Tax Administration Support Document

Open as: PDF or Word Document

Data Dictionary

Table of Contents


TABANK : TAX ADMIN AUTO PAYMENTS BANKING

TACASH : TAX ADMINISTRATION TEMPORARY CASH FILE

TACTRL : NEMRC Year CONTROL File

TAMAST : MAIN ACCOUNT FILE

TASYST : TAX ADMINISTRATION SYSTEM FILE

TATRAX : TRANSACTION FILE

TAX2AP : TRANSFER FILE TO TRANSFER TO AP

TAX2GL : TRANSFER TO GENERAL LEDGER


								
TABANK : TAX ADMIN AUTO PAYMENTS BANKING               

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    B_PROP         C     10     0   PARCEL ID                               
   2    B_SUB          C     10     0   SUB                                     
   3    B_NAME         C     40     0   NAME THAT MUST BE SOMEWHERE IN NAME 
1/2  
   4    B_BANKNAME     C     40     0   NAME THAT IS TRANSFERRED TO THE BANK    
   5    B_ABA          C      9     0   BANKS ABA NUMBER                        
   6    B_ACCT         C     20     0   BANK ACCOUNT NUMBER                     
   7    B_TYPE         C      1     0   TYPE OF BANK ACCOUNT C OR S             
   8    B_PHONE        C     12     0   PHONE NUMBER OF ACCOUNT HOLDER          
   9    B_DELFLAG      C      1     0   DELETED                                 
  10    B_NETSTAMP     N      2     0   NET STAMP                               
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 10 FIELDS = 145

                                Related Indexes                                

TABANK : B_DELFLAG+B_PROP+B_SUB+B_NAME                                         



 
TACASH : TAX ADMINISTRATION TEMPORARY CASH FILE            

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    C_PROP         C     10     0   PARCEL NUMBER                           
   2    C_SUB          C     10     0   SUB PARCEL NUMBER                       
   3    C_YEAR         C     10     0   YEAR OF RECEIPT                         
   4    C_CTRLYEAR     N      4     0   NEMRC CONTROL YEAR                      
   5    C_CHECK        C      8     0   CHECK NUMBER OF THIS RECEIPT            
   6    C_RECEIPT      C     10     0   RECEIPT #                               
   7    C_DATE         D      8     0   DATE THIS RECEIPT WAS MADE              
   8    C_TIME         C      8     0   TIME ENTRY WAS MADE                     
   9    C_REMIT        N      9     1   DEPOSIT NUMBER OF THIS RECEIPT          
  10    C_MODULE       C      2     0   NEMRC MODULE THIS CASH RECEIPT CAME 
FROM
  11    LNM_READ_D     N     15     1                                           
  12    LCM_MISC       C     40     0                                           
  13    LNM_DEF_CA     N     15     2                                           
  14    LDM_DATE_R     D      8     0                                           
  15    LMM_CKMEMO     C    250     0                                           
  16    LCM_CR_YEA     C     10     0                                           
  17    LNM_TOTAL_     N     15     2                                           
  18    LNM_DIS1       N     15     2                                           
  19    LNM_DIS2       N     15     2                                           
  20    LNM_DIS3       N     15     2                                           
  21    LNM_DIS4       N     15     2                                           
  22    LNM_DISC_A     N     15     2                                           
  23    LNM_PAY1       N     15     2                                           
  24    LNM_PAY2       N     15     2                                           
  25    LNM_PAY3       N     15     2                                           
  26    LNM_PAY4       N     15     2                                           
  27    LNM_INT1       N     15     2                                           
  28    LNM_INT2       N     15     2                                           
  29    LNM_INT3       N     15     2                                           
  30    LNM_INT4       N     15     2                                           
  31    LNM_PEN1       N     15     2                                           
  32    LNM_PEN2       N     15     2                                           
  33    LNM_PEN3       N     15     2                                           
  34    LNM_PEN4       N     15     2                                           
  35    LNM_OTHER_     N     15     2                                           
  36    LNM_CREDIT     N     15     2                                           
  37    C_DELFLAG      C      1     0   DELFLAG                                 
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 37 FIELDS = 718

                                Related Indexes                                

