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
TASYST : TAX ADMINISTRATION SYSTEM 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
