AC Billing Revenue – Lawson BR tables and programs

AC Billing Revenue (BR) in Lawson S3 v10 MSP6 has 78 tables, 119 online screens and 63 batch programs.

Tables (78)

TablePrefixDescriptionPrimary keyFields
ACADDLCNTRADNAdditional Contract InfoACTIVITY-GRP, CONTRACT34
ACBILLACIActivity BillingACTIVITY15
ACBILLTOABLActivity Bill ToCOMPANY, CUSTOMER, BILL-TO-GRP4
ACBILLTOXABOActivity Bill To DetailCOMPANY, CUSTOMER, BILL-TO-GRP, BILL-TO5
ACBILLXAIXActivity Billing DetailACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY19
ACBLMASTBMHActivity Billing BalancesBILL-ACTIVITY, BILL-WBS-CODE, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, MATRIX-CAT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, MX-VALUE, FEE-TAX-CODE, LINE-TYPE16
ACBLRATEALRActivity Billing Rates HeaderACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SOURCE-CODE, MATRIX-CAT, EFFECTIVE-DT9
ACBLRATEXALXActivity Billing Rates DetailACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SOURCE-CODE, MATRIX-CAT, EFFECTIVE-DT, MX-VALUE10
ACBRDNBLRXBRXActivity Brdn Billing Rate DtlACTIVITY, BURDEN-CD, BURDEN-TYPE, POOL-NBR, EFFECTIVE-DATE7
ACCEILINGCEHActivity CeilingACTIVITY, ACCT-CATEGORY, SUM-ACCT-CAT, CTR-CAT-GRP, MATRIX-CAT5
ACCEILINGXCEXActivity Ceiling DetailACTIVITY, ACCT-CATEGORY, SUM-ACCT-CAT, CTR-CAT-GRP, MATRIX-CAT, MX-VALUE16
ACCLGTRANSCGTCeiling Level TransactionsATN-OBJ-ID, LEVEL6
ACCNTADXCMAThe contract attribute modification file contains the contract modification information for attributes from Contract…CONTRACT, MOD-NBR, MATRIX-CAT5
ACCNTMODCMDActivity Comment TypeCONTRACT, MOD-NBR58
ACCNTRACCTCNAActivity Contract AccountsCONTRACT, ACCT-CATEGORY14
ACCNTRACTCNTActivity ContractCONTRACT63
ACCNTRACTXCNXActivity Contract DetailCONTRACT, ACTIVITY4
ACCNTRCATCNCActivity Contract CategoryCONTRACT, ACTIVITY, ACCT-CATEGORY5
ACCNTRCMTXCXMNo description in the Lawson data dictionaryCONTRACT, MAINT-SCHEDULE, OBJ-ID, COMMENT-TYPE, SEQ-NBR12
ACCNTRPCDCNPNo description in the Lawson data dictionaryCONTRACT2
ACCNTRSTATCSBActivity Contract StatusCONT-STATUS2
ACCNTRWBSCWBActivity Contract WBSCONTRACT, BILL-WBS-CODE3
ACCONTACTSCTSContract Customer ContactsACTIVITY-GRP, CONTRACT, RESP-CODE21
ACCTRCATGBCGContract Category GroupCTR-CAT-GRP, CONTRACT3
ACCTRCATGXBCXContract Category Group DtlCONTRACT, ACCT-CATEGORY3
ACCUSTDTLCMBNo description in the Lawson data dictionaryCOMPANY, CUSTOMER3
ACCUSTOMERCMRActivity CustomerCOMPANY, CUSTOMER, AC-CUSTOMER-ID31
ACDEFREVDRDActivity Deferred RevenueCONTRACT, OBJ-ID, SEQ-NBR11
ACFEEBALFBLThe fee balance file stores cumulative costs, fee and overage which will be used in calculating the billing and revenue…CONTRACT, ACTIVITY, TYPE, FEE-CD, COMPANY, ACCT-UNIT14
ACFEECDFCDActivity Management Fee CodeFEE-CD5
ACFEEDTLFDTActivity Management Fee DetailCONTRACT29
ACGLTOTREVGRVActivity Total Revenue AmountACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT6
ACHISTCLGHCTBilling OverageOBJ-ID, LINE-NBR, ATN-OBJ-ID, LEVEL7
ACHISTCNSLIHCBilling ConsolidationOBJ-ID, LINE-NBR30
ACHISTDTLHDTInvoice DetailOBJ-ID, LINE-NBR68
ACHISTGMIHGInvoice GMHIH-OBJ-ID, CONTRACT-ACTVY, RECORD-TYPE, ACTIVITY6
ACHISTHDRHIHInvoice HeaderOBJ-ID59
ACHISTTAXHITInvoice Tax DetailOBJ-ID, HDT-LINE-NBR, SEQ-NBR8
ACIFCNTCMTAFCNo description in the Lawson data dictionaryCONTRACT, COMMENT-TYPE, SEQ-NBR5
ACIFPRDTLAFDNo description in the Lawson data dictionaryCONTRACT, PRODUCT, PROD-VERSION, LINE-NBR37
ACIFPRHDRAFPNo description in the Lawson data dictionaryRUN-GROUP, CONTRACT27
ACINVAUDITIVANo description in the Lawson data dictionaryOBJ-ID, LINE-NBR, TRANS-DATE, SEQUENCE-NBR13
ACINVORDAIONo description in the Lawson data dictionaryHIH-OBJ-ID, CONTRACT2
ACJOURNLCDJCDActivity Journal CodeJOURNAL-CODE6
ACJURCODEJURActivity Juris CodeJURIS-CODE3
ACMILESTNMLSActivity MilestonesACTIVITY, MILESTONE-CAT6
ACMILESTNXMLXActivity Milestones DetailACTIVITY, MILESTONE-CAT, MILESTONE11
ACMNTHDRMSEActivity Maintenance HeaderCONTRACT, MAINT-SCHEDULE13
ACMNTSCHMSCActivity Maintenance ScheduleCONTRACT, MAINT-SCHEDULE, OBJ-ID43
ACMNTSCHXMSDActivity Maintenance Sched DtlCONTRACT, MAINT-SCHEDULE, OBJ-ID, TRAN-DATE11
ACPMHSTCSLPMCNo description in the Lawson data dictionaryOBJ-ID, LINE-NBR30
ACPMHSTDTLPMLNo description in the Lawson data dictionaryOBJ-ID, LINE-NBR66
ACPMHSTHDRPMHNo description in the Lawson data dictionaryOBJ-ID58
ACPMHSTTAXPHTNo description in the Lawson data dictionaryOBJ-ID, PML-LINE-NBR, SEQ-NBR8
ACPRMSTNPMSNo description in the Lawson data dictionaryACTIVITY, MILESTONE-CAT6
ACPRMSTNXPMXNo description in the Lawson data dictionaryACTIVITY, MILESTONE-CAT, MILESTONE15
ACPROADJBRJNo description in the Lawson data dictionaryHIH-OBJ-ID, LINE-NBR-MAP, ADJ-LEVEL, REASON-CODE21
ACPRODACCTBRRActivity Product AccountPRODUCT-LIST, PRODUCT, RECORD-TYPE23
ACPRODDTLAHDActivity Product DetailCONTRACT, OBJ-ID53
ACPRODHDRAHRActivity Product HeaderCONTRACT38
ACPRODINVPDIProduct Invoice CancellationCONTRACT, OBJ-ID2
ACPRODLSTBRPActivity Product ListPRODUCT-LIST3
ACPRODLSTXBRQNo description in the Lawson data dictionaryPRODUCT-LIST, PRODUCT, PROD-VERSION9
ACPRODTAXBTXNo description in the Lawson data dictionaryTAX-ACCT-CAT, DELIV-METHOD, EFFECTIVE-DATE4
ACPRODUSERBRUNo description in the Lawson data dictionaryRECORD-TYPE, PRODUCT-LIST, PRODUCT, PROD-VERSION, EFFECTIVE-DT, MAX-USERS12
ACPROFORMAATINo description in the Lawson data dictionaryINVOICE-TYPE, CONTRACT, DUE-DATE, MAINT-SCHEDULE7
ACREASONCDCDENo description in the Lawson data dictionaryREASON-CODE2
ACRETAINRETNo description in the Lawson data dictionaryACTIVITY, RETAIN-ID12
ACRETAINXREXNo description in the Lawson data dictionaryACTIVITY, RETAIN-ID, RETAIN-CODE7
ACRETNGRTGActivity Bill RetentionACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY13
ACRETNGXRGXActivity Bill Retention DetailACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SEQ-NBR17
ACSRVCLOCASVThis file maintains a service location for tax purposes.COMPANY, CUSTOMER, SERVICE-LOC17
ACTEMPACCTBRBActivity Account TemplateTEMPLATE, ACCT-CATEGORY13
ACTEMPCNTBRAActivity Contract TemplateTEMPLATE38
ACTRANSERRTERNo description in the Lawson data dictionaryOBJ-ID9
ACWBSCODEWBSNo description in the Lawson data dictionaryBILL-WBS-CODE3
BRCUSTAUCSABR Activity Customer AuditCOMPANY, CUSTOMER, AC-CUSTOMER-ID, UNIQUE-I-D13
BRPURGEBRLNo description in the Lawson data dictionaryFILE-NAME5

