Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

                             BLRICLINE FILE

                       Cust. Recurring Invc Item

This file contains the line items for customer recurring invoices.  It is
usually created from a line on the recurring invoice.  However, you can enter
additional line items manually.

REFERENCED BY

BL231     BL34.1    BL30.3    BL30.5

UPDATED BY

BL31.1    BL31.2    BL31.3    BL31.5    BL31.7    BL32.3
BL32.4    BL33.1    BL331     BLI2.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BUL-COMPANY          Numeric 4                                   BL31.1  BL31.2
Company              The company number represents an            BL31.3  BL31.5
                     established company and is entered on       BL31.7  BL32.3
                     all function codes.                         BL32.4  BL33.1

BUL-RECUR-INVOICE    Alpha 10                                    BL31.1  BL31.2
Recur Invoice        This is the recurring invoice               BL31.3  BL31.5
                     identifier.                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1

BUL-CUSTOMER         Alpha 9  (Right Justified)                  BL31.1  BL31.2
Customer Number      This field contains the number that         BL31.3  BL31.5
                     represents a customer.                      BL31.7  BL32.3
                                                                 BL32.4  BL33.1

BUL-SHIP-TO          Numeric 4                                   BL31.1  BL31.2
Ship-to Code         This field contains the number              BL31.3  BL31.5
                     representing the ship to customer.          BL31.7  BL32.3
                                                                 BL32.4

BUL-LINE-NBR         Numeric 6                                   BL31.1  BL31.2
Line Number          This field contains the line number.        BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1

BUL-ITEM             Alpha 32                                    BL31.1  BL31.2
Item Number          This field contains the item                BL31.3  BL31.5
                     identifier.                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1

BUL-ITEM-DESC        Alpha 30
Item Description     This field contains the description for
                     items.

BUL-LINE-TYPE        Alpha 1
Line Type            This field contains the type of
                     inventory on this line.
                     N = Non-stock
                     X = Special Order

BUL-ZERO-AFTER-USE   Alpha 1                                     BL31.1  BL31.2
Zero After Use       This flag indicates whether the             BL31.3  BL31.5
                     quantity field is to be zeroed after        BL31.7  BL32.3
                     creation of the actual invoice for each     BL32.4
                     period.

BUL-QUANTITY         Signed 13.4                                 BL31.1  BL31.2
Quantity             This is the total quantity to be billed     BL31.3  BL31.5
                     for this customer recurring invoice         BL31.7  BL32.3
                     item.                                       BL32.4  BL33.1

BUL-SKIP-FLAG        Alpha 1                                     BL31.1  BL31.2
Skip Emp/App if no   Skip this period flag. Only valid if        BL31.3  BL31.5
Detail Flag          zero after use is set to Yes. This lets     BL31.7  BL32.3
                     you pass the edit ensuring that all zero    BL32.4  BL33.1
                     after use lines have been set up for a
                     billing period and still skip billing a
                     line.

BUL-INVOICE-QTY      Signed 13.4                                 BL31.1  BL31.2
Invoice Quantity     This is the quantity to be billed on        BL31.3  BL31.5
                     the next invoice created for this           BL31.7  BL32.3
                     customer recurring invoice line.            BL32.4

BUL-BILLED-AMOUNT    Signed 15.2                                 BL31.1  BL31.2
Billed Amount        The total amount already billed against     BL31.3  BL31.5
                     this customer recurring invoice line.       BL31.7  BL32.3
                                                                 BL32.4

BUL-SELL-UOM         Alpha 4                                     BL31.1  BL31.2
Sell Unit of Measure This field contains the selling unit of     BL31.3  BL31.5
                     measure for the item.                       BL31.7  BL32.3
                                                                 BL32.4

BUL-UNIT-PRICE       Signed 13.5                                 BL31.1  BL31.2
Unit Price           This field contains the unit price.         BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4

BUL-SPR-UOM          Alpha 4                                     BL31.1  BL31.2
Selling Price Unit   This is the pricing unit of measure for     BL31.3  BL31.5
of Measure           this line.                                  BL31.7  BL32.3
                                                                 BL32.4

BUL-FREQUENCY        Alpha 1                                     BL31.1  BL31.2
Frequency            This is the frequency code for this         BL31.3  BL31.5
                     recurring invoice.                          BL31.7  BL32.3
                     W = Weekly                                  BL32.4
                     S = Semi-Monthly
                     M = Monthly
                     Q = Quarterly
                     Y = Yearly
                     U = User Defined

BUL-CYCLE-CODE       Alpha 3                                     BL31.1  BL31.2
Cycle Code           This is the cycle code. Cycle code is       BL31.3  BL31.5
                     used to separate recurring invoices into    BL31.7  BL32.3
                     groups within frequency for processing.     BL32.4

BUL-START-DATE       Numeric 8  (yyyymmdd)                       BL31.1  BL31.2
Start Date           This is the starting date. Invoices         BL31.3  BL31.5
                     created from this customer recurring        BL31.7  BL32.3
                     invoice after this date and prior to the    BL32.4
                     stop date will include this item.

