Purchase Order FAQ
Purchase Order - Data Dictionary
.
10/17/00 NEMRC Customer Support Page 1
02:12 pm Filename: POIORD
File Description: Purchase Order Items Ordered File
No Field Name Type Len Dec Description of field
--------------------------------------------------------------------------------
1 O_PONUM C 8 0 PURCHASE ORDER NUMBER
2 O_REQUNUM C 10 0 REQUSITION NUMBER
3 O_ITEMNO C 12 0 ITEM NUMBER
4 O_DESC C 50 0 ITEM DESCRIPTION
5 O_POUNITS N 11 2 UNITS POS AND REPORTS (NON ITEM/ACCT)
6 O_ORDUNIT N 20 11 NUMBER OF UNITS ORDERED
7 O_RCVUNIT N 20 11 NUMBER OF UNITS RECEIVED
8 O_ORDPRIC N 11 2 UNIT PRICE
9 O_EXPACCT C 25 0 EXPENDITURE ACCOUNT (NORMALLY)
10 O_ENCFLAG C 1 0 Y IF ENCUMBERED IN G/L
11 O_DELFLAG C 1 0 "*"=RE-USABLE
--------------------------------------------------------------------------------
TOTAL LENGTH OF ALL 11 FIELDS = 169
Related Indexes
POIORD : O_DELFLAG+O_PONUM+O_ITEMNO+O_EXPACCT+O_ENCFLAG
POIREQ : O_DELFLAG+O_REQUNUM+O_ITEMNO+O_EXPACCT+O_ENCFLAG .
10/17/00 NEMRC Customer Support Page 1
02:12 pm Filename: POIRCV
File Description: Purchase Order Received Goods File
No Field Name Type Len Dec Description of field
--------------------------------------------------------------------------------
1 R_PONUM C 8 0 PURCHASE ORDER NUMBER
2 R_INVNO C 12 0 INVOICE # THIS QUANTITY WAS INVOICED ON
3 R_RCVDATE D 8 0 RECEIVED DATE
4 R_ITEMNO C 12 0 ITEM NUMBER
5 R_EXPACCT C 25 0 EXPENDITURE ACCOUNT (NORMALLY)
6 R_ENCFLAG C 1 0 Y IF ENCUMBERED IN G/L
7 R_RCVUNIT N 20 11 NUMBER OF UNITS RECEIVED
8 R_RCVPRIC N 11 2 UNIT PRICE
9 R_APAMT N 11 2 AMOUNT AVAILIABLE FOR AP TO INVOICE
10 R_DELFLAG C 1 0 "*"=RE-USABLE
--------------------------------------------------------------------------------
TOTAL LENGTH OF ALL 10 FIELDS = 109
Related Indexes
POIRCV : R_DELFLAG+R_PONUM+R_ITEMNO+R_EXPACCT+R_ENCFLAG .
10/17/00 NEMRC Customer Support Page 1
02:12 pm Filename: POLOCA
File Description: PO Default File
No Field Name Type Len Dec Description of field
--------------------------------------------------------------------------------
1 L_LOCACODE C 2 0 LOCATION DEFAULT
2 L_SHIPNAME C 30 0 SHIPPING ADDRESS
3 L_SHIPADD1 C 35 0 SHIPPING ADDRESS
4 L_SHIPADD2 C 35 0 SHIPPING ADDRESS
5 L_SHIPCITY C 25 0 SHIPPING ADDRESS
6 L_SHIPSTAT C 10 0 SHIPPING ADDRESS
7 L_SHIPZIP C 10 0 SHIPPING ADDRESS
8 L_DELFLAG C 1 0 "*" IF DELETED
9 L_NETSTAMP N 2 0 NETWORK STAMP
--------------------------------------------------------------------------------
TOTAL LENGTH OF ALL 9 FIELDS = 150
Related Indexes
POSHIP : L_DELFLAG+L_SHIPNAME
POLOCA : L_DELFLAG+L_LOCACODE+L_SHIPNAME .
10/17/00 NEMRC Customer Support Page 1
02:12 pm Filename: POMAST
File Description: Purchase Order Master File
No Field Name Type Len Dec Description of field
--------------------------------------------------------------------------------
1 M_PONUM C 8 0 PURCHASE ORDER NUMBER
2 M_REQUNUM C 10 0 REQUISITION NUMBER
3 M_ORDDATE D 8 0 ORDER DATE
4 M_REQDATE D 8 0 REQUEST DATE
5 M_STATUS C 10 0 ** SEE BELOW
6 M_LASTYEAR C 1 0 THIS PO WENT THROUGH A YEAR CLOSE
7 M_FUTURE C 1 0 'Y' IF A NEXT YEAR PO.
8 M_APPROV C 1 0 YN T: APPR.,REJECT.,OPEN,X-FER RESPECT.
9 M_REQUPRT C 1 0 'Y' IF REQUISITION PRINTED
10 M_VENDNO C 9 0 VENDOR NUMBER
11 M_COMPANY C 35 0 " NAME
12 M_ADD1 C 35 0 " ADDRESS
13 M_ADD2 C 35 0 " "
14 M_CITY C 25 0 " CITY
15 M_STATE C 10 0 " STATE
16 M_ZIP C 10 0 " ZIP
17 M_SHIPNAME C 30 0 SHIPPING ADDRESS
18 M_SHIPADD1 C 35 0 SHIPPING ADDRESS
19 M_SHIPADD2 C 35 0 SHIPPING ADDRESS
20 M_SHIPCITY C 25 0 SHIPPING ADDRESS
21 M_SHIPSTAT C 10 0 SHIPPING ADDRESS
22 M_SHIPZIP C 10 0 SHIPPING ADDRESS
23 M_DISPERC N 5 2 DISCOUNT PERCENTAGE
24 M_DISDAY N 2 0 # OF DAYS TO CALC DISCOUNT DUE DATE
25 M_DUEDAY N 2 0 # OF DAYS TO CALC FINAL DUE DATE
26 M_FOB C 12 0 DESTINATION
27 M_FRT C 12 0 FREIGHT
28 M_VIA C 12 0 SHIPPING METHOD
29 M_REQBY C 30 0 PERSON REQUISITIONED BY
30 M_REQDEPT C 30 0 DEPARTMENT REQUISITIONED BY
31 M_BUDYR C 9 0 BUDGET YEAR (1234-1234)
32 M_FUNDESC C 15 0 FUND DESCRIPTION
33 M_DEPDESC C 15 0 DEPARTMENT DESCRIPTION
34 M_ACCDESC C 15 0 ACCOUNT DESCRIPTION
35 M_DESCRIP C 25 0 PURCHASE ORDER DESCRIPTION
36 M_REMARK C 150 0 REMARKS (3 LINES OF 50CHARS)
37 M_REMARK1 C 150 0 TOTAL UNITS ORDERED
38 M_ORDUNIT N 11 2 3 LINES OF 50 ADDTIONAL REMARKS
39 M_ORDAMT N 11 2 TOTAL AMOUNT ORDERED
40 M_RCVUNIT N 11 2 TOTAL UNITS RECEIVED
41 M_RCVAMT N 11 2 TOTAL AMOUNT RECEIVED
42 M_APAMT N 11 2 AMOUNT AVAILABLE FOR A/P TO POST
43 M_GL_POST C 1 0 "Y"=POSTED TO G/L " "=NOT POSTED TO G/L
44 M_GL_BAT C 3 0
45 M_REQBATCH N 3 0 BATCH TRANSFER # TO CENTRAL LOCATION
46 M_NETSTAMP N 2 0 NETWORK SIGNATURE
47 M_DELFLAG C 1 0 "*"=RE-USABLE
--------------------------------------------------------------------------------
TOTAL LENGTH OF ALL 47 FIELDS = 901
Related Indexes
POMAST : M_DELFLAG+M_PONUM
POMPGL : M_GL_POST
POMREQ : M_DELFLAG+M_REQUNUM
POPORE : M_DELFLAG+RIGHT(M_REQUNUM,8)+LEFT(M_REQUNUM,2)
Additional Information
M_status,1,1=Status:O=Open,C=Closed,V=Voided,P=All items Received
2,1=Printed(Y/N)
3,1=Posted to AP:N=None,C=Completed,P=Partial .
10/17/00 NEMRC Customer Support Page 1
02:12 pm Filename: POSYST
File Description: System File
No Field Name Type Len Dec Description of field
--------------------------------------------------------------------------------
1 S_NEXTPO N 8 0 NEXT PURCHASE ORDER NUMBER
2 S_FOB C 12 0 DEFAULT DESTINATION
3 S_FRT C 12 0 DEFAULT FREIGHT
4 S_VIA C 12 0 DEFAULT SHIPPING METHOD
5 S_TAXNUM C 20 0 TAX EXEMPT # (BLANK IF NONE)
6 S_BUDYR C 9 0 BUDGET YEAR (1234-1234)
7 S_ENCFLAG C 1 0 DEFAULT ENCUMBRANCE FLAG (Y/N)
8 S_POFORM C 2 0 PURCHASE ORDER FORM CODE (00,01,...)
9 S_REFORM C 2 0 REQUISITION FORM CODE (00,01,...)
10 S_USEREQU C 1 0 (Y/N) USE REQUISTION PROCESSING
11 S_ALLOWBAT C 1 0 ALLOW DISKETTE REQUISITION BATCH X-FER
12 S_SAMEKEY C 1 0 SAME REQUISITION # AS PO # NO BATCH XFER
13 S_NEXTREQU N 8 0 LOCATION CODE + REQUISITION NUMBER
14 S_REQUBAT N 3 0 NEXT BATCH TO TRANSFER TO CENTRAL LOCA
15 S_CENTRAL C 1 0 'Y' IF CENTRAL LOCATION
16 S_NEXTYEAR C 1 0 'Y' IF ALLOWING NEXT YEAR STUFF
17 S_ITEMACCT C 1 0 ALLOW ITEM ACCOUNT RELATIONSHIPS
18 S_VERSION C 4 0 NEMRC EXECUTABLE THAT MATCHES THIS DATA
19 S_NETSTAMP N 2 0 NETWORK SIGNATURE
--------------------------------------------------------------------------------
TOTAL LENGTH OF ALL 19 FIELDS = 101S