TACASH : C_DELFLAG+C_PROP+C_SUB+STRTRAN(STR(C_CTRLYEAR,4,0),' ','0')           
TATDEP : C_DELFLAG+STR(C_REMIT,9,1)                                            



 
TACTRL : NEMRC Year CONTROL File                   

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    R_YEARNAME     C     10     0   USERS DESCRIPTION OF THE YEAR           
   2    R_CTRLYEAR     N      4     0   NEMRC CONTROL YEAR (KEEPS ORDER)        
   3    R_DUEDATE1     D      8     0   DUE DATE FOR PAYMENT 1                  
   4    R_DUEDATE2     D      8     0   DUE DATE FOR PAYMENT 2                  
   5    R_DUEDATE3     D      8     0   DUE DATE FOR PAYMENT 3                  
   6    R_DUEDATE4     D      8     0   DUE DATE FOR PAYMENT 4                  
   7    R_USEDISC      C      1     0   'Y' IF USING DISCOUNTS FOR THIS YEAR    
   8    R_DISCP1       N      5     2   DISCOUNT PERCENTAGE FOR PAYMENT 1       
   9    R_DISCP2       N      5     2   DISCOUNT PERCENTAGE FOR PAYMENT 2       
  10    R_DISCP3       N      5     2   DISCOUNT PERCENTAGE FOR PAYMENT 3       
  11    R_DISCP4       N      5     2   DISCOUNT PERCENTAGE FOR PAYMENT 4       
  12    R_DISCD1       D      8     0   DISCOUNT WILL BE TAKEN UNTIL            
  13    R_DISCD2       D      8     0   DISCOUNT WILL BE TAKEN UNTIL            
  14    R_DISCD3       D      8     0   DISCOUNT WILL BE TAKEN UNTIL            
  15    R_DISCD4       D      8     0   DISCOUNT WILL BE TAKEN UNTIL            
  16    R_YEARCLOS     C      1     0   'Y' IF YEAR HAS BEEN CLOSED             
  17    R_DELETE       C      1     0   'Y' IF OK TO DELETE PARCEL BILLS        
  18    R_INTP1        N      5     2   INTEREST RATE FOR PAYMENT 1             
  19    R_INTP2        N      5     2   INTEREST RATE FOR PAYMENT 2             
  20    R_INTP3        N      5     2   INTEREST RATE FOR PAYMENT 3             
  21    R_INTP4        N      5     2   INTEREST RATE FOR PAYMENT 4             
  22    R_CASH         C     25     0   CASH ACCOUNT NUMBER                     
  23    R_AR           C     25     0   ACCOUNT RECEIVABLE ACCOUNT              
  24    R_INTRECV      C     25     0   INTEREST RECEIVABLE ACCOUNT             
  25    R_PENRECV      C     25     0   PENALTY RECEIVABLE ACCOUNT              
  26    R_OTHRECV      C     25     0   OTHER RECEIVABLE ACCOUNT                
  27    R_DAR          C     25     0   DELIQUENT ACCOUNT RECEIVABLE ACCOUNT    
  28    R_DINTRECV     C     25     0   DELIQUENT INT RECEIVABLE ACCOUNT        
  29    R_DPENRECV     C     25     0   DELIQUENT PEN RECEIVABLE ACCOUNT        
  30    R_DOTHRECV     C     25     0   DELIQUENT OTHER RECEIVABLE ACCOUNT      
  31    R_P_ABATE      C     25     0   ABATEMENTS FOR PRINCIPAL                
  32    R_I_ABATE      C     25     0   ABATEMENTS FOR INTEREST                 
  33    R_N_ABATE      C     25     0   ABATEMENTS FOR PENALTY                  
  34    R_O_ABATE      C     25     0   ABATEMENTS FOR OTHER                    
  35    R_CMP          C     25     0   CREDIT MEMOS PAYABLE ACCOUNT           
  36    R_SMP          C     25     0   DUE TO TAX PAYER FROM STATE             
  37    R_TAX          C     25     0   TAX REVENUE ACCOUNT                     
  38    R_INT          C     25     0   INTEREST ACCOUNT                        
  39    R_PEN          C     25     0   PENALTY ACCOUNT                         
  40    R_OTHER        C     25     0   OTHER ACCOUNT                           
  41    R_DTAX         C     25     0   TAX REVENUE ACCOUNT                     
  42    R_DINT         C     25     0   DEL INT REVENUE ACCOUNT                 
  43    R_DPEN         C     25     0   DEL PEN REVENUE ACCOUNT                 
  44    R_DOTHER       C     25     0   DEL OTHER REVENUE ACCOUNT               
  45    R_DISC         C     25     0   DISCOUNT ACCOUNT                        
  46    R_RATEDES0     C     15     0   RATE DESCRIPTION FOR TAX YEAR 0           
  47    R_RATEDES1     C     15     0   RATE DESCRIPTION FOR TAX YEAR 1          
  48    R_RATEDES2     C     15     0   RATE DESCRIPTION FOR TAX YEAR 2          
  49    R_RATEDES3     C     15     0   RATE DESCRIPTION FOR TAX YEAR 3          
  50    R_RATEDES4     C     15     0   RATE DESCRIPTION FOR TAX YEAR 4          
  51    R_RATEDES5     C     15     0   RATE DESCRIPTION FOR TAX YEAR 5          
  52    R_RATEDES6     C     15     0   RATE DESCRIPTION FOR TAX YEAR 6         
  53    R_RATEDES7     C     15     0   RATE DESCRIPTION FOR TAX YEAR 7          
  54    R_RATEDES8     C     15     0   RATE DESCRIPTION FOR TAX YEAR 8          
  55    R_RATEDES9     C     15     0   RATE DESCRIPTION FOR TAX YEAR 9          
  56    R_RATERAT0     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 0          
  57    R_RATERAT1     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 1          
  58    R_RATERAT2     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 2          
  59    R_RATERAT3     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 3          
  60    R_RATERAT4     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 4          
  61    R_RATERAT5     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 5          
  62    R_RATERAT6     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 6          
  63    R_RATERAT7     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 7          
  64    R_RATERAT8     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 8          
  65    R_RATERAT9     N      8     4   TAX RATE (SPLIT) FOR TAX YEAR 9          
  66    R_SPLIT0       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 0       
  67    R_SPLIT1       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 1       
  68    R_SPLIT2       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 2       
  69    R_SPLIT3       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 3       
  70    R_SPLIT4       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 4       
  71    R_SPLIT5       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 5       
  72    R_SPLIT6       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 6       
  73    R_SPLIT7       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 7       
  74    R_SPLIT8       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 8       
  75    R_SPLIT9       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 9       
  76    R_PMTACCT1     M      0     0   MEMO THAT HOLDS ACCT NUMBERS 4 PMT 1    
  77    R_PMTACCT2     M      0     0   MEMO THAT HOLDS ACCT NUMBERS 4 PMT 2    
  78    R_PMTACCT3     M      0     0   MEMO THAT HOLDS ACCT NUMBERS 4 PMT 3    
  79    R_PMTACCT4     M      0     0   MEMO THAT HOLDS ACCT NUMBERS 4 PMT 4    
  80    R_TRANSFER     L      1     0   TRANSFERRED                             
  81    R_TDATE        D      8     0   DATE TRANSFERRED                        
  82    R_STATUS       C      1     0   "C"LOSED NO AMOUNTS DUE.                
  83    R_OPEN         C      1     0   FLAGGED ALL AS OPEN?                    
  84    R_911DATA      C      1     0   SHOW 911/DESC/TAXMAP DATA FOR THIS 
