Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BLRICUST


                             BLRICUST FILE

                       Customer Recurring Invoice

This file stores the header information for customer recurring invoices. Most
of this data defaults from the associated recurring invoice.  However, the
user can then add or modify that information for this specific customer.

REFERENCED BY

BL231     BL30.1    BL30.2    BL30.3    BL30.5    BL33.1
BL330     BL34.1

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BRC-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.

BRC-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

BRC-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

BRC-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

BRC-CONTACT            Alpha 20                                  BL130   BL31.1
Element: Primary ContacThis is the name of the main contact.     BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-PHONE-NBR          Numeric 10                                BL130   BL31.1
Element: Telephone NumbThe phone number of the manager in        BL31.2  BL31.3
                       charge.                                   BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-CURRENCY-CODE      Alpha 5                                   BL130   BL31.1
Element: Currency Code This field contains the company's base    BL31.2  BL31.3
                       currency code defined in the General      BL31.5  BL31.7
                       Ledger system.                            BL32.3  BL32.4

BRC-HOLD-CODE          Alpha 4                                   BL130   BL31.1
Element: Hold Code     This field contains the hold code. Hold   BL31.2  BL31.3
                       codes are set up in the Accounts          BL31.5  BL31.7
                       Receivable system.                        BL32.3  BL32.4

BRC-TERMS-CD           Alpha 5                                   BL130   BL31.1
Element: Terms Code    This is the terms code to use for         BL31.2  BL31.3
                       invoices created for the customer         BL31.5  BL31.7
                       recurring invoice. It is optional. If     BL32.3  BL32.4
                       blank, the terms code for the customer
                       is used.

BRC-REFERENCE          Alpha 10  (Lower Case)                    BL130   BL31.1
Element: Reference     The reference number associated with      BL31.2  BL31.3
                       the transaction.                          BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-PROCESS-LEVEL      Alpha 5                                   BL130   BL31.1
Element: Process Level This field contains the process level,    BL31.2  BL31.3
                       which is the reporting hierarchy below    BL31.5  BL31.7
                       company.                                  BL32.3  BL32.4

BRC-LOCATION           Alpha 5                                   BL130   BL31.1
Element: Location Code This field contains a valid stock         BL31.2  BL31.3
                       location within the company inventory.    BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-TERRITORY          Alpha 4                                   BL130   BL31.1
Element: Sales TerritorThis field contains the sales territory.  BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-SALESMAN           Numeric 4                                 BL130   BL31.1
Element: Salesman NumbeThis field contains the code that         BL31.2  BL31.3
                       represents the primary sales              BL31.5  BL31.7
                       representative of this line. If left      BL32.3  BL32.4
                       blank, this defaults from the customer.

BRC-SALESMAN-2         Numeric 4                                 BL130   BL31.1
Element: Salesman NumbeThis field contains the code              BL31.2  BL31.3
                       representing the second sales             BL31.5  BL31.7
                       representative. This defaults from the    BL32.3  BL32.4
                       customer.

BRC-COMM-RATE-1        Percent 7.5  (Percent)                    BL130   BL31.1
Element: Chrg Rate     This field contains the commission rate   BL31.2  BL31.3
                       of the primary sales representative.      BL31.5  BL31.7
                       This defaults from customer.              BL32.3  BL32.4

BRC-COMM-RATE-2        Percent 7.5  (Percent)                    BL130   BL31.1
Element: Chrg Rate     This field contains the commission rate   BL31.2  BL31.3
                       for the second sales representative.      BL31.5  BL31.7
                       This defaults from customer.              BL32.3  BL32.4

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

BRC-INVOICE-COUNT      Numeric 3                                 BL130   BL31.1
Element: Invoice Count Number of invoices already created        BL31.2  BL31.3
                       against this customer recurring invoice.  BL31.5  BL31.7
                       Compared to the recurring invoice number  BL32.3  BL32.4
                       of invoices to control creation of
                       invoices for this customer recurring
                       invoice.

