ARPAYMENT – Acct Receivables Payment

System: Accounts Receivable (AR)
Prefix: APM
Primary key: COMPANY, BATCH-NBR, PAYMENT-SEQ
Fields: 53
Updated by: 6 programs
Referenced by: 103 programs

ARPAYMENT is the Acct Receivables Payment table in Lawson Accounts Receivable (prefix APM). It is indexed by COMPANY, BATCH-NBR, PAYMENT-SEQ (APMSET1); alternate indexes: APMSET10, APMSET11, APMSET2, APMSET3, APMSET4, APMSET5, APMSET6, APMSET7 and 2 more. It is related 1:1 to ARCOMP, ARPYMNTHDR, ARAPMUF, ARAPSELECT, ARCODE, ARMICRCUST, ARPROCLEVL, CUSTDESC and 2 more and 1:M to ARADJUST, ARAPPLIED, ARCOMMENT, ARDISTRIB, ARREMIT, ARSADJUST, ARSAPPLIED and POREBRECD. It is updated by AR13.1, AR13.2, ARLL.1, CB06.1, CB06.2 and CB191 and referenced by AC56.1, AC560, AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2 and 95 more. The table has 53 fields, 11 indexes and 19 documented relations.

About ARPAYMENT

The AR Payment file will contain the detail payment records entered for a given payment batch. There are several online and interface programs to input payment records. A payment record identifies an amount in original and company base currency, to be used to apply to invoices, credit memos, and debit memos. All payment type records will be contained in this file including Non-AR type payments.

Fields (53)

