ARPYMNTHDR

AR Payment Batch

The AR Payment Batch file contains the batch header information for payments entered into the system. Batch header records include balancing controls, transaction dates, currency indicators and other information regarding all payments in that batch.

REFERENCED BY
AR13.1 AR13.2


UPDATED BY
AR01.1 ARLL.1 CB06.1 CB06.2 CB191

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APH-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ARLL.1 CB06.2
APH-BATCH-NBR
Element: Batch Nbr
Numeric 6
This is the identifying number of a group of payments within a company. There is a company option to have this number assigned automatically or manually entered.
ARLL.1 CB06.2
APH-PROCESS-LEVEL
Element: Process Level
Alpha 5
This is the process level of the batch.
ARLL.1 CB06.2
APH-STATUS
Element: Status
Numeric 1
This is the status of the batch of payments. Valid values are: 0 = Open batch - unreleased 1 = Released batch
ARLL.1 CB06.2
CB191
APH-OPR-CODE
Element: Opr Code
Alpha 10 (Lower Case)
This will contain the operator code of the individual entering cash. This will either be a valid operator code or the individual's signon identification.
ARLL.1 CB06.2
APH-DEPOSIT-DATE
Element: Deposit Date
Numeric 8 (yyyymmdd)
Deposit date to be recognized for this batch of payments.
ARLL.1 CB06.2
APH-GL-DATE
Element: Posting Date
Numeric 8 (yyyymmdd)
General ledger transaction date for posting the entire batch to General Ledger.
ARLL.1 CB06.2
APH-CASH-CODE
Element: Cash Code
Alpha 4
Cash code containing default general ledger cash account.
CB06.2
APH-CURRENCY-CD
Element: Currency Code
Alpha 5
Currency code tied to the cash code entered for the batch.
ARLL.1 CB06.2
APH-ORIG-RATE
Element: Exchange Rate
Signed 14.7
The rate used to convert a transaction amount from a non-base currency to the company base currency.
ARLL.1 CB06.2
APH-CURR-MUDV
Element: Curr Mudv
Alpha 1
Currency Multiplier or Divider. Mathematical technique used in conjunction with the currency exchange rate to convert the transaction currency amount to the company base currency amount. Valid values are: D = Divide M = Multiply
ARLL.1 CB06.2
APH-GROUP-RATE
Element: Group Exchange Rate
Signed 14.7
The rate used to convert a transaction amount from a currency that differs from the customer group currency to the customer group currency.
ARLL.1 CB06.2
APH-GROUP-MUDV
Element: Group Mudv
Alpha 1
Group Currency Multiplier or Divider. Mathematical technique used in conjunction with the group currency exchange rate to convert the company base currency amount to the group currency amount. Valid values are: D = Divide M = Multiply
ARLL.1 CB06.2
APH-BASE-CASH
Element: Base Cash Amount
Signed 18.2
Total amount of cash in the company base currency for a particular batch.
ARLL.1 CB06.2
APH-BASE-RNA
Element: Base RNA Amount
Signed 18.2
Total amount of the Received Not Applied account valued in the company base currency.
ARLL.1 CB06.2
APH-RNA-TOTAL
Element: RNA Total
Signed 18.2
This will contain the transaction currency value of the RNA amount for type "P" payments.
CB06.2
APH-LOCK-BOX
Element: Lock Box
Alpha 2
Lock box code identifier for this batch.
APH-LOC-BOX-BATCH
Element: Lock Box Batch
Numeric 3
This will be the batch number from the lock box interface batch header record. It will be for reference purposes only.
APH-BATCH-TOTAL
Element: Intl Amt
Signed 18.2
Control total representing total amount of payment records in transaction currency for this batch.
ARLL.1
APH-BATCH-COUNT
Element: Batch Count
Signed 5.0
Control total representing total number of payment records within this batch.
ARLL.1
APH-ADDTNL-AMT
Element: Additional Amount
Signed 18.2
This will hold any additional charges that may have been incurred from the bank. This has no affect on the total amount of cash in the batch. Example: A charge for currency exchange transactions may be entered on the batch header screen. The offset general ledger account entered will be debited, and the general ledger cash account will be credited.
APH-ACCT-UNIT
Element: Acct Unit
Alpha 15
This will be the accounting unit that the additional charges will be posted to. The offset will be the cash account of that batch.
APH-ACCOUNT
Element: Account
Numeric 6
This will be the account that the additional charges will be posted to. The offset will be the cash account of that batch.
APH-SUB-ACCT
Element: Sub Acct
Numeric 4
This will be the sub-account the additional charges will be posted to. The offset will be the cash account of that batch.
APH-DETAIL-TOTAL
Element: Intl Amt
Signed 18.2
Detail total representing actual total of payment records in transaction currency entered for this batch.
ARLL.1 CB06.2
APH-DETAIL-COUNT
Element: Detail Count
Signed 5.0
Detail count representing actual number of payment records entered in this batch.
ARLL.1 CB06.2
APH-LAST-LOG-SEQ
Element: Seq Number
Numeric 6
Sequence counter representing order of record input within a batch. This field is used for sequential batch reviews and record uniqueness.
ARLL.1
APH-ORIG-ND
Element: Number of Decimals
Numeric 1
Currency decimal indicator.
ARLL.1 CB06.2
APH-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The batch header reference.
ARLL.1
APH-NOT-APPLD-CD
Element: RNA Code
Alpha 4
The default received not applied GL code. The general ledger account represented by this code will be debited for each payment applied, if a prepayment GL code is not present for that payment.
ARLL.1 CB06.2
APH-PRE-PAY-CODE
Element: Prepayment Code
Alpha 4
The default prepayment GL code. The general ledger account represented by this code will be debited for each payment applied, if a received not applied GL code is not present for that payment.
ARLL.1
APH-DEP-INST-CODE
Deposit Bank
Transaction Code
Alpha 3
The deposit bank transaction code of the payment header. It must exist in the Lawson Cash Ledger system.
ARLL.1 CB06.2
CB191
APH-TRANS-IDENT
Element: Transaction ID
Numeric 10
A unique CB system-generated identification value assigned to the transaction to make the interface CB deposit transaction record unique.
ARLL.1 CB06.2
CB191
APH-ADJ-INST-CODE
Adjustment Bank
Trans Code
Alpha 3
The adjustment bank transaction code of the payment header. It must be set up in the Lawson Cash Ledger system.
CB191
APH-ADJ-TRANS-IDNT
Adjustment Trans ID
Code
Numeric 10
A unique CB system-generated identification value assigned to the transaction to make the interface adjustment CB transaction record unique.
CB191
APH-JRNL-BOOK-NBR
Element: Journal Book Number
Alpha 12
This field contains the journal book number for the payment batch header.
ARLL.1 CB06.2
APH-RECON-STMT-NBR
Bank Statement
Number
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
CB06.2
APH-JBK-SEQ-NBR
Element: Jbk Seq Nbr
Numeric 10
The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).
CB06.2
APH-ORIG-CODE
Element: Orig Code
Alpha 1
APH-CB-USER-FIELD1
Element: User Field1
Alpha 30
APH-CB-USER-FIELD2
Element: User Field1
Alpha 30
APH-CB-USER-FIELD3
Element: User Field1
Alpha 30
APH-CB-USER-FIELD4
Element: User Field1
Alpha 30


ARPYMNTHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APHSET1 COMPANY
BATCH-NBR
AR01.1 AR13.1
AR13.2 ARLL.1
CB06.1 CB06.2
CB191
APHSET2 COMPANY
BATCH-NBR
Subset
WhereSTATUS =Zeroes
APHSET3 COMPANY
GL-DATE
BATCH-NBR
KeyChange
APHSET4 DEP-INST-CODE
TRANS-IDENT
KeyChange, Subset
WhereDEP-INST-CODE !=Spaces
APHSET5 ADJ-INST-CODE
ADJ-TRANS-IDNT
KeyChange, Subset
WhereADJ-INST-CODE !=Spaces


ARPYMNTHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ar Company ARCOMP Required
APH-COMPANY->ACO-COMPANY (ACOSET1)
Ar Lock Box ARLOCKBOX Required
When APH-LOCK-BOX !=Spaces
APH-LOCK-BOX->ARL-LOCK-BOX
Ar Process Lvl ARPROCLEVL Required
APH-COMPANY->APV-COMPANY
APH-PROCESS-LEVEL->APV-PROCESS-LEVEL
Aroptr AROPTR Required
When APH-OPR-CODE !=Spaces
APH-COMPANY->AOP-COMPANY
APH-OPR-CODE->AOP-OPR-CODE
Arupmnthdr ARUPMNTHDR Not Required
APH-COMPANY->UPH-COMPANY
APH-BATCH-NBR->UPH-BATCH-NBR


ARPYMNTHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ar Pymnt Detls ARPAYMENT Delete Cascades
APH-COMPANY->APM-COMPANY
APH-BATCH-NBR->APM-BATCH-NBR
  APM-PAYMENT-SEQ


File created: Thu Jun 09 11:09:07 2016

Home
Contact Us



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