BLRICUST – Customer Recurring Invoice

System: Billing (BL)
Prefix: BRC
Primary key: COMPANY, RECUR-INVOICE, CUSTOMER
Fields: 43
Updated by: 1 program
Referenced by: 0 programs

BLRICUST is the Customer Recurring Invoice table in Lawson Billing (prefix BRC). It is indexed by COMPANY, RECUR-INVOICE, CUSTOMER (BRCSET1). It is related 1:1 to ARCOMP, ARCUSTOMER, CUCODES, CUSTDESC, HOLDCODES, ICLOCATION, OECOMMHDR, OECOMPANY and 4 more and 1:M to BLRICCOMM and BLRICLINE. It is updated by BLI2.1. The table has 43 fields, 1 index and 17 documented relations.

About BLRICUST

No description in the Lawson data dictionary.

Fields (43)

Column = COBOL field name without the BRC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`BRC-COMPANY` PK COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	—
`BRC-RECUR-INVOICE` PK RECUR_INVOICE	Alpha 10	This is the recurring invoice identifier.	—
`BRC-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	—
`BRC-SHIP-TO` SHIP_TO	Numeric 4	This field contains the number representing the ship to customer.	—
`BRC-CONTACT` CONTACT	Alpha 20	This is the name of the main contact.	—
`BRC-PHONE-NBR` PHONE_NBR	Numeric 10	The phone number of the manager in charge.	—
`BRC-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company's base currency code defined in the General Ledger system.	—
`BRC-HOLD-CODE` HOLD_CODE	Alpha 4	This field contains the hold code. Hold codes are set up in the Accounts Receivable system.	—
`BRC-TERMS-CD` TERMS_CD	Alpha 5	This is the terms code to use for invoices created for the customer recurring invoice. It is optional. If blank, the terms code for the customer is used.	—
`BRC-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	—
`BRC-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	—
`BRC-LOCATION` LOCATION	Alpha 5	This field contains a valid stock location within the company inventory.	—
`BRC-TERRITORY` TERRITORY	Alpha 4	This field contains the sales territory.	—
`BRC-SALESMAN` SALESMAN	Numeric 4	This field contains the code that represents the primary sales representative of this line. If left blank, this defaults from the customer.	—
`BRC-SALESMAN-2` SALESMAN_2	Numeric 4	This field contains the code representing the second sales representative. This defaults from the customer.	—
`BRC-COMM-RATE-1` COMM_RATE_1	Percent 7.5 (Percent)	This field contains the commission rate of the primary sales representative. This defaults from customer.	—
`BRC-COMM-RATE-2` COMM_RATE_2	Percent 7.5 (Percent)	This field contains the commission rate for the second sales representative. This defaults from customer.	—
`BRC-COMM-SPLIT` COMM_SPLIT	Percent 5.3 (Percent)	This field contains the commission split. This defaults from the customer.	—
`BRC-INVOICE-COUNT` INVOICE_COUNT	Numeric 3	Number of invoices already created against this customer recurring invoice. Compared to the recurring invoice number of invoices to control creation of invoices for this customer recurring invoice.	—
`BRC-FREQUENCY` FREQUENCY	Alpha 1	Frequency for this customer recurring invoice.	—
`BRC-CYCLE-CODE` CYCLE_CODE	Alpha 3	Cycle code. Used to group customer recurring invoices within frequency code to manage the workload.	—
`BRC-START-DATE` START_DATE	Numeric 8 (yyyymmdd)	Start date. No invoices are created for this customer recurring invoice prior to this date.	—
`BRC-STOP-DATE` STOP_DATE	Numeric 8 (yyyymmdd)	Stop date. No invoices are created for this customer recurring invoice after this date.	—
`BRC-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.	—
`BRC-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific general ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing.	—
`BRC-TRANS-USER1` TRANS_USER1	Alpha 10	User field 1.	—
`BRC-TRANS-USER2` TRANS_USER2	Alpha 15	User field 2.	—
`BRC-TRANS-USER3` TRANS_USER3	Numeric 8 (yyyymmdd)	User field 3.	—
`BRC-TRANS-USER4` TRANS_USER4	Numeric 9	User field 4.	—
`BRC-TRANS-USER5` TRANS_USER5	Signed 18.2	User field 5.	—
`BRC-STD-COMM1` STD_COMM1	Alpha 4	Standard comment code 1. Code for a group of comments.	—
`BRC-STD-COMM2` STD_COMM2	Alpha 4	Standard comment code 2. Code for a group of comments.	—
`BRC-STD-COMM3` STD_COMM3	Alpha 4	Standard comment code 3. Code for a group of comments.	—
`BRC-LAST-LINE-NBR` LAST_LINE_NBR	Numeric 6	This is the number of the last line item added. It is used to determine the number when the next line is added.	—
`BRC-LAST-MISC-SEQ` LAST_MISC_SEQ	Numeric 3	Last sequence number for add-on charges for this customer recurring invoice.	—
`BRC-LAST-COMM-SEQ` LAST_COMM_SEQ	Numeric 3	This is the sequence number of the last comment line entered for this line.	BLI2.1
`BRC-EP-TYPE` EP_TYPE	Alpha 5	—	—
`BRC-EP-ACCOUNT` EP_ACCOUNT	Alpha 32	—	—
`BRC-EP-EXP-DATE` EP_EXP_DATE	Numeric 8 (yyyymmdd)	—	—
`BRC-BILL-TO` BILL_TO	Numeric 4	This field contains the mailing address for the invoice. Bill to addresses are maintained in the Accounts Receviable Bill To form AR09.4.	—
`BRC-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	—
`BRC-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	Code indicating the taxing status. E - Exempt, T - Taxable.	—
`BRC-PO-NUMBER` PO_NUMBER	Alpha 22	—	—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`BRCSET1`	`COMPANY`, `RECUR-INVOICE`, `CUSTOMER`	Primary		BLI2.1

