Lawson Insight Technical Documentation |
|
ARPAYMENT
ARPAYMENT FILE
AR Payment
The AR Payment file will contain the detail payment records entered for a
given batch. There are several online and batch programs to input payment
records. A payment record identifies an amount in original and company base
currency, to be used to apply to invoices 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 AR256 AR286
AR287 AR36.1 AR36.2 AR10.1 AR251 AR252
AR253 AR255 AR282 AR294 AR301 AR53.1
AR90.1 AR232 AR258 AR194 AR250 AR505
AR17.1 AR27.1 OE292 AR271 AR275 AR520
AR219 AR50.1 BL02.1 BL04.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 BR02.3 BR10.1
BR11.1 BR120 BR121 BR122 BR140 BR16.1
BR17.1 BR19.1 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.7 BR21.2 BR210 BR211 BR216
BR217 BR220 BR400 BR420 BR45.1 BR450
BR46.1 BR46.2 BR46.4 BR521 BRIP.1 IC02.1
IC531 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 OE111 OE112 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE130 OE14.3 OE14.4 OE16.1 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 OE530 OE54.1
OE60.1 OE80.1 OE80.2 OE81.1 OE81.2 OE810
OE830 OE85.1 OE85.3 OE86.1 OE90.1 OE90.2
PBIP.1 PR197 SA03.1 SA100 SA252 SA254
SA256 SA261 SA271 SA281 SA291 SA300
SA80.2 SA90.2 TX140 TX40.1 WH110 WH120
WH130 WH132 WH190 WH20.1 WH20.2 WH20.7
WH21.2 WH224 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 WO30.1
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 AR29.1 AR29.2
AR30.1 AR30.2 AR30.8 AR31.5 AR31.6 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 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 Company number. AR21.2 AR21.3
AR21.4 AR28.1
AR29.1 AR29.2
AR30.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 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
Record Sequence Payment Sequence. This is the generated AR21.2 AR21.3
Number sequence number to separate individual AR21.4 AR28.1
invoice payment requirements. AR29.1 AR29.2
AR30.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 AR31.5 AR31.6
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
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 DT166
...
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 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 Represents a bank institution location. AR570 AR575
APM-BANK-ACCT-NBR Alpha 35 AR21.1 AR28.1
Element: Bank Account NThe bank-assigned account number AR570 AR575
identification to be used for the cash
code.
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 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 AR21.2 AR21.3
of the transaction. Valid values are: AR21.4 AR29.1
AR29.2 AR30.1
N = Non-AR payment AR34.1 AR42.1
P = Customer payment AR42.2 AR42.6
AR42.7 AR43.1
B = BOE Payment 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-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, etc. that AR29.2 AR30.1
identifies the transaction. 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 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. AR180 AR29.1
AR29.2 AR30.1
AR30.8 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 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
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.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 from the lock box AR29.1 AR570
interface program for this payment. AR575 AR580
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).
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
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. 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 AR34.1
payments are applied. 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 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 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
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 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 AR34.1
convert the company base currency amount AR42.1 AR42.2
to the group currency amount. 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
AR31.6 AR33.1
AR33.3 AR33.6
AR34.1 AR35.1
AR37.3 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 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
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. No data is
stored in this field. Please refer to
the Universe documentation for more
information on compute fields.
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. 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
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 application will be AR30.8 AR33.3
stored here. 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 AR33.3
currency of the transaction will be AR34.1 AR35.1
stored here. 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 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.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 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.2 AR48.3
AR504 AR80.1
AR80.2
APM-CURR-MUDV Alpha 1 AR115 AR21.1
Currency Currency Multiplier or Divider. This is AR21.2 AR21.3
Multiply/Divide used along with the currency rate to AR21.4 AR30.1
compute the company base transaction AR34.1 AR503
amount. Valid values are: AR570 AR575
AR580
M = Multiply
D = Divide
APM-HIST-PER Numeric 2 AR180 AR198
Element: Hist Per AR29.2 AR80.1
AR80.2
APM-SELECT-SEQ Numeric 6 AR115 AR30.1
Element: Select Seq AR30.2 AR34.1
APM-LAST-FC-DATE Numeric 8 (yyyymmdd) AR137 AR29.1
Element: Last Fc Date
APM-DEPOSIT-DATE Numeric 8 (yyyymmdd) AR20.1 AR21.1
Element: Deposit Date AR21.2 AR21.3
AR21.4 AR29.1
AR29.2 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
Element: Operator Code This field contains the operator code.
This is the user ID of the person who
last maintained this record.
ARPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APMSET1 COMPANY This path is used for record AR115 AR124
BATCH-NBR uniqueness. AR129 AR130
PAYMENT-SEQ KeyChange 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 AR24.1
AR256 AR286
...
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
AR301 AR33.1
AR48.1 AR53.1
AR90.1 DT520
APMSET11 COMPANY This index was created as a solution to AR300
PAYMENT-SEQ the Find Next/Prev Flag error. It is
BATCH-NBR only used where a modify must be done
within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
KeyChange
APMSET2 COMPANY This path is used to select records in AR115 AR124
BATCH-NBR batch number order. AR13.1 AR13.2
TRANS-TYPE KeyChange AR130 AR132
TRANS-NBR AR191 AR20.1
CUSTOMER AR21.1 AR21.2
AR21.3 AR21.4
AR229 AR232
AR233 AR24.1
AR28.1 AR282
AR29.1 AR29.2
AR30.1 AR300
AR31.6 AR33.1
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
...
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"
PAYMENT-SEQ 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 KeyChange, Subset
BATCH-NBR Where TRANS-TYPE = "P"
PAYMENT-SEQ 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 KeyChange, Subset
BATCH-NBR Where TRANS-TYPE = "N"
PAYMENT-SEQ
APMSET6 COMPANY This path is used to access open AR129 AR130
CUSTOMER customer payments by customer number AR135 AR137
GL-DATE order. AR150 AR194
BATCH-NBR KeyChange, Subset AR223 AR250
PAYMENT-SEQ Where TRANS-TYPE != "N" AR251 AR252
And STATUS = 2 AR253 AR255
AR33.1 AR505
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 AR130 AR137
CUSTOMER customer payment records that are open AR150 AR194
GL-DATE or not historical. AR198 AR250
TRANS-TYPE KeyChange, Subset AR251 AR252
TRANS-NBR Where (STATUS > 1 AR253 AR255
BATCH-NBR And STATUS < 9 ) AR271 AR275
And (TRANS-TYPE = "P" AR520
Or TRANS-TYPE = "B" )
APMSET9 COMPANY This path is used to select open AR219 AR48.1
CUSTOMER customer payments or unreleased customer AR48.3 AR50.1
GL-DATE payments. AR90.1 BL02.1
BATCH-NBR KeyChange, Subset BL04.1 BL120
PAYMENT-SEQ Where (TRANS-TYPE = "P" BL121 BL122
Or TRANS-TYPE = "B" ) BL123 BL125
And (STATUS = Zeroes BL130 BL20.1
Or STATUS = 2 ) BL20.3 BL20.6
BL202 BL204
BL21.2 BL21.5
BL217 BL220
BL231 BL246
BL29.1 BL29.2
BL290 BL291
BL31.1 BL31.2
...
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
|