OEB_RCV_TRANSACTIONS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 CREATION_DATE TIMESTAMP 8
5 CREATED_BY BIGINT 8
6 LAST_UPDATE_LOGIN BIGINT 8
7 REQUEST_ID BIGINT 8
8 PROGRAM_APPLICATION_ID BIGINT 8
9 PROGRAM_ID BIGINT 8
10 PROGRAM_UPDATE_DATE TIMESTAMP 8
11 TRANSACTION_TYPE CHARACTER VARYING(25) 25
12 TRANSACTION_DATE TIMESTAMP 8
13 QUANTITY NUMERIC(18,2) 19
14 UNIT_OF_MEASURE CHARACTER VARYING(25) 25
15 SHIPMENT_HEADER_ID BIGINT 8
16 SHIPMENT_LINE_ID BIGINT 8
17 USER_ENTERED_FLAG CHARACTER VARYING(1) 1
18 INTERFACE_SOURCE_CODE CHARACTER VARYING(25) 25
19 INTERFACE_SOURCE_LINE_ID BIGINT 8
20 INV_TRANSACTION_ID BIGINT 8
21 SOURCE_DOCUMENT_CODE CHARACTER VARYING(25) 25
22 DESTINATION_TYPE_CODE CHARACTER VARYING(25) 25
23 PRIMARY_QUANTITY NUMERIC(18,2) 19
24 PRIMARY_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
25 UOM_CODE CHARACTER VARYING(3) 3
26 EMPLOYEE_ID BIGINT 8
27 PARENT_TRANSACTION_ID BIGINT 8
28 PO_HEADER_ID BIGINT 8
29 PO_RELEASE_ID BIGINT 8
30 PO_LINE_ID BIGINT 8
31 PO_LINE_LOCATION_ID BIGINT 8
32 PO_DISTRIBUTION_ID BIGINT 8
33 PO_REVISION_NUM BIGINT 8
34 REQUISITION_LINE_ID BIGINT 8
35 PO_UNIT_PRICE NUMERIC(18,2) 19
36 CURRENCY_CODE CHARACTER VARYING(15) 15
37 CURRENCY_CONVERSION_TYPE CHARACTER VARYING(30) 30
38 CURRENCY_CONVERSION_RATE NUMERIC(18,2) 19
39 CURRENCY_CONVERSION_DATE TIMESTAMP 8
40 ROUTING_HEADER_ID BIGINT 8
41 ROUTING_STEP_ID BIGINT 8
42 DELIVER_TO_PERSON_ID BIGINT 8
43 DELIVER_TO_LOCATION_ID BIGINT 8
44 VENDOR_ID BIGINT 8
45 VENDOR_SITE_ID BIGINT 8
46 ORGANIZATION_ID BIGINT 8
47 SUBINVENTORY CHARACTER VARYING(10) 10
48 LOCATOR_ID BIGINT 8
49 WIP_ENTITY_ID BIGINT 8
50 WIP_LINE_ID BIGINT 8
51 WIP_REPETITIVE_SCHEDULE_ID BIGINT 8
52 WIP_OPERATION_SEQ_NUM BIGINT 8
53 WIP_RESOURCE_SEQ_NUM BIGINT 8
54 BOM_RESOURCE_ID BIGINT 8
55 LOCATION_ID BIGINT 8
56 SUBSTITUTE_UNORDERED_CODE CHARACTER VARYING(25) 25
57 RECEIPT_EXCEPTION_FLAG CHARACTER VARYING(1) 1
58 INSPECTION_STATUS_CODE CHARACTER VARYING(25) 25
59 ACCRUAL_STATUS_CODE CHARACTER VARYING(25) 25
60 INSPECTION_QUALITY_CODE CHARACTER VARYING(25) 25
61 VENDOR_LOT_NUM CHARACTER VARYING(30) 30
62 RMA_REFERENCE CHARACTER VARYING(30) 30
63 COMMENTS CHARACTER VARYING(240) 240
64 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
65 ATTRIBUTE1 CHARACTER VARYING(150) 150
66 ATTRIBUTE2 CHARACTER VARYING(150) 150
67 ATTRIBUTE3 CHARACTER VARYING(150) 150
68 ATTRIBUTE4 CHARACTER VARYING(150) 150
69 ATTRIBUTE5 CHARACTER VARYING(150) 150
70 ATTRIBUTE6 CHARACTER VARYING(150) 150
71 ATTRIBUTE7 CHARACTER VARYING(150) 150
72 ATTRIBUTE8 CHARACTER VARYING(150) 150
73 ATTRIBUTE9 CHARACTER VARYING(150) 150
74 ATTRIBUTE10 CHARACTER VARYING(150) 150
75 ATTRIBUTE11 CHARACTER VARYING(150) 150
76 ATTRIBUTE12 CHARACTER VARYING(150) 150
77 ATTRIBUTE13 CHARACTER VARYING(150) 150
78 ATTRIBUTE14 CHARACTER VARYING(150) 150
79 ATTRIBUTE15 CHARACTER VARYING(150) 150
80 REQ_DISTRIBUTION_ID BIGINT 8
81 DEPARTMENT_CODE CHARACTER VARYING(10) 10
82 REASON_ID BIGINT 8
83 DESTINATION_CONTEXT CHARACTER VARYING(30) 30
84 LOCATOR_ATTRIBUTE CHARACTER VARYING(150) 150
85 CHILD_INSPECTION_FLAG CHARACTER VARYING(1) 1
86 SOURCE_DOC_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
87 SOURCE_DOC_QUANTITY NUMERIC(18,2) 19
88 INTERFACE_TRANSACTION_ID BIGINT 8
89 GROUP_ID BIGINT 8
90 MOVEMENT_ID BIGINT 8
91 INVOICE_ID BIGINT 8
92 INVOICE_STATUS_CODE CHARACTER VARYING(25) 25
93 QA_COLLECTION_ID BIGINT 8
94 MRC_CURRENCY_CONVERSION_TYPE CHARACTER VARYING(1000) 1000
95 MRC_CURRENCY_CONVERSION_DATE CHARACTER VARYING(1000) 1000
96 MRC_CURRENCY_CONVERSION_RATE CHARACTER VARYING(1000) 1000
97 MRC_PO_UNIT_PRICE CHARACTER VARYING(1000) 1000
98 COUNTRY_OF_ORIGIN_CODE CHARACTER VARYING(2) 2
99 MVT_STAT_STATUS CHARACTER VARYING(30) 30
100 QUANTITY_BILLED NUMERIC(18,2) 19
101 MATCH_FLAG CHARACTER VARYING(1) 1
102 AMOUNT_BILLED NUMERIC(18,2) 19
103 MATCH_OPTION CHARACTER VARYING(25) 25
104 OE_ORDER_HEADER_ID BIGINT 8
105 OE_ORDER_LINE_ID BIGINT 8
106 CUSTOMER_ID BIGINT 8
107 CUSTOMER_SITE_ID BIGINT 8
108 LPN_ID BIGINT 8
109 TRANSFER_LPN_ID BIGINT 8
110 MOBILE_TXN CHARACTER VARYING(2) 2
111 SECONDARY_QUANTITY NUMERIC(18,2) 19
112 SECONDARY_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
113 QC_GRADE CHARACTER VARYING(150) 150
114 SECONDARY_UOM_CODE CHARACTER VARYING(3) 3
115 PA_ADDITION_FLAG CHARACTER VARYING(1) 1
116 CONSIGNED_FLAG CHARACTER VARYING(1) 1
117 SOURCE_TRANSACTION_NUM CHARACTER VARYING(25) 25
118 FROM_SUBINVENTORY CHARACTER VARYING(240) 240
119 FROM_LOCATOR_ID BIGINT 8
120 AMOUNT NUMERIC(18,2) 19
121 DROPSHIP_TYPE_CODE BIGINT 8
122 LPN_GROUP_ID BIGINT 8
123 JOB_ID BIGINT 8
124 TIMECARD_ID BIGINT 8
125 TIMECARD_OVN NUMERIC(18,2) 19
126 PROJECT_ID BIGINT 8
127 TASK_ID BIGINT 8
128 REQUESTED_AMOUNT NUMERIC(18,2) 19
129 MATERIAL_STORED_AMOUNT NUMERIC(18,2) 19
130 REPLENISH_ORDER_LINE_ID BIGINT 8
131 LCM_SHIPMENT_LINE_ID BIGINT 8
132 UNIT_LANDED_COST NUMERIC(18,2) 19
133 RECEIPT_CONFIRMATION_EXTRACTED CHARACTER VARYING(1) 1
134 LCM_ADJUSTMENT_NUM BIGINT 8
135 XML_DOCUMENT_ID BIGINT 8
136 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
137 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
138 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
139 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8