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