OEB_PO_LINE_LOCATIONS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LINE_LOCATION_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 PO_HEADER_ID BIGINT 8
5 PO_LINE_ID BIGINT 8
6 LAST_UPDATE_LOGIN BIGINT 8
7 CREATION_DATE TIMESTAMP 8
8 CREATED_BY BIGINT 8
9 QUANTITY NUMERIC(18,2) 19
10 QUANTITY_RECEIVED NUMERIC(18,2) 19
11 QUANTITY_ACCEPTED NUMERIC(18,2) 19
12 QUANTITY_REJECTED NUMERIC(18,2) 19
13 QUANTITY_BILLED NUMERIC(18,2) 19
14 QUANTITY_CANCELLED NUMERIC(18,2) 19
15 UNIT_MEAS_LOOKUP_CODE CHARACTER VARYING(25) 25
16 PO_RELEASE_ID BIGINT 8
17 SHIP_TO_LOCATION_ID BIGINT 8
18 SHIP_VIA_LOOKUP_CODE CHARACTER VARYING(25) 25
19 NEED_BY_DATE TIMESTAMP 8
20 PROMISED_DATE TIMESTAMP 8
21 LAST_ACCEPT_DATE TIMESTAMP 8
22 PRICE_OVERRIDE NUMERIC(18,2) 19
23 ENCUMBERED_FLAG CHARACTER VARYING(1) 1
24 ENCUMBERED_DATE TIMESTAMP 8
25 UNENCUMBERED_QUANTITY NUMERIC(18,2) 19
26 FOB_LOOKUP_CODE CHARACTER VARYING(25) 25
27 FREIGHT_TERMS_LOOKUP_CODE CHARACTER VARYING(25) 25
28 TAXABLE_FLAG CHARACTER VARYING(1) 1
29 TAX_NAME CHARACTER VARYING(30) 30
30 ESTIMATED_TAX_AMOUNT NUMERIC(18,2) 19
31 FROM_HEADER_ID BIGINT 8
32 FROM_LINE_ID BIGINT 8
33 FROM_LINE_LOCATION_ID BIGINT 8
34 START_DATE TIMESTAMP 8
35 END_DATE TIMESTAMP 8
36 LEAD_TIME NUMERIC(18,2) 19
37 LEAD_TIME_UNIT CHARACTER VARYING(25) 25
38 PRICE_DISCOUNT NUMERIC(18,2) 19
39 TERMS_ID BIGINT 8
40 APPROVED_FLAG CHARACTER VARYING(1) 1
41 APPROVED_DATE TIMESTAMP 8
42 CLOSED_FLAG CHARACTER VARYING(1) 1
43 CANCEL_FLAG CHARACTER VARYING(1) 1
44 CANCELLED_BY BIGINT 8
45 CANCEL_DATE TIMESTAMP 8
46 CANCEL_REASON CHARACTER VARYING(240) 240
47 FIRM_STATUS_LOOKUP_CODE CHARACTER VARYING(25) 25
48 FIRM_DATE TIMESTAMP 8
49 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
50 ATTRIBUTE1 CHARACTER VARYING(150) 150
51 ATTRIBUTE2 CHARACTER VARYING(150) 150
52 ATTRIBUTE3 CHARACTER VARYING(150) 150
53 ATTRIBUTE4 CHARACTER VARYING(150) 150
54 ATTRIBUTE5 CHARACTER VARYING(150) 150
55 ATTRIBUTE6 CHARACTER VARYING(150) 150
56 ATTRIBUTE7 CHARACTER VARYING(150) 150
57 ATTRIBUTE8 CHARACTER VARYING(150) 150
58 ATTRIBUTE9 CHARACTER VARYING(150) 150
59 ATTRIBUTE10 CHARACTER VARYING(150) 150
60 UNIT_OF_MEASURE_CLASS CHARACTER VARYING(25) 25
61 ENCUMBER_NOW CHARACTER VARYING(1) 1
62 ATTRIBUTE11 CHARACTER VARYING(150) 150
63 ATTRIBUTE12 CHARACTER VARYING(150) 150
64 ATTRIBUTE13 CHARACTER VARYING(150) 150
65 ATTRIBUTE14 CHARACTER VARYING(150) 150
66 ATTRIBUTE15 CHARACTER VARYING(150) 150
67 INSPECTION_REQUIRED_FLAG CHARACTER VARYING(1) 1
68 RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
69 QTY_RCV_TOLERANCE NUMERIC(18,2) 19
70 QTY_RCV_EXCEPTION_CODE CHARACTER VARYING(25) 25
71 ENFORCE_SHIP_TO_LOCATION_CODE CHARACTER VARYING(25) 25
72 ALLOW_SUBSTITUTE_RECEIPTS_FLAG CHARACTER VARYING(1) 1
73 DAYS_EARLY_RECEIPT_ALLOWED NUMERIC(18,2) 19
74 DAYS_LATE_RECEIPT_ALLOWED NUMERIC(18,2) 19
75 RECEIPT_DAYS_EXCEPTION_CODE CHARACTER VARYING(25) 25
76 INVOICE_CLOSE_TOLERANCE NUMERIC(18,2) 19
77 RECEIVE_CLOSE_TOLERANCE NUMERIC(18,2) 19
78 SHIP_TO_ORGANIZATION_ID BIGINT 8
79 SHIPMENT_NUM NUMERIC(18,2) 19
80 SOURCE_SHIPMENT_ID BIGINT 8
81 SHIPMENT_TYPE CHARACTER VARYING(25) 25
82 CLOSED_CODE CHARACTER VARYING(30) 30
83 REQUEST_ID BIGINT 8
84 PROGRAM_APPLICATION_ID BIGINT 8
85 PROGRAM_ID BIGINT 8
86 PROGRAM_UPDATE_DATE TIMESTAMP 8
87 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
88 GOVERNMENT_CONTEXT CHARACTER VARYING(30) 30
89 RECEIVING_ROUTING_ID BIGINT 8
90 ACCRUE_ON_RECEIPT_FLAG CHARACTER VARYING(1) 1
91 CLOSED_REASON CHARACTER VARYING(240) 240
92 CLOSED_DATE TIMESTAMP 8
93 CLOSED_BY BIGINT 8
94 ORG_ID BIGINT 8
95 QUANTITY_SHIPPED NUMERIC(18,2) 19
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 COUNTRY_OF_ORIGIN_CODE CHARACTER VARYING(2) 2
118 TAX_USER_OVERRIDE_FLAG CHARACTER VARYING(1) 1
119 MATCH_OPTION CHARACTER VARYING(25) 25
120 TAX_CODE_ID BIGINT 8
121 CALCULATE_TAX_FLAG CHARACTER VARYING(1) 1
122 CHANGE_PROMISED_DATE_REASON CHARACTER VARYING(240) 240
123 NOTE_TO_RECEIVER CHARACTER VARYING(480) 480
124 SECONDARY_QUANTITY NUMERIC(18,2) 19
125 SECONDARY_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
126 PREFERRED_GRADE CHARACTER VARYING(150) 150
127 SECONDARY_QUANTITY_RECEIVED NUMERIC(18,2) 19
128 SECONDARY_QUANTITY_ACCEPTED NUMERIC(18,2) 19
129 SECONDARY_QUANTITY_REJECTED NUMERIC(18,2) 19
130 SECONDARY_QUANTITY_CANCELLED NUMERIC(18,2) 19
131 VMI_FLAG CHARACTER VARYING(1) 1
132 CONSIGNED_FLAG CHARACTER VARYING(1) 1
133 RETROACTIVE_DATE TIMESTAMP 8
134 SUPPLIER_ORDER_LINE_NUMBER CHARACTER VARYING(25) 25
135 AMOUNT NUMERIC(18,2) 19
136 AMOUNT_RECEIVED NUMERIC(18,2) 19
137 AMOUNT_BILLED NUMERIC(18,2) 19
138 AMOUNT_CANCELLED NUMERIC(18,2) 19
139 AMOUNT_REJECTED NUMERIC(18,2) 19
140 AMOUNT_ACCEPTED NUMERIC(18,2) 19
141 DROP_SHIP_FLAG CHARACTER VARYING(1) 1
142 SALES_ORDER_UPDATE_DATE TIMESTAMP 8
143 TRANSACTION_FLOW_HEADER_ID BIGINT 8
144 FINAL_MATCH_FLAG CHARACTER VARYING(1) 1
145 MANUAL_PRICE_CHANGE_FLAG CHARACTER VARYING(1) 1
146 SHIPMENT_CLOSED_DATE TIMESTAMP 8
147 CLOSED_FOR_RECEIVING_DATE TIMESTAMP 8
148 CLOSED_FOR_INVOICE_DATE TIMESTAMP 8
149 SECONDARY_QUANTITY_SHIPPED NUMERIC(18,2) 19
150 VALUE_BASIS CHARACTER VARYING(25) 25
151 MATCHING_BASIS CHARACTER VARYING(30) 30
152 PAYMENT_TYPE CHARACTER VARYING(30) 30
153 DESCRIPTION CHARACTER VARYING(240) 240
154 WORK_APPROVER_ID BIGINT 8
155 BID_PAYMENT_ID BIGINT 8
156 QUANTITY_FINANCED NUMERIC(18,2) 19
157 AMOUNT_FINANCED NUMERIC(18,2) 19
158 QUANTITY_RECOUPED NUMERIC(18,2) 19
159 AMOUNT_RECOUPED NUMERIC(18,2) 19
160 RETAINAGE_WITHHELD_AMOUNT NUMERIC(18,2) 19
161 RETAINAGE_RELEASED_AMOUNT NUMERIC(18,2) 19
162 AMOUNT_SHIPPED NUMERIC(18,2) 19
163 OUTSOURCED_ASSEMBLY NUMERIC(18,2) 19
164 TAX_ATTRIBUTE_UPDATE_CODE CHARACTER VARYING(15) 15
165 ORIGINAL_SHIPMENT_ID BIGINT 8
166 LCM_FLAG CHARACTER VARYING(1) 1
167 UDA_TEMPLATE_ID BIGINT 8
168 DRAFT_ID BIGINT 8
169 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
170 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
171 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
172 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8