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 AR80.1 AR80.2 BR152
AR10.1 AR251 AR252 AR253 AR255 AR282
AR294 AR301 AR53.1 AR90.1 AR232 AR258
AR194 AR250 AR505 AR17.1 AR27.1 AR271
AR275 AC551 AR219 AR50.1 BR10.1 BR11.1
BR120 BR121 BR122 BR123 BR15.1 BR151
BR155 BR156 BR16.1 BR16.2 BR210 BR211
BR215 BR220 BR251 BR252 BR253 BR420
BR450 BR51.1 BR51.2 BR52.1 BR52.2 BR521
BR53.1 BR55.2 BR91.1 BRIP.1 BRPI.1 IC02.1
IC531 PBIP.1 PR197 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.3 AR30.4 AR30.8 AR30.9
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 AR48.3
AR502 AR503 AR504 AR560 AR570 AR575
AR580 AR82.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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 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 AR21.2 AR21.3
Number 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 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.2
9 = Historical AR30.3 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
AR48.3 AR502
AR503 AR504
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
...
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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 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 17 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 AR30.2
AR30.4 AR37.3
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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 AR30.2 AR30.4
P = Customer payment AR42.1 AR42.2
B = BOE Payment AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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. AR30.2 AR30.4
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
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 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 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 AR129 AR130
Element: Applied AmountThe amount of the payment that has been AR131 AR135
applied. AR180 AR29.1
AR29.2 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 AR35.1
AR44.3 AR48.3
AR503 AR504
DT150 DT92.1
APM-APPLIED-SEQ Numeric 5 AR129 AR130
Element: Application SeThe total number of applications that AR131 AR135
have been created with this payment. AR180 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
AR48.3 AR502
AR504 AR560
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
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
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
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. AR30.2 AR30.4
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 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 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 AR30.2
AR30.4 AR37.3
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 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
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
AR30.2 AR30.4
AR37.3 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 AR90.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 15.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 12.6 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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 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 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 15.2 AR129 AR130
Element: Payment AmountAmount applied against the payment in AR131 AR135
the payment's transaction currency. AR180 AR29.1
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR37.3
AR44.3 AR48.3
AR503 AR504
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
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
AR30.2 AR30.4
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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 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
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
APM-ADJ-AMT Signed 15.2 AR129 AR130
Element: Adjust Amount Payment adjustment amount in company AR131 AR135
base currency. AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.2 AR48.3
AR504
APM-ORIG-ADJ-AMT Signed 15.2 AR129 AR130
Transaction Adjust The amount of the payment adjustment in AR131 AR135
Amount transaction currency. AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.2 AR48.3
AR504
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 AR30.2 AR30.4
amount. Valid values are: AR503 AR570
AR575 AR580
M = Multiply
D = Divide
APM-HIST-PER Numeric 2 AR180 AR198
Element: Current Period AR29.2
APM-SELECT-SEQ Numeric 6 AR115 AR30.1
Element: Select Seq AR30.2 AR30.4
AR30.9
APM-LAST-FC-DATE Numeric 8 (yyyymmdd) AR137 AR29.1
Element: Date
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 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
AR30.3 AR301
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.
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 AR30.2
AR30.3 AR30.4
AR300 AR31.6
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 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 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
AR30.3 AR48.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
APMSET8 COMPANY This path will be used to select AR137 AR150
CUSTOMER customer payment records that are open AR194 AR198
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 = "P"
Or TRANS-TYPE = "B" )
APMSET9 COMPANY This path is used to select open AC551 AR130
CUSTOMER customer payments or unreleased customer AR219 AR48.1
GL-DATE payments. AR48.3 AR50.1
BATCH-NBR KeyChange, Subset AR90.1 BR10.1
PAYMENT-SEQ Where (TRANS-TYPE = "P" BR11.1 BR120
Or TRANS-TYPE = "B" ) BR121 BR122
And (STATUS = Zeroes BR123 BR15.1
Or STATUS = 2 ) BR151 BR152
BR155 BR156
BR16.1 BR16.2
BR210 BR211
BR215 BR220
BR251 BR252
BR253 BR420
BR450 BR51.1
...
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
Reverse REVERSE Not Required, Delete Restricted
APM-COMPANY -> RVH-COMPANY
APM-CUSTOMER -> RVH-CUSTOMER
APM-TRANS-TYPE -> RVH-TRANS-TYPE
APM-TRANS-NBR -> RVH-INVOICE
APM-BATCH-NBR -> RVH-BATCH-NBR
APM-PAYMENT-SEQ -> 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-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
Reversedtl REVERSEDTL Delete Cascades
APM-COMPANY -> RVD-CR-COMPANY
APM-BATCH-NBR -> RVD-CR-BATCH
APM-PAYMENT-SEQ -> RVD-CR-PYMNT-SEQ
RVD-COMPANY
RVD-TRANS-TYPE
RVD-INVOICE
RVD-PAYMENT-SEQ
RVD-BATCH-NBR
RVD-APP-SEQ
|