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 in AR42.1 Transaction Header. Each transaction within the
batch will  reference or contain values of this transaction header record.

REFERENCED BY

AR01.1    AR242     AR37.7    ARLL.1    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       The number representing an AR company.

BLH-BATCH-NBR          Numeric 6                                 AR42.1
Element: Batch Nbr     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: Opr Code      Operator ID code that was entered when
                       adding the batch of invoices. This will
                       either be a valid operator code (if the
                       corresponding company requires operator
                       control for transaction input), or the
                       user's signon identification.

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

BLH-GL-DATE            Numeric 8  (yyyymmdd)                     AR42.1
Element: Posting Date  This field contains the general ledger
                       posting date.

BLH-AR-CODE            Alpha 4                                   AR42.1
Element: Ar Code       AR code indicating what accounts
                       receivable general ledger account will
                       be debited (or credited if the batch has
                       more credits than invoices and debit
                       memos) 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
Element: Curr Mudv     Currency Multiplier or Divider.
                       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 DeciThe number of decimals assigned to a
                       particular account as determined by the
                       account currency.


BLH-ORIG-RATE          Signed 14.7                               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 18.2                               AR42.2  AR42.7
Element: Invoice Entry The total invoice amount for the batch.   AR43.1

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

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

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

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

BLH-DEBIT-TOTAL        Signed 18.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                                                AR01.1  AR242
          BATCH-NBR                                              AR300   AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.3  AR42.7
                                                                 AR42.8  AR43.1
                                                                 ARLL.1

BLHSET2   COMPANY       Subset                                   AR199   AR43.1
          PROCESS-LEVEL Where STATUS = Zeroes
          BATCH-NBR

BLHSET3   COMPANY       Subset                                   AR43.1
          BATCH-NBR     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