Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BLRICCOMM


                             BLRICCOMM FILE

                      Cust. Recurring Invc Comment

This file stores comments associated with customer recurring invoice and
invoice lines.

UPDATED BY

BLI2.1    BLI3.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BUC-COMPANY            Numeric 4                                 BLI2.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

BUC-RECUR-INVOICE      Alpha 10                                  BLI2.1
Element: Recur Invoice This is the recurring invoice
                       identifier.

BUC-CUSTOMER           Alpha 9  (Right Justified)                BLI2.1
Element: Customer NumbeThis field contains the number that
                       represents a customer.

BUC-SHIP-TO            Numeric 4                                 BLI2.1
Element: Ship-to Code  This field contains the number
                       representing the ship to customer.

BUC-LINE-NBR           Numeric 6                                 BLI2.1
Element: Line Number   This field contains the line number.

BUC-SEQ                Numeric 3                                 BLI2.1
Element: Sequence NumbeThis field contains the record sequence
                       number.

BUC-PRINT-CODE         Alpha 1                                   BLI2.1
Element: Print Code    This field contains the print code,
                       which defines where comments are
                       displayed or printed.
                       B = Both print and display
                       D = Display only
                       P = Print only

BUC-START-DATE         Numeric 8  (yyyymmdd)                     BLI2.1
Element: Date          This is the date on which this comment
                       will begin being used.

BUC-STOP-DATE          Numeric 8  (yyyymmdd)                     BLI2.1
Element: Date          This is the date this comment will stop
                       being used.

                         BLRICCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BUCSET1   COMPANY                                                BLI2.1  BLI3.1
          RECUR-INVOICE
          CUSTOMER
          LINE-NBR
          SEQ

                         BLRICCOMM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Blricline      BLRICLINE    Required

                            BUC-COMPANY          -> BUL-COMPANY
                            BUC-RECUR-INVOICE    -> BUL-RECUR-INVOICE
                            BUC-CUSTOMER         -> BUL-CUSTOMER
                            BUC-LINE-NBR         -> BUL-LINE-NBR