Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BLINVHDR


                             BLINVHDR FILE

                          AR Transaction Batch

The AR Transaction Batch file contains transaction header records for
manually entered transactions. Each transaction within the batch will
reference or contain values of this transaction header record.

REFERENCED BY

AR01.1    AR242     AR37.7    AR199

UPDATED BY

AR300     AR42.1    AR42.2    AR42.7    AR43.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BLH-COMPANY            Numeric 4                                 AR42.1
Element: Company       Company number.

BLH-BATCH-NBR          Numeric 6                                 AR42.1
Element: Batch Number  This identifies the batch the entered
                       transactions are part of.

BLH-PROCESS-LEVEL      Alpha 5                                   AR42.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

BLH-STATUS             Numeric 1                                 AR42.1  AR42.2
Element: Status        Indicates the status of the batch.        AR42.7  AR43.1
                       Valid values are:

                       0 = Unreleased
                       1 = Released

BLH-OPR-CODE           Alpha 10  (Lower Case)                    AR42.1
Element: Requester     Operator ID code that was entered when
                       adding the batch of invoices. This will
                       either be a valid operator code or the
                       user's signon identification.

BLH-BATCH-DATE         Numeric 8  (yyyymmdd)                     AR42.1
Element: Date          Date of the batch.

BLH-GL-DATE            Numeric 8  (yyyymmdd)                     AR42.1
Element: Posting Date

BLH-AR-CODE            Alpha 4                                   AR42.1
Accounts Receivable    AR code indicating what accounts
Code                   receivable general ledger account will
                       be debited for this batch of manual
                       transactions.

BLH-ORIG-CURRENCY      Alpha 5                                   AR42.1
Element: Transaction CuCurrency code representing the currency
                       of the batch.

BLH-CURR-MUDV          Alpha 1                                   AR42.1
Currency               Currency Multiplier or Divider.
Multiply/Divide        Mathematical technique used in
                       conjunction with the currency rate to
                       convert the transaction currency amount
                       to the company base currency amount.

BLH-ORIG-ND            Numeric 1                                 AR42.1
Element: Number of Decimals

BLH-ORIG-RATE          Signed 12.6                               AR42.1
Element: Exchange Rate Exchange Rate. The rate used to convert
                       a transaction amount from a non-base
                       currency to the company base currency.
                       The rate is maintained in the Currency
                       Relationship file and there is an option
                       at the company level to allow an
                       override of the default rate at entry
                       time.

BLH-INV-ENTRY          Signed 15.2                               AR42.2  AR42.7
Element: Invoice Entry The total invoice amount for the batch.   AR43.1

BLH-INV-TOTAL          Signed 15.2                               AR42.1  AR43.1
Invoice Control        The invoice control total for the
Total                  batch.

BLH-CREDIT-ENTRY       Signed 15.2                               AR42.2  AR42.7
Credit Memo Entry      The total credit memo amount for the      AR43.1
Total                  batch.

BLH-CREDIT-TOTAL       Signed 15.2                               AR42.1  AR43.1
Credit Memo Control    The credit memo control total for the
Total                  batch.

BLH-DEBIT-ENTRY        Signed 15.2                               AR42.2  AR42.7
Debit Memo Entry       The total debit memo amount for the       AR43.1
Total                  batch.

BLH-DEBIT-TOTAL        Signed 15.2                               AR42.1  AR43.1
Debit Memo Control     The debit memo control total for the
Total                  batch.

BLH-COUNT-ENTRY        Numeric 5                                 AR42.2  AR42.7
Transaction Count      The total number of transactions in the   AR43.1
Entry Total            batch.

BLH-COUNT-TOTAL        Numeric 5                                 AR42.1  AR43.1
Trans Count Control    The control total for the number of
Total                  transactions in the batch.

                         BLINVHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BLHSET1   COMPANY       This path is used for record uniqueness  AR01.1  AR242
          BATCH-NBR     and selection.                           AR300   AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.3  AR42.7
                                                                 AR42.8  AR43.1

BLHSET2   COMPANY       This path is used to select unreleased   AR199   AR43.1
          PROCESS-LEVEL records in process level order.
          BATCH-NBR     Subset
                        Where STATUS = Zeroes

BLHSET3   COMPANY       This path is used to select unreleased   AR43.1
          BATCH-NBR     records in batch number order.
                        Subset
                        Where STATUS = Zeroes

                         BLINVHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcodes        ARCODE       Required

                            BLH-COMPANY          -> RCD-COMPANY
                            BLH-AR-CODE          -> RCD-AR-CODE

Company        ARCOMP       Required

                            BLH-COMPANY          -> ACO-COMPANY

Operator       AROPTR       Required
                            When BLH-OPR-CODE != Spaces

                            BLH-COMPANY          -> AOP-COMPANY
                            BLH-OPR-CODE         -> AOP-OPR-CODE

Proces Level   ARPROCLEVL   Required

                            BLH-COMPANY          -> APV-COMPANY
                            BLH-PROCESS-LEVEL    -> APV-PROCESS-LEVEL

                         BLINVHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aroihdr        AROIHDR      Delete Restricted

                            BLH-COMPANY          -> ARH-COMPANY
                            BLH-BATCH-NBR        -> ARH-BATCH-NBR
                                                    ARH-CUSTOMER
                                                    ARH-TRANS-TYPE
                                                    ARH-INVOICE