Column = COBOL field name without the APM- 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
#`APM-COMPANY` PK COMPANY	Numeric 4	The AR company associated with the payment record.	ARLL.1
#`APM-BATCH-NBR` PK BATCH_NBR	Numeric 6	This identifies the batch to which the entered payments belong.	ARLL.1
#`APM-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	ARLL.1
#`APM-STATUS` STATUS	Numeric 1	This status indicates where the payment is in the processing flow. Valid values are: `0` Unreleased `1` Release, Unassigned `2` Open Payment `7` Applied `8` Closed `9` Historical	AR13.1, AR13.2, ARLL.1, CB191
#`APM-CUSTOMER` SET10 SET2 SET6 SET7 SET8 SET9 CUSTOMER	Alpha 9 (Right Justified)	The customer that submitted the payment for application.	AR13.1, AR13.2, ARLL.1
#`APM-BANK-ENTITY` SET3 BANK_ENTITY	Alpha 15	Represents a bank institution location.	—
#`APM-BANK-ACCT-NBR` SET3 BANK_ACCT_NBR	Alpha 35	The bank-assigned account number identification.	—
#`APM-GL-DATE` SET4 SET5 SET6 SET8 SET9 GL_DATE	Numeric 8 (yyyymmdd)	This is the date used for posting to general ledger. It will also be used in determining the "as of" aging of applications.	ARLL.1, CB06.1
#`APM-TRANS-TYPE` SET10 SET2 SET7 SET8 TRANS_TYPE	Alpha 1	This field indicates the payment type of the transaction. Valid values are: Non-AR Payments Customer Payment BOE Payment `N` Non-AR payment `P` Customer Payment `B` BOE Payment	ARLL.1
#`APM-TRANS-NBR` SET10 SET2 SET7 SET8 TRANS_NBR	Alpha 10 (Right Justified)	This is the payment number for the transaction. This can be a check number, wire transfer number, or any other number that identifies the transaction.	ARLL.1
#`APM-TRAN-AMT` TRAN_AMT	Signed 18.2	Base transaction amount. Transaction amount of the payment record in the company base currency.	ARLL.1, CB06.1, CB06.2, CB191
#`APM-APPLD-AMT` APPLD_AMT	Signed 18.2	The amount of the payment that has been applied in company base currency.	—
#`APM-APPLIED-SEQ` APPLIED_SEQ	Numeric 7	The total number of applications that have been created with this payment.	ARLL.1
#`APM-REMIT-SEQ` REMIT_SEQ	Numeric 7	Total number of remittance records that have been created for this payment.	—
#`APM-DIST-SEQ` DIST_SEQ	Numeric 4	Total number of offset General Ledger distributions for type "N" payments (Non-AR cash payment).	—
#`APM-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	This is the process level for the payment.	ARLL.1
#`APM-CANCEL-DATE` CANCEL_DATE	Numeric 8 (yyyymmdd)	This is the date the payment was identified as being canceled. The payment is no longer available for application. If the transferred customer field is blank, the cancellation was a Return-to-maker (RTM) payment. If the transferred customer has a value, the cancellation was a transfer to another customer.	—
#`APM-TRNS-CUST` TRNS_CUST	Alpha 9	This field will be used to indicate that a payment has been transferred to another customer.	—
#`APM-CASH-CODE` SET4 SET5 CASH_CODE	Alpha 4	Cash code containing currency indicator and general ledger cash account. This account will be debited with the total amount of all payments in a batch.	—
#`APM-AR-CODE` AR_CODE	Alpha 4	The received not applied code or prepayment code assigned to this payment. This account is credited when payments are entered, and debited when payments are applied.	ARLL.1
#`APM-ORIG-CURRENCY` ORIG_CURRENCY	Alpha 5	Transaction currency. Currency code of the transaction amount of the payment.	ARLL.1, CB06.1, CB191
#`APM-ORIG-RATE` ORIG_RATE	Signed 14.7	Exchange rate. This is 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 relation file.	ARLL.1, CB06.1, CB191
#`APM-ORIG-AMT` ORIG_AMT	Signed 18.2	This is the amount of the payment in transaction currency.	ARLL.1, CB06.2
#`APM-BASE-DETAIL` BASE_DETAIL	Signed 18.2	This field will be updated with the converted base amount for all distributions for any Non-AR payments. The system will match this amount against the converted total amount of the payment. If differences occur due to rounding during currency conversion, the system will automatically adjust the amount of the last distribution to make the total base amount of the distributions equal to the base transactions.	—
#`APM-GROUP-RATE` GROUP_RATE	Signed 14.7	The rate used to convert a transaction amount from a currency that differs from the base currency to the group currency.	ARLL.1
#`APM-GROUP-MUDV` GROUP_MUDV	Alpha 1	Group Currency Multiplier or Divider. Mathematical technique used in conjunction with the currency rate to convert the company base currency amount to the group currency amount.	ARLL.1
#`APM-LAST-STA-DATE` LAST_STA_DATE	Numeric 8 (yyyymmdd)	Date of the last statement on which this payment appeared.	—
#`APM-ORIG-APP-AMT` ORIG_APP_AMT	Signed 18.2	Amount applied against the payment in the payment's transaction currency.	—
#`APM-AR-REFERENCE` AR_REFERENCE	Alpha 22 (Lower Case)	The reference number for this payment.	ARLL.1
#`APM-REF-TYPE` REF_TYPE	Alpha 1	This field is used along with the Reference field. It indicates the specific type of transaction of the reference field. Valid values are: `I` Invoice `O` Order `D` Debit Memo `B` Billing Invoice `C` Credit Memo `N` Non-Lawson `M` Mixed	—
#`APM-ORIG-ND` ORIG_ND	Numeric 1	Currency decimal indicator.	ARLL.1
#`APM-PAYMENT-OPEN` PAYMENT_OPEN	Derived	This field is used as a compute field to calculate open amount.	—
#`APM-TYPE-DSP` TYPE_DSP	Derived	This field is used as a string field, combining transaction type and transaction number fields for record access.	—
#`APM-PREPAY-FLAG` PREPAY_FLAG	Numeric 1	Indicates if payment is a prepayment. Valid values are: `0` Not a Prepay `1` Prepayment	—
#`APM-CREDIT-APPLD` CREDIT_APPLD	Signed 18.2	When a payment is applied to a credit memo, the amount of the application will be stored in theis field.	—
#`APM-ORIG-CR-APPLD` ORIG_CR_APPLD	Signed 18.2	When a payment is applied to a credit memo, the amount of application in the currency of the transaction will be stored in this field.	—
#`APM-ADJ-AMT` ADJ_AMT	Signed 18.2	Payment adjustment amount in company base currency.	—
#`APM-ORIG-ADJ-AMT` ORIG_ADJ_AMT	Signed 18.2	The amount of the payment adjustment in transaction currency.	—
#`APM-CURR-MUDV` CURR_MUDV	Alpha 1	Currency Multiplier or Divider. This is used along with the currency rate to compute the company base transaction amount. Valid values are: `M` Multiply `D` Divide	—
#`APM-HIST-PER` HIST_PER	Numeric 2	The number of updates from being processed by AR198 Transaction Status Update.	—
#`APM-SELECT-SEQ` SELECT_SEQ	Numeric 6	A counter used to keep track of the order of cash applications for this payment until temporary application records have been processed.	—
#`APM-LAST-FC-DATE` LAST_FC_DATE	Numeric 8 (yyyymmdd)	The date of the last late payment charge assessed against this payment.	—
#`APM-DEPOSIT-DATE` DEPOSIT_DATE	Numeric 8 (yyyymmdd)	The deposit date of the payment.	ARLL.1
#`APM-OPR-CODE` OPR_CODE	Alpha 10 (Lower Case)	This field contains the user's login code during the transfer payment process.	—
#`APM-ACTIVITY` ACTIVITY	Alpha 15	The activity associated with the payment record.	—
#`APM-CONTRACT` SET11 CONTRACT	Alpha 15	The contract associated with the payment record (interfaced from BR).	—
#`APM-ACTIVITY-GRP` ACTIVITY_GRP	Alpha 15	The activity group associated with the payment record.	—
#`APM-TRANSFER-DATE` TRANSFER_DATE	Numeric 8 (yyyymmdd)	—	—
#`APM-NA-LST-ST-DATE` NA_LST_ST_DATE	Numeric 8 (yyyymmdd)	—	—
#`APM-TRANS-FRM-CUST` TRANS_FRM_CUST	Alpha 9 (Right Justified)	—	—
#`APM-TRANSFER-AMT` TRANSFER_AMT	Signed 18.2	—	—
#`APM-ORIG-CODE` ORIG_CODE	Alpha 1	—	—
#`APM-GRANT` GRANT	Alpha 30	—	—