Online screens (119)

ScreenDescriptionUpdatesReferences
BR00.1Activity Billing1642
BR00.2Billing Detail1241
BR00.3Ceiling Levels415
BR00.4Additional Information13
BR01.1Retention and Unbilled411
BR01.2Bill Retention413
BR02.1Retainer Parameters39
BR02.2Retainer Detail36
BR02.3Retainer Invoice Entry1966
BR03.1Billing Category Rates416
BR03.2Units of Production Rates412
BR03.3Cost Plus Billing Labor Category Assignment415
BR04.1Burden Bill Rates28
BR05.1Milestones09
BR05.2Days Milestones310
BR05.3Date Milestones310
BR05.4Percent Complete Milestones310
BR05.5Manual Milestones310
BR06.1Invoice Groups11
BR07.1Invoice Group Numbering12
BR08.1Reason Codes10
BR09.1Jurisdiction Codes12
BR09.2Jurisdiction Code Numbering10
BR10.1Contract Parameters2350
BR10.2Contract Detail710
BR10.3Contract Accounts57
BR10.4Additional Contract Information78
BR10.5Contract Modification63
BR10.7Contract Attribute Modifications56
BR10.8Contract Modification Approval73
BR10.9Product Contract Parameters1127
BR11.1Customer1039
BR12.1Journal Codes14
BR12.2Contract Account Category Detail27
BR13.1Additional Contract Information25
BR14.1Customer Contacts15
BR15.1Fee Code Setup13
BR15.2Fee Code Assignment26
BR16.1Service Location728
BR16.2Customer Maintenance Renew Date319
BR17.1Bill To Group522
BR18.1Contract Category Group26
BR18.2Contract Category Group Mass Addition27
BR18.3Contract Category Group Copy22
BR19.1Single Invoice Calculation740
BR19.2Filter324
BR19.3Invoice Calculation Override01
BR20.1Invoice Edit Contract3061
BR20.2Invoice Edit Line3061
BR20.3Invoice Edit Activity3061
BR20.4Invoice Edit Activity and Account Category3061
BR20.5Invoice Edit Transaction3062
BR20.6Invoice Edit Detail537
BR20.7Invoice Header427
BR20.9Filter322
BR21.1Invoice Cancellation823
BR21.2Filter221
BR22.1Contract Change Orders73
BR30.1Contract Status11
BR31.1Product Contract Comments13
BR31.2Product Detail Comments15
BR31.3Maintenance Schedule Comments13
BR31.4Maintenance Product Comments16
BR40.1Revenue Billing Adjustment08
BR40.3Transfer232
BR40.4Write Up, Down214
BR41.1Contract Adjustment (AC only)627
BR41.4Contract Adjustment (AC and GL)838
BR42.1Transaction Hold56
BR42.2Filter04
BR43.1Revenue Adjustment546
BR44.1Mass Transaction Transfer1793
BR45.1Invoice Control927
BR46.1Bill in Advance2465
BR46.2Transfer Invoice Transaction2450
BR46.3Filter17
BR46.4Split Transfer2450
BR47.1Contract Template28
BR47.2Contract Account Template12
BR48.1Customer Template720
BR49.1Invoice Adjustment Maintenance822
BR50.1Product List Maintenance23
BR50.2Product List Accounts14
BR50.3Define Product List45
BR50.4Product Cost Detail12
BR50.5Product Price Detail12
BR51.1Product Contract1543
BR51.2Product Cost of Goods Sold535
BR52.1Maintenance Schedule736
BR52.2New Maintenance Schedule530
BR52.3Product Maintenance Revenue Schedule14
BR52.4Renew All416
BR52.5Product Maintenance Renewal417
BR52.7Schedule Totals03
BR53.1Product Deferred Revenue Schedule421
BR53.2Product Deferred Revenue Auto Scheduler33
BR54.1Product Billing Milestones08
BR54.2Days Product Billing Milestones412
BR54.3Date Product Billing Milestones412
BR54.4Manual Product Billing Milestones412
BR55.1Maintenance Invoice Cancellation614
BR55.2Filter221
BR56.1Product Invoice Cancellation68
BR58.1Product Tax Relationships11
BR65.1Percent Complete by Contract119
BR65.2Percent Complete by Activity117
BR65.3Percent Complete by Account Category216
BR70.1Product Contract Interface Adjustment639
BR70.2Product Interface Cost of Goods Sold333
BR71.1Product Contract Interface Comments13
BR88.1Customer Audit Analysis03
BR88.2Audit Analysis Filter01
BR90.1Contract Modification Inquiry05
BR90.2Filter01
BR91.1Contract By Customer Inquiry221
BR96.1Transaction Analysis - Billable Amounts117
BRBD.1BR BOD Maintenance50
BRBD.2BR BOD Inquiry010
BRIP.1Invoice Print Program4459

