Open Purchase Order Data Files
|
DB Column
|
Field name
|
Sample
|
Sequence
|
Begin
|
End
|
Length
|
Decimal Places
|
|
vend
|
Vendor ID
|
A2229
|
1
|
1
|
9
|
9
|
N/A
|
|
loc
|
Item Location
|
ATL
|
2
|
10
|
14
|
5
|
N/A
|
|
item
|
Item #
|
123456789
|
3
|
15
|
42
|
28
|
N/A
|
|
podate
|
PO Date
|
20220121 (YYYYMMDD)
|
4
|
43
|
50
|
8
|
N/A
|
|
poduedate
|
PO Due Date
|
20220131 (YYYYMMDD)
|
5
|
51
|
58
|
8
|
N/A
|
|
poqty
|
Qty Ordered
|
00000000050000 (=5)
|
6
|
59
|
72
|
14
|
4
|
|
ponumber
|
PO Number
|
12345
|
7
|
73
|
82
|
10
|
N/A
|
|
marsreq
|
MARS Req #
|
12345
|
8
|
83
|
90
|
8
|
N/A
|
|
lastdaterecv
|
Last Received Date
|
|
9
|
91
|
98
|
8
|
N/A
|
|
poqty_recv
|
Last Received Qty
|
|
10
|
99
|
112
|
14
|
4
|
|
marsreqseq
|
Status
|
|
11
|
113
|
116
|
4
|
|
|
pocost
|
Line Cost
|
|
12
|
117
|
130
|
14
|
4
|