Indexes (11)

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
`APMSET1`	`COMPANY` `BATCH-NBR` `PAYMENT-SEQ`	Primary, KeyChange		AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +22 more (list truncated in source)
`APMSET10`	`COMPANY` `CUSTOMER` `TRANS-TYPE` `TRANS-NBR` `BATCH-NBR`	KeyChange		AR10.1, AR301
`APMSET11`	`CONTRACT` `COMPANY` `BATCH-NBR` `PAYMENT-SEQ`	Subset	Where (CONTRACT != Spaces)	—
`APMSET2`	`COMPANY` `BATCH-NBR` `TRANS-TYPE` `TRANS-NBR` `CUSTOMER`	KeyChange		AR13.1, AR13.2, CB06.1, CB06.2, CB191
`APMSET3`	`COMPANY` `BANK-ENTITY` `BANK-ACCT-NBR` `BATCH-NBR` `PAYMENT-SEQ`	KeyChange, Subset	Where TRANS-TYPE = "P" And (CUSTOMER = Spaces Or CUSTOMER = "000000000")	AR13.1, AR13.2
`APMSET4`	`COMPANY` `CASH-CODE` `GL-DATE` `BATCH-NBR` `PAYMENT-SEQ`	KeyChange, Subset	Where TRANS-TYPE = "P" And STATUS = 2	—
`APMSET5`	`COMPANY` `CASH-CODE` `GL-DATE` `BATCH-NBR` `PAYMENT-SEQ`	KeyChange, Subset	Where TRANS-TYPE = "N"	—
`APMSET6`	`COMPANY` `CUSTOMER` `GL-DATE` `BATCH-NBR` `PAYMENT-SEQ`	KeyChange, Subset	Where TRANS-TYPE != "N" And STATUS = 2	—
`APMSET7`	`TRANS-NBR` `CUSTOMER` `COMPANY` `TRANS-TYPE` `BATCH-NBR`	KeyChange		AR17.1, CB191
`APMSET8`	`COMPANY` `CUSTOMER` `GL-DATE` `TRANS-TYPE` `TRANS-NBR` `BATCH-NBR`	KeyChange, Subset	Where (STATUS > 1 And STATUS < 9) And (TRANS-TYPE = "P" Or TRANS-TYPE = "B")	—
`APMSET9`	`COMPANY` `CUSTOMER` `GL-DATE` `BATCH-NBR` `PAYMENT-SEQ`	KeyChange, Subset	Where (TRANS-TYPE = "P" Or TRANS-TYPE = "B") And (STATUS = Zeroes Or STATUS = 2)	AC56.1, AC560, BR00.1, BR00.2, BR02.3, BR10.1, BR10.9, BR11.1 +22 more (list truncated in source)

Relations

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

One to one (10) — lookups and parents

Relation Table Rules Condition Field map

Ar Company

ARCOMP

Required

APM-COMPANY → ACO-COMPANY

Ar Pymnt Hdr

ARPYMNTHDR

Required

`APM-COMPANY`	→	`APH-COMPANY`
`APM-BATCH-NBR`	→	`APH-BATCH-NBR`

Arapmuf

ARAPMUF

Not Required, Delete Cascades

`APM-COMPANY`	→	`PUF-COMPANY`
`APM-BATCH-NBR`	→	`PUF-BATCH-NBR`
`APM-PAYMENT-SEQ`	→	`PUF-PAYMENT-SEQ`

