datamap sales trans confirm

E1 / OTM Integration document.xls Oracle Property Confidential 08/24/2022 Page 1 of 2 EnterpriseOne OTM D4900180 F4201 F4211 F49T40 Alias Description Type Size X-Ref Example Data Alias X OTDOMAIN Transportation Planning Domain CHAR 50 No domain name X X X OTSHPN New Field CHAR 50 No Shipment ID X TRMNUM Transmission Number CHAR 11 No transmission number X OTBUYSEL Buy Sell Flag CHAR 1 No Buy Sell flag X X X OTSSHPN New Field No shipmentgid Order Line Key X X X X OTORDRLS Order Release ID (Order Number DOCO concat) MATH 8 No 7117 See description X X X Order Type DCTO (concat) CHAR 2 No S4 See description X X X Order Company KCOO (concat) CHAR 5 No 00001 See description X X Line Number (concat to OTORDRLS for OTORDRLN) MATH 6 No 1.000 releasegid X OTORDRLN See above No releaselinegid X OTBLFCHG Billable Freight Charge No X CRCD Billable Freight Charge Currency Code CHAR 3 No Currency code for allocated cost X X X DATE 6 No 12/20/2006 latestestimateddeliverydate (parse) X X X X MATH 6 No 0 parse Allocated cost to the order for all the shipments that that order participates in parse into RSDJ Date Promised Delivery (parsed from latestestimatedeliverydate) parse into RSDT Promised Delivery Time (parsed from latestestimatedeliverydate)

Upload: cvkraj

Post on 12-Sep-2015

222 views

Category:

Documents

2 download

Report

Download

Embed Size (px):

DESCRIPTION

Datamap Sales Trans Confirm

TRANSCRIPT

Transportation ConfirmationEnterpriseOneOTMD4900180F4201F4211F49T40AliasDescriptionTypeSizeX-RefExample DataAliasXSD LocationTypeSizeOpt?CommentsXOTDOMAINTransportation Planning DomainCHAR50Nodomain nameshipment.shipmentheader.shipmentgid.gid.domainnameVARCHAR250XXXOTSHPNNew FieldCHAR50NoShipment IDshipment.shipmentheader.shipmentgid.gid.xidVARCHAR250XTRMNUMTransmission NumberCHAR11Notransmission numbertransmissionbody.glogxmlelement.transmissionreport.transmissionnoVARCHAR211XOTBUYSELBuy Sell FlagCHAR1NoBuy Sell flagCHAR1XXXOTSSHPNNew FieldNoshipmentgidshipment.release.releaseallocationinfo.releaseallocbytype.alloctypequalgid = PLANNING_SELLshipment.release.releaseallocationinfo.releaseallocbytype.releaseallocshipment.shipmentgid.xidVARCHAR250Order Line KeyXXXXOTORDRLSOrder Release ID (Order Number DOCO concat)MATH8No7117See descriptionshipment.release.releasegid.xidE1 sales orderline key will have been concatenated to be the OTM release order line idXXXOrder Type DCTO (concat)CHAR2NoS4See descriptionXXXOrder Company KCOO (concat)CHAR5No00001See descriptionXXLine Number (concat to OTORDRLS for OTORDRLN)MATH6No1.000releasegidVARCHAR250XOTORDRLNSee aboveNoreleaselinegidshipment.release.releaseline.releaselinegid.xid (See description above)VARCHAR250XOTBLFCHGBillable Freight ChargeNoAllocated cost to the order for all the shipments that that order participates inshipment.release.releaseallocationinfo.releaseallocbytype.releaseallocshipment.totalalloccost.financialamount.monetaryamountNUMBERXCRCDBillable Freight Charge Currency CodeCHAR3NoCurrency code for allocated costshipment.release.releaseallocationinfo.releaseallocbytype.releaseallocshipment.totalalloccost.financialamount.global currency codeVARCHAR2101XXXparse into RSDJDate Promised Delivery (parsed from latestestimatedeliverydate)DATE6No12/20/2006latestestimateddeliverydate (parse)shipment.release.releaseshipmentinfo.latestestimateddeliverydateDATEXXXXparse into RSDTPromised Delivery Time (parsed from latestestimatedeliverydate)MATH6No0parse

Confirm Instruction Manual

DataMap User Guide - ohconnect.org · ProgressBook DataMap User Guide ... 16.1.0 “Access Student Roadmap ... teachers in multiple buildings, and to reflect the new

Study Project TRANS-CSP Trans-Mediterranean Interconnection

Bandaging & slings confirm

MMA MTA DataMap - PRWebww1.prweb.com/prfiles/2017/09/26/14736117/11x11VFinal-download.pdf · MMA MTA DATAMAP TM THE CENTER Represents the creation of unifi ed user data that brings

CONFIRM SEBI.pptx

Wheel-Trans Eligibility Applicationttc.ca/PDF/Wheel-Trans/Wheel-Trans Eligibility Application.pdf · Wheel-Trans Eligibility Application. Phone (preferred number) * (alternate number)

Confirm 120613

SyteLine ERP DataMap Guide - Abbey Code Guide.pdf · 1-2 SyteLine ERP DataMap Guide ... SyteLine ERP DataMap Guide. SyteLine ERP DataMap Guide. SyteLine ERP DataMap Guide. SyteLine

Trans-Siberian route: development of trans-continental

DataMap User Guide - LACA User Guide.pdf · iv ProgressBook DataMap User Guide View an Intervention from the Student Roadmap Screen ... Analyze Multiple Measures of Student Data

EDR DataMap - Environmental Atlas · 2008. 10. 13. · EDR DataMap - Environmental Atlas 1000 1400 200 200 400 400 400 0 600 600 600 00 1400 1200 1200 1000 1000 800 800 1 1400 1200