ARPAYMENT

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APMSET1 COMPANY
BATCH-NBR
PAYMENT-SEQ
KeyChange
ARLL.1 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521 CB06.1
CB191
APMSET10 COMPANY
CUSTOMER
TRANS-TYPE
TRANS-NBR
BATCH-NBR
KeyChange
AR10.1 AR301
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
WhereTRANS-TYPE ="P"
And(CUSTOMER =Spaces
OrCUSTOMER ="000000000")
AR13.1 AR13.2
APMSET4 COMPANY
CASH-CODE
GL-DATE
BATCH-NBR
PAYMENT-SEQ
KeyChange, Subset
WhereTRANS-TYPE ="P"
AndSTATUS =2
APMSET5 COMPANY
CASH-CODE
GL-DATE
BATCH-NBR
PAYMENT-SEQ
KeyChange, Subset
WhereTRANS-TYPE ="N"
APMSET6 COMPANY
CUSTOMER
GL-DATE
BATCH-NBR
PAYMENT-SEQ
KeyChange, Subset
WhereTRANS-TYPE !="N"
AndSTATUS =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
AndSTATUS <9)
And(TRANS-TYPE ="P"
OrTRANS-TYPE ="B")
APMSET9 COMPANY
CUSTOMER
GL-DATE
BATCH-NBR
PAYMENT-SEQ
KeyChange, Subset
Where(TRANS-TYPE ="P"
OrTRANS-TYPE ="B")
And(STATUS =Zeroes
OrSTATUS =2)
...
AC56.1 AC560
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


ARPAYMENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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
AndAPM-CUSTOMER !="000000000"
ACO-CUST-GROUP->CUD-CUST-GROUP
APM-CUSTOMER->CUD-CUSTOMER
Customer ARCUSTOMER Required
When APM-CUSTOMER !=Spaces
AndAPM-CUSTOMER !="000000000"
APM-COMPANY->ACM-COMPANY
APM-CUSTOMER->ACM-CUSTOMER


ARPAYMENT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:09:06 2016

Home
Contact Us



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