BUL-STOP-DATE        Numeric 8  (yyyymmdd)                       BL31.1  BL31.2
Stop Date            This is the stop date. Invoice created      BL31.3  BL31.5
                     for this customer recurring invoice         BL31.7  BL32.3
                     after this date will not include this       BL32.4
                     line.

BUL-TERRITORY        Alpha 4                                     BL31.1  BL31.2
Sales Territory      This field contains the sales territory.    BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4

BUL-SALESMAN         Numeric 4                                   BL31.1  BL31.2
Salesman Number      This field contains the code that           BL31.3  BL31.5
                     represents the primary sales                BL31.7  BL32.3
                     representative of this line. If left        BL32.4
                     blank, this defaults from the order
                     header.

BUL-SALESMAN-2       Numeric 4                                   BL31.1  BL31.2
Salesman Number 2    This field contains the code                BL31.3  BL31.5
                     representing the second sales               BL31.7  BL32.3
                     representative.                             BL32.4

BUL-COMM-RATE-1      Percent 7.5  (Percent)                      BL31.1  BL31.2
Commission Rate for  This field contains the commission rate     BL31.3  BL31.5
Slsmn 1              of the primary sales representative.        BL31.7  BL32.3
                                                                 BL32.4

BUL-COMM-RATE-2      Percent 7.5  (Percent)                      BL31.1  BL31.2
Commission Rate for  This field contains the commission rate     BL31.3  BL31.5
Slsmn 2              for the second sales representative.        BL31.7  BL32.3
                                                                 BL32.4

BUL-COMM-SPLIT       Percent 5.3  (Percent)                      BL31.1  BL31.2
Commission Split     This field contains the commission          BL31.3  BL31.5
Percentage           split. This defaults from the customer      BL31.7  BL32.3
                     master.                                     BL32.4

BUL-STD-COMM1        Alpha 4                                     BL31.1  BL31.2
Std Comm1            Standard comment code 1. Code to            BL31.3  BL31.5
                     represent a group of comments.              BL31.7  BL32.3
                                                                 BL32.4

BUL-STD-COMM2        Alpha 4                                     BL31.1  BL31.2
Std Comm2            Standard comment code 2. Code to            BL31.3  BL31.5
                     represent a group of comments.              BL31.7  BL32.3
                                                                 BL32.4

BUL-STD-COMM3        Alpha 4                                     BL31.1  BL31.2
Std Comm3            Standard comment code 3. Code to            BL31.3  BL31.5
                     represent a group of comments.              BL31.7  BL32.3
                                                                 BL32.4

BUL-LAST-MISC-SEQ    Numeric 3                                   BL31.1  BL31.2
Last Misc Code       Last sequence number used for add-on        BL31.3  BL31.5
Sequence             charges for this customer recurring         BL31.7  BL32.3
                     invoice line.                               BL32.4

BUL-LAST-COMM-SEQ    Numeric 3                                   BL31.1  BL31.2
Last Comment         This is the sequence number of the last     BL31.3  BL31.5
Sequence Number      comment line entered for this               BL31.7  BL32.3
                     requisition line.                           BL32.4  BLI2.1

BUL-MAST-LINE-NBR    Numeric 6                                   BL31.1  BL31.2
Mast Line Nbr        Line number of the recurring invoice        BL31.3  BL31.5
                     line that caused this customer recurring    BL31.7  BL32.3
                     invoice line.                               BL32.4

BUL-UNBILLED-AMT     Derived
Unbilled Amt         Amount yet to be billed against this
                     line.

BUL-TOTAL-VALUE      Derived
Total Value          Total amount to be billed against this
                     line.

BUL-IC-UOM-1         Derived
Ic Uom 1             This field contains the first inventory
                     unit of measure for the item.

BUL-IC-UOM-2         Derived
Ic Uom 2             This field contains the second
                     inventory unit of measure for the item.

BUL-IC-UOM-3         Derived
Ic Uom 3             This field contains the third inventory
                     unit of measure for the item.

BUL-IC-UOM-4         Derived
Ic Uom 4             This field contains the fourth
                     inventory unit of measure for the item.

BUL-IC-UOM-5         Derived
Ic Uom 5             This field contains the fifth inventory
                     unit of measure for the item.

BUL-IC-UOM-6         Derived
Ic Uom 6             This field contains the sixth inventory
                     unit of measure for the item.

BUL-STS-INDEX        Derived
Sts Index            This field determines which inventory
                     unit of measure is used for display
                     purposes.

BUL-STS-M            Derived
Sts M                This field contains the multiplier.

BUL-STS-MULT         Derived
Sts Mult             This field contains the sales to stock
                     multiplier.

BUL-PTS-INDEX        Derived
Pts Index            This field determines which unit of
                     measure to use in pricing.

BUL-PTS-M            Derived
Pts M                This field contains the pricing
                     multiplier.

BUL-PTS-MULT         Derived
Pts Mult             This field contains the pricing unit of
                     measure multiplier.

