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                                                                     
							

© NEMRC 2010-2022 | Privacy Policy