|
|
BLINVHDR FILE
AR Transaction Batch
AR Transaction Batch
REFERENCED BY
AR01.1 AR242 AR37.7 AR199
UPDATED BY
AR300 AR42.1 AR42.2 AR42.7 AR43.1 AR952
AR976
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BLH-COMPANY Numeric 4 AR42.1 AR952
Company Company number. AR976
BLH-BATCH-NBR Numeric 6 AR42.1 AR952
Batch Number This identifies the batch the entered AR976
transactions are part of.
BLH-PROCESS-LEVEL Alpha 5 AR42.1 AR952
Process Level This field contains the process level, AR976
which is the reporting hierarchy below
company.
BLH-STATUS Numeric 1 AR42.1 AR42.2
Status Indicates the status of the batch. AR42.7 AR43.1
Valid values are: AR952 AR976
0 = Unreleased
1 = Released
BLH-OPR-CODE Alpha 10 (Lower Case) AR42.1 AR952
Operator Code Operator ID code that was entered when AR976
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 AR952
Batch Date Date of the batch. AR976
BLH-GL-DATE Numeric 8 (yyyymmdd) AR42.1 AR952
Posting Date This field contains the general ledger AR976
posting date.
BLH-AR-CODE Alpha 4 AR42.1 AR952
Accounts Receivable AR code indicating what accounts AR976
Code receivable general ledger account will
be debited for this batch of manual
transactions.
BLH-ORIG-CURRENCY Alpha 5 AR42.1 AR952
Transaction Currency Currency code representing the currency AR976
of the batch.
BLH-CURR-MUDV Alpha 1 AR42.1 AR952
Currency Currency Multiplier or Divider. AR976
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 AR952
Number of Decimals Currency decimal indicator. AR976
BLH-ORIG-RATE Signed 12.6 AR42.1 AR952
Exchange Rate Exchange Rate. The rate used to convert AR976
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
Invoice Entry Total The total invoice amount for the batch. AR43.1 AR952
AR976
BLH-INV-TOTAL Signed 15.2 AR42.1 AR43.1
Invoice Control The invoice control total for the AR952 AR976
Total batch.
BLH-CREDIT-ENTRY Signed 15.2 AR42.2 AR42.7
Credit Memo Entry The total credit memo amount for the AR43.1 AR976
Total batch.
BLH-CREDIT-TOTAL Signed 15.2 AR42.1 AR43.1
Credit Memo Control The credit memo control total for the AR976
Total batch.
BLH-DEBIT-ENTRY Signed 15.2 AR42.2 AR42.7
Debit Memo Entry The total debit memo amount for the AR43.1 AR976
Total batch.
BLH-DEBIT-TOTAL Signed 15.2 AR42.1 AR43.1
Debit Memo Control The debit memo control total for the AR976
Total batch.
BLH-COUNT-ENTRY Numeric 5 AR42.2 AR42.7
Transaction Count The total number of transactions in the AR43.1 AR952
Entry Total batch. AR976
BLH-COUNT-TOTAL Numeric 5 AR42.1 AR43.1
Trans Count Control The control total for the number of AR952 AR976
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-TRANS-NBR
|