Acct Receivables 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.
REFERENCED BY
AR13.1 | AR13.2 | ARLL.1 | CB06.1 | CB06.2 | CB191 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
APM-COMPANY Element: Company | Numeric 4 The AR company associated with the payment record. |
|
||||
APM-BATCH-NBR Element: Batch Number | Numeric 6 This identifies the batch to which the entered payments belong. |
|
||||
APM-PAYMENT-SEQ Element: Seq Number | Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system. |
|
||||
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 |
|
||||
APM-CUSTOMER Element: Customer | Alpha 9 (Right Justified) The customer that submitted the payment for application. |
|
||||
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. |
|
||||
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 |
|
||||
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. |
|
||||
APM-TRAN-AMT Element: Transaction Amount | Signed 18.2 Base transaction amount. Transaction amount of the payment record in the company base currency. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
APM-ORIG-CURRENCY Element: Transaction Currency | Alpha 5 Transaction currency. Currency code of the transaction amount of the payment. |
|
||||
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. |
|
||||
APM-ORIG-AMT Element: Transaction Amount | Signed 18.2 This is the amount of the payment in transaction currency. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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 |
|
||||
APM-GRANT Element: Grant | Alpha 30 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
APMSET1 |
COMPANY BATCH-NBR PAYMENT-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
APMSET10 |
COMPANY CUSTOMER TRANS-TYPE TRANS-NBR BATCH-NBR |
|
| ||||||||||||||||||||||||||||||||||||
APMSET11 |
CONTRACT COMPANY BATCH-NBR PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||||||||
APMSET2 |
COMPANY BATCH-NBR TRANS-TYPE TRANS-NBR CUSTOMER |
|
| ||||||||||||||||||||||||||||||||||||
APMSET3 |
COMPANY BANK-ENTITY BANK-ACCT-NBR BATCH-NBR PAYMENT-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
APMSET4 |
COMPANY CASH-CODE GL-DATE BATCH-NBR PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||||||||
APMSET5 |
COMPANY CASH-CODE GL-DATE BATCH-NBR PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||||||||
APMSET6 |
COMPANY CUSTOMER GL-DATE BATCH-NBR PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||||||||
APMSET7 |
TRANS-NBR CUSTOMER COMPANY TRANS-TYPE BATCH-NBR |
|
| ||||||||||||||||||||||||||||||||||||
APMSET8 |
COMPANY CUSTOMER GL-DATE TRANS-TYPE TRANS-NBR BATCH-NBR |
|
|||||||||||||||||||||||||||||||||||||
APMSET9 |
COMPANY CUSTOMER GL-DATE BATCH-NBR PAYMENT-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Ar Company | ARCOMP |
Required
| ||||||||||||||||||
Ar Pymnt Hdr | ARPYMNTHDR |
Required
| ||||||||||||||||||
Arapmuf | ARAPMUF |
Not Required, Delete Cascades
| ||||||||||||||||||
Arapselect | ARAPSELECT |
Not Required
| ||||||||||||||||||
Arcode | ARCODE |
Required
| ||||||||||||||||||
Armicrcust | ARMICRCUST |
Required
| ||||||||||||||||||
Arproclevl | ARPROCLEVL |
Required
| ||||||||||||||||||
Custdesc | CUSTDESC |
Required
| ||||||||||||||||||
Customer | ARCUSTOMER |
Required
| ||||||||||||||||||
Gmgrant | GMGRANT |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Aradjust | ARADJUST |
| |||||||||||||||||||||||||||
Arapplied | ARAPPLIED |
Delete Restricted
| |||||||||||||||||||||||||||
Arcomment | ARCOMMENT |
| |||||||||||||||||||||||||||
Armemodist | ARDISTRIB |
Delete Cascades
| |||||||||||||||||||||||||||
Arremit | ARREMIT |
Delete Cascades
| |||||||||||||||||||||||||||
Arsadjust | ARSADJUST |
| |||||||||||||||||||||||||||
Arsapplied | ARSAPPLIED |
Delete Cascades
| |||||||||||||||||||||||||||
Non Ar Distrib | ARDISTRIB |
Delete Cascades
| |||||||||||||||||||||||||||
Porebrecd | POREBRECD |
|
All trademarks and registered trademarks are the property of their
respective owners.