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.

Field / columnTypeDescription & valuesUpdated by
APM-COMPANY PK
COMPANY		Numeric 4The AR company associated with the payment record.ARLL.1
APM-BATCH-NBR PK
BATCH_NBR		Numeric 6This identifies the batch to which the entered payments belong.ARLL.1
APM-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.ARLL.1
APM-STATUS
STATUS		Numeric 1This 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
CUSTOMER		Alpha 9 (Right Justified)The customer that submitted the payment for application.AR13.1, AR13.2, ARLL.1
APM-BANK-ENTITY
BANK_ENTITY		Alpha 15Represents a bank institution location.—
APM-BANK-ACCT-NBR
BANK_ACCT_NBR		Alpha 35The bank-assigned account number identification.—
APM-GL-DATE
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
TRANS_TYPE		Alpha 1This 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
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.2Base 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.2The amount of the payment that has been applied in company base currency.—
APM-APPLIED-SEQ
APPLIED_SEQ		Numeric 7The total number of applications that have been created with this payment.ARLL.1
APM-REMIT-SEQ
REMIT_SEQ		Numeric 7Total number of remittance records that have been created for this payment.—
APM-DIST-SEQ
DIST_SEQ		Numeric 4Total number of offset General Ledger distributions for type "N" payments (Non-AR cash payment).—
APM-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This 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 9This field will be used to indicate that a payment has been transferred to another customer.—
APM-CASH-CODE
CASH_CODE		Alpha 4Cash 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 4The 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 5Transaction currency. Currency code of the transaction amount of the payment.ARLL.1, CB06.1, CB191
APM-ORIG-RATE
ORIG_RATE		Signed 14.7Exchange 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.2This is the amount of the payment in transaction currency.ARLL.1, CB06.2
APM-BASE-DETAIL
BASE_DETAIL		Signed 18.2This 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.7The 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 1Group 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.2Amount 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 1This 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 1Currency decimal indicator.ARLL.1
APM-PAYMENT-OPEN
PAYMENT_OPEN		DerivedThis field is used as a compute field to calculate open amount.—
APM-TYPE-DSP
TYPE_DSP		DerivedThis field is used as a string field, combining transaction type and transaction number fields for record access.—
APM-PREPAY-FLAG
PREPAY_FLAG		Numeric 1Indicates if payment is a prepayment. Valid values are:
  • 0 Not a Prepay
  • 1 Prepayment
