Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BLRICMISC


                             BLRICMISC FILE

                      Cust. Recurring Invoice AOC

This file stores the add-on charges for customer recurring invoices and
invoice line items.  Usually they are created from the recurring invoice
add-on charges.  However, the user can add additional add-on charges manually.

REFERENCED BY

BL231     BL30.2    BL30.5

UPDATED BY

BL130     BL31.1    BL31.2    BL31.3    BL31.5    BL31.7
BL32.3    BL32.4    BL331     BL34.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BUM-COMPANY            Numeric 4                                 BL130   BL31.1
Element: Company       Identifies the AP company if the          BL31.2  BL31.3
                       resource type = V.  Identifies the HR     BL31.5  BL31.7
                       company if the resource type = E.  It is  BL32.3  BL32.4
                       blank for type A, P or Q resources.       BL34.1

BUM-RECUR-INVOICE      Alpha 10                                  BL130   BL31.1
Element: Recur Invoice This is the recurring invoice             BL31.2  BL31.3
                       identifier.                               BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL34.1

BUM-CUSTOMER           Alpha 9  (Right Justified)                BL130   BL31.1
Element: Customer NumbeThis field contains the number that       BL31.2  BL31.3
                       represents a customer.                    BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL34.1

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

BUM-LINE-NBR           Numeric 6                                 BL130   BL31.1
Element: Line Number   This field contains the line number.      BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL34.1

BUM-SEQ                Numeric 3                                 BL130   BL31.1
Element: Sequence NumbeThis field contains the record sequence   BL31.2  BL31.3
                       number.                                   BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL34.1

BUM-MISC               Alpha 16                                  BL130   BL31.1
Element: Misc          Add-on charge code. Must be valid in      BL31.2  BL31.3
                       the add-on charge master file.            BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL34.1

BUM-ZERO-AFTER-USE     Alpha 1                                   BL130   BL31.1
Element: All Flag      Flag to determine whether the amount      BL31.2  BL31.3
                       field is zeroed out after each creation   BL31.5  BL31.7
                       of an invoice against this customer       BL32.3  BL32.4
                       recurring invoice add-on charge.

BUM-AMOUNT             Signed 18.2                               BL130   BL31.1
Element: Intl Amt      This is the total amount to be billed     BL31.2  BL31.3
                       for this charge.                          BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL34.1

BUM-BILLED-AMOUNT      Signed 18.2                               BL130   BL31.1
Element: Intl Amt      This is the amount billed to date for     BL31.2  BL31.3
                       this charge.                              BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BUM-PRICE              Signed 18.2                               BL130   BL31.1
Element: Intl Amt      This field contains the flat amount       BL31.2  BL31.3
                       that is applied as an add-on charge per   BL31.5  BL31.7
                       billing.                                  BL32.3  BL32.4

BUM-SKIP-FLAG          Alpha 1                                   BL130   BL31.1
Skip Emp/App if no     Flag to indicate that this add-on         BL31.2  BL31.3
Detail Flag            charge is to be skipped the next time an  BL31.5  BL31.7
                       invoice is created for this customer      BL32.3  BL32.4
                       recurring invoice. Only valid if the      BL34.1
                       zero after use flag is set on.

BUM-FREQUENCY          Alpha 1                                   BL130   BL31.1
Element: Frequency     Frequency for this customer recurring     BL31.2  BL31.3
                       invoice.                                  BL31.5  BL31.7
                       W = Weekly                                BL32.3  BL32.4
                       S = Semi-Monthly
                       M = Monthly
                       Q = Quarterly
                       Y = Yearly
                       U = User Defined

BUM-CYCLE-CODE         Alpha 3                                   BL130   BL31.1
Element: Authority CodeCycle code. Used to group customer        BL31.2  BL31.3
                       recurring invoices within frequency code  BL31.5  BL31.7
                       to manage the work load.                  BL32.3  BL32.4

