Accounts Receivable – Lawson AR tables and programs

Accounts Receivable (AR) in Lawson S3 v10 MSP6 has 102 tables, 55 online screens and 21 batch programs.

Tables (102)

TablePrefixDescriptionPrimary keyFields
AGEUSERONEAUONo description in the Lawson data dictionaryCOMPANY, CUSTOMER, TRANS-USER18
AGINGCODEAGEAccounts Receivable Aging CodeCOMPANY, AGING-CODE11
ARACMUFCUFThe Customer User Fields file contains extra user fields that can be entered for a customer.COMPANY, CUSTOMER7
ARACPIVOTCCPAcct Receivables Payment TransCOMPANY, TRANS-TYPE, BATCH-NBR, TRANSACTION, PAYMENT-SEQ46
ARADJUSTADJAcct Receivables App AdjsmntCOMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ, ADJ-SEQ30
ARAPHUFBUFThe Payment Batch User Fields file contains user fields that can be entered on Payment Batches.COMPANY, BATCH-NBR7
ARAPMUFPUFThe Payment User Fields file contains user fields that can be entered on Payments.COMPANY, BATCH-NBR, PAYMENT-SEQ8
ARAPPLDBODYBKNo description in the Lawson data dictionaryCOMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ12
ARAPPLIEDARAAcct Receivables ApplicationCOMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ40
ARAPSELECTAAINo description in the Lawson data dictionaryCOMPANY, BATCH-NBR, TRANS-TYPE, INVOICE, PAYMENT-SEQ17
ARARHUFTUFThe Transaction Header User Fields file contains user fields that can be entered on Transaction Headers.COMPANY, TRANS-TYPE, INVOICE8
ARAUDITDITNo description in the Lawson data dictionaryCUST-GROUP, COMPANY, DATE, CUSTOMER, TIME, SEQ-NBR13
ARCATEGORYACAAccounts Receivable CategoryCOMPANY, AR-CATEGORY12
ARCCUSTARUAR Customer ConversionCOMPANY, CUSTOMER174
ARCCUST2AR2No description in the Lawson data dictionaryCOMPANY, CUSTOMER3
ARCDSELECTSELAR Credit SelectsCOMPANY, CREDIT-ANLYST, DATE, SYS-TIME, CUSTOMER, SELECT-LEVEL13
ARCHGBAKTXAKTText for Chargeback PrintCOMPANY, TEXT-CODE, LANGUAGE-CODE7
ARCODERCDAR GL CodeCOMPANY, AR-CODE8
ARCOMMENTCMTCustomer CommentsCOMPANY, CUSTOMER, SEQ-NUMBER11
ARCOMPACOAccounts Receivable CompanyCOMPANY124
ARCOMPAUDRAUAR Company AuditCOMPANY, UNIQUE-I-D13
ARCONTACTSCONAR Customer ContactsCOMPANY, CUSTOMER, RESP-CODE11
ARCSTMXVALCTVThis file contains an attribute value for a customer.OBJ-ID, MATRIX-CAT3
ARCUSTBODYBMNo description in the Lawson data dictionaryCOMPANY, CUSTOMER8
ARCUSTFLDSACFAR Customer User FieldsCOMPANY, CUSTOMER12
ARCUSTGRPACGAccounts Receivable Cust GroupCUST-GROUP29
ARCUSTOMERACMAR Company CustomerCOMPANY, CUSTOMER152
ARCUSTPERARPAR Customer Period TotalsCOMPANY, CUSTOMER, YEAR10
ARCUSTTOTSCUTAR Customer PL InclusionsCOMPANY, CUSTOMER, PROCESS-LEVEL4
ARCYCLEACYAccounts Receivable Cycle CodeCOMPANY, CYCLE-TYPE, CYCLE5
ARDICTARYNo description in the Lawson data dictionaryDB-FILE-PFX, FLD-NBR5
ARDISPUTEADPAR Disputed TransactionsCOMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, SEQ15
ARDISTRIBAMDAR DistributionsGL-COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCT, GL-DATE, CREATE-DATE, CREATE-TIME, PROG-SEQ-NBR54
ARDUNCODEDUCDunning Process CodeDUN-PROCESS-CD2
ARDUNLTRDULNo description in the Lawson data dictionaryDUN-PROCESS-CD, DUN-LEVEL9
ARDUNNINGDNNAR Dunning LettersCOMPANY, DUNNING-NBR, LANGUAGE-CODE5
ARDUNTXTCDATXDunning Text CodesDUN-TEXT-CODE, LANGUAGE-CODE3
ARFINANCEARFFinance Charge Rate CodeFIN-CHRG-CD4
ARFINRATEAFIFinance Charge RatesFIN-CHRG-CD, EFF-DATE3
ARIBILLTOAIBNo description in the Lawson data dictionaryCUST-GROUP, CUSTOMER, BILL-TO16
ARICOMMENTAIMComment Conversion/InterfaceCOMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, SEQ-NBR12
ARICSTCUSAR Interface CustomerCOMPANY, CUSTOMER, ACTION-CD240
ARICUSTPERAIECustomer Period ConversionCOMPANY, CUSTOMER, YEAR10
ARIDISTRIBAIDDistribution Convert/InterfaceCOMPANY, TRANS-TYPE, INVOICE, PROG-SEQ-NBR22
ARIEFTAIFNo description in the Lawson data dictionaryCOMPANY, CUSTOMER21
ARIITEMARILine Item Detail InterfaceCOMPANY, TRANS-TYPE, INVOICE, SEQUENCE24
ARIMICRIMIMICR Customer Xref ConversionCOMPANY, BANK-ENTITY, BANK-ACCT-NBR, CUSTOMER6
ARIOECUSTAOECustomer Order Processing ConvCOMPANY, CUSTOMER40
ARISGBLKAISNo description in the Lawson data dictionaryCOMPANY, TRANS-TYPE, INVOICE, PROG-SEQ-NBR5
ARITEMAIRLine Item DetailCOMPANY, TRANS-TYPE, INVOICE, SEQUENCE16
ARITEMAUDARZOpen Item AuditCOMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ11
ARITRANSAITAR Interface TransactionCOMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ78
ARLOCKBOXARLLock Box LocationLOCK-BOX18
ARMAPARMThis file contains the User Sort defintions used for sorting purposes in cash application and credit management inquiry.INDEX-NBR7
ARMICRCUSTAMXAR MICR Customer Cross RefCOMPANY, BANK-ENTITY, BANK-ACCT-NBR6
AROIHDRARHAcct Receivables Trans HeaderCOMPANY, TRANS-TYPE, INVOICE83
AROITEMSAROAcct Receivables TransactionCOMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ95
AROPIVOTPVTNational Account TransNAT-COMPANY, NAT-CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, COMPANY, CUSTOMER40
AROPTRAOPAccounts Receivable OperatorCOMPANY, OPR-CODE5
ARPAYMENTAPMAcct Receivables PaymentCOMPANY, BATCH-NBR, PAYMENT-SEQ53
ARPAYNOTTXANTThis file contains language specific text for finance charge late payment printing purposes.COMPANY, TEXT-CODE, LANGUAGE-CODE8
ARPRLAUDRPAAR Process Level AuditCOMPANY, PROCESS-LEVEL, UNIQUE-I-D13
ARPROCLEVLAPVAccounts Receivable Proc LevelCOMPANY, PROCESS-LEVEL28
ARPYMNTHDRAPHAcct Receivables Payment BatchCOMPANY, BATCH-NBR43
ARREASONARRAccounts Receivable Reason CdCOMPANY, TYPE, REASON-CODE26
ARREMITRMIPayment RemittanceCOMPANY, BATCH-NBR, PAYMENT-SEQ, REMIT-SEQ8
ARRTMTXRTXThis file contains language specific text for retun to maker form printing purposes.COMPANY, TEXT-CODE, LANGUAGE-CODE7
ARSADJUSTASJCash Application Adjust SelectCOMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, ADJ-SEQ24
ARSAPPLIEDASGCash Application SelectCR-COMPANY, CR-BATCH, CR-PYMNT-SEQ, COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ15
ARSTMPRTTXASXText for Print StatementCOMPANY, TEXT-CODE, LANGUAGE-CODE8
ARSUMMARYARSTransaction ActivityCOMPANY, PROCESS-LEVEL, TYPE7
ARUDISTRIBDGMNo description in the Lawson data dictionaryCOMPANY, BATCH-NBR, TRANS-TYPE, INVOICE, CUSTOMER, DIST-SEQ8
ARUOIHDRUIHNo description in the Lawson data dictionaryCOMPANY, TRANS-TYPE, INVOICE4
ARUPMNTHDRUPHNo description in the Lawson data dictionaryCOMPANY, BATCH-NBR3
ARUSERSORTUSSThis table contains user sort data entered from AR42 Transaction Entry.COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ8
ARUSRFLDEFADUThe User Field Definition file defines field types and data types for customer, payment, payment header, and trasaction…USER-FLD-TYPE, COMPANY7
ARXINDARXNo description in the Lawson data dictionaryCOMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBR10
BALFWDTOTBFTAR Balance Forward Cust TotalsCOMPANY, CUSTOMER, CURRENCY-CD6
BILLTOABSBill ToCUST-GROUP, CUSTOMER, BILL-TO18
BILLTOBODYCKNo description in the Lawson data dictionaryCUST-GROUP, CUSTOMER, BILL-TO9
BLINVHDRBLHAR Transaction BatchCOMPANY, BATCH-NBR20
CONBODYCNNo description in the Lawson data dictionaryCOMPANY, CUSTOMER, RESP-CODE9
CRANALYSTCANAR Credit AnalystsCOMPANY, CREDIT-ANLYST6
CUSTDEFLTSCDFAR Customer DefaultsCOMPANY, DEFAULT-CODE95
CUSTDESCCUDAR Group CustomerCUST-GROUP, CUSTOMER37
DISPCODESDCDAR Dispute CodesCOMPANY, DISPUTE-CD4
FTCUSTGRPFTGEFT Customer GroupCUST-GROUP, COMPANY, CR-CUSTOMER, CUSTOMER4
FTCUSTNOTEFTNEFT Customer NotificationCUST-GROUP, COMPANY, CUSTOMER9
FTTRANSFTTEFT TransactionCUST-GROUP, CR-COMPANY, COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, EFT-TYPE, EFT-SEQ19
HOLDCODESHDDAR Hold CodeCUST-GROUP, HOLD-CODE9
MAJCUSTCLMJCMajor Customer ClassMAJOR-CLASS4
MINCUSTCLMNCMinor Customer ClassMAJOR-CLASS, MINOR-CLASS4
NATACCTNACAccounts Receivable Natl AcctNAT-COMPANY, NAT-CUSTOMER, COMPANY, CUSTOMER5
NATBALANCENABAR National Account BalanceNAT-COMPANY, NAT-CUSTOMER24
OECUSTOETCustomer Order ProcessingCOMPANY, CUSTOMER59
OEICUSTAEICust Order Process InterfaceCOMPANY, CUSTOMER59
PLGRPDTLPGDAR Process Level Report DetailCOMPANY, PL-GROUP, PROCESS-LEVEL3
PLGRPHDRPGHAR Process Level Report HeaderCOMPANY, PL-GROUP3
PROCLVLGRPPLGAR Process Level Report GroupCOMPANY, RPT-GROUP, SEQ-NBR, PL-GROUP4
SALESREPSAWAccounts Receivables Sales RepCOMPANY, SALESMAN7
STATICCUSTSTAAR Ovrd Credit Trans ReviewCOMPANY, CUSTOMER5
TERITORYTRYAR TerritoriesCOMPANY, TERRITORY5