—
APM-CREDIT-APPLD
CREDIT_APPLD		Signed 18.2When 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.2When 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.2Payment adjustment amount in company base currency.—
APM-ORIG-ADJ-AMT
ORIG_ADJ_AMT		Signed 18.2The amount of the payment adjustment in transaction currency.—
APM-CURR-MUDV
CURR_MUDV		Alpha 1Currency 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 2The number of updates from being processed by AR198 Transaction Status Update.—
APM-SELECT-SEQ
SELECT_SEQ		Numeric 6A 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 15The activity associated with the payment record.—
APM-CONTRACT
CONTRACT		Alpha 15The contract associated with the payment record (interfaced from BR).—
APM-ACTIVITY-GRP
ACTIVITY_GRP		Alpha 15The 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APMSET1COMPANY, BATCH-NBR, PAYMENT-SEQPrimary, KeyChangeAR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +22 more (list truncated in source)
APMSET10COMPANY, CUSTOMER, TRANS-TYPE, TRANS-NBR, BATCH-NBRKeyChangeAR10.1, AR301
APMSET11CONTRACT, COMPANY, BATCH-NBR, PAYMENT-SEQSubsetWhere (CONTRACT != Spaces)—
APMSET2COMPANY, BATCH-NBR, TRANS-TYPE, TRANS-NBR, CUSTOMERKeyChangeAR13.1, AR13.2, CB06.1, CB06.2, CB191
APMSET3COMPANY, BANK-ENTITY, BANK-ACCT-NBR, BATCH-NBR, PAYMENT-SEQKeyChange, SubsetWhere TRANS-TYPE = "P" And (CUSTOMER = Spaces Or CUSTOMER = "000000000")AR13.1, AR13.2
APMSET4COMPANY, CASH-CODE, GL-DATE, BATCH-NBR, PAYMENT-SEQKeyChange, SubsetWhere TRANS-TYPE = "P" And STATUS = 2—
APMSET5COMPANY, CASH-CODE, GL-DATE, BATCH-NBR, PAYMENT-SEQKeyChange, SubsetWhere TRANS-TYPE = "N"—
APMSET6COMPANY, CUSTOMER, GL-DATE, BATCH-NBR, PAYMENT-SEQKeyChange, SubsetWhere TRANS-TYPE != "N" And STATUS = 2—
APMSET7TRANS-NBR, CUSTOMER, COMPANY, TRANS-TYPE, BATCH-NBRKeyChangeAR17.1, CB191
APMSET8COMPANY, CUSTOMER, GL-DATE, TRANS-TYPE, TRANS-NBR, BATCH-NBRKeyChange, SubsetWhere (STATUS > 1 And STATUS < 9) And (TRANS-TYPE = "P" Or TRANS-TYPE = "B")—
APMSET9COMPANY, CUSTOMER, GL-DATE, BATCH-NBR, PAYMENT-SEQKeyChange, SubsetWhere (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

One to one (10) — lookups and parents

RelationTableRulesConditionField map
Ar CompanyARCOMPRequiredAPM-COMPANY → ACO-COMPANY
Ar Pymnt HdrARPYMNTHDRRequiredAPM-COMPANY → APH-COMPANY, APM-BATCH-NBR → APH-BATCH-NBR
ArapmufARAPMUFNot Required, Delete CascadesAPM-COMPANY → PUF-COMPANY, APM-BATCH-NBR → PUF-BATCH-NBR, APM-PAYMENT-SEQ → PUF-PAYMENT-SEQ
ArapselectARAPSELECTNot RequiredAPM-COMPANY → AAI-COMPANY, APM-CUSTOMER → AAI-CUSTOMER, APM-BATCH-NBR → AAI-BATCH-NBR, APM-PAYMENT-SEQ → AAI-PAYMENT-SEQ
ArcodeARCODERequiredAPM-COMPANY → RCD-COMPANY, APM-AR-CODE → RCD-AR-CODE
ArmicrcustARMICRCUSTRequiredAPM-COMPANY → AMX-COMPANY, APM-BANK-ENTITY → AMX-BANK-ENTITY, APM-BANK-ACCT-NBR → AMX-BANK-ACCT-NBR
ArproclevlARPROCLEVLRequiredAPM-COMPANY → APV-COMPANY, APM-PROCESS-LEVEL → APV-PROCESS-LEVEL
CustdescCUSTDESCRequiredWhen APM-CUSTOMER != Spaces And APM-CUSTOMER != "000000000"ACO-CUST-GROUP → CUD-CUST-GROUP, APM-CUSTOMER → CUD-CUSTOMER
CustomerARCUSTOMERRequiredWhen APM-CUSTOMER != Spaces And APM-CUSTOMER != "000000000"APM-COMPANY → ACM-COMPANY, APM-CUSTOMER → ACM-CUSTOMER
GmgrantGMGRANTRequiredAPM-GRANT → GRN-GRANT

One to many (9) — child tables

RelationTableRulesConditionField map
AradjustARADJUSTAPM-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
ArappliedARAPPLIEDDelete RestrictedAPM-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
ArcommentARCOMMENTAPM-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
ArmemodistARDISTRIBDelete CascadesValid 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
ArremitARREMITDelete CascadesAPM-COMPANY → RMI-COMPANY, APM-BATCH-NBR → RMI-BATCH-NBR, APM-PAYMENT-SEQ → RMI-PAYMENT-SEQ, → RMI-REMIT-SEQ
ArsadjustARSADJUSTAPM-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
ArsappliedARSAPPLIEDDelete CascadesAPM-COMPANY → ASG-CR-COMPANY, APM-BATCH-NBR → ASG-CR-BATCH, APM-PAYMENT-SEQ → ASG-CR-PYMNT-SEQ, → ASG-SELECT-SEQ
Non Ar DistribARDISTRIBDelete CascadesValid 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
PorebrecdPOREBRECDAPM-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)

Referenced by (103)