YEAR 
  85    R_NETSTAMP     N      2     0   NETWORK STAMP                           
  86    R_DELFLAG      C      1     0   '*' IF RE-USEABLE                       
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 86 FIELDS = 966

                                Related Indexes                                

TACTRL : R_DELFLAG+STRTRAN(STR(R_CTRLYEAR,4,0),' ','0')                        



 
TAMAST : MAIN ACCOUNT FILE                      

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    M_PROP         C     10     0   PARCEL NUMBER,RIGHT JUSTIFIED ZERO 
FILL 
   2    M_SUB          C     10     0   PARCEL NUMBER,LEFT JUSTIFIED            
   3    M_YEAR         C     10     0   FISCAL YEAR EX '9394'                   
   4    M_CTRLYEAR     N      4     0   NEMRC CONTROL YEAR                      
   5    M_BILLNUM      N      8     0   BILL NUMBER USED FOR SPEED RECEIPTS     
   6    M_OPENPAY      L      1     0   ALLOW PAYMENTS                          
   7    M_NAME1        C     40     0   NAME FIELD BOTH LAST AND FIRST          
   8    M_NAME2        C     40     0   NAME FIELD BOTH LAST AND FIRST          
   9    M_LIENDATE     D      8     0   DATE LIEN WAS PROCESSED                 
  10    M_PAYAMT1      N     11     2   AMOUNT BILLED PAYMENT 1                 
  11    M_PAYAMT2      N     11     2   AMOUNT BILLED PAYMENT 2                 
  12    M_PAYAMT3      N     11     2   AMOUNT BILLED PAYMENT 3                 
  13    M_PAYAMT4      N     11     2   AMOUNT BILLED PAYMENT 4                 
  14    M_ACCUMIN1     N      9     2   AMOUNT OF INTEREST CALCULATED FOR 
PAYMENT 1 
  15    M_ACCUMIN2     N      9     2   AMOUNT OF INTEREST CALCULATED FOR 
PAYMENT 2 
  16    M_ACCUMIN3     N      9     2   AMOUNT OF INTEREST CALCULATED FOR 
PAYMENT 3 
  17    M_ACCUMIN4     N      9     2   AMOUNT OF INTEREST CALCULATED FOR 
PAYMENT 4 
  18    M_ACCUMPE1     N      9     2   AMOUNT OF PENALTY CALCULATED FOR 
PAYMENT 1  
  19    M_ACCUMPE2     N      9     2   AMOUNT OF PENALTY CALCULATED FOR 
PAYMENT 2  
  20    M_ACCUMPE3     N      9     2   AMOUNT OF PENALTY CALCULATED FOR 
PAYMENT 3  
  21    M_ACCUMPE4     N      9     2   AMOUNT OF PENALTY CALCULATED FOR 