BUL-ITEM-16          Derived
Item 16              This field contains the first 16
                     characters of the item's identifier.
                     This information is used by inquiries
                     and reports.

                         BLRICLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BULSET1   COMPANY                                                BL231   BL31.1
          RECUR-INVOICE                                          BL31.2  BL31.3
          CUSTOMER                                               BL31.5  BL31.7
          LINE-NBR                                               BL32.3  BL32.4
                                                                 BL331   BL34.1
                                                                 BLI2.1

BULSET2   COMPANY       Subset                                   BL30.3  BL30.5
          RECUR-INVOICE Where MAST-LINE-NBR != Zeroes            BL32.2
          MAST-LINE-NBR
          CUSTOMER

BULSET3   COMPANY       KeyChange, Subset
          FREQUENCY     Where QUANTITY  = Zeroes
          CYCLE-CODE    And   SKIP-FLAG = "N"
          ITEM
          RECUR-INVOICE
          CUSTOMER
          LINE-NBR

BULSET4   COMPANY       KeyChange, Subset                        BL33.1
          FREQUENCY     Where ZERO-AFTER-USE = "Y"
          CYCLE-CODE
          ITEM
          RECUR-INVOICE
          CUSTOMER
          LINE-NBR

BULSET5   COMPANY       Subset
          RECUR-INVOICE Where QUANTITY  = Zeroes
          CUSTOMER      And   SKIP-FLAG = "N"
          LINE-NBR

                         BLRICLINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            BUL-COMPANY          -> ACO-COMPANY  (ACOSET1)

Arcustomer     ARCUSTOMER   Required

                            BUL-COMPANY          -> ACM-COMPANY
                            BUL-CUSTOMER         -> ACM-CUSTOMER

Blricsgblk     BLRICSGBLK   Not Required

                            BUL-COMPANY          -> CGM-COMPANY
                            BUL-RECUR-INVOICE    -> CGM-RECUR-INVOICE
                            BUL-CUSTOMER         -> CGM-CUSTOMER
                            BUL-LINE-NBR         -> CGM-LINE-NBR
                            Zeroes               -> CGM-SEQ

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            BUL-CUSTOMER         -> CUD-CUSTOMER

Iccompany      ICCOMPANY    Required

                            BUL-COMPANY          -> ICC-COMPANY

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            BUL-ITEM             -> ITE-ITEM

Oecommhdr1     OECOMMHDR    Not Required
                            Valid When BUL-STD-COMM1 != Spaces

                            BUL-COMPANY          -> OCH-COMPANY
                            BUL-STD-COMM1        -> OCH-STD-COMM

Oecommhdr2     OECOMMHDR    Not Required
                            Valid When BUL-STD-COMM2 != Spaces

                            BUL-COMPANY          -> OCH-COMPANY
                            BUL-STD-COMM2        -> OCH-STD-COMM

Oecommhdr3     OECOMMHDR    Not Required
                            Valid When BUL-STD-COMM3 != Spaces

                            BUL-COMPANY          -> OCH-COMPANY
                            BUL-STD-COMM3        -> OCH-STD-COMM

Oecompany      OECOMPANY    Required

                            BUL-COMPANY          -> OEC-COMPANY

Oecustsrvc     BLRICUST     Required

                            BUL-COMPANY          -> BRC-COMPANY
                            BUL-RECUR-INVOICE    -> BRC-RECUR-INVOICE
                            BUL-CUSTOMER         -> BRC-CUSTOMER

Oemastsrvc     BLRIMAST     Required

                            BUL-COMPANY          -> BRM-COMPANY
                            BUL-RECUR-INVOICE    -> BRM-RECUR-INVOICE

Oemsline       BLRIMLINE    Not Required

                            BUL-COMPANY          -> BML-COMPANY
                            BUL-RECUR-INVOICE    -> BML-RECUR-INVOICE
                            BUL-LINE-NBR         -> BML-LINE-NBR

Salesman       SALESREP     Required
                            When BUL-SALESMAN != Zeroes

                            BUL-COMPANY          -> SAW-COMPANY
                            BUL-SALESMAN         -> SAW-SALESMAN

Salesman2      SALESREP     Required
                            When BUL-SALESMAN-2 != Zeroes

                            BUL-COMPANY          -> SAW-COMPANY
                            BUL-SALESMAN-2       -> SAW-SALESMAN

Territory      TERITORY     Required
                            When BUL-TERRITORY != Spaces

                            BUL-COMPANY          -> TRY-COMPANY
                            BUL-TERRITORY        -> TRY-TERRITORY

                         BLRICLINE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Blriccomm      BLRICCOMM

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

Oecscomm       BLRICCOMM

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

Oecsmisc       BLRICMISC

                            BUL-COMPANY          -> BUM-COMPANY
                            BUL-RECUR-INVOICE    -> BUM-RECUR-INVOICE
                            BUL-CUSTOMER         -> BUM-CUSTOMER
                            BUL-LINE-NBR         -> BUM-LINE-NBR
                                                    BUM-SEQ