AR Payment

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.
UPDATED BY

AC56.1	AC560	AR10.1	AR13.1	AR13.2	AR17.1
AR301	ARLL.1	BR00.1	BR00.2	BR02.3	BR10.1
BR10.9	BR11.1	BR120	BR121	BR122	BR123
BR140	BR151	BR152	BR155	BR156	BR16.1
BR16.2	BR17.1	BR180	BR19.1	BR20.1	BR20.2
BR20.3	BR20.4	BR20.5	BR20.7	BR21.2	BR210
BR211	BR216	BR217	BR220	BR251	BR252
BR253	BR400	BR420	BR45.1	BR450	BR46.1
BR46.2	BR46.4	BR49.1	BR51.1	BR51.2	BR52.1
BR52.2	BR521	BR53.1	BR55.2	BR70.1	BR70.2
BR91.1	BRIP.1	CB06.1	CB06.2	CB191	IC02.1
TX140	TX40.1	WH110	WH120	WH130	WH132
WH190	WH20.1	WH20.2	WH20.7	WH21.2	WH224
WH226	WH30.1	WH30.2	WH30.3	WH30.4	WH31.1
WH31.2	WH31.3	WH31.4	WH32.1	WH32.2	WH32.3
WH32.4	WH32.5	WH33.5	WH34.1	WH34.2	WH34.3
WH34.4	WH40.1	WH40.2	WH520	WH830	ZW130

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
APM-COMPANY Element: Company	Numeric 4 The AR company associated with the payment record.	ARLL.1
APM-BATCH-NBR Element: Batch Number	Numeric 6 This identifies the batch to which the entered payments belong.	ARLL.1
APM-PAYMENT-SEQ Element: Seq Number	Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system.	ARLL.1
APM-STATUS Element: 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 Element: Customer	Alpha 9 (Right Justified) The customer that submitted the payment for application.	AR13.1 AR13.2 ARLL.1
APM-BANK-ENTITY Element: Bank Entity	Alpha 15 Represents a bank institution location.
APM-BANK-ACCT-NBR Element: Bank Acct Nbr	Alpha 35 The bank-assigned account number identification.
APM-GL-DATE Element: Posting 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 Element: Transaction 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 Element: Transaction Number	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 Element: Transaction Amount	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 Element: Applied Amount	Signed 18.2 The amount of the payment that has been applied in company base currency.
APM-APPLIED-SEQ Element: Application Sequence	Numeric 7 The total number of applications that have been created with this payment.	ARLL.1
APM-REMIT-SEQ Element: Remittance Sequence	Numeric 7 Total number of remittance records that have been created for this payment.
APM-DIST-SEQ Distribution Sequence	Numeric 4 Total number of offset General Ledger distributions for type "N" payments (Non-AR cash payment).
APM-PROCESS-LEVEL Element: Process Level	Alpha 5 This is the process level for the payment.	ARLL.1
APM-CANCEL-DATE Element: 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 Element: Transferred Payment	Alpha 9 This field will be used to indicate that a payment has been transferred to another customer.
APM-CASH-CODE Element: 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 Accounts Receivable 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 Element: Transaction Currency	Alpha 5 Transaction currency. Currency code of the transaction amount of the payment.	ARLL.1 CB06.1 CB191
APM-ORIG-RATE Element: Exchange 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 Element: Transaction Amount	Signed 18.2 This is the amount of the payment in transaction currency.	ARLL.1 CB06.2
APM-BASE-DETAIL Element: 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 Element: Group Exchange 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 Multiply/Divide	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 Element: Last Statement Date	Numeric 8 (yyyymmdd) Date of the last statement on which this payment appeared.
APM-ORIG-APP-AMT Element: Payment Amount	Signed 18.2 Amount applied against the payment in the payment's transaction currency.
APM-AR-REFERENCE Element: Ar Reference	Alpha 22 (Lower Case) The reference number for this payment.	ARLL.1
APM-REF-TYPE Element: Reference 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 Element: Number of Decimals	Numeric 1 Currency decimal indicator.	ARLL.1
APM-PAYMENT-OPEN Element: Payment Open	Derived This field is used as a compute field to calculate open amount.
APM-TYPE-DSP Element: Type Display	Derived This field is used as a string field, combining transaction type and transaction number fields for record access.
APM-PREPAY-FLAG Element: Prepay Flag	Numeric 1 Indicates if payment is a prepayment. Valid values are: 0 = Not a Prepay 1 = Prepayment
APM-CREDIT-APPLD Credit Application Amount	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 Credit Trans Applied Amount	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 Element: Adjust Amount	Signed 18.2 Payment adjustment amount in company base currency.
APM-ORIG-ADJ-AMT Transaction Adjust Amount	Signed 18.2 The amount of the payment adjustment in transaction currency.
APM-CURR-MUDV Element: 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 Element: Hist Per	Numeric 2 The number of updates from being processed by AR198 Transaction Status Update.
APM-SELECT-SEQ Element: 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 Element: Last Fc Date	Numeric 8 (yyyymmdd) The date of the last late payment charge assessed against this payment.
APM-DEPOSIT-DATE Element: Deposit Date	Numeric 8 (yyyymmdd) The deposit date of the payment.	ARLL.1
APM-OPR-CODE Element: Opr Code	Alpha 10 (Lower Case) This field contains the user's login code during the transfer payment process.
APM-ACTIVITY Element: Activity	Alpha 15 The activity associated with the payment record.
APM-CONTRACT Element: Contract	Alpha 15 The contract associated with the payment record (interfaced from BR).
APM-ACTIVITY-GRP Element: Activity Grp	Alpha 15 The activity group associated with the payment record.
APM-TRANSFER-DATE Element: Date	Numeric 8 (yyyymmdd)
APM-NA-LST-ST-DATE Element: Na Lst St Date	Numeric 8 (yyyymmdd)
APM-TRANS-FRM-CUST Element: Customer	Alpha 9 (Right Justified)
APM-TRANSFER-AMT Element: Intl Amt	Signed 18.2
APM-ORIG-CODE Element: Orig Code	Alpha 1

ARPAYMENT FILE INDEX

ARPAYMENT FILE RELATIONS

ONE TO ONE RELATIONS

ARPAYMENT FILE RELATIONS

ONE TO MANY RELATIONS

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