Inbound Supply EDI Transactions (Flat-File Layout)

NOTES:

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

VENDOR INVOICE HEADER

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

USER-DEFINED FIELDS

Field Description	Position	Length	Format	SyteLine 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
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

VENDOR INVOICE DETAIL

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

PO ACKNOWLEDGMENT HEADER

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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	edi_po_ack_mst.vend_order
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

PO HEADER TEXT

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

USER-DEFINED FIELDS

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

ACK BLANKET HEADER

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

ACK BLANKET HEADER TEXT

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

ACK RELEASE/LINE ITEM

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

ACK RELEASE/LINE ITEM TEXT

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

VENDOR SHIP NOTICE HEADER

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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	edi_vsn_mst.ship_date (time portion) 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

USER-DEFINED FIELDS

Field Description	Position	Length	Format	SyteLine 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
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
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

VENDOR SHIP NOTICE DETAIL

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

VENDOR SHIP NOTICE DETAIL TEXT

Field Description	Position	Length	Format	SyteLine Field or Notes
Trading Partner Code	1	7	AN	vend_tp_mst.tp_code 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

Related Topics

Electronic Data Interchange (EDI) Overview

Inbound Demand EDI Transactions - Flat-File Layout

Outbound Demand EDI Transactions - Flat File Layout

Outbound Supply EDI Transactions - Flat-File Layout