Batch programs (63)

ProgramDescriptionUpdatesReferences
BR120Invoice Calculation3079
BR121Invoice Print and Interface2583
BR122Online batch invoice process3359
BR123Product Invoice Cancel2467
BR124Deferred Revenue Adjustment924
BR130Revenue Calculation2147
BR131Revenue Realization1745
BR132This program has been retired.10
BR133This program has been retired.10
BR134This program has been retired.10
BR140Billing and Revenue Backout4283
BR142Mass Transaction Hold529
BR145Invoice Control Maintenance635
BR151Product Invoicing2583
BR152Maintenance Invoicing2582
BR153Product Revenue Calculation1442
BR154Maintenance Revenue Calculation1342
BR155Maintenance Schedule Copy952
BR156Maintenance Quote2480
BR157Maintenance Cancel1040
BR165Percent Complete Calculation939
BR180Location Vertex Geocode Update623
BR190Billing and Revenue Recalculation842
BR200Billing Listing430
BR202Retainer Listing429
BR203Billing Rate Listing13
BR204Burden Billing Rate Listing431
BR205Milestone Listing430
BR206Invoice Group Listing18
BR208Reason Code Listing11
BR209Jurisdiction Code Listing11
BR210Contract Listing548
BR211Activity Customer Listing327
BR212Contract Modification Listing429
BR215Fee Code Listing431
BR216Service Location Listing321
BR217Bill To Group Listing323
BR218Contract Category Grp Listing14
BR220Invoice Audit Listing648
BR230Contract Status Listing11
BR245Invoice Control Listing536
BR247Contract Template Listing12
BR250Product List Listing14
BR251Product Contract Listing550
BR252Maintenance Schedule Listing862
BR253Deferred Revenue Listing548
BR254Product Milestone Listing425
BR265Percent of Completion Report430
BR288Contract Audit Analysis Report13
BR300Invoice Purge1739
BR305Contract Audit Analysis Purge22
BR400Invoice History648
BR405Milestone Analysis430
BR420Billing Invoice Report1767
BR422Contract Change Order History Report529
BR430Revenue History436
BR450Activity Aging860
BR515Fee Code Recalculation313
BR516Fee Code Rebuild313
BR521Billing Import2976
BR530Revenue Import2146
BR570Product Contract Interface924
BR580Applied Balance Rebuild1428