BRC-FREQUENCY          Alpha 1                                   BL130   BL31.1
Element: Frequency     Frequency for this customer recurring     BL31.2  BL31.3
                       invoice.                                  BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-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 workload.                   BL32.3  BL32.4

BRC-START-DATE         Numeric 8  (yyyymmdd)                     BL130   BL31.1
Element: Start Date    Start date. No invoices are created for   BL31.2  BL31.3
                       this customer recurring invoice prior to  BL31.5  BL31.7
                       this date.                                BL32.3  BL32.4

BRC-STOP-DATE          Numeric 8  (yyyymmdd)                     BL130   BL31.1
Element: Stop Date     Stop date. No invoices are created for    BL31.2  BL31.3
                       this customer recurring invoice after     BL31.5  BL31.7
                       this date.                                BL32.3  BL32.4

BRC-ACTIVITY           Alpha 15                                  BL130   BL31.1
Element: Activity      Activities are the processes or           BL31.2  BL31.3
                       procedures that produce work. Cost        BL31.5  BL31.7
                       objects (products, services, customers,   BL32.3  BL32.4
                       and so on) are the reasons for
                       performing the activity. Activities and
                       cost object activities are used
                       synonymously in the Activity Management
                       system. Direct costs are posted to
                       activities, and indirect costs are
                       allocated to activities based on
                       activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

BRC-ACCT-CATEGORY      Alpha 5                                   BL130   BL31.1
Element: Account CategoAccount categories are groupings of       BL31.2  BL31.3
                       costs, revenues, or a combination of      BL31.5  BL31.7
                       both used for reporting and inquiries     BL32.3  BL32.4
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       general ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

BRC-TRANS-USER1        Alpha 10                                  BL130   BL31.1
Element: Trans User1   User field 1.                             BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-TRANS-USER2        Alpha 15                                  BL130   BL31.1
Element: Agent         User field 2.                             BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-TRANS-USER3        Numeric 8  (yyyymmdd)                     BL130   BL31.1
Element: Trans User3   User field 3.                             BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-TRANS-USER4        Numeric 9                                 BL130   BL31.1
Element: Trans User4   User field 4.                             BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-TRANS-USER5        Signed 18.2                               BL130   BL31.1
Element: Intl Amt      User field 5.                             BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-STD-COMM1          Alpha 4                                   BL130   BL31.1
Element: Standard CommeStandard comment code 1. Code for a       BL31.2  BL31.3
                       group of comments.                        BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-STD-COMM2          Alpha 4                                   BL130   BL31.1
Element: Standard CommeStandard comment code 2. Code for a       BL31.2  BL31.3
                       group of comments.                        BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-STD-COMM3          Alpha 4                                   BL130   BL31.1
Element: Standard CommeStandard comment code 3. Code for a       BL31.2  BL31.3
                       group of comments.                        BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-LAST-LINE-NBR      Numeric 6                                 BL130   BL31.1
Element: Line Number   This is the number of the last line       BL31.2  BL31.3
                       item added. It is used to determine the   BL31.5  BL31.7
                       number when the next line is added.       BL32.3  BL32.4

BRC-LAST-MISC-SEQ      Numeric 3                                 BL130   BL31.1
Element: Sequence NumbeLast sequence number for add-on charges   BL31.2  BL31.3
                       for this customer recurring invoice.      BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-LAST-COMM-SEQ      Numeric 3                                 BL130   BL31.1
Element: Sequence NumbeThis is the sequence number of the last   BL31.2  BL31.3
                       comment line entered for this line.       BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BLI2.1

BRC-EP-TYPE            Alpha 5                                   BL130   BL31.1
Element: Ep Type                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-EP-ACCOUNT         Alpha 32                                  BL130   BL31.1
Element: Ep Account                                              BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

