Outbound mapping values

Page 1

Field name in Template Front end field name/label PARAMETERS STRUCTURE

SUBINVENTORY Shipping point IMPORT SHIP_POINT

H_ORDER_NUMBER Sales order TABLES SALES_ORDER_ITEMS

L_LINE_TYPE Delivery type IMPORT SHIP_POINT

DELIVERY_NUMBER Outbound delivery TABLES DELIVERIES

H_SHIP_TO_LOCATIONShip to party IMPORT SHIP_POINT

H_QUOTE_DATE Document date IMPORT SHIP_POINT

L_LINE_NUMBER Item TABLES CREATED_ITEMS

L_ORDERED_ITEM Material TABLES CREATED_ITEMS

L_QUANTITY Delivery quantity TABLES CREATED_ITEMS

L_UOM Unit TABLES CREATED_ITEMS

OPTIONALMandatory

Outbound mapping values

Page 2

FIELD DATATYPELENGTH

SHIP_POINT C 4 1201

REF_DOC C 10 15524

DLV_TYPE C 4 1201

DELIV_NUMB C 10

SHIP_TO C 10 1201

DUE_DATE DATS 8 6/16/15

DELIV_ITEM N 6 10

MATERIAL C 18 M-10

DLV_QTY QUN 13 10

SALES_UNIT UNIT 3 PC

SERIAL_NUMBER C 18 33REF_IT N 6 10

Billing Doc Mapping Values

Page 3

Oracle Fields SAP Fields ValuesDELIVERY_NUMBER REF_DOC 90000763H_TRX_TYPE ORDBILLTYP F2H_PAYING_CUSTOMER PAYER 1172D_AMOUNT NET_VALUE_ITEM 2000H_INVOICE_DATE BILL_DATE 12/31/95D_ACCOUNT ACCTASGNMT 01H_CURRENCY_CODE CURRENCY DEMH_PAYMENT_TERMS PAYMENT_TERMS ZB01H_FREIGHT_TERMS INCOTERMS1 EXWH_BILL_TO_LOCATION country code need to be mapped TAX_DEST_CTY DEPROVINCE REGION 06OPERATING_UNIT SALESORG 1000H_SALES_CHANNEL DISTR_CHAN 10Sub inventory DIVISION 00L_QUANTITY REQ_QTY 10L_ITEM MATERIAL GTS-14001L_WAREHOUSE PLANT 1000L_SALES_ORDER_NUMBER DOC_NUMBER 90000763L_PRICING_DATE PRICE_DATE 12/31/95H_DEFAULT_REP_CONTRY_NAME COUNTRY DETAX_CODE TAXCL_1MAT 1

Mandatory SOLD TO PARTY 1172