SeanHoppe.com Cleo Code Samples CLEO DDS - Invoice 810 Detail
Cleo EDI Integrator users can use the our spreadsheet to assist with x12 EDI 810 field, element mappings. Click here for XLS >
Invoice 810 Header, Click here >
The DDS below is good for inbound and outbound transactions.
A*=========================================================================
A R F47047 TEXT('EDI Invoice')
A*-------------------------------------------------------------------------
A SZEDTY 00001A TEXT('Record Type')
A SZEDSQ 00002P TEXT('Record Sequence')
A SZEKCO 00005A TEXT('Document Key Company')
A SZEDOC 00009S TEXT('Document Number')
A SZEDCT 00002A TEXT('Document Type')
A SZEDLN 00007P TEXT('Line Number')
A SZEDST 00006A TEXT('Transaction Set')
A SZEDFT 00010A TEXT('Translation Format')
A SZEDDT 00006S TEXT('EDI - Transmission Date')
A SZEDER 00001A TEXT('Send/Receive Indicator')
A SZEDDL 00005P 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 00008S TEXT('Order Number')
A SZDCTO 00002A TEXT('Order Type')
A SZLNID 00006P TEXT('Line Number')
A SZSFXO 00003A TEXT('Order Suffix')
A SZMCU 00012A TEXT('Business Unit')
A SZCO 00005A TEXT('Company')
A SZAN8 00008S TEXT('Address Number')
A SZSHAN 00008S TEXT('Ship To')
A SZPA8 00008S TEXT('Parent Number')
A SZDRQJ 00008S TEXT('Requested')
A SZTRDJ 00008S TEXT('Order Date')
A SZPDDJ 00008S TEXT('Promised Delivery')
A SZOPDJ 00008S TEXT('Original Promised')
A SZADDJ 00008S TEXT('Actual Ship')
A SZIVD 00008S TEXT('Invoice Date')
A SZCNDJ 00008S TEXT('Cancel Date')
A SZDGL 00008S TEXT('G/L Date')
A SZRSDJ 00008S TEXT('Promised Delivery')
A SZPEFJ 00008S TEXT('Price Effective')
A SZPPDJ 00008S TEXT('Ship')
A SZPSDJ 00008S TEXT('Future Use 2')
A SZVR01 00025A TEXT('Reference')
A SZVR02 00025A TEXT('Reference 2')
A SZITM 00008S TEXT('Item Number (Short)')
A SZLITM 00025A TEXT('BCI Item Number')
A SZAITM 00025A TEXT('3rd Item Number')
A SZCITM 00025A TEXT('Customer Item Number')
A SZDSC1 00030A TEXT('Description')
A SZDSC2 00030A TEXT('Description 2')
A SZLNTY 00002A TEXT('Line Type')
A SZUOM 00002A TEXT('U/M')
A SZUORG 00015P 4 TEXT('Quantity')
A SZSOQS 00015P 4 TEXT('Quantity Shipped')
A SZSOBK 00015P 4 TEXT('Quantity Backordered')
A SZSOCN 00015P 4 TEXT('Quantity Canceled')
A SZUPRC 00015P 4 TEXT('Unit Price')
A SZAEXP 00015P 4 TEXT('Extended Price')
A SZAOPN 00015P 4 TEXT('Amount Open')
A SZPROV 00001A TEXT('Price Override Code')
A SZTPC 00001A TEXT('Temporary Price (Y/N)')
A SZAPUM 00002A TEXT('Entered Unit of Measure for')
A SZLPRC 00015P 4 TEXT('Unit List Price')
A SZUNCS 00015P 4 TEXT('Unit Cost')
A SZECST 00015P 4 TEXT('Extended Cost')
A SZCSTO 00001A TEXT('Cost Override Code')
A SZTCST 00015P 4 TEXT('Transfer Cost')
A SZINMG 00010A TEXT('Print Message')
A SZPTC 00003A TEXT('Payment Terms')
A SZASN 00008A TEXT('Adjustment Schedule')
A SZODOC 00008S TEXT('Original Document No')
A SZODCT 00002A TEXT('Original Document Type')
A SZOKC 00005A TEXT('Original Document Company')
A SZPSN 00008S TEXT('Pick Slip Number')
A SZDELN 00008S TEXT('Delivery Number')
A SZPRIO 00001A TEXT('Priority Processing Code')
A SZRESL 00001A TEXT('Printed Code')
A SZBACK 00001A TEXT('Backorders Allowed (Y/N)')
A SZSBAL 00001A TEXT('Substitutes Allowed (Y/N)')
A SZAPTS 00001A TEXT('Partial Shipments Allowed')
A SZLOB 00003A TEXT('Line of Business')
A SZEUSE 00003A TEXT('End Use')
A SZDTYS 00002A TEXT('Duty Status')
A SZCDCD 00015A TEXT('Commodity Code')
A SZNTR 00002A TEXT('Nature of Transaction')
A SZVEND 00008S TEXT('Primary / Last Supplier Numb')
A SZANBY 00008S TEXT('Buyer Number')
A SZCARS 00008S 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 SZSERN 00030A TEXT('Lot Serial Number')
A SZUOM1 00002A TEXT('Unit of Measure')
A SZPQOR 00015P 4 TEXT('Quantity Ordered')
A SZUOM2 00002A TEXT('Secondary UOM')
A SZSQOR 00015P 4 TEXT('Secondary Quantity Ordered')
A SZUOM4 00002A TEXT('Pricing UOM')
A SZITWT 00015P 4 TEXT('Unit Weight')
A SZWTUM 00002A TEXT('Weight Unit of Measure')
A SZITVL 00015P 4 TEXT('Unit Volume')
A SZSTTS 00002A TEXT('Line Status')
A SZRCD 00003A TEXT('Reason Code')
A SZGRWT 00015P 4 TEXT('Gross Weight')
A SZGWUM 00002A TEXT('Gross Weight Unit of Measure')
A SZANI 00029A TEXT('Account Number')
A SZAID 00008A TEXT('Account ID')
A SZSWMS 00001A TEXT('Warehouse Status Code')
A SZURCD 00002A TEXT('User Reserved Code')
A SZURDT 00006S TEXT('User Reserved Date')
A SZURAT 00015P 4 TEXT('User Reserved Amount')
A SZURAB 00008S 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 00006S TEXT('Date Updated')
A SZTDAY 00006P TEXT('TIME OF DAY')
A SZREF01 00080A TEXT('ALPHA REFERENCE 1')
A SZREF02 00080A TEXT('ALPHA REFERENCE 2')
A SZREF03 00080A TEXT('ALPHA REFERENCE 2')
A SZREF04 00015S TEXT('ZONE REFERENCE 1')
A SZREF05 00015S TEXT('ZONE REFERENCE 2')
A SZREF06 00015S TEXT('ZONE REFERENCE 3')
A*=========================================================================
