Inbound 820 (Payment Order/Remittance Advice) results in the document
automation of the Made2Manage Cash Receipts (CASH) screen. The layout of the
820 Fixed File Format is listed below. The hierarchy of each 820 transaction
is a single HDR segment followed by at least one DET segment.
Payment Currency Amount of Any Non- Cash Adjustment Applied
236
251
16
4
Y
GLCSHI.FNPYADJAMT
Payment Currency Amount in Cash Applied/Paid on This Invoice
252
267
16
4
Y
GLCSHI.FNPYCSHAMT
830 - Planning Schedule with Release Capability
Inbound 830 (Planning Schedule with Release Capability) results in the
document automation of the Made2Manage Orders (SO) screen. The layout of the
830 Fixed File Format is listed below. The hierarchy of each 830 transaction
is a single HDR segment followed by at least one DET segment followed by
optional REL segments. The REF, HDT and MSG records are extensions of the HDR
record. The PID and DDT records are extensions of the DET record. The HAC and
DAC records create line item records for special allowances and charges from
the header and item level respectively.
Tip: In HAC-1, the Discount Rate is calculated as the sum of all discount
rates when multiple HAC records are present.
830 - HDT
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘HDT’
1
3
3
0
C
’HDT’
X
Order Date
4
11
8
0
D
SOMAST.FORDERDATE
Due Date
12
19
8
0
D
SOMAST.FDUEDATE
User Defined Date 1
20
27
8
0
D
SOMAST.FDUSRDATE1
EDI Date 1
28
35
8
0
D
SOHDR.FCEDIDATE1
EDI Date 2
36
43
8
0
D
SOHDR.FCEDIDATE2
EDI Date 3
44
51
8
0
D
SOHDR.FCEDIDATE3
EDI Date 4
52
59
8
0
D
SOHDR.FCEDIDATE4
EDI Date 5
60
67
8
0
D
SOHDR.FCEDIDATE5
EDI Date 6
68
75
8
0
D
SOHDR.FCEDIDATE6
EDI Date 7
76
83
8
0
D
SOHDR.FCEDIDATE7
EDI Date 8
84
91
8
0
D
SOHDR.FCEDIDATE8
EDI Date 9
92
99
8
0
D
SOHDR.FCEDIDATE9
EDI Date 10
100
107
8
0
D
SOHDR.FCEDIDATE10
EDI Date 11
108
115
8
0
D
SOHDR.FCEDIDATE11
EDI Date 12
116
123
8
0
D
SOHDR.FCEDIDATE12
EDI Date 13
124
131
8
0
D
SOHDR.FCEDIDATE13
EDI Date 14
132
139
8
0
D
SOHDR.FCEDIDATE14
EDI Date 15
140
147
8
0
D
SOHDR.FCEDIDATE15
830 - MSG
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘MSG’
1
3
3
0
C
’MSG’
X
User Defined Memo 1
4
83
80
0
M
SOMAST.FMUSRMEMO1
EDI Memo 1
84
163
80
0
M
SOHDR.FCEDIMEMO1
EDI Memo 2
164
243
80
0
M
SOHDR.FCEDIMEMO2
830 - DET
Note: All the fields marked with X must be selected.
Only one of the fields marked X1 must be selected.
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DET’
1
3
3
0
C
’DET’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
X1
Part Revision
29
31
3
0
C
SOITEM.FPARTREV
Quantity
32
47
16
5
N
SOITEM.FQUANTITY
X
Unit of Measure
48
50
3
0
C
SOITEM.FMEASURE
Source
51
51
1
0
C
SOITEM.FSOURCE
Part Number Description Line 1
52
131
80
0
M
SOITEM.FDESC
Part Number Description Line 2
132
211
80
0
M
SOITEM.FDESC
Product Class
212
215
4
0
C
SOITEM.FPRODCL
Group Code
216
221
6
0
C
SOITEM.FGROUP
Unit Price
222
237
16
5
N
SORELS.FUNETPRICE
Customer Part Number
238
262
25
0
C
SOITEM.FCUSTPART
X1
Customer Part Revision
263
265
3
0
C
SOITEM.FCUSTPTREV
Customer Part Description Line 1
266
345
80
0
M
SOITEM.FDESCMEMO
Customer Part Description Line 2
346
425
80
0
M
SOITEM.FDESCMEMO
Delivery Notes Line 1
426
505
80
0
M
SORELS.FDELIVERY
Delivery Notes Line 2
506
585
80
0
M
SORELS.FDELIVERY
Order Billing Type
586
588
3
0
C
SOITEM.FORDERTYPE
Use Standard BOMs and Routings
589
589
1
0
L
SOITEM.FSTANDPART
Lot/Serial Number Required
590
590
1
0
L
SOITEM.FLLOTREQD
Extent of Lot Control
591
591
1
0
C
SOITEM.FCLOTEXT
Taxable
592
592
1
0
L
SORELS.FLISTAXABL
Price Schedule Code
593
598
6
0
C
SOITEM.FSCHECODE
Ship-to Address Key
599
618
20
0
C
SORELS.FSHPTOADDR
Due Date
619
626
8
0
D
SOITEM.FDUEDATE
Close within minimum %
627
637
11
5
N
SOITEM.FNUNDER
Close within maximum %
638
648
11
5
N
SOITEM.FNOVER
Multi-Release
649
649
1
0
L
SOITEM.FMULTIPLE
Ship Item
650
650
1
0
L
SOITEM.FSHIPITEM
Split Ship
651
651
1
0
L
SORELS.FSPLITSHP
Create Jobs
652
652
1
0
L
SOITEM.FAUTOCREAT
Print Memo
653
653
1
0
L
SOITEM.FPRINTMEMO
Ship Early
654
654
1
0
L
SORELS.FSHPBEFDUE
CTP Approved
655
655
1
0
L
SORELS.FLATP
EDI Character 1
656
675
20
0
C
SODET.FCEDICHAR1
EDI Character 2
676
695
20
0
C
SODET.FCEDICHAR2
EDI Character 3
696
715
20
0
C
SODET.FCEDICHAR3
EDI Character 4
716
735
20
0
C
SODET.FCEDICHAR4
EDI Character 5
736
755
20
0
C
SODET.FCEDICHAR5
EDI Character 6
756
775
20
0
C
SODET.FCEDICHAR6
EDI Character 7
776
795
20
0
C
SODET.FCEDICHAR7
EDI Character 8
796
815
20
0
C
SODET.FCEDICHAR8
EDI Character 9
816
835
20
0
C
SODET.FCEDICHAR9
EDI Character 10
836
855
20
0
C
SODET.FCEDICHAR10
EDI Character 11
856
875
20
0
C
SODET.FCEDICHAR11
EDI Character 12
876
895
20
0
C
SODET.FCEDICHAR12
EDI Character 13
896
915
20
0
C
SODET.FCEDICHAR13
EDI Character 14
916
935
20
0
C
SODET.FCEDICHAR14
EDI Character 15
936
955
20
0
C
SODET.FCEDICHAR15
EDI Date 1
956
963
8
0
D
SODET.FCEDIDATE1
EDI Date 2
964
971
8
0
D
SODET.FCEDIDATE2
EDI Date 3
972
979
8
0
D
SODET.FCEDIDATE3
EDI Date 4
980
987
8
0
D
SODET.FCEDIDATE4
EDI Date 5
988
995
8
0
D
SODET.FCEDIDATE5
EDI Date 6
996
1003
8
0
D
SODET.FCEDIDATE6
EDI Date 7
1004
1011
8
0
D
SODET.FCEDIDATE7
EDI Date 8
1012
1019
8
0
D
SODET.FCEDIDATE8
EDI Date 9
1020
1027
8
0
D
SODET.FCEDIDATE9
EDI Date 10
1028
1035
8
0
D
SODET.FCEDIDATE10
EDI Date 11
1036
1043
8
0
D
SODET.FCEDIDATE11
EDI Date 12
1044
1051
8
0
D
SODET.FCEDIDATE12
EDI Date 13
1052
1059
8
0
D
SODET.FCEDIDATE13
EDI Date 14
1060
1067
8
0
D
SODET.FCEDIDATE14
EDI Date 15
1068
1075
8
0
D
SODET.FCEDIDATE15
EDI Numeric 1
1076
1091
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
1092
1107
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
1108
1123
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
1124
1139
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
1140
1155
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
1156
1171
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
1172
1187
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
1188
1203
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
1204
1219
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
1220
1235
16
5
N
SODET.FCEDINUM10
EDI Memo 1 Line 1
1236
1315
80
0
M
SODET.FCEDIMEMO1
EDI Memo 1 Line 2
1316
1395
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2 Line 1
1396
1475
80
0
M
SODET.FCEDIMEMO2
EDI Memo 2 Line 2
1476
1555
80
0
M
SODET.FCEDIMEMO2
Price Schedule Type
1556
1556
1
0
C
SOITEM.FSCHEDTYPE
Quantity in Alternate Unit of Measure
1557
1573
17
5
N
SOITEM.FNALTQTY
Alternate Unit of Measure
1574
1576
3
0
C
SOITEM.FCALTUM
Location
1577
1590
14
0
C
SORELS.FCLOC
Bin
1591
1604
14
0
C
SORELS.FCBIN
Contract
1605
1614
10
0
C
SOITEM.CONTRACTNU
Selling U/M Quantity
1615
1629
15
5
N
SOITEM.FNALTSQTY
X1
Selling U/M
1630
1632
3
0
C
SOITEM.FCALSTUM
X1
Selling U/M Unit Price
1633
1648
16
5
N
SOITEM.FSUNITPRICE
X1
830 - PID
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘PID’
1
3
3
0
C
’PID
X
Part Number Description
4
83
80
0
M
SOITEM.FDESC
Customer Part Number Description
84
163
80
0
M
SOITEM.FDESCMEMO
Delivery Notes
164
243
80
0
M
SORELS.FDELIVERY
EDI Memo 1
244
323
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
324
403
80
0
M
SODET.FCEDIMEMO2
830 - DDT
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DDT’
1
3
3
0
C
’DDT’
X
Delivery Notes
4
83
80
0
M
SORELS.FDELIVERY
Due Date
84
91
8
0
D
SOITEM.FDUEDATE
EDI Date 1
92
99
8
0
D
SODET.FCEDIDATE1
EDI Date 2
100
107
8
0
D
SODET.FCEDIDATE2
EDI Date 3
108
115
8
0
D
SODET.FCEDIDATE3
EDI Date 4
116
123
8
0
D
SODET.FCEDIDATE4
EDI Date 5
124
131
8
0
D
SODET.FCEDIDATE5
EDI Date 6
132
139
8
0
D
SODET.FCEDIDATE6
EDI Date 7
140
147
8
0
D
SODET.FCEDIDATE7
EDI Date 8
148
155
8
0
D
SODET.FCEDIDATE8
EDI Date 9
156
163
8
0
D
SODET.FCEDIDATE9
EDI Date 10
164
171
8
0
D
SODET.FCEDIDATE10
EDI Date 11
172
179
8
0
D
SODET.FCEDIDATE11
EDI Date 12
180
187
8
0
D
SODET.FCEDIDATE12
EDI Date 13
188
195
8
0
D
SODET.FCEDIDATE13
EDI Date 14
196
203
8
0
D
SODET.FCEDIDATE14
EDI Date 15
204
211
8
0
D
SODET.FCEDIDATE15
830 - DAC
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DAC’
1
3
3
0
C
’DAC’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
Quantity
29
44
16
5
N
SOITEM.FQUANTITY
Unit of Measure
45
47
3
0
C
SOITEM.FMEASURE
Part Number Description
48
127
80
0
M
SOITEM.FDESC
Unit Price
128
143
16
5
N
SORELS.FUNETPRICE
Customer Part Number
144
168
25
0
C
SOITEM.FCUSTPART
Customer Part Number Description
169
248
80
0
M
SOITEM.FDESCMEMO
EDI Character 1
249
268
20
0
C
SODET.FCEDICHAR1
EDI Character 2
269
288
20
0
C
SODET.FCEDICHAR2
EDI Character 3
289
308
20
0
C
SODET.FCEDICHAR3
EDI Character 4
309
328
20
0
C
SODET.FCEDICHAR4
EDI Character 5
329
348
20
0
C
SODET.FCEDICHAR5
EDI Character 6
349
368
20
0
C
SODET.FCEDICHAR6
EDI Character 7
369
388
20
0
C
SODET.FCEDICHAR7
EDI Character 8
389
408
20
0
C
SODET.FCEDICHAR8
EDI Character 9
409
428
20
0
C
SODET.FCEDICHAR9
EDI Character 10
429
448
20
0
C
SODET.FCEDICHAR10
EDI Character 11
449
468
20
0
C
SODET.FCEDICHAR11
EDI Character 12
469
488
20
0
C
SODET.FCEDICHAR12
EDI Character 13
489
508
20
0
C
SODET.FCEDICHAR13
EDI Character 14
509
528
20
0
C
SODET.FCEDICHAR14
EDI Character 15
529
548
20
0
C
SODET.FCEDICHAR15
EDI Numeric 1
549
564
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
565
580
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
581
596
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
597
612
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
613
628
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
629
644
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
645
660
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
661
676
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
677
692
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
693
708
16
5
N
SODET.FCEDINUM10
EDI Memo 1
709
788
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
789
868
80
0
M
SODET.FCEDIMEMO2
Discount Rate
869
875
7
3
N
SORELS.FUNETPRICE1
Tip: In DAC-1, allowance or charge discount rate is calculated as the sum of
all discount rates when multiple DAC records are present for a line item and a
unit discount amount calculated as a function of the parent unit price and the
calculated discount.
830 - REL
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘REL’
1
3
3
0
C
’REL’
x
Ship-To Address Key
4
23
20
0
C
SORELS.FSHPTOADDR
Due Date
24
31
8
0
D
SORELS.FDUEDATE
Delivery Notes Line 1
32
111
80
0
M
SORELS.FDELIVERY
Delivery Notes Line 2
112
191
80
0
M
SORELS.FDELIVERY
Taxable
192
192
1
0
L
SORELS.FLISTAXABL
Allow Split Shipments
193
193
1
0
L
SORELS.FSPLITSHP
Ship Early
194
194
1
0
L
SORELS.FSHPBEFDUE
Release Quantity
195
208
14
5
N
SORELS.FORDERQTY
Unit Price
209
224
16
5
N
SORELS.FUNETPRICE
Ship-To Address Key 2
225
244
20
0
C
SORELS.FSHPTOADDR
Release Quantity 2
245
258
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 3
259
278
20
0
C
SORELS.FSHPTOADDR
Release Quantity 3
279
292
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 4
293
312
20
0
C
SORELS.FSHPTOADDR
Release Quantity 4
313
326
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 5
327
346
20
0
C
SORELS.FSHPTOADDR
Release Quantity 5
347
360
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 6
361
380
20
0
C
SORELS.FSHPTOADDR
Release Quantity 6
381
394
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 7
395
414
20
0
C
SORELS.FSHPTOADDR
Release Quantity 7
415
428
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 8
429
448
20
0
C
SORELS.FSHPTOADDR
Release Quantity 8
449
462
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 9
463
482
20
0
C
SORELS.FSHPTOADDR
Release Quantity 9
483
496
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 10
497
516
20
0
C
SORELS.FSHPTOADDR
Release Quantity 10
517
530
14
5
N
SORELS.FORDERQTY
Release Selling U/M Quantity
531
545
15
5
N
SORELS.FSORDERQTY
X1
Selling U/M Unit Price
546
561
16
5
N
SORELS.FSUNETPRICE
X1
840 - Request for Quote
Inbound 840 (Request for Quote) results in the document automation of the
Made2Manage Quotes (QUOTE) screen. The layout of the 840 Fixed File Format is
listed below. The hierarchy of each 840 transaction is a single HDR segment
followed by at least one DET segment.
Note: All the fields marked X must be selected. Only one of the fields marked
X1 must be selected.
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DET’
1
3
3
0
C
’DET’
X
Part Number
4
28
25
0
C
QTITEM.FPARTNO
X1
Part Revision Number
29
31
3
0
C
QTITEM.FPARTREV
Description Line 1
32
111
80
0
M
QTITEM.FDESC
Description Line 2
112
191
80
0
M
QTITEM.FDESC
Customer Part Number
192
216
25
0
C
QTITEM.FCUSTPART
X1
Customer Part Number Revision
217
219
3
0
C
QTITEM.FCUSTPTREV
Item Source
220
220
1
0
C
QTITEM.FSOURCE
Product Class
221
224
4
0
C
QTITEM.FPRODCL
Group Code
225
230
6
0
C
QTITEM.FGROUP
External Item Number
231
233
3
0
C
QTITEM.FENUMBER
BOM or Routing has been Changed
234
234
1
0
L
QTITEM.FSTANDPART
Delivery Notes Line 1
235
314
80
0
M
QTITEM.FDELIVERY
Delivery Notes Line 2
315
394
80
0
M
QTITEM.FDELIVERY
Part Additional Instruction Memo Line 1
395
474
80
0
M
QTITEM.FDESCMEMO
Part Additional Instruction Memo Line 2
475
554
80
0
M
QTITEM.FDESCMEMO
Item Description Print Memo
555
555
1
0
L
QTITEM.FPRINTMEMO
Default Estimate Quantity
556
569
14
5
N
QTITEM.FESTQTY
Quantity Unit of Measure
570
572
3
0
C
QTITEM.FMEASURE
Unit Selling Price
573
588
16
5
N
QTITEM.FUNETPRICE
Price Schedule Code
589
594
6
0
C
QTITEM.FSCHECODE
Lot Required
595
595
1
0
L
QTITEM.FLLOTREQD
Lot Text
596
596
1
0
C
QTITEM.FCLOTEXT
Taxable Item
597
597
1
0
L
QTITEM.FLISTAXABL
Default Estimate Selling U/M Quantity
598
612
15
5
N
QTITEM.FSESTQTY
X1
Selling U/M
613
615
3
0
C
QTITEM.FSMEASURE
X1
Selling U/M Unit Price
616
631
16
5
N
QTITEM.FSUNETPRICE
X1
850 - Purchase Order
Inbound 850 (Purchase Order) results in the document automation of the
Made2Manage Orders (SO) screen. The layout of the 850 Fixed File Format is
listed below. The hierarchy of each 850 transaction is a single HDR segment
followed by at least one DET segment followed by optional REL segments.
The REF, HDT and MSG records are extensions of the HDR record. The PID and DDT
records are extensions of the DET record. The HAC and DAC records create line-
item records for special allowances and charges from the header and item level
respectively.
Tip: In HAC-1, the Discount Rate is calculated as the sum of all discount
rates when multiple HAC records are present.
850-HDT
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘HDT’
1
3
3
0
C
’HDT’
X
Order Date
4
11
8
0
D
SOMAST.FORDERDATE
Due Date
12
19
8
0
D
SOMAST.FDUEDATE
User Defined Date 1
20
27
8
0
D
SOMAST.FDUSRDATE1
EDI Date 1
28
35
8
0
D
SOHDR.FCEDIDATE1
EDI Date 2
36
43
8
0
D
SOHDR.FCEDIDATE2
EDI Date 3
44
51
8
0
D
SOHDR.FCEDIDATE3
EDI Date 4
52
59
8
0
D
SOHDR.FCEDIDATE4
EDI Date 5
60
67
8
0
D
SOHDR.FCEDIDATE5
EDI Date 6
68
75
8
0
D
SOHDR.FCEDIDATE6
EDI Date 7
76
83
8
0
D
SOHDR.FCEDIDATE7
EDI Date 8
84
91
8
0
D
SOHDR.FCEDIDATE8
EDI Date 9
92
99
8
0
D
SOHDR.FCEDIDATE9
EDI Date 10
100
107
8
0
D
SOHDR.FCEDIDATE10
EDI Date 11
108
115
8
0
D
SOHDR.FCEDIDATE11
EDI Date 12
116
123
8
0
D
SOHDR.FCEDIDATE12
EDI Date 13
124
131
8
0
D
SOHDR.FCEDIDATE13
EDI Date 14
132
139
8
0
D
SOHDR.FCEDIDATE14
EDI Date 15
140
147
8
0
D
SOHDR.FCEDIDATE15
850-MSG
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘MSG’
1
3
3
0
C
’MSG’
X
User Defined Memo 1
4
83
80
0
M
SOMAST.FMUSRMEMO1
EDI Memo 1
84
163
80
0
M
SOHDR.FCEDIMEMO1
EDI Memo 2
164
243
80
0
M
SOHDR.FCEDIMEMO2
850-DET
Note: All the fields marked with X must be selected.
Only one of the fields marked X1 must be selected.
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DET’
1
3
3
0
C
’DET’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
X1
Part Revision
29
31
3
0
C
SOITEM.FPARTREV
Quantity
32
47
16
5
N
SOITEM.FQUANTITY
X
Unit of Measure
48
50
3
0
C
SOITEM.FMEASURE
Source
51
51
1
0
C
SOITEM.FSOURCE
Part Number Description Line 1
52
131
80
0
M
SOITEM.FDESC
Part Number Description Line 2
132
211
80
0
M
SOITEM.FDESC
Product Class
212
215
4
0
C
SOITEM.FPRODCL
Group Code
216
221
6
0
C
SOITEM.FGROUP
Unit Price
222
237
16
5
N
SORELS.FUNETPRICE
Customer Part Number
238
262
25
0
C
SOITEM.FCUSTPART
X1
Customer Part Revision
263
265
3
0
C
SOITEM.FCUSTPTREV
Customer Part Description Line 1
266
345
80
0
M
SOITEM.FDESCMEMO
Customer Part Description Line 2
346
425
80
0
M
SOITEM.FDESCMEMO
Delivery Notes Line 1
426
505
80
0
M
SORELS.FDELIVERY
Delivery Notes Line 2
506
585
80
0
M
SORELS.FDELIVERY
Order Billing Type
586
588
3
0
C
SOITEM.FORDERTYPE
Use Standard BOMs and Routings
589
589
1
0
L
SOITEM.FSTANDPART
Lot/Serial Number Required
590
590
1
0
L
SOITEM.FLLOTREQD
Extent of Lot Control
591
591
1
0
C
SOITEM.FCLOTEXT
Taxable
592
592
1
0
L
SORELS.FLISTAXABL
Price Schedule Code
593
598
6
0
C
SOITEM.FSCHECODE
Ship-to Address Key
599
618
20
0
C
SORELS.FSHPTOADDR
Due Date
619
626
8
0
D
SOITEM.FDUEDATE
Close within minimum %
627
637
11
5
N
SOITEM.FNUNDER
Close within maximum %
638
648
11
5
N
SOITEM.FNOVER
Multi-Release
649
649
1
0
L
SOITEM.FMULTIPLE
Ship Item
650
650
1
0
L
SOITEM.FSHIPITEM
Split Ship
651
651
1
0
L
SORELS.FSPLITSHP
Create Jobs
652
652
1
0
L
SOITEM.FAUTOCREAT
Print Memo
653
653
1
0
L
SOITEM.FPRINTMEMO
Ship Early
654
654
1
0
L
SORELS.FSHPBEFDUE
CTP Approved
655
655
1
0
L
SORELS.FLATP
EDI Character 1
656
675
20
0
C
SODET.FCEDICHAR1
EDI Character 2
676
695
20
0
C
SODET.FCEDICHAR2
EDI Character 3
696
715
20
0
C
SODET.FCEDICHAR3
EDI Character 4
716
735
20
0
C
SODET.FCEDICHAR4
EDI Character 5
736
755
20
0
C
SODET.FCEDICHAR5
EDI Character 6
756
775
20
0
C
SODET.FCEDICHAR6
EDI Character 7
776
795
20
0
C
SODET.FCEDICHAR7
EDI Character 8
796
815
20
0
C
SODET.FCEDICHAR8
EDI Character 9
816
835
20
0
C
SODET.FCEDICHAR9
EDI Character 10
836
855
20
0
C
SODET.FCEDICHAR10
EDI Character 11
856
875
20
0
C
SODET.FCEDICHAR11
EDI Character 12
876
895
20
0
C
SODET.FCEDICHAR12
EDI Character 13
896
915
20
0
C
SODET.FCEDICHAR13
EDI Character 14
916
935
20
0
C
SODET.FCEDICHAR14
EDI Character 15
936
955
20
0
C
SODET.FCEDICHAR15
EDI Date 1
956
963
8
0
D
SODET.FCEDIDATE1
EDI Date 2
964
971
8
0
D
SODET.FCEDIDATE2
EDI Date 3
972
979
8
0
D
SODET.FCEDIDATE3
EDI Date 4
980
987
8
0
D
SODET.FCEDIDATE4
EDI Date 5
988
995
8
0
D
SODET.FCEDIDATE5
EDI Date 6
996
1003
8
0
D
SODET.FCEDIDATE6
EDI Date 7
1004
1011
8
0
D
SODET.FCEDIDATE7
EDI Date 8
1012
1019
8
0
D
SODET.FCEDIDATE8
EDI Date 9
1020
1027
8
0
D
SODET.FCEDIDATE9
EDI Date 10
1028
1035
8
0
D
SODET.FCEDIDATE10
EDI Date 11
1036
1043
8
0
D
SODET.FCEDIDATE11
EDI Date 12
1044
1051
8
0
D
SODET.FCEDIDATE12
EDI Date 13
1052
1059
8
0
D
SODET.FCEDIDATE13
EDI Date 14
1060
1067
8
0
D
SODET.FCEDIDATE14
EDI Date 15
1068
1075
8
0
D
SODET.FCEDIDATE15
EDI Numeric 1
1076
1091
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
1092
1107
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
1108
1123
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
1124
1139
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
1140
1155
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
1156
1171
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
1172
1187
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
1188
1203
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
1204
1219
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
1220
1235
16
5
N
SODET.FCEDINUM10
EDI Memo 1 Line 1
1236
1315
80
0
M
SODET.FCEDIMEMO1
EDI Memo 1 Line 2
1316
1395
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2 Line 1
1396
1475
80
0
M
SODET.FCEDIMEMO2
EDI Memo 2 Line 2
1476
1555
80
0
M
SODET.FCEDIMEMO2
Price Schedule Type
1556
1556
1
0
C
SOITEM.FSCHEDTYPE
Quantity in Alternate Unit of Measure
1557
1573
17
5
N
SOITEM.FNALTQTY
Alternate Unit of Measure
1574
1576
3
0
C
SOITEM.FCALTUM
Location
1577
1590
14
0
C
SORELS.FCLOC
Bin
1591
1604
14
0
C
SORELS.FCBIN
Contract
1605
1614
10
0
C
SOITEM.CONTRACTNU
Selling U/M Quantity
1615
1629
15
5
N
SOITEM.FNALTSQTY
X1
Selling U/M
1630
1632
3
0
C
SOITEM.FCALSTUM
X1
Selling U/M Unit Price
1633
1648
16
5
N
SOITEM.FSUNITPRICE
X1
850-PID
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘PID’
1
3
3
0
C
’PID
X
Part Number Description
4
83
80
0
M
SOITEM.FDESC
Customer Part Number Description
84
163
80
0
M
SOITEM.FDESCMEMO
Delivery Notes
164
243
80
0
M
SORELS.FDELIVERY
EDI Memo 1
244
323
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
324
403
80
0
M
SODET.FCEDIMEMO2
EDI Character 1
404
423
20
0
C
SODET.FCEDICHAR1
EDI Character 2
424
443
20
0
C
SODET.FCEDICHAR2
EDI Character 3
444
463
20
0
C
SODET.FCEDICHAR3
EDI Character 4
464
483
20
0
C
SODET.FCEDICHAR4
EDI Character 5
484
503
20
0
C
SODET.FCEDICHAR5
EDI Character 6
504
523
20
0
C
SODET.FCEDICHAR6
EDI Character 7
524
543
20
0
C
SODET.FCEDICHAR7
EDI Character 8
544
563
20
0
C
SODET.FCEDICHAR8
EDI Character 9
564
583
20
0
C
SODET.FCEDICHAR9
EDI Character 10
584
603
20
0
C
SODET.FCEDICHAR10
EDI Character 11
604
623
20
0
C
SODET.FCEDICHAR11
EDI Character 12
624
643
20
0
C
SODET.FCEDICHAR12
EDI Character 13
644
663
20
0
C
SODET.FCEDICHAR13
EDI Character 14
664
683
20
0
C
SODET.FCEDICHAR14
EDI Character 15
684
703
20
0
C
SODET.FCEDICHAR15
EDI Numeric 1
704
719
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
720
735
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
736
751
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
752
767
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
768
783
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
784
799
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
800
815
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
816
831
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
832
847
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
848
863
16
5
N
SODET.FCEDINUM10
850-DDT
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DDT’
1
3
3
0
C
’DDT’
X
Delivery Notes
4
83
80
0
M
SORELS.FDELIVERY
Due Date
84
91
8
0
D
SOITEM.FDUEDATE
EDI Date 1
92
99
8
0
D
SODET.FCEDIDATE1
EDI Date 2
100
107
8
0
D
SODET.FCEDIDATE2
EDI Date 3
108
115
8
0
D
SODET.FCEDIDATE3
EDI Date 4
116
123
8
0
D
SODET.FCEDIDATE4
EDI Date 5
124
131
8
0
D
SODET.FCEDIDATE5
EDI Date 6
132
139
8
0
D
SODET.FCEDIDATE6
EDI Date 7
140
147
8
0
D
SODET.FCEDIDATE7
EDI Date 8
148
155
8
0
D
SODET.FCEDIDATE8
EDI Date 9
156
163
8
0
D
SODET.FCEDIDATE9
EDI Date 10
164
171
8
0
D
SODET.FCEDIDATE10
EDI Date 11
172
179
8
0
D
SODET.FCEDIDATE11
EDI Date 12
180
187
8
0
D
SODET.FCEDIDATE12
EDI Date 13
188
195
8
0
D
SODET.FCEDIDATE13
EDI Date 14
196
203
8
0
D
SODET.FCEDIDATE14
EDI Date 15
204
211
8
0
D
SODET.FCEDIDATE15
850-DAC
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DAC’
1
3
3
0
C
’DAC’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
Quantity
29
44
16
5
N
SOITEM.FQUANTITY
Unit of Measure
45
47
3
0
C
SOITEM.FMEASURE
Part Number Description
48
127
80
0
M
SOITEM.FDESC
Unit Price
128
143
16
5
N
SORELS.FUNETPRICE
Customer Part Number
144
168
25
0
C
SOITEM.FCUSTPART
Customer Part Number Description
169
248
80
0
M
SOITEM.FDESCMEMO
EDI Character 1
249
268
20
0
C
SODET.FCEDICHAR1
EDI Character 2
269
288
20
0
C
SODET.FCEDICHAR2
EDI Character 3
289
308
20
0
C
SODET.FCEDICHAR3
EDI Character 4
309
328
20
0
C
SODET.FCEDICHAR4
EDI Character 5
329
348
20
0
C
SODET.FCEDICHAR5
EDI Character 6
349
368
20
0
C
SODET.FCEDICHAR6
EDI Character 7
369
388
20
0
C
SODET.FCEDICHAR7
EDI Character 8
389
408
20
0
C
SODET.FCEDICHAR8
EDI Character 9
409
428
20
0
C
SODET.FCEDICHAR9
EDI Character 10
429
448
20
0
C
SODET.FCEDICHAR10
EDI Character 11
449
468
20
0
C
SODET.FCEDICHAR11
EDI Character 12
469
488
20
0
C
SODET.FCEDICHAR12
EDI Character 13
489
508
20
0
C
SODET.FCEDICHAR13
EDI Character 14
509
528
20
0
C
SODET.FCEDICHAR14
EDI Character 15
529
548
20
0
C
SODET.FCEDICHAR15
EDI Numeric 1
549
564
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
565
580
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
581
596
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
597
612
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
613
628
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
629
644
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
645
660
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
661
676
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
677
692
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
693
708
16
5
N
SODET.FCEDINUM10
EDI Memo 1
709
788
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
789
868
80
0
M
SODET.FCEDIMEMO2
Discount Rate
869
875
7
3
N
SORELS.FUNETPRICE1
Tip: In DAC-1, allowance or charge discount rate is calculated as the sum of
all discount rates when multiple DAC records are present for a line item and a
unit discount amount calculated as a function of the parent unit price and the
calculated discount.
850-REL
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘REL’
1
3
3
0
C
’REL’
X
Ship-To Address Key
4
23
20
0
C
SORELS.FSHPTOADDR
Due Date
24
31
8
0
D
SORELS.FDUEDATE
Delivery Notes Line 1
32
111
80
0
M
SORELS.FDELIVERY
Delivery Notes Line 2
112
191
80
0
M
SORELS.FDELIVERY
Taxable
192
192
1
0
L
SORELS.FLISTAXABL
Allow Split Shipments
193
193
1
0
L
SORELS.FSPLITSHP
Ship Early
194
194
1
0
L
SORELS.FSHPBEFDUE
Release Quantity
195
208
14
5
N
SORELS.FORDERQTY
Unit Price
209
224
16
5
N
SORELS.FUNETPRICE
Ship-To Address Key 2
225
244
20
0
C
SORELS.FSHPTOADDR
Release Quantity 2
245
258
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 3
259
278
20
0
C
SORELS.FSHPTOADDR
Release Quantity 3
279
292
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 4
293
312
20
0
C
SORELS.FSHPTOADDR
Release Quantity 4
313
326
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 5
327
346
20
0
C
SORELS.FSHPTOADDR
Release Quantity 5
347
360
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 6
361
380
20
0
C
SORELS.FSHPTOADDR
Release Quantity 6
381
394
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 7
395
414
20
0
C
SORELS.FSHPTOADDR
Release Quantity 7
415
428
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 8
429
448
20
0
C
SORELS.FSHPTOADDR
Release Quantity 8
449
462
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 9
463
482
20
0
C
SORELS.FSHPTOADDR
Release Quantity 9
483
496
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 10
497
516
20
0
C
SORELS.FSHPTOADDR
Release Quantity 10
517
530
14
5
N
SORELS.FORDERQTY
Release Selling U/M Quantity
531
545
15
5
N
SORELS.FSORDERQTY
X1
Selling U/M Unit Price
546
561
16
5
N
SORELS.FSUNETPRICE
X1
860 - Purchase Order Change
Inbound 860 (Purchase Order Change) results in the document automation of the
Made2Manage Orders (SO) screen. The layout of the 860 Fixed File Format is
listed below. The hierarchy of each 860 transaction is a single HDR segment
followed by at least one DET segment followed by optional REL segments. The
REF, HDT and MSG records are extensions of the HDR record. The PID and DDT
records are extensions of the DET record. The HAC and DAC records create line-
item records for special allowances and charges from the header and item level
respectively.
860-HDR
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘HDR’
1
3
3
0
C
’HDR’
X
Trading Partner EDI ID*
4
23
20
0
C
SOMAST.FCUSTNO
X
Customer Purchase Order Number*
24
43
20
0
C
SOMAST.FCUSTPONO
X
Company Name
44
78
35
0
C
SOMAST.FCOMPANY
Sold-To Address Key
79
98
20
0
C
SOMAST.FSOLDADDR
Sold-To Address Line 1
99
178
80
0
M
SOMAST.FMSTREET
Sold-To Address Line 2
179
258
80
0
M
SOMAST.FMSTREET
City
259
278
20
0
C
SOMAST.FCITY
State
279
298
20
0
C
SOMAST.FSTATE
Zip Code
299
308
10
0
C
SOMAST.FZIP
Country
309
333
25
0
C
SOMAST.FCOUNTRY
Contact First Name
334
348
15
0
C
SOMAST.FCFNAME
Contact Last Name
349
378
30
0
C
SOMAST.FCONTACT
Phone Number
379
398
20
0
C
SOMAST.FPHONE
Fax Number
399
418
20
0
C
SOMAST.FFAX
Sales Order Name
419
453
35
0
C
SOMAST.FORDERNAME
Order Date
454
461
8
0
D
SOMAST.FORDERDATE
Due Date
462
469
8
0
D
SOMAST.FDUEDATE
Discount Rate
470
476
7
3
N
SOMAST.FDISRATE
Sales Order Transaction Currency
477
479
3
0
C
SOMAST.FCCURID
Ship To Address Key
480
499
20
0
C
SOMAST.FSHPTOADDR
Ship Via
500
519
20
0
C
SOMAST.FSHIPVIA
Payment Type
520
520
1
0
C
SOMAST.FPAYTYPE
Terms For A Cash Payment
521
524
4
0
C
SOMAST.FTERM
Freight on Board Point
525
544
20
0
C
SOMAST.FFOB
User Defined Character 1
545
564
20
0
C
SOMAST.FCUSRCHR1
User Defined Character 2
565
604
40
0
C
SOMAST.FCUSRCHR2
User Defined Character 3
605
644
40
0
C
SOMAST.FCUSRCHR3
User Defined Quantity 1
645
658
14
5
N
SOMAST.FNUSRQTY1
User Defined Currency 1
659
674
16
5
N
SOMAST.FNUSRCUR1
User Defined Date 1
675
682
8
0
D
SOMAST.FDUSRDATE1
User Defined Memo 1 Line 1
683
762
80
0
M
SOMAST.FMUSRMEMO1
User Defined Memo 1 Line 2
763
842
80
0
M
SOMAST.FMUSRMEMO1
EDI Character 1
843
862
20
0
C
SOHDR.FCEDICHAR1
EDI Character 2
863
882
20
0
C
SOHDR.FCEDICHAR2
EDI Character 3
883
902
20
0
C
SOHDR.FCEDICHAR3
EDI Character 4
903
922
20
0
C
SOHDR.FCEDICHAR4
EDI Character 5
923
942
20
0
C
SOHDR.FCEDICHAR5
EDI Character 6
943
962
20
0
C
SOHDR.FCEDICHAR6
EDI Character 7
963
982
20
0
C
SOHDR.FCEDICHAR7
EDI Character 8
983
1002
20
0
C
SOHDR.FCEDICHAR8
EDI Character 9
1003
1022
20
0
C
SOHDR.FCEDICHAR9
EDI Character 10
1023
1042
20
0
C
SOHDR.FCEDICHAR10
EDI Character 11
1043
1062
20
0
C
SOHDR.FCEDICHAR11
EDI Character 12
1063
1082
20
0
C
SOHDR.FCEDICHAR12
EDI Character 13
1083
1102
20
0
C
SOHDR.FCEDICHAR13
EDI Character 14
1103
1122
20
0
C
SOHDR.FCEDICHAR14
EDI Character 15
1123
1142
20
0
C
SOHDR.FCEDICHAR15
EDI Date 1
1143
1150
8
0
D
SOHDR.FCEDIDATE1
EDI Date 2
1151
1158
8
0
D
SOHDR.FCEDIDATE2
EDI Date 3
1159
1166
8
0
D
SOHDR.FCEDIDATE3
EDI Date 4
1167
1174
8
0
D
SOHDR.FCEDIDATE4
EDI Date 5
1175
1182
8
0
D
SOHDR.FCEDIDATE5
EDI Date 6
1183
1190
8
0
D
SOHDR.FCEDIDATE6
EDI Date 7
1191
1198
8
0
D
SOHDR.FCEDIDATE7
EDI Date 8
1199
1206
8
0
D
SOHDR.FCEDIDATE8
EDI Date 9
1207
1214
8
0
D
SOHDR.FCEDIDATE9
EDI Date 10
1215
1222
8
0
D
SOHDR.FCEDIDATE10
EDI Date 11
1223
1230
8
0
D
SOHDR.FCEDIDATE11
EDI Date 12
1231
1238
8
0
D
SOHDR.FCEDIDATE12
EDI Date 13
1239
1246
8
0
D
SOHDR.FCEDIDATE13
EDI Date 14
1247
1254
8
0
D
SOHDR.FCEDIDATE14
EDI Date 15
1255
1262
8
0
D
SOHDR.FCEDIDATE15
EDI Numeric 1
1263
1278
16
5
N
SOHDR.FCEDINUM1
EDI Numeric 2
1279
1294
16
5
N
SOHDR.FCEDINUM2
EDI Numeric 3
1295
1310
16
5
N
SOHDR.FCEDINUM3
EDI Numeric 4
1311
1326
16
5
N
SOHDR.FCEDINUM4
EDI Numeric 5
1327
1342
16
5
N
SOHDR.FCEDINUM5
EDI Numeric 6
1343
1358
16
5
N
SOHDR.FCEDINUM6
EDI Numeric 7
1359
1374
16
5
N
SOHDR.FCEDINUM7
EDI Numeric 8
1375
1390
16
5
N
SOHDR.FCEDINUM8
EDI Numeric 9
1391
1406
16
5
N
SOHDR.FCEDINUM9
EDI Numeric 10
1407
1422
16
5
N
SOHDR.FCEDINUM10
EDI Memo 1 Line 1
1423
1502
80
0
M
SOHDR.FCEDIMEMO1
EDI Memo 1 Line 2
1503
1582
80
0
M
SOHDR.FCEDIMEMO1
EDI Memo 2 Line 1
1583
1662
80
0
M
SOHDR.FCEDIMEMO2
EDI Memo 2 Line 2
1663
1742
80
0
M
SOHDR.FCEDIMEMO2
Coordinator
1743
1745
3
0
C
SOMAST.FSOCOORD
Contract Code
1746
1755
10
0
C
SOMAST.CONTRACTNU
Bill To Address Key
1756
1775
20
0
C
SOMAST.FBILLADDR
Ship To Company
2089
2123
35
0
C
SOMAST.SHIPCOMPANY
Ship To Address
2124
2283
160
0
C
SOMAST.SHIPADDRESS
Ship To City
2284
2303
20
0
C
SOMAST.SHIPCITY
Ship To State
2304
2323
20
0
C
SOMAST.SHIPSTATE
Ship To Country
2324
2348
25
0
C
SOMAST.SHIPCOUNTRY
Zip Code
2349
2358
10
0
C
SOMAST.SHIPZIP
Phone No.
2359
2378
20
0
C
SOMAST.SHIPPHONE
Fax
2379
2398
20
0
C
SOMAST.SHIPFAX
860-REF
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘REF’
1
3
3
0
C
’REF’
X
Contact First Name
4
18
15
0
C
SOMAST.FCFNAME
Contact Last Name
19
48
30
0
C
SOMAST.FCONTACT
Phone Number
49
68
20
0
C
SOMAST.FPHONE
Fax Number
69
88
20
0
C
SOMAST.FFAX
Sales Order Name
89
123
35
0
C
SOMAST.FORDERNAME
Sales Order Transaction Currency
124
126
3
0
C
SOMAST.FCCURID
Ship Via
127
146
20
0
C
SOMAST.FSHIPVIA
Payment Type
147
147
1
0
C
SOMAST.FPAYTYPE
Terms For A Cash Payment
148
151
4
0
C
SOMAST.FTERM
Freight on Board Point
152
171
20
0
C
SOMAST.FFOB
User Defined Character 1
172
191
20
0
C
SOMAST.FCUSRCHR1
User Defined Character 2
192
231
40
0
C
SOMAST.FCUSRCHR2
User Defined Character 3
232
271
40
0
C
SOMAST.FCUSRCHR3
EDI Character 1
272
291
20
0
C
SOHDR.FCEDICHAR1
EDI Character 2
292
311
20
0
C
SOHDR.FCEDICHAR2
EDI Character 3
312
331
20
0
C
SOHDR.FCEDICHAR3
EDI Character 4
332
351
20
0
C
SOHDR.FCEDICHAR4
EDI Character 5
352
371
20
0
C
SOHDR.FCEDICHAR5
EDI Character 6
372
391
20
0
C
SOHDR.FCEDICHAR6
EDI Character 7
392
411
20
0
C
SOHDR.FCEDICHAR7
EDI Character 8
412
431
20
0
C
SOHDR.FCEDICHAR8
EDI Character 9
432
451
20
0
C
SOHDR.FCEDICHAR9
EDI Character 10
452
471
20
0
C
SOHDR.FCEDICHAR10
EDI Character 11
472
491
20
0
C
SOHDR.FCEDICHAR11
EDI Character 12
492
511
20
0
C
SOHDR.FCEDICHAR12
EDI Character 13
512
531
20
0
C
SOHDR.FCEDICHAR13
EDI Character 14
532
551
20
0
C
SOHDR.FCEDICHAR14
EDI Character 15
552
571
20
0
C
SOHDR.FCEDICHAR15
Contract Code
572
581
10
0
C
SOMAST.CONTRACTNU
860-HAC
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘HAC’
1
3
3
0
C
’HAC’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
Quantity
29
44
16
5
N
SOITEM.FQUANTITY
Unit of Measure
45
47
3
0
C
SOITEM.FMEASURE
Part Number Description
48
127
80
0
M
SOITEM.FDESC
Unit Price
128
143
16
5
N
SORELS.FUNETPRICE
Customer Part Number
144
168
25
0
C
SOITEM.FCUSTPART
Customer Part Number Description
169
248
80
0
M
SOITEM.FDESCMEMO
EDI Character 1
249
268
20
0
C
SODET.FCEDICHAR1
EDI Character 2
269
288
20
0
C
SODET.FCEDICHAR2
EDI Character 3
289
308
20
0
C
SODET.FCEDICHAR3
EDI Character 4
309
328
20
0
C
SODET.FCEDICHAR4
EDI Character 5
329
348
20
0
C
SODET.FCEDICHAR5
EDI Character 6
349
368
20
0
C
SODET.FCEDICHAR6
EDI Character 7
369
388
20
0
C
SODET.FCEDICHAR7
EDI Character 8
389
408
20
0
C
SODET.FCEDICHAR8
EDI Character 9
409
428
20
0
C
SODET.FCEDICHAR9
EDI Character 10
429
448
20
0
C
SODET.FCEDICHAR10
EDI Character 11
449
468
20
0
C
SODET.FCEDICHAR11
EDI Character 12
469
488
20
0
C
SODET.FCEDICHAR12
EDI Character 13
489
508
20
0
C
SODET.FCEDICHAR13
EDI Character 14
509
528
20
0
C
SODET.FCEDICHAR14
EDI Character 15
529
548
20
0
C
SODET.FCEDICHAR15
EDI Numeric 1
549
564
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
565
580
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
581
596
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
597
612
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
613
628
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
629
644
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
645
660
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
661
676
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
677
692
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
693
708
16
5
N
SODET.FCEDINUM10
EDI Memo 1
709
788
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
789
868
80
0
M
SODET.FCEDIMEMO2
Discount Rate
869
875
7
3
N
SOMAST.FDISRATE1
Tip: In HAC-1, the Discount Rate is calculated as the sum of all discount
rates when multiple HAC records are present.
860-HDT
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘HDT’
1
3
3
0
C
’HDT’
X
Order Date
4
11
8
0
D
SOMAST.FORDERDATE
Due Date
12
19
8
0
D
SOMAST.FDUEDATE
User Defined Date 1
20
27
8
0
D
SOMAST.FDUSRDATE1
EDI Date 1
28
35
8
0
D
SOHDR.FCEDIDATE1
EDI Date 2
36
43
8
0
D
SOHDR.FCEDIDATE2
EDI Date 3
44
51
8
0
D
SOHDR.FCEDIDATE3
EDI Date 4
52
59
8
0
D
SOHDR.FCEDIDATE4
EDI Date 5
60
67
8
0
D
SOHDR.FCEDIDATE5
EDI Date 6
68
75
8
0
D
SOHDR.FCEDIDATE6
EDI Date 7
76
83
8
0
D
SOHDR.FCEDIDATE7
EDI Date 8
84
91
8
0
D
SOHDR.FCEDIDATE8
EDI Date 9
92
99
8
0
D
SOHDR.FCEDIDATE9
EDI Date 10
100
107
8
0
D
SOHDR.FCEDIDATE10
EDI Date 11
108
115
8
0
D
SOHDR.FCEDIDATE11
EDI Date 12
116
123
8
0
D
SOHDR.FCEDIDATE12
EDI Date 13
124
131
8
0
D
SOHDR.FCEDIDATE13
EDI Date 14
132
139
8
0
D
SOHDR.FCEDIDATE14
EDI Date 15
140
147
8
0
D
SOHDR.FCEDIDATE15
860-MSG
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘MSG’
1
3
3
0
C
’MSG’
X
User Defined Memo 1
4
83
80
0
M
SOMAST.FMUSRMEMO1
EDI Memo 1
84
163
80
0
M
SOHDR.FCEDIMEMO1
EDI Memo 2
164
243
80
0
M
SOHDR.FCEDIMEMO2
860-DET
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DET’
1
3
3
0
C
’DET’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
X
Part Revision
29
31
3
0
C
SOITEM.FPARTREV
Quantity
32
47
16
5
N
SOITEM.FQUANTITY
X
Unit of Measure
48
50
3
0
C
SOITEM.FMEASURE
Source
51
51
1
0
C
SOITEM.FSOURCE
Part Number Description Line 1
52
131
80
0
M
SOITEM.FDESC
Part Number Description Line 2
132
211
80
0
M
SOITEM.FDESC
Product Class
212
215
4
0
C
SOITEM.FPRODCL
Group Code
216
221
6
0
C
SOITEM.FGROUP
Unit Price
222
237
16
5
N
SORELS.FUNETPRICE
Customer Part Number
238
262
25
0
C
SOITEM.FCUSTPART
Customer Part Revision
263
265
3
0
C
SOITEM.FCUSTPTREV
Customer Part Description Line 1
266
345
80
0
M
SOITEM.FDESCMEMO
Customer Part Description Line 2
346
425
80
0
M
SOITEM.FDESCMEMO
Delivery Notes Line 1
426
505
80
0
M
SORELS.FDELIVERY
Delivery Notes Line 2
506
585
80
0
M
SORELS.FDELIVERY
Order Billing Type
586
588
3
0
C
SOITEM.FORDERTYPE
Use Standard BOMs and Routings
589
589
1
0
L
SOITEM.FSTANDPART
Lot/Serial Number Required
590
590
1
0
L
SOITEM.FLLOTREQD
Extent of Lot Control
591
591
1
0
C
SOITEM.FCLOTEXT
Taxable
592
592
1
0
L
SORELS.FLISTAXABL
Price Schedule Code
593
598
6
0
C
SOITEM.FSCHECODE
Ship-to Address Key
599
618
20
0
C
SORELS.FSHPTOADDR
Due Date
619
626
8
0
D
SOITEM.FDUEDATE
Close within minimum %
627
637
11
5
N
SOITEM.FNUNDER
Close within maximum %
638
648
11
5
N
SOITEM.FNOVER
Multi-Release
649
649
1
0
L
SOITEM.FMULTIPLE
Ship Item
650
650
1
0
L
SOITEM.FSHIPITEM
Split Ship
651
651
1
0
L
SORELS.FSPLITSHP
Create Jobs
652
652
1
0
L
SOITEM.FAUTOCREAT
Print Memo
653
653
1
0
L
SOITEM.FPRINTMEMO
Ship Early
654
654
1
0
L
SORELS.FSHPBEFDUE
CTP Approved
655
655
1
0
L
SORELS.FLATP
EDI Character 1
656
675
20
0
C
SODET.FCEDICHAR1
EDI Character 2
676
695
20
0
C
SODET.FCEDICHAR2
EDI Character 3
696
715
20
0
C
SODET.FCEDICHAR3
EDI Character 4
716
735
20
0
C
SODET.FCEDICHAR4
EDI Character 5
736
755
20
0
C
SODET.FCEDICHAR5
EDI Character 6
756
775
20
0
C
SODET.FCEDICHAR6
EDI Character 7
776
795
20
0
C
SODET.FCEDICHAR7
EDI Character 8
796
815
20
0
C
SODET.FCEDICHAR8
EDI Character 9
816
835
20
0
C
SODET.FCEDICHAR9
EDI Character 10
836
855
20
0
C
SODET.FCEDICHAR10
EDI Character 11
856
875
20
0
C
SODET.FCEDICHAR11
EDI Character 12
876
895
20
0
C
SODET.FCEDICHAR12
EDI Character 13
896
915
20
0
C
SODET.FCEDICHAR13
EDI Character 14
916
935
20
0
C
SODET.FCEDICHAR14
EDI Character 15
936
955
20
0
C
SODET.FCEDICHAR15
EDI Date 1
956
963
8
0
D
SODET.FCEDIDATE1
EDI Date 2
964
971
8
0
D
SODET.FCEDIDATE2
EDI Date 3
972
979
8
0
D
SODET.FCEDIDATE3
EDI Date 4
980
987
8
0
D
SODET.FCEDIDATE4
EDI Date 5
988
995
8
0
D
SODET.FCEDIDATE5
EDI Date 6
996
1003
8
0
D
SODET.FCEDIDATE6
EDI Date 7
1004
1011
8
0
D
SODET.FCEDIDATE7
EDI Date 8
1012
1019
8
0
D
SODET.FCEDIDATE8
EDI Date 9
1020
1027
8
0
D
SODET.FCEDIDATE9
EDI Date 10
1028
1035
8
0
D
SODET.FCEDIDATE10
EDI Date 11
1036
1043
8
0
D
SODET.FCEDIDATE11
EDI Date 12
1044
1051
8
0
D
SODET.FCEDIDATE12
EDI Date 13
1052
1059
8
0
D
SODET.FCEDIDATE13
EDI Date 14
1060
1067
8
0
D
SODET.FCEDIDATE14
EDI Date 15
1068
1075
8
0
D
SODET.FCEDIDATE15
EDI Numeric 1
1076
1091
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
1092
1107
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
1108
1123
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
1124
1139
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
1140
1155
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
1156
1171
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
1172
1187
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
1188
1203
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
1204
1219
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
1220
1235
16
5
N
SODET.FCEDINUM10
EDI Memo 1 Line 1
1236
1315
80
0
M
SODET.FCEDIMEMO1
EDI Memo 1 Line 2
1316
1395
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2 Line 1
1396
1475
80
0
M
SODET.FCEDIMEMO2
EDI Memo 2 Line 2
1476
1555
80
0
M
SODET.FCEDIMEMO2
Price Schedule Type
1556
1556
1
0
C
SOITEM.FSCHEDTYPE
Quantity in Alternate Unit of Measure
1557
1573
17
5
N
SOITEM.FNALTQTY
Alternate Unit of Measure
1574
1576
3
0
C
SOITEM.FCALTUM
Location
1577
1590
14
0
C
SORELS.FCLOC
Bin
1591
1604
14
0
C
SORELS.FCBIN
Contract
1605
1614
10
0
C
SOITEM.CONTRACTNU
Selling U/M Quantity
1615
1629
15
5
N
SOITEM.FNALTSQTY
X1
Selling U/M
1630
1632
3
0
C
SOITEM.FCALSTUM
X1
Selling U/M Unit Price
1633
1648
16
5
N
SOITEM.FSUNITPRICE
X1
860-PID
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘PID’
1
3
3
0
C
’PID
X
Part Number Description
4
83
80
0
M
SOITEM.FDESC
Customer Part Number Description
84
163
80
0
M
SOITEM.FDESCMEMO
Delivery Notes
164
243
80
0
M
SORELS.FDELIVERY
EDI Memo 1
244
323
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
324
403
80
0
M
SODET.FCEDIMEMO2
860-DDT
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DDT’
1
3
3
0
C
’DDT’
X
Delivery Notes
4
83
80
0
M
SORELS.FDELIVERY
Due Date
84
91
8
0
D
SOITEM.FDUEDATE
EDI Date 1
92
99
8
0
D
SODET.FCEDIDATE1
EDI Date 2
100
107
8
0
D
SODET.FCEDIDATE2
EDI Date 3
108
115
8
0
D
SODET.FCEDIDATE3
EDI Date 4
116
123
8
0
D
SODET.FCEDIDATE4
EDI Date 5
124
131
8
0
D
SODET.FCEDIDATE5
EDI Date 6
132
139
8
0
D
SODET.FCEDIDATE6
EDI Date 7
140
147
8
0
D
SODET.FCEDIDATE7
EDI Date 8
148
155
8
0
D
SODET.FCEDIDATE8
EDI Date 9
156
163
8
0
D
SODET.FCEDIDATE9
EDI Date 10
164
171
8
0
D
SODET.FCEDIDATE10
EDI Date 11
172
179
8
0
D
SODET.FCEDIDATE11
EDI Date 12
180
187
8
0
D
SODET.FCEDIDATE12
EDI Date 13
188
195
8
0
D
SODET.FCEDIDATE13
EDI Date 14
196
203
8
0
D
SODET.FCEDIDATE14
EDI Date 15
204
211
8
0
D
SODET.FCEDIDATE15
860-DAC
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DAC’
1
3
3
0
C
’DAC’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
Quantity
29
44
16
5
N
SOITEM.FQUANTITY
Unit of Measure
45
47
3
0
C
SOITEM.FMEASURE
Part Number Description
48
127
80
0
M
SOITEM.FDESC
Unit Price
128
143
16
5
N
SORELS.FUNETPRICE
Customer Part Number
144
168
25
0
C
SOITEM.FCUSTPART
Customer Part Number Description
169
248
80
0
M
SOITEM.FDESCMEMO
EDI Character 1
249
268
20
0
C
SODET.FCEDICHAR1
EDI Character 2
269
288
20
0
C
SODET.FCEDICHAR2
EDI Character 3
289
308
20
0
C
SODET.FCEDICHAR3
EDI Character 4
309
328
20
0
C
SODET.FCEDICHAR4
EDI Character 5
329
348
20
0
C
SODET.FCEDICHAR5
EDI Character 6
349
368
20
0
C
SODET.FCEDICHAR6
EDI Character 7
369
388
20
0
C
SODET.FCEDICHAR7
EDI Character 8
389
408
20
0
C
SODET.FCEDICHAR8
EDI Character 9
409
428
20
0
C
SODET.FCEDICHAR9
EDI Character 10
429
448
20
0
C
SODET.FCEDICHAR10
EDI Character 11
449
468
20
0
C
SODET.FCEDICHAR11
EDI Character 12
469
488
20
0
C
SODET.FCEDICHAR12
EDI Character 13
489
508
20
0
C
SODET.FCEDICHAR13
EDI Character 14
509
528
20
0
C
SODET.FCEDICHAR14
EDI Character 15
529
548
20
0
C
SODET.FCEDICHAR15
EDI Numeric 1
549
564
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
565
580
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
581
596
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
597
612
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
613
628
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
629
644
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
645
660
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
661
676
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
677
692
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
693
708
16
5
N
SODET.FCEDINUM10
EDI Memo 1
709
788
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
789
868
80
0
M
SODET.FCEDIMEMO2
Discount Rate
869
875
7
3
N
SORELS.FUNETPRICE1
Tip: In DAC-1, allowance o,r charge discount rate is calculated as the sum of
all discount rates when multiple DAC records are present for a line item and a
unit discount amount calculated as a function of the parent unit price and the
calculated discount.
860-REL
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘REL’
1
3
3
0
C
’REL’
X
Ship-To Address Key
4
23
20
0
C
SORELS.FSHPTOADDR
Due Date
24
31
8
0
D
SORELS.FDUEDATE
Delivery Notes Line 1
32
111
80
0
M
SORELS.FDELIVERY
Delivery Notes Line 2
112
191
80
0
M
SORELS.FDELIVERY
Taxable
192
192
1
0
L
SORELS.FLISTAXABL
Allow Split Shipments
193
193
1
0
L
SORELS.FSPLITSHP
Ship Early
194
194
1
0
L
SORELS.FSHPBEFDUE
Release Quantity
195
208
14
5
N
SORELS.FORDERQTY
Unit Price
209
224
16
5
N
SORELS.FUNETPRICE
Ship-To Address Key 2
225
244
20
0
C
SORELS.FSHPTOADDR
Release Quantity 2
245
258
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 3
259
278
20
0
C
SORELS.FSHPTOADDR
Release Quantity 3
279
292
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 4
293
312
20
0
C
SORELS.FSHPTOADDR
Release Quantity 4
313
326
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 5
327
346
20
0
C
SORELS.FSHPTOADDR
Release Quantity 5
347
360
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 6
361
380
20
0
C
SORELS.FSHPTOADDR
Release Quantity 6
381
394
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 7
395
414
20
0
C
SORELS.FSHPTOADDR
Release Quantity 7
415
428
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 8
429
448
20
0
C
SORELS.FSHPTOADDR
Release Quantity 8
449
462
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 9
463
482
20
0
C
SORELS.FSHPTOADDR
Release Quantity 9
483
496
14
5
N
SORELS.FORDERQTY
Ship-To Address Key 10
497
516
20
0
C
SORELS.FSHPTOADDR
Release Quantity 10
517
530
14
5
N
SORELS.FORDERQTY
Release Selling U/M Quantity
531
545
15
5
N
SORELS.FSORDERQTY
X1
Selling U/M Unit Price
546
561
16
5
N
SORELS.FSUNETPRICE
X1
862 - Shipping Authorization
Inbound 862 (Shipping Authorization) results in the document automation of the
Made2Manage Orders (SO) screen. The layout of the 862 Fixed File Format is
listed below. The hierarchy of each 862 transaction is a single HDR segment
followed by at least one DET segment followed by optional REL segments. The
REF, HDT and MSG records are extensions of the HDR record. The PID and DDT
records are extensions of the DET record. The HAC and DAC records create line-
item records for special allowances and charges from the header and item level
respectively.
Tip: In HAC-1, the Discount Rate is calculated as the sum of all discount
rates when multiple HAC records are present.
862-HDT
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘HDT’
1
3
3
0
C
’HDT’
X
Order Date
4
11
8
0
D
SOMAST.FORDERDATE
Due Date
12
19
8
0
D
SOMAST.FDUEDATE
User Defined Date 1
20
27
8
0
D
SOMAST.FDUSRDATE1
EDI Date 1
28
35
8
0
D
SOHDR.FCEDIDATE1
EDI Date 2
36
43
8
0
D
SOHDR.FCEDIDATE2
EDI Date 3
44
51
8
0
D
SOHDR.FCEDIDATE3
EDI Date 4
52
59
8
0
D
SOHDR.FCEDIDATE4
EDI Date 5
60
67
8
0
D
SOHDR.FCEDIDATE5
EDI Date 6
68
75
8
0
D
SOHDR.FCEDIDATE6
EDI Date 7
76
83
8
0
D
SOHDR.FCEDIDATE7
EDI Date 8
84
91
8
0
D
SOHDR.FCEDIDATE8
EDI Date 9
92
99
8
0
D
SOHDR.FCEDIDATE9
EDI Date 10
100
107
8
0
D
SOHDR.FCEDIDATE10
EDI Date 11
108
115
8
0
D
SOHDR.FCEDIDATE11
EDI Date 12
116
123
8
0
D
SOHDR.FCEDIDATE12
EDI Date 13
124
131
8
0
D
SOHDR.FCEDIDATE13
EDI Date 14
132
139
8
0
D
SOHDR.FCEDIDATE14
EDI Date 15
140
147
8
0
D
SOHDR.FCEDIDATE15
862-MSG
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘MSG’
1
3
3
0
C
’MSG’
X
User Defined Memo 1
4
83
80
0
M
SOMAST.FMUSRMEMO1
EDI Memo 1
84
163
80
0
M
SOHDR.FCEDIMEMO1
EDI Memo 2
164
243
80
0
M
SOHDR.FCEDIMEMO2
862-DET
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DET’
1
3
3
0
C
’DET’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
X
Part Revision
29
31
3
0
C
SOITEM.FPARTREV
Quantity
32
47
16
5
N
SOITEM.FQUANTITY
X
Unit of Measure
48
50
3
0
C
SOITEM.FMEASURE
Source
51
51
1
0
C
SOITEM.FSOURCE
Part Number Description Line 1
52
131
80
0
M
SOITEM.FDESC
Part Number Description Line 2
132
211
80
0
M
SOITEM.FDESC
Product Class
212
215
4
0
C
SOITEM.FPRODCL
Group Code
216
221
6
0
C
SOITEM.FGROUP
Unit Price
222
237
16
5
N
SORELS.FUNETPRICE
Customer Part Number
238
262
25
0
C
SOITEM.FCUSTPART
Customer Part Revision
263
265
3
0
C
SOITEM.FCUSTPTREV
Customer Part Description Line 1
266
345
80
0
M
SOITEM.FDESCMEMO
Customer Part Description Line 2
346
425
80
0
M
SOITEM.FDESCMEMO
Delivery Notes Line 1
426
505
80
0
M
SORELS.FDELIVERY
Delivery Notes Line 2
506
585
80
0
M
SORELS.FDELIVERY
Order Billing Type
586
588
3
0
C
SOITEM.FORDERTYPE
Use Standard BOMs and Routings
589
589
1
0
L
SOITEM.FSTANDPART
Lot/Serial Number Required
590
590
1
0
L
SOITEM.FLLOTREQD
Extent of Lot Control
591
591
1
0
C
SOITEM.FCLOTEXT
Taxable
592
592
1
0
L
SORELS.FLISTAXABL
Price Schedule Code
593
598
6
0
C
SOITEM.FSCHECODE
Ship-to Address Key
599
618
20
0
C
SORELS.FSHPTOADDR
Due Date
619
626
8
0
D
SOITEM.FDUEDATE
Close within minimum %
627
637
11
5
N
SOITEM.FNUNDER
Close within maximum %
638
648
11
5
N
SOITEM.FNOVER
Multi-Release
649
649
1
0
L
SOITEM.FMULTIPLE
Ship Item
650
650
1
0
L
SOITEM.FSHIPITEM
Split Ship
651
651
1
0
L
SORELS.FSPLITSHP
Create Jobs
652
652
1
0
L
SOITEM.FAUTOCREAT
Print Memo
653
653
1
0
L
SOITEM.FPRINTMEMO
Ship Early
654
654
1
0
L
SORELS.FSHPBEFDUE
CTP Approved
655
655
1
0
L
SORELS.FLATP
EDI Character 1
656
675
20
0
C
SODET.FCEDICHAR1
EDI Character 2
676
695
20
0
C
SODET.FCEDICHAR2
EDI Character 3
696
715
20
0
C
SODET.FCEDICHAR3
EDI Character 4
716
735
20
0
C
SODET.FCEDICHAR4
EDI Character 5
736
755
20
0
C
SODET.FCEDICHAR5
EDI Character 6
756
775
20
0
C
SODET.FCEDICHAR6
EDI Character 7
776
795
20
0
C
SODET.FCEDICHAR7
EDI Character 8
796
815
20
0
C
SODET.FCEDICHAR8
EDI Character 9
816
835
20
0
C
SODET.FCEDICHAR9
EDI Character 10
836
855
20
0
C
SODET.FCEDICHAR10
EDI Character 11
856
875
20
0
C
SODET.FCEDICHAR11
EDI Character 12
876
895
20
0
C
SODET.FCEDICHAR12
EDICharacter13
896
915
20
0
C
SODET.FCEDICHAR13
EDICharacter14
916
935
20
0
C
SODET.FCEDICHAR14
EDICharacter15
936
955
20
0
C
SODET.FCEDICHAR15
EDIDate1
956
963
8
0
D
SODET.FCEDIDATE1
EDIDate2
964
971
8
0
D
SODET.FCEDIDATE2
EDIDate3
972
979
8
0
D
SODET.FCEDIDATE3
EDIDate4
980
987
8
0
D
SODET.FCEDIDATE4
EDIDate5
988
995
8
0
D
SODET.FCEDIDATE5
EDIDate6
996
1003
8
0
D
SODET.FCEDIDATE6
EDIDate7
1004
1011
8
0
D
SODET.FCEDIDATE7
EDIDate8
1012
1019
8
0
D
SODET.FCEDIDATE8
EDIDate9
1020
1027
8
0
D
SODET.FCEDIDATE9
EDIDate10
1028
1035
8
0
D
SODET.FCEDIDATE10
EDIDate11
1036
1043
8
0
D
SODET.FCEDIDATE11
EDIDate12
1044
1051
8
0
D
SODET.FCEDIDATE12
EDIDate13
1052
1059
8
0
D
SODET.FCEDIDATE13
EDIDate14
1060
1067
8
0
D
SODET.FCEDIDATE14
EDIDate15
1068
1075
8
0
D
SODET.FCEDIDATE15
EDINumeric1
1076
1091
16
5
N
SODET.FCEDINUM1
EDINumeric2
1092
1107
16
5
N
SODET.FCEDINUM2
EDINumeric3
1108
1123
16
5
N
SODET.FCEDINUM3
EDINumeric4
1124
1139
16
5
N
SODET.FCEDINUM4
EDINumeric5
1140
1155
16
5
N
SODET.FCEDINUM5
EDINumeric6
1156
1171
16
5
N
SODET.FCEDINUM6
EDINumeric7
1172
1187
16
5
N
SODET.FCEDINUM7
EDINumeric8
1188
1203
16
5
N
SODET.FCEDINUM8
EDINumeric9
1204
1219
16
5
N
SODET.FCEDINUM9
EDINumeric10
1220
1235
16
5
N
SODET.FCEDINUM10
EDIMemo1Line1
1236
1315
80
0
M
SODET.FCEDIMEMO1
EDIMemo1Line2
1316
1395
80
0
M
SODET.FCEDIMEMO1
EDIMemo2Line1
1396
1475
80
0
M
SODET.FCEDIMEMO2
EDIMemo2Line2
1476
1555
80
0
M
SODET.FCEDIMEMO2
PriceScheduleType
1556
1556
1
0
C
SOITEM.FSCHEDTYPE
Quantity inAlternateUnitOfMeasure
1557
1573
17
5
N
SOITEM.FNALTQTY
AlternateUnitOfMeasure
1574
1576
3
0
C
SOITEM.FCALTUM
Location
1577
1590
14
0
C
SORELS.FCLOC
Bin
1591
1604
14
0
C
SORELS.FCBIN
Contract
1605
1614
10
0
C
SOITEM.CONTRACTNU
Selling U/M Quantity
1615
1629
15
5
N
SOITEM.FNALTSQTY
X1
Selling U/M
1630
1632
3
0
C
SOITEM.FCALSTUM
X1
Selling U/M Unit Price
1633
1648
16
5
N
SOITEM.FSUNITPRICE
X1
862-PID
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘PID’
1
3
3
0
C
’PID
X
Part Number Description
4
83
80
0
M
SOITEM.FDESC
Customer Part Number Description
84
163
80
0
M
SOITEM.FDESCMEMO
Delivery Notes
164
243
80
0
M
SORELS.FDELIVERY
EDI Memo 1
244
323
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
324
403
80
0
M
SODET.FCEDIMEMO2
862-DDT
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DDT’
1
3
3
0
C
’DDT’
X
Delivery Notes
4
83
80
0
M
SORELS.FDELIVERY
Due Date
84
91
8
0
D
SOITEM.FDUEDATE
EDI Date 1
92
99
8
0
D
SODET.FCEDIDATE1
EDI Date 2
100
107
8
0
D
SODET.FCEDIDATE2
EDI Date 3
108
115
8
0
D
SODET.FCEDIDATE3
EDI Date 4
116
123
8
0
D
SODET.FCEDIDATE4
EDI Date 5
124
131
8
0
D
SODET.FCEDIDATE5
EDI Date 6
132
139
8
0
D
SODET.FCEDIDATE6
EDI Date 7
140
147
8
0
D
SODET.FCEDIDATE7
EDI Date 8
148
155
8
0
D
SODET.FCEDIDATE8
EDI Date 9
156
163
8
0
D
SODET.FCEDIDATE9
EDI Date 10
164
171
8
0
D
SODET.FCEDIDATE10
EDI Date 11
172
179
8
0
D
SODET.FCEDIDATE11
EDI Date 12
180
187
8
0
D
SODET.FCEDIDATE12
EDI Date 13
188
195
8
0
D
SODET.FCEDIDATE13
EDI Date 14
196
203
8
0
D
SODET.FCEDIDATE14
EDI Date 15
204
211
8
0
D
SODET.FCEDIDATE15
862-DAC
Field Description
Beg. Pos.
End Pos.
Len
Dec
Data Type
Made2Manage
Req
Header Record Tag: ‘DAC’
1
3
3
0
C
’DAC’
X
Part Number
4
28
25
0
C
SOITEM.FPARTNO
Quantity
29
44
16
5
N
SOITEM.FQUANTITY
Unit of Measure
45
47
3
0
C
SOITEM.FMEASURE
Part Number Description
48
127
80
0
M
SOITEM.FDESC
Unit Price
128
143
16
5
N
SORELS.FUNETPRICE
Customer Part Number
144
168
25
0
C
SOITEM.FCUSTPART
Customer Part Number Description
169
248
80
0
M
SOITEM.FDESCMEMO
EDI Character 1
249
268
20
0
C
SODET.FCEDICHAR1
EDI Character 2
269
288
20
0
C
SODET.FCEDICHAR2
EDI Character 3
289
308
20
0
C
SODET.FCEDICHAR3
EDI Character 4
309
328
20
0
C
SODET.FCEDICHAR4
EDI Character 5
329
348
20
0
C
SODET.FCEDICHAR5
EDI Character 6
349
368
20
0
C
SODET.FCEDICHAR6
EDI Character 7
369
388
20
0
C
SODET.FCEDICHAR7
EDI Character 8
389
408
20
0
C
SODET.FCEDICHAR8
EDI Character 9
409
428
20
0
C
SODET.FCEDICHAR9
EDI Character 10
429
448
20
0
C
SODET.FCEDICHAR10
EDI Character 11
449
468
20
0
C
SODET.FCEDICHAR11
EDI Character 12
469
488
20
0
C
SODET.FCEDICHAR12
EDI Character 13
489
508
20
0
C
SODET.FCEDICHAR13
EDI Character 14
509
528
20
0
C
SODET.FCEDICHAR14
EDI Character 15
529
548
20
0
C
SODET.FCEDICHAR15
EDI Numeric 1
549
564
16
5
N
SODET.FCEDINUM1
EDI Numeric 2
565
580
16
5
N
SODET.FCEDINUM2
EDI Numeric 3
581
596
16
5
N
SODET.FCEDINUM3
EDI Numeric 4
597
612
16
5
N
SODET.FCEDINUM4
EDI Numeric 5
613
628
16
5
N
SODET.FCEDINUM5
EDI Numeric 6
629
644
16
5
N
SODET.FCEDINUM6
EDI Numeric 7
645
660
16
5
N
SODET.FCEDINUM7
EDI Numeric 8
661
676
16
5
N
SODET.FCEDINUM8
EDI Numeric 9
677
692
16
5
N
SODET.FCEDINUM9
EDI Numeric 10
693
708
16
5
N
SODET.FCEDINUM10
EDI Memo 1
709
788
80
0
M
SODET.FCEDIMEMO1
EDI Memo 2
789
868
80
0
M
SODET.FCEDIMEMO2
Discount Rate
869
875
7
3
N
SORELS.FUNETPRICE1
Tip: In DAC-1, allowance or charge discount rate is calculated as the sum of
all discount rates when multiple DAC records are present for a line item and a
unit discount amount calculated as a function of the parent unit price and the
calculated discount.