BR521 – Billing Import
- System
- AC Billing Revenue (BR)
- Type
- Batch program
- Updates
- 29 tables
- References
- 76 tables
BR521 (Billing Import) is a Lawson AC Billing Revenue batch program. It updates ACACTIVITY, ACASNROLE, ACBILL, ACBILLX, ACCEILINGX, ACCLGTRANS, ACCNTRACT, ACFEEBAL and 21 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE, ACASSIGN and 68 more.
About BR521
Run Billing Import (BR521) to convert historical billing information from a non-Lawson billing system to Billing and Revenue Management. Billing Import updates billing history and balances for historical invoices without creating GL or AR entries. Updating the billing history ensures accuratecumulative to-date billing amounts for active contracts before generating new invoices within Billing and Revenue Management.
Updated files (29)
| Table | Description | System |
|---|---|---|
| ACACTIVITY | Activity | AC |
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACCEILINGX | Activity Ceiling Detail | BR |
| ACCLGTRANS | Ceiling Level Transactions | BR |
| ACCNTRACT | Activity Contract | BR |
| ACFEEBAL | The fee balance file stores cumulative costs, fee and overage which will be used in calculating the billing and revenue… | BR |
| ACFEEDTL | Activity Management Fee Detail | BR |
| ACMILESTNX | Activity Milestones Detail | BR |
| ACMNTSCH | Activity Maintenance Schedule | BR |
| ACMNTSCHX | Activity Maintenance Sched Dtl | BR |
| ACMONITOR | No description in the Lawson data dictionary | AC |
| ACPRMSTNX | No description in the Lawson data dictionary | BR |
| ACRETNG | Activity Bill Retention | BR |
| ACRETNGX | Activity Bill Retention Detail | BR |
| ACTRANS | Activity Transaction | AC |
| ARPROCLEVL | Accounts Receivable Proc Level | AR |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTEP | No description in the Lawson data dictionary | BL |
| IFMONITOR | No description in the Lawson data dictionary | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| SUBCKPOINT | Subledger Check Point | IF |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (76)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTMXVAL | Activity List Attribute Values | AC |
| ACADDLCNTR | Additional Contract Info | BR |
| ACAMCODE | Activity Asset | AC |
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACASSIGN | Activity Resource Assignment | AC |
| ACBILLTOX | Activity Bill To Detail | BR |
| ACBLMAST | Activity Billing Balances | BR |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATMXVAL | No description in the Lawson data dictionary | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCTRCATG | Contract Category Group | BR |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACCUSTOMER | Activity Customer | BR |
| ACFEECD | Activity Management Fee Code | BR |
| ACGRPMXVAL | The ACGRPMXVAL file is the primary file updated by AC13. | AC |
| ACHISTCLG | Billing Overage | BR |
| ACHISTDTL | Invoice Detail | BR |
| ACHISTHDR | Invoice Header | BR |
| ACHISTTAX | Invoice Tax Detail | BR |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACMILESTN | Activity Milestones | BR |
| ACMNTHDR | Activity Maintenance Header | BR |
| ACMNTSCHX | Activity Maintenance Sched Dtl | BR |
| ACPERCCMPL | Activity Percent Complete | AC |
| ACPRMSTN | No description in the Lawson data dictionary | BR |
| ACPROADJ | No description in the Lawson data dictionary | BR |
| ACPRODDTL | Activity Product Detail | BR |
| ACPRODHDR | Activity Product Header | BR |
| ACPRODINV | Product Invoice Cancellation | BR |
| ACPRODTAX | No description in the Lawson data dictionary | BR |
| ACPROFORMA | No description in the Lawson data dictionary | BR |
| ACRETAIN | No description in the Lawson data dictionary | BR |
| ACRETAINX | No description in the Lawson data dictionary | BR |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSRVCLOC | This file maintains a service location for tax purposes. | BR |
| ACSTATUS | Activity Status | AC |
| ACUOM | Activity Unit of Measure | AC |
| ACWBSCODE | No description in the Lawson data dictionary | BR |
| AGINGCODE | Accounts Receivable Aging Code | AR |
| APACCRCODE | Invoice Accrual Code | AP |
| ARCOMP | Accounts Receivable Company | AR |
| ARCOMPAUD | AR Company Audit | AR |
| ARCUSTFLDS | AR Customer User Fields | AR |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| ARCUSTOMER | AR Company Customer | AR |
| ARCUSTTOTS | AR Customer PL Inclusions | AR |
| ARDICT | No description in the Lawson data dictionary | AR |
| ARLOCKBOX | Lock Box Location | AR |
| ARPAYMENT | Acct Receivables Payment | AR |
| ARPRLAUD | AR Process Level Audit | AR |
| ARREMIT | Payment Remittance | AR |
| BILLTO | Bill To | AR |
| BRCUSTAU | BR Activity Customer Audit | BR |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUSTDESC | AR Group Customer | AR |
| EPTRANS | No description in the Lawson data dictionary | BL |
| GLSYSTEM | General Ledger Company | IF |
| GMAWARD | Grant Management Award | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| MXCATDEF | Attribute Definition | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| NATACCT | Accounts Receivable Natl Acct | AR |
| NATBALANCE | AR National Account Balance | AR |
| OECUST | Customer Order Processing | AR |
| STATICCUST | AR Ovrd Credit Trans Review | AR |
| STRUCTURE | Category Structure | AC |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (25)
ACAC, ACSR, ACTA, API4, ARLL, BRIP, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFIM, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU