Cash Receipts FAQ
Open as: PDF or Word Document
Cash Receipts - Data Dictionary
Table of Contents
CRACCT : GL ACCOUNTS FOR CASH RECEIPT CODES
CRCODE : CASH RECEIPTS CODE TABLE
CRRMIT : REMITTANCE/PASSWORD LINK FIL
CRSYST : CASH RECEIPTS SYSTEM FILE
CRACCT : GL ACCOUNTS FOR CASH RECEIPT CODES No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 A_CODE C 4 0 POSTING CODE 2 A_ACCT C 25 0 G/L ACCOUNT TO CREDIT 3 A_AMOUNT N 11 2 AMOUNT OF DEFAULT POSTING AMOUNT APPLIED TO THIS ACCOUNT (0.00 = NONE SPECIFIED) 4 A_DELFLAG C 1 0 DELETION FLAG ("*"=DELETED/REUSEABLE) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 4 FIELDS = 41 Related Indexes CRACCT : A_DELFLAG + upper(A_CODE)
CRCODE : CASH RECEIPTS CODE TABLE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 C_CODE C 4 0 POSTING CODE 2 C_DESC C 25 0 POSTING CODE DESCRIPTION 3 C_AMOUNT N 11 2 DEFAULT AMOUNT WHEN POSTING THIS CODE (0.00 = NONE SPECIFIED) 4 C_ACCT C 25 0 G/L ACCOUNT TO CREDIT 5 C_DBACCT C 25 0 G/L ACCOUNT TO DEBIT 6 C_DUETO C 25 0 DUE TO OTHER FUNDS ACCOUNT IF NEEDED 7 C_DUEFROM C 25 0 DUE FROM OTHER FUNDS ACCOUNT IF 8 C_ENTITY C 2 0 GL ENTITY LINK 9 C_STATUS C 1 0 (A)CTIVE (I)NACTIVE 10 C_TAENTITY C 2 0 LINKED TO WHICH TA ENTITY 11 C_UBENTITY C 2 0 LINKED TO WHICH UB ENTITY 12 C_ARENTITY C 2 0 LINKED TO WHICH AR ENTITY 13 C_TACODE C 1 0 DEFAULT CODE FOR TA POSTING/SWIPING? (Y/N) 14 C_UBCODE C 1 0 DEFAULT CODE FOR UB POSTING/SWIPING? (Y/N) 15 C_ARCODE C 1 0 DEFAULT CODE FOR AR POSTING/SWIPING? (Y/N) 16 C_XFERCOMM C 1 0 PROMPT USER FOR COMMENT DURING POSTING? (Y/N) 17 C_COMMPRPT C 30 0 PROMPT FOR POSTING COMMENT 18 C_NETSTAMP N 2 0 NETWORK STAMP 19 C_DELFLAG C 1 0 DELETION FLAG ("*"=DELETED/REUSEABLE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 19 FIELDS = 186 Related Indexes CRCODE : C_DELFLAG+upper(C_CODE)
CRCUST : ACCOUNT FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 CR_CUST C 20 0 CONCATENATED ACCOUNT NUMBER 2 CR_ACCT C 10 0 ACCOUNT NUMBER (FROM TA/UB/AR 3 CR_SUB C 10 0 SUBACCOUNT NUMBER (FROM TA/UB/AR) 4 CR_NAME C 40 0 CUSTOMER NAME 5 CR_MODULE C 2 0 MODULE FROM WHICH THIS RECORD ORIGINATED 6 CR_ENTITY C 2 0 ENTITY NUMBER FROM WHICH THIS RECORD ORIGINATED 7 CR_DATE C 15 0 DESCRIPTION FIELD (TA = YEAR)(UB = SERVICE) 8 CR_AMT01 N 9 2 [TA = PAYMENT 1] [UB = ] [AR = AMOUNTDUE] 9 CR_AMT02 N 9 2 AMOUNT OWED FOR PAYMENT 2 10 CR_AMT03 N 9 2 AMOUNT OWED FOR PAYMENT 11 CR_AMT04 N 9 2 AMOUNT OWED FOR PAYMENT 4 12 CR_AMT05 N 9 2 AMOUNT OWED FOR PAYMENT 5 13 CR_AMT06 N 9 2 AMOUNT OWED FOR PAYMENT 6 14 CR_AMT07 N 9 2 USED DURING VIEW BALANCES PROCESSING TO HOLD VARYING CATEGORIES OF BALANCES 15 CR_INT N 9 2 AMOUNT OF INTEREST DUE 16 CR_PEN N 9 2 AMOUNT OF PENALTY DUE 17 CR_TADUE1 D 8 0 DUE DATE OF FIRST TAX PAYMENT 18 CR_TADUE2 D 8 0 DUE DATE OF SECOND TAX PAYMENT 19 CR_TADUE3 D 8 0 DUE DATE OF THIRD TAX PAYMENT 20 CR_TADUE4 D 8 0 DUE DATE OF FOURTH TAX PAYMENT 21 CR_BILLNUM N 8 0 BAR CODED BILL NUMBER 22 CR_BARDATE D 8 0 DATE BAR-CODED BILL WAS CRAETED 23 CR_TACTRL N 4 0 TA TAX YEAR CONTROL NUMBER 24 CR_ASSESS N 12 2 TAX ASSESSMENT 25 CR_TABILL N 10 2 AMOUNT OF TAXES BILLED 26 CR_NXTDATE D 8 0 TA/UB NEXT DUE DATE FOR TAX PAYMENTS (IF UNIQUE IN TA) 27 CR_NXTPAY C 1 0 TA/UB PAYMENT NUMBER REPRESENTED BY CR_NXTDATE 28 CR_CODE C 4 0 CODE TO USE WHEN AUTOPOSTING VIA CR_BILLNUM 29 CR_AGREE M 0 0 MEMO FROM OTHER MODULE ABOUT AGREEMENT ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 29 FIELDS = 267 Related Indexes CRCUST : upper(CR_ACCT+CR_SUB+CR_NAME) CRNAME : upper(CR_NAME+CR_ACCT+CR_SUB) CRBILL : str(CR_BILLNUM,8,0) CRMODL : CR_MODULE+CR_ENTITY+upper(CR_ACCT+CR_SUB) CRUNUM : upper(CR_ACCT+CR_SUB+CR_NAME) CRUNAM : upper(CR_NAME+CR_ACCT+CR_SUB)
CRRMIT : REMITTANCE/PASSWORD LINK FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 R_PASS C 8 0 PASSWORD FOR REMITTANCE/DEPOSIT NUMBER CONTROL 2 R_REMIT C 6 0 REMITTANCE NUMBER WHICH IS LINKED TO R_PASS (RIGHT-JUSTIFIED) 3 R_DEPOSIT N 9 1 DEPOSIT NUMBER WHICH IS LINKED TO R_PASS 4 R_1STPAUSE C 1 0 'Y' IF WE GO DIRECTLY TO ACTION ON BILL NUMBER SWIPE 5 R_DELFLAG C 1 0 DELETION FLAG ("*"=DELETED/REUSEABLE) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 5 FIELDS = 25 Related Indexes CRRMIT : R_DELFLAG+upper(R_PASS)
CRSYST : CASH RECEIPTS SYSTEM FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 S_PROPLEN N 2 0 ACCOUNT NUMBER LENGTH 2 S_SUBLEN N 2 0 SUBACCOUNT NUMBER LENGTH 3 S_CRFORM C 2 0 RECEIPT FORM NUMBER 4 S_DOOR C 1 0 USE (D)EPOSIT OR (R)EMITTANCE NUMBER CONTROL 5 S_LSTREMIT C 6 0 LAST REMITTANCE NUMBER USED (RIGHT- JUSTIFIED) 6 S_LSTDEPO N 9 1 LAST DEPOSIT NUMBER USED 7 S_CHGREMIT C 1 0 CHANGE REMITTANCE/DEPOSIT NUMBER DURING POSTING? (Y/N) 8 S_GLACCESS C 1 0 ALLOW ACCESS TO GL ACCOUNT NUMBERS WHEN POSTING? (Y/N) 9 S_ADD2RMT C 1 0 AUTOMATICALLY ADVANCE REMITTANCE/DEPOSIT NUMBER AFTER GL TRANSFER? (Y/N) 10 S_NXTPOST N 6 0 NEXT SEQUENCE NUMBER TO USE POSTING CRTRAX 11 S_GLNXTBAT N 3 0 NEXT BATCH NUMBER FOR TANSFER TO GL 12 S_TANXTBAT N 3 0 NEXT BATCH NUMBER FOR TANSFER TO TA 13 S_UBNXTBAT N 3 0 NEXT BATCH NUMBER FOR TANSFER TO UB 14 S_ARNXTBAT N 3 0 NEXT BATCH NUMBER FOR TANSFER TO AR 15 S_CHKDEF C 8 0 DEFAULT CHECK NUMBER TO USE WHEN POSTING (OBSOLETE) 16 S_HOWPAY C 12 0 DEFAULT PAYMENT METHOD 17 S_CDRAW C 1 0 IS THERE AN INDIANA CASH DRAWER ATTACHED? (Y/N) 18 S_STATTRK C 1 0 TRACK WORKSTATION IDENTIFIERS? (Y/N) 19 S_COMMENT C 1 0 SHOW COMMENT FOR LINE ITEMS? (Y/N) 20 S_TABILL C 1 0 USE BILL NUMBERS/BAR CODES? (Y/N) 21 S_TAXLINK C 1 0 USE CUSTOMER ACCOUNT NUMBERS? (Y/N) (ACCT NUMBERS RIGHT JUSTIFIED) (SUBACCT NUMBERS LEFT JUSTIFIED) 22 S_FAKEACCT C 1 0 ACCEPT IMAGINARY ACCOUNT NUMBERS WHEN POSTING? (Y/N) 23 S_1STPAUSE C 1 0 GO DIRECTLY TO A SAVE ON BILL NUMBER SWIPE? (Y/N) 24 S_RPROMPT C 1 0 PROMPT FOR RECEIPT WHEN SAVING? (Y/N) 25 S_REPRINT C 1 0 REPRINT RECEIPT? "N"=NEVER "P"=P`ROMPT "A"=ALWAYS 26 S_SWIPER C 1 0 PRINT RECEIPT AFTER SWIPING? "N"=NEVER "P"=P`ROMPT "A"=ALWAYS 27 S_GLLINK C 1 0 LINKED TO GL? (Y/N) 28 S_TALINK C 1 0 LINKED TO TA? (Y/N) 29 S_UBLINK C 1 0 LINKED TO UB? (Y/N) 30 S_ARLINK C 1 0 LINKED TO AR? (Y/N) 31 S_PSLINK C 1 0 PASSWORD LINKED TO REMITTANCE/DEPOSIT NUMBER? (Y/N) 32 S_GLXFER C 1 0 TRANSFER TO GL: "Y" = DETAIL BY DATE "N" = BATCH SUMMARY 33 S_PAYXFER C 1 0 TRANSFER PAYMENT TYPE DETAIL TO GL? (Y/N) 34 S_PERIOD N 2 0 CURRENT PERIOD IN CR 35 S_YEAR N 4 0 CURRENT YEAR IN CR 36 S_LSTCLOSE D 8 0 DATE OF THE LAST YEAR END CLOSE 37 S_TAXLINK C 1 0 'Y'ES BY DEFAULT (ACCT NUMBERS RIGHT JUSTIFIED) (SUBACCT NUMBERS LEFT JUSTIFIED) 38 S_F05 C 30 0 FUNCTION KEY F5 39 S_F06 C 30 0 FUNCTION KEY F6 40 S_F07 C 30 0 FUNCTION KEY F7 41 S_F08 C 30 0 FUNCTION KEY F8 42 S_F09 C 30 0 FUNCTION KEY F9 43 S_F10 C 30 0 FUNCTION KEY F10 44 S_F11 C 30 0 FUNCTION KEY F11 45 S_F12 C 30 0 FUNCTION KEY F12 46 S_S_AND_R C 1 0 'Y' DEFAULT SAVE AND RECEIPT (OBSOLETE) 47 S_SYSTEM C 16 0 RESERVED FOR SYSTEM USE 48 S_NOTES M 0 0 EXPLANATION OF SITE-SPECIFIC CODES USED IN S_SYSTEM 49 S_JANUARY N 2 0 FISCAL PERIOD OF THE MONTH OF JANUARY 50 S_VERSION C 4 0 NEMRC EXECUATABLE THAT MATCHES THIS DATA 51 S_OLDVER C 4 0 PREVIOUS INSTALLED VERSION OF THE MODULE 52 S_UPVER D 8 0 DATE THE NEW VERSION WAS INSTALLED 53 S_NETSTAMP N 2 0 NETWORK STAMP ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 53 FIELDS = 372
CRTRAX : TRANSACTION FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 T_SEQNO C 6 0 SEQUENCE NUMBER FOR THIS POSTING 2 C_CODE C 4 0 POSTING TYPE CODE FROM CRCODE 3 T_CUSTOMER C 20 0 CONCATENATED CUSTOMER ACCOUNT NUMBER 4 T_ACCT C 10 0 ACCOUNT NUMER 5 T_SUB C 10 0 SUBACCOUNT NUMBER 6 T_REMIT C 6 0 REMITTANCE NUMBER 7 T_DEPOSIT N 9 1 DEPOSIT NUMBER 8 T_NAME C 40 0 NAME MATCHING ACCOUNT NUMBER 9 T_PAYER C 40 0 ACTUAL NAME OF PAYING PERSON/ENTITY 10 T_OPERATOR C 8 0 PERSONAL ID OF PERSON RECEIVING CASH 11 T_DATE D 8 0 POSTING DATE 12 T_TIME C 8 0 POSTING TIME 13 T_STATION C 15 0 WORKSTATION ID 14 T_DESC C 25 0 DESCRIPTION OF CASH RECEIPT CODE 15 T_COMMENT C 30 0 TRANSACTION COMMENT 16 T_AMOUNT N 11 2 AMOUNT OF THIS TRANSACTION 17 T_HOWPAY C 1 0 HOW PAYMENT WAS MADE "C"HECK CAS"H" C"R"EDIT CARD "D"EBIT CARD "W"ANDED "U"NSPECIFIED "E"LECTRONIC 18 T_CHECK C 8 0 CHECK NUMBER 19 T_VOID C 1 0 'V' FOR VOID OR OTHER STATUS 20 T_GLENTITY C 2 0 GL ENTITY FOR THIS PAYMENT CODE 21 T_STATUS C 1 0 GL TRANSFER STATUS BLANK = UNTRANSFERRED "Y"=TRANSFER TO GL "R"FND = REFUND DOES NOT TRANSFER 22 T_BATCH C 3 0 GL TRANSFER BATCH NUMBER 23 T_DEBIT C 25 0 GL ACCOUNT TO DEBIT 24 T_CREDIT C 25 0 GL ACCOUNT TO CREDIT 25 T_TAENTITY C 2 0 TA ENTITY FOR THIS PAYMENT CODE 26 T_TASTATUS C 1 0 TA TRANSFER STATUS 27 T_TABATCH C 3 0 TA TRANSFER BATCH NUMBER 28 T_UBENTITY C 2 0 UB ENTITY FOR THIS PAYMENT CODE 29 T_UBSTATUS C 1 0 UB TRANSFER STATUS 30 T_UBBATCH C 3 0 UB TRANSFER BATCH NUMBER 31 T_ARENTITY C 2 0 AR ENTITY FOR THIS PAYMENT CODE 32 T_ARSTATUS C 1 0 AR TRANSFER STATUS 33 T_ARBATCH C 3 0 AR TRANSFER BATCH NUMBER ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 33 FIELDS = 334 Related Indexes CRTRAX : dtos(T_DATE)+upper(T_ACCT+T_SUB+C_CODE) CRREMT : upper(T_REMIT) CRDEPO : T_DEPOSIT CRSEQN : T_SEQNO+ upper(T_ACCT+T_SUB+C_CODE) CRVBAL : upper(T_ACCT+T_SUB+C_CODE) + dtos(T_DATE) + T_SEQNO
CRX2AR : AR TRANSER FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 X_BATCH C 3 0 BATCH NUMBER 2 X_PROPSUB C 20 0 CONCATENATED ACCOUNT NUMBER 3 X_ACCT C 10 0 ACCOUNT NUMER 4 X_SUB C 10 0 SUBACCOUNT NUIMBER 5 X_NAME C 40 0 NAME OF CUSTOMER 6 X_AMOUNT N 15 2 TRANSFER AMOUNT CANNOT BE NEGATIVE 7 X_HOWPAY C 1 0 HOW PAYMENT WAS MADE "C"HECK CAS"H" C"R"EDIT CARD "D"EBIT CARD "W"ANDED "M"IXED 8 X_CHECK C 8 0 CHECK NUMBER CASH IF CASH 9 X_DATE D 8 0 DATE OF RECEIPT 10 X_TIME C 8 0 TIME OF RECEIPT 11 X_OPERATOR C 8 0 NAME OF PERSON WHO POSTED 12 X_CODE C 4 0 CODE BEING PASSED 13 X_PAYER C 40 0 ACTUAL NAME OF PAYING PERSON/ENTITY 14 X_COMMENT C 30 0 TRANSACTION COMMENT ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 14 FIELDS = 205
CRX2GL : GL TRANSFER FILE 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 DELETION FLAG ("*"=DELETED/REUSEABLE) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 11 FIELDS = 94
CRX2TA : TA TRANSER FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 X_BATCH C 3 0 BATCH NUMBER 2 X_PROPSUB C 20 0 CONCATENATED ACCOUNT NUMBER 3 X_ACCT C 10 0 ACCOUNT NUMER 4 X_SUB C 10 0 SUBACCOUNT NUIMBER 5 X_NAME C 40 0 NAME OF CUSTOMER 6 X_AMOUNT N 15 2 TRANSFER AMOUNT CANNOT BE NEGATIVE 7 X_HOWPAY C 1 0 HOW PAYMENT WAS MADE "C"HECK CAS"H" C"R"EDIT CARD "D"EBIT CARD "W"ANDED "M"IXED 8 X_CHECK C 8 0 CHECK NUMBER CASH IF CASH 9 X_DATE D 8 0 DATE OF RECEIPT 10 X_TIME C 8 0 TIME OF RECEIPT 11 X_OPERATOR C 8 0 NAME OF PERSON WHO POSTED 12 X_CODE C 4 0 CODE BEING PASSED TO TA 13 X_PAYER C 40 0 ACTUAL NAME OF PAYING PERSON/ENTITY 14 X_COMMENT C 30 0 TRANSACTION COMMENT ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 14 FIELDS = 205
CRX2UB : UB TRANSER FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 X_BATCH C 3 0 BATCH NUMBER 2 X_PROPSUB C 20 0 ACCOUNT NUMBER 3 X_ACCT C 10 0 ACCOUNT NUMBER 4 X_SUB C 10 0 SUBACCOUNT NUMBER 5 X_NAME C 40 0 NAME OF CUSTOMER 6 X_AMOUNT N 15 2 TRANSFER AMOUNT CANNOT BE NEGATIVE 7 X_HOWPAY C 1 0 HOW PAYMENT WAS MADE "C"HECK CAS"H" C"R"EDIT CARD "D"EBIT CARD "W"ANDED "M"IXED 8 X_CHECK C 8 0 CHECK NUMBER CASH IF CASH 9 X_DATE D 8 0 DATE OF RECEIPT 10 X_TIME C 8 0 TIME OF RECEIPT 11 X_OPERATOR C 8 0 NAME OF PERSON WHO POSTED 12 X_CODE C 4 0 CODE BEING PASSED TO 13 X_PAYER C 40 0 ACTUAL NAME OF PAYING PERSON/ENTITY 14 X_COMMENT C 30 0 TRANSACTION COMMENT ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 14 FIELDS = 205
