SeanHoppe.com > Cleo Code Samples > CLEO DDS - Invoice 810 Detail

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 >

QDDSSRC Set-up

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*=========================================================================

	
	




By: on