Arapselect

ARAPSELECT

Not Required

`APM-COMPANY`	→	`AAI-COMPANY`
`APM-CUSTOMER`	→	`AAI-CUSTOMER`
`APM-BATCH-NBR`	→	`AAI-BATCH-NBR`
`APM-PAYMENT-SEQ`	→	`AAI-PAYMENT-SEQ`

Arcode

ARCODE

Required

`APM-COMPANY`	→	`RCD-COMPANY`
`APM-AR-CODE`	→	`RCD-AR-CODE`

Armicrcust

ARMICRCUST

Required

`APM-COMPANY`	→	`AMX-COMPANY`
`APM-BANK-ENTITY`	→	`AMX-BANK-ENTITY`
`APM-BANK-ACCT-NBR`	→	`AMX-BANK-ACCT-NBR`

Arproclevl

ARPROCLEVL

Required

`APM-COMPANY`	→	`APV-COMPANY`
`APM-PROCESS-LEVEL`	→	`APV-PROCESS-LEVEL`

Custdesc

CUSTDESC

Required

When APM-CUSTOMER != Spaces And APM-CUSTOMER != "000000000"

`ACO-CUST-GROUP`	→	`CUD-CUST-GROUP`
`APM-CUSTOMER`	→	`CUD-CUSTOMER`

Customer

ARCUSTOMER

Required

When APM-CUSTOMER != Spaces And APM-CUSTOMER != "000000000"

`APM-COMPANY`	→	`ACM-COMPANY`
`APM-CUSTOMER`	→	`ACM-CUSTOMER`

Gmgrant

GMGRANT

Required

APM-GRANT → GRN-GRANT

One to many (9) — child tables

Relation Table Rules Condition Field map

Aradjust

ARADJUST

`APM-COMPANY`	→	`ADJ-COMPANY`
`APM-TRANS-TYPE`	→	`ADJ-TRANS-TYPE`
`APM-TRANS-NBR`	→	`ADJ-INVOICE`
`APM-PAYMENT-SEQ`	→	`ADJ-PAYMENT-SEQ`
`APM-BATCH-NBR`	→	`ADJ-BATCH-NBR`
—	→	`ADJ-APP-SEQ`
—	→	`ADJ-ADJ-SEQ`

Arapplied

ARAPPLIED

Delete Restricted

`APM-COMPANY`	→	`ARA-CR-COMPANY`
`APM-BATCH-NBR`	→	`ARA-CR-BATCH`
`APM-PAYMENT-SEQ`	→	`ARA-CR-PYMNT-SEQ`
—	→	`ARA-COMPANY`
—	→	`ARA-TRANS-TYPE`
—	→	`ARA-INVOICE`
—	→	`ARA-PAYMENT-SEQ`
—	→	`ARA-BATCH-NBR`
—	→	`ARA-APP-SEQ`

Arcomment

ARCOMMENT

`APM-COMPANY`	→	`CMT-COMPANY`
`APM-CUSTOMER`	→	`CMT-CUSTOMER`
`"T"`	→	`CMT-CMMT-TYPE`
`APM-TRANS-TYPE`	→	`CMT-TRANS-TYPE`
`APM-TRANS-NBR`	→	`CMT-INVOICE`
—	→	`CMT-BEG-DATE`
—	→	`CMT-SEQ-NUMBER`

Armemodist

ARDISTRIB

Delete Cascades

Valid When APM-TRANS-TYPE = "P"

`APM-COMPANY`	→	`AMD-COMPANY`
`APM-BATCH-NBR`	→	`AMD-BATCH-NBR`
`APM-TRANS-TYPE`	→	`AMD-TRANS-TYPE`
`APM-TRANS-NBR`	→	`AMD-INVOICE`
`APM-CUSTOMER`	→	`AMD-CUSTOMER`
—	→	`AMD-DIST-SEQ`

Arremit

ARREMIT

Delete Cascades

`APM-COMPANY`	→	`RMI-COMPANY`
`APM-BATCH-NBR`	→	`RMI-BATCH-NBR`
`APM-PAYMENT-SEQ`	→	`RMI-PAYMENT-SEQ`
—	→	`RMI-REMIT-SEQ`

Arsadjust

ARSADJUST

`APM-COMPANY`	→	`ASJ-COMPANY`
`APM-TRANS-TYPE`	→	`ASJ-TRANS-TYPE`
`APM-TRANS-NBR`	→	`ASJ-INVOICE`
`APM-PAYMENT-SEQ`	→	`ASJ-PAYMENT-SEQ`
`APM-BATCH-NBR`	→	`ASJ-BATCH-NBR`
—	→	`ASJ-ADJ-SEQ`