PAYMENT 4  
  22    M_ACCUMOTH     N      9     2   OTHER AMOUNT ACCUMULATED                
  23    M_DISCTAK1     N      9     2   DISCOUNT TAKEN ON PAYMENT 1             
  24    M_DISCTAK2     N      9     2   DISCOUNT TAKEN ON PAYMENT 2             
  25    M_DISCTAK3     N      9     2   DISCOUNT TAKEN ON PAYMENT 3             
  26    M_DISCTAK4     N      9     2   DISCOUNT TAKEN ON PAYMENT 4             
  27    M_PAY1_DUE     N     11     2   LEFT TO PAY ON PAYMENT 1 PRINCIPAL      
  28    M_PAY2_DUE     N     11     2   LEFT TO PAY ON PAYMENT 2 PRINCIPAL      
  29    M_PAY3_DUE     N     11     2   LEFT TO PAY ON PAYMENT 3 PRINCIPAL      
  30    M_PAY4_DUE     N     11     2   LEFT TO PAY ON PAYMENT 4 PRINCIPAL      
  31    M_LASTCLC1     D      8     0   DATE OF LAST INTEREST CALC FOR 
PAYMENT 1
  32    M_INT_DUE1     N      9     2   AMOUNT OF INTEREST DUE ON PAYMENT 1     
  33    M_LASTCLC2     D      8     0   DATE OF LAST INTEREST CALC FOR 
PAYMENT 2
  34    M_INT_DUE2     N      9     2   AMOUNT OF INTEREST DUE ON PAYMENT 2     
  35    M_LASTCLC3     D      8     0   DATE OF LAST INTEREST CALC FOR 
PAYMENT 3
  36    M_INT_DUE3     N      9     2   AMOUNT OF INTEREST DUE ON PAYMENT 3     
  37    M_LASTCLC4     D      8     0   DATE OF LAST INTEREST CALC FOR 
PAYMENT 4
  38    M_INT_DUE4     N      9     2   AMOUNT OF INTEREST DUE ON PAYMENT 4     
  39    M_PEN_DUE1     N      9     2   AMOUNT OF PENALTY DUE ON PAYMENT 1      
  40    M_PEN_DUE2     N      9     2   AMOUNT OF PENALTY DUE ON PAYMENT 2      
  41    M_PEN_DUE3     N      9     2   AMOUNT OF PENALTY DUE ON PAYMENT 3      
  42    M_PEN_DUE4     N      9     2   AMOUNT OF PENALTY DUE ON PAYMENT 4      
  43    M_OTH_DUE      N      9     2   OTHER AMOUNT DUE                        
  44    M_CREDITS      N      9     2   AMOUNT OF CREDIT AVAILABLE              
  45    M_ADDR_A       C     30     0   ADDRESS FOR NAME1                       
  46    M_ADDR_B       C     30     0   ADDRESS FOR NAME1                       
  47    M_CITY         C     30     0   ADDRESS FOR NAME1                       
  48    M_STATE        C     10     0   STATE NAME 1                            
  49    M_ZIP          C     10     0   ADDRESS FOR NAME1                       
  50    M_LOCA_A       C     30     0   LOCATION OF PROPERTY A                  
  51    M_LOCA_B       C     30     0   LOCATION OF PROPERTY B                  
  52    M_LOCA_C       C     30     0   LOCATION OF PROPERTY C                  
  53    M_911LOCA      C     40     0   911 LOCATION                            
  54    M_911NUM       N      9     0   911 NUMBER                              
  55    M_911SUFF      C      4     0   911 SUFFIX                              
  56    M_PDESC        C     40     0   PROPERTY DESCRIPTION                    
  57    M_TAXMAP       C     40     0   TAXMAP DESCRIPTION                      
  58    M_HOMESTED     N     12     2   HOMESTEAD VALUE OF PARCEL FROM X-FER    
  59    M_HOUSESIT     N     12     1   HOUSE SITE FROM X-FER                   
  60    M_GRANDLST     N     12     2   GRANDLIST VALUE OF THE PARCEL FROM X-
FER
  61    M_PERSONAL     N     12     2   PERSOANL PROPERTY VALUE                 
  62    M_ACRES        N     12     2   ACRES OF LAND FROM X-FER                
  63    M_LAND         N      9     0   LAND FROM THE GRAND LIST FILE           
  64    M_BUILDING     N      9     0   BUILDING FROM THE GRANDLIST             
  65    M_VETEXEMP     N      9     2   VET EXEMPT FROM THE GRANDLIST           
  66    M_REAL         N      9     2   REAL                                    
  67    M_FARMSTAB     N      9     2   FARM STABILIZATION                      
  68    M_LANDUSE      N      9     2   LAND USE FROM THE GRANDLIST             
  69    M_RATESELE     C     10     0   RATES BILLED STRING. ANY OF 
