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 AR33.1
AR33.3 AR33.5 AR33.6 AR35.1 AR35.2 AR36.1
AR37.1 AR37.2 AR37.7 AR39.1 AR39.2 AR48.1
AR48.3 AR504 AR53.1 AR800 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
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 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 The number representing an AR company. AR24.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 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
APH-BATCH-NBR Numeric 6 AR115 AR20.1
Element: Batch Nbr This is the identifying number of a AR24.1 AR42.1
group of payments within a company. AR42.2 AR42.6
There is a company option to have this AR42.7 AR43.1
number assigned automatically or AR44.3 AR502
manually entered. AR503 AR560
AR570 AR575
AR580 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
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
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
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 AR32.1 AR34.1
1 = Released batch AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR503
AR560 AR570
AR575 AR580
ARLL.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
APH-OPR-CODE Alpha 10 (Lower Case) AR115 AR20.1
Element: Opr Code 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
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
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
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
APH-GL-DATE Numeric 8 (yyyymmdd) AR115 AR20.1
Element: Posting Date General ledger transaction date for AR287 AR42.1
posting the entire batch to General AR42.2 AR42.6
Ledger. AR42.7 AR43.1
AR44.3 AR502
AR503 AR560
AR570 AR575
AR580 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
APH-CASH-CODE Alpha 4 AR115 AR20.1
Element: Cash Code Cash code containing default general AR503 AR570
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
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
APH-ORIG-RATE Signed 14.7 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
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
APH-CURR-MUDV Alpha 1 AR115 AR20.1
Element: Curr Mudv Currency Multiplier or Divider. AR42.1 AR42.2
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
ARLL.1 CB06.2
D = Divide DT150 DT155
M = Multiply 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-RATE Signed 14.7 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
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
APH-GROUP-MUDV Alpha 1 AR115 AR20.1
Element: Group Mudv Group Currency Multiplier or Divider. AR42.1 AR42.2
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
ARLL.1 CB06.2
D = Divide DT150 DT155
M = Multiply 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-CASH Signed 18.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 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.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 18.2 AR115 AR20.1
Element: Base RNA AmounTotal amount of the Received Not AR21.1 AR21.2
Applied account valued in the company AR21.3 AR21.4
base 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
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 18.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 AR32.1
AR34.1 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 18.2 AR115 AR20.1
Element: Intl Amt 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 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
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 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
APH-ADDTNL-AMT Signed 18.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: Acct Unit This 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: Sub Acct 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 18.2 AR115 AR20.1
Element: Intl Amt 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 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.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 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.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
Element: Seq Number Sequence counter representing order of AR21.2 AR21.3
record input within a batch. This field AR21.4 AR29.1
is used for sequential batch reviews and AR29.2 AR30.1
record uniqueness. 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
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
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
APH-REFERENCE Alpha 10 (Lower Case) AR115 AR20.1
Element: Reference The batch header reference. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 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
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
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
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 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
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
AR32.1 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR570 AR575
AR580 ARLL.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
APH-TRANS-IDENT Numeric 10 AR115 AR124
Element: Transaction IDA unique CB system-generated AR20.1 AR21.1
identification value assigned to the AR21.2 AR21.3
transaction to make the interface CB AR24.1 AR30.1
deposit transaction record unique. AR32.1 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR570 AR575
AR580 ARLL.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
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
AR32.1 AR34.1
AR570 AR575
AR580 CB191
APH-ADJ-TRANS-IDNT Numeric 10 AR115 AR124
Adjustment Trans ID A unique CB system-generated AR20.1 AR21.1
Code identification value assigned to the AR21.2 AR21.3
transaction to make the interface AR24.1 AR30.1
adjustment CB transaction record AR32.1 AR34.1
unique. 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 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
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
Element: Jbk Seq Nbr The journal book 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 AR01.1 AR115
BATCH-NBR 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 Subset AR124 AR199
BATCH-NBR Where STATUS = Zeroes AR24.1
APHSET3 COMPANY KeyChange AR124 AR220
GL-DATE AR222 AR228
BATCH-NBR AR300
APHSET4 DEP-INST-CODE KeyChange, Subset
TRANS-IDENT Where DEP-INST-CODE != Spaces
APHSET5 ADJ-INST-CODE KeyChange, Subset
ADJ-TRANS-IDNTWhere 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
|