The following data can be imported with this Excel file:
Level |
Name |
Mandatory? |
Field Name on P.50.07 |
---|---|---|---|
Agreement Header |
PO_NUMBER |
Y |
Agreement Number |
SHORT_DESC |
N |
Short Desc |
|
DESCRIPTION |
N |
Description |
|
NLS_ID |
N |
Nls |
|
ORDER_TYPE |
Y |
(Order Type) |
|
PO_SUPP |
N |
Suppl |
|
SUP_CODE |
Y |
Supplier |
|
PO_CURRENCY |
Y |
Currency |
|
PO_RM_CODE |
Y |
Routing Method |
|
BUYER |
Y |
Buyer |
|
ORIGIN |
N |
Origin |
|
ISSUED_BY |
N |
Issued By |
|
PO_COUNTRY |
N |
Country Code |
|
CLIENT_PO_NUMBER |
N |
Client Agreement Number |
|
POINT_OF_ORIGIN |
N |
Point of Origin |
|
EXPED_ILV_CODE |
N |
||
ILV_CODE |
N |
||
EV_CODE |
N |
||
CCP_CODE |
N |
||
PO_ACCOUNT_CODE |
N |
Account Code |
|
ORG_ETA_SITE_DATE |
N |
ETA Site |
|
TECH_EVAL_COMP_DATE |
N |
Tech Eval Comp Date |
|
EXPEDITER |
N |
Expediter |
|
TRAFFIC |
N |
Traffic |
|
READY_FOR_APPROVAL_IND |
N |
Ready For Approval |
|
APPROVED_DATE |
N |
Approved Date |
|
APPROVED_BY |
N |
Approved By |
|
PARENT_ORDER |
N |
(Parent) Agreement |
|
PARENT_PO_NUMBER |
N |
(Parent) Agreement Number |
|
PARENT_PO_SUPP |
N |
(Parent) Suppl |
|
PARENT_ORIGIN_CODE |
N |
(Parent) Origin |
|
PARENT_ORDER_TYPE |
N |
(Parent Order Type) |
|
Line Items |
POLI_POS |
Y |
Pos |
POLI_SUB_POS |
Y |
Sub |
|
IDENT_CODE |
Y |
Ident Code |
|
POLI_QTY |
Y |
Quantity |
|
POLI_QTY_CODE |
Y |
Quantity Unit |
|
POLI_CURRENCY |
Y |
Currency |
|
POLI_UNIT_WEIGHT |
Y |
Unit Weight |
|
POLI_WEIGHT_CODE |
Y |
Weight Unit |
|
TAG_NUMBER |
N |
Tag Number |
|
POLI_UNIT_PRICE |
N |
Unit Price |
|
POLI_VOLUME |
N |
Volume |
|
FRT_CODE |
N |
Incoterm |
|
FREIGHT_VALUE |
N |
Delivery Place |
|
PROM_CONTR_DATE |
N |
Prom Contract |
|
POLI_UNIT_PRICE |
N |
Unit Price |
|
SUPPLY_PRICE |
N |
Supply Price |
|
INSTALL_PRICE |
N |
Install Price |
|
PRICE_BASE |
N |
Price Base |
|
POLI_VOL_CODE |
N |
Volume Unit |
|
POLI_DIMENSIONS |
N |
Dimensions |
|
POLI_COUNTRY |
N |
Country of Origin |
|
MANUFACTURER |
N |
Manufacturer |
|
CATALOG_NUMBER |
N |
Catalog Number |
|
PERCENT_US_CONTENT |
N |
%Dom.Prod. |
|
TEC_PASSED_IND |
N |
TE Passed |
|
EXPORT_LICENSE_REQ_IND |
N |
Exp Lic Req |
|
EXPORT_LICENSE_NUMBER |
N |
Exp Lic Number |
|
EXPORT_LICENSE_RECEIVED_DATE |
N |
Exp Lic Recv |
|
POLI_ACCOUNT_CODE |
N |
Account Code |
|
ACCEPTED_IND |
N |
Accepted |
|
ITY_CODE |
N |
Item Type |
|
LAYOUT SHORT |
N |
Layout Short |
|
LAYOUT LONG |
N |
Layout Long |
|
PARENT_POLI |
N |
(Parent POLI) |
|
PARENT_POLI_POS |
N |
(Parent POLI Pos) |
|
PARENT_POLI_SUB_POS |
N |
(Parent POLI Sub Pos) |
|
REQ_LINE_ITEM |
N |
Req Line Item |
|
R_CODE |
N |
Engineering Requisition |
|
R_SUPP |
N |
Suppl |
|
R_ORIGIN_CODE |
N |
Origin |
|
R_ACTUAL_IND |
N |
Purchase |
|
RLI_POS |
N |
(RLI) Pos |
|
RLI_SUB_POS |
N |
(RLI) Sub |
|
POLI_SPLIT_TAG |
N |
Split Tag |
|
Item Shipments |
POLI_POS |
Y |
Pos |
POLI_SUB_POS |
Y |
Sub |
|
ITEM_SHIP_POS |
Y |
IS Pos |
|
ITEM_SHIP_SUB_POS |
Y |
IS Sub |
|
ITEM_SHIP_QTY |
N |
Quantity |
|
ITEM_SHIP_QTY_CODE |
N |
Quantity Unit |
|
ITEM_SHIP_WEIGHT |
N |
Item Ship Weight |
|
ITEM_SHIP_WEIGHT_CODE |
N |
Unit Weight |
|
ITEM_SHIP_VOLUME |
N |
Item Ship Volume |
|
ITEM_SHIP_VOL_CODE |
N |
Unit Volume |
|
ITEM_SHIP_DIMENSIONS |
N |
Item Ship Dimension |
|
DD_CODE |
N |
Delivery Designation |
|
ITEM_SHIP_RM_CODE |
N |
Routing Method |
|
FAB_LOCATION |
N |
Fab Location |
|
FAB_SHOP_CNTRL_NUMBER |
N |
Fab Ctrl Number |
|
FAB_COMPLETE_PERCENT |
N |
Comp % |
|
FIFTY_PERCENT_FAB_COMP |
N |
50% Comp |
|
REV_PROM_SHIP_DATE |
N |
Rev Prom Ship |
|
MAJ_MATL_ORDER_DATE |
N |
Maj Matl Order |
|
MAJ_MATL_RECV_DATE |
N |
Maj Matl Recv |
|
ACTUAL_FAB_START_DATE |
N |
Actual Fab Start |
|
PROM_FAB_COMP_DATE |
N |
Prom Fab Comp |
|
ACTUAL_FAB_COMP_DATE |
N |
Actual Fab Comp |
|
ACTUAL_SHIP_DATE |
N |
Actual Ship |
|
PRED_SHIP_DATE |
N |
Pred Ship |
|
PRED_ON_SITE_DATE |
N |
Pred On Site |
|
ACTUAL_ON_SITE_DATE |
N |
Actual On Site |
|
ACTUAL_CONTRACT_DATE |
N |
PO Actual |
|
PROM_INSPECT_DATE |
N |
Prom Inspect |
|
FINAL_INSPECT_DATE |
N |
Final Inspect |
|
READY_PREDICTED |
N |
Ready Predicted |
|
READY_ACTUAL |
N |
Ready Actual |
|
PROM_CONTRACT_DATE |
N |
Prom Contract |
|
PROM_SHIP_DATE |
N |
Prom Ship |
|
REQ_SITE_DATE |
N |
Req On Site |
|
ISH_EXPORT_LICENSE_REQ_IND |
N |
Exp Lic Req |
|
COMMENTS |
N |
Comments |
|
ISH_SPLIT_TAG |
N |
Split Tag |