'0123456789'
  70    M_TAXRATE      N      7     4   TOTAL OF TAX RATES BILLED               
  71    M_AGREE        M      0     0   MEMO OF AN AGREEMENT REACHED            
  72    M_BANKRPT      C      1     0   BANKRUPT                                
  73    M_NOTES        M      0     0   MEMO OF ANY PARCEL NOTES.               
  74    M_MISC1        C     20     0   MISC FIELD 1                    
  75    M_MISC2        C     20     0   MISC FIELD 2                    
  76    M_MISC3        C     20     0   MISC FIELD 3                    
  77    M_MISC4        C     20     0   MISC FIELD 4                    
  78    M_MISC5        C     20     0   MISC FIELD 5                    
  79    M_MISCFE1      N     12     2   MISC FEE 1                              
  80    M_MISCFE2      N     12     2   MISC FEE 2                              
  81    M_MISCFE3      N     12     2   MISC FEE 3                              
  82    M_MISCFE4      N     12     2   MISC FEE 4                              
  83    M_PENALTY      N     12     2   LATE FILED PENALTY                      
  84    M_INTEXMPT     C      1     0   WILL BE EXEMPT FROM INTEREST IF 'Y'     
  85    M_PENEXMPT     C      1     0   WILL BE EXEMPT FROM PENALTY IF 'Y'      
  86    M_OLDPROP      C     10     0   OLD PROP NUMBER, PRE-ZERO-FILLING 
9/99  
  87    M_OLDSUB       C     10     0   OLD SUB NUMBER, PRE-ZERO-FILLING 9/99   
  88    M_SPAN         C     13     0   SPAN NUMBER                             
  89    M_DELFLAG      C      1     0   "*" IF DELETED                          
  90    M_NETSTAMP     N      2     0   NETWORK STAMP FOR MULTIUSER             
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 90 FIELDS = 1121

                                Related Indexes                                

