Inbound Supply EDI Transactions - Flat-File Layout
-
Explanation of Formats:
DT = Date
AN = Alphanumeric
N* = Numeric (2nd digit = the number of decimal places)
- Field Length: Each file must be the exact length designated in this file layout. Each field's starting position must match the file layout. If your values are shorter than the field length specified here, the value is padded with blanks to fill the length of the field so that each field starts in the correct position.
810 (INVOIC) Invoice Flat File Layout
This table describes the fields in Vendor Invoice Header:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 100 |
| Vendor Invoice Number | 11 | 22 | AN | edi_vinv_mst.vend_inv_num |
| Invoice Line Nbr | 33 | 3 | N0 | "000" |
| Site Identifier | 36 | 7 | AN | |
| Undefined | 43 | 3 | AN | |
| Invoice Date | 46 | 8 | DT | edi_vinv_mst.inv_date |
| PO Number | 54 | 10 | AN | edi_vinv_mst.po_num |
| Misc Charges | 64 | 14 | N2 | edi_vinv_mst.misc_charges |
| Sales Tax | 78 | 14 | N2 | edi_vinv_mst.sales_tax |
| Freight Charges | 92 | 14 | N2 | edi_vinv_mst.freight |
| Goods Receiving Note | 106 | 30 | AN | edi_vinv_mst.grn_num |
| Undefined | 136 | 40 | AN |
This table describes the user-defined fields:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN | You can enter 17 characters in the Trading Partner field but will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 110 |
| Vendor Invoice Number | 11 | 22 | AN | edi_vinv_mst.vend_inv_num |
| Invoice Line Nbr | 33 | 3 | N0 | 000 |
| Site Identifier | 36 | 7 | AN | |
| Undefined | 43 | 3 | AN | |
| Customer User-Defined Character Field 1 | 46 | 20 | AN | edi_vinv_mst.charfld1 |
| Customer User-Defined Character Field 2 | 66 | 20 | AN | edi_vinv_mst.charfld2 |
| Customer User-Defined Character Field 3 | 86 | 20 | AN | edi_vinv_mst.charfld3 |
| Customer User-Defined Date Field | 106 | 8 | AN | edi_vinv_mst.datefld |
| Customer User-Defined Decimal Field 1 | 114 | 12 | N2 | edi_vinv_mst.decifld1 |
| Customer User-Defined Decimal Field 2 | 126 | 12 | N2 | edi_vinv_mst.decifld2 |
| Customer User-Defined Decimal Field 3 | 138 | 12 | N2 | edi_vinv_mst.decifld3 |
| Customer User-Defined Logic Field | 150 | 1 | AN | edi_vinv_mst.logifld |
| Undefined | 151 | 25 | AN |
This table describes the fields in the vendor invoice detail:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 200 |
| Vendor Invoice Number | 11 | 22 | AN | edi_vinv_mst.vend_inv_num |
| Invoice Line Nbr | 33 | 3 | N0 | (ignore) |
| Site Identifier | 36 | 7 | AN | |
| Undefined | 43 | 3 | AN | |
| Line Number | 46 | 4 | N0 | edi_vinv_item.po_line |
| Release Number | 50 | 4 | N0 | edi_vinv_item.po_release |
| Item | 54 | 30 | AN | edi_vinv_item.item |
| Invoice Qty | 84 | 13 | N3 | edi_vinv_item.orig_vchr_qty_conv |
| Unit Of Measure | 97 | 3 | AN | edi_vinv_item.u_m |
| Invoice Unit Cost | 100 | 14 | N5 | edi_vinv_item.orig_unit_cost_conv |
| Undefined | 114 | 62 | AN |
855 (ORDRSP) Purchase Order Acknowledgment Flat File Layout
This table describes the fields in the PO acknowledgment header:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 100 |
| Purchase Order Number | 11 | 10 | AN | po_ack_mst.po_num, edi_po_ack_mst.po_num |
| PO Blanket Line Num | 21 | 4 | N0 | 0000 |
| Line/Release Num | 25 | 4 | N0 | 0000 |
| Site Identifier | 29 | 7 | AN | |
| Undefined | 36 | 5 | AN | |
| Vendor Order | 41 | 22 | AN |
|
| Terms | 63 | 3 | AN | po_mst.terms_code, edi_po_ack_mst.terms_code |
| Ship Via | 66 | 4 | AN | po_mst.ship_code, edi_po_ack_mst.ship_code |
| Undefined | 70 | 81 | AN |
This table describes the fields in the PO header text:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 110 |
| Purchase Order Number | 11 | 10 | AN | po_ack_mst.po_num |
| PO Blanket Line Num | 21 | 4 | N0 | 0000 |
| Line/Release Number | 25 | 4 | N0 | 0000 |
| Site Identifier | 29 | 7 | AN | |
| Undefined | 34 | 5 | AN | |
| Text | 41 | 40 | AN | SpecificNotes.NoteContent |
| Undefined | 81 | 70 | AN |
This table describes the user-defined fields:
USER-DEFINED FIELDS
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 120 |
| Purchase Order Number | 11 | 10 | AN | edi_ack_mst.po_num |
| PO Blanket Line Num | 21 | 4 | N0 | 0000 |
| Line/Release Number | 25 | 4 | N0 | 0000 |
| Site Identifier | 29 | 7 | AN | tp_code |
| Undefined | 36 | 5 | AN | |
| Customer User-Defined Character Field 1 | 41 | 20 | AN | edi_po_ack_mst.charfld1 |
| Customer User-Defined Character Field 2 | 61 | 20 | AN | edi_po_ack_mst.charfld2 |
| Customer User-Defined Character Field 3 | 81 | 20 | AN | edi_po_ack_mst.charfld3 |
| Customer User-Defined Date Field | 101 | 8 | AN | edi_po_ack_mst.datefld |
| Customer User-Defined Decimal Field 1 | 109 | 12 | AN | edi_po_ack_mst.decifld1 |
| Customer User-Defined Decimal Field 2 | 121 | 12 | AN | edi_po_ack_mst.decifld2 |
| Customer User-Defined Decimal Field 3 | 133 | 12 | AN | edi_po_ack_mst.decifld3 |
| Customer User-Defined Logic Field | 145 | 1 | AN | edi_po_ack_mst.logifld |
| Undefined | 146 | 5 | AN |
This table describes the fields in the Ack Blanket Header:
ACK BLANKET HEADER
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 200 |
| Purchase Order Number | 11 | 10 | AN | po_mst.po_num, edi_po_ack_bln_mst.po_num |
| PO Blanket Line Num | 21 | 4 | N0 | 0000 |
| Line/Release Number | 25 | 4 | N0 | 0000 |
| Site Identifier | 29 | 7 | AN | tp_code |
| Undefined | 36 | 5 | N0 | |
| Item | 41 | 30 | AN | edi_po_ack_bln_mst.item |
| Revision | 71 | 8 | AN | edi_po_ack_bln_mst.rev |
| Unit Of Measure | 79 | 3 | AN | edi_po_ack_bln_mst.u_m |
| Blanket Order Qty | 82 | 13 | N3 | edi_po_ack_bln_mst.blkt_qty_conv |
| Item Cost | 95 | 14 | N5 | edi_po_ack_bln_mst.item_cost_conv |
| Vendor Part Number | 109 | 30 | AN | edi_po_ack_bln_mst.vend_item |
| Undefined | 139 | 12 | AN |
This table describes the fields in the Ack Blanket Header Text:
ACK BLANKET HEADER TEXT
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 210 |
| Purchase Order Number | 11 | 10 | AN | po_mst.po_num, edi_po_ack_bln_mst.po_num |
| PO Blanket Line Num | 21 | 4 | N0 | edi_po_ack_bln_mst.po_line |
| Line/Release Number | 25 | 4 | N0 | 0000 |
| Site Identifier | 29 | 7 | AN | tp_code |
| Undefined | 36 | 5 | AN | |
| P.O. Text | 41 | 40 | AN | edi_po_ack_bln_mst.text |
| Undefined | 81 | 70 | AN |
This table describes the fields in Ack Release/Line Item:
ACK RELEASE/LINE ITEM
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 300 |
| Purchase Order Number | 11 | 10 | AN | po_mst.po_num, edi_po_ack_item_mst.po_num |
| PO Blanket Line Num | 21 | 4 | N0 | edi_po_ack_item_mst.po_line |
| Line/Release Number | 25 | 4 | N0 | edi_po_ack_item_mst.po_release |
| Site Identifier | 29 | 7 | AN | tp_code |
| Undefined | 36 | 5 | AN | |
| Item | 41 | 30 | AN | edi_po_ack_item_mst.item |
| Revision | 71 | 8 | AN | edi_po_ack_item_mst.rev |
| Unit Of Measure | 79 | 3 | AN | edi_po_ack_item_mst.ack_qty_u_m |
| Order Qty | 82 | 13 | N3 | edi_po_ack_item_mst.ack_qty_conv |
| Item Cost | 95 | 14 | N5 | edi_po_ack_item_mst.ack_item_cost_conv |
| Promise Date | 109 | 8 | DT | edi_po_ack_item_mst.ack_prom_date |
| Vendor Part Number | 117 | 30 | AN | edi_po_ack_item_mst.vend_item |
| Undefined | 147 | 4 | AN |
This table describes the fields in Ack Release/Line Item Text:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 310 |
| Purchase Order Number | 11 | 10 | AN | po_mst.po_num, edi_po_ack_item_mst.po_num |
| PO Blanket Line Num | 21 | 4 | N0 | edi_po_ack_item_mst.po_line |
| Line/Release Number | 25 | 4 | N0 | edi_po_ack_item_mst.po_release |
| Site Identifier | 29 | 7 | AN | tp_code |
| Undefined | 36 | 5 | AN | |
| P.O. Text | 41 | 40 | AN | edi_po_ack_mst.text |
| Undefined | 81 | 70 | AN |
856 (DESADV) Advance Ship Notice Flat File Layout
This table describes the fields in Vendor Ship Notice Header:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 100 |
| Vendor Shipment Number | 11 | 30 | AN | edi_vsn_mst.vend_ship_id |
| Shipment Seq Nbr | 41 | 3 | N0 | edi_vsn_mst.seq_num |
| Site Identifier | 44 | 7 | AN | tp_code |
| Undefined | 51 | 5 | AN | |
| Date Shipped | 56 | 8 | DT | edi_vsn_mst.ship_date (date portion) |
| Time Shipped | 64 | 6 | AN |
Format: HHMMSS |
| Ship Via Code | 70 | 4 | AN | edi_vsn_mst.ship_code |
| Total Weight | 74 | 14 | N2 | edi_vsn_mst.weight |
| # Packages | 88 | 3 | N0 | edi_vsn_mst.qty_packages |
| PO Number | 91 | 10 | AN | edi_vsn_mst.po_num |
| Freight Charges | 101 | 14 | N2 | edi_vsn_mst.freight |
| Undefined | 115 | 56 | AN |
This table describes the fields in User-Defined Fields:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN | You can enter 17 characters in the Trading Partner field but will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 110 |
| Vendor Shipment Number | 11 | 30 | N0 |
|
| Shipment Seq Nbr | 41 | 3 | N0 | edi_vsn_mst.seq_num |
| Site Identifier | 44 | 7 | AN | |
| Undefined | 51 | 5 | AN | |
| Customer User-Defined Character Field 1 | 56 | 20 | AN | edi_vsn_mst.charfld1 |
| Customer User-Defined Character Field 2 | 76 | 20 | AN | edi_vsn_mst.charfld2 |
| Customer User-Defined Character Field 3 | 96 | 20 | AN | edi_vsn_mst.charfld3 |
| Customer User-Defined Date Field | 116 | 8 | DT | edi_vsn_mst.datefld |
| Customer User-Defined Decimal Field 1 | 124 | 12 | N2 | edi_vsn_mst.decifld1 |
| Customer User-Defined Decimal Field 2 | 136 | 12 | N2 | edi_vsn_mst.decifld2 |
| Customer User-Defined Decimal Field 3 | 148 | 12 | N2 | edi_vsn_mst.decifld3 |
| Customer User-Defined Logic Field | 160 | 1 | AN | edi_vsn_mst.logifld |
| Undefined | 161 | 10 | AN |
This table describes the fields in Vendor Ship Notice Detail:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 200 |
| Vendor Shipment Number | 11 | 30 | N0 | edi_vsn_mst.vend_ship_id |
| Shipment Seq Nbr | 41 | 3 | N0 | edi_vsn_mst.seq_num |
| Site Identifier | 44 | 7 | AN | tp_code |
| Undefined | 51 | 5 | AN | |
| Line Number | 56 | 4 | N0 | edi_vsn_item_mst.po_line |
| Release Number | 60 | 4 | N0 | edi_vsn_item_mst.po_release |
| Item | 64 | 30 | AN | edi_vsn_item_mst.item |
| Qty Shipped | 94 | 13 | N3 | edi_vsn_item_mst.orig_ship_qty_conv |
| Unit Of Measure | 107 | 3 | AN | edi_vsn_item_mst.u_m |
| P.O. Num | 110 | 10 | AN | edi_vsn_item_mst.po_num |
| Container | 120 | 30 | AN | edi_vsn_item_mst.container |
| Undefined | 150 | 21 | AN |
This table describes the fields in Vendor Ship Notice Detail Text:
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Trading Partner Code | 1 | 7 | AN |
You can enter 17 characters in the Trading Partner field but SyteLine will only use 7 characters for exports. |
| Record Type | 8 | 3 | N0 | 210 |
| Vendor Shipment Number | 11 | 30 | N0 | edi_vsn_mst.vend_ship_id |
| Shipment Seq Nbr | 41 | 3 | N0 | edi_vsn_mst.seq_num |
| Site Identifier | 44 | 7 | AN | |
| Undefined | 51 | 5 | AN | |
| Ref Type | 56 | 1 | AN | edi_vsn_lot_serial_mst.ref_type |
| Ref Num | 57 | 30 | AN | edi_vsn_lot_serial_mst.ref_num |
| Ref Qty | 87 | 13 | N3 | edi_vsn_lot_serial_mst.ref_qty |
| Undefined | 100 | 71 | AN |