Lawson Insight Technical Documentation |
|
ARPAYMENT
ARPAYMENT FILE
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.
REFERENCED BY
AR132 AR191 AR220 AR222 AR223 AR228
AR229 AR230 AR233 AR235 AR239 AR256
AR257 AR27.2 AR27.1 AR286 AR287 AR36.1
AR36.2 AR525 BR02.3 BR120 BR121 BR122
BR123 BR140 BR151 BR152 BR156 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR20.7 BR420
BR521 AR10.1 AR251 AR252 AR253 AR255
AR282 AR294 AR301 AR53.1 AR90.1 AR232
AR237 AR258 AR194 AR250 AR505 AR17.1
AR271 AR275 AR520 AC56.1 AC560 AR219
AR50.1 BL02.1 BL04.1 BL10.1 BL120 BL121
BL122 BL123 BL125 BL130 BL20.1 BL20.3
BL20.6 BL202 BL204 BL21.2 BL21.5 BL217
BL220 BL231 BL246 BL29.1 BL29.2 BL290
BL291 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7
BL32.3 BL32.4 BL33.1 BL331 BL34.1 BL46.1
BL46.2 BL520 BL530 BL546 BL80.1 BL80.3
BL802 BL81.1 BL82.1 BL820 BL85.1 BL85.2
BL90.1 BL92.1 BR00.1 BR00.2 BR10.1 BR10.9
BR11.1 BR155 BR16.1 BR16.2 BR17.1 BR180
BR19.1 BR21.2 BR210 BR211 BR216 BR217
BR220 BR251 BR252 BR253 BR400 BR45.1
BR450 BR46.1 BR46.2 BR46.4 BR51.1 BR51.2
BR52.1 BR52.2 BR53.1 BR55.2 BR70.1 BR70.2
BR91.1 BRIP.1 IC02.1 PW110 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 WH33.5
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830
UPDATED BY
AR115 AR124 AR129 AR13.1 AR13.2 AR130
AR131 AR135 AR137 AR150 AR180 AR190
AR198 AR20.1 AR21.1 AR21.2 AR21.3 AR21.4
AR21.5 AR21.6 AR24.1 AR28.1 AR28.2 AR29.1
AR29.2 AR30.1 AR30.2 AR30.8 AR32.1 AR33.1
AR33.3 AR33.5 AR33.6 AR34.1 AR35.1 AR35.2
AR37.1 AR37.2 AR37.3 AR37.4 AR37.5 AR37.6
AR37.7 AR39.1 AR39.2 AR42.1 AR42.2 AR42.6
AR42.7 AR43.1 AR44.3 AR48.3 AR502 AR503
AR504 AR560 AR570 AR575 AR580 AR80.1
AR80.2 AR82.1 ARLL.1 CB06.1 CB06.2 CB191
DT150 DT155 DT160 DT165 DT166 DT180
DT30.1 DT30.2 DT40.1 DT45.1 DT520 DT60.1
DT60.2 DT70.1 DT70.3 DT80.1 DT85.1 DT85.2
DT92.1 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APM-COMPANY Numeric 4 AR115 AR21.1
Element: Company The AR company associated with the AR21.2 AR21.3
payment record. AR21.4 AR28.1
AR29.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-BATCH-NBR Numeric 6 AR115 AR21.1
Element: Batch Number This identifies the batch to which the AR21.2 AR21.3
entered payments belong. AR21.4 AR28.1
AR29.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-PAYMENT-SEQ Numeric 6 AR115 AR21.1
Element: Seq Number A unique number assigned to each AR21.2 AR21.3
transaction to be interfaced into the AR21.4 AR28.1
Lawson system. AR29.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-STATUS Numeric 1 AR115 AR124
Element: Status This status indicates where the payment AR129 AR13.1
is in the processing flow. Valid values AR13.2 AR130
are: AR131 AR135
AR180 AR198
0 = Unreleased AR20.1 AR21.1
1 = Release, Unassigned AR21.2 AR21.3
2 = Open Payment AR24.1 AR28.1
7 = Applied AR29.1 AR29.2
8 = Closed AR30.1 AR30.8
9 = Historical AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR80.1
AR80.2 AR82.1
ARLL.1 CB191
DT150 DT155
DT160 DT165
...
APM-CUSTOMER Alpha 9 (Right Justified) AR115 AR13.1
Element: Customer The customer that submitted the payment AR13.2 AR21.1
for application. AR21.2 AR21.4
AR28.1 AR29.1
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-BANK-ENTITY Alpha 15 AR21.1 AR28.1
Element: Bank Entity Represents a bank institution location. AR570 AR575
APM-BANK-ACCT-NBR Alpha 35 AR21.1 AR28.1
Element: Bank Acct Nbr The bank-assigned account number AR570 AR575
identification.
APM-GL-DATE Numeric 8 (yyyymmdd) AR115 AR20.1
Element: Posting Date This is the date used for posting to AR21.1 AR21.2
general ledger. It will also be used in AR21.3 AR21.4
determining the "as of" aging of AR29.1 AR29.2
applications. AR30.1 AR32.1
AR34.1 AR37.3
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
ARLL.1 CB06.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-TRANS-TYPE Alpha 1 AR115 AR21.1
Element: Transaction TyThis field indicates the payment type of AR21.2 AR21.3
the transaction. Valid values are: AR21.4 AR29.1
Non-AR Payments AR29.2 AR30.1
Customer Payment AR32.1 AR34.1
BOE Payment AR42.1 AR42.2
N = Non-AR payment AR42.6 AR42.7
P = Customer Payment AR43.1 AR44.3
B = BOE Payment AR502 AR503
AR560 AR570
AR575 AR580
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
APM-TRANS-NBR Alpha 10 (Right Justified) AR115 AR21.1
Element: Transaction NuThis is the payment number for the AR21.2 AR21.3
transaction. This can be a check number, AR21.4 AR29.1
wire transfer number, or any other AR29.2 AR30.1
number that identifies the transaction. AR32.1 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
APM-TRAN-AMT Signed 18.2 AR115 AR124
Element: Transaction AmBase transaction amount. Transaction AR20.1 AR21.1
amount of the payment record in the AR21.2 AR21.3
company base currency. AR21.4 AR21.6
AR24.1 AR28.1
AR29.1 AR29.2
AR30.1 AR32.1
AR34.1 AR35.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
AR90.1 ARLL.1
CB06.1 CB06.2
CB191 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
APM-APPLD-AMT Signed 18.2 AR129 AR130
Element: Applied AmountThe amount of the payment that has been AR131 AR135
applied in company base currency. AR180 AR29.1
AR29.2 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR39.1
AR39.2 AR44.3
AR48.3 AR503
AR504 AR80.1
AR80.2 DT150
DT92.1
APM-APPLIED-SEQ Numeric 7 AR129 AR130
Element: Application SeThe total number of applications that AR131 AR135
have been created with this payment. AR180 AR29.1
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.2 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR504
AR560 AR80.1
AR80.2 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-REMIT-SEQ Numeric 7 AR21.2 AR21.4
Element: Remittance SeqTotal number of remittance records that AR21.5 AR21.6
have been created for this payment. AR29.1 AR570
AR575 AR580
APM-DIST-SEQ Numeric 4 AR190 AR21.3
Distribution Total number of offset General Ledger AR29.1 AR29.2
Sequence distributions for type "N" payments
(Non-AR cash payment).
APM-PROCESS-LEVEL Alpha 5 AR115 AR21.1
Element: Process Level This is the process level for the AR21.2 AR21.3
payment. AR21.4 AR29.1
AR29.2 AR30.1
AR32.1 AR34.1
AR35.1 AR37.3
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
APM-CANCEL-DATE Numeric 8 (yyyymmdd) AR29.1 AR29.2
Element: Cancel Date This is the date the payment was AR82.1
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 Alpha 9 AR29.1 AR29.2
Element: Transferred PaThis field will be used to indicate
that a payment has been transferred to
another customer.
APM-CASH-CODE Alpha 4 AR115 AR21.1
Element: Cash Code Cash code containing currency indicator AR21.2 AR21.3
and general ledger cash account. This AR21.4 AR29.1
account will be debited with the total AR29.2 AR30.1
amount of all payments in a batch. AR32.1 AR34.1
AR37.3 AR503
AR570 AR575
AR580
APM-AR-CODE Alpha 4 AR115 AR21.1
Accounts The received not applied code or AR21.2 AR21.3
Receivable Code prepayment code assigned to this AR21.4 AR21.6
payment. This account is credited when AR29.1 AR29.2
payments are entered, and debited when AR30.1 AR32.1
payments are applied. AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-ORIG-CURRENCY Alpha 5 AR115 AR124
Element: Transaction CuTransaction currency. Currency code of AR20.1 AR21.1
the transaction amount of the payment. AR21.2 AR21.3
AR21.4 AR24.1
AR29.1 AR29.2
AR30.1 AR32.1
AR34.1 AR37.3
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
ARLL.1 CB06.1
CB191 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
APM-ORIG-RATE Signed 14.7 AR115 AR124
Element: Exchange Rate Exchange rate. This is the rate used to AR20.1 AR21.1
convert a transaction amount from a AR21.2 AR21.3
non-base currency to the company base AR21.4 AR24.1
currency. The rate is maintained in the AR29.1 AR29.2
currency relation file. AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 ARLL.1
CB06.1 CB191
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-ORIG-AMT Signed 18.2 AR115 AR20.1
Element: Transaction AmThis is the amount of the payment in AR21.1 AR21.2
transaction currency. AR21.3 AR21.4
AR21.6 AR29.1
AR29.2 AR30.1
AR32.1 AR34.1
AR37.3 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR90.1
ARLL.1 CB06.2
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-BASE-DETAIL Signed 18.2 AR20.1 AR21.3
Element: Base Detail This field will be updated with the AR29.1 AR29.2
converted base amount for all AR570 AR575
distributions for any Non-AR payments. AR580
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 Signed 14.7 AR115 AR21.1
Element: Group ExchangeThe rate used to convert a transaction AR21.2 AR21.4
amount from a currency that differs from AR29.1 AR29.2
the base currency to the group currency. AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-GROUP-MUDV Alpha 1 AR115 AR21.1
Group Group Currency Multiplier or Divider. AR21.2 AR21.4
Multiply/Divide Mathematical technique used in AR29.1 AR29.2
conjunction with the currency rate to AR30.1 AR32.1
convert the company base currency amount AR34.1 AR42.1
to the group currency amount. AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
APM-LAST-STA-DATE Numeric 8 (yyyymmdd) AR150 AR503
Element: Last StatementDate of the last statement on which
this payment appeared.
APM-ORIG-APP-AMT Signed 18.2 AR129 AR130
Element: Payment AmountAmount applied against the payment in AR131 AR135
the payment's transaction currency. AR180 AR29.1
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.6
AR34.1 AR35.1
AR37.3 AR39.1
AR39.2 AR44.3
AR48.3 AR503
AR504 AR80.1
AR80.2 DT150
DT92.1
APM-AR-REFERENCE Alpha 22 (Lower Case) AR115 AR21.2
Element: Ar Reference The reference number for this payment. AR21.6 AR29.1
AR29.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR575 AR580
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
APM-REF-TYPE Alpha 1 AR21.2 AR21.6
Element: Reference TypeThis field is used along with the AR29.1 AR29.2
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 Numeric 1 AR115 AR21.1
Element: Number of DeciCurrency decimal indicator. AR21.2 AR21.3
AR21.4 AR29.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
APM-PAYMENT-OPEN Derived
Element: Payment Open This field is used as a compute field to
calculate open amount.
APM-TYPE-DSP Derived
Element: Type Display This field is used as a string field,
combining transaction type and
transaction number fields for record
access.
APM-PREPAY-FLAG Numeric 1 AR115 AR21.2
Element: Prepay Flag Indicates if payment is a prepayment. AR21.6 AR29.1
Valid values are: AR29.2
0 = Not a Prepay
1 = Prepayment
APM-CREDIT-APPLD Signed 18.2 AR115 AR130
Credit Application When a payment is applied to a credit AR180 AR30.1
Amount memo, the amount of the application will AR30.8 AR32.1
be stored in theis field. AR33.3 AR34.1
AR35.1 AR504
AR80.1 AR80.2
APM-ORIG-CR-APPLD Signed 18.2 AR115 AR130
Credit Trans When a payment is applied to a credit AR180 AR30.1
Applied Amount memo, the amount of application in the AR30.8 AR32.1
currency of the transaction will be AR33.3 AR34.1
stored in this field. AR35.1 AR504
AR80.1 AR80.2
APM-ADJ-AMT Signed 18.2 AR129 AR130
Element: Adjust Amount Payment adjustment amount in company AR131 AR135
base currency. AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
AR39.1 AR39.2
AR48.3 AR504
AR80.1 AR80.2
APM-ORIG-ADJ-AMT Signed 18.2 AR129 AR130
Transaction Adjust The amount of the payment adjustment in AR131 AR135
Amount transaction currency. AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
AR39.1 AR39.2
AR48.3 AR504
AR80.1 AR80.2
APM-CURR-MUDV Alpha 1 AR115 AR21.1
Element: Curr Mudv Currency Multiplier or Divider. This is AR21.2 AR21.3
used along with the currency rate to AR21.4 AR29.1
compute the company base transaction AR29.2 AR30.1
amount. Valid values are: AR32.1 AR34.1
AR503 AR570
M = Multiply AR575 AR580
D = Divide
APM-HIST-PER Numeric 2 AR180 AR198
Element: Hist Per The number of updates from being AR29.2 AR80.1
processed by AR198 Transaction Status AR80.2
Update.
APM-SELECT-SEQ Numeric 6 AR115 AR30.1
Element: Select Seq A counter used to keep track of the AR30.2 AR32.1
order of cash applications for this AR34.1
payment until temporary application
records have been processed.
APM-LAST-FC-DATE Numeric 8 (yyyymmdd) AR137 AR29.1
Element: Last Fc Date The date of the last late payment charge
assessed against this payment.
APM-DEPOSIT-DATE Numeric 8 (yyyymmdd) AR115 AR20.1
Element: Deposit Date The deposit date of the payment. AR21.1 AR21.2
AR21.3 AR21.4
AR29.1 AR29.2
AR30.1 AR32.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
APM-OPR-CODE Alpha 10 (Lower Case) AR29.1 AR29.2
Element: Opr Code This field contains the user's login AR30.1 AR32.1
code during the transfer payment
process.
APM-ACTIVITY Alpha 15 AR21.2 AR28.1
Element: Activity The activity associated with the payment AR28.2 AR29.1
record. AR32.1 AR503
AR575
APM-CONTRACT Alpha 15 AR21.2 AR28.1
Element: Contract The contract associated with the payment AR28.2 AR29.1
record (interfaced from BR). AR32.1 AR503
AR575
APM-ACTIVITY-GRP Alpha 15 AR21.2 AR28.1
Element: Activity Grp The activity group associated with the AR28.2 AR29.1
payment record. AR32.1 AR503
AR575
ARPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APMSET1 COMPANY KeyChange AR115 AR124
BATCH-NBR AR129 AR130
PAYMENT-SEQ AR131 AR132
AR135 AR137
AR150 AR180
AR190 AR191
AR20.1 AR21.1
AR21.2 AR21.3
AR21.4 AR21.5
AR21.6 AR220
AR222 AR223
AR228 AR229
AR230 AR233
AR235 AR239
AR24.1 AR256
...
APMSET10 COMPANY KeyChange AR10.1 AR229
CUSTOMER AR251 AR252
TRANS-TYPE AR253 AR255
TRANS-NBR AR28.7 AR282
BATCH-NBR AR286 AR287
AR29.2 AR294
AR301 AR33.1
AR53.1 AR90.1
DT520
APMSET11 COMPANY KeyChange AR300
PAYMENT-SEQ
BATCH-NBR
APMSET2 COMPANY KeyChange AR115 AR124
BATCH-NBR AR13.1 AR13.2
TRANS-TYPE AR130 AR132
TRANS-NBR AR191 AR20.1
CUSTOMER AR21.1 AR21.2
AR21.3 AR21.4
AR229 AR232
AR233 AR237
AR24.1 AR251
AR28.1 AR28.2
AR282 AR29.1
AR29.2 AR30.1
AR32.1 AR33.1
AR33.6 AR34.1
AR35.1 AR35.2
...
APMSET3 COMPANY KeyChange, Subset AR13.1 AR13.2
BANK-ENTITY Where TRANS-TYPE = "P" AR258 AR28.1
BANK-ACCT-NBR And (CUSTOMER = Spaces
BATCH-NBR Or CUSTOMER = "000000000" )
PAYMENT-SEQ
APMSET4 COMPANY KeyChange, Subset AR258 AR28.2
CASH-CODE Where TRANS-TYPE = "P"
GL-DATE And STATUS = 2
BATCH-NBR
PAYMENT-SEQ
APMSET5 COMPANY KeyChange, Subset AR28.5 AR28.6
CASH-CODE Where TRANS-TYPE = "N"
GL-DATE
BATCH-NBR
PAYMENT-SEQ
APMSET6 COMPANY KeyChange, Subset AR129 AR130
CUSTOMER Where TRANS-TYPE != "N" AR135 AR137
GL-DATE And STATUS = 2 AR150 AR194
BATCH-NBR AR223 AR250
PAYMENT-SEQ AR251 AR252
AR253 AR255
AR33.1 AR48.1
AR505
APMSET7 TRANS-NBR KeyChange AR17.1 AR230
CUSTOMER AR27.1 AR28.3
COMPANY AR28.4 AR504
TRANS-TYPE AR90.1 CB191
BATCH-NBR
APMSET8 COMPANY KeyChange, Subset AR137 AR150
CUSTOMER Where (STATUS > 1 AR194 AR198
GL-DATE And STATUS < 9 ) AR250 AR251
TRANS-TYPE And (TRANS-TYPE = "P" AR252 AR253
TRANS-NBR Or TRANS-TYPE = "B" ) AR255 AR271
BATCH-NBR AR275 AR520
APMSET9 COMPANY KeyChange, Subset AC56.1 AC560
CUSTOMER Where (TRANS-TYPE = "P" AR219 AR48.1
GL-DATE Or TRANS-TYPE = "B" ) AR48.3 AR50.1
BATCH-NBR And (STATUS = Zeroes AR90.1 BL02.1
PAYMENT-SEQ Or STATUS = 2 ) BL04.1 BL10.1
BL120 BL121
BL122 BL123
BL125 BL130
BL20.1 BL20.3
BL20.6 BL202
BL204 BL21.2
BL21.5 BL217
BL220 BL231
BL246 BL29.1
BL29.2 BL290
...
ARPAYMENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
Arprepay ARPREPAY Not Required, Delete Cascades
APM-COMPANY -> APY-COMPANY
APM-BATCH-NBR -> APY-BATCH-NBR
APM-PAYMENT-SEQ -> APY-PAYMENT-SEQ
Arproclevl ARPROCLEVL Required
APM-COMPANY -> APV-COMPANY
APM-PROCESS-LEVEL -> APV-PROCESS-LEVEL
Arrtm1 ARRTM Not Required, Delete Cascades
APM-COMPANY -> RTM-COMPANY
APM-CUSTOMER -> RTM-CUSTOMER
APM-TRANS-NBR -> RTM-TRANS-NBR
APM-BATCH-NBR -> RTM-BATCH-NBR
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
ARPAYMENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
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
|