BRC-EP-EXP-DATE        Numeric 8  (yyyymmdd)                     BL130   BL31.1
Element: Ep Exp Date                                             BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4

                         BLRICUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BRCSET1   COMPANY                                                BL130   BL231
          RECUR-INVOICE                                          BL30.1  BL30.2
          CUSTOMER                                               BL30.3  BL30.5
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.1
                                                                 BL32.2  BL32.3
                                                                 BL32.4  BL33.1
                                                                 BL330   BL331
                                                                 BL34.1  BLI2.1

                         BLRICUST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            BRC-COMPANY          -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            BRC-COMPANY          -> ACM-COMPANY
                            BRC-CUSTOMER         -> ACM-CUSTOMER

Blricsgblk     BLRICSGBLK   Not Required

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

Cucodes        CUCODES      Not Required
                            Valid When BRC-CURRENCY-CODE != Spaces

                            BRC-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            BRC-CUSTOMER         -> CUD-CUSTOMER

Holdcodes      HOLDCODES    Not Required
                            Valid When BRC-HOLD-CODE != Spaces

                            ACO-CUST-GROUP       -> HDD-CUST-GROUP
                            BRC-HOLD-CODE        -> HDD-HOLD-CODE

Iclocation     ICLOCATION   Required
                            When BRC-LOCATION != Spaces

                            BRC-COMPANY          -> ICL-COMPANY
                            BRC-LOCATION         -> ICL-LOCATION

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

                            BRC-COMPANY          -> OCH-COMPANY
                            BRC-STD-COMM1        -> OCH-STD-COMM

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

                            BRC-COMPANY          -> OCH-COMPANY
                            BRC-STD-COMM2        -> OCH-STD-COMM

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

                            BRC-COMPANY          -> OCH-COMPANY
                            BRC-STD-COMM3        -> OCH-STD-COMM

Oecompany      OECOMPANY    Required

                            BRC-COMPANY          -> OEC-COMPANY

Oemastsrvc     BLRIMAST     Required

                            BRC-COMPANY          -> BRM-COMPANY
                            BRC-RECUR-INVOICE    -> BRM-RECUR-INVOICE

Oeproclev      OEPROCLEV    Required

                            BRC-COMPANY          -> OEP-COMPANY
                            BRC-PROCESS-LEVEL    -> OEP-PROCESS-LEVEL

Salesman       SALESREP     Required
                            When BRC-SALESMAN != Zeroes

                            BRC-COMPANY          -> SAW-COMPANY
                            BRC-SALESMAN         -> SAW-SALESMAN

Salesman 2     SALESREP     Required
                            When BRC-SALESMAN-2 != Zeroes

                            BRC-COMPANY          -> SAW-COMPANY
                            BRC-SALESMAN-2       -> SAW-SALESMAN

Terms          TERMS        Required
                            When BRC-TERMS-CD != Spaces

                            BRC-TERMS-CD         -> TMS-TERMS-CD

Territory      TERITORY     Required
                            When BRC-TERRITORY != Spaces

                            BRC-COMPANY          -> TRY-COMPANY
                            BRC-TERRITORY        -> TRY-TERRITORY

                         BLRICUST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecscomm       BLRICCOMM

                            BRC-COMPANY          -> BUC-COMPANY
                            BRC-RECUR-INVOICE    -> BUC-RECUR-INVOICE
                            BRC-CUSTOMER         -> BUC-CUSTOMER
                            Zeroes               -> BUC-LINE-NBR
                                                    BUC-SEQ

Oecsline       BLRICLINE

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

Oecsmisc       BLRICMISC

                            BRC-COMPANY          -> BUM-COMPANY
                            BRC-RECUR-INVOICE    -> BUM-RECUR-INVOICE
                            BRC-CUSTOMER         -> BUM-CUSTOMER
                            Zeroes               -> BUM-LINE-NBR
                                                    BUM-SEQ

Oecsmisc All   BLRICMISC

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