Arsapplied

ARSAPPLIED

Delete Cascades

`APM-COMPANY`	→	`ASG-CR-COMPANY`
`APM-BATCH-NBR`	→	`ASG-CR-BATCH`
`APM-PAYMENT-SEQ`	→	`ASG-CR-PYMNT-SEQ`
—	→	`ASG-SELECT-SEQ`

Non Ar Distrib

ARDISTRIB

Delete Cascades

Valid When APM-TRANS-TYPE = "N"

`APM-COMPANY`	→	`AMD-COMPANY`
`APM-BATCH-NBR`	→	`AMD-BATCH-NBR`
`APM-TRANS-TYPE`	→	`AMD-TRANS-TYPE`
`APM-TRANS-NBR`	→	`AMD-INVOICE`
—	→	`AMD-CUSTOMER`
—	→	`AMD-DIST-SEQ`

Porebrecd

POREBRECD

`APM-COMPANY`	→	`RRC-COMPANY`
`APM-BATCH-NBR`	→	`RRC-AR-BATCH-NBR`
`APM-TRANS-NBR`	→	`RRC-AR-INVOICE`
—	→	`RRC-CONTRACT-GROUP`
—	→	`RRC-CM-CONTRACT`
—	→	`RRC-REBATE-TYPE`
—	→	`RRC-DUE-DATE`
—	→	`RRC-REBATE-SEQ`

Programs

Updated by (6)

AR13.1 MICR Customer
AR13.2 Customer MICR
ARLL.1 AR Transaction Interface
CB06.1 Bank Statement
CB06.2 Bank Statement Detail Entry
CB191 Bank Statement Close

Referenced by (103)

AC56.1 Setup Interface Adjustment
AC560 Setup Interface
AR09.1 Customer Group Address
AR09.4 Bill To
AR10.1 Customer
AR11.1 Customer Contacts
AR12.1 National Account
AR12.2 National Account Speed Entry
AR17.1 Comments
AR210 Customer Listing
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
BR00.1 Activity Billing
BR00.2 Billing Detail
BR02.3 Retainer Invoice Entry
BR10.1 Contract Parameters
BR10.9 Product Contract Parameters
BR11.1 Customer
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR140 Billing and Revenue Backout
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR155 Maintenance Schedule Copy
BR156 Maintenance Quote
BR16.1 Service Location
BR16.2 Customer Maintenance Renew Date
BR17.1 Bill To Group
BR180 Location Vertex Geocode Update
BR19.1 Single Invoice Calculation
BR20.1 Invoice Edit Contract
BR20.2 Invoice Edit Line
BR20.3 Invoice Edit Activity
BR20.4 Invoice Edit Activity and Account Category
BR20.5 Invoice Edit Transaction
BR20.7 Invoice Header
BR21.2 Filter
BR210 Contract Listing
BR211 Activity Customer Listing
BR216 Service Location Listing
BR217 Bill To Group Listing
BR220 Invoice Audit Listing
BR251 Product Contract Listing
BR252 Maintenance Schedule Listing
BR253 Deferred Revenue Listing
BR400 Invoice History
BR420 Billing Invoice Report
BR45.1 Invoice Control
BR450 Activity Aging
BR46.1 Bill in Advance
BR46.2 Transfer Invoice Transaction
BR46.4 Split Transfer
BR49.1 Invoice Adjustment Maintenance
BR51.1 Product Contract
BR51.2 Product Cost of Goods Sold
BR52.1 Maintenance Schedule
BR52.2 New Maintenance Schedule
BR521 Billing Import
BR53.1 Product Deferred Revenue Schedule
BR55.2 Filter
BR70.1 Product Contract Interface Adjustment
BR70.2 Product Interface Cost of Goods Sold
BR91.1 Contract By Customer Inquiry
BRIP.1 Invoice Print Program
IC02.1 Location
TX140 Vertex Geocode Update
TX40.1 Tax Inquiry for Vertex
WH110 Batch Allocation
WH120 Route Creation
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH20.1 Inventoried Allocation
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location
WH21.2 Stops
WH224 Packing List Print
WH226 Items on Backorder Report
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.5 Additional Shipment Information
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program

ARPAYMENT – Acct Receivables Payment

About ARPAYMENT

Fields (53) Copy as SQL

Indexes (11)

Relations

One to one (10) — lookups and parents

One to many (9) — child tables

Programs

Updated by (6)

Referenced by (103)

Fields (53)