 |
Lawson Insight Technical Documentation |
|
AROIHDR FILE
AR Transaction Header
The AR Transaction Header is the header record for all transactions in the AR
system. There will be subordinate records to this file that will carry the
individual due dates and amounts for each of the scheduled "due dates" for a
specific transaction.
REFERENCED BY
AR01.1 AR100 AR105 AR110 AR12.1 AR124
AR129 AR131 AR132 AR135 AR136 AR140
AR141 AR150 AR155 AR161 AR180 AR194
AR196 AR20.1 AR21.1 AR21.2 AR21.3 AR21.4
AR21.6 AR21.5 AR230 AR232 AR233 AR235
AR24.1 AR245 AR25.1 AR250 AR251 AR252
AR253 AR255 AR256 AR258 AR274 AR275
AR282 AR286 AR287 AR293 AR294 AR35.1
AR35.2 AR36.1 AR36.2 AR46.1 AR48.1 AR48.3
AR50.1 AR504 AR505 AR506 AR507 AR53.1
AR570 AR575 AR58.1 AR580 AR700 AR72.1
AR74.1 AR80.1 AR80.2 AR90.1 DA90.1 DA91.1
BR11.1 CB06.2 CB191 DT170 DT520 GL235
PHI3.1 WH20.7 AR199 AR242 AR10.1 AR17.1
AR227 AR234 AR271
UPDATED BY
AR115 AR130 AR137 AR145 AR190 AR191
AR29.3 AR30.1 AR30.2 AR30.4 AR30.8 AR300
AR31.5 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 AR45.1 AR502 AR560 AR82.1
DT150 DT180 DT181 DT45.1 DT92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARH-COMPANY Numeric 4 AR115 AR130
Company Company number. AR137 AR190
AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-TRANS-TYPE Alpha 1 AR115 AR130
Transaction Type Indicates the type of transaction. AR137 AR190
Valid values are: AR30.1 AR30.2
AR30.4 AR30.8
C = Credit Memo AR31.5 AR42.2
D = Debit Memo AR42.7 AR44.3
I = Invoice AR502 AR560
AR72.1 AR82.1
M = Mixed DT92.1
ARH-INVOICE Alpha 22 AR115 AR130
Invoice Number Used to identify the invoice. AR137 AR190
AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR72.1 AR82.1
DT92.1
ARH-STATUS Numeric 1 AR115 AR130
Transaction Status This field contains the status of the AR137 AR190
transaction. Valid values are AR30.1 AR30.2
AR30.4 AR30.8
0 = Unreleased AR31.5 AR42.1
1 = Released AR42.2 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-CUSTOMER Alpha 9 (Right Justified) AR115 AR130
Customer Customer number. AR137 AR190
AR29.3 AR30.1
AR30.2 AR30.4
AR30.8 AR31.5
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
DT92.1
ARH-BATCH-NBR Numeric 6 AR115 AR130
Batch Number This identifies the batch the entered AR137 AR190
invoices and debit memos are part of. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-PROCESS-LEVEL Alpha 5 AR115 AR130
Process Level This field contains the process level, AR137 AR190
which is the reporting hierarchy below AR30.1 AR30.2
company. AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR72.1 AR82.1
DT92.1
ARH-TRANS-DATE Numeric 8 (yyyymmdd) AR115 AR130
Transaction Date This field contains the date of the AR137 AR190
transaction. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-GL-DATE Numeric 8 (yyyymmdd) AR115 AR130
General Ledger Date This field contains the general ledger AR137 AR190
posting date. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-ORIG-CURRENCY Alpha 5 AR115 AR130
Transaction Currency The transaction currency code. AR137 AR190
AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR72.1 AR82.1
DT92.1
ARH-ORIG-ND Numeric 1 AR115 AR130
Number of Decimals Currency decimal indicator. AR137 AR190
AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR72.1 AR82.1
DT92.1
ARH-ORIG-AMT Signed 15.2 AR115 AR130
Transaction Amount The amount of the transaction in AR137 AR190
transaction currency. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-TRAN-AMT Signed 15.2 AR115 AR130
Base Amount The total amount of the transaction in AR137 AR190
the company base currency. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-CUST-PO-NBR Alpha 22 AR115 AR130
Customer PO Number The customer purchase order number AR190 AR30.1
assigned to the invoice. AR30.2 AR30.4
AR30.8 AR42.2
AR42.6 AR502
AR560 AR72.1
ARH-XREF-COMPANY Numeric 4 AR42.2 AR42.6
Cross Reference The company associated with the cross AR502 AR560
Company referenced transaction.
ARH-XREF-CUSTOMER Alpha 9 (Right Justified) AR42.2 AR42.6
Cross Reference The customer associated with the cross AR560
Customer referenced transaction.
ARH-XREF-TYPE Alpha 1 AR115 AR130
Cross Reference Type The type of cross reference. Used to AR190 AR30.1
identify the reference number being AR30.2 AR30.4
cross referenced in this transaction. AR30.8 AR31.5
Valid values are: AR42.2 AR42.6
AR502 AR560
I = Invoice AR72.1 AR82.1
D = Debit Memo DT92.1
C = Credit Memo
ARH-XREF-NBR Alpha 22 AR115 AR130
Cross Reference The cross reference number entered when AR190 AR30.1
Number the transaction was created. AR30.2 AR30.4
AR30.8 AR31.5
AR42.2 AR42.6
AR502 AR560
AR72.1 AR82.1
DT92.1
ARH-XREF-SEQ Numeric 3 AR190 AR42.2
Cross Reference The cross reference transaction AR42.6 AR502
Sequence sequence number. AR560
ARH-XREF-DUE-DATE Numeric 8 (yyyymmdd) AR42.2 AR42.6
Cross Reference Due The due date of the cross referenced
Date transaction.
ARH-AUTO-APP-FL Alpha 1 AR42.2 AR42.6
Automatic Indicates if the transaction is AR502 AR560
Application Flag eligible for automatic cash application.
ARH-DESC Alpha 30 (Lower Case) AR115 AR130
Description The description of invoice or debit AR137 AR190
memo. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.6 AR42.7
AR502 AR560
AR82.1 DT92.1
ARH-TRANS-USER1 Alpha 10 AR190 AR42.2
Transaction User 1 A user-defined field that is built with AR42.6 AR502
an access path in the invoice/debit memo AR560 AR72.1
transaction file.
ARH-TRANS-USER2 Alpha 15 AR190 AR42.2
Transaction User 2 A user-defined field. AR42.6 AR502
AR560 AR72.1
ARH-TRANS-USER3 Numeric 8 (yyyymmdd) AR190 AR42.2
Transaction User 3 A user-defined field. AR42.6 AR502
AR560
ARH-TRANS-USER4 Numeric 9 AR190 AR42.2
Transaction User 4 A user-defined field. AR42.6 AR502
AR560 AR82.1
ARH-TRANS-USER5 Signed 13.2 AR190 AR42.2
Transaction User 5 A user-defined field. AR42.6 AR502
AR560
ARH-AR-CODE Alpha 4 AR115 AR130
Accounts Receivable The accounts receivable code that AR137 AR190
Code identifies the accounts receivable AR30.1 AR30.2
general ledger account to be credited AR30.4 AR30.8
during cash application. AR31.5 AR42.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
DT92.1
ARH-SALESMAN Numeric 4 AR115 AR130
SalesRep The sales representative. Defaults from AR137 AR190
AR Company Customer file. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.6 AR42.7
AR44.3 AR502
AR560 AR82.1
ARH-ORIG-RATE Signed 12.6 AR115 AR130
Exchange Rate The currency exchange rate used to AR137 AR190
convert a non-base currency transaction AR30.1 AR30.2
amount to the company base currency. AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-CURR-MUDV Alpha 1 AR115 AR130
Currency The currency multiply/divide indicator. AR137 AR190
Multiply/Divide Indicates whether the currency exchange AR30.1 AR30.2
rate is to be multiplied or divided by AR30.4 AR30.8
the original, transaction amount to AR31.5 AR42.2
calculate the base currency amount. AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-GROUP-RATE Signed 12.6 AR115 AR130
Group Rate The group currency exchange rate. Used AR137 AR190
to convert a non-base currency AR30.1 AR30.2
transaction amount to the group AR30.4 AR30.8
currency. AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-GROUP-MUDV Alpha 1 AR115 AR130
Group The group currency multiply/divide AR137 AR190
Multiply/Divide indicator. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 DT92.1
ARH-BASE-DETAIL Signed 15.2 AR137 AR190
Base Detail This is a working field used to insure AR31.5 AR42.2
balancing non-base distributions in a AR42.7 AR44.3
rounding situation. AR507
ARH-BANK-INST-CODE Alpha 3 AR115 AR130
Payment Code The cash (check) payment or bill of AR137 AR190
exchange payment transaction code. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.2
AR42.6 AR42.7
AR44.3 AR502
AR560 AR82.1
DT92.1
ARH-BANK-INST-TYPE Alpha 1 AR115 AR130
Transaction Code This categorizes the type of bank AR137 AR190
Type instrument. AR30.1 AR30.2
C = Cash Payment AR30.4 AR30.8
D = Bill of Exchange AR31.5 AR42.2
AR42.6 AR42.7
AR44.3 AR502
AR560 AR82.1
ARH-TERMS-CD Alpha 5 AR115 AR130
Terms Code The terms code used in the generation AR137 AR190
of invoice obligations. Used to AR30.1 AR30.2
calculate prepayment discount dates and AR30.4 AR30.8
net due dates. AR31.5 AR42.2
AR42.6 AR42.7
AR44.3 AR502
AR560 AR82.1
DT92.1
ARH-PAYMENT-SEQ Numeric 6 AR115 AR130
Payment Sequence The last sequence number used in AR137 AR190
generating invoice obligations. An AR30.1 AR30.2
invoice may have multiple records with AR30.4 AR30.8
the same transaction number; each will AR31.5 AR42.1
have its own due date, but will be tied AR42.2 AR42.6
to the primary transaction number. AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
DT92.1
ARH-DIST-SEQ Numeric 4 AR190 AR31.5
Distribution The last distribution sequence number AR42.1 AR42.2
Sequence Number assigned to the transaction. AR42.7 AR43.1
AR44.3 AR507
AR560 DT150
DT180 DT181
DT92.1
ARH-ORIG-CODE Alpha 1 AR115 AR130
Origin Code A system-generated code that identifies AR137 AR190
where the record originated. Valid AR30.1 AR30.2
values are: AR30.4 AR30.8
AR31.5 AR42.2
B = AR invoice (AR42) AR42.7 AR44.3
C = Chargeback AR502 AR560
F = Finance and/or Late Payment Charges AR82.1
L = Converted data (Lawson)
M = Memo (AR42)
O = External Order Processing system
R = Returned Payment
G = Grouped Debit Memo
E = Closing created chargeback
P = Payment created credit memo
ARH-BILL-TO Numeric 4 AR42.2 AR42.6
Bill To The bill to location for the open item. AR502 AR560
ARH-REVALUE-FL Alpha 1 AR115 AR130
Revaluation This field indicates if a currency AR137 AR190
revaluation is needed for this non-base AR30.1 AR30.2
invoice or debit memo. Valid values are: AR30.4 AR30.8
AR31.5 AR42.2
AR42.6 AR42.7
N = No; no revaluation needed AR44.3 AR502
Y = Yes; revaluation needed AR560 AR82.1
ARH-TAX-EXEMPT-CD Alpha 1 AR115 AR130
Tax Exempt Code This is the customer tax exempt AR30.1 AR30.2
indicator. Used by the Lawson Order AR30.4 AR30.8
Entry system and AR invoice entry. Valid AR42.2 AR502
values are: AR560
T = Taxable
E = Exempt
ARH-NOTICE-FL Alpha 1 AR191
Notice Flag Identifies whether to print notices.
ARH-CB-REASON Alpha 4 AR130 AR190
Chargeback Reason The chargeback reason code. AR30.1 AR30.2
AR30.4 AR30.8
ARH-CB-ORIG-COMP Numeric 4 AR130 AR190
Chargeback Company The chargeback company. AR30.1 AR30.2
AR30.4 AR30.8
ARH-CB-SEQ-NBR Numeric 4 AR130 AR190
Chargeback Sequence The sequence number of the chargeback. AR30.1 AR30.2
Number AR30.4 AR30.8
ARH-CANCEL-FLAG Alpha 1 AR29.3
Cancellation Flag Indicates if the open item has been has
been transferred to another customer.
Valid values are:
Y = Open item has been transferred
Blank = Open item has not been
transferred
ARH-REASON-CODE Alpha 4 AR31.5 AR42.2
Reason Code Indicates the reason for memos. AR42.6 AR42.7
ARH-JRNL-BOOK-NBR Alpha 12 AR190 AR42.2
Journal Book Number This field contains the journal book AR42.7 AR44.3
number for this transaction header AR502 AR560
record. AR82.1
ARH-TAX-FL Alpha 1 AR42.1 AR42.2
Tax Point Indicates tax point origin, used for AR42.7 AR43.1
tax calculation. Valid values are: AR560
N = No tax calculation
Y = Payment origin
ARH-LATE-CH-FL Alpha 1 AR137 AR42.2
Late Ch Fl Late Charge Flag. Indicate if late AR42.6 AR560
charge is to be applied to the invoice.
ARH-LATE-CH-TR-NBR Alpha 10 (Right Justified) AR137
Late Ch Tr Nbr The transaction number of the late
payment charge invoice.
ARH-LATE-CH-OR-AMT Signed 15.2 AR137
Late Ch Or Amt The late payment charge amount in
transction currrency.
ARH-LATE-CH-TR-AMT Signed 15.2 AR137
Late Ch Tr Amt The late payment charge amount in
company base currency.
ARH-ALT-TYPE Alpha 1 AR115 AR130
Alt Type C = Credit Memo AR137 AR190
D = Debit Memo AR30.1 AR30.2
I = Invoice AR30.4 AR30.8
AR31.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1
ARH-SUM-LINE Alpha 1 AR130 AR137
Sum Line N = No AR190 AR30.1
Y = Yes AR30.2 AR30.4
AR30.8 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR72.1 AR82.1
ARH-SYSTEM Alpha 2 AR42.2 AR42.7
System Code A two-character code representing an AR44.3 AR502
application used within the Lawson AR560 AR82.1
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
ARH-DUN-LTR-IND Alpha 1
Dun Ltr Ind Dunning letters in use for customer. Yes
or No. Specified in AR10.1 (customer).
Applies only to the advanced dunning
process.
ARH-OVERIDE-DUNPRC Alpha 1 AR42.6 AR45.1
Overide Dunprc Override Dunning Process.
ARH-DUN-PROCESS-CD Alpha 6 AR145
Dun Process Cd Dunning letter process code for
thetransaction A unique code that
represents a combinatioin of Dunning
Letter options.
ARH-LST-DUNLTR-STM Numeric 2 AR145
Lst Dunltr Stm Level of the last dunning letter sent
as if this transaction was dunned in
isolation. I.E. As if it were the only
overdue transaction on the letter.
ARH-LAST-LTR-DATE Numeric 8 (yyyymmdd) AR145
Last Ltr Date Date last dunning letter was sent for
the invoice.
ARH-LST-LTRTEXT-CD Alpha 6 AR145
Lst Ltrtext Cd Text Code for last Dunning Letter sent
on this invoice.
ARH-SENT-FOR-COLL Alpha 1 AR145
Sent For Coll Sent for collection. This indicates
whether the invoice has been sent for
collection (Yes or No).
ARH-ASSESS-DUN-FEE Alpha 1 AR145
Assess Dun Fee Specifies whether to assess a dunning
letter fee.
ARH-INV-OBJ-ID Numeric 12
Inv Obj Id
ARH-AC-CUSTOMER-ID Alpha 5
Ac Customer Id
AROIHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARHSET1 COMPANY This path is used for record AR01.1 AR100
TRANS-TYPE uniqueness. AR105 AR110
INVOICE AR115 AR12.1
AR124 AR129
AR130 AR131
AR132 AR135
AR136 AR137
AR140 AR141
AR145 AR150
AR155 AR161
AR180 AR190
AR191 AR194
AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR21.4
...
ARHSET2 CUST-PO-NBR This path is used to select records by AR30.1 AR30.2
COMPANY purchase order number. AR30.3 AR58.1
CUSTOMER KeyChange AR90.1 DA90.1
TRANS-TYPE DA91.1
INVOICE
ARHSET3 COMPANY This path is used to select records by AR199 AR242
BATCH-NBR batch number. AR293 AR300
CUSTOMER AR42.1 AR42.2
TRANS-TYPE AR42.7 AR43.1
INVOICE
ARHSET4 COMPANY This path is used to select records by AR10.1 AR131
CUSTOMER customer number. AR150 AR17.1
TRANS-TYPE AR191 AR227
INVOICE AR232 AR233
AR234 AR271
AR300 AR35.1
AR506 AR58.1
AR72.1
ARHSET5 ALT-TYPE This index is used to access open item AR130 AR21.4
INVOICE records by transaction number AR21.5 AR30.3
COMPANY independent of company. AR30.4 AR30.9
AR575 AR58.1
ARHSET6 COMPANY AR131 AR30.1
ALT-TYPE AR30.2 AR31.5
INVOICE AR42.2 AR42.7
AR560 BR11.1
PHI3.1 WH20.7
AROIHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Not Required
ARH-TRANS-USER1 -> CNT-CONTRACT
Achisthdr ACHISTHDR Not Required
ARH-TRANS-USER1 -> HIH-CONTRACT
ARH-COMPANY -> HIH-COMPANY
ARH-CUSTOMER -> HIH-CUSTOMER
CNT-AC-CUSTOMER-ID -> HIH-AC-CUSTOMER-ID
ARH-INVOICE -> HIH-INVOICE
Arcode ARCODE Required
ARH-COMPANY -> RCD-COMPANY
ARH-AR-CODE -> RCD-AR-CODE
Arcomp ARCOMP Required
ARH-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
ARH-COMPANY -> ACM-COMPANY
ARH-CUSTOMER -> ACM-CUSTOMER
Arproclevl ARPROCLEVL Required
ARH-COMPANY -> APV-COMPANY
ARH-PROCESS-LEVEL -> APV-PROCESS-LEVEL
Aruoihdr ARUOIHDR Not Required
ARH-COMPANY -> UIH-COMPANY
ARH-TRANS-TYPE -> UIH-TRANS-TYPE
ARH-INVOICE -> UIH-INVOICE
Blinvhdr BLINVHDR Required
ARH-COMPANY -> BLH-COMPANY
ARH-BATCH-NBR -> BLH-BATCH-NBR
Cbbankinst CBBANKINST Required
ARH-BANK-INST-CODE -> CBI-BANK-INST-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
ARH-CUSTOMER -> CUD-CUSTOMER
Salesrep SALESREP Required
ARH-COMPANY -> SAW-COMPANY
ARH-SALESMAN -> SAW-SALESMAN
Terms TERMS Required
ARH-TERMS-CD -> TMS-TERMS-CD
AROIHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomment ARCOMMENT Delete Cascades
ARH-COMPANY -> CMT-COMPANY
ARH-CUSTOMER -> CMT-CUSTOMER
"T" -> CMT-CMMT-TYPE
ARH-TRANS-TYPE -> CMT-TRANS-TYPE
ARH-INVOICE -> CMT-INVOICE
CMT-BEG-DATE
CMT-SEQ-NUMBER
Ardistrib ARDISTRIB Delete Cascades
ARH-COMPANY -> AMD-COMPANY
ARH-BATCH-NBR -> AMD-BATCH-NBR
ARH-TRANS-TYPE -> AMD-TRANS-TYPE
ARH-INVOICE -> AMD-INVOICE
ARH-CUSTOMER -> AMD-CUSTOMER
AMD-DIST-SEQ
Aroitems AROITEMS Delete Cascades
ARH-COMPANY -> ARO-COMPANY
ARH-TRANS-TYPE -> ARO-ALT-TYPE
ARH-INVOICE -> ARO-INVOICE
ARO-PAYMENT-SEQ
|