OEB_PO_HEADERS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PO_HEADER_ID BIGINT 8
2 AGENT_ID BIGINT 8
3 TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
4 LAST_UPDATE_DATE TIMESTAMP 8
5 LAST_UPDATED_BY BIGINT 8
6 SEGMENT1 CHARACTER VARYING(20) 20
7 SUMMARY_FLAG CHARACTER VARYING(1) 1
8 ENABLED_FLAG CHARACTER VARYING(1) 1
9 SEGMENT2 CHARACTER VARYING(20) 20
10 SEGMENT3 CHARACTER VARYING(20) 20
11 SEGMENT4 CHARACTER VARYING(20) 20
12 SEGMENT5 CHARACTER VARYING(20) 20
13 START_DATE_ACTIVE TIMESTAMP 8
14 END_DATE_ACTIVE TIMESTAMP 8
15 LAST_UPDATE_LOGIN BIGINT 8
16 CREATION_DATE TIMESTAMP 8
17 CREATED_BY BIGINT 8
18 VENDOR_ID BIGINT 8
19 VENDOR_SITE_ID BIGINT 8
20 VENDOR_CONTACT_ID BIGINT 8
21 SHIP_TO_LOCATION_ID BIGINT 8
22 BILL_TO_LOCATION_ID BIGINT 8
23 TERMS_ID BIGINT 8
24 SHIP_VIA_LOOKUP_CODE CHARACTER VARYING(25) 25
25 FOB_LOOKUP_CODE CHARACTER VARYING(25) 25
26 FREIGHT_TERMS_LOOKUP_CODE CHARACTER VARYING(25) 25
27 STATUS_LOOKUP_CODE CHARACTER VARYING(25) 25
28 CURRENCY_CODE CHARACTER VARYING(15) 15
29 RATE_TYPE CHARACTER VARYING(30) 30
30 RATE_DATE TIMESTAMP 8
31 RATE NUMERIC(18,2) 19
32 FROM_HEADER_ID BIGINT 8
33 FROM_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
34 START_DATE TIMESTAMP 8
35 END_DATE TIMESTAMP 8
36 BLANKET_TOTAL_AMOUNT NUMERIC(18,2) 19
37 AUTHORIZATION_STATUS CHARACTER VARYING(25) 25
38 REVISION_NUM NUMERIC(18,2) 19
39 REVISED_DATE TIMESTAMP 8
40 APPROVED_FLAG CHARACTER VARYING(1) 1
41 APPROVED_DATE TIMESTAMP 8
42 AMOUNT_LIMIT NUMERIC(18,2) 19
43 MIN_RELEASE_AMOUNT NUMERIC(18,2) 19
44 NOTE_TO_AUTHORIZER CHARACTER VARYING(240) 240
45 NOTE_TO_VENDOR CHARACTER VARYING(480) 480
46 NOTE_TO_RECEIVER CHARACTER VARYING(480) 480
47 PRINT_COUNT NUMERIC(18,2) 19
48 PRINTED_DATE TIMESTAMP 8
49 VENDOR_ORDER_NUM CHARACTER VARYING(25) 25
50 CONFIRMING_ORDER_FLAG CHARACTER VARYING(1) 1
51 COMMENTS CHARACTER VARYING(240) 240
52 REPLY_DATE TIMESTAMP 8
53 REPLY_METHOD_LOOKUP_CODE CHARACTER VARYING(25) 25
54 RFQ_CLOSE_DATE TIMESTAMP 8
55 QUOTE_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
56 QUOTATION_CLASS_CODE CHARACTER VARYING(25) 25
57 QUOTE_WARNING_DELAY_UNIT CHARACTER VARYING(25) 25
58 QUOTE_WARNING_DELAY NUMERIC(18,2) 19
59 QUOTE_VENDOR_QUOTE_NUMBER CHARACTER VARYING(25) 25
60 ACCEPTANCE_REQUIRED_FLAG CHARACTER VARYING(1) 1
61 ACCEPTANCE_DUE_DATE TIMESTAMP 8
62 CLOSED_DATE TIMESTAMP 8
63 USER_HOLD_FLAG CHARACTER VARYING(1) 1
64 APPROVAL_REQUIRED_FLAG CHARACTER VARYING(1) 1
65 CANCEL_FLAG CHARACTER VARYING(1) 1
66 FIRM_STATUS_LOOKUP_CODE CHARACTER VARYING(30) 30
67 FIRM_DATE TIMESTAMP 8
68 FROZEN_FLAG CHARACTER VARYING(1) 1
69 SUPPLY_AGREEMENT_FLAG CHARACTER VARYING(1) 1
70 EDI_PROCESSED_FLAG CHARACTER VARYING(1) 1
71 EDI_PROCESSED_STATUS CHARACTER VARYING(10) 10
72 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
73 ATTRIBUTE1 CHARACTER VARYING(150) 150
74 ATTRIBUTE2 CHARACTER VARYING(150) 150
75 ATTRIBUTE3 CHARACTER VARYING(150) 150
76 ATTRIBUTE4 CHARACTER VARYING(150) 150
77 ATTRIBUTE5 CHARACTER VARYING(150) 150
78 ATTRIBUTE6 CHARACTER VARYING(150) 150
79 ATTRIBUTE7 CHARACTER VARYING(150) 150
80 ATTRIBUTE8 CHARACTER VARYING(150) 150
81 ATTRIBUTE9 CHARACTER VARYING(150) 150
82 ATTRIBUTE10 CHARACTER VARYING(150) 150
83 ATTRIBUTE11 CHARACTER VARYING(150) 150
84 ATTRIBUTE12 CHARACTER VARYING(150) 150
85 ATTRIBUTE13 CHARACTER VARYING(150) 150
86 ATTRIBUTE14 CHARACTER VARYING(150) 150
87 ATTRIBUTE15 CHARACTER VARYING(150) 150
88 CLOSED_CODE CHARACTER VARYING(25) 25
89 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
90 GOVERNMENT_CONTEXT CHARACTER VARYING(30) 30
91 REQUEST_ID BIGINT 8
92 PROGRAM_APPLICATION_ID BIGINT 8
93 PROGRAM_ID BIGINT 8
94 PROGRAM_UPDATE_DATE TIMESTAMP 8
95 ORG_ID BIGINT 8
96 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
97 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
98 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
99 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
100 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
101 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
102 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
103 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
104 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
105 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
106 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
107 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
108 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
109 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
110 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
111 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
112 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
113 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
114 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
115 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
116 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
117 INTERFACE_SOURCE_CODE CHARACTER VARYING(25) 25
118 REFERENCE_NUM CHARACTER VARYING(25) 25
119 WF_ITEM_TYPE CHARACTER VARYING(8) 8
120 WF_ITEM_KEY CHARACTER VARYING(240) 240
121 MRC_RATE_TYPE CHARACTER VARYING(1000) 1000
122 MRC_RATE_DATE CHARACTER VARYING(1000) 1000
123 MRC_RATE CHARACTER VARYING(1000) 1000
124 PCARD_ID BIGINT 8
125 PRICE_UPDATE_TOLERANCE NUMERIC(18,2) 19
126 PAY_ON_CODE CHARACTER VARYING(25) 25
127 XML_FLAG CHARACTER VARYING(3) 3
128 XML_SEND_DATE TIMESTAMP 8
129 XML_CHANGE_SEND_DATE TIMESTAMP 8
130 GLOBAL_AGREEMENT_FLAG CHARACTER VARYING(1) 1
131 CONSIGNED_CONSUMPTION_FLAG CHARACTER VARYING(1) 1
132 CBC_ACCOUNTING_DATE TIMESTAMP 8
133 CONSUME_REQ_DEMAND_FLAG CHARACTER VARYING(1) 1
134 CHANGE_REQUESTED_BY CHARACTER VARYING(20) 20
135 SHIPPING_CONTROL CHARACTER VARYING(30) 30
136 CONTERMS_EXIST_FLAG CHARACTER VARYING(1) 1
137 CONTERMS_ARTICLES_UPD_DATE TIMESTAMP 8
138 CONTERMS_DELIV_UPD_DATE TIMESTAMP 8
139 ENCUMBRANCE_REQUIRED_FLAG CHARACTER VARYING(1) 1
140 PENDING_SIGNATURE_FLAG CHARACTER VARYING(1) 1
141 CHANGE_SUMMARY CHARACTER VARYING(1000) 1000
142 DOCUMENT_CREATION_METHOD CHARACTER VARYING(30) 30
143 SUBMIT_DATE TIMESTAMP 8
144 CREATED_LANGUAGE CHARACTER VARYING(4) 4
145 CPA_REFERENCE NUMERIC(18,2) 19
146 LAST_UPDATED_PROGRAM CHARACTER VARYING(255) 255
147 SUPPLIER_NOTIF_METHOD CHARACTER VARYING(25) 25
148 FAX CHARACTER VARYING(30) 30
149 EMAIL_ADDRESS CHARACTER VARYING(1000) 1000
150 RETRO_PRICE_COMM_UPDATES_FLAG CHARACTER VARYING(1) 1
151 RETRO_PRICE_APPLY_UPDATES_FLAG CHARACTER VARYING(1) 1
152 UPDATE_SOURCING_RULES_FLAG CHARACTER VARYING(1) 1
153 AUTO_SOURCING_FLAG CHARACTER VARYING(1) 1
154 LOCK_OWNER_ROLE CHARACTER VARYING(10) 10
155 LOCK_OWNER_USER_ID BIGINT 8
156 SUPPLIER_AUTH_ENABLED_FLAG CHARACTER VARYING(1) 1
157 CAT_ADMIN_AUTH_ENABLED_FLAG CHARACTER VARYING(1) 1
158 STYLE_ID BIGINT 8
159 TAX_ATTRIBUTE_UPDATE_CODE CHARACTER VARYING(15) 15
160 ENABLE_ALL_SITES CHARACTER VARYING(1) 1
161 PAY_WHEN_PAID CHARACTER VARYING(1) 1
162 COMM_REV_NUM NUMERIC(18,2) 19
163 CLM_DOCUMENT_NUMBER CHARACTER VARYING(50) 50
164 OTM_STATUS_CODE CHARACTER VARYING(80) 80
165 OTM_RECOVERY_FLAG CHARACTER VARYING(1) 1
166 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
167 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
168 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
169 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8