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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BUCSET1
  1. COMPANY
  2. RECUR-INVOICE
  3. CUSTOMER
  4. LINE-NBR
  5. SEQ
PrimaryBLI2.1, BLI3.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BLRICLINEBLRICCOMM

One to one (1) — lookups and parents

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

Programs

Updated by (2)