Lawson Insight Technical Documentation |
|
ARPYMNTHDR
ARPYMNTHDR FILE
AR Payment Batch
The AR Payment Batch file contains the batch header information for payments
entered into the system. Batch header records include balancing controls,
transaction dates, currency indicators and other information regarding all
payments in that batch.
REFERENCED BY
AR01.1 AR129 AR13.1 AR13.2 AR130 AR131
AR135 AR137 AR150 AR190 AR220 AR223
AR228 AR229 AR230 AR275 AR28.1 AR28.3
AR28.4 AR28.7 AR282 AR286 AR287 AR31.1
AR31.5 AR31.6 AR35.1 AR35.2 AR36.1 AR37.1
AR37.2 AR37.7 AR48.1 AR48.3 AR504 AR53.1
AR82.1 AR199 AR222
UPDATED BY
AR115 AR124 AR20.1 AR21.1 AR21.2 AR21.3
AR21.4 AR21.6 AR24.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 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
APH-COMPANY Numeric 4 AR115 AR20.1
Element: Company Company number. AR24.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 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
APH-BATCH-NBR Numeric 6 AR115 AR20.1
Element: Batch Number This is the identifying number of a AR24.1 AR42.1
group of payments within a company. AR42.2 AR42.6
There is an option to have this number AR42.7 AR43.1
assigned automatically or manually AR44.3 AR502
entered. AR503 AR560
AR570 AR575
AR580 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
APH-PROCESS-LEVEL Alpha 5 AR115 AR20.1
Element: Process Level This is the process level of the batch. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
APH-STATUS Numeric 1 AR115 AR124
Element: Status This is the status of the batch of AR20.1 AR21.1
payments. Valid values are: AR21.2 AR21.3
AR24.1 AR30.1
0 = Open batch - unreleased AR30.2 AR30.4
1 = Released batch AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
APH-OPR-CODE Alpha 10 (Lower Case) AR115 AR20.1
Element: Requester This will contain the operator code of AR42.1 AR42.2
the individual entering cash. This will AR42.6 AR42.7
either be a valid operator code or the AR43.1 AR44.3
individual's signon identification. AR502 AR503
AR560 AR570
AR575 AR580
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
APH-DEPOSIT-DATE Numeric 8 (yyyymmdd) AR115 AR20.1
Element: Deposit Date Deposit date to be recognized for this AR42.1 AR42.2
batch of payments. AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
APH-GL-DATE Numeric 8 (yyyymmdd) AR115 AR20.1
Element: Posting Date General ledger transaction date for AR286 AR287
posting the entire batch to General AR42.1 AR42.2
Ledger. AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
APH-CASH-CODE Alpha 4 AR115 AR20.1
Accounts Receivable Cash code containing default general AR503 AR570
Code ledger cash account. AR575 AR580
CB06.2
APH-CURRENCY-CD Alpha 5 AR115 AR20.1
Element: Currency Code Currency code tied to the cash code AR42.1 AR42.2
entered for the batch. AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
APH-ORIG-RATE Signed 12.6 AR115 AR20.1
Element: Exchange Rate The rate used to convert a transaction AR42.1 AR42.2
amount from a non-base currency to the AR42.6 AR42.7
company base currency. AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
APH-CURR-MUDV Alpha 1 AR115 AR20.1
Currency Currency Multiplier or Divider. AR42.1 AR42.2
Multiply/Divide Mathematical technique used in AR42.6 AR42.7
conjunction with the currency exchange AR43.1 AR44.3
rate to convert the transaction currency AR502 AR503
amount to the company base currency AR560 AR570
amount. Valid values are: AR575 AR580
CB06.2 DT150
D = Divide DT155 DT160
M = Multiply 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
APH-GROUP-RATE Signed 12.6 AR115 AR20.1
Element: Group ExchangeThe rate used to convert a transaction AR42.1 AR42.2
amount from a currency that differs from AR42.6 AR42.7
the customer group currency to the AR43.1 AR44.3
customer group currency. AR502 AR503
AR560 AR570
AR575 AR580
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
APH-GROUP-MUDV Alpha 1 AR115 AR20.1
Group Group Currency Multiplier or Divider. AR42.1 AR42.2
Multiply/Divide Mathematical technique used in AR42.6 AR42.7
conjunction with the group currency AR43.1 AR44.3
exchange rate to convert the company AR502 AR503
base currency amount to the group AR560 AR570
currency amount. Valid values are: AR575 AR580
CB06.2 DT150
D = Divide DT155 DT160
M = Multiply 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
APH-BASE-CASH Signed 15.2 AR115 AR20.1
Element: Base Cash AmouTotal amount of cash in the company AR21.1 AR21.2
base currency for a particular batch. AR21.3 AR21.4
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.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
APH-BASE-RNA Signed 15.2 AR115 AR20.1
Element: Base RNA AmounTotal amount going to the Received Not AR21.1 AR21.2
Applied account valued in the company AR21.3 AR21.4
base 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 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
APH-RNA-TOTAL Signed 15.2 AR115 AR20.1
Element: RNA Total This will contain the transaction AR21.1 AR21.2
currency value of the RNA amount for AR21.3 AR21.4
type "P" payments. AR30.1 AR30.2
AR30.4 AR503
AR570 AR575
AR580 CB06.2
APH-LOCK-BOX Alpha 2 AR115 AR20.1
Element: Lock Box Lock box code identifier for this AR570 AR575
batch. AR580
APH-LOC-BOX-BATCH Numeric 3 AR570
Element: Lock Box BatchThis will be the batch number from the
lock box interface batch header record.
It will be for reference purposes only.
APH-BATCH-TOTAL Signed 15.2 AR115 AR20.1
Element: Detail Total Control total representing total amount AR24.1 AR42.1
of payment records in transaction AR42.2 AR42.6
currency for this batch. 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
APH-BATCH-COUNT Signed 5.0 AR115 AR20.1
Element: Batch Count Control total representing total number AR24.1 AR42.1
of payment records within this batch. 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
APH-ADDTNL-AMT Signed 15.2 AR115 AR20.1
Element: Additional AmoThis will hold any additional charges AR570 AR580
that may have been incurred from the
bank. This has no affect on the total
amount of cash in the batch.
Example: A charge for currency exchange
transactions may be entered on the batch
header screen. The offset general ledger
account entered will be debited, and the
general ledger cash account will be
credited.
APH-ACCT-UNIT Alpha 15 AR115 AR20.1
Element: Accounting UniThis will be the accounting unit that AR580
the additional charges will be posted
to. The offset will be the cash account
of that batch.
APH-ACCOUNT Numeric 6 AR115 AR20.1
Element: Account This will be the account that the AR580
additional charges will be posted to.
The offset will be the cash account of
that batch.
APH-SUB-ACCT Numeric 4 AR115 AR20.1
Element: Subaccount This will be the sub-account the AR580
additional charges will be posted to.
The offset will be the cash account of
that batch.
APH-DETAIL-TOTAL Signed 15.2 AR115 AR20.1
Element: Detail Total Detail total representing actual total AR21.1 AR21.2
of payment records in transaction AR21.3 AR21.4
currency entered for this batch. 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.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
APH-DETAIL-COUNT Signed 5.0 AR115 AR20.1
Element: Detail Count Detail count representing actual number AR21.1 AR21.2
of payment records entered in this AR21.3 AR21.4
batch. 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.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
APH-LAST-LOG-SEQ Numeric 6 AR115 AR21.1
Record Sequence Sequence counter representing order of AR21.2 AR21.3
Number record input within a batch. This field AR21.4 AR29.1
is used for sequential batch reviews and AR29.2 AR30.1
record uniqueness. 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
APH-ORIG-ND Numeric 1 AR115 AR20.1
Element: Number of DeciCurrency decimal indicator. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
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
APH-REFERENCE Alpha 10 (Lower Case) AR115 AR20.1
Element: Requester The batch header reference. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 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
APH-NOT-APPLD-CD Alpha 4 AR115 AR20.1
Element: RNA Code The default received not applied GL AR42.1 AR42.2
code. The general ledger account AR42.6 AR42.7
represented by this code will be debited AR43.1 AR44.3
for each payment applied, if a AR502 AR503
prepayment GL code is not present for AR560 AR570
that payment. AR575 AR580
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
APH-PRE-PAY-CODE Alpha 4 AR115 AR20.1
Element: Prepayment CodThe default prepayment GL code. The AR42.1 AR42.2
general ledger account represented by AR42.6 AR42.7
this code will be debited for each AR43.1 AR44.3
payment applied, if a received not AR502 AR560
applied GL code is not present for that AR570 AR575
payment. 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
APH-DEP-INST-CODE Alpha 3 AR115 AR124
Deposit Bank The deposit bank transaction code of AR20.1 AR21.1
Transaction Code the payment header. It must exist in the AR21.2 AR21.3
Lawson Cash Ledger system. AR24.1 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR570 AR575
AR580 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
APH-TRANS-IDENT Numeric 10 AR115 AR124
Element: Transaction IDA unique system-generated AR20.1 AR21.1
identification value assigned to the AR21.2 AR21.3
transaction to make this record unique. AR24.1 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR570 AR575
AR580 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
APH-ADJ-INST-CODE Alpha 3 AR115 AR124
Adjustment Bank The adjustment bank transaction code of AR20.1 AR21.1
Trans Code the payment header. It must be set up in AR21.2 AR21.3
the Lawson Cash Ledger system. AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 CB191
APH-ADJ-TRANS-IDNT Numeric 10 AR115 AR124
Adjustment Trans ID A unique system-generated AR20.1 AR21.1
Code identification value assigned to the AR21.2 AR21.3
transaction to make this record unique. AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 CB191
APH-JRNL-BOOK-NBR Alpha 12 AR115 AR20.1
Element: Journal Book NThis field contains the journal book AR42.1 AR42.2
number for the payment batch header. AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR570 AR575
AR580 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
APH-RECON-STMT-NBR Numeric 12 AR20.1 CB06.2
Bank Statement The bank-assigned reconciliation
Number statement number. Used only for cash
codes that require reconciliation
statements.
APH-JBK-SEQ-NBR Numeric 10 AR20.1 CB06.2
Journal Book The journal book sequence number
Sequence Number assigned to a journal book transaction
when it is added or interfaced to the
Lawson system. Used only when Auto
Journal Book Seq Nbr is set to Yes in
GL10.1 (Company).
ARPYMNTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APHSET1 COMPANY This path is used for record uniqueness AR01.1 AR115
BATCH-NBR and selection. AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR150 AR190
AR20.1 AR20.2
AR21.1 AR21.2
AR21.3 AR21.4
AR21.5 AR21.6
AR21.7 AR220
AR223 AR228
AR229 AR230
AR24.1 AR275
AR28.1 AR28.3
...
APHSET2 COMPANY This path is used to select unreleased AR124 AR199
BATCH-NBR records. AR24.1
Subset
Where STATUS = Zeroes
APHSET3 COMPANY This path is used to select records in AR124 AR220
GL-DATE general ledger date order. AR222 AR228
BATCH-NBR KeyChange AR300
APHSET4 DEP-INST-CODE This path is used to allow drill down
TRANS-IDENT from cash ledger screens back into the
payment header file.
KeyChange, Subset
Where DEP-INST-CODE != Spaces
APHSET5 ADJ-INST-CODE This path is used to allow drill down
ADJ-TRANS-IDNTfrom cash ledger screens back into the
payment header file for any bank
charges entered.
KeyChange, Subset
Where ADJ-INST-CODE != Spaces
ARPYMNTHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ar Company ARCOMP Required
APH-COMPANY -> ACO-COMPANY (ACOSET1)
Ar Lock Box ARLOCKBOX Required
When APH-LOCK-BOX != Spaces
APH-LOCK-BOX -> ARL-LOCK-BOX
Ar Process Lvl ARPROCLEVL Required
APH-COMPANY -> APV-COMPANY
APH-PROCESS-LEVEL -> APV-PROCESS-LEVEL
Aroptr AROPTR Required
When APH-OPR-CODE != Spaces
APH-COMPANY -> AOP-COMPANY
APH-OPR-CODE -> AOP-OPR-CODE
Arupmnthdr ARUPMNTHDR Not Required
APH-COMPANY -> UPH-COMPANY
APH-BATCH-NBR -> UPH-BATCH-NBR
ARPYMNTHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ar Pymnt Detls ARPAYMENT Delete Cascades
APH-COMPANY -> APM-COMPANY
APH-BATCH-NBR -> APM-BATCH-NBR
APM-PAYMENT-SEQ
|