Lawson Insight Technical Documentation |
|
AROIHDR
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 AR112 AR12.1
AR12.2 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 AR58.2
AR580 AR700 AR72.1 AR74.1 AR80.1 AR80.2
AR90.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 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 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARH-COMPANY Numeric 4 AR115 AR130
Element: 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
Element: Transaction TyIndicates 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
M = Mixed AR72.1 AR82.1
DT92.1
ARH-INVOICE Alpha 22 AR115 AR130
Element: Invoice NumberUsed 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
Element: Transaction StThis 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
Element: 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
Element: 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
Element: 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
Element: Transaction DaThis 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
Element: General LedgerThis 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
Element: Transaction CuThe 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
Element: Number of DeciCurrency 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
Element: Transaction AmThe 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
Element: 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
Element: Customer PO NuThe 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
Element: Cross ReferencThe 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
Element: 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
Element: Transaction UsA 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
Element: Transaction UsA user-defined field. AR42.6 AR502
AR560 AR72.1
ARH-TRANS-USER3 Numeric 8 (yyyymmdd) AR190 AR42.2
Element: Transaction UsA user-defined field. AR42.6 AR502
AR560
ARH-TRANS-USER4 Numeric 9 AR190 AR42.2
Element: Transaction UsA user-defined field. AR42.6 AR502
AR560 AR82.1
ARH-TRANS-USER5 Signed 13.2 AR190 AR42.2
Element: Transaction UsA 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Payment SequenThe 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
Element: 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
Element: Bill To The bill to location for the open item. AR502 AR560
ARH-REVALUE-FL Alpha 1 AR115 AR130
Element: 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
Element: Tax Exempt CodThis 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
Element: Notice Flag Identifies whether to print notices.
ARH-CB-REASON Alpha 4 AR130 AR190
Element: Chargeback ReaThe chargeback reason code. AR30.1 AR30.2
AR30.4 AR30.8
ARH-CB-ORIG-COMP Numeric 4 AR130 AR190
Element: Chargeback ComThe 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
Element: Cancellation FIndicates 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
Accounts Receivable Indicates the reason for memos. AR42.6 AR42.7
Code
ARH-JRNL-BOOK-NBR Alpha 12 AR190 AR42.2
Element: Journal Book NThis 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
Element: 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
Element: 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
Element: Late Ch Tr NbrThe transaction number of the late
payment charge invoice.
ARH-LATE-CH-OR-AMT Signed 15.2 AR137
Element: Late Ch Or AmtThe late payment charge amount in
transction currrency.
ARH-LATE-CH-TR-AMT Signed 15.2 AR137
Element: Late Ch Tr AmtThe late payment charge amount in
company base currency.
ARH-ALT-TYPE Alpha 1 AR115 AR130
Element: 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
Element: All Flag 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
Element: 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
Element: 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
Element: Overide DunprcOverride Dunning Process.
ARH-DUN-PROCESS-CD Alpha 6 AR145
Element: Dun Process CdDunning letter process code for
thetransaction A unique code that
represents a combinatioin of Dunning
Letter options.
ARH-LST-DUNLTR-STM Numeric 2 AR145
Element: Lst Dunltr StmLevel 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
Element: Last Ltr Date Date last dunning letter was sent for
the invoice.
ARH-LST-LTRTEXT-CD Alpha 6 AR145
Element: Lst Ltrtext CdText Code for last Dunning Letter sent
on this invoice.
ARH-SENT-FOR-COLL Alpha 1 AR145
Element: 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
Element: Assess Dun FeeSpecifies whether to assess a dunning
letter fee.
ARH-INV-OBJ-ID Numeric 12
Element: Inv Obj Id
ARH-AC-CUSTOMER-ID Alpha 5
Element: 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 AR112 AR115
AR12.1 AR12.2
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
...
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
TRANS-TYPE
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 AR233 AR234
AR271 AR30.4
AR300 AR35.1
AR45.1 AR506
AR58.1 AR72.1
AR90.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.9 AR575
AR58.1
ARHSET6 COMPANY AR131 AR191
ALT-TYPE AR30.1 AR30.2
INVOICE AR31.5 AR42.2
AR42.6 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
Acpmhsthdr ACPMHSTHDR
ARH-TRANS-USER1 -> PMH-CONTRACT
ARH-COMPANY -> PMH-COMPANY
ARH-CUSTOMER -> PMH-CUSTOMER
CNT-AC-CUSTOMER-ID -> PMH-AC-CUSTOMER-ID
ARH-INVOICE -> PMH-INVOICE
PMH-OBJ-ID
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
|