OEB_PO_REQUISITION_LINES_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REQUISITION_LINE_ID BIGINT 8
2 REQUISITION_HEADER_ID BIGINT 8
3 LINE_NUM BIGINT 8
4 LINE_TYPE_ID BIGINT 8
5 CATEGORY_ID BIGINT 8
6 ITEM_DESCRIPTION CHARACTER VARYING(240) 240
7 UNIT_MEAS_LOOKUP_CODE CHARACTER VARYING(25) 25
8 UNIT_PRICE NUMERIC(18,2) 19
9 QUANTITY NUMERIC(18,2) 19
10 DELIVER_TO_LOCATION_ID BIGINT 8
11 TO_PERSON_ID BIGINT 8
12 LAST_UPDATE_DATE TIMESTAMP 8
13 LAST_UPDATED_BY BIGINT 8
14 SOURCE_TYPE_CODE CHARACTER VARYING(25) 25
15 LAST_UPDATE_LOGIN BIGINT 8
16 CREATION_DATE TIMESTAMP 8
17 CREATED_BY BIGINT 8
18 ITEM_ID BIGINT 8
19 ITEM_REVISION CHARACTER VARYING(3) 3
20 QUANTITY_DELIVERED NUMERIC(18,2) 19
21 SUGGESTED_BUYER_ID BIGINT 8
22 ENCUMBERED_FLAG CHARACTER VARYING(1) 1
23 RFQ_REQUIRED_FLAG CHARACTER VARYING(1) 1
24 NEED_BY_DATE TIMESTAMP 8
25 LINE_LOCATION_ID BIGINT 8
26 MODIFIED_BY_AGENT_FLAG CHARACTER VARYING(1) 1
27 PARENT_REQ_LINE_ID BIGINT 8
28 JUSTIFICATION CHARACTER VARYING(500) 500
29 NOTE_TO_AGENT CHARACTER VARYING(500) 500
30 NOTE_TO_RECEIVER CHARACTER VARYING(500) 500
31 PURCHASING_AGENT_ID BIGINT 8
32 DOCUMENT_TYPE_CODE CHARACTER VARYING(25) 25
33 BLANKET_PO_HEADER_ID BIGINT 8
34 BLANKET_PO_LINE_NUM BIGINT 8
35 CURRENCY_CODE CHARACTER VARYING(15) 15
36 RATE_TYPE CHARACTER VARYING(30) 30
37 RATE_DATE TIMESTAMP 8
38 RATE NUMERIC(18,2) 19
39 CURRENCY_UNIT_PRICE NUMERIC(18,2) 19
40 SUGGESTED_VENDOR_NAME CHARACTER VARYING(240) 240
41 SUGGESTED_VENDOR_LOCATION CHARACTER VARYING(240) 240
42 SUGGESTED_VENDOR_CONTACT CHARACTER VARYING(150) 150
43 SUGGESTED_VENDOR_PHONE CHARACTER VARYING(40) 40
44 SUGGESTED_VENDOR_PRODUCT_CODE CHARACTER VARYING(25) 25
45 UN_NUMBER_ID BIGINT 8
46 HAZARD_CLASS_ID BIGINT 8
47 MUST_USE_SUGG_VENDOR_FLAG CHARACTER VARYING(1) 1
48 REFERENCE_NUM CHARACTER VARYING(25) 25
49 ON_RFQ_FLAG CHARACTER VARYING(1) 1
50 URGENT_FLAG CHARACTER VARYING(1) 1
51 CANCEL_FLAG CHARACTER VARYING(1) 1
52 SOURCE_ORGANIZATION_ID BIGINT 8
53 SOURCE_SUBINVENTORY CHARACTER VARYING(10) 10
54 DESTINATION_TYPE_CODE CHARACTER VARYING(25) 25
55 DESTINATION_ORGANIZATION_ID BIGINT 8
56 DESTINATION_SUBINVENTORY CHARACTER VARYING(10) 10
57 QUANTITY_CANCELLED NUMERIC(18,2) 19
58 CANCEL_DATE TIMESTAMP 8
59 CANCEL_REASON CHARACTER VARYING(240) 240
60 CLOSED_CODE CHARACTER VARYING(25) 25
61 AGENT_RETURN_NOTE CHARACTER VARYING(480) 480
62 CHANGED_AFTER_RESEARCH_FLAG CHARACTER VARYING(1) 1
63 VENDOR_ID BIGINT 8
64 VENDOR_SITE_ID BIGINT 8
65 VENDOR_CONTACT_ID BIGINT 8
66 RESEARCH_AGENT_ID BIGINT 8
67 ON_LINE_FLAG CHARACTER VARYING(1) 1
68 WIP_ENTITY_ID BIGINT 8
69 WIP_LINE_ID BIGINT 8
70 WIP_REPETITIVE_SCHEDULE_ID BIGINT 8
71 WIP_OPERATION_SEQ_NUM BIGINT 8
72 WIP_RESOURCE_SEQ_NUM BIGINT 8
73 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
74 DESTINATION_CONTEXT CHARACTER VARYING(30) 30
75 INVENTORY_SOURCE_CONTEXT CHARACTER VARYING(30) 30
76 VENDOR_SOURCE_CONTEXT CHARACTER VARYING(30) 30
77 ATTRIBUTE1 CHARACTER VARYING(150) 150
78 ATTRIBUTE2 CHARACTER VARYING(150) 150
79 ATTRIBUTE3 CHARACTER VARYING(150) 150
80 ATTRIBUTE4 CHARACTER VARYING(150) 150
81 ATTRIBUTE5 CHARACTER VARYING(150) 150
82 ATTRIBUTE6 CHARACTER VARYING(150) 150
83 ATTRIBUTE7 CHARACTER VARYING(150) 150
84 ATTRIBUTE8 CHARACTER VARYING(150) 150
85 ATTRIBUTE9 CHARACTER VARYING(150) 150
86 ATTRIBUTE10 CHARACTER VARYING(150) 150
87 ATTRIBUTE11 CHARACTER VARYING(150) 150
88 ATTRIBUTE12 CHARACTER VARYING(150) 150
89 ATTRIBUTE13 CHARACTER VARYING(150) 150
90 ATTRIBUTE14 CHARACTER VARYING(150) 150
91 ATTRIBUTE15 CHARACTER VARYING(150) 150
92 BOM_RESOURCE_ID BIGINT 8
93 REQUEST_ID BIGINT 8
94 PROGRAM_APPLICATION_ID BIGINT 8
95 PROGRAM_ID BIGINT 8
96 PROGRAM_UPDATE_DATE TIMESTAMP 8
97 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
98 GOVERNMENT_CONTEXT CHARACTER VARYING(30) 30
99 CLOSED_REASON CHARACTER VARYING(240) 240
100 CLOSED_DATE TIMESTAMP 8
101 TRANSACTION_REASON_CODE CHARACTER VARYING(25) 25
102 QUANTITY_RECEIVED NUMERIC(18,2) 19
103 SOURCE_REQ_LINE_ID BIGINT 8
104 ORG_ID BIGINT 8
105 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
106 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
107 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
108 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
109 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
110 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
111 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
112 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
113 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
114 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
115 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
116 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
117 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
118 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
119 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
120 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
121 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
122 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
123 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
124 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
125 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
126 KANBAN_CARD_ID BIGINT 8
127 CATALOG_TYPE CHARACTER VARYING(30) 30
128 CATALOG_SOURCE CHARACTER VARYING(30) 30
129 MANUFACTURER_ID BIGINT 8
130 MANUFACTURER_NAME CHARACTER VARYING(240) 240
131 MANUFACTURER_PART_NUMBER CHARACTER VARYING(150) 150
132 REQUESTER_EMAIL CHARACTER VARYING(240) 240
133 REQUESTER_FAX CHARACTER VARYING(60) 60
134 REQUESTER_PHONE CHARACTER VARYING(60) 60
135 UNSPSC_CODE CHARACTER VARYING(30) 30
136 OTHER_CATEGORY_CODE CHARACTER VARYING(30) 30
137 SUPPLIER_DUNS CHARACTER VARYING(60) 60
138 TAX_STATUS_INDICATOR CHARACTER VARYING(30) 30
139 PCARD_FLAG CHARACTER VARYING(1) 1
140 NEW_SUPPLIER_FLAG CHARACTER VARYING(1) 1
141 AUTO_RECEIVE_FLAG CHARACTER VARYING(1) 1
142 TAX_USER_OVERRIDE_FLAG CHARACTER VARYING(1) 1
143 TAX_CODE_ID BIGINT 8
144 NOTE_TO_VENDOR CHARACTER VARYING(480) 480
145 OKE_CONTRACT_VERSION_ID BIGINT 8
146 OKE_CONTRACT_HEADER_ID BIGINT 8
147 ITEM_SOURCE_ID BIGINT 8
148 SUPPLIER_REF_NUMBER CHARACTER VARYING(150) 150
149 SECONDARY_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
150 SECONDARY_QUANTITY NUMERIC(18,2) 19
151 PREFERRED_GRADE CHARACTER VARYING(150) 150
152 SECONDARY_QUANTITY_RECEIVED NUMERIC(18,2) 19
153 SECONDARY_QUANTITY_CANCELLED NUMERIC(18,2) 19
154 VMI_FLAG CHARACTER VARYING(1) 1
155 AUCTION_HEADER_ID BIGINT 8
156 AUCTION_DISPLAY_NUMBER CHARACTER VARYING(40) 40
157 AUCTION_LINE_NUMBER NUMERIC(18,2) 19
158 REQS_IN_POOL_FLAG CHARACTER VARYING(1) 1
159 BID_NUMBER BIGINT 8
160 BID_LINE_NUMBER BIGINT 8
161 NONCAT_TEMPLATE_ID BIGINT 8
162 SUGGESTED_VENDOR_CONTACT_FAX CHARACTER VARYING(40) 40
163 SUGGESTED_VENDOR_CONTACT_EMAIL CHARACTER VARYING(2000) 2000
164 AMOUNT NUMERIC(18,2) 19
165 CURRENCY_AMOUNT NUMERIC(18,2) 19
166 LABOR_REQ_LINE_ID BIGINT 8
167 JOB_ID BIGINT 8
168 JOB_LONG_DESCRIPTION CHARACTER VARYING(2000) 2000
169 CONTRACTOR_STATUS CHARACTER VARYING(25) 25
170 CONTACT_INFORMATION CHARACTER VARYING(240) 240
171 SUGGESTED_SUPPLIER_FLAG CHARACTER VARYING(1) 1
172 CANDIDATE_SCREENING_REQD_FLAG CHARACTER VARYING(1) 1
173 CANDIDATE_FIRST_NAME CHARACTER VARYING(240) 240
174 CANDIDATE_LAST_NAME CHARACTER VARYING(240) 240
175 ASSIGNMENT_END_DATE TIMESTAMP 8
176 OVERTIME_ALLOWED_FLAG CHARACTER VARYING(1) 1
177 CONTRACTOR_REQUISITION_FLAG CHARACTER VARYING(1) 1
178 DROP_SHIP_FLAG CHARACTER VARYING(1) 1
179 ASSIGNMENT_START_DATE TIMESTAMP 8
180 ORDER_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
181 PURCHASE_BASIS CHARACTER VARYING(30) 30
182 MATCHING_BASIS CHARACTER VARYING(30) 30
183 NEGOTIATED_BY_PREPARER_FLAG CHARACTER VARYING(1) 1
184 SHIP_METHOD CHARACTER VARYING(30) 30
185 ESTIMATED_PICKUP_DATE TIMESTAMP 8
186 SUPPLIER_NOTIFIED_FOR_CANCEL CHARACTER VARYING(1) 1
187 BASE_UNIT_PRICE NUMERIC(18,2) 19
188 AT_SOURCING_FLAG CHARACTER VARYING(1) 1
189 TAX_ATTRIBUTE_UPDATE_CODE CHARACTER VARYING(15) 15
190 TAX_NAME CHARACTER VARYING(30) 30
191 TRANSFERRED_TO_OE_FLAG CHARACTER VARYING(1) 1
192 CONFORMED_LINE_ID BIGINT 8
193 AMENDMENT_TYPE CHARACTER VARYING(30) 30
194 AMENDMENT_STATUS CHARACTER VARYING(3) 3
195 LINE_NUM_DISPLAY CHARACTER VARYING(100) 100
196 GROUP_LINE_ID BIGINT 8
197 CLM_INFO_FLAG CHARACTER VARYING(1) 1
198 CLM_OPTION_INDICATOR CHARACTER VARYING(1) 1
199 CLM_BASE_LINE_NUM BIGINT 8
200 CLM_OPTION_NUM BIGINT 8
201 CLM_OPTION_FROM_DATE TIMESTAMP 8
202 CLM_OPTION_TO_DATE TIMESTAMP 8
203 CLM_FUNDED_FLAG CHARACTER VARYING(1) 1
204 UDA_TEMPLATE_ID BIGINT 8
205 CONTRACT_TYPE CHARACTER VARYING(100) 100
206 COST_CONSTRAINT CHARACTER VARYING(100) 100
207 AMENDMENT_RESPONSE_REASON CHARACTER VARYING(2000) 2000
208 CLM_PERIOD_PERF_START_DATE TIMESTAMP 8
209 CLM_PERIOD_PERF_END_DATE TIMESTAMP 8
210 CLM_EXTENDED_ITEM_DESCRIPTION CHARACTER VARYING(4000) 4000
211 CLM_OPTION_EXERCISED CHARACTER VARYING(1) 1
212 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
213 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
214 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
215 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8