OEB_PO_LINES_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PO_LINE_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 PO_HEADER_ID BIGINT 8
5 LINE_TYPE_ID BIGINT 8
6 LINE_NUM NUMERIC(18,2) 19
7 LAST_UPDATE_LOGIN BIGINT 8
8 CREATION_DATE TIMESTAMP 8
9 CREATED_BY BIGINT 8
10 ITEM_ID BIGINT 8
11 ITEM_REVISION CHARACTER VARYING(3) 3
12 CATEGORY_ID BIGINT 8
13 ITEM_DESCRIPTION CHARACTER VARYING(240) 240
14 UNIT_MEAS_LOOKUP_CODE CHARACTER VARYING(25) 25
15 QUANTITY_COMMITTED NUMERIC(18,2) 19
16 COMMITTED_AMOUNT NUMERIC(18,2) 19
17 ALLOW_PRICE_OVERRIDE_FLAG CHARACTER VARYING(1) 1
18 NOT_TO_EXCEED_PRICE NUMERIC(18,2) 19
19 LIST_PRICE_PER_UNIT NUMERIC(18,2) 19
20 UNIT_PRICE NUMERIC(18,2) 19
21 QUANTITY NUMERIC(18,2) 19
22 UN_NUMBER_ID BIGINT 8
23 HAZARD_CLASS_ID BIGINT 8
24 NOTE_TO_VENDOR CHARACTER VARYING(480) 480
25 FROM_HEADER_ID BIGINT 8
26 FROM_LINE_ID BIGINT 8
27 MIN_ORDER_QUANTITY NUMERIC(18,2) 19
28 MAX_ORDER_QUANTITY NUMERIC(18,2) 19
29 QTY_RCV_TOLERANCE NUMERIC(18,2) 19
30 OVER_TOLERANCE_ERROR_FLAG CHARACTER VARYING(25) 25
31 MARKET_PRICE NUMERIC(18,2) 19
32 UNORDERED_FLAG CHARACTER VARYING(1) 1
33 CLOSED_FLAG CHARACTER VARYING(1) 1
34 USER_HOLD_FLAG CHARACTER VARYING(1) 1
35 CANCEL_FLAG CHARACTER VARYING(1) 1
36 CANCELLED_BY BIGINT 8
37 CANCEL_DATE TIMESTAMP 8
38 CANCEL_REASON CHARACTER VARYING(240) 240
39 FIRM_STATUS_LOOKUP_CODE CHARACTER VARYING(30) 30
40 FIRM_DATE TIMESTAMP 8
41 VENDOR_PRODUCT_NUM CHARACTER VARYING(25) 25
42 CONTRACT_NUM CHARACTER VARYING(25) 25
43 TAXABLE_FLAG CHARACTER VARYING(1) 1
44 TAX_NAME CHARACTER VARYING(30) 30
45 TYPE_1099 CHARACTER VARYING(10) 10
46 CAPITAL_EXPENSE_FLAG CHARACTER VARYING(1) 1
47 NEGOTIATED_BY_PREPARER_FLAG CHARACTER VARYING(1) 1
48 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
49 ATTRIBUTE1 CHARACTER VARYING(150) 150
50 ATTRIBUTE2 CHARACTER VARYING(150) 150
51 ATTRIBUTE3 CHARACTER VARYING(150) 150
52 ATTRIBUTE4 CHARACTER VARYING(150) 150
53 ATTRIBUTE5 CHARACTER VARYING(150) 150
54 ATTRIBUTE6 CHARACTER VARYING(150) 150
55 ATTRIBUTE7 CHARACTER VARYING(150) 150
56 ATTRIBUTE8 CHARACTER VARYING(150) 150
57 ATTRIBUTE9 CHARACTER VARYING(150) 150
58 ATTRIBUTE10 CHARACTER VARYING(150) 150
59 REFERENCE_NUM CHARACTER VARYING(25) 25
60 ATTRIBUTE11 CHARACTER VARYING(150) 150
61 ATTRIBUTE12 CHARACTER VARYING(150) 150
62 ATTRIBUTE13 CHARACTER VARYING(150) 150
63 ATTRIBUTE14 CHARACTER VARYING(150) 150
64 ATTRIBUTE15 CHARACTER VARYING(150) 150
65 MIN_RELEASE_AMOUNT NUMERIC(18,2) 19
66 PRICE_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
67 CLOSED_CODE CHARACTER VARYING(25) 25
68 PRICE_BREAK_LOOKUP_CODE CHARACTER VARYING(25) 25
69 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
70 GOVERNMENT_CONTEXT CHARACTER VARYING(30) 30
71 REQUEST_ID BIGINT 8
72 PROGRAM_APPLICATION_ID BIGINT 8
73 PROGRAM_ID BIGINT 8
74 PROGRAM_UPDATE_DATE TIMESTAMP 8
75 CLOSED_DATE TIMESTAMP 8
76 CLOSED_REASON CHARACTER VARYING(240) 240
77 CLOSED_BY BIGINT 8
78 TRANSACTION_REASON_CODE CHARACTER VARYING(25) 25
79 ORG_ID BIGINT 8
80 QC_GRADE CHARACTER VARYING(25) 25
81 BASE_UOM CHARACTER VARYING(25) 25
82 BASE_QTY NUMERIC(18,2) 19
83 SECONDARY_UOM CHARACTER VARYING(25) 25
84 SECONDARY_QTY NUMERIC(18,2) 19
85 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
86 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
87 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
88 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
89 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
90 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
91 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
92 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
93 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
94 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
95 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
96 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
97 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
98 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
99 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
100 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
101 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
102 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
103 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
104 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
105 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
106 LINE_REFERENCE_NUM CHARACTER VARYING(25) 25
107 PROJECT_ID BIGINT 8
108 TASK_ID BIGINT 8
109 EXPIRATION_DATE TIMESTAMP 8
110 TAX_CODE_ID BIGINT 8
111 OKE_CONTRACT_HEADER_ID BIGINT 8
112 OKE_CONTRACT_VERSION_ID BIGINT 8
113 FROM_LINE_LOCATION_ID BIGINT 8
114 SECONDARY_QUANTITY NUMERIC(18,2) 19
115 SECONDARY_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
116 PREFERRED_GRADE CHARACTER VARYING(150) 150
117 AUCTION_HEADER_ID BIGINT 8
118 AUCTION_DISPLAY_NUMBER CHARACTER VARYING(40) 40
119 AUCTION_LINE_NUMBER BIGINT 8
120 BID_NUMBER BIGINT 8
121 BID_LINE_NUMBER BIGINT 8
122 RETROACTIVE_DATE TIMESTAMP 8
123 SUPPLIER_REF_NUMBER CHARACTER VARYING(150) 150
124 CONTRACT_ID BIGINT 8
125 START_DATE TIMESTAMP 8
126 AMOUNT NUMERIC(18,2) 19
127 JOB_ID BIGINT 8
128 CONTRACTOR_FIRST_NAME CHARACTER VARYING(240) 240
129 CONTRACTOR_LAST_NAME CHARACTER VARYING(240) 240
130 ORDER_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
131 PURCHASE_BASIS CHARACTER VARYING(30) 30
132 MATCHING_BASIS CHARACTER VARYING(30) 30
133 SVC_AMOUNT_NOTIF_SENT CHARACTER VARYING(1) 1
134 SVC_COMPLETION_NOTIF_SENT CHARACTER VARYING(1) 1
135 BASE_UNIT_PRICE NUMERIC(18,2) 19
136 MANUAL_PRICE_CHANGE_FLAG CHARACTER VARYING(1) 1
137 CATALOG_NAME CHARACTER VARYING(255) 255
138 SUPPLIER_PART_AUXID CHARACTER VARYING(255) 255
139 IP_CATEGORY_ID BIGINT 8
140 LAST_UPDATED_PROGRAM CHARACTER VARYING(255) 255
141 RETAINAGE_RATE NUMERIC(18,2) 19
142 MAX_RETAINAGE_AMOUNT NUMERIC(18,2) 19
143 PROGRESS_PAYMENT_RATE NUMERIC(18,2) 19
144 RECOUPMENT_RATE NUMERIC(18,2) 19
145 TAX_ATTRIBUTE_UPDATE_CODE CHARACTER VARYING(15) 15
146 GROUP_LINE_ID BIGINT 8
147 LINE_NUM_DISPLAY CHARACTER VARYING(240) 240
148 CLM_INFO_FLAG CHARACTER VARYING(1) 1
149 CLM_OPTION_INDICATOR CHARACTER VARYING(1) 1
150 CLM_BASE_LINE_NUM NUMERIC(18,2) 19
151 CLM_OPTION_NUM NUMERIC(18,2) 19
152 CLM_OPTION_FROM_DATE TIMESTAMP 8
153 CLM_OPTION_TO_DATE TIMESTAMP 8
154 CLM_FUNDED_FLAG CHARACTER VARYING(1) 1
155 CONTRACT_TYPE CHARACTER VARYING(240) 240
156 COST_CONSTRAINT CHARACTER VARYING(240) 240
157 CLM_IDC_TYPE CHARACTER VARYING(240) 240
158 UDA_TEMPLATE_ID BIGINT 8
159 USER_DOCUMENT_STATUS CHARACTER VARYING(30) 30
160 DRAFT_ID BIGINT 8
161 CLM_EXERCISED_FLAG CHARACTER VARYING(1) 1
162 CLM_EXERCISED_DATE TIMESTAMP 8
163 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
164 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
165 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
166 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8