Other tables used by AC Billing Revenue programs (205)

ACACCTBOD, ACACCTCAT, ACACCTCATX, ACACRESRT, ACACRESRTX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACACTSEG, ACAMCODE, ACASNROLE, ACASSIGN, ACBRDNBLRT, ACBRDNDTL, ACBRDNHDR, ACBRDNPOOL, ACBRDNPRRT, ACBRDNTYPE, ACBUDDTL, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATMXVAL, ACCATSUM, ACCATSUMX, ACCHGORDER, ACCHGORDX, ACCMTTYPE, ACCNTBOD, ACCNTSBOD, ACCOMMIT, ACCONSOL, ACCTLGRPHD, ACCUSTBOD, ACDETAILAU, ACDICT, ACGLCODE, ACGLMAST, ACGRPMXVAL, ACHEADERAU, ACHISTORY, ACHSTDTBOD, ACIFACTV, ACMASTER, ACMONITOR, ACMXVAL, ACOBJID, ACPERCCMPL, ACPERCMPLX, ACPRDPERF, ACRESOURCE, ACRESRT, ACRESRTX, ACROLE, ACSTATUS, ACTEMPCUST, ACTRANS, ACTRANSEG, ACTRANSGL, ACUOM, ADDRDATA, AGINGCODE, AMACCTAU, AMACCTGPAU, AMASSET, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU, AMSYSOPTAU, APACCRCODE, APCOMPANY, APVENGROUP, ARACPIVOT, ARADJUST, ARCODE, ARCOMP, ARCOMPAUD, ARCONTACTS, ARCUSTFLDS, ARCUSTGRP, ARCUSTOMER, ARCUSTTOTS, ARDICT, ARDISPUTE, ARITRANS, ARLOCKBOX, AROIHDR, AROITEMS, ARPAYMENT, ARPRLAUD, ARPROCLEVL, ARREASON, ARREMIT, AUMXVALUAU, AUMXVLDTAU, BILLTO, CAALOCGPAU, CADETAILAU, CAHEADERAU, CBBANKINST, CUACCT, CUACCTAU, CUCODES, CUCODESAU, CUCONV, CUCONVAU, CURELAT, CURELATAU, CUSTDESC, CUSTEP, CUTABLE, CUTABLEAU, CUTRANSL, CUTRNSLAU, EMPLOYEE, EPTRANS, FBADJCODAU, FBCNTRLAU, FBDETAIL, FBDETAILAU, FBFNDHDRAU, FBFUNDAMT, FBFUNDDTL, FBHEADER, FBHEADERAU, FBHSTHDRAU, FBINTBUAU, FBSPREADAU, FBTRANSAU, FROPTIONS, GLACCTVLD, GLACMXVLAU, GLADDRESS, GLAMOUNTS, GLAUTMXVAU, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCHTDTLAU, GLCODES, GLCOMMIT, GLINTCO, GLMASTER, GLMASTERAU, GLNAMES, GLNAMESAU, GLSRCCODE, GLSYSTEM, GLSYSTEMAU, GLTRANS, GMAWARD, GMCOSTSHR, GMFNDACT, GMPGMINC, GTMXVALUAU, HRSECLEV, IFMONITOR, INSTCTRYCD, INSTREGN, JBKACCT, JBOOKHDR, MACAPDTL, MLCOLEDGER, MXCATDEF, MXCATDEFAU, MXELEMENT, MXELEMNTAU, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXLSTDTLAU, MXLSTHDRAU, MXOBJCAT, MXOBJCATAU, MXTMPDTLAU, MXTMPHDRAU, MXTPEFDTAU, MXTPHEDTAU, MXVALIDATE, MXVALIDAU, MXVEWDTLAU, MXVEWHDRAU, NATACCT, NATBALANCE, OECOMPANY, OECOMPREF, OECUST, PRSYSTEM, RJMXVALUAU, STATICCUST, STRUCTURE, SUBCKPOINT, SYSTEMCODE, TERMS, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, TXTAXTRAN, WFSETUP