OEB_PO_REQUISITION_HEADERS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REQUISITION_HEADER_ID BIGINT 8
2 PREPARER_ID BIGINT 8
3 LAST_UPDATE_DATE TIMESTAMP 8
4 LAST_UPDATED_BY BIGINT 8
5 SEGMENT1 CHARACTER VARYING(20) 20
6 SUMMARY_FLAG CHARACTER VARYING(1) 1
7 ENABLED_FLAG CHARACTER VARYING(1) 1
8 SEGMENT2 CHARACTER VARYING(20) 20
9 SEGMENT3 CHARACTER VARYING(20) 20
10 SEGMENT4 CHARACTER VARYING(20) 20
11 SEGMENT5 CHARACTER VARYING(20) 20
12 START_DATE_ACTIVE TIMESTAMP 8
13 END_DATE_ACTIVE TIMESTAMP 8
14 LAST_UPDATE_LOGIN BIGINT 8
15 CREATION_DATE TIMESTAMP 8
16 CREATED_BY BIGINT 8
17 DESCRIPTION CHARACTER VARYING(240) 240
18 AUTHORIZATION_STATUS CHARACTER VARYING(25) 25
19 NOTE_TO_AUTHORIZER CHARACTER VARYING(4000) 4000
20 TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
21 TRANSFERRED_TO_OE_FLAG CHARACTER VARYING(1) 1
22 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
23 ATTRIBUTE1 CHARACTER VARYING(150) 150
24 ATTRIBUTE2 CHARACTER VARYING(150) 150
25 ATTRIBUTE3 CHARACTER VARYING(150) 150
26 ATTRIBUTE4 CHARACTER VARYING(150) 150
27 ATTRIBUTE5 CHARACTER VARYING(150) 150
28 ON_LINE_FLAG CHARACTER VARYING(1) 1
29 PRELIMINARY_RESEARCH_FLAG CHARACTER VARYING(1) 1
30 RESEARCH_COMPLETE_FLAG CHARACTER VARYING(1) 1
31 PREPARER_FINISHED_FLAG CHARACTER VARYING(1) 1
32 PREPARER_FINISHED_DATE TIMESTAMP 8
33 AGENT_RETURN_FLAG CHARACTER VARYING(1) 1
34 AGENT_RETURN_NOTE CHARACTER VARYING(240) 240
35 CANCEL_FLAG CHARACTER VARYING(1) 1
36 ATTRIBUTE6 CHARACTER VARYING(150) 150
37 ATTRIBUTE7 CHARACTER VARYING(150) 150
38 ATTRIBUTE8 CHARACTER VARYING(150) 150
39 ATTRIBUTE9 CHARACTER VARYING(150) 150
40 ATTRIBUTE10 CHARACTER VARYING(150) 150
41 ATTRIBUTE11 CHARACTER VARYING(150) 150
42 ATTRIBUTE12 CHARACTER VARYING(150) 150
43 ATTRIBUTE13 CHARACTER VARYING(150) 150
44 ATTRIBUTE14 CHARACTER VARYING(150) 150
45 ATTRIBUTE15 CHARACTER VARYING(150) 150
46 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
47 GOVERNMENT_CONTEXT CHARACTER VARYING(30) 30
48 REQUEST_ID BIGINT 8
49 PROGRAM_APPLICATION_ID BIGINT 8
50 PROGRAM_ID BIGINT 8
51 PROGRAM_UPDATE_DATE TIMESTAMP 8
52 INTERFACE_SOURCE_CODE CHARACTER VARYING(25) 25
53 INTERFACE_SOURCE_LINE_ID BIGINT 8
54 CLOSED_CODE CHARACTER VARYING(25) 25
55 ORG_ID BIGINT 8
56 WF_ITEM_TYPE CHARACTER VARYING(8) 8
57 WF_ITEM_KEY CHARACTER VARYING(240) 240
58 EMERGENCY_PO_NUM CHARACTER VARYING(20) 20
59 PCARD_ID BIGINT 8
60 APPS_SOURCE_CODE CHARACTER VARYING(25) 25
61 CBC_ACCOUNTING_DATE TIMESTAMP 8
62 CHANGE_PENDING_FLAG CHARACTER VARYING(1) 1
63 ACTIVE_SHOPPING_CART_FLAG CHARACTER VARYING(1) 1
64 CONTRACTOR_STATUS CHARACTER VARYING(25) 25
65 CONTRACTOR_REQUISITION_FLAG CHARACTER VARYING(1) 1
66 SUPPLIER_NOTIFIED_FLAG CHARACTER VARYING(1) 1
67 EMERGENCY_PO_ORG_ID BIGINT 8
68 APPROVED_DATE TIMESTAMP 8
69 TAX_ATTRIBUTE_UPDATE_CODE CHARACTER VARYING(15) 15
70 FIRST_APPROVER_ID BIGINT 8
71 FIRST_POSITION_ID BIGINT 8
72 FEDERAL_FLAG CHARACTER VARYING(1) 1
73 CONFORMED_HEADER_ID BIGINT 8
74 REVISION_NUM BIGINT 8
75 AMENDMENT_TYPE CHARACTER VARYING(30) 30
76 AMENDMENT_STATUS CHARACTER VARYING(3) 3
77 AMENDMENT_REASON CHARACTER VARYING(4000) 4000
78 UDA_TEMPLATE_ID BIGINT 8
79 UDA_TEMPLATE_DATE TIMESTAMP 8
80 CLM_ISSUING_OFFICE CHARACTER VARYING(1000) 1000
81 CLM_COTR_OFFICE CHARACTER VARYING(1000) 1000
82 CLM_COTR_CONTACT CHARACTER VARYING(400) 400
83 CLM_PRIORITY_CODE CHARACTER VARYING(400) 400
84 SUGGESTED_AWARD_NO CHARACTER VARYING(240) 240
85 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
86 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
87 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
88 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8