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