Accounts Receivable FAQ
Open as: PDF or Word Document
Accounts Receivable - Data Dictionary
Table of Contents
ARCASH : TEMPORARY CASH RECEIPTS FILE
ARCODE : ACCOUNT RECEIVABLE SERVICE MASTER FILE
ARCOMM : ACCOUNTS RECEIVABLE COMMENT FILE
ARCUST : ACCOUNTS RECEIVABLE CLIENT FILE
ARDIST : HOLDS PREVIOUS TRANSFERS
ARFORM : ACCOUNTS RECEIVABLE STATEMENT FORMS FILE
ARPEND : PENDING INVOICES ENTERED FROM REMOT
ARPROJ : ACCOUNTS RECEIVABLE PROJECT FILE
ARSYST : ACCOUNTS RECEIVABLE SYSTEM FILE
ARTRAX : ACCOUNTS RECEIVABLE TRAX FILE
ARCASH : TEMPORARY CASH RECEIPTS FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 H_SEQNO N 10 0 UNIQUE SERVICE NUMBER (SYSTEM ASSIGNED) 2 H_CUSTNO C 10 0 CLIENT NUMBER 3 H_SUB C 10 0 SUB CLIENT NUMBER 4 H_PROJNO C 6 0 CASE NUMBER 5 H_CREATED D 8 0 DATE OF THIS TRANSACTION 6 H_TIME C 8 0 TIME OF TRANSACTION 7 H_CODE C 6 0 SERVICE NUMBER 8 H_DEPOSIT N 9 1 DEPOSIT NUMBER 9 H_CHECKNO C 8 0 CHECK NUMBER IF ANY 10 H_DESCR C 80 0 DESCRIPTION OF SERVICE 11 H_UNITPR N 12 4 UNIT PRICE CHARGED 12 H_QTY N 7 2 NUMBER OF UNITS (QUANTITY) 13 H_GL_BATCH C 3 0 TRANSFERRED TO G/L ON BATCH NUMBER 14 H_PRINTED D 8 0 DATE TRANSACTION WAS PRINTED 15 H_TYPE C 3 0 TRANSACTION TYPE (SEE BELOW) 16 H_MISC C 30 0 SYSTEM USED COMMENTS 17 H_MISC0 C 20 0 MISC FIELD 0 (USER DEFINED) 18 H_MISC1 C 20 0 MISC FIELD (USER DEFINED) 19 H_MISC2 C 20 0 MISC FIELD (USER DEFINED) 20 H_MISC3 C 20 0 MISC FIELD (USER DEFINED) 21 H_MISC4 C 20 0 MISC FIELD (USER DEFINED) 22 H_NETSTAMP N 2 0 NETSTAMP 23 H_DELFLAG C 1 0 "*" IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 23 FIELDS = 321 Related Indexes ARCASH : H_DELFLAG+H_CUSTNO+H_SUB+STR(H_SEQNO,10)+H_CODE
ARCODE : ACCOUNT RECEIVABLE SERVICE MASTER FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 D_CODE C 6 0 UNIQUE SERVICE OR ACTIVITY NUMBER 2 D_DESCR C 80 0 SERVICE DESCRIPTION 3 D_PRICE N 12 4 RATE FOR THIS SERV (COULD BE TAX.) 4 D_TAXABLE1 C 1 0 IS THIS SERVICE TAXABLE FOR RATE 1 5 D_TAXABLE2 C 1 0 IS THIS SERVICE TAXABLE FOR RATE 2 6 D_TAXABLE3 C 1 0 IS THIS SERVICE TAXABLE FOR RATE 3 7 D_CASH C 25 0 GL CASH ACCOUNT 8 D_AR C 25 0 GL ACCOUNTS RECEIVABLE 9 D_FINAR C 25 0 GL FINANCE CHARGES RECEIVABLE 10 D_BADDEBT C 25 0 GL WRITE OFF OF BAD DEBTS ACCOUNT 11 D_REV C 25 0 GL REVENUE ACCOUNT 12 D_FINREV C 25 0 GL FINANCE CHARGE REVENUE ACCOUNT 13 D_NETSTAMP N 2 0 NETSTAMP 14 D_DELFLAG C 1 0 "*" IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 14 FIELDS = 254 Related Indexes ARCODE : D_DELFLAG+D_CODE
ARCOMM : ACCOUNTS RECEIVABLE COMMENT FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 M_COMMID C 6 0 COMMENT CODE 2 M_COMMENT M 0 0 MEMO FIELD 3 M_DELFLAG C 1 0 "*" IF DELETED 4 M_NETSTAMP N 2 0 NETWORK STAMP ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 4 FIELDS = 9 Related Indexes ARCOMM : M_DELFLAG+M_COMMID
ARCUST : ACCOUNTS RECEIVABLE CLIENT FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 C_CUSTNO C 10 0 CLIENT NUMBER 2 C_SUB C 10 0 SUB CLIENT NUMBER 3 C_NAME1 C 40 0 NAME OF CUSTOMER 4 C_NAME2 C 40 0 NAME OF CUSTOMER (POSSIBLE COMPANY NAME) 5 C_ADDRESS1 C 30 0 FIRST ADDRESS LINE 6 C_ADDRESS2 C 30 0 SECOND ADDRESS LINE 7 C_CITY C 15 0 CITY 8 C_STATE C 2 0 STATE 9 C_ZIP C 10 0 ZIP CODE 10 C_PHONE C 12 0 TELEPHONE NUMBER 11 C_FAX C 12 0 FAX NUMBER 12 C_LDATE D 8 0 DATE OF LAST BILLING 13 C_LASTPAY D 8 0 DATE OF LAST PAYMENT RECEIVED 14 C_BALANCE N 10 2 A/R BALANCE 15 C_TAXABLE1 C 1 0 'Y'ES IF TAXED FOR RATE 1 16 C_TAXABLE2 C 1 0 'Y'ES IF TAXED FOR RATE 2 17 C_TAXABLE3 C 1 0 'Y'ES IF TAXED FOR RATE 3 18 C_INTEREST C 1 0 'N' IF EXEMPT FOR INTEREST 19 C_COMMID C 6 0 COMMENT CODE FOR STATEMENTS 20 C_AGREE M 0 0 AGREEMENT MEMO (USER DEFINED) 21 C_NOTES M 0 0 CUSTOMER NOTES (USER DEFINED) 22 C_MISC0 C 20 0 MISC 0 23 C_MISC1 C 20 0 MISC 1 24 C_MISC2 C 20 0 MISC 2 25 C_MISC3 C 20 0 MISC 3 26 C_MISC4 C 20 0 MISC 4 27 C_MISC5 C 20 0 MISC 5 28 C_MISC6 C 20 0 MISC 6 29 C_MISC7 C 20 0 MISC 7 30 C_MISC8 C 20 0 MISC 8 31 C_MISC9 C 20 0 MISC 9 32 C_NETSTAMP N 2 0 NETWORK STAMP 33 C_DELFLAG C 1 0 "*" = DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 33 FIELDS = 450 Related Indexes ARCUST : C_DELFLAG+C_CUSTNO+C_SUB ARNAME : C_DELFLAG+C_NAME1 ARNAM2 : C_DELFLAG+C_NAME2
ARDIST : HOLDS PREVIOUS TRANSFERS No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 TRSBATCH N 3 0 BATCH NUMBER TRANSFERRED ON 2 TRSACT C 25 0 ACCOUNT NUMBER 3 TRSDES C 25 0 TRANSACTION DESCRIPTION 4 TRSREF C 12 0 REFERENCE NUMBER 5 TRSDATE D 8 0 TRANSACTION DATE 6 TRSAMT N 15 2 AMOUNT 7 TRSID C 1 0 0=SPECIAL,1=POSTING,2=REFERENCE 8 TRSMODU C 2 0 MODULE THAT GENERATED THIS POSTING 9 TRSCOMPID C 2 0 COMPANY ID THAT GENERATED THIS POSTING 10 TRSTYPE C 1 0 TRANSACTION TYPE (SEE BELOW) 11 TRSPD C 2 0 G/L PERIOD OF POSTING 12 TRSDELFLAG C 1 0 '*' IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 12 FIELDS = 97
ARFORM : ACCOUNTS RECEIVABLE STATEMENT FORMS FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 F_FORM C 2 0 FORM # 2 F_TYPE C 4 0 PLACE IN FORM (GENERAL) TOP, SCROLL, BOTT 3 F_ROW N 3 0 PLACE WHERE @ SAY IS RELA TO GENERAL 4 F_COL N 3 0 PLACE WHERE @ SAY IS SAIS HORIZONTAL 5 F_CONTENTS C 120 0 CONTENTS CODE-WISE 6 F_DESCRIP C 35 0 CONTENTS LAY MANS TERMS 7 F_DELFLAG C 1 0 "*" IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 7 FIELDS = 168 Related Indexes ARFORM : F_DELFLAG+F_FORM+F_TYPE+STR(F_ROW,3)+STR(F_COL,3) Additional Information F_CONTENTS FIELD: POSITION (1-8) .FXP FILE NAME TO PERFORM DURING INTITIALIZE (9-10) # OF INVOICE THAT CAN SHOW ON INVOICE (11-11) (Y,N) IF A LASER FORM (12-13) TOTAL LENGTH OF THE FORM (LINES) (14-15) WHERE THE SCROLLING INVOICES START (16-17) WHERE THE SCROLLING LINES END AND FOOTER SECTION START. (18-18) # OF LINES PER INVOICE
ARPEND : PENDING INVOICES ENTERED FROM REMOTE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 P_CUSTNO C 10 0 CLIENT NUMBER 2 P_SUB C 10 0 SUB CLIENT NUMBER 3 P_CREATED D 8 0 DATE OF THIS TRANSACTION 4 P_CODE C 6 0 SERVICE NUMBER 5 P_DESCR M 80 0 DESCRIPTION OF SERVICE 6 P_UNITPR N 12 4 UNIT PRICE CHARGED 7 P_QTY N 12 2 NUMBER OF UNITS (QUANTITY) 8 P_MISC0 C 20 0 MISC FIELD 0 (USER DEFINED) 9 P_NETSTAMP N 2 0 NETSTAMP 10 P_DELFLAG C 1 0 "*" IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 10 FIELDS = 161 Related Indexes ARPEND : P_DELFLAG+P_CUSTNO+P_SUB+DTOS(P_CREATED)+P_MISC0
ARPROJ : ACCOUNTS RECEIVABLE PROJECT FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 A_PROJNO C 6 0 PROJECT NUMBER 2 A_CUSTNO C 10 0 CLIENT NUMBER 3 A_SUB C 10 0 SUB CLIENT NUMBER 4 A_DESCR C 40 0 PROJECT DESCRIPTION 5 A_COMMID C 6 0 COMMENT CODE TO BE PRINTED ON STATEMENTS 6 A_NOTES M 0 0 PROJECT NOTES 7 A_NETSTAMP N 2 0 NETSTAMP 8 A_DELFLAG C 1 0 "*" IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 8 FIELDS = 75 Related Indexes ARPROJ : A_DELFLAG+A_CUSTNO+A_SUB+A_PROJNO
ARSYST : ACCOUNTS RECEIVABLE SYSTEM FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 S_F05 C 30 0 FUNCTION KEY F5 2 S_F06 C 30 0 FUNCTION KEY F6 3 S_F07 C 30 0 FUNCTION KEY F7 4 S_F08 C 30 0 FUNCTION KEY F8 5 S_F09 C 30 0 FUNCTION KEY F9 6 S_F10 C 30 0 FUNCTION KEY F10 7 S_F11 C 30 0 FUNCTION KEY F11 8 S_F12 C 30 0 FUNCTION KEY F12 9 S_NETSTAMP N 2 0 NETWORK SIGNATURE 10 S_GLLINK C 1 0 LINKED TO G/L 11 S_APLINK C 1 0 LINKED TO A/P 12 S_APCOMP C 2 0 LINKED TO AP COMPID 13 S_APVEND C 9 0 VENDOR CODE FOR CREDITS 14 S_CASHACCR C 1 0 'C'ASH - 'A'CCRUAL 15 S_INCPMTS C 1 0 'Y' IF ALL PAYMENTS IN BAL FORWARD. 16 S_INCADJU C 1 0 'Y' IF ALL ADJUSTMENTS IN BAL FORWARD 17 S_INCINT C 1 0 'Y' IF ALL INTEREST IN BAL FORWARD 18 S_AUTOCRED C 1 0 'N' TO SKIP AUTO APPLY CREDITS 19 S_EXACT C 1 0 'Y' POST CASH TO EXACT BILLS IF MATCHED 20 S_PERIOD N 2 0 PERIOD AR IS IN 21 S_YEAR N 4 0 CURRENT YEAR 22 S_GLCOMP C 2 0 GENERAL LEDGER ENTITY NUMBER 23 S_NEXTSEQ N 10 0 NEXT AVAILABLE TRANS. SEQUENCE NUMBER. 24 S_NEXTBILL N 8 0 NEXT BILL NUMBER 25 S_NEXTDEPO N 9 1 NEXT AVAILABLE DEPOSIT NUMBER 26 S_NEXTGL N 3 0 NEXT AVAILABLE GL TRANSFER BATCH NUMBER 27 S_VERSION C 4 0 NEMRC FAR.EXE VERSION NUMBER 28 S_OLDVER C 4 0 PREVIOUS INSTALLED VERSION OF THE MODULE 29 S_UPVER D 8 0 DATE THE NEW VERSION WAS INSTALLED 30 S_JANUARY N 2 0 JAN IS WHAT PERIOD FOR UPPER LEFT CORNER 31 S_STFORM C 2 0 STATEMENT FORM NUMBER 32 S_INVFORM C 2 0 INVOICE FORM # 33 S_ESTFORM C 2 0 ESTIMATE FORM 34 S_CASH C 25 0 GL CASH ACCOUNT 35 S_AR C 25 0 GL ACCOUNTS RECEIVABLE 36 S_FINAR C 25 0 GL FINANCE CHARGES RECEIVABLE 37 S_BADDEBT C 25 0 GL WRITE OFF OF BAD DEBTS ACCOUNT 38 S_REV C 25 0 GL REVENUE ACCOUNT 39 S_FINREV C 25 0 GL FINANCE CHARGE REVENUE ACCOUNT 40 S_DUETO C 25 0 GL DUE TO 41 S_DUEFROM C 25 0 GL DUE FROM 42 S_CREDITS C 25 0 DUE TO CUSTOMERS (CREDITS) 43 S_LASTINT D 8 0 DATE INTEREST LAST CALC'D ON 44 S_TAXABLE1 C 1 0 'Y'ES IF THERE IS A FIRST TAX RATE 45 S_TAXABLE2 C 1 0 'Y'ES IF THERE IS A SECOND TAX RATE 46 S_TAXABLE3 C 1 0 'Y'ES IF THERE IS A THIRD TAX RATE 47 S_COMMID C 6 0 SYSTEM WIDE COMMENT 48 S_MISC0 C 10 0 MISC DESCRIPTION 49 S_MISC1 C 10 0 MISC DESCRIPTION 1 50 S_MISC2 C 10 0 MISC DESCRIPTION 2 51 S_MISC3 C 10 0 MISC DESCRIPTION 3 52 S_MISC4 C 10 0 MISC DESCRIPTION 4 53 S_CMISC0 C 10 0 MISC CUST DESCRIPTION 54 S_CMISC1 C 10 0 MISC CUST DESCRIPTION 1 55 S_CMISC2 C 10 0 MISC CUST DESCRIPTION 2 56 S_CMISC3 C 10 0 MISC CUST DESCRIPTION 3 57 S_CMISC4 C 10 0 MISC CUST DESCRIPTION 4 58 S_CMISC5 C 10 0 MISC CUST DESCRIPTION 5 59 S_CMISC6 C 10 0 MISC CUST DESCRIPTION 6 60 S_CMISC7 C 10 0 MISC CUST DESCRIPTION 7 61 S_CMISC8 C 10 0 MISC CUST DESCRIPTION 8 62 S_CMISC9 C 10 0 MISC CUST DESCRIPTION 9 63 S_CUSTLEN N 2 0 CUSTOMER NUMBER LENGTH 64 S_SUBLEN N 2 0 CUSTOMER NUMBER SUB LENGTH 65 S_DUEADD N 3 0 DAYS PAST PRINTED DATE FOR DUE DATE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 65 FIELDS = 722
ARTRAX : ACCOUNTS RECEIVABLE TRAX FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 T_SEQNO N 10 0 UNIQUE SERVICE NUMBER (SYSTEM ASSIGNED) 2 T_CUSTNO C 10 0 CLIENT NUMBER 3 T_SUB C 10 0 SUB CLIENT NUMBER 4 T_PROJNO C 6 0 CASE NUMBER 5 T_CREATED D 8 0 DATE OF THIS TRANSACTION 6 T_DUEDATE D 8 0 DUE DATE OF INVOICE 7 T_TIME C 8 0 TIME OF TRANSACTION 8 T_CODE C 6 0 SERVICE NUMBER 9 T_DEPOSIT N 9 1 DEPOSIT NUMBER 10 T_CHECKNO C 8 0 CHECK NUMBER IF ANY 11 T_DESCR M 80 0 DESCRIPTION OF SERVICE 12 T_UNITPR N 12 4 UNIT PRICE CHARGED 13 T_QTY N 12 2 NUMBER OF UNITS (QUANTITY) 14 T_AMOUNT N 12 4 T_QTY * T_UNITPR 15 T_GL_BATCH C 3 0 TRANSFERRED TO G/L ON BATCH NUMBER 16 T_PRINTED D 8 0 DATE TRANSACTION WAS PRINTED 17 T_PRTSTATE C 1 0 Y IF NOT INCLUDED IN NEXT BALANCE FWD 18 T_IS_ESTIM C 1 0 Y IF ESTIMATE. ESTIMATES CANNOT TRANSFER. 19 T_TYPE C 3 0 TRANSACTION TYPE (SEE BELOW) 20 T_MISC C 30 0 SYSTEM USED COMMENTS 21 T_MISC0 C 20 0 MISC FIELD 0 (USER DEFINED) 22 T_MISC1 C 20 0 MISC FIELD (USER DEFINED) 1 23 T_MISC2 C 20 0 MISC FIELD (USER DEFINED) 2 24 T_MISC3 C 20 0 MISC FIELD (USER DEFINED) 3 25 T_MISC4 C 20 0 MISC FIELD (USER DEFINED) 4 26 T_NETSTAMP N 2 0 NETSTAMP 27 T_DELFLAG C 1 0 "*" IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 27 FIELDS = 348 Related Indexes ARTRAX : T_DELFLAG+T_CUSTNO+T_SUB+T_PROJNO ARSEQN : T_DELFLAG+STR(T_SEQNO,10,0)+T_CODE ARPOST : T_DELFLAG+T_GL_BATCH ARDATE : T_DELFLAG+IIF(EMPT(T_PRINTED),'0','1') +T_CUSTNO+T_SUB+STR(T_SEQNO,10)+ ARDEPO : T_DELFLAG+STR(T_DEPOSIT,9,1) ARSERV : T_DELFLAG+T_CODE+T_CUSTNO+T_SUB+STR(T_SEQNO,10) Additional Information T_TYPE: 'B'ill, 'P'ayment, 'A'djustment or 'W'rite off A transaction has hit the customer file if. It has deposit number, is an adjustment, or has a printed date. Transactions which do not affect the customer balance are bills that have not been printed or interest changes that have not been printed.
ARX2AP : TRANSFER TO AP FILE 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
ARX2GL : TRANSFER TO GL 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 '*' IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 11 FIELDS = 94
