BLINVHDR

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.
UPDATED BY
AR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BLH-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
BLH-BATCH-NBR
Element: Batch Nbr
Numeric 6
This identifies the batch the entered transactions are part of.
BLH-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
BLH-STATUS
Element: Status
Numeric 1
Indicates the status of the batch. Valid values are: 0 = Unreleased 1 = Released
BLH-OPR-CODE
Element: Opr 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-DATE
Element: Batch Date
Numeric 8 (yyyymmdd)
Date of the batch.
BLH-GL-DATE
Element: Posting Date
Numeric 8 (yyyymmdd)
This field contains the general ledger posting date.
BLH-AR-CODE
Element: Ar 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-CURRENCY
Element: Transaction Currency
Alpha 5
Currency code representing the currency of the batch.
BLH-CURR-MUDV
Element: Curr 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-ND
Element: Number of Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BLH-ORIG-RATE
Element: Exchange 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-ENTRY
Element: Invoice Entry Total
Signed 18.2
The total invoice amount for the batch.
BLH-INV-TOTAL
Invoice Control
Total
Signed 18.2
The invoice control total for the batch.
BLH-CREDIT-ENTRY
Credit Memo Entry
Total
Signed 18.2
The total credit memo amount for the batch.
BLH-CREDIT-TOTAL
Credit Memo Control
Total
Signed 18.2
The credit memo control total for the batch.
BLH-DEBIT-ENTRY
Debit Memo Entry
Total
Signed 18.2
The total debit memo amount for the batch.
BLH-DEBIT-TOTAL
Debit Memo Control
Total
Signed 18.2
The debit memo control total for the batch.
BLH-COUNT-ENTRY
Transaction Count
Entry Total
Numeric 5
The total number of transactions in the batch.
BLH-COUNT-TOTAL
Trans Count Control
Total
Numeric 5
The control total for the number of transactions in the batch.


BLINVHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BLHSET1 COMPANY
BATCH-NBR
AR01.1
BLHSET2 COMPANY
PROCESS-LEVEL
BATCH-NBR
Subset
WhereSTATUS =Zeroes
BLHSET3 COMPANY
BATCH-NBR
Subset
WhereSTATUS =Zeroes


BLINVHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcodes ARCODE Required
BLH-COMPANY->RCD-COMPANY (RCDSET1)
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
NAME
RELATED 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


File created: Wed Jun 08 20:47:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.