BUM-START-DATE         Numeric 8  (yyyymmdd)                     BL130   BL31.1
Element: Start Date    Start date. Any invoice created for       BL31.2  BL31.3
                       this customer recurring invoice prior to  BL31.5  BL31.7
                       this date will not include this add-on    BL32.3  BL32.4
                       charge.

BUM-STOP-DATE          Numeric 8  (yyyymmdd)                     BL130   BL31.1
Element: Stop Date     Stop date. Any invoice created for this   BL31.2  BL31.3
                       customer recurring invoice after this     BL31.5  BL31.7
                       date will not include this add-on         BL32.3  BL32.4
                       charge.

BUM-MAST-LINE-NBR      Numeric 6                                 BL130   BL31.1
Element: Line Number   Line number of the recurring invoice      BL31.2  BL31.3
                       add-on charge that triggered this         BL31.5  BL31.7
                       customer recurring invoice add-on         BL32.3  BL32.4
                       charge.

BUM-MAST-SEQ           Numeric 3                                 BL130   BL31.1
Element: Sequence NumbeSequence number of the recurring          BL31.2  BL31.3
                       invoice add-on charge that triggered      BL31.5  BL31.7
                       creation of this customer recurring       BL32.3  BL32.4
                       invoice add-on charge.

                         BLRICMISC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BUMSET1   COMPANY                                                BL130   BL231
          RECUR-INVOICE                                          BL31.1  BL31.2
          CUSTOMER                                               BL31.3  BL31.5
          LINE-NBR                                               BL31.7  BL32.3
          SEQ                                                    BL32.4  BL331

BUMSET2   COMPANY       Subset                                   BL30.2  BL30.5
          RECUR-INVOICE Where MAST-LINE-NBR != Zeroes
          MAST-LINE-NBR
          MAST-SEQ
          CUSTOMER

BUMSET3   COMPANY       KeyChange, Subset                        BL130
          FREQUENCY     Where AMOUNT    = Zeroes
          CYCLE-CODE    And   SKIP-FLAG = "N"
          MISC
          RECUR-INVOICE
          CUSTOMER
          LINE-NBR
          SEQ

BUMSET4   COMPANY       KeyChange, Subset                        BL34.1
          FREQUENCY     Where ZERO-AFTER-USE = "Y"
          CYCLE-CODE
          MISC
          RECUR-INVOICE
          CUSTOMER
          LINE-NBR
          SEQ

BUMSET5   COMPANY       Subset                                   BL130
          RECUR-INVOICE Where AMOUNT    = Zeroes
          CUSTOMER      And   SKIP-FLAG = "N"
          LINE-NBR
          SEQ

                         BLRICMISC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            BUL-COMPANY          -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            BUM-COMPANY          -> ACM-COMPANY
                            BUM-CUSTOMER         -> ACM-CUSTOMER

Blricsgblk     BLRICSGBLK   Not Required

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

Custdesc       CUSTDESC     Not Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            BUM-CUSTOMER         -> CUD-CUSTOMER

Oecompany      OECOMPANY    Required

                            BUL-COMPANY          -> OEC-COMPANY

Oecsline       BLRICLINE    Required

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

Oecustsrvc     BLRICUST     Required

                            BUM-COMPANY          -> BRC-COMPANY
                            BUM-RECUR-INVOICE    -> BRC-RECUR-INVOICE
                            BUM-CUSTOMER         -> BRC-CUSTOMER

Oemastsrvc     BLRIMAST     Required

                            BUM-COMPANY          -> BRM-COMPANY
                            BUM-RECUR-INVOICE    -> BRM-RECUR-INVOICE

Oemisc         OEMISC       Required

                            BUM-COMPANY          -> OEM-COMPANY
                            BUM-MISC             -> OEM-MISC
                            BRC-CURRENCY-CODE    -> OEM-CURRENCY-CODE

Oemsmisc       BLRIMMISC    Not Required

                            BUM-COMPANY          -> BMM-COMPANY
                            BUM-RECUR-INVOICE    -> BMM-RECUR-INVOICE
                            BUM-LINE-NBR         -> BMM-LINE-NBR
                            BUM-SEQ              -> BMM-SEQ