Relations

One to one (15) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcomp	ARCOMP	Required		`BRC-COMPANY` → `ACO-COMPANY`
Arcustomer	ARCUSTOMER	Required		`BRC-COMPANY` → `ACM-COMPANY`, `BRC-CUSTOMER` → `ACM-CUSTOMER`
Cucodes	CUCODES	Not Required	Valid When BRC-CURRENCY-CODE != Spaces	`BRC-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Custdesc	CUSTDESC	Required		`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `BRC-CUSTOMER` → `CUD-CUSTOMER`
Holdcodes	HOLDCODES	Not Required	Valid When BRC-HOLD-CODE != Spaces	`ACO-CUST-GROUP` → `HDD-CUST-GROUP`, `BRC-HOLD-CODE` → `HDD-HOLD-CODE`
Iclocation	ICLOCATION	Required	When BRC-LOCATION != Spaces	`BRC-COMPANY` → `ICL-COMPANY`, `BRC-LOCATION` → `ICL-LOCATION`
Oecommhdr1	OECOMMHDR	Not Required	Valid When BRC-STD-COMM1 != Spaces	`BRC-COMPANY` → `OCH-COMPANY`, `BRC-STD-COMM1` → `OCH-STD-COMM`
Oecommhdr2	OECOMMHDR	Not Required	Valid When BRC-STD-COMM2 != Spaces	`BRC-COMPANY` → `OCH-COMPANY`, `BRC-STD-COMM2` → `OCH-STD-COMM`
Oecommhdr3	OECOMMHDR	Not Required	Valid When BRC-STD-COMM3 != Spaces	`BRC-COMPANY` → `OCH-COMPANY`, `BRC-STD-COMM3` → `OCH-STD-COMM`
Oecompany	OECOMPANY	Required		`BRC-COMPANY` → `OEC-COMPANY`
Oeproclev	OEPROCLEV	Required		`BRC-COMPANY` → `OEP-COMPANY`, `BRC-PROCESS-LEVEL` → `OEP-PROCESS-LEVEL`
Salesman	SALESREP	Required	When BRC-SALESMAN != Zeroes	`BRC-COMPANY` → `SAW-COMPANY`, `BRC-SALESMAN` → `SAW-SALESMAN`
Salesman 2	SALESREP	Required	When BRC-SALESMAN-2 != Zeroes	`BRC-COMPANY` → `SAW-COMPANY`, `BRC-SALESMAN-2` → `SAW-SALESMAN`
Terms	TERMS	Required	When BRC-TERMS-CD != Spaces	`BRC-TERMS-CD` → `TMS-TERMS-CD`
Territory	TERITORY	Required	When BRC-TERRITORY != Spaces	`BRC-COMPANY` → `TRY-COMPANY`, `BRC-TERRITORY` → `TRY-TERRITORY`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Oecscomm	BLRICCOMM			`BRC-COMPANY` → `BUC-COMPANY`, `BRC-RECUR-INVOICE` → `BUC-RECUR-INVOICE`, `BRC-CUSTOMER` → `BUC-CUSTOMER`, `Zeroes` → `BUC-LINE-NBR`, → `BUC-SEQ`
Oecsline	BLRICLINE			`BRC-COMPANY` → `BUL-COMPANY`, `BRC-RECUR-INVOICE` → `BUL-RECUR-INVOICE`, `BRC-CUSTOMER` → `BUL-CUSTOMER`, → `BUL-LINE-NBR`

Programs

Updated by (1)

BLI2.1 BL and OE Attachment Copy