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