ARPAYMENT FILE
AR Payment
AR Payment
REFERENCED BY
AR132 AR191 AR220 AR222 AR228 AR229
AR230 AR233 AR235 AR256 AR286 AR287
AR36.1 AR36.2 AR80.1 AR80.2 AR10.1 AR251
AR252 AR253 AR255 AR282 AR294 AR301
AR53.1 AR90.1 AR232 CB733 AR258 AR194
AR505 AR17.1 AR27.1 OE292 AR250 AR271
AR275 AC115 AC15.2 AC450 AR50.1 BL02.1
BL02.2 BL04.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL202 BL204 BL21.2
BL21.5 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 BL80.1 BL80.3 BL802
BL81.1 BL820 BL85.1 BL85.2 BL90.1 BL902
BL92.1 BL940 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE112 OE113 OE114
OE129 OE130 OE14.3 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE230 OE254
OE260 OE270 OE271 OE272 OE284 OE285
OE286 OE290 OE291 OE293 OE294 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE330 OE510 OE53.1 OE54.1 OE60.1
OE80.1 OE80.2 OE81.1 OE81.2 OE810 OE830
OE85.1 OE90.1 OE90.2 OE920 OE950 PBIP.1
SA03.1 SA100 SA252 SA254 SA256 SA261
SA271 SA281 SA291 SA300 SA80.2 SA90.2
TX140 TX40.1 WH110 WH120 WH130 WH132
WH190 WH20.2 WH20.7 WH21.2 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830
UPDATED BY
AR115 AR124 AR13.1 AR13.2 AR130 AR131
AR135 AR137 AR150 AR180 AR190 AR199
AR20.1 AR21.1 AR21.2 AR21.3 AR21.4 AR21.5
AR21.6 AR24.1 AR28.1 AR29.1 AR29.2 AR30.1
AR30.2 AR30.3 AR30.4 AR30.8 AR300 AR31.5
AR31.6 AR35.1 AR35.2 AR37.1 AR37.2 AR37.3
AR37.4 AR37.5 AR37.6 AR37.7 AR42.1 AR42.2
AR42.6 AR42.7 AR43.1 AR44.3 AR502 AR503
AR504 AR560 AR570 AR575 AR580 AR82.1
AR952 AR974 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APM-COMPANY Numeric 4 AR115 AR21.1
Company Company number. AR21.2 AR21.3
AR21.4 AR28.1
AR29.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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
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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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-SEQ-NBR Numeric 4 AR115 AR21.1
Sequence Number Input sequence number of payment record AR21.2 AR21.3
within a batch. AR21.4 AR28.1
AR29.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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
Status This status indicates where the payment AR13.1 AR13.2
is in the processing flow. Valid values AR130 AR131
are: AR135 AR180
AR199 AR20.1
0 = Unreleased AR21.1 AR21.2
1 = Release, Unassigned AR21.3 AR24.1
2 = Open Payment AR28.1 AR29.1
7 = Applied AR29.2 AR30.1
8 = Closed AR30.2 AR30.3
9 = Historical AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR504
AR560 AR570
AR575 AR580
AR82.1 AR952
AR974 CB191
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
...
APM-CUSTOMER Alpha 9 (Right Justified) AR115 AR13.1
Customer The customer that submitted the payment AR13.2 AR21.1
for application. AR21.2 AR21.4
AR28.1 AR29.1
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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
Bank Represents a bank institution location. AR570 AR575
AR952 AR974
APM-BANK-ACCT-NBR Alpha 17 AR21.1 AR28.1
Bank Account Number The bank-assigned account number AR570 AR575
identification to be used for the cash AR952 AR974
code.
APM-GL-DATE Numeric 8 (yyyymmdd) AR115 AR20.1
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 AR30.2
AR30.4 AR37.3
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
AR952 AR974
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
Transaction Type This field indicates the payment type of AR21.2 AR21.3
the transaction. Valid values are: AR21.4 AR29.1
AR29.2 AR30.1
N = Non-AR payment AR30.2 AR30.4
P = Customer payment AR42.1 AR42.2
B = BOE payment AR42.6 AR42.7
C = Credit memo AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
AR952 AR974
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
Transaction Number This is the payment number for the AR21.2 AR21.3
transaction. This can be a check number, AR21.4 AR29.1
wire transfer number, etc. that AR29.2 AR30.1
identifies the transaction. AR30.2 AR30.4
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
AR952 AR974
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 15.2 AR115 AR124
Transaction Amount Base 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 AR30.2
AR30.4 AR35.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
AR90.1 AR952
AR974 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 15.2 AR130 AR131
Applied Amount The amount of the payment that has been AR135 AR180
applied. AR29.1 AR29.2
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR44.3
AR503 AR504
AR952 AR974
DT150 DT40.1
DT520 DT92.1
APM-APPLIED-SEQ Numeric 5 AR130 AR131
Application Sequence The total number of applications that AR135 AR180
have been created with this payment. AR29.1 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR504 AR560
AR952 AR974
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 5 AR21.2 AR21.4
Remittance Sequence Total number of remittance records that AR21.5 AR21.6
have been created from the lock box AR29.1 AR570
interface program for this payment. AR575 AR580
AR952 AR974
APM-DIST-SEQ Numeric 4 AR190 AR21.3
Distribution Total number of offset distributions on AR29.1 AR29.2
Sequence type "N" payment (Non-AR cash payment). AR952 AR974
APM-PROCESS-LEVEL Alpha 5 AR115 AR21.1
Process Level This is the process level for the AR21.2 AR21.3
payment. AR21.4 AR29.1
AR29.2 AR30.1
AR30.2 AR30.4
AR35.1 AR37.3
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
AR952 AR974
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
Cancel Date This is the date the payment was AR82.1 AR952
identified as being canceled. The AR974
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
Transferred Payment This field will be used to indicate AR952 AR974
that a payment has been transferred to
another customer.
APM-CASH-CODE Alpha 4 AR115 AR21.1
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. AR30.2 AR30.4
AR37.3 AR503
AR570 AR575
AR580 AR952
AR974
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 AR30.2
payments are applied. AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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
Transaction Currency Transaction 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 AR30.2
AR30.4 AR37.3
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
AR952 AR974
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 12.6 AR115 AR124
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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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 15.2 AR115 AR20.1
Transaction Amount This 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
AR30.2 AR30.4
AR37.3 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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 15.2 AR20.1 AR21.3
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 AR952
The system will match this amount AR974
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 12.6 AR115 AR21.1
Group Exchange Rate The 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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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 AR30.2
convert the company base currency amount AR30.4 AR42.1
to the group currency amount. AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR952
AR974 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
Last Statement Date Date of the last statement on which AR952 AR974
this payment appeared.
APM-ORIG-APP-AMT Signed 15.2 AR130 AR131
Payment Amount Amount applied against the payment in AR135 AR180
the payment's transaction currency. AR29.1 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 AR35.1
AR37.3 AR44.3
AR503 AR504
AR952 AR974
DT150 DT40.1
DT520 DT92.1
APM-REFERENCE Alpha 10 (Lower Case) AR115 AR21.2
Reference Reference field available to carry any AR29.1 AR29.2
information on a particular payment that AR42.1 AR42.2
a user may want to reference. At cash AR42.6 AR42.7
entry time this field also is used to AR43.1 AR44.3
assign payments to customers, by AR502 AR503
entering an invoice or debit memo. AR560 AR575
AR580 AR952
AR974 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
Reference Type This field is used along with the AR29.1 AR29.2
Reference field. It indicates the AR952 AR974
specific type of transaction of the
reference field. Valid values are:
I = Invoice
O = Order
D = Debit Memo
APM-ORIG-ND Numeric 1 AR115 AR21.1
Number of Decimals Currency decimal indicator. AR21.2 AR21.3
AR21.4 AR29.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
AR952 AR974
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
Payment Open This field is used as a compute field
to calculate open amount. No data is
stored in this field. Please refer to
the Universe documentation for more
information on compute fields.
APM-TYPE-DSP Derived
Type Display This field is used as a string field,
combining transaction type and
transaction number fields for record
access. No data is stored in this field.
Please refer to the Universe
documentation for more information on
string fields.
APM-PREPAY-FLAG Numeric 1 AR115 AR21.2
Prepay Flag Indicates if payment is a prepayment. AR21.6 AR29.1
Valid values are: AR29.2 AR952
AR974
0 = Not a Prepay
1 = Prepayment
APM-CREDIT-APPLD Signed 15.2 AR115 AR130
Credit Application When a payment is applied to a credit AR180 AR30.1
Amount memo the amount of application will be AR30.2 AR30.4
stored here. AR30.8 AR35.1
AR504 AR974
APM-ORIG-CR-APPLD Signed 15.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.2 AR30.4
currency of the transaction will be AR30.8 AR35.1
stored here. AR504 AR974
APM-ADJ-AMT Signed 15.2 AR130 AR131
Adjust Amount Payment adjustment amount in company AR135 AR180
base currency. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.2
AR504 AR974
APM-ORIG-ADJ-AMT Signed 15.2 AR130 AR131
Transaction Adjust The amount of the payment adjustment in AR135 AR180
Amount transaction currency. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.2
AR504 AR974
APM-TAX-CODE Alpha 10 AR21.2 AR21.6
Tax Code This field contains a code representing AR952 AR974
specific tax information. This must be
valid Tax Code.
APM-TRAN-TAX-AMT Signed 15.2 AR21.2 AR21.6
Base Tax Amount Tax amount in base currency. AR952 AR974
APM-ORIG-TAX-AMT Signed 15.2 AR21.2 AR21.6
Transaction Tax The tax amount in transaction currency. AR952 AR974
Amount
APM-TRAN-TXBL-AMT Signed 15.2 AR21.6 AR952
Base Taxable Amount The taxable amount of the transaction. AR974
APM-ORIG-TXBL-AMT Signed 15.2 AR21.6 AR952
Transaction Taxable The taxable amount of the transaction AR974
Amount in transaction currency.
APM-CURR-MUDV Alpha 1 AR21.1 AR21.2
Currency Currency Multiplier or Divider. This is AR21.3 AR21.4
Multiply/Divide used along with the currency rate to AR30.1 AR30.2
compute the company base transaction AR30.4 AR503
amount. Valid values are: AR570 AR575
AR580
M = Multiply
D = Divide
APM-HIST-PER Numeric 2 AR180 AR199
History Periods Determines how many times the Period
Closing Report is run before the payment
status is changed.
APM-LAST-FC-DATE Numeric 8 (yyyymmdd) AR137 AR29.1
Last Fc Date The date of the last finance charge
calculation for this payment.
ARPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APMSET1 COMPANY This path is used for record AR115 AR124
BATCH-NBR uniqueness. AR130 AR131
SEQ-NBR AR132 AR135
AR137 AR150
AR180 AR190
AR191 AR20.1
AR21.1 AR21.2
AR21.3 AR21.4
AR21.5 AR21.6
AR220 AR222
AR228 AR229
AR230 AR233
AR235 AR24.1
AR256 AR286
AR287 AR30.1
...
APMSET10 COMPANY This path is used to select records in AR10.1 AR229
CUSTOMER customer number order. AR251 AR252
TRANS-TYPE KeyChange AR253 AR255
TRANS-NBR AR28.7 AR282
BATCH-NBR AR286 AR287
AR29.2 AR294
AR30.3 AR300
AR301 AR53.1
AR90.1 DT520
APMSET2 COMPANY This path is used to select records in AR115 AR124
BATCH-NBR batch number order. AR13.1 AR13.2
TRANS-TYPE KeyChange AR132 AR191
TRANS-NBR AR20.1 AR21.1
CUSTOMER AR21.2 AR21.3
AR21.4 AR232
AR233 AR24.1
AR28.1 AR282
AR29.1 AR29.2
AR30.1 AR30.2
AR30.3 AR30.4
AR300 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.6
...
APMSET3 COMPANY This path is used to access unassigned AR13.1 AR13.2
BANK-ENTITY payment records by MICR number. AR258 AR28.1
BANK-ACCT-NBR KeyChange, Subset
BATCH-NBR Where TRANS-TYPE = "P"
SEQ-NBR And (CUSTOMER = Spaces
Or CUSTOMER = "000000000" )
APMSET4 COMPANY This path is used to access open AR258 AR28.2
CASH-CODE customer payments by cash code.
GL-DATE Subset
BATCH-NBR Where TRANS-TYPE = "P"
SEQ-NBR And STATUS = 2
APMSET5 COMPANY This path is used to access non-AR AR28.5 AR28.6
CASH-CODE payments by cash code.
GL-DATE Subset
BATCH-NBR Where TRANS-TYPE = "N"
SEQ-NBR
APMSET6 COMPANY This path is used to access open AR130 AR135
CUSTOMER customer payments by customer number AR194 AR30.3
GL-DATE order. AR505
BATCH-NBR KeyChange, Subset
SEQ-NBR Where TRANS-TYPE != "N"
And STATUS = 2
APMSET7 TRANS-NBR This path is used to access payment AR17.1 AR230
CUSTOMER records by payment number order. AR27.1 AR28.3
COMPANY KeyChange AR28.4 AR504
TRANS-TYPE AR90.1 CB191
BATCH-NBR OE292
APMSET8 COMPANY This path will be used to select AR137 AR150
CUSTOMER customer payment records that are open AR194 AR199
GL-DATE or not historical. AR250 AR251
TRANS-TYPE KeyChange, Subset AR252 AR253
TRANS-NBR Where (STATUS > 1 AR255 AR271
BATCH-NBR And STATUS < 9 ) AR275
And TRANS-TYPE != "N"
APMSET9 COMPANY This path is used to select open AC115 AC15.2
CUSTOMER customer payments or unreleased customer AC450 AR50.1
GL-DATE payments. AR90.1 BL02.1
BATCH-NBR KeyChange, Subset BL02.2 BL04.1
SEQ-NBR Where TRANS-TYPE = "P" BL120 BL121
And (STATUS = Zeroes BL122 BL123
Or STATUS = 2 ) BL130 BL20.1
BL20.3 BL202
BL204 BL21.2
BL21.5 BL220
BL231 BL246
BL29.1 BL29.2
BL290 BL291
BL31.1 BL31.2
BL31.3 BL31.5
...
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
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-SEQ-NBR -> APY-SEQ-NBR
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
Reverse REVERSE Not Required, Delete Restricted
APM-COMPANY -> RVH-COMPANY
APM-CUSTOMER -> RVH-CUSTOMER
APM-TRANS-TYPE -> RVH-TRANS-TYPE
APM-TRANS-NBR -> RVH-TRANS-NBR
APM-BATCH-NBR -> RVH-BATCH-NBR
APM-SEQ-NBR -> RVH-PAYMENT-SEQ
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-TRANS-NBR
APM-SEQ-NBR -> 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-SEQ-NBR -> ARA-CR-PYMNT-SEQ
ARA-COMPANY
ARA-TRANS-TYPE
ARA-TRANS-NBR
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-TRANS-NBR
CMT-BEG-DATE
CMT-SEQ-NBR
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-TRANS-NBR
APM-CUSTOMER -> AMD-CUSTOMER
AMD-DIST-SEQ
Arremit ARREMIT Delete Cascades
APM-COMPANY -> RMI-COMPANY
APM-BATCH-NBR -> RMI-BATCH-NBR
APM-SEQ-NBR -> RMI-SEQ-NBR
RMI-REMIT-SEQ
Arsadjust ARSADJUST
APM-COMPANY -> ASJ-COMPANY
APM-TRANS-TYPE -> ASJ-TRANS-TYPE
APM-TRANS-NBR -> ASJ-TRANS-NBR
APM-SEQ-NBR -> ASJ-PAYMENT-SEQ
ASJ-ADJ-SEQ
Arsapplied ARSAPPLIED Delete Cascades
APM-COMPANY -> ASG-CR-COMPANY
APM-BATCH-NBR -> ASG-CR-BATCH
APM-SEQ-NBR -> ASG-CR-PYMNT-SEQ
ASG-COMPANY
ASG-TRANS-TYPE
ASG-TRANS-NBR
ASG-PAYMENT-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-TRANS-NBR
AMD-CUSTOMER
AMD-DIST-SEQ
Reversedtl REVERSEDTL Delete Cascades
APM-COMPANY -> RVD-CR-COMPANY
APM-BATCH-NBR -> RVD-CR-BATCH
APM-SEQ-NBR -> RVD-CR-PYMNT-SEQ
RVD-COMPANY
RVD-TRANS-TYPE
RVD-TRANS-NBR
RVD-PAYMENT-SEQ
RVD-BATCH-NBR
RVD-APP-SEQ
|