Online screens (55)

ScreenDescriptionUpdatesReferences
AR00.1Customer Group12
AR00.2EFT Calendar01
AR01.1Company1939
AR01.3User Sort Fields13
AR02.1Process Level513
AR03.1Process Level Group23
AR03.2Process Level Report Group13
AR04.1Cycle Codes13
AR05.1Customer Class20
AR06.1Credit Analyst22
AR06.2Territory11
AR06.3Sales Representative21
AR06.4Operator11
AR07.1Finance Charge12
AR07.2Finance Charge Rates11
AR08.1Customer Defaults1429
AR08.2Billing Customer Fields01
AR09.1Customer Group Address2433
AR09.2Banks14
AR09.4Bill To325
AR09.5EFT Notification14
AR09.7EFT Customers15
AR09.8Net Balance05
AR10.1Customer3655
AR10.2Customer Process Level Inclusion23
AR10.3Billing01
AR10.5Customer Electronic Payments23
AR11.1Customer Contacts122
AR12.1National Account825
AR12.2National Account Speed Entry725
AR13.1MICR Customer924
AR13.2Customer MICR924
AR14.1Lockbox57
AR15.1Adjustment Reasons11
AR15.2Expanded Reasons04
AR15.3Memo Reasons11
AR15.4Category58
AR15.5Dispute11
AR15.6Operator11
AR15.7GL Code12
AR15.8Aging Code11
AR16.1Hold Code11
AR17.1Comments77
AR18.1Dunning Text11
AR18.2Dunning Levels12
AR18.3Dunning Processing Code Maintenance11
AR23.1Customer Attributes311
AR23.2Values By Customer Attributes36
AR23.3Customer View Preview28
AR23.4Manual Customer List34
AR23.5Copy List30
AR98.1Conversion Customer31
AR98.2Conversion Customer Period10
AR98.3Conversion Customer Order Entry10
ARLL.1AR Transaction Interface5075

