ARPYMNTHDR – Acct Receivables Payment Batch

System: Accounts Receivable (AR)
Prefix: APH
Primary key: COMPANY, BATCH-NBR
Fields: 43
Updated by: 4 programs
Referenced by: 3 programs

ARPYMNTHDR is the Acct Receivables Payment Batch table in Lawson Accounts Receivable (prefix APH). It is indexed by COMPANY, BATCH-NBR (APHSET1); alternate indexes: APHSET2, APHSET3, APHSET4 and APHSET5. It is related 1:1 to ARCOMP, ARLOCKBOX, ARPROCLEVL, AROPTR and ARUPMNTHDR and 1:M to ARPAYMENT. It is updated by ARLL.1, CB06.1, CB06.2 and CB191 and referenced by AR01.1, AR13.1 and AR13.2. The table has 43 fields, 5 indexes and 6 documented relations.

About ARPYMNTHDR

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.

Fields (43)

Column = COBOL field name without the APH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`APH-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	ARLL.1, CB06.2
#`APH-BATCH-NBR` PK 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` PROCESS_LEVEL	Alpha 5	This is the process level of the batch.	ARLL.1, CB06.2
#`APH-STATUS` 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` 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` DEPOSIT_DATE	Numeric 8 (yyyymmdd)	Deposit date to be recognized for this batch of payments.	ARLL.1, CB06.2
#`APH-GL-DATE` SET3 GL_DATE	Numeric 8 (yyyymmdd)	General ledger transaction date for posting the entire batch to General Ledger.	ARLL.1, CB06.2
#`APH-CASH-CODE` CASH_CODE	Alpha 4	Cash code containing default general ledger cash account.	CB06.2
#`APH-CURRENCY-CD` CURRENCY_CD	Alpha 5	Currency code tied to the cash code entered for the batch.	ARLL.1, CB06.2
#`APH-ORIG-RATE` ORIG_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` 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` GROUP_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` 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` BASE_CASH	Signed 18.2	Total amount of cash in the company base currency for a particular batch.	ARLL.1, CB06.2
#`APH-BASE-RNA` BASE_RNA	Signed 18.2	Total amount of the Received Not Applied account valued in the company base currency.	ARLL.1, CB06.2
#`APH-RNA-TOTAL` 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` LOCK_BOX	Alpha 2	Lock box code identifier for this batch.	—
#`APH-LOC-BOX-BATCH` LOC_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` BATCH_TOTAL	Signed 18.2	Control total representing total amount of payment records in transaction currency for this batch.	ARLL.1
#`APH-BATCH-COUNT` BATCH_COUNT	Signed 5.0	Control total representing total number of payment records within this batch.	ARLL.1
#`APH-ADDTNL-AMT` ADDTNL_AMT	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` 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` 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` 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` DETAIL_TOTAL	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` 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` LAST_LOG_SEQ	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` ORIG_ND	Numeric 1	Currency decimal indicator.	ARLL.1, CB06.2
#`APH-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The batch header reference.	ARLL.1
#`APH-NOT-APPLD-CD` NOT_APPLD_CD	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` PRE_PAY_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` SET4 DEP_INST_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` SET4 TRANS_IDENT	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` SET5 ADJ_INST_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` SET5 ADJ_TRANS_IDNT	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` JRNL_BOOK_NBR	Alpha 12	This field contains the journal book number for the payment batch header.	ARLL.1, CB06.2
#`APH-RECON-STMT-NBR` RECON_STMT_NBR	Numeric 12	The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.	CB06.2
#`APH-JBK-SEQ-NBR` 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` ORIG_CODE	Alpha 1	—	—
#`APH-CB-USER-FIELD1` CB_USER_FIELD1	Alpha 30	—	—
#`APH-CB-USER-FIELD2` CB_USER_FIELD2	Alpha 30	—	—
#`APH-CB-USER-FIELD3` CB_USER_FIELD3	Alpha 30	—	—
#`APH-CB-USER-FIELD4` CB_USER_FIELD4	Alpha 30	—	—

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`APHSET1`	`COMPANY` `BATCH-NBR`	Primary		AR01.1, AR13.1, AR13.2, ARLL.1, CB06.1, CB06.2, CB191
`APHSET2`	`COMPANY` `BATCH-NBR`	Subset	Where STATUS = Zeroes	—
`APHSET3`	`COMPANY` `GL-DATE` `BATCH-NBR`	KeyChange		—
`APHSET4`	`DEP-INST-CODE` `TRANS-IDENT`	KeyChange, Subset	Where DEP-INST-CODE != Spaces	—
`APHSET5`	`ADJ-INST-CODE` `ADJ-TRANS-IDNT`	KeyChange, Subset	Where ADJ-INST-CODE != Spaces	—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (5) — lookups and parents

Relation Table Rules Condition Field map

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`

One to many (1) — child tables

Relation Table Rules Condition Field map

Ar Pymnt Detls

ARPAYMENT

Delete Cascades

`APH-COMPANY`	→	`APM-COMPANY`
`APH-BATCH-NBR`	→	`APM-BATCH-NBR`
—	→	`APM-PAYMENT-SEQ`

ARPYMNTHDR – Acct Receivables Payment Batch

About ARPYMNTHDR

Fields (43)

Indexes (5)

Relations

One to one (5) — lookups and parents

One to many (1) — child tables

Programs

Updated by (4)

Referenced by (3)

ARPYMNTHDR – Acct Receivables Payment Batch

About ARPYMNTHDR

Fields (43) Copy as SQL

Indexes (5)

Relations

One to one (5) — lookups and parents

One to many (1) — child tables

Programs

Updated by (4)

Referenced by (3)

Fields (43)