SeanHoppe.com Cleo Code Samples Purchase Order 850 Detail
Cleo EDI Integrator Users can use the our spreadsheet to assist with x12 EDI 850 field, element mappings. Click here for XLS >
Purchase Order 850 Detail, Click here >
The DDS below is good for inbound and outbound transactions.
*
M*=========================================================================
M* Maintenance :
M*=========================================================================
A*=========================================================================
A R F47012 TEXT('Purchase Order Detail')
A*-------------------------------------------------------------------------
A SZEDTY 00001A TEXT('Record Type')
A SZEDSQ 00002P00 TEXT('Record Sequence')
A SZEKCO 00005A TEXT('Document Key Company')
A SZEDOC 00009S00 TEXT('Document Number')
A SZEDCT 00002A TEXT('Document Type')
A SZEDLN 00007P03 TEXT('Line Number')
A SZEDST 00006A TEXT('Transaction Set')
A SZEDFT 00010A TEXT('Translation Format ')
A SZEDDT 00008S00 TEXT('EDI - Transmission Date')
A SZEDER 00001A TEXT('Send/Receive Indicator')
A SZEDDL 00005P00 TEXT('Number of Detail Lines')
A SZEDSP 00001A TEXT('Processed (Y/N)')
A SZEDBT 00015A TEXT('Batch Number ')
A SZPNID 00015A TEXT('Trading Partner ID ')
A SZKCOO 00005A TEXT('Order Company')
A SZDOCO 00008S00 TEXT('Order Number ')
A SZDCTO 00002A TEXT('Order Type ')
A SZLNID 00006P03 TEXT('Line Number')
A SZSFXO 00003A TEXT('Order Suffix ')
A SZMCU 00012A TEXT('Business Unit')
A SZCO 00005A TEXT('Company')
A SZAN8 00008S00 TEXT('Address Number ')
A SZSHAN 00008S00 TEXT('Ship To')
A SZPA8 00008S00 TEXT('Parent Number')
A SZDRQJ 00008S00 TEXT('Requested. ')
A SZTRDJ 00008S00 TEXT('Order Date ')
A SZPDDJ 00008S00 TEXT('Promised Delivery Date')
A SZOPDJ 00008S00 TEXT('Original Promised Date')
A SZADDJ 00008S00 TEXT('Actual Ship Date')
A SZIVD 00008S00 TEXT('Invoice Date ')
A SZCNDJ 00008S00 TEXT('Cancel Date')
A SZDGL 00008S00 TEXT('G/L Date')
A SZRSDJ 00008S00 TEXT('Promised Delivery')
A SZPEFJ 00006S00 TEXT('Price Effective')
A SZPPDJ 00006S00 TEXT('Ship ')
A SZPSDJ 00006S00 TEXT('Future Use 2 ')
A SZVR01 00025A TEXT('Purchase Order Number')
A SZVR02 00025A TEXT('Reference 2')
A SZITM 00008S00 TEXT('Item Number (Short)')
A SZLITM 00025A TEXT('Long Item Number')
A SZAITM 00025A TEXT('UPC Item Number')
A SZCITM 00025A TEXT('Customer Item Number')
A SZLOCN 00020A TEXT('Location')
A SZUOM 00002A TEXT('U/M')
A SZUORG 00015P00 TEXT('Quantity')
A SZSOQS 00015P00 TEXT('Quantity Shipped')
A SZSOBK 00015P00 TEXT('Quantity Backordered')
A SZSOCN 00015P00 TEXT('Quantity Canceled')
A SZSONE 00015P00 TEXT('Future Quantity Committed')
A SZUOPN 00015P00 TEXT('Quantity Open')
A SZQTYT 00015P00 TEXT('Quantity Shipped to Date ')
A SZOTQY 00001A TEXT('Other Quantity (1/2)')
A SZUPRC 00015P04 TEXT('Unit Price ')
A SZAEXP 00015P02 TEXT('Extended Price ')
A SZLPRC 00015P04 TEXT('Unit List Price')
A SZUNCS 00015P04 TEXT('Unit Cost. ')
A SZECST 00015P02 TEXT('Extended Cost')
A SZCSTO 00001A TEXT('Cost Override Code ')
A SZTCST 00015P02 TEXT('Transfer Cost')
A SZINMG 00010A TEXT('Print Message')
A SZPTC 00003A TEXT('Payment Terms')
A SZRYIN 00001A TEXT('Payment Instrument ')
A SZDTBS 00001A TEXT('Based on Date')
A SZKCO 00005A TEXT('Document Company')
A SZDOC 00008S00 TEXT('Document Number')
A SZTAX1 00001A TEXT('Sales Taxable')
A SZTXA1 00010A TEXT('Tax Rate/Area')
A SZEXR1 00002A TEXT('Tax Expl Code')
A SZATXT 00001A TEXT('Associated Text')
A SZPRIO 00001A TEXT('Priority Processing Code ')
A SZCARS 00008A TEXT('Carrier Number ')
A SZMOT 00003A TEXT('Mode of Trn')
A SZCOT 00003A TEXT('Conditions of Transport')
A SZROUT 00003A TEXT('Route Code ')
A SZSTOP 00003A TEXT('Stop Code. ')
A SZZON 00003A TEXT('Zone Number')
A SZCNID 00020A TEXT('Container I.D')
A SZFRTH 00003A TEXT('Freight Handling Code')
A SZSHCM 00003A TEXT('Shipping Commodity Class ')
A SZSHCN 00003A TEXT('Shipping Conditions Code ')
A SZSERN 00030A TEXT('Lot Serial Number')
A SZUOM1 00002A TEXT('Unit of Measure')
A SZPQOR 00015P00 TEXT('Quantity Ordered')
A SZUOM2 00002A TEXT('Secondary UOM')
A SZSQOR 00015P00 TEXT('Secondary Quantity Ordered ')
A SZUOM4 00002A TEXT('Pricing UOM')
A SZITWT 00015P04 TEXT('Unit Weight')
A SZWTUM 00002A TEXT('Weight Unit of Measure')
A SZITVL 00015P04 TEXT('Unit Volume')
A SZVLUM 00002A TEXT('Volume Unit of Measure')
A SZSC01A 00001A TEXT('SAC01 - Group A')
A SZSC02A 00005A TEXT('SAC02 - Group A')
A SZSC05A 00006S TEXT('SAC05 - Group A')
A SZSC12A 00002A TEXT('SAC12 - Group A')
A SZSC15A 00045A TEXT('SAC15 - Group A')
A SZSC01B 00001A TEXT('SAC01 - Group B')
A SZSC02B 00005A TEXT('SAC02 - Group B')
A SZSC05B 00006S TEXT('SAC05 - Group B')
A SZSC12B 00002A TEXT('SAC12 - Group B')
A SZSC15B 00045A TEXT('SAC15 - Group B')
A SZSC01C 00001A TEXT('SAC01 - Group C')
A SZSC02C 00005A TEXT('SAC02 - Group C')
A SZSC05C 00006S TEXT('SAC05 - Group C')
A SZSC12C 00002A TEXT('SAC12 - Group C')
A SZSC15C 00045A TEXT('SAC15 - Group C')
A SZGRWT 00015P04 TEXT('Gross Weight ')
A SZGWUM 00002A TEXT('Gross Weight Unit of Measure+
A SZURCD 00002A TEXT('User Reserved Code ')
A SZURDT 00006S00 TEXT('User Reserved Date ')
A SZURAT 00015P02 TEXT('User Reserved Amount')
A SZURAB 00008S00 TEXT('User Reserved Number')
A SZURRF 00015A TEXT('User Reserved Reference ')
A SZTORG 00010A TEXT('Transaction Originator')
A SZUSER 00010A TEXT('User ID')
A SZPID 00010A TEXT('Program ID ')
A SZJOBN 00010A TEXT('Work Station ID')
A SZUPMJ 00008S00 TEXT('Date Updated ')
A SZTDAY 00006P00 TEXT('Time of Day')
A SZREF01 00080A TEXT('ALPHA REFERENCE 1')
A SZREF02 00080A TEXT('ALPHA REFERENCE 2')
A SZREF03 00080A TEXT('ALPHA REFERENCE 3')
A SZREF04 00015S TEXT('ZONE REFERENCE 1')
A SZREF05 00015S TEXT('ZONE REFERENCE 2')
A SZREF06 00015S TEXT('ZONE REFERENCE 3')