TAMAST : M_DELFLAG+M_PROP+M_SUB+STRTRAN(STR(M_CTRLYEAR,4,0),' ','0')           
TANAME : M_DELFLAG+M_NAME1+M_PROP+M_SUB+STRTRAN(STR(M_CTRLYEAR,4,0),' ','0')   
TABILL : M_DELFLAG+STRTRAN(STR(M_BILLNUM,8,0),' ','0')                         
TASPAN : M_DELFLAG+
IIF(EMPT(LEFT(M_span,1)),'ZZZZZZZZZZZZZ',M_SPAN)+M_PROP+M_SU
TA911A : M_DELFLAG+
IIF(EMPTY(M_911LOCA),REPL("Z",53),M_911LOCA+STR(M_911NUM,9,0



 
TASYST : TAX ADMINISTRATION SYSTEM FILE                

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    S_PROPLEN      N      2     0   PROPERTY LENGTH UP TO 10                
   2    S_SUBLEN       N      2     0   SUB-PROPERTY LENGTH UP TO 10            
   3    S_YEARSIGN     N      2     0   SIGNIFICANT # OF UNIQUE YEAR 
CHARACTERS 
   4    S_NEXTDEPO     N      7     0   THE NEXT AVAILABLE GOOD DEPOSIT 
NUMBER  
   5    S_NEXTBILL     N      8     0   NEXT BILL NUMBER BE USED.               
   6    S_GLLINK       C      1     0   LINK TO G/L                             
   7    S_GLCOMP       C      2     0   IF FILE(GLENTITY.OPT) GL LINK ENTITY 
#  
   8    S_APLINK       C      1     0   LINK TO A/P                             
   9    S_APCOMP       C      2     0   IF FILE(GLENTITY.OPT) AP LINK ENTITY 
#  
  10    S_APVEND       C      9     0   TAX CREDIT VENDOR NUMBER                
  11    S_XFERDETL     C      1     0   'Y'ES TRANSFER BY ACCOUNT AND DATE      
  12    S_CASHACCR     C      1     0   'C'ASH OR 'A'CCRUAL G/L METHOD          
  13    S_SPLITRAT     C      1     0   YES IF USING G/L ACCTS SPECIFIC TO 
RATES
  14    S_PMTACCTS     C      1     0   YES IF USING G/L ACCTS SPECIFIC TO 
PMTS 
  15    S_RATEDES0     C     15     0   DEFAULT RATE DESCRIPTION 0               
  16    S_RATEDES1     C     15     0   DEFAULT RATE DESCRIPTION 1               
  17    S_RATEDES2     C     15     0   DEFAULT RATE DESCRIPTION 2               
  18    S_RATEDES3     C     15     0   DEFAULT RATE DESCRIPTION 3               
  19    S_RATEDES4     C     15     0   DEFAULT RATE DESCRIPTION 4               
  20    S_RATEDES5     C     15     0   DEFAULT RATE DESCRIPTION 5               
  21    S_RATEDES6     C     15     0   DEFAULT RATE DESCRIPTION 6               
  22    S_RATEDES7     C     15     0   DEFAULT RATE DESCRIPTION 7               
  23    S_RATEDES8     C     15     0   DEFAULT RATE DESCRIPTION 8              
  24    S_RATEDES9     C     15     0   DEFAULT RATE DESCRIPTION 9               
  25    S_RATERAT0     N      8     4   DEFAULT RATE AMOUNT 0                    
  26    S_RATERAT1     N      8     4   DEFAULT RATE AMOUNT 1                    
  27    S_RATERAT2     N      8     4   DEFAULT RATE AMOUNT 2                    
  28    S_RATERAT3     N      8     4   DEFAULT RATE AMOUNT 3                    
  29    S_RATERAT4     N      8     4   DEFAULT RATE AMOUNT 4                    
  30    S_RATERAT5     N      8     4   DEFAULT RATE AMOUNT 5                    
  31    S_RATERAT6     N      8     4   DEFAULT RATE AMOUNT 6                    
  32    S_RATERAT7     N      8     4   DEFAULT RATE AMOUNT 7                    
  33    S_RATERAT8     N      8     4   DEFAULT RATE AMOUNT 8                    
  34    S_RATERAT9     N      8     4   DEFAULT RATE AMOUNT 9                    
  35    S_SPLIT0       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 0       
  36    S_SPLIT1       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 1       
  37    S_SPLIT2       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 2       
  38    S_SPLIT3       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 3       
  39    S_SPLIT4       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 4       
  40    S_SPLIT5       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 5       
  41    S_SPLIT6       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 6       
  42    S_SPLIT7       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 7       
  43    S_SPLIT8       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 8       
  44    S_SPLIT9       M      0     0   MEMO HOLDS SPLIT ACCOUNT NUMBERS 9       
  45    S_PMTACCT1     M      0     0   MEMO THAT HOLDS ACCT NUMBERS 4 PMT 1    
  46    S_PMTACCT2     M      0     0   MEMO THAT HOLDS ACCT NUMBERS 4 PMT 2    
  47    S_PMTACCT3     M      0     0   MEMO THAT HOLDS ACCT NUMBERS 4 PMT 3    
  48    S_PMTACCT4     M      0     0   MEMO THAT HOLDS ACCT NUMBERS 4 PMT 4    
  49    S_NUMPMTS      N      1     0   NUMBER OF PAYMENTS                      
  50    S_NOTEEDIT     C      1     0   Y IF EDIT OF NOTES ALLOWED DURING 
CASH  
  51    S_INT_METH     C      1     0   INTEREST CALC METHOD "D"AILY/"M"ENU     
  52    S_INTDATE      D      8     0   DATE INTERST WAS LAST CALCULATED ON     
  53    S_INTPRCNT     N      5     2   INTEREST PERCENT UNDER 90 DAYS          
  54    S_PENPRCNT     N      5     2   PENALTY PERCENT UNDER 90 DAYS           
  55    S_PROPCTR      N      6     0   DELINQ PARCEL COUNTER                   
  56    S_CASH         C     25     0   CASH ACCOUNT NUMBER                     
  57    S_AR           C     25     0   ACCOUNT RECEIVABLE ACCOUNT              
  58    S_INTRECV      C     25     0   INTEREST RECEIVABLE ACCOUNT             
  59    S_PENRECV      C     25     0   PENALTY RECEIVABLE ACCOUNT              
  60    S_OTHRECV      C     25     0   OTHER RECEIVABLE ACCOUNT                
  61    S_DAR          C     25     0   DELIQUENT ACCOUNT RECEIVABLE ACCOUNT    
  62    S_DINTRECV     C     25     0   DELIQUENT INT RECEIVABLE ACCOUNT        
  63    S_DPENRECV     C     25     0   DELIQUENT PEN RECEIVABLE ACCOUNT        
  64    S_DOTHRECV     C     25     0   DELIQUENT OTHER RECEIVABLE ACCOUNT      
  65    S_P_ABATE      C     25     0   ABATEMENTS FOR PRINCIPAL                
  66    S_I_ABATE      C     25     0   ABATEMENTS FOR INTEREST                 
  67    S_N_ABATE      C     25     0   ABATEMENTS FOR PENALTY                  
  68    S_O_ABATE      C     25     0   ABATEMENTS FOR OTHER                    
  69    S_CMP          C     25     0   CREDIT MEMOS PAYABLE ACCOUNT            
  70    S_SMP          C     25     0   DUE TO TAXPAYER FROM STATE ACCOUNT      
  71    S_TAX          C     25     0   TAX REVENUE ACCOUNT                     
  72    S_INT          C     25     0   INTEREST ACCOUNT                        
  73    S_PEN          C     25     0   PENALTY ACCOUNT                         
  74    S_OTHER        C     25     0   OTHER ACCOUNT                           
  75    S_DTAX         C     25     0   DEL TAX REVENUE ACCOUNT                 
  76    S_DINT         C     25     0   DEL INT REVENUE ACCOUNT                 
  77    S_DPEN         C     25     0   DEL PEN REVENUE ACCOUNT                 
  78    S_DOTHER       C     25     0   DEL OTHER REVENUE ACCOUNT               
  79    S_DISC         C     25     0   DISCOUNT ACCOUNT                        
  80    S_DUETO        C     25     0   DUE TO OTHER FUNDS ACCOUNT              
  81    S_DUEFROM      C     25     0   DUE FROM OTHER FUNDS ACCOUNT            
  82    S_TRESADD1     C     30     0   TREASURES ADDRESS 1                      
  83    S_TRESADD2     C     30     0   TREASURES ADDRESS 2               
  84    S_TRESADD3     C     30     0   TREASURES ADDRESS 3               
  85    S_CLTADD1      C     30     0   COLLECTORS ADDRESS 1                      
  86    S_CLTADD2      C     30     0   COLLECTORS ADDRESSS 2             
  87    S_CLTADD3      C     30     0   COLLECTORS ADDRESS 3              
  88    S_MISCFELD     C     50     0   TITLES FOR MISCELLANEOUS FIELDS         
  89    S_NOTICE1      M      0     0   DELINQUENT NOTICE 1                     
  90    S_NOTICE2      M      0     0   DELINQUENT NOTICE 2               
  91    S_NOTICE3      M      0     0   DELINQUENT NOTICE 3               
  92    S_NOTICE4      M      0     0   DELINQUENT NOTICE 4               
  93    S_NOTICE5      M      0     0   DELINQUENT NOTICE 5               
  94    S_PERIOD       N      2     0   CURRENT PERIOD IN CR                    
  95    S_GLNXTBAT     N      3     0   NEXT BATCH NUMBER FOR TRANSFER TO G/L   
  96    S_APNXTBAT     N      3     0   NEXT BATCH NUMBER FOR TRANSFER TO A/P   
  97    S_YEAR         N      4     0   CURRENT YEAR IN CR                      
  98    S_CURRENT1     C      1     0   (Y/N) APPLY CASH RECEIPT TO CURRENT 
1ST 
  99    S_DEFORDER     C      4     0   ORDER TO APPLY PAYMENT IN (SEE BELOW)   
 100    S_APPLY1ST     C      1     0   APPLY CASH ACROSS APPLICATIONS FIRST    
 101    S_PRORATE      C      1     0   APPLY PARTIAL PAYMENTS ON PRO-RATA      
 102    S_OLDYEAR1     C      1     0   APPLY OLD YEARS FIRST                   
 103    S_FULLDISC     C      1     0   APPLY DISC TO FULL PAYMENTS ONLY        
 104    S_PROALL       C      1     0   PRO-RATE PENALTY AND APPS AFTER 
PENALTY 
 105    S_PROLAST      C      1     0   PRO-RATE ONLY THE LAST NOT FULL 
PAYMENT 
 106    S_NEXTDAYS     N      3     0   DEFAULT NEXT AMOUNT DUE AFTER (DAYS)    
 107    S_FULLPAY      C      1     0   ALLOW ONLY FULL PAYMENTS                
 108    S_CHKNEG       C      1     0   Y TO RUN AUTO NEGATIVE DUE TO CREDIT 
ADJ
 109    S_F05          C     30     0   FUNCTION KEY F5                         
 110    S_F06          C     30     0   FUNCTION KEY F6                         
 111    S_F07          C     30     0   FUNCTION KEY F7                         
 112    S_F08          C     30     0   FUNCTION KEY F8                         
 113    S_F09          C     30     0   FUNCTION KEY F9                         
 114    S_F10          C     30     0   FUNCTION KEY F10                        
 115    S_F11          C     30     0   FUNCTION KEY F11                        
 116    S_F12          C     30     0   FUNCTION KEY F12                        
 117    S_NETSTAMP     N      2     0   NETWORK STAMP                           
 118    S_JANUARY      N      2     0   JAN IS WHAT PERIOD FOR UPPER LEFT 
CORNER
 119    S_SYSTEM       C      8     0   HOLDS VERSION UPGRADE PROBLEM CODE      
 120    S_NH           C      1     0   NEW HAMPSHIRE OPTIONS AVAILABLE         
 121    S_VERDATE      D      8     0   DATE OF LAST UPDATE                     
 122    S_PVERSION     C      4     0   PREVIOUS NEMRC EXECUTABLE               
 123    S_VERSION      C      4     0   NEMRC EXECUTABLE THAT MATCHES DATA 
FILES
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 123 FIELDS = 1474




 
TATRAX : TRANSACTION FILE                       

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    T_PROP         C     10     0   PARCEL NUMBER RIGHT JUSTIFIED           
   2    T_SUB          C     10     0   PARCEL NUMBER LEFT JUSTFIFIED           
   3    T_YEAR         C     10     0   FISCAL YEAR EX: 9394                    
   4    T_CTRLYEAR     N      4     0   NEMRC CONTROL YEAR                      
   5    T_AMOUNT       N     12     2   AMOUNT OF THE TRANSACTION               
   6    T_DATE         D      8     0   DATE THE TRANSACTION WAS RECEIVED       
   7    T_TIME         C      8     0   TIME TRANSACTION RECORDED               
   8    T_TYPE         C      4     0   TRANSACTION TYPE                        
   9    T_DEPOSIT      N      9     1   DEPOSIT NUMBER                          
  10    T_GL_POST      C      3     0   '   ' IF NOT POSTED TO G/L (BATCH #)  
  11    T_MISC         C     30     0   SYSTEM COMMENT FIELD                    
  12    T_MEMO         M      8     0   SYSTEM MEMO FIELD                       
  13    T_COMMENT      C     30     0   USER COMMENT FIELD                      
  14    T_DELFLAG      C      1     0   "*" IF DELETED                          
  15    T_NETSTAMP     N      2     0   NETWORK STAMP                           
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 15 FIELDS = 149

                                Related Indexes                                

TATRAX : T_DELFLAG+T_PROP+T_SUB+STRTRAN(STR(T_CTRLYEAR,4,0),' ','0')           
TADATE : T_DELFLAG+DTOS(T_DATE)                                                
TAPOST : T_DELFLAG+T_GL_POST                                                   
TADEPO : T_DELFLAG+STR(T_DEPOSIT,9,1)                                          



 
TAX2AP : TRANSFER FILE TO TRANSFER TO AP               

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PVENDNO        C      9     0   VENDOR NUMBER                           
   2    PINVNO         C     12     0   INVOICE NUMBER                          
   3    REF            C      8     0   PURCHASE ORDER NUMBER                   
   4    CHECKNO        C      8     0   CHECK NUMBER                            
   5    POSTAT         C      1     0   U=UNPAID,P=PAID,V=VOID                  
   6    PCOMPANY       C     35     0   VENDOR COMPANY NAME                     
   7    PADDRESS1      C     35     0   VENDOR ADDRESS 1                         
   8    PADDRESS2      C     35     0   VENDOR ADDRESS 2                         
   9    PCITY          C     25     0   VENDOR CITY                             
  10    PSTATE         C     10     0   VENDOR STATE                            
  11    PZIP           C     10     0   VENDOR ZIP                              
  12    PPRIORITY      C      2     0   CHECKING ACCOUNT CODE (MN=MANUAL)       
  13    PURDATE        D      8     0   DATE OF PURCHASE (INVOICE DATE)         
  14    DUEDATE        D      8     0   DATE PAYMENT DUE                        
  15    CHECKDATE      D      8     0   DATE OF CHECK                           
  16    PURAMT         N     11     2   FULL AMOUNT OF PURCHASE                 
  17    DISAMT         N     11     2   DISCOUNT AMOUNT                         
  18    PAIDAMT        N     11     2   AMOUNT PAID                             
  19    CHECKACC       C     25     0   G/L NET ACCOUNT NUMBER                  
  20    M_FUNDESC      C     15     0   FUND DESCRIPTION                        
  21    M_FISCYR       C      9     0   FISCAL YEAR (1234-1234)                 
  22    M_INVDESC      C     25     0   INVOICE DESCRIPTION                     
  23    M_DISPERC      N      5     2   DISCOUNT PERCENTAGE                     
  24    M_DISDAY       N      2     0   # DAYS TO CALC DISCOUNT DUE DATE        
  25    M_DUEDAY       N      2     0   # DAYS TO CALC FINAL DUE DATE           
  26    M_VOUCHER      C      8     0   VOUCHER NUMBER                          
  27    M_FROMPO       C      1     0   "Y"=INVOICE STARTED AS A PO             
  28    M_1099         C      1     0   "Y"=INVOICE IS A 1099 PAYMENT           
  29    M_MISCFLG      C      1     0   USED DURING:REPRINT & WARRANT REPO      
  30    M_GL_POST      C      1     0   "Y"=POSTED TO G/L " " = NOT POSTED      
  31    M_GL_INV       C      1     0   "Y"=INVOICE HAS BEEN POSTED             
  32    M_GL_CHK       C      1     0   "Y"=CHECK HAS BEEN POSTED               
  33    M_GL_BAT       C      3     0   GL BATCH NUMBER                         
  34    M_MANUAL       C      1     0   'Y' OR 'N' IF MANUAL                    
  35    M_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  36    M_DELFLAG      C      1     0   "*" FOR RE-USABLE RECORD                
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 36 FIELDS = 351



 
TAX2GL : TRANSFER TO GENERAL LEDGER                  

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    TRSACT         C     25     0   ACCOUNT NUMBER                          
   2    TRSDES         C     25     0   TRANSACTION DESCRIPTION                 
   3    TRSREF         C     12     0   REFERENCE NUMBER                        
   4    TRSDATE        D      8     0   TRANSACTION DATE                        
   5    TRSAMT         N     15     2   AMOUNT                                  
   6    TRSID          C      1     0   0=SPECIAL,1=POSTING,2=REFERENCE         
   7    TRSMODU        C      2     0   MODULE THAT GENERATED THIS POSTING      
   8    TRSCOMPID      C      2     0   COMPANY ID THAT GENERATED THIS 
POSTING  
   9    TRSTYPE        C      1     0   TRANSACTION TYPE (SEE BELOW)            
  10    TRSPD          C      2     0   G/L PERIOD OF POSTING                   
  11    TRSDELFLAG     C      1     0                                           
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 11 FIELDS = 94	

© NEMRC 2010-2021 | Privacy Policy