BLRICCOMM – Cust. Recurring Invc Comment

System
Billing (BL)
Prefix
BUC
Primary key
COMPANY, RECUR-INVOICE, CUSTOMER, LINE-NBR, SEQ
Fields
9
Updated by
2 programs
Referenced by
0 programs

BLRICCOMM is the Cust. Recurring Invc Comment table in Lawson Billing (prefix BUC). It is indexed by COMPANY, RECUR-INVOICE, CUSTOMER, LINE-NBR, SEQ (BUCSET1). It is related 1:1 to BLRICLINE. It is updated by BLI2.1 and BLI3.1. The table has 9 fields, 1 index and 1 documented relation.

About BLRICCOMM

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
BUC-COMPANY PK
COMPANY		Numeric 4Identifies 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.BLI2.1
BUC-RECUR-INVOICE PK
RECUR_INVOICE		Alpha 10This is the recurring invoice identifier.BLI2.1
BUC-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.BLI2.1
BUC-SHIP-TO
SHIP_TO		Numeric 4This field contains the number representing the ship to customer.BLI2.1
BUC-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.BLI2.1
BUC-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.BLI2.1
BUC-PRINT-CODE
PRINT_CODE		Alpha 1This field contains the print code, which defines where comments are displayed or printed.
  • B Both print and display
  • D Display only
  • P Print only
BLI2.1
BUC-START-DATE
START_DATE		Numeric 8 (yyyymmdd)This is the date on which this comment will begin being used.BLI2.1
BUC-STOP-DATE
STOP_DATE		Numeric 8 (yyyymmdd)This is the date this comment will stop being used.BLI2.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
BUCSET1COMPANY, RECUR-INVOICE, CUSTOMER, LINE-NBR, SEQPrimaryBLI2.1, BLI3.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
BlriclineBLRICLINERequiredBUC-COMPANY → BUL-COMPANY, BUC-RECUR-INVOICE → BUL-RECUR-INVOICE, BUC-CUSTOMER → BUL-CUSTOMER, BUC-LINE-NBR → BUL-LINE-NBR

Programs

Updated by (2)