cv040_beg_stk_v.0 old
DESCRIPTION
CV040_Beg_Stk_v.0 oldTRANSCRIPT
AIM
CV.040 CONVERSION DATA MAPPING
PRIVI ORGANICS LIMITEDCV040_Inventory On-hand quantity Interface
Author: Shabeena Momin
Creation Date: 31-JAN-2011
Last Updated: 31-JAN-2011
Document Ref: 1.0
Version: DRAFT 1B
Approvals:
<Approver 1>
<Approver 2>
CV.040 Conversion Data Mapping
Document Control
Change Record3
Date Author Version
Change Reference
31-JAN-2011
Shabeena J Momin Draft 1a
No Previous Document
Reviewers
Name Position
Distribution
Copy No.
Name Location
1 Library Master Project Library
2 Project Manager
3
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2iicxxxi83ii
CV.040 Conversion Data Mapping
Copy No.
Name Location
4
Note To Holders:
If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes.
If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2iiicxxxi83iii
CV.040 Conversion Data Mapping
Contents
Document Control....................................................................................... ii
Introduction.................................................................................................4
Purpose.................................................................................................4
Background...........................................................................................4
Scope and Application...........................................................................4
Audience................................................................................................4
Application Business Object Reference Information....................................5
Conversion Mapping – Inventory On-hand quantity Interface....................6
Extract File Layout....................................................................................18
Data Clean-up...........................................................................................21
Data Normalization...................................................................................22
Objects......................................................................................................23
Data Conversion Process...........................................................................24
Open and Closed Issues for this Deliverable.............................................25
Open Issues.........................................................................................25
Closed Issues.......................................................................................25
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2ivcxxxi83iv
CV.040 Conversion Data Mapping
Introduction
Purpose
The Conversion Data Mapping document describes the:
Detailed data mapping from the source legacy system to the Oracle Application R12 for Item Quantity.
File layout to be used for extraction of the data from the source system
Scope and Application
The Conversion Data Mapping identifies for use in designing conversion programs to convert On-hand quantity Interface:
Data sources
Target tables and columns
Validation
Audience
This document is intended for the following individuals:
Privi Organics Limited conversion project staff
Outside consultants
Reviewers of data conversion deliverables
Conversion Tables
The following tables are going to be populated in the Oracle application for the conversion of Inventory onhand qty data
Staging Tables
xxx_stag_mtl_trans_tbl
Template Tables
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 25131835
CV.040 Conversion Data Mapping
PRIVI_GL_CODE
Interface Tables1. MTL_TRANSACTIONS_INTERFACE
2. MTL_LOT_TRANSACTIONS_INTERFACE
Base Tables
MTL_MATERIAL_TRANSACTIONS
MTL_LOT_TRANSACTIONS
Ordering of Tables
Below is the order in which the tables need to be populated for the Item quantities data conversion
1. MTL_TRANSACTIONS_INTERFACE
2. MTL_LOT_TRANSACTIONS_INTERFACE
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 26131836
CV.040 Conversion Data Mapping
Application Business Object Reference Information
In each of the following sections, a table maps the business objects for Item Quantity to the Oracle Application tables. The foreign key relationships between the Oracle Application tables are also indicated. Column (2) suggests whether the business object is a candidate for programmatic conversion. In column (4), the standard Oracle interface is documented if one exists for facilitating the conversion of a specific business object.
Business Object
Man/Prog
OwnedBy
Open Interface Production Table Name(s)
Foreign Key Table Name(s)
Setup Business Object
Inventory On-hand quantity
P INV MTL_TRANSACTIONS_INTERFACE
MTL_LOT_TRANSACTIONS_INTERFACE
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 27131837
CV.040 Conversion Data Mapping
Conversion Mapping – Inventory On-hand qty
Below is a table mapping the legacy data elements to the Oracle tables and columns.
Target Application: Oracle Application 12.1.1
Business Object: Inventory
Prepared by: Shabeena Momin
Ref.#
Target Application Table
Target Application Table Column
Target Column Datatype
Not Null?
Source System Source System Field Name
Source System Field Datatype
Default Validation Rule #
File Name Value
1 MTL_TRANSACTIONS_INTERFACE
COST_TYPE_ID NUMBER(22)
Y
2 MTL_TRANSACTIONS_INTERFACE
ORG_COST_GROUP_ID NUMBER(22)
Y
3 MTL_TRANSACTIONS_INTERFACE
SCHEDULED_PAYBACK_DATE
DATE(7) Y
4 MTL_TRANSACTIONS_INTERFACE
END_ITEM_UNIT_NUMBER
VARCHAR2(60)
Y
5 MTL_TRANSACTIONS_INTERFACE
OVERCOMPLETION_TRANSACTION_ID
NUMBER(22)
Y
6 MTL_TRANSACTIONS_INTERFACE
OVERCOMPLETION_PRIMARY_QTY
NUMBER(22)
Y
7 MTL_TRANSACTIONS_I OVERCOMPLETION_TRA NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 28131838
CV.040 Conversion Data Mapping
NTERFACE NSACTION_QTY 2)
8 MTL_TRANSACTIONS_INTERFACE
QA_COLLECTION_ID NUMBER(22)
Y
9 MTL_TRANSACTIONS_INTERFACE
KANBAN_CARD_ID NUMBER(22)
Y
10 MTL_TRANSACTIONS_INTERFACE
COST_GROUP_ID NUMBER(22)
Y
11 MTL_TRANSACTIONS_INTERFACE
FLOW_SCHEDULE VARCHAR2(1)
Y Y
12 MTL_TRANSACTIONS_INTERFACE
SCHEDULED_FLAG NUMBER(22)
Y 2
13 MTL_TRANSACTIONS_INTERFACE
SCHEDULE_NUMBER VARCHAR2(30)
Y
14 MTL_TRANSACTIONS_INTERFACE
BUILD_SEQUENCE NUMBER(22)
Y
15 MTL_TRANSACTIONS_INTERFACE
SCHEDULE_GROUP NUMBER(22)
Y
16 MTL_TRANSACTIONS_INTERFACE
SUBSTITUTION_ITEM_ID NUMBER(22)
Y
17 MTL_TRANSACTIONS_INTERFACE
SUBSTITUTION_TYPE_ID NUMBER(22)
Y
18 MTL_TRANSACTIONS_INTERFACE
PARENT_ID NUMBER(22)
Y
19 MTL_TRANSACTIONS_INTERFACE
DEMAND_CLASS VARCHAR2(30)
Y
20 MTL_TRANSACTIONS_I ACCOUNTING_CLASS VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 29131839
CV.040 Conversion Data Mapping
NTERFACE 2(10)
21 MTL_TRANSACTIONS_INTERFACE
ALTERNATE_ROUTING_DESIGNATOR
VARCHAR2(10)
Y
22 MTL_TRANSACTIONS_INTERFACE
ALTERNATE_BOM_DESIGNATOR
VARCHAR2(10)
Y
23 MTL_TRANSACTIONS_INTERFACE
ROUTING_REVISION_DATE
DATE(7) Y
24 MTL_TRANSACTIONS_INTERFACE
BOM_REVISION_DATE DATE(7) Y
25 MTL_TRANSACTIONS_INTERFACE
ROUTING_REVISION VARCHAR2(3)
Y
26 MTL_TRANSACTIONS_INTERFACE
BOM_REVISION VARCHAR2(3)
Y
27 MTL_TRANSACTIONS_INTERFACE
OVERHEAD_ACCOUNT NUMBER(22)
Y
28 MTL_TRANSACTIONS_INTERFACE
OUTSIDE_PROCESSING_ACCOUNT
NUMBER(22)
Y
29 MTL_TRANSACTIONS_INTERFACE
RESOURCE_ACCOUNT NUMBER(22)
Y
30 MTL_TRANSACTIONS_INTERFACE
MATERIAL_OVERHEAD_ACCOUNT
NUMBER(22)
Y
31 MTL_TRANSACTIONS_INTERFACE
MATERIAL_ACCOUNT NUMBER(22)
Y
32 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_SEQUENCE_ID
NUMBER(22)
Y
33 MTL_TRANSACTIONS_I TRANSFER_PERCENTAG NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2101318310
CV.040 Conversion Data Mapping
NTERFACE E 2)
34 MTL_TRANSACTIONS_INTERFACE
FINAL_COMPLETION_FLAG
VARCHAR2(1)
Y
35 MTL_TRANSACTIONS_INTERFACE
EXPENDITURE_TYPE VARCHAR2(30)
Y
36 MTL_TRANSACTIONS_INTERFACE
PA_EXPENDITURE_ORG_ID
NUMBER(22)
Y
37 MTL_TRANSACTIONS_INTERFACE
SOURCE_PROJECT_ID NUMBER(22)
Y
38 MTL_TRANSACTIONS_INTERFACE
TO_PROJECT_ID NUMBER(22)
Y
39 MTL_TRANSACTIONS_INTERFACE
PROJECT_ID NUMBER(22)
Y
40 MTL_TRANSACTIONS_INTERFACE
SOURCE_TASK_ID NUMBER(22)
Y
41 MTL_TRANSACTIONS_INTERFACE
TO_TASK_ID NUMBER(22)
Y
42 MTL_TRANSACTIONS_INTERFACE
TASK_ID NUMBER(22)
Y
43 MTL_TRANSACTIONS_INTERFACE
LOCATOR_NAME VARCHAR2(2000)
Y xxx_stag_mtl_trans_tbl
LOCATOR_NAME
44 MTL_TRANSACTIONS_INTERFACE
INVENTORY_ITEM VARCHAR2(2000)
Y
45 MTL_TRANSACTIONS_INTERFACE
SHIPPED_QUANTITY NUMBER(22)
Y
46 MTL_TRANSACTIONS_I RESERVATION_QUANTIT NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2111318311
CV.040 Conversion Data Mapping
NTERFACE Y 2)
47 MTL_TRANSACTIONS_INTERFACE
MOVEMENT_ID NUMBER(22)
Y
48 MTL_TRANSACTIONS_INTERFACE
REQUISITION_DISTRIBUTION_ID
NUMBER(22)
Y
49 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE15 VARCHAR2(150)
Y
50 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE14 VARCHAR2(150)
Y
51 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE13 VARCHAR2(150)
Y
52 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE12 VARCHAR2(150)
Y
53 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE11 VARCHAR2(150)
Y
54 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE10 VARCHAR2(150)
Y
55 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE9 VARCHAR2(150)
Y
56 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE8 VARCHAR2(150)
Y
57 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE7 VARCHAR2(150)
Y
58 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE6 VARCHAR2(150)
Y
59 MTL_TRANSACTIONS_I ATTRIBUTE5 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2121318312
CV.040 Conversion Data Mapping
NTERFACE 2(150)
60 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE4 VARCHAR2(150)
Y
61 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE3 VARCHAR2(150)
Y
62 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE2 VARCHAR2(150)
Y
63 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE1 VARCHAR2(150)
Y
64 MTL_TRANSACTIONS_INTERFACE
ATTRIBUTE_CATEGORY VARCHAR2(30)
Y
65 MTL_TRANSACTIONS_INTERFACE
REQUIRED_FLAG VARCHAR2(1)
Y
66 MTL_TRANSACTIONS_INTERFACE
ERROR_CODE VARCHAR2(240)
Y
67 MTL_TRANSACTIONS_INTERFACE
SHIPPABLE_FLAG VARCHAR2(1)
Y
68 MTL_TRANSACTIONS_INTERFACE
ERROR_EXPLANATION VARCHAR2(240)
Y
69 MTL_TRANSACTIONS_INTERFACE
NEGATIVE_REQ_FLAG NUMBER(22)
Y
70 MTL_TRANSACTIONS_INTERFACE
DEMAND_SOURCE_DELIVERY
VARCHAR2(30)
Y
71 MTL_TRANSACTIONS_INTERFACE
DEMAND_SOURCE_LINE VARCHAR2(30)
Y
72 MTL_TRANSACTIONS_I DEMAND_SOURCE_HEA NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2131318313
CV.040 Conversion Data Mapping
NTERFACE DER_ID 2)
73 MTL_TRANSACTIONS_INTERFACE
PERCENTAGE_CHANGE NUMBER(22)
Y
74 MTL_TRANSACTIONS_INTERFACE
VALUE_CHANGE NUMBER(22)
Y
75 MTL_TRANSACTIONS_INTERFACE
NEW_AVERAGE_COST NUMBER(22)
Y
76 MTL_TRANSACTIONS_INTERFACE
EXPECTED_ARRIVAL_DATE
DATE(7) Y
77 MTL_TRANSACTIONS_INTERFACE
WAYBILL_AIRBILL VARCHAR2(20)
Y
78 MTL_TRANSACTIONS_INTERFACE
CONTAINERS NUMBER(22)
Y
79 MTL_TRANSACTIONS_INTERFACE
FREIGHT_CODE VARCHAR2(30)
Y
80 MTL_TRANSACTIONS_INTERFACE
TRANSFER_COST NUMBER(22)
Y
81 MTL_TRANSACTIONS_INTERFACE
TRANSPORTATION_ACCOUNT
NUMBER(22)
Y
82 MTL_TRANSACTIONS_INTERFACE
TRANSPORTATION_COST
NUMBER(22)
Y
83 MTL_TRANSACTIONS_INTERFACE
SHIPMENT_NUMBER VARCHAR2(30)
Y
84 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT20 VARCHAR2(40)
Y
85 MTL_TRANSACTIONS_I XFER_LOC_SEGMENT19 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2141318314
CV.040 Conversion Data Mapping
NTERFACE 2(40)
86 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT18 VARCHAR2(40)
Y
87 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT17 VARCHAR2(40)
Y
88 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT16 VARCHAR2(40)
Y
89 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT15 VARCHAR2(40)
Y
90 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT14 VARCHAR2(40)
Y
91 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT13 VARCHAR2(40)
Y
92 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT12 VARCHAR2(40)
Y
93 MTL_TRANSACTIONS_INTERFACE
SOURCE_LOT_NUMBER VARCHAR2(80)
Y xxx_stag_mtl_trans_tbl
LOT_NUMBER
94 MTL_TRANSACTIONS_INTERFACE
RELIEVE_RESERVATIONS_FLAG
VARCHAR2(1)
Y
95 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT11 VARCHAR2(40)
Y
96 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT10 VARCHAR2(40)
Y
97 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT9 VARCHAR2(40)
Y
98 MTL_TRANSACTIONS_I LOC_SEGMENT8 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2151318315
CV.040 Conversion Data Mapping
NTERFACE 2(40)
99 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT7 VARCHAR2(40)
Y
100 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT6 VARCHAR2(40)
Y
101 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT5 VARCHAR2(40)
Y
102 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT4 VARCHAR2(40)
Y
103 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT3 VARCHAR2(40)
Y
104 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT2 VARCHAR2(40)
Y
105 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT1 VARCHAR2(40)
Y
106 MTL_TRANSACTIONS_INTERFACE
LOCATOR_ID NUMBER(22)
Y mtl_item_locations locator_id number derived
107 MTL_TRANSACTIONS_INTERFACE
SUBINVENTORY_CODE VARCHAR2(10)
Y xxx_stag_mtl_trans_tbl
108 MTL_TRANSACTIONS_INTERFACE
ACCT_PERIOD_ID NUMBER(22)
Y
109 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_DATE DATE(7) N
110 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_UOM VARCHAR2(3)
N mtl_system_items primary_uom_code varchar2(3)
Derived
111 MTL_TRANSACTIONS_I PRIMARY_QUANTITY NUMBER(2 Y xxx_stag_mtl_trans
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2161318316
CV.040 Conversion Data Mapping
NTERFACE 2) _tbl
112 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_QUANTITY
NUMBER(22)
N
113 MTL_TRANSACTIONS_INTERFACE
ORGANIZATION_ID NUMBER(22)
N org_organization_definitions
organization_id number(22)
Derived
114 MTL_TRANSACTIONS_INTERFACE
REVISION VARCHAR2(3)
Y
115 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT20 VARCHAR2(40)
Y
116 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT19 VARCHAR2(40)
Y
117 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT18 VARCHAR2(40)
Y
118 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT17 VARCHAR2(40)
Y
119 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT16 VARCHAR2(40)
Y
120 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT15 VARCHAR2(40)
Y
121 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT14 VARCHAR2(40)
Y
122 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT13 VARCHAR2(40)
Y
123 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT12 VARCHAR2(40)
Y
124 MTL_TRANSACTIONS_I ITEM_SEGMENT11 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2171318317
CV.040 Conversion Data Mapping
NTERFACE 2(40)
125 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT10 VARCHAR2(40)
Y
126 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT9 VARCHAR2(40)
Y
127 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT8 VARCHAR2(40)
Y
128 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT7 VARCHAR2(40)
Y
129 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT6 VARCHAR2(40)
Y
130 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT5 VARCHAR2(40)
Y
131 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT4 VARCHAR2(40)
Y
132 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT3 VARCHAR2(40)
Y
133 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT2 VARCHAR2(40)
Y
134 MTL_TRANSACTIONS_INTERFACE
ITEM_SEGMENT1 VARCHAR2(40)
Y xxx_stag_mtl_trans_tbl
item_code varchar2(40)
135 MTL_TRANSACTIONS_INTERFACE
INVENTORY_ITEM_ID NUMBER(22)
Y
136 MTL_TRANSACTIONS_INTERFACE
PROGRAM_UPDATE_DATE
DATE(7) Y
137 MTL_TRANSACTIONS_I PROGRAM_ID NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2181318318
CV.040 Conversion Data Mapping
NTERFACE 2)
138 MTL_TRANSACTIONS_INTERFACE
PROGRAM_APPLICATION_ID
NUMBER(22)
Y
139 MTL_TRANSACTIONS_INTERFACE
REQUEST_ID NUMBER(22)
Y
140 MTL_TRANSACTIONS_INTERFACE
LAST_UPDATE_LOGIN NUMBER(22)
Y
141 MTL_TRANSACTIONS_INTERFACE
CREATED_BY NUMBER(22)
N
142 MTL_TRANSACTIONS_INTERFACE
CREATION_DATE DATE(7) N
143 MTL_TRANSACTIONS_INTERFACE
LAST_UPDATED_BY NUMBER(22)
N
144 MTL_TRANSACTIONS_INTERFACE
LAST_UPDATE_DATE DATE(7) N
145 MTL_TRANSACTIONS_INTERFACE
LOCK_FLAG NUMBER(22)
Y
146 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_MODE NUMBER(22)
N
147 MTL_TRANSACTIONS_INTERFACE
VALIDATION_REQUIRED NUMBER(22)
Y
148 MTL_TRANSACTIONS_INTERFACE
PROCESS_FLAG NUMBER(22)
N 1
149 MTL_TRANSACTIONS_INTERFACE
SOURCE_HEADER_ID NUMBER(22)
N
150 MTL_TRANSACTIONS_I SOURCE_LINE_ID NUMBER(2 N
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2191318319
CV.040 Conversion Data Mapping
NTERFACE 2)
151 MTL_TRANSACTIONS_INTERFACE
SOURCE_CODE VARCHAR2(30)
N Miscellaneous Recpt(RG Update)
152 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_HEADER_ID
NUMBER(22)
Y mtl_material_transactions_s.N
EXTVAL
153 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_INTERFACE_ID
NUMBER(22)
Y mtl_material_transactions_s.N
EXTVAL
154 MTL_TRANSACTIONS_INTERFACE
REBUILD_JOB_NAME VARCHAR2(240)
Y
155 MTL_TRANSACTIONS_INTERFACE
REBUILD_ACTIVITY_ID NUMBER(22)
Y
156 MTL_TRANSACTIONS_INTERFACE
REBUILD_SERIAL_NUMBER
VARCHAR2(30)
Y
157 MTL_TRANSACTIONS_INTERFACE
REBUILD_ITEM_ID NUMBER(22)
Y
158 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_BATCH_SEQ
NUMBER(22)
Y
159 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_BATCH_ID
NUMBER(22)
Y
160 MTL_TRANSACTIONS_INTERFACE
REPRESENTATIVE_LOT_NUMBER
VARCHAR2(80)
Y
161 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_GROUP_SEQ
NUMBER(22)
Y
162 MTL_TRANSACTIONS_I TRANSACTION_GROUP_I NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2201318320
CV.040 Conversion Data Mapping
NTERFACE D 2)
163 MTL_TRANSACTIONS_INTERFACE
SECONDARY_TRANSACTION_QUANTITY
NUMBER(22)
Y
164 MTL_TRANSACTIONS_INTERFACE
SECONDARY_UOM_CODE
VARCHAR2(240)
Y
165 MTL_TRANSACTIONS_INTERFACE
TRANSFER_PLANNING_TP_TYPE
NUMBER(22)
Y
166 MTL_TRANSACTIONS_INTERFACE
XFR_PLANNING_ORGANIZATION_ID
NUMBER(22)
Y
167 MTL_TRANSACTIONS_INTERFACE
PLANNING_TP_TYPE NUMBER(22)
Y
168 MTL_TRANSACTIONS_INTERFACE
PLANNING_ORGANIZATION_ID
NUMBER(22)
Y
169 MTL_TRANSACTIONS_INTERFACE
TRANSFER_OWNING_TP_TYPE
NUMBER(22)
Y
170 MTL_TRANSACTIONS_INTERFACE
XFR_OWNING_ORGANIZATION_ID
NUMBER(22)
Y
171 MTL_TRANSACTIONS_INTERFACE
OWNING_TP_TYPE NUMBER(22)
Y
172 MTL_TRANSACTIONS_INTERFACE
OWNING_ORGANIZATION_ID
NUMBER(22)
Y
173 MTL_TRANSACTIONS_INTERFACE
TRANSFER_ORGANIZATION_TYPE
NUMBER(22)
Y
174 MTL_TRANSACTIONS_INTERFACE
ORGANIZATION_TYPE NUMBER(22)
Y
175 MTL_TRANSACTIONS_I XML_DOCUMENT_ID VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2211318321
CV.040 Conversion Data Mapping
NTERFACE 2(240)
176 MTL_TRANSACTIONS_INTERFACE
CONTENT_LPN_ID NUMBER(22)
Y
177 MTL_TRANSACTIONS_INTERFACE
TRANSFER_LPN_ID NUMBER(22)
Y
178 MTL_TRANSACTIONS_INTERFACE
LPN_ID NUMBER(22)
Y
179 MTL_TRANSACTIONS_INTERFACE
TRANSFER_COST_GROUP_ID
NUMBER(22)
Y
180 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT11 VARCHAR2(40)
Y
181 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT10 VARCHAR2(40)
Y
182 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT9 VARCHAR2(40)
Y
183 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT8 VARCHAR2(40)
Y
184 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT7 VARCHAR2(40)
Y
185 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT6 VARCHAR2(40)
Y
186 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT5 VARCHAR2(40)
Y
187 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT4 VARCHAR2(40)
Y
188 MTL_TRANSACTIONS_I XFER_LOC_SEGMENT3 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2221318322
CV.040 Conversion Data Mapping
NTERFACE 2(40)
189 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT2 VARCHAR2(40)
Y
190 MTL_TRANSACTIONS_INTERFACE
XFER_LOC_SEGMENT1 VARCHAR2(40)
Y
191 MTL_TRANSACTIONS_INTERFACE
TRANSFER_LOCATOR NUMBER(22)
Y
192 MTL_TRANSACTIONS_INTERFACE
TRANSFER_ORGANIZATION
NUMBER(22)
Y
193 MTL_TRANSACTIONS_INTERFACE
TRANSFER_SUBINVENTORY
VARCHAR2(10)
Y
194 MTL_TRANSACTIONS_INTERFACE
VENDOR_LOT_NUMBER VARCHAR2(30)
Y
195 MTL_TRANSACTIONS_INTERFACE
ENCUMBRANCE_AMOUNT
NUMBER(22)
Y
196 MTL_TRANSACTIONS_INTERFACE
ENCUMBRANCE_ACCOUNT
NUMBER(22)
Y
197 MTL_TRANSACTIONS_INTERFACE
SHIP_TO_LOCATION_ID NUMBER(22)
Y
198 MTL_TRANSACTIONS_INTERFACE
RCV_TRANSACTION_ID NUMBER(22)
Y
199 MTL_TRANSACTIONS_INTERFACE
RECEIVING_DOCUMENT VARCHAR2(10)
Y
200 MTL_TRANSACTIONS_INTERFACE
LINE_ITEM_NUM NUMBER(22)
Y
201 MTL_TRANSACTIONS_I CUSTOMER_SHIP_ID NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2231318323
CV.040 Conversion Data Mapping
NTERFACE 2)
202 MTL_TRANSACTIONS_INTERFACE
DEMAND_ID NUMBER(22)
Y
203 MTL_TRANSACTIONS_INTERFACE
TRX_SOURCE_DELIVERY_ID
NUMBER(22)
Y
204 MTL_TRANSACTIONS_INTERFACE
TRX_SOURCE_LINE_ID NUMBER(22)
Y
205 MTL_TRANSACTIONS_INTERFACE
PICKING_LINE_ID NUMBER(22)
Y
206 MTL_TRANSACTIONS_INTERFACE
REPETITIVE_LINE_ID NUMBER(22)
Y
207 MTL_TRANSACTIONS_INTERFACE
OPERATION_SEQ_NUM NUMBER(22)
Y
208 MTL_TRANSACTIONS_INTERFACE
MRP_CODE NUMBER(22)
Y
209 MTL_TRANSACTIONS_INTERFACE
PRIMARY_SWITCH NUMBER(22)
Y
210 MTL_TRANSACTIONS_INTERFACE
SETUP_TEARDOWN_CODE
NUMBER(22)
Y
211 MTL_TRANSACTIONS_INTERFACE
SCHEDULE_UPDATE_CODE
NUMBER(22)
Y
212 MTL_TRANSACTIONS_INTERFACE
DEPARTMENT_ID NUMBER(22)
Y
213 MTL_TRANSACTIONS_INTERFACE
EMPLOYEE_CODE VARCHAR2(10)
Y
214 MTL_TRANSACTIONS_I SCHEDULE_ID NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2241318324
CV.040 Conversion Data Mapping
NTERFACE 2)
215 MTL_TRANSACTIONS_INTERFACE
WIP_ENTITY_TYPE NUMBER(22)
Y
216 MTL_TRANSACTIONS_INTERFACE
USSGL_TRANSACTION_CODE
VARCHAR2(30)
Y
217 MTL_TRANSACTIONS_INTERFACE
CURRENCY_CONVERSION_RATE
NUMBER(22)
Y
218 MTL_TRANSACTIONS_INTERFACE
CURRENCY_CONVERSION_TYPE
VARCHAR2(30)
Y
219 MTL_TRANSACTIONS_INTERFACE
CURRENCY_CONVERSION_DATE
DATE(7) Y
220 MTL_TRANSACTIONS_INTERFACE
CURRENCY_CODE VARCHAR2(30)
Y
221 MTL_TRANSACTIONS_INTERFACE
REQUISITION_LINE_ID NUMBER(22)
Y
222 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT30 VARCHAR2(25)
Y
223 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT29 VARCHAR2(25)
Y
224 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT28 VARCHAR2(25)
Y
225 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT27 VARCHAR2(25)
Y
226 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT26 VARCHAR2(25)
Y
227 MTL_TRANSACTIONS_I DST_SEGMENT25 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2251318325
CV.040 Conversion Data Mapping
NTERFACE 2(25)
228 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT24 VARCHAR2(25)
Y
229 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT23 VARCHAR2(25)
Y
230 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT22 VARCHAR2(25)
Y
231 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT21 VARCHAR2(25)
Y
232 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT20 VARCHAR2(25)
Y
233 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT19 VARCHAR2(25)
Y
234 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT18 VARCHAR2(25)
Y
235 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT17 VARCHAR2(25)
Y
236 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT16 VARCHAR2(25)
Y
237 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT15 VARCHAR2(25)
Y
238 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT14 VARCHAR2(25)
Y
239 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT13 VARCHAR2(25)
Y
240 MTL_TRANSACTIONS_I DST_SEGMENT12 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2261318326
CV.040 Conversion Data Mapping
NTERFACE 2(25)
241 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT11 VARCHAR2(25)
Y
242 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT10 VARCHAR2(25)
Y
243 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT9 VARCHAR2(25)
Y
244 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT8 VARCHAR2(25)
Y
245 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT7 VARCHAR2(25)
Y
246 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT6 VARCHAR2(25)
Y
247 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT5 VARCHAR2(25)
Y
248 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT4 VARCHAR2(25)
Y
249 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT3 VARCHAR2(25)
Y
250 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT2 VARCHAR2(25)
Y
251 MTL_TRANSACTIONS_INTERFACE
DST_SEGMENT1 VARCHAR2(25)
Y
252 MTL_TRANSACTIONS_INTERFACE
DISTRIBUTION_ACCOUNT_ID
NUMBER(22)
Y PRIVI_GL_CODE CODE_COMBINATION_ID
NUMBER DERIVED
253 MTL_TRANSACTIONS_I TRANSACTION_COST NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2271318327
CV.040 Conversion Data Mapping
NTERFACE 2)
254 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_REFERENCE
VARCHAR2(240)
Y
255 MTL_TRANSACTIONS_INTERFACE
REASON_ID NUMBER(22)
Y
256 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_TYPE_ID NUMBER(22)
N
257 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_ACTION_ID
NUMBER(22)
Y
258 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_SOURCE_TYPE_ID
NUMBER(22)
Y
259 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_SOURCE_NAME
VARCHAR2(80)
Y
260 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT30 VARCHAR2(40)
Y
261 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT29 VARCHAR2(40)
Y
262 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT28 VARCHAR2(40)
Y
263 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT27 VARCHAR2(40)
Y
264 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT26 VARCHAR2(40)
Y
265 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT25 VARCHAR2(40)
Y
266 MTL_TRANSACTIONS_I DSP_SEGMENT24 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2281318328
CV.040 Conversion Data Mapping
NTERFACE 2(40)
267 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT23 VARCHAR2(40)
Y
268 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT22 VARCHAR2(40)
Y
269 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT21 VARCHAR2(40)
Y
270 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT20 VARCHAR2(40)
Y
271 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT19 VARCHAR2(40)
Y
272 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT18 VARCHAR2(40)
Y
273 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT17 VARCHAR2(40)
Y
274 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT16 VARCHAR2(40)
Y
275 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT15 VARCHAR2(40)
Y
276 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT14 VARCHAR2(40)
Y
277 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT13 VARCHAR2(40)
Y
278 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT12 VARCHAR2(40)
Y
279 MTL_TRANSACTIONS_I DSP_SEGMENT11 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2291318329
CV.040 Conversion Data Mapping
NTERFACE 2(40)
280 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT10 VARCHAR2(40)
Y
281 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT9 VARCHAR2(40)
Y
282 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT8 VARCHAR2(40)
Y
283 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT7 VARCHAR2(40)
Y
284 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT6 VARCHAR2(40)
Y
285 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT5 VARCHAR2(40)
Y
286 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT4 VARCHAR2(40)
Y
287 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT3 VARCHAR2(40)
Y
288 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT2 VARCHAR2(40)
Y
289 MTL_TRANSACTIONS_INTERFACE
DSP_SEGMENT1 VARCHAR2(40)
Y
290 MTL_TRANSACTIONS_INTERFACE
TRANSACTION_SOURCE_ID
NUMBER(22)
Y
291 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT20 VARCHAR2(40)
Y
292 MTL_TRANSACTIONS_I LOC_SEGMENT19 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2301318330
CV.040 Conversion Data Mapping
NTERFACE 2(40)
293 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT18 VARCHAR2(40)
Y
294 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT17 VARCHAR2(40)
Y
295 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT16 VARCHAR2(40)
Y
296 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT15 VARCHAR2(40)
Y
297 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT14 VARCHAR2(40)
Y
298 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT13 VARCHAR2(40)
Y
299 MTL_TRANSACTIONS_INTERFACE
LOC_SEGMENT12 VARCHAR2(40)
Y
300 MTL_TRANSACTIONS_INTERFACE
WIP_SUPPLY_TYPE NUMBER(22)
Y
301 MTL_TRANSACTIONS_INTERFACE
COMPLETION_TRANSACTION_ID
NUMBER(22)
Y
302 MTL_TRANSACTIONS_INTERFACE
MOVE_TRANSACTION_ID NUMBER(22)
Y
303 MTL_TRANSACTIONS_INTERFACE
MATERIAL_EXPENSE_ACCOUNT
NUMBER(22)
Y
304 MTL_TRANSACTIONS_INTERFACE
TRANSFER_PRICE NUMBER(22)
Y
305 MTL_TRANSACTIONS_I RELIEVE_HIGH_LEVEL_R VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2311318331
CV.040 Conversion Data Mapping
NTERFACE SV_FLAG 2(1)
306 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE5 VARCHAR2(150)
Y
307 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE6 VARCHAR2(150)
Y
308 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE7 VARCHAR2(150)
Y
309 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE8 VARCHAR2(150)
Y
310 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE9 VARCHAR2(150)
Y
311 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE10 VARCHAR2(150)
Y
312 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE11 VARCHAR2(150)
Y
313 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE12 VARCHAR2(150)
Y
314 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE13 VARCHAR2(150)
Y
315 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE14 VARCHAR2(150)
Y
316 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE15 VARCHAR2(150)
Y
317 MTL_TRANSACTIONS_INTERFACE_V
CURRENCY_CONVERSION_DATE
DATE(7) Y
318 MTL_TRANSACTIONS_I SHIPPABLE_FLAG VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2321318332
CV.040 Conversion Data Mapping
NTERFACE_V 2(1)
319 MTL_TRANSACTIONS_INTERFACE_V
MOVEMENT_ID NUMBER(22)
Y
320 MTL_TRANSACTIONS_INTERFACE_V
RESERVATION_QUANTITY
NUMBER(22)
Y
321 MTL_TRANSACTIONS_INTERFACE_V
SHIPPED_QUANTITY NUMBER(22)
Y
322 MTL_TRANSACTIONS_INTERFACE_V
SOURCE_PROJECT_ID NUMBER(22)
Y
323 MTL_TRANSACTIONS_INTERFACE_V
SOURCE_TASK_ID NUMBER(22)
Y
324 MTL_TRANSACTIONS_INTERFACE_V
PROJECT_ID NUMBER(22)
Y
325 MTL_TRANSACTIONS_INTERFACE_V
TO_PROJECT_ID NUMBER(22)
Y
326 MTL_TRANSACTIONS_INTERFACE_V
TASK_ID NUMBER(22)
Y
327 MTL_TRANSACTIONS_INTERFACE_V
TO_TASK_ID NUMBER(22)
Y
328 MTL_TRANSACTIONS_INTERFACE_V
EXPENDITURE_TYPE VARCHAR2(30)
Y
329 MTL_TRANSACTIONS_INTERFACE_V
PA_EXPENDITURE_ORG_ID
NUMBER(22)
Y
330 MTL_TRANSACTIONS_INTERFACE_V
COST_GROUP_ID NUMBER(22)
Y
331 MTL_TRANSACTIONS_I MATERIAL_ACCOUNT NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2331318333
CV.040 Conversion Data Mapping
NTERFACE_V 2)
332 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_COST_GROUP_ID
NUMBER(22)
Y
333 MTL_TRANSACTIONS_INTERFACE_V
LPN_ID NUMBER(22)
Y
334 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_LPN_ID NUMBER(22)
Y
335 MTL_TRANSACTIONS_INTERFACE_V
LPN VARCHAR2(30)
Y
336 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_LPN VARCHAR2(30)
Y
337 MTL_TRANSACTIONS_INTERFACE_V
COST_GROUP_NAME VARCHAR2(10)
Y
338 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_COST_GROUP_NAME
VARCHAR2(10)
Y
339 MTL_TRANSACTIONS_INTERFACE_V
CONTENT_LPN_ID NUMBER(22)
Y
340 MTL_TRANSACTIONS_INTERFACE_V
CONTENT_LPN VARCHAR2(30)
Y
341 MTL_TRANSACTIONS_INTERFACE_V
PLANNING_ORGANIZATION_ID
NUMBER(22)
Y
342 MTL_TRANSACTIONS_INTERFACE_V
PLANNING_TP_TYPE NUMBER(22)
Y
343 MTL_TRANSACTIONS_INTERFACE_V
OWNING_ORGANIZATION_ID
NUMBER(22)
Y
344 MTL_TRANSACTIONS_I OWNING_TP_TYPE NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2341318334
CV.040 Conversion Data Mapping
NTERFACE_V 2)
345 MTL_TRANSACTIONS_INTERFACE_V
SCHEDULE_NUMBER VARCHAR2(30)
Y
346 MTL_TRANSACTIONS_INTERFACE_V
FLOW_SCHEDULE VARCHAR2(1)
Y
347 MTL_TRANSACTIONS_INTERFACE_V
SCHEDULED_FLAG NUMBER(22)
Y
348 MTL_TRANSACTIONS_INTERFACE_V
SECONDARY_TRANSACTION_QUANTITY
NUMBER(22)
Y
349 MTL_TRANSACTIONS_INTERFACE_V
SECONDARY_UOM_CODE
VARCHAR2(240)
Y
350 MTL_TRANSACTIONS_INTERFACE_V
ROW_ID ROWID(10)
Y
351 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_INTERFACE_ID
NUMBER(22)
Y
352 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_HEADER_ID
NUMBER(22)
Y
353 MTL_TRANSACTIONS_INTERFACE_V
SOURCE_CODE VARCHAR2(30)
N
354 MTL_TRANSACTIONS_INTERFACE_V
SOURCE_LINE_ID NUMBER(22)
N
355 MTL_TRANSACTIONS_INTERFACE_V
SOURCE_HEADER_ID NUMBER(22)
N
356 MTL_TRANSACTIONS_INTERFACE_V
PROCESS_FLAG NUMBER(22)
N
357 MTL_TRANSACTIONS_I PROCESS_FLAG_DESC VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2351318335
CV.040 Conversion Data Mapping
NTERFACE_V 2(80)
358 MTL_TRANSACTIONS_INTERFACE_V
VALIDATION_REQUIRED NUMBER(22)
Y
359 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_MODE NUMBER(22)
N 3
360 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_MODE_DESC
VARCHAR2(80)
Y
361 MTL_TRANSACTIONS_INTERFACE_V
LOCK_FLAG NUMBER(22)
Y 2
362 MTL_TRANSACTIONS_INTERFACE_V
LOCK_FLAG_DESC VARCHAR2(80)
Y
363 MTL_TRANSACTIONS_INTERFACE_V
LAST_UPDATE_DATE DATE(7) N
364 MTL_TRANSACTIONS_INTERFACE_V
LAST_UPDATED_BY NUMBER(22)
N
365 MTL_TRANSACTIONS_INTERFACE_V
CREATION_DATE DATE(7) N
366 MTL_TRANSACTIONS_INTERFACE_V
CREATED_BY NUMBER(22)
N
367 MTL_TRANSACTIONS_INTERFACE_V
LAST_UPDATE_LOGIN NUMBER(22)
Y
368 MTL_TRANSACTIONS_INTERFACE_V
REQUEST_ID NUMBER(22)
Y
369 MTL_TRANSACTIONS_INTERFACE_V
PROGRAM_APPLICATION_ID
NUMBER(22)
Y
370 MTL_TRANSACTIONS_I PROGRAM_ID NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2361318336
CV.040 Conversion Data Mapping
NTERFACE_V 2)
371 MTL_TRANSACTIONS_INTERFACE_V
PROGRAM_UPDATE_DATE
DATE(7) Y
372 MTL_TRANSACTIONS_INTERFACE_V
INVENTORY_ITEM_ID NUMBER(22)
Y
373 MTL_TRANSACTIONS_INTERFACE_V
ITEM_DESCRIPTION VARCHAR2(240)
Y
374 MTL_TRANSACTIONS_INTERFACE_V
PRIMARY_UOM_CODE VARCHAR2(3)
Y
375 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT1 VARCHAR2(40)
Y
376 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT2 VARCHAR2(40)
Y
377 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT3 VARCHAR2(40)
Y
378 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT4 VARCHAR2(40)
Y
379 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT5 VARCHAR2(40)
Y
380 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT6 VARCHAR2(40)
Y
381 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT7 VARCHAR2(40)
Y
382 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT8 VARCHAR2(40)
Y
383 MTL_TRANSACTIONS_I ITEM_SEGMENT9 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2371318337
CV.040 Conversion Data Mapping
NTERFACE_V 2(40)
384 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT10 VARCHAR2(40)
Y
385 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT11 VARCHAR2(40)
Y
386 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT12 VARCHAR2(40)
Y
387 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT13 VARCHAR2(40)
Y
388 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT14 VARCHAR2(40)
Y
389 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT15 VARCHAR2(40)
Y
390 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT16 VARCHAR2(40)
Y
391 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT17 VARCHAR2(40)
Y
392 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT18 VARCHAR2(40)
Y
393 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT19 VARCHAR2(40)
Y
394 MTL_TRANSACTIONS_INTERFACE_V
ITEM_SEGMENT20 VARCHAR2(40)
Y
395 MTL_TRANSACTIONS_INTERFACE_V
REVISION VARCHAR2(3)
Y
396 MTL_TRANSACTIONS_I ORGANIZATION_ID NUMBER(2 N
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2381318338
CV.040 Conversion Data Mapping
NTERFACE_V 2)
397 MTL_TRANSACTIONS_INTERFACE_V
ORGANIZATION_CODE VARCHAR2(3)
Y
398 MTL_TRANSACTIONS_INTERFACE_V
ORGANIZATION_NAME VARCHAR2(240)
Y
399 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_QUANTITY
NUMBER(22)
N
400 MTL_TRANSACTIONS_INTERFACE_V
PRIMARY_QUANTITY NUMBER(22)
Y
401 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_UOM VARCHAR2(3)
N
402 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_DATE DATE(7) N
403 MTL_TRANSACTIONS_INTERFACE_V
ACCT_PERIOD_ID NUMBER(22)
Y
404 MTL_TRANSACTIONS_INTERFACE_V
SUBINVENTORY_CODE VARCHAR2(10)
Y
405 MTL_TRANSACTIONS_INTERFACE_V
LOCATOR_ID NUMBER(22)
Y
406 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT1 VARCHAR2(40)
Y
407 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT2 VARCHAR2(40)
Y
408 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT3 VARCHAR2(40)
Y
409 MTL_TRANSACTIONS_I LOC_SEGMENT4 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2391318339
CV.040 Conversion Data Mapping
NTERFACE_V 2(40)
410 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT5 VARCHAR2(40)
Y
411 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT6 VARCHAR2(40)
Y
412 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT7 VARCHAR2(40)
Y
413 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT8 VARCHAR2(40)
Y
414 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT9 VARCHAR2(40)
Y
415 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT10 VARCHAR2(40)
Y
416 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT11 VARCHAR2(40)
Y
417 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT12 VARCHAR2(40)
Y
418 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT13 VARCHAR2(40)
Y
419 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT14 VARCHAR2(40)
Y
420 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT15 VARCHAR2(40)
Y
421 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT16 VARCHAR2(40)
Y
422 MTL_TRANSACTIONS_I LOC_SEGMENT17 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2401318340
CV.040 Conversion Data Mapping
NTERFACE_V 2(40)
423 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT18 VARCHAR2(40)
Y
424 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT19 VARCHAR2(40)
Y
425 MTL_TRANSACTIONS_INTERFACE_V
LOC_SEGMENT20 VARCHAR2(40)
Y
426 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_SOURCE_ID
NUMBER(22)
Y
427 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT1 VARCHAR2(40)
Y
428 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT2 VARCHAR2(40)
Y
429 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT3 VARCHAR2(40)
Y
430 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT4 VARCHAR2(40)
Y
431 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT5 VARCHAR2(40)
Y
432 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT6 VARCHAR2(40)
Y
433 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT7 VARCHAR2(40)
Y
434 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT8 VARCHAR2(40)
Y
435 MTL_TRANSACTIONS_I DSP_SEGMENT9 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2411318341
CV.040 Conversion Data Mapping
NTERFACE_V 2(40)
436 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT10 VARCHAR2(40)
Y
437 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT11 VARCHAR2(40)
Y
438 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT12 VARCHAR2(40)
Y
439 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT13 VARCHAR2(40)
Y
440 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT14 VARCHAR2(40)
Y
441 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT15 VARCHAR2(40)
Y
442 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT16 VARCHAR2(40)
Y
443 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT17 VARCHAR2(40)
Y
444 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT18 VARCHAR2(40)
Y
445 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT19 VARCHAR2(40)
Y
446 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT20 VARCHAR2(40)
Y
447 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT21 VARCHAR2(40)
Y
448 MTL_TRANSACTIONS_I DSP_SEGMENT22 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2421318342
CV.040 Conversion Data Mapping
NTERFACE_V 2(40)
449 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT23 VARCHAR2(40)
Y
450 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT24 VARCHAR2(40)
Y
451 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT25 VARCHAR2(40)
Y
452 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT26 VARCHAR2(40)
Y
453 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT27 VARCHAR2(40)
Y
454 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT28 VARCHAR2(40)
Y
455 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT29 VARCHAR2(40)
Y
456 MTL_TRANSACTIONS_INTERFACE_V
DSP_SEGMENT30 VARCHAR2(40)
Y
457 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_SOURCE_NAME
VARCHAR2(80)
Y
458 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_SOURCE_TYPE_ID
NUMBER(22)
Y
459 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_SOURCE_TYPE_NAME
VARCHAR2(30)
Y
460 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_ACTION_ID
NUMBER(22)
Y
461 MTL_TRANSACTIONS_I TRANSACTION_ACTION_ VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2431318343
CV.040 Conversion Data Mapping
NTERFACE_V NAME 2(80)
462 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_TYPE_ID NUMBER(22)
N
463 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_TYPE_NAME
VARCHAR2(80)
Y
464 MTL_TRANSACTIONS_INTERFACE_V
REASON_ID NUMBER(22)
Y 1
465 MTL_TRANSACTIONS_INTERFACE_V
REASON_NAME VARCHAR2(30)
Y
466 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_REFERENCE
VARCHAR2(240)
Y
467 MTL_TRANSACTIONS_INTERFACE_V
TRANSACTION_COST NUMBER(22)
Y
468 MTL_TRANSACTIONS_INTERFACE_V
DISTRIBUTION_ACCOUNT_ID
NUMBER(22)
Y
469 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT1 VARCHAR2(25)
Y
470 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT2 VARCHAR2(25)
Y
471 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT3 VARCHAR2(25)
Y
472 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT4 VARCHAR2(25)
Y
473 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT5 VARCHAR2(25)
Y
474 MTL_TRANSACTIONS_I DST_SEGMENT6 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2441318344
CV.040 Conversion Data Mapping
NTERFACE_V 2(25)
475 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT7 VARCHAR2(25)
Y
476 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT8 VARCHAR2(25)
Y
477 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT9 VARCHAR2(25)
Y
478 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT10 VARCHAR2(25)
Y
479 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT11 VARCHAR2(25)
Y
480 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT12 VARCHAR2(25)
Y
481 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT13 VARCHAR2(25)
Y
482 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT14 VARCHAR2(25)
Y
483 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT15 VARCHAR2(25)
Y
484 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT16 VARCHAR2(25)
Y
485 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT17 VARCHAR2(25)
Y
486 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT18 VARCHAR2(25)
Y
487 MTL_TRANSACTIONS_I DST_SEGMENT19 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2451318345
CV.040 Conversion Data Mapping
NTERFACE_V 2(25)
488 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT20 VARCHAR2(25)
Y
489 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT21 VARCHAR2(25)
Y
490 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT22 VARCHAR2(25)
Y
491 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT23 VARCHAR2(25)
Y
492 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT24 VARCHAR2(25)
Y
493 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT25 VARCHAR2(25)
Y
494 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT26 VARCHAR2(25)
Y
495 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT27 VARCHAR2(25)
Y
496 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT28 VARCHAR2(25)
Y
497 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT29 VARCHAR2(25)
Y
498 MTL_TRANSACTIONS_INTERFACE_V
DST_SEGMENT30 VARCHAR2(25)
Y
499 MTL_TRANSACTIONS_INTERFACE_V
REQUISITION_LINE_ID NUMBER(22)
Y
500 MTL_TRANSACTIONS_I REQUISITION_DISTRIBU NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2461318346
CV.040 Conversion Data Mapping
NTERFACE_V TION_ID 2)
501 MTL_TRANSACTIONS_INTERFACE_V
CURRENCY_CODE VARCHAR2(30)
Y
502 MTL_TRANSACTIONS_INTERFACE_V
CURRENCY_CONVERSION_TYPE
VARCHAR2(30)
Y
503 MTL_TRANSACTIONS_INTERFACE_V
CURRENCY_CONVERSION_RATE
NUMBER(22)
Y
504 MTL_TRANSACTIONS_INTERFACE_V
USSGL_TRANSACTION_CODE
VARCHAR2(30)
Y
505 MTL_TRANSACTIONS_INTERFACE_V
WIP_ENTITY_TYPE NUMBER(22)
Y
506 MTL_TRANSACTIONS_INTERFACE_V
SCHEDULE_ID NUMBER(22)
Y
507 MTL_TRANSACTIONS_INTERFACE_V
EMPLOYEE_CODE VARCHAR2(10)
Y
508 MTL_TRANSACTIONS_INTERFACE_V
DEPARTMENT_ID NUMBER(22)
Y
509 MTL_TRANSACTIONS_INTERFACE_V
DEPARTMENT_CODE VARCHAR2(10)
Y
510 MTL_TRANSACTIONS_INTERFACE_V
SCHEDULE_UPDATE_CODE
NUMBER(22)
Y
511 MTL_TRANSACTIONS_INTERFACE_V
SETUP_TEARDOWN_CODE
NUMBER(22)
Y
512 MTL_TRANSACTIONS_INTERFACE_V
PRIMARY_SWITCH NUMBER(22)
Y
513 MTL_TRANSACTIONS_I MRP_CODE NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2471318347
CV.040 Conversion Data Mapping
NTERFACE_V 2)
514 MTL_TRANSACTIONS_INTERFACE_V
OPERATION_SEQ_NUM NUMBER(22)
Y
515 MTL_TRANSACTIONS_INTERFACE_V
REPETITIVE_LINE_ID NUMBER(22)
Y
516 MTL_TRANSACTIONS_INTERFACE_V
PICKING_LINE_ID NUMBER(22)
Y
517 MTL_TRANSACTIONS_INTERFACE_V
TRX_SOURCE_LINE_ID NUMBER(22)
Y
518 MTL_TRANSACTIONS_INTERFACE_V
TRX_SOURCE_DELIVERY_ID
NUMBER(22)
Y
519 MTL_TRANSACTIONS_INTERFACE_V
DEMAND_ID NUMBER(22)
Y
520 MTL_TRANSACTIONS_INTERFACE_V
CUSTOMER_SHIP_ID NUMBER(22)
Y
521 MTL_TRANSACTIONS_INTERFACE_V
LINE_ITEM_NUM NUMBER(22)
Y
522 MTL_TRANSACTIONS_INTERFACE_V
RECEIVING_DOCUMENT VARCHAR2(10)
Y
523 MTL_TRANSACTIONS_INTERFACE_V
RCV_TRANSACTION_ID NUMBER(22)
Y
524 MTL_TRANSACTIONS_INTERFACE_V
SHIP_TO_LOCATION_ID NUMBER(22)
Y
525 MTL_TRANSACTIONS_INTERFACE_V
ENCUMBRANCE_ACCOUNT
NUMBER(22)
Y
526 MTL_TRANSACTIONS_I ENCUMBRANCE_AMOUN NUMBER(2 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2481318348
CV.040 Conversion Data Mapping
NTERFACE_V T 2)
527 MTL_TRANSACTIONS_INTERFACE_V
VENDOR_LOT_NUMBER VARCHAR2(30)
Y
528 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_SUBINVENTORY
VARCHAR2(10)
Y
529 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_ORGANIZATION
NUMBER(22)
Y
530 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_ORGANIZATION_CODE
VARCHAR2(3)
Y
531 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_ORGANIZATION_NAME
VARCHAR2(240)
Y
532 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_LOCATOR NUMBER(22)
Y
533 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT1 VARCHAR2(40)
Y
534 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT2 VARCHAR2(40)
Y
535 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT3 VARCHAR2(40)
Y
536 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT4 VARCHAR2(40)
Y
537 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT5 VARCHAR2(40)
Y
538 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT6 VARCHAR2(40)
Y
539 MTL_TRANSACTIONS_I XFER_LOC_SEGMENT7 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2491318349
CV.040 Conversion Data Mapping
NTERFACE_V 2(40)
540 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT8 VARCHAR2(40)
Y
541 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT9 VARCHAR2(40)
Y
542 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT10 VARCHAR2(40)
Y
543 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT11 VARCHAR2(40)
Y
544 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT12 VARCHAR2(40)
Y
545 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT13 VARCHAR2(40)
Y
546 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT14 VARCHAR2(40)
Y
547 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT15 VARCHAR2(40)
Y
548 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT16 VARCHAR2(40)
Y
549 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT17 VARCHAR2(40)
Y
550 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT18 VARCHAR2(40)
Y
551 MTL_TRANSACTIONS_INTERFACE_V
XFER_LOC_SEGMENT19 VARCHAR2(40)
Y
552 MTL_TRANSACTIONS_I XFER_LOC_SEGMENT20 VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2501318350
CV.040 Conversion Data Mapping
NTERFACE_V 2(40)
553 MTL_TRANSACTIONS_INTERFACE_V
SHIPMENT_NUMBER VARCHAR2(30)
Y
554 MTL_TRANSACTIONS_INTERFACE_V
TRANSPORTATION_COST
NUMBER(22)
Y
555 MTL_TRANSACTIONS_INTERFACE_V
TRANSPORTATION_ACCOUNT
NUMBER(22)
Y
556 MTL_TRANSACTIONS_INTERFACE_V
TRANSFER_COST NUMBER(22)
Y
557 MTL_TRANSACTIONS_INTERFACE_V
FREIGHT_CODE VARCHAR2(30)
Y
558 MTL_TRANSACTIONS_INTERFACE_V
CONTAINERS NUMBER(22)
Y
559 MTL_TRANSACTIONS_INTERFACE_V
WAYBILL_AIRBILL VARCHAR2(20)
Y
560 MTL_TRANSACTIONS_INTERFACE_V
EXPECTED_ARRIVAL_DATE
DATE(7) Y
561 MTL_TRANSACTIONS_INTERFACE_V
NEW_AVERAGE_COST NUMBER(22)
Y
562 MTL_TRANSACTIONS_INTERFACE_V
VALUE_CHANGE NUMBER(22)
Y
563 MTL_TRANSACTIONS_INTERFACE_V
PERCENTAGE_CHANGE NUMBER(22)
Y
564 MTL_TRANSACTIONS_INTERFACE_V
DEMAND_SOURCE_HEADER_ID
NUMBER(22)
Y
565 MTL_TRANSACTIONS_I DEMAND_SOURCE_LINE VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2511318351
CV.040 Conversion Data Mapping
NTERFACE_V 2(30)
566 MTL_TRANSACTIONS_INTERFACE_V
DEMAND_SOURCE_DELIVERY
VARCHAR2(30)
Y
567 MTL_TRANSACTIONS_INTERFACE_V
NEGATIVE_REQ_FLAG NUMBER(22)
Y
568 MTL_TRANSACTIONS_INTERFACE_V
ERROR_EXPLANATION VARCHAR2(240)
Y
569 MTL_TRANSACTIONS_INTERFACE_V
ERROR_CODE VARCHAR2(240)
Y
570 MTL_TRANSACTIONS_INTERFACE_V
REQUIRED_FLAG VARCHAR2(1)
Y
571 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE_CATEGORY VARCHAR2(30)
Y
572 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE1 VARCHAR2(150)
Y
573 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE2 VARCHAR2(150)
Y
574 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE3 VARCHAR2(150)
Y
575 MTL_TRANSACTIONS_INTERFACE_V
ATTRIBUTE4 VARCHAR2(150)
Y
576 MTL_TRANSACTIONS_INTERFACE_DFV
ROW_ID ROWID(10)
Y
577 MTL_TRANSACTIONS_INTERFACE_DFV
CONTEXT VARCHAR2(30)
Y
578 MTL_TRANSACTIONS_I CONCATENATED_SEGM VARCHAR Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2521318352
CV.040 Conversion Data Mapping
NTERFACE_DFV ENTS 2(0)
-1 -2 -3 -4 -5 -6 -7 -8
Ref.#
Target Application Table Target Application Table Column Target Column
Datatype
Not Null?
Source System Source System Field Name
Source System
Field Datatype
File Name
1MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE15
VARCHAR2(150) Y
2MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE14
VARCHAR2(150) Y
3MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE13
VARCHAR2(150) Y
4MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE12
VARCHAR2(150) Y
5MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE11
VARCHAR2(150) Y
6MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE10
VARCHAR2(150) Y
7MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE9
VARCHAR2(150) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2531318353
CV.040 Conversion Data Mapping
8MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE8
VARCHAR2(150) Y
9MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE7
VARCHAR2(150) Y
10MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE6
VARCHAR2(150) Y
11MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE5
VARCHAR2(150) Y
12MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE4
VARCHAR2(150) Y
13MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE3
VARCHAR2(150) Y
14MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE2
VARCHAR2(150) Y
15MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE1
VARCHAR2(150) Y
16MTL_TRANSACTION_LOTS_INTERFACE ATTRIBUTE_CATEGORY
VARCHAR2(30) Y
17MTL_TRANSACTION_LOTS_INTERFACE REASON_CODE VARCHAR2(4) Y
18MTL_TRANSACTION_LOTS_INTERFACE SUBLOT_NUM
VARCHAR2(32) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2541318354
CV.040 Conversion Data Mapping
19MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE28
VARCHAR2(150) Y
20MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE27
VARCHAR2(150) Y
21MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE26
VARCHAR2(150) Y
22MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE25
VARCHAR2(150) Y
23MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE24
VARCHAR2(150) Y
24MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE23
VARCHAR2(150) Y
25MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE22
VARCHAR2(150) Y
26MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE21
VARCHAR2(150) Y
27MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE20
VARCHAR2(150) Y
28MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE19
VARCHAR2(150) Y
29 MTL_TRANSACTION_LOTS_INTERFACE
C_ATTRIBUTE18 VARCHAR2(15 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2551318355
CV.040 Conversion Data Mapping
0)
30MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE17
VARCHAR2(150) Y
31MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE16
VARCHAR2(150) Y
32MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE15
VARCHAR2(150) Y
33MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE14
VARCHAR2(150) Y
34MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE13
VARCHAR2(150) Y
35MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE12
VARCHAR2(150) Y
36MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE11
VARCHAR2(150) Y
37MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE10
VARCHAR2(150) Y
38MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE9
VARCHAR2(150) Y
39MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE8
VARCHAR2(150) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2561318356
CV.040 Conversion Data Mapping
40MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE7
VARCHAR2(150) Y
41MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE6
VARCHAR2(150) Y
42MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE5
VARCHAR2(150) Y
43MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE4
VARCHAR2(150) Y
44MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE3
VARCHAR2(150) Y
45MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE2
VARCHAR2(150) Y
46MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE1
VARCHAR2(150) Y
47MTL_TRANSACTION_LOTS_INTERFACE LOT_ATTRIBUTE_CATEGORY
VARCHAR2(30) Y
48MTL_TRANSACTION_LOTS_INTERFACE CURL_WRINKLE_FOLD
VARCHAR2(150) Y
49MTL_TRANSACTION_LOTS_INTERFACE WIDTH_UOM VARCHAR2(3) Y
50MTL_TRANSACTION_LOTS_INTERFACE WIDTH NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2571318357
CV.040 Conversion Data Mapping
51MTL_TRANSACTION_LOTS_INTERFACE THICKNESS_UOM VARCHAR2(3) Y
52MTL_TRANSACTION_LOTS_INTERFACE THICKNESS NUMBER(22) Y
53MTL_TRANSACTION_LOTS_INTERFACE RECYCLED_CONTENT NUMBER(22) Y
54MTL_TRANSACTION_LOTS_INTERFACE LENGTH_UOM VARCHAR2(3) Y
55MTL_TRANSACTION_LOTS_INTERFACE LENGTH NUMBER(22) Y
56MTL_TRANSACTION_LOTS_INTERFACE BEST_BY_DATE DATE(7) Y
57MTL_TRANSACTION_LOTS_INTERFACE KILL_DATE DATE(7) Y
58MTL_TRANSACTION_LOTS_INTERFACE PLACE_OF_ORIGIN
VARCHAR2(150) Y
59MTL_TRANSACTION_LOTS_INTERFACE VOLUME_UOM VARCHAR2(3) Y
60MTL_TRANSACTION_LOTS_INTERFACE VOLUME NUMBER(22) Y
61MTL_TRANSACTION_LOTS_INTERFACE COLOR
VARCHAR2(150) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2581318358
CV.040 Conversion Data Mapping
62MTL_TRANSACTION_LOTS_INTERFACE ITEM_SIZE NUMBER(22) Y
63MTL_TRANSACTION_LOTS_INTERFACE AGE NUMBER(22) Y
64MTL_TRANSACTION_LOTS_INTERFACE RETEST_DATE DATE(7) Y
65MTL_TRANSACTION_LOTS_INTERFACE STATUS_ID NUMBER(22) Y
66MTL_TRANSACTION_LOTS_INTERFACE MATURITY_DATE DATE(7) Y
67MTL_TRANSACTION_LOTS_INTERFACE CHANGE_DATE DATE(7) Y
68MTL_TRANSACTION_LOTS_INTERFACE GRADE_CODE
VARCHAR2(150) Y
69MTL_TRANSACTION_LOTS_INTERFACE DATE_CODE
VARCHAR2(150) Y
70MTL_TRANSACTION_LOTS_INTERFACE ORIGINATION_DATE DATE(7) Y
71MTL_TRANSACTION_LOTS_INTERFACE COUNTRY_OF_ORIGIN
VARCHAR2(30) Y
72MTL_TRANSACTION_LOTS_INTERFACE SUPPLIER_LOT_NUMBER
VARCHAR2(150) Y
73 MTL_TRANSACTION_LOTS_INTERFACE
VENDOR_NAME VARCHAR2(24 Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2591318359
CV.040 Conversion Data Mapping
0)
74MTL_TRANSACTION_LOTS_INTERFACE DESCRIPTION
VARCHAR2(256) Y
75MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE30 NUMBER(22) Y
76MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE29 NUMBER(22) Y
77MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE28 NUMBER(22) Y
78MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE27 NUMBER(22) Y
79MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE26 NUMBER(22) Y
80MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE25 NUMBER(22) Y
81MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE24 NUMBER(22) Y
82MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE23 NUMBER(22) Y
83MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE22 NUMBER(22) Y
84MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE21 NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2601318360
CV.040 Conversion Data Mapping
85MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE20 NUMBER(22) Y
86MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE19 NUMBER(22) Y
87MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE18 NUMBER(22) Y
88MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE17 NUMBER(22) Y
89MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE16 NUMBER(22) Y
90MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE15 NUMBER(22) Y
91MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE14 NUMBER(22) Y
92MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE13 NUMBER(22) Y
93MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE12 NUMBER(22) Y
94MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE11 NUMBER(22) Y
95MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE10 NUMBER(22) Y
96MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE9 NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2611318361
CV.040 Conversion Data Mapping
97MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE8 NUMBER(22) Y
98MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE7 NUMBER(22) Y
99MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE6 NUMBER(22) Y
100MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE5 NUMBER(22) Y
101MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE4 NUMBER(22) Y
102MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE3 NUMBER(22) Y
103MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE2 NUMBER(22) Y
104MTL_TRANSACTION_LOTS_INTERFACE N_ATTRIBUTE1 NUMBER(22) Y
105MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE20 DATE(7) Y
106MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE19 DATE(7) Y
107MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE18 DATE(7) Y
108MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE17 DATE(7) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2621318362
CV.040 Conversion Data Mapping
109MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE16 DATE(7) Y
110MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE15 DATE(7) Y
111MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE14 DATE(7) Y
112MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE13 DATE(7) Y
113MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE12 DATE(7) Y
114MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE11 DATE(7) Y
115MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE10 DATE(7) Y
116MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE9 DATE(7) Y
117MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE8 DATE(7) Y
118MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE7 DATE(7) Y
119MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE6 DATE(7) Y
120MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE5 DATE(7) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2631318363
CV.040 Conversion Data Mapping
121MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE4 DATE(7) Y
122MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE3 DATE(7) Y
123MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE2 DATE(7) Y
124MTL_TRANSACTION_LOTS_INTERFACE D_ATTRIBUTE1 DATE(7) Y
125MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE30
VARCHAR2(150) Y
126MTL_TRANSACTION_LOTS_INTERFACE C_ATTRIBUTE29
VARCHAR2(150) Y
127MTL_TRANSACTION_LOTS_INTERFACE EXPIRATION_ACTION_DATE DATE(7) Y
128MTL_TRANSACTION_LOTS_INTERFACE EXPIRATION_ACTION_CODE
VARCHAR2(32) Y
129MTL_TRANSACTION_LOTS_INTERFACE TERRITORY_CODE
VARCHAR2(30) Y
130MTL_TRANSACTION_LOTS_INTERFACE VENDOR_ID NUMBER(22) Y
131MTL_TRANSACTION_LOTS_INTERFACE
SECONDARY_TRANSACTION_QUANTITY NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2641318364
CV.040 Conversion Data Mapping
132MTL_TRANSACTION_LOTS_INTERFACE PRODUCT_TRANSACTION_ID NUMBER(22) Y
133MTL_TRANSACTION_LOTS_INTERFACE PRODUCT_CODE VARCHAR2(5) Y
134MTL_TRANSACTION_LOTS_INTERFACE PROCESS_FLAG VARCHAR2(1) Y
135MTL_TRANSACTION_LOTS_INTERFACE ERROR_CODE
VARCHAR2(240) Y
136MTL_TRANSACTION_LOTS_INTERFACE SERIAL_TRANSACTION_TEMP_ID NUMBER(22) Y
137MTL_TRANSACTION_LOTS_INTERFACE PRIMARY_QUANTITY NUMBER(22) Y
xxx_stag_mtl_trans_tbl
PRIMARY_QUANTITY number
138MTL_TRANSACTION_LOTS_INTERFACE TRANSACTION_QUANTITY NUMBER(22) N
xxx_stag_mtl_trans_tbl
PRIMARY_QUANTITY number
139MTL_TRANSACTION_LOTS_INTERFACE LOT_EXPIRATION_DATE DATE(7) Y
140MTL_TRANSACTION_LOTS_INTERFACE LOT_NUMBER
VARCHAR2(80) N
xxx_stag_mtl_trans_tbl lot_number
varchar2(80)
141MTL_TRANSACTION_LOTS_INTERFACE PROGRAM_UPDATE_DATE DATE(7) Y
142MTL_TRANSACTION_LOTS_INTERFACE PROGRAM_ID NUMBER(22) Y
143 MTL_TRANSACTION_LOTS_INTERF PROGRAM_APPLICATION_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2651318365
CV.040 Conversion Data Mapping
ACE
144MTL_TRANSACTION_LOTS_INTERFACE REQUEST_ID NUMBER(22) Y
145MTL_TRANSACTION_LOTS_INTERFACE LAST_UPDATE_LOGIN NUMBER(22) Y
146MTL_TRANSACTION_LOTS_INTERFACE CREATED_BY NUMBER(22) N
147MTL_TRANSACTION_LOTS_INTERFACE CREATION_DATE DATE(7) N
148MTL_TRANSACTION_LOTS_INTERFACE LAST_UPDATED_BY NUMBER(22) N
149MTL_TRANSACTION_LOTS_INTERFACE LAST_UPDATE_DATE DATE(7) N
150MTL_TRANSACTION_LOTS_INTERFACE SOURCE_LINE_ID NUMBER(22) Y
151MTL_TRANSACTION_LOTS_INTERFACE SOURCE_CODE
VARCHAR2(30) Y
152MTL_TRANSACTION_LOTS_INTERFACE TRANSACTION_INTERFACE_ID NUMBER(22) N
153MTL_TRANSACTION_LOTS_INTERFACE PARENT_OBJECT_NUMBER2
VARCHAR2(240) Y
154MTL_TRANSACTION_LOTS_INTERFACE PARENT_OBJECT_ID2 NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2661318366
CV.040 Conversion Data Mapping
155MTL_TRANSACTION_LOTS_INTERFACE PARENT_OBJECT_TYPE2 NUMBER(22) Y
156MTL_TRANSACTION_LOTS_INTERFACE PARENT_ITEM_ID NUMBER(22) Y
157MTL_TRANSACTION_LOTS_INTERFACE PARENT_OBJECT_NUMBER
VARCHAR2(240) Y
158MTL_TRANSACTION_LOTS_INTERFACE PARENT_OBJECT_ID NUMBER(22) Y
159MTL_TRANSACTION_LOTS_INTERFACE PARENT_OBJECT_TYPE NUMBER(22) Y
160MTL_TRANSACTION_LOTS_INTERFACE REASON_ID NUMBER(22) Y
161MTL_TRANSACTION_LOTS_INTERFACE PARENT_LOT_NUMBER
VARCHAR2(80) Y
162MTL_TRANSACTION_LOTS_INTERFACE ORIGINATION_TYPE NUMBER(22) Y
163MTL_TRANSACTION_LOTS_INTERFACE HOLD_DATE DATE(7) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2671318367
CV.040 Conversion Data Mapping
Extract File Layout
Below is a table documenting the extract file schema of staging table xxx_stag_mtl_trans_tbl
Field Name Datatype Position:
Position:
Oracle Table Oracle Column Comments
From To
ATTRIBUTE14VARCHAR2(150) Y
ATTRIBUTE13VARCHAR2(150) Y
ATTRIBUTE12VARCHAR2(150) Y
ATTRIBUTE11VARCHAR2(150) Y
ATTRIBUTE10VARCHAR2(150) Y
ATTRIBUTE9VARCHAR2(150) Y
ATTRIBUTE8VARCHAR2(150) Y
ATTRIBUTE7VARCHAR2(150) Y
ATTRIBUTE6VARCHAR2(150) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2681318368
CV.040 Conversion Data Mapping
ATTRIBUTE5VARCHAR2(150) Y
ATTRIBUTE4VARCHAR2(150) Y
ATTRIBUTE3VARCHAR2(150) Y
ATTRIBUTE2VARCHAR2(150) Y
ATTRIBUTE1VARCHAR2(150) Y
ATTRIBUTE_CATEGORY VARCHAR2(30) Y
REQUIRED_FLAG VARCHAR2(1) Y
ERROR_CODEVARCHAR2(240) Y
SHIPPABLE_FLAG VARCHAR2(1) Y
ERROR_EXPLANATIONVARCHAR2(240) Y
NEGATIVE_REQ_FLAG NUMBER(22) Y
DEMAND_SOURCE_DELIVERY VARCHAR2(30) Y
DEMAND_SOURCE_LINE VARCHAR2(30) Y
DEMAND_SOURCE_HEADER_ID NUMBER(22) Y
PERCENTAGE_CHANGE NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2691318369
CV.040 Conversion Data Mapping
VALUE_CHANGE NUMBER(22) Y
NEW_AVERAGE_COST NUMBER(22) Y
EXPECTED_ARRIVAL_DATE DATE(7) Y
WAYBILL_AIRBILL VARCHAR2(20) Y
CONTAINERS NUMBER(22) Y
FREIGHT_CODE VARCHAR2(30) Y
TRANSFER_COST NUMBER(22) Y
TRANSPORTATION_ACCOUNT NUMBER(22) Y
TRANSPORTATION_COST NUMBER(22) Y
SHIPMENT_NUMBER VARCHAR2(30) Y
XFER_LOC_SEGMENT20 VARCHAR2(40) Y
XFER_LOC_SEGMENT19 VARCHAR2(40) Y
XFER_LOC_SEGMENT18 VARCHAR2(40) Y
XFER_LOC_SEGMENT17 VARCHAR2(40) Y
XFER_LOC_SEGMENT16 VARCHAR2(40) Y
XFER_LOC_SEGMENT15 VARCHAR2(40) Y
XFER_LOC_SEGMENT14 VARCHAR2(40) Y
XFER_LOC_SEGMENT13 VARCHAR2(40) Y
XFER_LOC_SEGMENT12 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2701318370
CV.040 Conversion Data Mapping
XFER_LOC_SEGMENT11 VARCHAR2(40) Y
XFER_LOC_SEGMENT10 VARCHAR2(40) Y
XFER_LOC_SEGMENT9 VARCHAR2(40) Y
XFER_LOC_SEGMENT8 VARCHAR2(40) Y
XFER_LOC_SEGMENT7 VARCHAR2(40) Y
XFER_LOC_SEGMENT6 VARCHAR2(40) Y
XFER_LOC_SEGMENT5 VARCHAR2(40) Y
XFER_LOC_SEGMENT4 VARCHAR2(40) Y
XFER_LOC_SEGMENT3 VARCHAR2(40) Y
XFER_LOC_SEGMENT2 VARCHAR2(40) Y
XFER_LOC_SEGMENT1 VARCHAR2(40) Y
TRANSFER_LOCATOR NUMBER(22) Y
TRANSFER_ORGANIZATION NUMBER(22) Y
TRANSFER_SUBINVENTORY VARCHAR2(10) Y
VENDOR_LOT_NUMBER VARCHAR2(30) Y
ENCUMBRANCE_AMOUNT NUMBER(22) Y
ENCUMBRANCE_ACCOUNT NUMBER(22) Y
SHIP_TO_LOCATION_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2711318371
CV.040 Conversion Data Mapping
RCV_TRANSACTION_ID NUMBER(22) Y
RECEIVING_DOCUMENT VARCHAR2(10) Y
LINE_ITEM_NUM NUMBER(22) Y
CUSTOMER_SHIP_ID NUMBER(22) Y
DEMAND_ID NUMBER(22) Y
TRX_SOURCE_DELIVERY_ID NUMBER(22) Y
TRX_SOURCE_LINE_ID NUMBER(22) Y
PICKING_LINE_ID NUMBER(22) Y
REPETITIVE_LINE_ID NUMBER(22) Y
OPERATION_SEQ_NUM NUMBER(22) Y
MRP_CODE NUMBER(22) Y
PRIMARY_SWITCH NUMBER(22) Y
SETUP_TEARDOWN_CODE NUMBER(22) Y
SCHEDULE_UPDATE_CODE NUMBER(22) Y
DEPARTMENT_ID NUMBER(22) Y
EMPLOYEE_CODE VARCHAR2(10) Y
SCHEDULE_ID NUMBER(22) Y
WIP_ENTITY_TYPE NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2721318372
CV.040 Conversion Data Mapping
USSGL_TRANSACTION_CODE VARCHAR2(30) Y
CURRENCY_CONVERSION_RATE NUMBER(22) Y
CURRENCY_CONVERSION_TYPE VARCHAR2(30) Y
CURRENCY_CONVERSION_DATE DATE(7) Y
CURRENCY_CODE VARCHAR2(30) Y
REQUISITION_LINE_ID NUMBER(22) Y
DST_SEGMENT30 VARCHAR2(25) Y
DST_SEGMENT29 VARCHAR2(25) Y
DST_SEGMENT28 VARCHAR2(25) Y
DST_SEGMENT27 VARCHAR2(25) Y
DST_SEGMENT26 VARCHAR2(25) Y
DST_SEGMENT25 VARCHAR2(25) Y
DST_SEGMENT24 VARCHAR2(25) Y
DST_SEGMENT23 VARCHAR2(25) Y
DST_SEGMENT22 VARCHAR2(25) Y
DST_SEGMENT21 VARCHAR2(25) Y
DST_SEGMENT20 VARCHAR2(25) Y
DST_SEGMENT19 VARCHAR2(25) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2731318373
CV.040 Conversion Data Mapping
DST_SEGMENT18 VARCHAR2(25) Y
DST_SEGMENT17 VARCHAR2(25) Y
DST_SEGMENT16 VARCHAR2(25) Y
DST_SEGMENT15 VARCHAR2(25) Y
DST_SEGMENT14 VARCHAR2(25) Y
DST_SEGMENT13 VARCHAR2(25) Y
DST_SEGMENT12 VARCHAR2(25) Y
DST_SEGMENT11 VARCHAR2(25) Y
DST_SEGMENT10 VARCHAR2(25) Y
DST_SEGMENT9 VARCHAR2(25) Y
DST_SEGMENT8 VARCHAR2(25) Y
DST_SEGMENT7 VARCHAR2(25) Y
DST_SEGMENT6 VARCHAR2(25) Y
DST_SEGMENT5 VARCHAR2(25) Y
DST_SEGMENT4 VARCHAR2(25) Y
FROM_SERIAL NUMBER(22) Y
ROW_STATUS VARCHAR2(1) Y
AAA VARCHAR2(10) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2741318374
CV.040 Conversion Data Mapping
MATERIAL_EXPENSE_ACCOUNT NUMBER(22) Y
TRANSFER_PRICE NUMBER(22) Y
RELIEVE_HIGH_LEVEL_RSV_FLAG VARCHAR2(1) Y
RELIEVE_RESERVATIONS_FLAG VARCHAR2(1) Y
WIP_SUPPLY_TYPE NUMBER(22) Y
COMPLETION_TRANSACTION_ID NUMBER(22) Y
MOVE_TRANSACTION_ID NUMBER(22) Y
REBUILD_JOB_NAMEVARCHAR2(240) Y
REBUILD_ACTIVITY_ID NUMBER(22) Y
REBUILD_SERIAL_NUMBER VARCHAR2(30) Y
REBUILD_ITEM_ID NUMBER(22) Y
TRANSACTION_BATCH_SEQ NUMBER(22) Y
TRANSACTION_BATCH_ID NUMBER(22) Y
REPRESENTATIVE_LOT_NUMBER VARCHAR2(80) Y
TRANSACTION_GROUP_SEQ NUMBER(22) Y
TRANSACTION_GROUP_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2751318375
CV.040 Conversion Data Mapping
SECONDARY_TRANSACTION_QUANTITY NUMBER(22) Y
SECONDARY_UOM_CODEVARCHAR2(240) Y
TRANSFER_PLANNING_TP_TYPE NUMBER(22) Y
XFR_PLANNING_ORGANIZATION_ID NUMBER(22) Y
PLANNING_TP_TYPE NUMBER(22) Y
PLANNING_ORGANIZATION_ID NUMBER(22) Y
TRANSFER_OWNING_TP_TYPE NUMBER(22) Y
XFR_OWNING_ORGANIZATION_ID NUMBER(22) Y
OWNING_TP_TYPE NUMBER(22) Y
OWNING_ORGANIZATION_ID NUMBER(22) Y
TRANSFER_ORGANIZATION_TYPE NUMBER(22) Y
ORGANIZATION_TYPE NUMBER(22) Y
XML_DOCUMENT_IDVARCHAR2(240) Y
CONTENT_LPN_ID NUMBER(22) Y
TRANSFER_LPN_ID NUMBER(22) Y
LPN_ID NUMBER(22) Y
TRANSFER_COST_GROUP_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2761318376
CV.040 Conversion Data Mapping
SOURCE_LOT_NUMBER VARCHAR2(80) Y
COST_TYPE_ID NUMBER(22) Y
ORG_COST_GROUP_ID NUMBER(22) Y
SCHEDULED_PAYBACK_DATE DATE(7) Y
END_ITEM_UNIT_NUMBER VARCHAR2(60) Y
OVERCOMPLETION_TRANSACTION_ID NUMBER(22) Y
OVERCOMPLETION_PRIMARY_QTY NUMBER(22) Y
OVERCOMPLETION_TRANSACTION_QTY NUMBER(22) Y
QA_COLLECTION_ID NUMBER(22) Y
KANBAN_CARD_ID NUMBER(22) Y
COST_GROUP_ID NUMBER(22) Y
FLOW_SCHEDULE VARCHAR2(1) Y
SCHEDULED_FLAG NUMBER(22) Y
SCHEDULE_NUMBER VARCHAR2(30) Y
BUILD_SEQUENCE NUMBER(22) Y
SCHEDULE_GROUP NUMBER(22) Y
SUBSTITUTION_ITEM_ID NUMBER(22) Y
SUBSTITUTION_TYPE_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2771318377
CV.040 Conversion Data Mapping
PARENT_ID NUMBER(22) Y
DEMAND_CLASS VARCHAR2(30) Y
ACCOUNTING_CLASS VARCHAR2(10) Y
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) Y
ALTERNATE_BOM_DESIGNATOR VARCHAR2(10) Y
ROUTING_REVISION_DATE DATE(7) Y
BOM_REVISION_DATE DATE(7) Y
ROUTING_REVISION VARCHAR2(3) Y
BOM_REVISION VARCHAR2(3) Y
OVERHEAD_ACCOUNT NUMBER(22) Y
OUTSIDE_PROCESSING_ACCOUNT NUMBER(22) Y
RESOURCE_ACCOUNT NUMBER(22) Y
MATERIAL_OVERHEAD_ACCOUNT NUMBER(22) Y
MATERIAL_ACCOUNT NUMBER(22) Y
TRANSACTION_SEQUENCE_ID NUMBER(22) Y
TRANSFER_PERCENTAGE NUMBER(22) Y
FINAL_COMPLETION_FLAG VARCHAR2(1) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2781318378
CV.040 Conversion Data Mapping
EXPENDITURE_TYPE VARCHAR2(30) Y
PA_EXPENDITURE_ORG_ID NUMBER(22) Y
SOURCE_PROJECT_ID NUMBER(22) Y
TO_PROJECT_ID NUMBER(22) Y
PROJECT_ID NUMBER(22) Y
SOURCE_TASK_ID NUMBER(22) Y
TO_TASK_ID NUMBER(22) Y
TASK_ID NUMBER(22) Y
LOCATOR_NAMEVARCHAR2(2000) Y mtl_transactions_interface LOCATOR_NAME
INVENTORY_ITEMVARCHAR2(2000) Y
SHIPPED_QUANTITY NUMBER(22) Y
RESERVATION_QUANTITY NUMBER(22) Y
MOVEMENT_ID NUMBER(22) Y
REQUISITION_DISTRIBUTION_ID NUMBER(22) Y
ATTRIBUTE15VARCHAR2(150) Y
DST_SEGMENT3 VARCHAR2(25) Y
DST_SEGMENT2 VARCHAR2(25) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2791318379
CV.040 Conversion Data Mapping
DST_SEGMENT1 VARCHAR2(25) Y
DISTRIBUTION_ACCOUNT_ID NUMBER(22) Y
TRANSACTION_COST NUMBER(22) Y
TRANSACTION_REFERENCEVARCHAR2(240) Y
REASON_ID NUMBER(22) Y
TRANSACTION_TYPE_ID NUMBER(22) Y
TRANSACTION_ACTION_ID NUMBER(22) Y
TRANSACTION_SOURCE_TYPE_ID NUMBER(22) Y
TRANSACTION_SOURCE_NAME VARCHAR2(80) Y
DSP_SEGMENT30 VARCHAR2(40) Y
DSP_SEGMENT29 VARCHAR2(40) Y
DSP_SEGMENT28 VARCHAR2(40) Y
DSP_SEGMENT27 VARCHAR2(40) Y
DSP_SEGMENT26 VARCHAR2(40) Y
DSP_SEGMENT25 VARCHAR2(40) Y
DSP_SEGMENT24 VARCHAR2(40) Y
DSP_SEGMENT23 VARCHAR2(40) Y
DSP_SEGMENT22 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2801318380
CV.040 Conversion Data Mapping
DSP_SEGMENT21 VARCHAR2(40) Y
DSP_SEGMENT20 VARCHAR2(40) Y
DSP_SEGMENT19 VARCHAR2(40) Y
DSP_SEGMENT18 VARCHAR2(40) Y
DSP_SEGMENT17 VARCHAR2(40) Y
DSP_SEGMENT16 VARCHAR2(40) Y
DSP_SEGMENT15 VARCHAR2(40) Y
DSP_SEGMENT14 VARCHAR2(40) Y
DSP_SEGMENT13 VARCHAR2(40) Y
DSP_SEGMENT12 VARCHAR2(40) Y
DSP_SEGMENT11 VARCHAR2(40) Y
DSP_SEGMENT10 VARCHAR2(40) Y
DSP_SEGMENT9 VARCHAR2(40) Y
DSP_SEGMENT8 VARCHAR2(40) Y
DSP_SEGMENT7 VARCHAR2(40) Y
DSP_SEGMENT6 VARCHAR2(40) Y
DSP_SEGMENT5 VARCHAR2(40) Y
DSP_SEGMENT4 VARCHAR2(40) Y
DSP_SEGMENT3 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2811318381
CV.040 Conversion Data Mapping
DSP_SEGMENT2 VARCHAR2(40) Y
DSP_SEGMENT1 VARCHAR2(40) Y
TRANSACTION_SOURCE_ID NUMBER(22) Y
LOC_SEGMENT20 VARCHAR2(40) Y
LOC_SEGMENT19 VARCHAR2(40) Y
LOC_SEGMENT18 VARCHAR2(40) Y
LOC_SEGMENT17 VARCHAR2(40) Y
LOC_SEGMENT16 VARCHAR2(40) Y
LOC_SEGMENT15 VARCHAR2(40) Y
LOC_SEGMENT14 VARCHAR2(40) Y
LOC_SEGMENT13 VARCHAR2(40) Y
LOC_SEGMENT12 VARCHAR2(40) Y
LOC_SEGMENT11 VARCHAR2(40) Y
LOC_SEGMENT10 VARCHAR2(40) Y
LOC_SEGMENT9 VARCHAR2(40) Y
LOC_SEGMENT8 VARCHAR2(40) Y
LOC_SEGMENT7 VARCHAR2(40) Y
LOC_SEGMENT6 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2821318382
CV.040 Conversion Data Mapping
LOC_SEGMENT5 VARCHAR2(40) Y
LOC_SEGMENT4 VARCHAR2(40) Y
LOC_SEGMENT3 VARCHAR2(40) Y
LOC_SEGMENT2 VARCHAR2(40) Y
LOC_SEGMENT1 VARCHAR2(40) Y
LOCATOR_ID NUMBER(22) Y
SUBINVENTORY_CODE VARCHAR2(10) Y MTL_TRANSACTIONS_INTERFACAESUBINVENTORY_CODE
ACCT_PERIOD_ID NUMBER(22) Y
TRANSACTION_DATE DATE(7) Y
TRANSACTION_UOM VARCHAR2(3) Y
PRIMARY_QUANTITY NUMBER(22) Y MTL_TRANSACTIONS_INTERFACE PRIMARY_QUANTITY
TRANSACTION_QUANTITY NUMBER(22) Y
ORGANIZATION_ID NUMBER(22) Y
REVISION VARCHAR2(3) Y
ITEM_SEGMENT20 VARCHAR2(40) Y
ITEM_SEGMENT19 VARCHAR2(40) Y
ITEM_SEGMENT18 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2831318383
CV.040 Conversion Data Mapping
ITEM_SEGMENT17 VARCHAR2(40) Y
ITEM_SEGMENT16 VARCHAR2(40) Y
ITEM_SEGMENT15 VARCHAR2(40) Y
ITEM_SEGMENT14 VARCHAR2(40) Y
ITEM_SEGMENT13 VARCHAR2(40) Y
ITEM_SEGMENT12 VARCHAR2(40) Y
ITEM_SEGMENT11 VARCHAR2(40) Y
ITEM_SEGMENT10 VARCHAR2(40) Y
ITEM_SEGMENT9 VARCHAR2(40) Y
ITEM_SEGMENT8 VARCHAR2(40) Y
ITEM_SEGMENT7 VARCHAR2(40) Y
ITEM_SEGMENT6 VARCHAR2(40) Y
ITEM_SEGMENT5 VARCHAR2(40) Y
ITEM_SEGMENT4 VARCHAR2(40) Y
ITEM_SEGMENT3 VARCHAR2(40) Y
ITEM_SEGMENT2 VARCHAR2(40) Y
ITEM_SEGMENT1 VARCHAR2(40) Y mtl_transactions_interface ITEM_SEGMENT1
INVENTORY_ITEM_ID NUMBER(22) Y
PROGRAM_UPDATE_DATE DATE(7) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2841318384
CV.040 Conversion Data Mapping
PROGRAM_ID NUMBER(22) Y
PROGRAM_APPLICATION_ID NUMBER(22) Y
REQUEST_ID NUMBER(22) Y
LAST_UPDATE_LOGIN NUMBER(22) Y
CREATED_BY NUMBER(22) Y
CREATION_DATE DATE(7) Y
LAST_UPDATED_BY NUMBER(22) Y
LAST_UPDATE_DATE DATE(7) Y
LOCK_FLAG NUMBER(22) Y
TRANSACTION_MODE NUMBER(22) Y
VALIDATION_REQUIRED NUMBER(22) Y
PROCESS_FLAG NUMBER(22) Y
SOURCE_HEADER_ID NUMBER(22) Y
SOURCE_LINE_ID NUMBER(22) Y
SOURCE_CODE VARCHAR2(30) Y
TRANSACTION_HEADER_ID NUMBER(22) Y
TRANSACTION_INTERFACE_ID NUMBER(22) Y
LOT_NUMBER VARCHAR2(25) Y MTL_LOTS_TRANSACTION_INTERF LOT_NUMBER
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2851318385
CV.040 Conversion Data Mapping
ACE
ORGN_CODE VARCHAR2(40) Y mtl_transactions_interface organization_id derived
Field Name Datatype Position:
Position:
Oracle Table Oracle Column Comments
From To
ATTRIBUTE14VARCHAR2(150) Y
ATTRIBUTE13VARCHAR2(150) Y
ATTRIBUTE12VARCHAR2(150) Y
ATTRIBUTE11VARCHAR2(150) Y
ATTRIBUTE10VARCHAR2(150) Y
ATTRIBUTE9VARCHAR2(150) Y
ATTRIBUTE8VARCHAR2(150) Y
ATTRIBUTE7VARCHAR2(150) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2861318386
CV.040 Conversion Data Mapping
ATTRIBUTE6VARCHAR2(150) Y
ATTRIBUTE5VARCHAR2(150) Y
ATTRIBUTE4VARCHAR2(150) Y
ATTRIBUTE3VARCHAR2(150) Y
ATTRIBUTE2VARCHAR2(150) Y
ATTRIBUTE1VARCHAR2(150) Y
ATTRIBUTE_CATEGORY VARCHAR2(30) Y
REQUIRED_FLAG VARCHAR2(1) Y
ERROR_CODEVARCHAR2(240) Y
SHIPPABLE_FLAG VARCHAR2(1) Y
ERROR_EXPLANATIONVARCHAR2(240) Y
NEGATIVE_REQ_FLAG NUMBER(22) Y
DEMAND_SOURCE_DELIVERY VARCHAR2(30) Y
DEMAND_SOURCE_LINE VARCHAR2(30) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2871318387
CV.040 Conversion Data Mapping
DEMAND_SOURCE_HEADER_ID NUMBER(22) Y
PERCENTAGE_CHANGE NUMBER(22) Y
VALUE_CHANGE NUMBER(22) Y
NEW_AVERAGE_COST NUMBER(22) Y
EXPECTED_ARRIVAL_DATE DATE(7) Y
WAYBILL_AIRBILL VARCHAR2(20) Y
CONTAINERS NUMBER(22) Y
FREIGHT_CODE VARCHAR2(30) Y
TRANSFER_COST NUMBER(22) Y
TRANSPORTATION_ACCOUNT NUMBER(22) Y
TRANSPORTATION_COST NUMBER(22) Y
SHIPMENT_NUMBER VARCHAR2(30) Y
XFER_LOC_SEGMENT20 VARCHAR2(40) Y
XFER_LOC_SEGMENT19 VARCHAR2(40) Y
XFER_LOC_SEGMENT18 VARCHAR2(40) Y
XFER_LOC_SEGMENT17 VARCHAR2(40) Y
XFER_LOC_SEGMENT16 VARCHAR2(40) Y
XFER_LOC_SEGMENT15 VARCHAR2(40) Y
XFER_LOC_SEGMENT14 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2881318388
CV.040 Conversion Data Mapping
XFER_LOC_SEGMENT13 VARCHAR2(40) Y
XFER_LOC_SEGMENT12 VARCHAR2(40) Y
XFER_LOC_SEGMENT11 VARCHAR2(40) Y
XFER_LOC_SEGMENT10 VARCHAR2(40) Y
XFER_LOC_SEGMENT9 VARCHAR2(40) Y
XFER_LOC_SEGMENT8 VARCHAR2(40) Y
XFER_LOC_SEGMENT7 VARCHAR2(40) Y
XFER_LOC_SEGMENT6 VARCHAR2(40) Y
XFER_LOC_SEGMENT5 VARCHAR2(40) Y
XFER_LOC_SEGMENT4 VARCHAR2(40) Y
XFER_LOC_SEGMENT3 VARCHAR2(40) Y
XFER_LOC_SEGMENT2 VARCHAR2(40) Y
XFER_LOC_SEGMENT1 VARCHAR2(40) Y
TRANSFER_LOCATOR NUMBER(22) Y
TRANSFER_ORGANIZATION NUMBER(22) Y
TRANSFER_SUBINVENTORY VARCHAR2(10) Y
VENDOR_LOT_NUMBER VARCHAR2(30) Y
ENCUMBRANCE_AMOUNT NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2891318389
CV.040 Conversion Data Mapping
ENCUMBRANCE_ACCOUNT NUMBER(22) Y
SHIP_TO_LOCATION_ID NUMBER(22) Y
RCV_TRANSACTION_ID NUMBER(22) Y
RECEIVING_DOCUMENT VARCHAR2(10) Y
LINE_ITEM_NUM NUMBER(22) Y
CUSTOMER_SHIP_ID NUMBER(22) Y
DEMAND_ID NUMBER(22) Y
TRX_SOURCE_DELIVERY_ID NUMBER(22) Y
TRX_SOURCE_LINE_ID NUMBER(22) Y
PICKING_LINE_ID NUMBER(22) Y
REPETITIVE_LINE_ID NUMBER(22) Y
OPERATION_SEQ_NUM NUMBER(22) Y
MRP_CODE NUMBER(22) Y
PRIMARY_SWITCH NUMBER(22) Y
SETUP_TEARDOWN_CODE NUMBER(22) Y
SCHEDULE_UPDATE_CODE NUMBER(22) Y
DEPARTMENT_ID NUMBER(22) Y
EMPLOYEE_CODE VARCHAR2(10) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2901318390
CV.040 Conversion Data Mapping
SCHEDULE_ID NUMBER(22) Y
WIP_ENTITY_TYPE NUMBER(22) Y
USSGL_TRANSACTION_CODE VARCHAR2(30) Y
CURRENCY_CONVERSION_RATE NUMBER(22) Y
CURRENCY_CONVERSION_TYPE VARCHAR2(30) Y
CURRENCY_CONVERSION_DATE DATE(7) Y
CURRENCY_CODE VARCHAR2(30) Y
REQUISITION_LINE_ID NUMBER(22) Y
DST_SEGMENT30 VARCHAR2(25) Y
DST_SEGMENT29 VARCHAR2(25) Y
DST_SEGMENT28 VARCHAR2(25) Y
DST_SEGMENT27 VARCHAR2(25) Y
DST_SEGMENT26 VARCHAR2(25) Y
DST_SEGMENT25 VARCHAR2(25) Y
DST_SEGMENT24 VARCHAR2(25) Y
DST_SEGMENT23 VARCHAR2(25) Y
DST_SEGMENT22 VARCHAR2(25) Y
DST_SEGMENT21 VARCHAR2(25) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2911318391
CV.040 Conversion Data Mapping
DST_SEGMENT20 VARCHAR2(25) Y
DST_SEGMENT19 VARCHAR2(25) Y
DST_SEGMENT18 VARCHAR2(25) Y
DST_SEGMENT17 VARCHAR2(25) Y
DST_SEGMENT16 VARCHAR2(25) Y
DST_SEGMENT15 VARCHAR2(25) Y
DST_SEGMENT14 VARCHAR2(25) Y
DST_SEGMENT13 VARCHAR2(25) Y
DST_SEGMENT12 VARCHAR2(25) Y
DST_SEGMENT11 VARCHAR2(25) Y
DST_SEGMENT10 VARCHAR2(25) Y
DST_SEGMENT9 VARCHAR2(25) Y
DST_SEGMENT8 VARCHAR2(25) Y
DST_SEGMENT7 VARCHAR2(25) Y
DST_SEGMENT6 VARCHAR2(25) Y
DST_SEGMENT5 VARCHAR2(25) Y
DST_SEGMENT4 VARCHAR2(25) Y
FROM_SERIAL NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2921318392
CV.040 Conversion Data Mapping
ROW_STATUS VARCHAR2(1) Y
AAA VARCHAR2(10) Y
MATERIAL_EXPENSE_ACCOUNT NUMBER(22) Y
TRANSFER_PRICE NUMBER(22) Y
RELIEVE_HIGH_LEVEL_RSV_FLAG VARCHAR2(1) Y
RELIEVE_RESERVATIONS_FLAG VARCHAR2(1) Y
WIP_SUPPLY_TYPE NUMBER(22) Y
COMPLETION_TRANSACTION_ID NUMBER(22) Y
MOVE_TRANSACTION_ID NUMBER(22) Y
REBUILD_JOB_NAMEVARCHAR2(240) Y
REBUILD_ACTIVITY_ID NUMBER(22) Y
REBUILD_SERIAL_NUMBER VARCHAR2(30) Y
REBUILD_ITEM_ID NUMBER(22) Y
TRANSACTION_BATCH_SEQ NUMBER(22) Y
TRANSACTION_BATCH_ID NUMBER(22) Y
REPRESENTATIVE_LOT_NUMBER VARCHAR2(80) Y
TRANSACTION_GROUP_SEQ NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2931318393
CV.040 Conversion Data Mapping
TRANSACTION_GROUP_ID NUMBER(22) Y
SECONDARY_TRANSACTION_QUANTITY NUMBER(22) Y
SECONDARY_UOM_CODEVARCHAR2(240) Y
TRANSFER_PLANNING_TP_TYPE NUMBER(22) Y
XFR_PLANNING_ORGANIZATION_ID NUMBER(22) Y
PLANNING_TP_TYPE NUMBER(22) Y
PLANNING_ORGANIZATION_ID NUMBER(22) Y
TRANSFER_OWNING_TP_TYPE NUMBER(22) Y
XFR_OWNING_ORGANIZATION_ID NUMBER(22) Y
OWNING_TP_TYPE NUMBER(22) Y
OWNING_ORGANIZATION_ID NUMBER(22) Y
TRANSFER_ORGANIZATION_TYPE NUMBER(22) Y
ORGANIZATION_TYPE NUMBER(22) Y
XML_DOCUMENT_IDVARCHAR2(240) Y
CONTENT_LPN_ID NUMBER(22) Y
TRANSFER_LPN_ID NUMBER(22) Y
LPN_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2941318394
CV.040 Conversion Data Mapping
TRANSFER_COST_GROUP_ID NUMBER(22) Y
SOURCE_LOT_NUMBER VARCHAR2(80) Y
COST_TYPE_ID NUMBER(22) Y
ORG_COST_GROUP_ID NUMBER(22) Y
SCHEDULED_PAYBACK_DATE DATE(7) Y
END_ITEM_UNIT_NUMBER VARCHAR2(60) Y
OVERCOMPLETION_TRANSACTION_ID NUMBER(22) Y
OVERCOMPLETION_PRIMARY_QTY NUMBER(22) Y
OVERCOMPLETION_TRANSACTION_QTY NUMBER(22) Y
QA_COLLECTION_ID NUMBER(22) Y
KANBAN_CARD_ID NUMBER(22) Y
COST_GROUP_ID NUMBER(22) Y
FLOW_SCHEDULE VARCHAR2(1) Y
SCHEDULED_FLAG NUMBER(22) Y
SCHEDULE_NUMBER VARCHAR2(30) Y
BUILD_SEQUENCE NUMBER(22) Y
SCHEDULE_GROUP NUMBER(22) Y
SUBSTITUTION_ITEM_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2951318395
CV.040 Conversion Data Mapping
SUBSTITUTION_TYPE_ID NUMBER(22) Y
PARENT_ID NUMBER(22) Y
DEMAND_CLASS VARCHAR2(30) Y
ACCOUNTING_CLASS VARCHAR2(10) Y
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) Y
ALTERNATE_BOM_DESIGNATOR VARCHAR2(10) Y
ROUTING_REVISION_DATE DATE(7) Y
BOM_REVISION_DATE DATE(7) Y
ROUTING_REVISION VARCHAR2(3) Y
BOM_REVISION VARCHAR2(3) Y
OVERHEAD_ACCOUNT NUMBER(22) Y
OUTSIDE_PROCESSING_ACCOUNT NUMBER(22) Y
RESOURCE_ACCOUNT NUMBER(22) Y
MATERIAL_OVERHEAD_ACCOUNT NUMBER(22) Y
MATERIAL_ACCOUNT NUMBER(22) Y
TRANSACTION_SEQUENCE_ID NUMBER(22) Y
TRANSFER_PERCENTAGE NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2961318396
CV.040 Conversion Data Mapping
FINAL_COMPLETION_FLAG VARCHAR2(1) Y
EXPENDITURE_TYPE VARCHAR2(30) Y
PA_EXPENDITURE_ORG_ID NUMBER(22) Y
SOURCE_PROJECT_ID NUMBER(22) Y
TO_PROJECT_ID NUMBER(22) Y
PROJECT_ID NUMBER(22) Y
SOURCE_TASK_ID NUMBER(22) Y
TO_TASK_ID NUMBER(22) Y
TASK_ID NUMBER(22) Y
LOCATOR_NAMEVARCHAR2(2000) Y mtl_transactions_interface LOCATOR_NAME
INVENTORY_ITEMVARCHAR2(2000) Y
SHIPPED_QUANTITY NUMBER(22) Y
RESERVATION_QUANTITY NUMBER(22) Y
MOVEMENT_ID NUMBER(22) Y
REQUISITION_DISTRIBUTION_ID NUMBER(22) Y
ATTRIBUTE15VARCHAR2(150) Y
DST_SEGMENT3 VARCHAR2(25) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2971318397
CV.040 Conversion Data Mapping
DST_SEGMENT2 VARCHAR2(25) Y
DST_SEGMENT1 VARCHAR2(25) Y
DISTRIBUTION_ACCOUNT_ID NUMBER(22) Y
TRANSACTION_COST NUMBER(22) Y
TRANSACTION_REFERENCEVARCHAR2(240) Y
REASON_ID NUMBER(22) Y
TRANSACTION_TYPE_ID NUMBER(22) Y
TRANSACTION_ACTION_ID NUMBER(22) Y
TRANSACTION_SOURCE_TYPE_ID NUMBER(22) Y
TRANSACTION_SOURCE_NAME VARCHAR2(80) Y
DSP_SEGMENT30 VARCHAR2(40) Y
DSP_SEGMENT29 VARCHAR2(40) Y
DSP_SEGMENT28 VARCHAR2(40) Y
DSP_SEGMENT27 VARCHAR2(40) Y
DSP_SEGMENT26 VARCHAR2(40) Y
DSP_SEGMENT25 VARCHAR2(40) Y
DSP_SEGMENT24 VARCHAR2(40) Y
DSP_SEGMENT23 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2981318398
CV.040 Conversion Data Mapping
DSP_SEGMENT22 VARCHAR2(40) Y
DSP_SEGMENT21 VARCHAR2(40) Y
DSP_SEGMENT20 VARCHAR2(40) Y
DSP_SEGMENT19 VARCHAR2(40) Y
DSP_SEGMENT18 VARCHAR2(40) Y
DSP_SEGMENT17 VARCHAR2(40) Y
DSP_SEGMENT16 VARCHAR2(40) Y
DSP_SEGMENT15 VARCHAR2(40) Y
DSP_SEGMENT14 VARCHAR2(40) Y
DSP_SEGMENT13 VARCHAR2(40) Y
DSP_SEGMENT12 VARCHAR2(40) Y
DSP_SEGMENT11 VARCHAR2(40) Y
DSP_SEGMENT10 VARCHAR2(40) Y
DSP_SEGMENT9 VARCHAR2(40) Y
DSP_SEGMENT8 VARCHAR2(40) Y
DSP_SEGMENT7 VARCHAR2(40) Y
DSP_SEGMENT6 VARCHAR2(40) Y
DSP_SEGMENT5 VARCHAR2(40) Y
DSP_SEGMENT4 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 2991318399
CV.040 Conversion Data Mapping
DSP_SEGMENT3 VARCHAR2(40) Y
DSP_SEGMENT2 VARCHAR2(40) Y
DSP_SEGMENT1 VARCHAR2(40) Y
TRANSACTION_SOURCE_ID NUMBER(22) Y
LOC_SEGMENT20 VARCHAR2(40) Y
LOC_SEGMENT19 VARCHAR2(40) Y
LOC_SEGMENT18 VARCHAR2(40) Y
LOC_SEGMENT17 VARCHAR2(40) Y
LOC_SEGMENT16 VARCHAR2(40) Y
LOC_SEGMENT15 VARCHAR2(40) Y
LOC_SEGMENT14 VARCHAR2(40) Y
LOC_SEGMENT13 VARCHAR2(40) Y
LOC_SEGMENT12 VARCHAR2(40) Y
LOC_SEGMENT11 VARCHAR2(40) Y
LOC_SEGMENT10 VARCHAR2(40) Y
LOC_SEGMENT9 VARCHAR2(40) Y
LOC_SEGMENT8 VARCHAR2(40) Y
LOC_SEGMENT7 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210013183100
CV.040 Conversion Data Mapping
LOC_SEGMENT6 VARCHAR2(40) Y
LOC_SEGMENT5 VARCHAR2(40) Y
LOC_SEGMENT4 VARCHAR2(40) Y
LOC_SEGMENT3 VARCHAR2(40) Y
LOC_SEGMENT2 VARCHAR2(40) Y
LOC_SEGMENT1 VARCHAR2(40) Y
LOCATOR_ID NUMBER(22) Y
SUBINVENTORY_CODE VARCHAR2(10) Y MTL_TRANSACTIONS_INTERFACAESUBINVENTORY_CODE
ACCT_PERIOD_ID NUMBER(22) Y
TRANSACTION_DATE DATE(7) Y
TRANSACTION_UOM VARCHAR2(3) Y
PRIMARY_QUANTITY NUMBER(22) Y MTL_TRANSACTIONS_INTERFACE PRIMARY_QUANTITY
TRANSACTION_QUANTITY NUMBER(22) Y
ORGANIZATION_ID NUMBER(22) Y
REVISION VARCHAR2(3) Y
ITEM_SEGMENT20 VARCHAR2(40) Y
ITEM_SEGMENT19 VARCHAR2(40) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210113183101
CV.040 Conversion Data Mapping
ITEM_SEGMENT18 VARCHAR2(40) Y
ITEM_SEGMENT17 VARCHAR2(40) Y
ITEM_SEGMENT16 VARCHAR2(40) Y
ITEM_SEGMENT15 VARCHAR2(40) Y
ITEM_SEGMENT14 VARCHAR2(40) Y
ITEM_SEGMENT13 VARCHAR2(40) Y
ITEM_SEGMENT12 VARCHAR2(40) Y
ITEM_SEGMENT11 VARCHAR2(40) Y
ITEM_SEGMENT10 VARCHAR2(40) Y
ITEM_SEGMENT9 VARCHAR2(40) Y
ITEM_SEGMENT8 VARCHAR2(40) Y
ITEM_SEGMENT7 VARCHAR2(40) Y
ITEM_SEGMENT6 VARCHAR2(40) Y
ITEM_SEGMENT5 VARCHAR2(40) Y
ITEM_SEGMENT4 VARCHAR2(40) Y
ITEM_SEGMENT3 VARCHAR2(40) Y
ITEM_SEGMENT2 VARCHAR2(40) Y
ITEM_SEGMENT1 VARCHAR2(40) Y mtl_transactions_interface ITEM_SEGMENT1
INVENTORY_ITEM_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210213183102
CV.040 Conversion Data Mapping
PROGRAM_UPDATE_DATE DATE(7) Y
PROGRAM_ID NUMBER(22) Y
PROGRAM_APPLICATION_ID NUMBER(22) Y
REQUEST_ID NUMBER(22) Y
LAST_UPDATE_LOGIN NUMBER(22) Y
CREATED_BY NUMBER(22) Y
CREATION_DATE DATE(7) Y
LAST_UPDATED_BY NUMBER(22) Y
LAST_UPDATE_DATE DATE(7) Y
LOCK_FLAG NUMBER(22) Y
TRANSACTION_MODE NUMBER(22) Y
VALIDATION_REQUIRED NUMBER(22) Y
PROCESS_FLAG NUMBER(22) Y
SOURCE_HEADER_ID NUMBER(22) Y
SOURCE_LINE_ID NUMBER(22) Y
SOURCE_CODE VARCHAR2(30) Y
TRANSACTION_HEADER_ID NUMBER(22) Y
TRANSACTION_INTERFACE_ID NUMBER(22) Y
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210313183103
CV.040 Conversion Data Mapping
LOT_NUMBER VARCHAR2(25) Y MTL_LOTS_TRANSACTION_INTERFACE LOT_NUMBER
ORGN_CODE VARCHAR2(40) Y mtl_transactions_interface organization_id derived
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210413183104
CV.040 Conversion Data Mapping
Data Clean-up
N/A
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210513183105
CV.040 Conversion Data Mapping
Data Normalization
N/A
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210613183106
CV.040 Conversion Data Mapping
Validations
Validated organization_id
Checked if item is assigned to organization
Checkedif the item for the org is lot controlled before inserting into the Lots interface table.
Checked if inventory already exists for that item in that org and for a lot.
Validate organization_id, organization_code.
Validate inventory item id.
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210713183107
CV.040 Conversion Data Mapping
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210813183108
CV.040 Conversion Data Mapping
Objects
Data File : OPENING_STK.csv
Control File XX_LOAD_OPEN_STKctl
Validation Script privi_beg_stk_update.PRIVI_VALIDATE_PRC
Interface Script : privi_beg_stk_update.STAG_INTER_INSERT_PRC
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 210913183109
CV.040 Conversion Data Mapping
Interface Table Creation Program Logic
This section describes the logic for the conversion staging table creation programs that will be built to support the conversion of Inventory data.
This Table is used to upload the data from Flat file and validate the data before pushing into standard interface tables
CREATE TABLE APPS.XXX_STAG_MTL_TRANS_TBL
(
ORGN_CODE VARCHAR2(40 BYTE),
TRANSACTION_INTERFACE_ID NUMBER,
TRANSACTION_HEADER_ID NUMBER,
SOURCE_CODE VARCHAR2(30 BYTE),
SOURCE_LINE_ID NUMBER,
SOURCE_HEADER_ID NUMBER,
PROCESS_FLAG NUMBER(1),
VALIDATION_REQUIRED NUMBER,
TRANSACTION_MODE NUMBER,
LOCK_FLAG NUMBER(1),
LAST_UPDATE_DATE DATE,
LAST_UPDATED_BY NUMBER,
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211013183110
CV.040 Conversion Data Mapping
CREATION_DATE DATE,
CREATED_BY NUMBER,
LAST_UPDATE_LOGIN NUMBER,
REQUEST_ID NUMBER,
PROGRAM_APPLICATION_ID NUMBER,
PROGRAM_ID NUMBER,
PROGRAM_UPDATE_DATE DATE,
INVENTORY_ITEM_ID NUMBER,
ITEM_SEGMENT1 VARCHAR2(40 BYTE),
ITEM_SEGMENT2 VARCHAR2(40 BYTE),
ITEM_SEGMENT3 VARCHAR2(40 BYTE),
ITEM_SEGMENT4 VARCHAR2(40 BYTE),
ITEM_SEGMENT5 VARCHAR2(40 BYTE),
ITEM_SEGMENT6 VARCHAR2(40 BYTE),
ITEM_SEGMENT7 VARCHAR2(40 BYTE),
ITEM_SEGMENT8 VARCHAR2(40 BYTE),
ITEM_SEGMENT9 VARCHAR2(40 BYTE),
ITEM_SEGMENT10 VARCHAR2(40 BYTE),
ITEM_SEGMENT11 VARCHAR2(40 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211113183111
CV.040 Conversion Data Mapping
ITEM_SEGMENT12 VARCHAR2(40 BYTE),
ITEM_SEGMENT13 VARCHAR2(40 BYTE),
ITEM_SEGMENT14 VARCHAR2(40 BYTE),
ITEM_SEGMENT15 VARCHAR2(40 BYTE),
ITEM_SEGMENT16 VARCHAR2(40 BYTE),
ITEM_SEGMENT17 VARCHAR2(40 BYTE),
ITEM_SEGMENT18 VARCHAR2(40 BYTE),
ITEM_SEGMENT19 VARCHAR2(40 BYTE),
ITEM_SEGMENT20 VARCHAR2(40 BYTE),
REVISION VARCHAR2(3 BYTE),
ORGANIZATION_ID NUMBER,
TRANSACTION_QUANTITY NUMBER,
PRIMARY_QUANTITY NUMBER,
TRANSACTION_UOM VARCHAR2(3 BYTE),
TRANSACTION_DATE DATE,
ACCT_PERIOD_ID NUMBER,
SUBINVENTORY_CODE VARCHAR2(10 BYTE),
LOCATOR_ID NUMBER,
LOC_SEGMENT1 VARCHAR2(40 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211213183112
CV.040 Conversion Data Mapping
LOC_SEGMENT2 VARCHAR2(40 BYTE),
LOC_SEGMENT3 VARCHAR2(40 BYTE),
LOC_SEGMENT4 VARCHAR2(40 BYTE),
LOC_SEGMENT5 VARCHAR2(40 BYTE),
LOC_SEGMENT6 VARCHAR2(40 BYTE),
LOC_SEGMENT7 VARCHAR2(40 BYTE),
LOC_SEGMENT8 VARCHAR2(40 BYTE),
LOC_SEGMENT9 VARCHAR2(40 BYTE),
LOC_SEGMENT10 VARCHAR2(40 BYTE),
LOC_SEGMENT11 VARCHAR2(40 BYTE),
LOC_SEGMENT12 VARCHAR2(40 BYTE),
LOC_SEGMENT13 VARCHAR2(40 BYTE),
LOC_SEGMENT14 VARCHAR2(40 BYTE),
LOC_SEGMENT15 VARCHAR2(40 BYTE),
LOC_SEGMENT16 VARCHAR2(40 BYTE),
LOC_SEGMENT17 VARCHAR2(40 BYTE),
LOC_SEGMENT18 VARCHAR2(40 BYTE),
LOC_SEGMENT19 VARCHAR2(40 BYTE),
LOC_SEGMENT20 VARCHAR2(40 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211313183113
CV.040 Conversion Data Mapping
TRANSACTION_SOURCE_ID NUMBER,
DSP_SEGMENT1 VARCHAR2(40 BYTE),
DSP_SEGMENT2 VARCHAR2(40 BYTE),
DSP_SEGMENT3 VARCHAR2(40 BYTE),
DSP_SEGMENT4 VARCHAR2(40 BYTE),
DSP_SEGMENT5 VARCHAR2(40 BYTE),
DSP_SEGMENT6 VARCHAR2(40 BYTE),
DSP_SEGMENT7 VARCHAR2(40 BYTE),
DSP_SEGMENT8 VARCHAR2(40 BYTE),
DSP_SEGMENT9 VARCHAR2(40 BYTE),
DSP_SEGMENT10 VARCHAR2(40 BYTE),
DSP_SEGMENT11 VARCHAR2(40 BYTE),
DSP_SEGMENT12 VARCHAR2(40 BYTE),
DSP_SEGMENT13 VARCHAR2(40 BYTE),
DSP_SEGMENT14 VARCHAR2(40 BYTE),
DSP_SEGMENT15 VARCHAR2(40 BYTE),
DSP_SEGMENT16 VARCHAR2(40 BYTE),
DSP_SEGMENT17 VARCHAR2(40 BYTE),
DSP_SEGMENT18 VARCHAR2(40 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211413183114
CV.040 Conversion Data Mapping
DSP_SEGMENT19 VARCHAR2(40 BYTE),
DSP_SEGMENT20 VARCHAR2(40 BYTE),
DSP_SEGMENT21 VARCHAR2(40 BYTE),
DSP_SEGMENT22 VARCHAR2(40 BYTE),
DSP_SEGMENT23 VARCHAR2(40 BYTE),
DSP_SEGMENT24 VARCHAR2(40 BYTE),
DSP_SEGMENT25 VARCHAR2(40 BYTE),
DSP_SEGMENT26 VARCHAR2(40 BYTE),
DSP_SEGMENT27 VARCHAR2(40 BYTE),
DSP_SEGMENT28 VARCHAR2(40 BYTE),
DSP_SEGMENT29 VARCHAR2(40 BYTE),
DSP_SEGMENT30 VARCHAR2(40 BYTE),
TRANSACTION_SOURCE_NAME VARCHAR2(80 BYTE),
TRANSACTION_SOURCE_TYPE_ID NUMBER,
TRANSACTION_ACTION_ID NUMBER,
TRANSACTION_TYPE_ID NUMBER,
REASON_ID NUMBER,
TRANSACTION_REFERENCE VARCHAR2(240 BYTE),
TRANSACTION_COST NUMBER,
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211513183115
CV.040 Conversion Data Mapping
DISTRIBUTION_ACCOUNT_ID NUMBER,
DST_SEGMENT1 VARCHAR2(25 BYTE),
DST_SEGMENT2 VARCHAR2(25 BYTE),
DST_SEGMENT3 VARCHAR2(25 BYTE),
DST_SEGMENT4 VARCHAR2(25 BYTE),
DST_SEGMENT5 VARCHAR2(25 BYTE),
DST_SEGMENT6 VARCHAR2(25 BYTE),
DST_SEGMENT7 VARCHAR2(25 BYTE),
DST_SEGMENT8 VARCHAR2(25 BYTE),
DST_SEGMENT9 VARCHAR2(25 BYTE),
DST_SEGMENT10 VARCHAR2(25 BYTE),
DST_SEGMENT11 VARCHAR2(25 BYTE),
DST_SEGMENT12 VARCHAR2(25 BYTE),
DST_SEGMENT13 VARCHAR2(25 BYTE),
DST_SEGMENT14 VARCHAR2(25 BYTE),
DST_SEGMENT15 VARCHAR2(25 BYTE),
DST_SEGMENT16 VARCHAR2(25 BYTE),
DST_SEGMENT17 VARCHAR2(25 BYTE),
DST_SEGMENT18 VARCHAR2(25 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211613183116
CV.040 Conversion Data Mapping
DST_SEGMENT19 VARCHAR2(25 BYTE),
DST_SEGMENT20 VARCHAR2(25 BYTE),
DST_SEGMENT21 VARCHAR2(25 BYTE),
DST_SEGMENT22 VARCHAR2(25 BYTE),
DST_SEGMENT23 VARCHAR2(25 BYTE),
DST_SEGMENT24 VARCHAR2(25 BYTE),
DST_SEGMENT25 VARCHAR2(25 BYTE),
DST_SEGMENT26 VARCHAR2(25 BYTE),
DST_SEGMENT27 VARCHAR2(25 BYTE),
DST_SEGMENT28 VARCHAR2(25 BYTE),
DST_SEGMENT29 VARCHAR2(25 BYTE),
DST_SEGMENT30 VARCHAR2(25 BYTE),
REQUISITION_LINE_ID NUMBER,
CURRENCY_CODE VARCHAR2(30 BYTE),
CURRENCY_CONVERSION_DATE DATE,
CURRENCY_CONVERSION_TYPE VARCHAR2(30 BYTE),
CURRENCY_CONVERSION_RATE NUMBER,
USSGL_TRANSACTION_CODE VARCHAR2(30 BYTE),
WIP_ENTITY_TYPE NUMBER,
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211713183117
CV.040 Conversion Data Mapping
SCHEDULE_ID NUMBER,
EMPLOYEE_CODE VARCHAR2(10 BYTE),
DEPARTMENT_ID NUMBER,
SCHEDULE_UPDATE_CODE NUMBER,
SETUP_TEARDOWN_CODE NUMBER,
PRIMARY_SWITCH NUMBER,
MRP_CODE NUMBER,
OPERATION_SEQ_NUM NUMBER,
REPETITIVE_LINE_ID NUMBER,
PICKING_LINE_ID NUMBER,
TRX_SOURCE_LINE_ID NUMBER,
TRX_SOURCE_DELIVERY_ID NUMBER,
DEMAND_ID NUMBER,
CUSTOMER_SHIP_ID NUMBER,
LINE_ITEM_NUM NUMBER,
RECEIVING_DOCUMENT VARCHAR2(10 BYTE),
RCV_TRANSACTION_ID NUMBER,
SHIP_TO_LOCATION_ID NUMBER,
ENCUMBRANCE_ACCOUNT NUMBER,
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211813183118
CV.040 Conversion Data Mapping
ENCUMBRANCE_AMOUNT NUMBER,
VENDOR_LOT_NUMBER VARCHAR2(30 BYTE),
TRANSFER_SUBINVENTORY VARCHAR2(10 BYTE),
TRANSFER_ORGANIZATION NUMBER,
TRANSFER_LOCATOR NUMBER,
XFER_LOC_SEGMENT1 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT2 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT3 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT4 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT5 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT6 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT7 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT8 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT9 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT10 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT11 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT12 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT13 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT14 VARCHAR2(40 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 211913183119
CV.040 Conversion Data Mapping
XFER_LOC_SEGMENT15 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT16 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT17 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT18 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT19 VARCHAR2(40 BYTE),
XFER_LOC_SEGMENT20 VARCHAR2(40 BYTE),
SHIPMENT_NUMBER VARCHAR2(30 BYTE),
TRANSPORTATION_COST NUMBER,
TRANSPORTATION_ACCOUNT NUMBER,
TRANSFER_COST NUMBER,
FREIGHT_CODE VARCHAR2(30 BYTE),
CONTAINERS NUMBER,
WAYBILL_AIRBILL VARCHAR2(20 BYTE),
EXPECTED_ARRIVAL_DATE DATE,
NEW_AVERAGE_COST NUMBER,
VALUE_CHANGE NUMBER,
PERCENTAGE_CHANGE NUMBER,
DEMAND_SOURCE_HEADER_ID NUMBER,
DEMAND_SOURCE_LINE VARCHAR2(30 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212013183120
CV.040 Conversion Data Mapping
DEMAND_SOURCE_DELIVERY VARCHAR2(30 BYTE),
NEGATIVE_REQ_FLAG NUMBER,
ERROR_EXPLANATION VARCHAR2(240 BYTE),
SHIPPABLE_FLAG VARCHAR2(1 BYTE),
ERROR_CODE VARCHAR2(240 BYTE),
REQUIRED_FLAG VARCHAR2(1 BYTE),
ATTRIBUTE_CATEGORY VARCHAR2(30 BYTE),
ATTRIBUTE1 VARCHAR2(150 BYTE),
ATTRIBUTE2 VARCHAR2(150 BYTE),
ATTRIBUTE3 VARCHAR2(150 BYTE),
ATTRIBUTE4 VARCHAR2(150 BYTE),
ATTRIBUTE5 VARCHAR2(150 BYTE),
ATTRIBUTE6 VARCHAR2(150 BYTE),
ATTRIBUTE7 VARCHAR2(150 BYTE),
ATTRIBUTE8 VARCHAR2(150 BYTE),
ATTRIBUTE9 VARCHAR2(150 BYTE),
ATTRIBUTE10 VARCHAR2(150 BYTE),
ATTRIBUTE11 VARCHAR2(150 BYTE),
ATTRIBUTE12 VARCHAR2(150 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212113183121
CV.040 Conversion Data Mapping
ATTRIBUTE13 VARCHAR2(150 BYTE),
ATTRIBUTE14 VARCHAR2(150 BYTE),
ATTRIBUTE15 VARCHAR2(150 BYTE),
REQUISITION_DISTRIBUTION_ID NUMBER,
MOVEMENT_ID NUMBER,
RESERVATION_QUANTITY NUMBER,
SHIPPED_QUANTITY NUMBER,
INVENTORY_ITEM VARCHAR2(2000 BYTE),
LOCATOR_NAME VARCHAR2(2000 BYTE),
TASK_ID NUMBER(15),
TO_TASK_ID NUMBER(15),
SOURCE_TASK_ID NUMBER,
PROJECT_ID NUMBER(15),
TO_PROJECT_ID NUMBER(15),
SOURCE_PROJECT_ID NUMBER,
PA_EXPENDITURE_ORG_ID NUMBER,
EXPENDITURE_TYPE VARCHAR2(30 BYTE),
FINAL_COMPLETION_FLAG VARCHAR2(1 BYTE),
TRANSFER_PERCENTAGE NUMBER,
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212213183122
CV.040 Conversion Data Mapping
TRANSACTION_SEQUENCE_ID NUMBER,
MATERIAL_ACCOUNT NUMBER,
MATERIAL_OVERHEAD_ACCOUNT NUMBER,
RESOURCE_ACCOUNT NUMBER,
OUTSIDE_PROCESSING_ACCOUNT NUMBER,
OVERHEAD_ACCOUNT NUMBER,
BOM_REVISION VARCHAR2(3 BYTE),
ROUTING_REVISION VARCHAR2(3 BYTE),
BOM_REVISION_DATE DATE,
ROUTING_REVISION_DATE DATE,
ALTERNATE_BOM_DESIGNATOR VARCHAR2(10 BYTE),
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10 BYTE),
ACCOUNTING_CLASS VARCHAR2(10 BYTE),
DEMAND_CLASS VARCHAR2(30 BYTE),
PARENT_ID NUMBER,
SUBSTITUTION_TYPE_ID NUMBER,
SUBSTITUTION_ITEM_ID NUMBER,
SCHEDULE_GROUP NUMBER,
BUILD_SEQUENCE NUMBER,
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212313183123
CV.040 Conversion Data Mapping
SCHEDULE_NUMBER VARCHAR2(30 BYTE),
SCHEDULED_FLAG NUMBER,
FLOW_SCHEDULE VARCHAR2(1 BYTE),
COST_GROUP_ID NUMBER,
KANBAN_CARD_ID NUMBER,
QA_COLLECTION_ID NUMBER,
OVERCOMPLETION_TRANSACTION_QTY NUMBER,
OVERCOMPLETION_PRIMARY_QTY NUMBER,
OVERCOMPLETION_TRANSACTION_ID NUMBER,
END_ITEM_UNIT_NUMBER VARCHAR2(60 BYTE),
SCHEDULED_PAYBACK_DATE DATE,
ORG_COST_GROUP_ID NUMBER,
COST_TYPE_ID NUMBER,
SOURCE_LOT_NUMBER VARCHAR2(80 BYTE),
TRANSFER_COST_GROUP_ID NUMBER,
LPN_ID NUMBER,
TRANSFER_LPN_ID NUMBER,
CONTENT_LPN_ID NUMBER,
XML_DOCUMENT_ID VARCHAR2(240 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212413183124
CV.040 Conversion Data Mapping
ORGANIZATION_TYPE NUMBER,
TRANSFER_ORGANIZATION_TYPE NUMBER,
OWNING_ORGANIZATION_ID NUMBER,
OWNING_TP_TYPE NUMBER,
XFR_OWNING_ORGANIZATION_ID NUMBER,
TRANSFER_OWNING_TP_TYPE NUMBER,
PLANNING_ORGANIZATION_ID NUMBER,
PLANNING_TP_TYPE NUMBER,
XFR_PLANNING_ORGANIZATION_ID NUMBER,
TRANSFER_PLANNING_TP_TYPE NUMBER,
SECONDARY_UOM_CODE VARCHAR2(240 BYTE),
SECONDARY_TRANSACTION_QUANTITY NUMBER,
TRANSACTION_GROUP_ID NUMBER,
TRANSACTION_GROUP_SEQ NUMBER,
REPRESENTATIVE_LOT_NUMBER VARCHAR2(80 BYTE),
TRANSACTION_BATCH_ID NUMBER,
TRANSACTION_BATCH_SEQ NUMBER,
REBUILD_ITEM_ID NUMBER,
REBUILD_SERIAL_NUMBER VARCHAR2(30 BYTE),
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212513183125
CV.040 Conversion Data Mapping
REBUILD_ACTIVITY_ID NUMBER,
REBUILD_JOB_NAME VARCHAR2(240 BYTE),
MOVE_TRANSACTION_ID NUMBER,
COMPLETION_TRANSACTION_ID NUMBER,
WIP_SUPPLY_TYPE NUMBER,
RELIEVE_RESERVATIONS_FLAG VARCHAR2(1 BYTE),
RELIEVE_HIGH_LEVEL_RSV_FLAG VARCHAR2(1 BYTE),
TRANSFER_PRICE NUMBER,
MATERIAL_EXPENSE_ACCOUNT NUMBER,
AAA VARCHAR2(10 BYTE),
ROW_STATUS VARCHAR2(1 BYTE),
FROM_SERIAL NUMBER,
LOT_NUMBER VARCHAR2(25 BYTE)
)
CREATE TABLE APPS.PRIVI_GL_CODE
(
SEQ_NO NUMBER,
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212613183126
CV.040 Conversion Data Mapping
ORGN_CODE VARCHAR2(25 BYTE),
SUBINV_ORG VARCHAR2(25 BYTE),
GL_CLASS VARCHAR2(25 BYTE),
CODE_COMBINATION_ID NUMBER(15),
COMPANY VARCHAR2(25 BYTE),
UNIT VARCHAR2(25 BYTE),
COSTCENTOR VARCHAR2(25 BYTE),
ACCOUNT VARCHAR2(25 BYTE),
PRODUCTLINE VARCHAR2(25 BYTE),
PROJECT VARCHAR2(25 BYTE),
INTERCOMPANY VARCHAR2(25 BYTE),
FUTURE1 VARCHAR2(25 BYTE),
FUTURE2 VARCHAR2(25 BYTE),
AAA VARCHAR2(10 BYTE)
)
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212713183127
CV.040 Conversion Data Mapping
Upload Program Logic
This section describes the logic for the conversion upload programs that will be built to support the conversion of Inventory Item Data.
a. Items with status_flag=’Y” will only be processed
Concurrent Program:
Launch the Transaction Manager through Interface Manager or explicitly call the API – INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS () to launch a dedicated transaction worker to process them.
The Transaction Manager picks up the rows to process based on the LOCK_FLAG, TRANSACTION_MODE, and PROCESS_FLAG. Only records with TRANSACTION_MODE of 3, LOCK_FLAG of '2', and PROCESS_FLAG of '1' will be picked up by the Transaction Manager and assigned to a Transaction Worker. If a record fails to process completely, then PROCESS_FLAG will be set to '3' and ERROR_CODE and ERROR_EXPLANATION will be populated with the cause for the error.
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212813183128
CV.040 Conversion Data Mapping
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 212913183129
CV.040 Conversion Data Mapping
Open and Closed Issues for this Deliverable
Open Issues
ID Issue Resolution Responsibility Target Date
Impact Date
Closed Issues
ID Issue Resolution Responsibility Target Date
Impact Date
CV040_
File Ref:CV040_beg_Stk_v.0 (v. DRAFT 1)
Company Confidential - For internal use only
Doc Ref: 1.0
Validations 213013183130