BLINVHDR – AR Transaction Batch
- System
- Accounts Receivable (AR)
- Prefix
BLH- Primary key
COMPANY,BATCH-NBR- Fields
- 20
- Updated by
- 0 programs
- Referenced by
- 0 programs
BLINVHDR is the AR Transaction Batch table in Lawson Accounts Receivable (prefix BLH). It is indexed by COMPANY, BATCH-NBR (BLHSET1); alternate indexes: BLHSET2 and BLHSET3. It is related 1:1 to ARCODE, ARCOMP, AROPTR and ARPROCLEVL and 1:M to AROIHDR. The table has 20 fields, 3 indexes and 5 documented relations.
About BLINVHDR
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.
Fields (20)
Column = COBOL field name without the BLH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BLH-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | — |
#BLH-BATCH-NBR PKBATCH_NBR | Numeric 6 | This identifies the batch the entered transactions are part of. | — |
#BLH-PROCESS-LEVEL SET2PROCESS_LEVEL | Alpha 5 | This field contains the process level, which is the reporting hierarchy below company. | — |
#BLH-STATUSSTATUS | Numeric 1 | Indicates the status of the batch. Valid values are:
| — |
#BLH-OPR-CODEOPR_CODE | Alpha 10 (Lower Case) | 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-DATEBATCH_DATE | Numeric 8 (yyyymmdd) | Date of the batch. | — |
#BLH-GL-DATEGL_DATE | Numeric 8 (yyyymmdd) | This field contains the general ledger posting date. | — |
#BLH-AR-CODEAR_CODE | Alpha 4 | 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-CURRENCYORIG_CURRENCY | Alpha 5 | Currency code representing the currency of the batch. | — |
#BLH-CURR-MUDVCURR_MUDV | Alpha 1 | 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-NDORIG_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
#BLH-ORIG-RATEORIG_RATE | Signed 14.7 | 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-ENTRYINV_ENTRY | Signed 18.2 | The total invoice amount for the batch. | — |
#BLH-INV-TOTALINV_TOTAL | Signed 18.2 | The invoice control total for the batch. | — |
#BLH-CREDIT-ENTRYCREDIT_ENTRY | Signed 18.2 | The total credit memo amount for the batch. | — |
#BLH-CREDIT-TOTALCREDIT_TOTAL | Signed 18.2 | The credit memo control total for the batch. | — |
#BLH-DEBIT-ENTRYDEBIT_ENTRY | Signed 18.2 | The total debit memo amount for the batch. | — |
#BLH-DEBIT-TOTALDEBIT_TOTAL | Signed 18.2 | The debit memo control total for the batch. | — |
#BLH-COUNT-ENTRYCOUNT_ENTRY | Numeric 5 | The total number of transactions in the batch. | — |
#BLH-COUNT-TOTALCOUNT_TOTAL | Numeric 5 | The control total for the number of transactions in the batch. | — |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
BLHSET1 |
| Primary | AR01.1, ARLL.1 | |
BLHSET2 |
| Subset | Where STATUS = Zeroes | — |
BLHSET3 |
| Subset | Where STATUS = Zeroes | — |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Arcodes | ARCODE | Required |
| |||||||
| Company | ARCOMP | Required |
| |||||||
| Operator | AROPTR | Required | When BLH-OPR-CODE != Spaces |
| ||||||
| Proces Level | ARPROCLEVL | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aroihdr | AROIHDR | Delete Restricted |
|
Programs
No Lawson programs are documented as updating or referencing this table.