If the Generate Invoices field on the EDI Customer Profiles form is selected for the trading partner associated with the invoiced customer order, invoices are generated during the invoice printing process.
CAUTION 1: To convert to a single flat file for use with translators other than Radley, on the Demand EDI Parameters - Interface Setup form, the Generic Interface field must be selected.
CAUTION 2:If the value in a SyteLine Freight, Misc Charges, Sales Tax, Prepaid Amount, or Total record contains more than 10 digits (for example, a US dollar amount greater than $99,999,999.99), the additional digits are truncated from the right side in the flat-file record.
| Field Description | Position | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN | cust_tp_mst.tp_code You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| SY1 Designator (hard_coded) | 8 | 3 | AN | Hard Coded SY1 |
| Transaction Type Number | 11 | 6 | AN | Hard Coded 810 |
| Field Description | Position: Radley | Position: Other Translators | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|---|
| Record Type | 1 | 1 | N0 | 1 = Header | |
| Trading Partner Designator | 1 | 2 | 2 | AN | cust_tp_mst.tp_code |
| Invoice Number | 3 | 4 | 12 | N0 | edi_inv_hdr_mst.inv_num. The invoice number length is determined by the Invoice Length field on the Order Entry Parameters form. However, the full 12 characters for this field in the EDI file should be preserved. |
| Undefined | 15 | 16 | 18 | AN | If you use an invoice number length less than 12, this Undefined field appears to have additional space available. If you use this undefined field, preserve its defined starting character and length. |
| Destination | 33 | 34 | 5 | AN | substring(cust_tp_mst.tp_code,3,5) for ship-to customer |
| Undefined | 38 | 39 | 5 | AN | |
| Invoice Date | 43 | 44 | 8 | DT | edi_inv_hdr_mst.inv_date Format = YYYYMMDD |
| Invoice Type | 51 | 52 | 2 | AN | cust_tp_mst.inv_code |
| ASN Number | 53 | 54 | 30 | AN | do_hdr_mst.do_num or edi_bol_mst.asn_num |
| Purchase Order Number | 83 | 84 | 22 | AN | edi_inv_hdr_mst.cust_po |
| Purchase Order Date | 105 | 106 | 8 | DT | rma_mst.rma_date, co_mst.order_date, or edi_co_mst.order_date. Format = YYYYMMDD |
| Undefined | 113 | 114 | 53 | AN | |
| Ship Date | 166 | 167 | 8 | DT | edi_inv_hdr_mst.ship_date Format = YYYYMMDD |
| Undefined | 174 | 175 | 67 | AN | |
| Discount Percentage | 241 | 242 | 5 | N0 | items_mst.disc_pct |
| Undefined | 246 | 247 | 10 | AN | |
| BOL Number | 256 | 257 | 30 | AN | symedi_edi_bol_mst.bol_num |
| Undefined | 268 | 287 | 117 | AN | |
| Terms code | 403 | 404 | 2 | AN | symedi_edi_inv_hdr_mst.terms_code
(last character truncated) |
| Undefined | 405 | 406 | 2 | AN | |
| Discount Days | 407 | 408 | 3 | N0 | items_mst.disc_days |
| Due Days | 410 | 411 | 3 | N0 | items_mst.due_days |
| Undefined | 413 | 414 | 13 | N0 | |
| Prox Day | 426 | 427 | 2 | N0 | items_mst.prox_day |
| Undefined | 428 | 429 | 103 | N0 | |
| A-OR-C | 531 | 532 | 1 | AN | if Prepaid then "A" else "" |
| A-OR-C | 532 | 533 | 1 | AN | if Misc Chg then "C" else "" |
| A-OR-C | 533 | 534 | 1 | AN | if Freight then "C" else "" |
| A-OR-C | 534 | 535 | 1 | AN | if Sales Tax then "C" else "" |
| Undefined | 535 | 536 | 201 | AN | |
| AC-AMOUNT | 736 | 737 | 10 | N0 | edi_inv_hdr_mst.prepaid_amt |
| AC-AMOUNT | 746 | 747 | 10 | N0 | edi_inv_hdr_mst.misc_charges |
| AC-AMOUNT | 756 | 757 | 10 | N0 | edi_inv_hdr_mst.freight |
| AC-AMOUNT | 766 | 767 | 10 | N0 | edi_inv_stax_mst.sales_tax |
| Undefined | 776 | 777 | 365 | AN | |
| AC-TOTAL | 1141 | 1142 | 10 | N0 | AC-AMOUNT Total |
| Undefined | 1151 | 1152 | 8 | AN | |
| Import Export Flag | 1159 | 1160 | 1 | N0 | Hard Coded 0 - zero |
| Undefined | 1160 | 1161 | 652 | AN | |
| 1811 | 1812 | Total Record Length |
| Field Description | Position: Radley | Position: Other Translators | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|---|
| Record Type | 1 | 1 | N0 | 2 = Detail | |
| Trading Partner Designator | 1 | 2 | 2 | AN | cust_tp_mst.tp_code |
| Invoice Number | 3 | 4 | 12 | N0 | edi_inv_item_mst.inv_num |
| Undefined | 15 | 16 | 18 | AN | |
| Out Part Number | 33 | 34 | 30 | AN | edi_inv_item_mst.item |
| Undefined | 63 | 64 | 30 | AN | |
| Destination | 93 | 94 | 5 | AN | substring(cust_tp_mst.tp_code,3,5) for ship-to customer |
| Undefined | 98 | 99 | 5 | AN | |
| Customer Part Number | 103 | 104 | 30 | AN | coitem.cust_item, co_bln.cust_item |
| Purchase Order Number | 133 | 134 | 22 | AN | edi_inv_item_mst.cust_po |
| Purchase Order Line | 155 | 156 | 4 | AN | edi_inv_item_mst.co_line |
| Undefined | 159 | 160 | 16 | AN | |
| Purchase Order Release | 175 | 176 | 4 | AN | edi_inv_item_mst.co_release |
| Undefined | 179 | 180 | 26 | AN | |
| Invoiced Quantity | 205 | 203 | 10, 13 | N0 | edi_inv_item_mst.qty_invoiced (Radley length is 10; other translators' length is 13) |
| Price | 215 | 216 | 10 | N0 | edi_inv_item_mst.price |
| Unit Of Measure | 225 | 226 | 2 | AN | rmaitem_mst.u_m or coitem_mst.u_m |
| Basis Code | 227 | 228 | 2 | AN | Hard Coded UM |
| Undefined | 229 | 230 | 48 | N0 | |
| Subject To Terms Flag | 277 | 278 | 1 | N0 | Hard Coded 1 - one |
| Subject To Discount Flag | 278 | 279 | 1 | N0 | Hard Coded if edi_inv_item_mst.disc<>0 then 1 else 0 |
| Discount Percentage | 279 | 280 | 5 | N0 | edi_inv_item_mst.disc |
| Discount Amount | 284 | 285 | 10 | N0 | Calculated |
| Item Amount | 294 | 295 | 10 | N0 | Calculated |
| Undefined | 304 | 305 | 674 | AN | |
| Order Quantity | 978 | 979 | 6 | N0 | rmaitem_mst.qty_to_return or coitem_mst.qty_ordered |
| Order Unit Of Measure | 984 | 985 | 2 | AN | rmaitem_mst.u_m or coite_mstm.u_m |
| Undefined | 986 | 987 | 634 | AN | |
| Import Export Flag | 1620 | 1621 | 1 | N0 | Hard Coded 0 - zero |
| Undefined | 1621 | 1622 | 428 | AN | |
| 2048 | 2049 | Total Record Length |
This record type is used for each multiple due date record that exists for an invoice.
| Field Description | Position: Radley | Position: Other Translators | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|---|
| Record Type | 1 | 1 | N0 | 3 = Due Date | |
| Trading Partner Designator | 1 | 2 | 2 | AN | cust_tp_mst.tp_code |
| Invoice Number | 3 | 4 | 12 | N0 | edi_inv_hdr_mst.inv_num |
| Undefined | 15 | 16 | 18 | N0 | edi_inv_hdr_mst.inv_num |
| Due Date | 33 | 34 | 8 | DT | edi_ar_terms_due_mst.due_date Format:YYYYMMDD |
| Due Date Percentage | 41 | 42 | 5 | N0 | edi_ar_terms_due_mst.terms_percent |
| Due Date Amount | 46 | 47 | 13 | N0 | edi_ar_terms_due_mst.amount |
| Due Days Offset | 59 | 60 | 10 | N0 | edi_ar_terms_due_mst.due_days_offset |
| Terms Sequence | 69 | 70 | 9 | N0 | edi_ar_terms_due_mst.terms_seq |
Purchase order acknowledgments are generated during the posting of a customer order from the EDI database tables to SyteLine if theEDI Customer Profile form's Generate Acknowledgments field is selected for the trading partner associated with the customer order. A purchase order acknowledgment is also generated for each order that is printed via the Order Verification Report.
CAUTION: To convert to a single flat file for use with translators other than Radley, the Generic Interface field must be selected on the Demand EDI Parameters - Interface Setup form.
| Field Description | Position | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN | cust_tp_mst.tp_code You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| SY1 Designator (hard_coded) | 8 | 3 | AN | Hard Coded SY1 |
| Transaction Type Number | 11 | 6 | AN | Hard Coded 855 |
| Field Description | Position | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|
| Trading Partner Designator | 1 | 2 | AN | substring(cust_tp_mst.tp_code, 1,2) |
| Purchase Order Number | 3 | 22 | AN | ack_cust_po (ackitem_mst.cust_po BCO) |
| Purchase Order Date | 25 | 8 | DT | ack_mst.order_date
Format = YYYYMMDD |
| Acknowledgment Flag | 33 | 1 | N0 | Hard Coded
if ack_mst.trx_code = "ACK" then 1 else 3 |
| Undefined | 34 | 6 | AN | |
| Record Type | 40 | 3 | N0 | Hard Coded 100 |
| Sequence Number | 43 | 6 | N0 | Calculated |
| Division Abbreviation | 49 | 5 | AN | substring(cust_tp_mst.tp_code, 3,5) |
| Destination Abbreviation | 54 | 5 | AN | substring(cust_tp_mst.tp_code, 3,5) |
| Undefined | 59 | 15 | AN | |
| Transaction Set | 74 | 3 | AN | ack_mst.trx_code |
| Undefined | 77 | 32 | AN | |
| Data Entry Date | 109 | 8 | DT | Current Date Format = YYYYMMDD |
| Data Entry Time | 117 | 4 | AN | Time Format = HHMM |
| Export Date | 121 | 8 | DT | Current Date Format = YYYYMMDD |
| Undefined | 129 | 30 | AN | |
| On/Off Part and Dest Found | 159 | 1 | N0 | Hard Coded 1 - one |
| Undefined | 160 | 11 | N0 | |
| Purpose | 171 | 2 | AN | cust_tp_mst.ack_code |
| PO Type | 173 | 2 | AN | Hard Coded if ack_type = "R" then "SA" else "BK" |
| Undefined | 175 | 34 | AN | |
| Terms | 209 | 2 | AN | ack_mst.terms (last character truncated) |
| Undefined | 211 | 39 | AN | |
| PO Contact Number | 250 | 25 | AN | ack_mst.phone |
| Undefined | 275 | 136 | AN | |
| Ship Via | 411 | 2 | AN | ack_mst.ship_code (last character truncated) |
| Undefined | 413 | 168 | AN | |
| Manually Entered Flag | 581 | 1 | N0 | Hard Coded 0 - zero |
| Customer User-Defined Character Field 1 | 582 | 20 | AN | ack_mst.charfld1 Radley Undefined |
| Customer User-Defined Character Field 2 | 602 | 20 | AN | ack_mst.charfld2 Radley Undefined |
| Customer User-Defined Character Field 3 | 622 | 20 | AN | ack_mst.charfld3 Radley Undefined |
| Customer User-Defined Date Field | 642 | 8 | DT | ack_mst.datefld Radley Undefined Format = YYYYMMDD |
| Customer User-Defined Decimal Field 1 | 650 | 14 | AN | ack_mst.decifld1 Radley Undefined |
| Customer User-Defined Decimal Field 2 | 664 | 14 | AN | ack_mst.decifld2 Radley Undefined |
| Customer User-Defined Decimal Field 3 | 678 | 14 | AN | ack_mst.decifld3 Radley Undefined |
| Customer User-Defined Logic Field | 692 | 3 | AN | ack_mst.logifld Radley Undefined
YES or NO |
| Undefined | 695 | 335 | AN | |
| 1029 | Total Record Length |
| Field Description | Position | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|
| Trading Partner Designator | 1 | 2 | AN | substring(cust_tp_mst.tp_code, 1,2) |
| Purchase Order Number | 3 | 22 | AN | ack_cust_po (ackitem_mst.cust_po BCO) |
| Purchase Order Date | 25 | 8 | DT | ack_mst.order_date Format = YYYYMMDD |
| Acknowledgment Flag | 33 | 1 | N0 | Hard Coded if ack_mst.trx_code = "ACK" then 1 else 3 |
| Undefined | 34 | 6 | AN | |
| Record Type | 40 | 3 | N0 | Hard Coded 200 |
| Sequence Number | 43 | 6 | N0 | Calculated |
| Division Abbreviation | 49 | 5 | AN | substring (cust_tp_mst.tp_code, 3,5) |
| Destination Abbreviation | 54 | 5 | AN | substring (cust_tp_mst.tp_code, 3,5) |
| Undefined | 59 | 15 | AN | |
| Transaction Set | 74 | 3 | AN | ack_mst.trx_code |
| Undefined | 77 | 32 | AN | |
| Data Entry Date | 109 | 8 | DT | Current Date Format = YYYYMMDD |
| Data Entry Time | 117 | 4 | AN | Time Format = HHMM |
| Export Date | 121 | 8 | DT | Current Date Format - YYYYMMDD |
| Undefined | 129 | 30 | AN | |
| On/Off Part and Dest Found | 159 | 1 | N0 | Hard Coded 1 - one |
| Undefined | 160 | 10 | AN | |
| Entity ID Code | 170 | 2 | AN | Hard Coded 'BT' Bill to 'ST' Ship to |
| Undefined | 172 | 19 | AN | |
| Ship To/Bill To Name | 191 | 60 | AN | custaddr_mst.name |
| Undefined | 251 | 10 | AN | |
| Address Name 1 | 261 | 50 | AN | custaddr_mst.addr##1 |
| Undefined | 311 | 110 | AN | |
| Address Line 1 | 421 | 50 | AN | custaddr_mst.addr##2 |
| Undefined | 471 | 110 | AN | |
| City | 581 | 30 | AN | custaddr_mst.city |
| Undefined | 611 | 15 | AN | |
| State | 626 | 5 | AN | custaddr_mst.state |
| Zip Code | 631 | 10 | AN | custaddr_mst.zip |
| Undefined | 641 | 477 | AN | |
| 1118 | Total Record Length |
| Field Description | Position | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|
| Trading Partner Designator | 1 | 2 | AN | substring(cust_tp_mst.tp_code, 1,2) |
| Purchase Order Number | 3 | 22 | AN | ack_cust_po (ackitem_mst.cust_po BCO) |
| Purchase Order Date | 25 | 8 | DT | ack_mst.order_date Format = YYYYMMDD |
| Acknowledgment Flag | 33 | 1 | N0 | Hard Coded if ack_mst.trx_code = "ACK" then 1 else 3 |
| Control Sequence | 34 | 6 | AN | ackitem_mst.ext_ref |
| Record Type | 40 | 3 | N0 | Hard Coded 300 |
| Sequence Number | 43 | 6 | N0 | Calculated |
| Division Abbreviation | 49 | 5 | AN | substring(cust_tp_mst.tp_code, 3,5) |
| Destination Abbreviation | 54 | 5 | AN | substring(cust_tp_mst.tp_code, 3,5) |
| Undefined | 59 | 15 | AN | |
| Transaction Set | 74 | 3 | AN | ack_mst.trx_code |
| Undefined | 77 | 32 | AN | |
| Data Entry Date | 109 | 8 | DT | Current Date Format = YYYYMMDD |
| Data Entry Time | 117 | 4 | AN | Time Format = HHMM |
| Export Date | 121 | 8 | DT | Current Date Format = YYYYMMDD |
| Undefined | 129 | 30 | AN | |
| On/Off Part and Dest Found | 159 | 1 | N0 | Hard Coded 1 - one |
| Undefined | 160 | 10 | N0 | |
| Purchase Order LIne | 170 | 4 | N0 | ackitem_mst.co_line |
| Undefined | 174 | 16 | AN | |
| Trading Partner Part Number | 190 | 30 | AN | ack_bln_mst.cust_item or ackitem_mst.cust_item |
| Our Item Number | 220 | 30 | AN | ack_bln_mst.item or ackitem_mst.item |
| Quantity | 250 | 9 | N0 | ackitem_mst.qty_ordered |
| Unit Of Measure | 259 | 2 | AN | ack_bln_mst.u_m or ackitem_mst.u_m |
| Price | 261 | 14 | N0 | ack_bln_mst.cont_price |
| Price Base | 275 | 2 | AN | ack_bln_mst.pricecode or ackitem_mst.pricecode (last character truncated) |
| Description | 277 | 35 | AN | SpecificNotes.NoteContent |
| Undefined | 312 | 30 | AN | |
| Time Qualifier | 342 | 3 | AN | Hard Coded 017 |
| Required Date | 345 | 8 | DT | ackitem_mst.due_date Format = YYYYMMDD |
| Undefined | 353 | 4 | AN | |
| Blanket Line Quantity | 357 | 9 | N0 | ack_bln_mst.blanket_qty |
| Undefined | 366 | 470 | AN | |
| Customer User-Defined Character Field 1 | 836 | 20 | AN | ack_mst.charfld1 Radley Undefined |
| Customer User-Defined Character Field 2 | 856 | 20 | AN | ack_mst.charfld2 Radley Undefined |
| Customer User-Defined Character Field 3 | 876 | 20 | AN | ack_mst.charfld3 Radley Undefined |
| Customer User-Defined Date Field | 896 | 8 | DT | ack_mst.datefld Radley Undefined Format = YYYYMMDD |
| Customer User-Defined Decimal Field 1 | 904 | 14 | AN | ack_mst.decifld1 Radley Undefined |
| Customer User-Defined Decimal Field 2 | 918 | 14 | AN | ack_mst.decifld2 Radley Undefined |
| Customer User-Defined Decimal Field 3 | 932 | 14 | AN | ack_mst.decifld3 Radley Undefined |
| Customer User-Defined Logic Field | 946 | 3 | AN | ack_mst.logifld - Radley Undefined YES or NO |
| Undefined | 949 | 76 | AN | |
| 1024 | Total Record Length |
NOTE: If you are using Radley, the Quantity field length is 10, the format is N0, and the position is 205. The total record length is not affected.
Advance ship notices (ASNs) are used within the SyteLine EDI functionality to notify the trading partner that a shipment of goods has been completed. This transaction set communicates the contents of a shipment, who it is from, and where it is going. An ASN is generated during the printing of an advance ship notice if theGenerate Ship Notice field on the EDI Customer Profiles form is selected for the trading partner associated with the ASN customer order.
CAUTION: To convert to a single flat file for use with translators other than Radley, the Generic Interface check box must be selected on the Demand EDI Parameters - Interface Setup form.
| Field Description | Position | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN | cust_tp_mst.tp_code |
| SY1 Designator (hard_coded) | 8 | 3 | AN | Hard Coded SY1 |
| Transaction Type Number | 11 | 6 | AN | Hard Coded 856 |
| Field Description | Position: Radley | Position: Other Translators | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|---|
| Record Type | 1 | 1 | N0 | 1 = Header | |
| Transaction Type | 1 | 2 | 1 | N0 | Hard Coded 1 - one |
| Company Code | 2 | 3 | 7 | AN | edi_parms_mst.tp_code |
| Undefined | 9 | 10 | 1 | AN | |
| Trading Partner Designator | 10 | 11 | 2 | AN | substring(cust_tp_mst.tp_code, 1,2) |
| Shipper Number | 12 | 13 | 30 | AN | edi_bol_mst.shipper_num |
| Undefined | 42 | 43 | 40 | AN | |
| Destination Abbreviation | 82 | 83 | 5 | AN | substring(cust_tp-tp_code, 3,5) |
| Site Abbreviation | 87 | 88 | 5 | AN | substring(bt_cust_tp_mst.tp_code, 3,5) |
| Bill To Abbreviation | 92 | 93 | 5 | AN | substring(bt_cust_tp_mst.tp_code, 3,5) |
| Ship To Abbreviation | 97 | 98 | 5 | AN | substring(cust_tp_mst.tp_code, 3,5) |
| Ship Date | 102 | 103 | 8 | DT | Current Date Format = YYYYMMDD |
| Ship Time | 110 | 111 | 4 | AN | Time Format = HHMM |
| Pooled | 114 | 115 | 1 | AN | cust_tp_mst.pooled_asn |
| Undefined | 115 | 116 | 31 | AN | |
| Carrier Code | 146 | 147 | 4 | AN | co_mst.ship_code |
| Undefined | 150 | 151 | 6 | AN | |
| Equipment Number | 156 | 157 | 7 | AN | edi_bol_mst.veh_num |
| Undefined | 163 | 164 | 10 | AN | |
| Route | 173 | 174 | 25 | AN | edi_bol_mst.route |
| Undefined | 198 | 199 | 75 | AN | |
| Status | 273 | 274 | 1 | AN | Hard Coded "N" |
| Entry Date | 274 | 275 | 8 | DT | Current Date Format = YYYYMMDD |
| Entry Time | 282 | 283 | 4 | AN | Time Format = HHMM |
| Undefined | 286 | 287 | 15 | AN | |
| Carrier Reference | 301 | 302 | 15 | AN | edi_bol_mst.carrier_num |
| Undefined | 316 | 317 | 16 | AN | |
| ASN Required Flag | 332 | 333 | 1 | N0 | Hard Coded 1 - one |
| Undefined | 333 | 334 | 120 | AN | |
| ASN Number | 453 | 454 | 30 | AN | do_hdr_mst.do_num or edi_bol_mst.bol_num |
| BOL Number | 483 | 484 | 30 | AN | do_hdr_mst.do_num or edi_bol_mst.bol_num |
| Undefined | 513 | 514 | 520 | AN | |
| 1032 | 1033 | Total Record Length |
| Field Description | Position: Radley | Position: Other Translators | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|---|
| Record Type | 1 | 1 | N0 | 2 = Detail | |
| Transaction Type | 1 | 2 | 1 | N0 | Hard Coded 1 - one |
| Company Code | 2 | 3 | 7 | AN | edi_parms_mst.tp_code |
| Undefined | 9 | 10 | 1 | AN | |
| Trading Partner Designator | 10 | 11 | 2 | AN | substring(cust_tp_mst.tp_code, 1,2) |
| Shipper Number | 12 | 13 | 30 | AN | edi_bol_mst.shipper_num |
| Item | 42 | 43 | 30 | AN | edi_bol_item_mst.item |
| Customer Item | 72 | 73 | 30 | AN | coitem_mst.cust_item or " " |
| Quantity Shipped | 102 | 103 | 7 | AN | edi_bol_item_mst.qty |
| Unit Of Measure | 109 | 110 | 2 | AN | edi_bol_item_mst.u_m |
| Undefined | 111 | 112 | 50 | AN | |
| Item Description | 161 | 162 | 30 | AN | edi_bol_item_mst.description |
| Item Weight | 191 | 192 | 10 | N0 | item_mst.unit_weight |
| Undefined | 201 | 202 | 6 | AN | |
| PO Number | 207 | 208 | 22 | AN | edi_rel-po_mst.cust_po or co_mst.cust_po |
| PO Date | 229 | 230 | 8 | DT | edi_co_mst.order_date or co_mst.order_date Format = YYYYMMDD |
| Undefined | 237 | 238 | 16 | AN | |
| Price | 253 | 254 | 10 | N0 | coitem_mst.price or 0 |
| Undefined | 263 | 264 | 40 | AN | |
| Status | 303 | 304 | 1 | AN | Hard Coded "N" |
| Entry Date | 304 | 305 | 8 | DT | Current Date Format = YYYYMMDD |
| Entry Time | 312 | 313 | 4 | AN | Time Format = HHMM |
| Undefined | 316 | 317 | 332 | AN | |
| Lot Number | 648 | 649 | 30 | AN | matltrack_mst.lot |
| Undefined | 678 | 679 | 417 | AN | |
| 1094 | 1095 | Total Record Length |
The serial number record applies only to generic translators (not to Radley). This record may be included if the Include Serial Numbers check box is selected on the EDI Customer Profiles form.
| Field Description | Position: Radley | Position: Other Translators | Length | Format | SyteLine Field or Notes |
|---|---|---|---|---|---|
| Record Type | 1 | 1 | N0 | 3 = Serial | |
| Transaction Type | 2 | 1 | N0 | Hard Coded 1 - one | |
| Company Code | 3 | 8 | AN | edi_parms_mst.tp_code | |
| Trading Partner Designator | 11 | 2 | AN | substring(cust_tp_mst.tp_code, 1,2) | |
| Shipper Number | 13 | 30 | AN | edi_bol_mst.shipper_num | |
| Item | 43 | 30 | AN | edi_bol_item_mst.item | |
| Undefined | 73 | 30 | AN | ||
| Serial Number | 103 | 30 | AN | serial_mst.ser_num | |
| Undefined | 133 | 355 | AN | ||
| 487 | Total Record Length |
Electronic Data Interchange (EDI) Overview
Inbound Demand EDI Transactions - Flat-File Layout