Batch programs (21)

ProgramDescriptionUpdatesReferences
AR200Customer Group Listing13
AR201Company Process Level Listing14
AR203Report Group Listing16
AR204Cycle Listing13
AR205Customer Class Listing13
AR206Operational Setup 1 Listing15
AR207Finance Charge Listing12
AR208Customer Defaults Listing13
AR209Customer Labels Print13
AR210Customer Listing433
AR211Customer Optional Fields Listing312
AR212National Account Listing14
AR213MICR Customer Listing14
AR214Lockbox Listing13
AR215Operational Setup 2 Listing18
AR216Hold Listing13
AR217Comments Listing312
AR218Dunning Text Listing13
AR301Customer Purge3230
AR501Customer Conversion3747
AR550Customer Interface3248

Other tables used by Accounts Receivable programs (104)

ACACCTCAT, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE, ACASSIGN, ACCAL, ACCALX, ACCATMXVAL, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCNTRACTX, ACCOMMIT, ACCOMMITX, ACCUSTOMER, ACGRPMXVAL, ACROLE, ADDRDATA, APACCRCODE, APCOMPANY, APVENBAL, APVENCLASS, APVENGROUP, APVENMAST, ARDRAFTS, C2AUTOGIRO, CBBANKENT, CBBANKINST, CBCASHCODE, CBCPYCASH, CBUSER, CBUSRCLASS, CUACCT, CUCODES, CUCONV, CURELAT, CUSTEP, CUSTORDER, DTCUSTBANK, EPTRANS, EPTYPE, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBTRANS, FBYETR, FOBCODE, FROPTIONS, GLADDRESS, GLCGCPY, GLCHART, GLCODES, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLNAMES, GLSYSTEM, GMAWARD, ICLOCATION, INFERCONCD, INSTATPROC, INSTCTRYCD, INSTNOTC, INSTPORTS, INSTREGN, JBKOPCODE, JBKSYSCODE, JBOOKHDR, MXCATDEF, MXELEMENT, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXOBJCAT, MXTMPLDTL, MXTMPLHDR, MXVALIDATE, OECOMPANY, OECOMPREF, OECUSTCODE, OEFRTCODE, OEINVOICE, OEMETHOD, OEORDDISC, OEPRCLIST, POCOMPANY, PWICUST, SHIPTO, STRUCTURE, SUBCKPOINT, SYSTEMCODE, TERMS, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, TXTAXTRAN, WFSETUP