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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
APH-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | ARLL.1, CB06.2 |
APH-BATCH-NBR PKBATCH_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-LEVELPROCESS_LEVEL | Alpha 5 | This is the process level of the batch. | ARLL.1, CB06.2 |
APH-STATUSSTATUS | Numeric 1 | This is the status of the batch of payments. Valid values are:
| ARLL.1, CB06.2, CB191 |
APH-OPR-CODEOPR_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-DATEDEPOSIT_DATE | Numeric 8 (yyyymmdd) | Deposit date to be recognized for this batch of payments. | ARLL.1, CB06.2 |
APH-GL-DATEGL_DATE | Numeric 8 (yyyymmdd) | General ledger transaction date for posting the entire batch to General Ledger. | ARLL.1, CB06.2 |
APH-CASH-CODECASH_CODE | Alpha 4 | Cash code containing default general ledger cash account. | CB06.2 |
APH-CURRENCY-CDCURRENCY_CD | Alpha 5 | Currency code tied to the cash code entered for the batch. | ARLL.1, CB06.2 |
APH-ORIG-RATEORIG_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-MUDVCURR_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:
| ARLL.1, CB06.2 |
APH-GROUP-RATEGROUP_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-MUDVGROUP_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:
| ARLL.1, CB06.2 |
APH-BASE-CASHBASE_CASH | Signed 18.2 | Total amount of cash in the company base currency for a particular batch. | ARLL.1, CB06.2 |
APH-BASE-RNABASE_RNA | Signed 18.2 | Total amount of the Received Not Applied account valued in the company base currency. | ARLL.1, CB06.2 |
APH-RNA-TOTALRNA_TOTAL | Signed 18.2 | This will contain the transaction currency value of the RNA amount for type "P" payments. | CB06.2 |
APH-LOCK-BOXLOCK_BOX | Alpha 2 | Lock box code identifier for this batch. | — |
APH-LOC-BOX-BATCHLOC_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-TOTALBATCH_TOTAL | Signed 18.2 | Control total representing total amount of payment records in transaction currency for this batch. | ARLL.1 |
APH-BATCH-COUNTBATCH_COUNT | Signed 5.0 | Control total representing total number of payment records within this batch. | ARLL.1 |
APH-ADDTNL-AMTADDTNL_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-UNITACCT_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-ACCOUNTACCOUNT | 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-ACCTSUB_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-TOTALDETAIL_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-COUNTDETAIL_COUNT | Signed 5.0 | Detail count representing actual number of payment records entered in this batch. | ARLL.1, CB06.2 |
APH-LAST-LOG-SEQLAST_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-NDORIG_ND | Numeric 1 | Currency decimal indicator. | ARLL.1, CB06.2 |
APH-REFERENCEREFERENCE | Alpha 10 (Lower Case) | The batch header reference. | ARLL.1 |
APH-NOT-APPLD-CDNOT_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-CODEPRE_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-CODEDEP_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-IDENTTRANS_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-CODEADJ_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-IDNTADJ_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-NBRJRNL_BOOK_NBR | Alpha 12 | This field contains the journal book number for the payment batch header. | ARLL.1, CB06.2 |
APH-RECON-STMT-NBRRECON_STMT_NBR | Numeric 12 | The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements. | CB06.2 |
APH-JBK-SEQ-NBRJBK_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-CODEORIG_CODE | Alpha 1 | — | — |
APH-CB-USER-FIELD1CB_USER_FIELD1 | Alpha 30 | — | — |
APH-CB-USER-FIELD2CB_USER_FIELD2 | Alpha 30 | — | — |
APH-CB-USER-FIELD3CB_USER_FIELD3 | Alpha 30 | — | — |
APH-CB-USER-FIELD4CB_USER_FIELD4 | Alpha 30 | — | — |
Indexes (5)
Keys marked * are descending. 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
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 |
Programs
Updated by (4)
- ARLL.1 AR Transaction Interface
- CB06.1 Bank Statement
- CB06.2 Bank Statement Detail Entry
- CB191 Bank Statement Close