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 AR110 AR112 AR12.1 AR12.2 AR124
AR129 AR131 AR135 AR140 AR150 AR155
AR180 AR196 AR20.1 AR21.1 AR21.2 AR21.3
AR21.4 AR21.6 AR21.5 AR235 AR24.1 AR25.1
AR250 AR274 AR286 AR287 AR293 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 AR74.1 AR80.1
AR80.2 AR90.1 BL00.1 BL01.1 BL120 BL121
BL122 BL123 BL130 BL20.1 BL20.3 BL200
BL201 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 BR11.1 CB06.2 CB191 DT170
DT520 GL235 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE810
OE830 WH20.7 AR199 AR242 AR10.1 AR17.1
AR234 AR72.1
UPDATED BY
AR115 AR130 AR137 AR145 AR190 AR191
AR29.3 AR30.1 AR30.8 AR31.5 AR33.3 AR33.5
AR34.1 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
ARLL.1 DT150 DT180 DT181 DT45.1 DT92.1
TX101 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARH-COMPANY Numeric 4 AR115 AR130
Element: Company Company number. AR137 AR190
AR30.1 AR30.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.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.8
AR31.5 AR33.3
C = Credit Memo AR33.5 AR34.1
D = Debit Memo AR42.2 AR42.7
I = Invoice AR44.3 AR502
AR560 AR82.1
M = Mixed ARLL.1 DT92.1
ARH-INVOICE Alpha 22 AR115 AR130
Element: Invoice NumberUsed to identify the invoice. AR137 AR190
AR30.1 AR30.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.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.8
AR31.5 AR33.3
0 = Unreleased AR33.5 AR34.1
1 = Released AR42.1 AR42.2
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-CUSTOMER Alpha 9 (Right Justified) AR115 AR130
Element: Customer Customer number. AR137 AR190
AR29.3 AR30.1
AR30.8 AR31.5
AR33.3 AR33.5
AR34.1 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 ARLL.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.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.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.8
company. AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.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.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.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.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-ORIG-CURRENCY Alpha 5 AR115 AR130
Element: Transaction CuThe transaction currency code. AR137 AR190
AR30.1 AR30.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-ORIG-ND Numeric 1 AR115 AR130
Element: Number of DeciCurrency decimal indicator. AR137 AR190
AR30.1 AR30.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-ORIG-AMT Signed 18.2 AR115 AR130
Element: Transaction AmThe amount of the transaction in AR137 AR190
transaction currency. AR30.1 AR30.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-TRAN-AMT Signed 18.2 AR115 AR130
Element: Base Amount The total amount of the transaction in AR137 AR190
the company base currency. AR30.1 AR30.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
ARLL.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.8 AR33.3
AR34.1 AR42.2
AR42.6 AR502
AR560 ARLL.1
ARH-XREF-COMPANY Numeric 4 AR42.2 AR42.6
Cross Reference The company associated with the cross AR502 AR560
Company referenced transaction. ARLL.1
ARH-XREF-CUSTOMER Alpha 9 (Right Justified) AR42.2 AR42.6
Cross Reference The customer associated with the cross AR560 ARLL.1
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.8 AR31.5
cross referenced in this transaction. AR33.3 AR33.5
Valid values are: AR34.1 AR42.2
AR42.6 AR502
I = Invoice AR560 AR82.1
D = Debit Memo ARLL.1 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.8 AR31.5
AR33.3 AR33.5
AR34.1 AR42.2
AR42.6 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-XREF-PYMT-SEQ Numeric 6 AR190 AR42.2
Element: Xref Pymt Seq AR42.6 AR502
AR560 ARLL.1
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. ARLL.1
ARH-DESC Alpha 30 (Lower Case) AR115 AR130
Element: Description The description of invoice or debit AR137 AR190
memo. AR30.1 AR30.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.6
AR42.7 AR502
AR560 AR82.1
ARLL.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 ARLL.1
transaction file.
ARH-TRANS-USER2 Alpha 15 AR190 AR42.2
Element: Transaction UsA user-defined field. AR42.6 AR502
AR560 ARLL.1
ARH-TRANS-USER3 Numeric 8 (yyyymmdd) AR190 AR42.2
Element: Transaction UsA user-defined field. AR42.6 AR502
AR560 ARLL.1
ARH-TRANS-USER4 Numeric 9 AR190 AR42.2
Element: Transaction UsA user-defined field. AR42.6 AR502
AR560 AR82.1
ARLL.1
ARH-TRANS-USER5 Signed 18.2 AR190 AR42.2
Element: Transaction UsA user-defined field. AR42.6 AR502
AR560 ARLL.1
ARH-AR-CODE Alpha 4 AR115 AR130
Accounts Receivable The accounts receivable code that AR137 AR190
Code identifies the accounts receivable AR30.1 AR30.8
general ledger account to be credited AR31.5 AR33.3
during cash application. AR33.5 AR34.1
AR42.1 AR42.2
AR42.7 AR44.3
AR502 AR560
AR82.1 ARLL.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.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.6
AR42.7 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARH-ORIG-RATE Signed 14.7 AR115 AR130
Element: Exchange Rate The currency exchange rate used to AR137 AR190
convert a non-base currency transaction AR30.1 AR30.8
amount to the company base currency. AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.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.8
rate is to be multiplied or divided by AR31.5 AR33.3
the original, transaction amount to AR33.5 AR34.1
calculate the base currency amount. AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-GROUP-RATE Signed 14.7 AR115 AR130
Element: Group Rate The group currency exchange rate. Used AR137 AR190
to convert a non-base currency AR30.1 AR30.8
transaction amount to the group AR31.5 AR33.3
currency. AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-GROUP-MUDV Alpha 1 AR115 AR130
Group The group currency multiply/divide AR137 AR190
Multiply/Divide indicator. AR30.1 AR30.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARH-BASE-DETAIL Signed 18.2 AR137 AR190
Element: Base Detail This is a working field used to insure AR31.5 AR33.5
balancing non-base distributions in a AR42.2 AR42.7
rounding situation. AR44.3 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.8
AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.6
AR42.7 AR44.3
AR502 AR560
AR82.1 ARLL.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.8
C = Cash Payment AR31.5 AR33.3
D = Bill of Exchange AR33.5 AR34.1
AR42.2 AR42.6
AR42.7 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.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.8
calculate prepayment discount dates and AR31.5 AR33.3
net due dates. AR33.5 AR34.1
AR42.2 AR42.6
AR42.7 AR44.3
AR502 AR560
AR82.1 ARLL.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.8
invoice may have multiple records with AR31.5 AR33.3
the same transaction number; each will AR33.5 AR34.1
have its own due date, but will be tied AR42.1 AR42.2
to the primary transaction number. AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARH-DIST-SEQ Numeric 4 AR190 AR31.5
Distribution The last distribution sequence number AR33.5 AR42.1
Sequence Number assigned to the transaction. AR42.2 AR42.7
AR43.1 AR44.3
AR507 AR560
ARLL.1 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.8
values are: AR31.5 AR33.3
AR33.5 AR34.1
B = AR invoice (AR42) AR42.2 AR42.7
C = Chargeback AR44.3 AR502
F = Finance and/or Late Payment Charges AR560 AR82.1
L = Converted data (Lawson) ARLL.1
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
ARLL.1
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.8
invoice or debit memo. Valid values are: AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.6
N = No; no revaluation needed AR42.7 AR44.3
Y = Yes; revaluation needed AR502 AR560
AR82.1 ARLL.1
ARH-TAX-EXEMPT-CD Alpha 1 AR115 AR130
Element: Tax Exempt CodThis is the customer tax exempt AR30.1 AR30.8
indicator. Used by the Lawson Order AR33.3 AR34.1
Entry system and AR invoice entry. Valid AR42.2 AR502
values are: AR560 ARLL.1
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.8
AR33.3 AR34.1
ARH-CB-ORIG-COMP Numeric 4 AR130 AR190
Element: Chargeback ComThe chargeback company. AR30.1 AR30.8
AR33.3 AR34.1
ARH-CB-SEQ-NBR Numeric 4 AR130 AR190
Chargeback Sequence The sequence number of the chargeback. AR30.1 AR30.8
Number AR33.3 AR34.1
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 AR33.5
Element: Reason Code Indicates the reason for memos. AR42.2 AR42.6
AR42.7
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 ARLL.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 ARLL.1
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. ARLL.1
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 18.2 AR137
Element: Intl Amt The late payment charge amount in
transction currrency.
ARH-LATE-CH-TR-AMT Signed 18.2 AR137
Element: Intl Amt The 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.8
I = Invoice AR31.5 AR33.3
AR33.5 AR34.1
AR42.2 AR42.7
AR44.3 AR502
AR560 AR82.1
ARLL.1
ARH-SUM-LINE Alpha 1 AR130 AR137
Element: Sum Line N = No AR190 AR30.1
Y = Yes AR30.8 AR31.5
AR33.3 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
ARLL.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 = ARLL.1
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 AR502 AR560
Element: Ac Customer IdThis field enables a link to BR-created ARLL.1
transactions and is used in Drill views.
ARH-TAX-FLAG Alpha 1 TX101
Element: All Flag This is the tax flag which indicates to
the system whether this transaction has
been interfaced into the Tax Report
files or not.
ARH-FOB-CODE Alpha 3 AR42.2
Element: Shipping Term The user defined Free On Board Code.
ARH-PORT-CD Alpha 5 AR42.2
Element: Port Cd The Intrastat port code. Must be
define
in IN04.1 (Port Maintenance)
ARH-NOTC Alpha 2 AR42.2
Element: Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
ARH-STAT-PROC Alpha 6 AR42.2
Element: Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
ARH-ORIGIN-COUNTRY Alpha 2 AR42.2
Element: Origin CountryThe country from which the goods were
shipped. Must be a valid country in
IN01.1 (Country Maintenance)
ARH-DEST-COUNTRY Alpha 2 AR42.2
Element: Dest Country The country to which the goods were
shipped. Must be a valid country in
IN01.1 (Country Maintenance).
ARH-ORIGIN-REGION Alpha 2 AR42.2
Element: Origin Region The region of the country from which the
goods were shipped, if required. Must be
a valid region in IN02.1 (Region
Maintenance)
ARH-DEST-REGION Alpha 2 AR42.2
Element: Dest Region The region of the country to which the
goods were shipped, if required. Must
be a valid region in IN02.1 (Region
Maintenance)
ARH-DROP-SHIP-IND Alpha 1 AR42.2
Element: Drop Ship Ind Specifies whether the shipment is a
drop (triangulated) shipment, that is a
shipment where goods are shipped from
one EC country to another, but a
principal in the transaction is based
elsewhere.
ARH-TRANSPORT-MODE Alpha 1 AR42.2
Element: Transport ModeThe mode of transportation at the
border crossing. Code 7 is used for the
Channel Tunnel.
1 = Sea
2 = Rail
3 = Road
4 = Air
5 = Post
7 = Fixed Installation
8 = Inland Waterway
9 = Own Propulsion
AROIHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARHSET1 COMPANY This path is used for record AR01.1 AR110
TRANS-TYPE uniqueness. AR112 AR115
INVOICE KeyChange AR12.1 AR12.2
AR124 AR129
AR130 AR131
AR135 AR137
AR140 AR145
AR150 AR155
AR180 AR190
AR191 AR196
AR20.1 AR21.1
AR21.2 AR21.3
AR21.4 AR21.6
AR235 AR24.1
AR25.1 AR250
...
ARHSET2 CUST-PO-NBR This path is used to select records by AR30.1 AR33.1
COMPANY purchase order number. AR58.1 AR90.1
CUSTOMER KeyChange
TRANS-TYPE
INVOICE
ARHSET3 COMPANY This path is used to select records by AR199 AR242
BATCH-NBR batch number. AR300 AR42.1
CUSTOMER KeyChange AR42.2 AR42.7
TRANS-TYPE AR43.1 ARLL.1
INVOICE
ARHSET4 COMPANY This path is used to select records by AR10.1 AR131
CUSTOMER customer number. AR17.1 AR191
TRANS-TYPE KeyChange AR234 AR300
INVOICE AR35.1 AR45.1
AR506 AR58.1
AR72.1 TX101
ARHSET5 ALT-TYPE This index is used to access open item AR130 AR21.4
INVOICE records by transaction number AR21.5 AR30.2
COMPANY independent of company. AR33.1 AR34.1
KeyChange AR42.2 AR42.7
AR560 AR575
AR58.1 ARLL.1
BL00.1 BL01.1
BL120 BL121
BL122 BL123
BL130 BL20.1
BL20.3 BL200
BL201 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
ARHSET6 COMPANY KeyChange AR131 AR30.1
ALT-TYPE AR31.5 AR33.5
INVOICE AR42.2 AR42.6
AR42.7 AR560
ARLL.1 BL00.1
BL01.1 BL120
BL121 BL122
BL123 BL130
BL20.1 BL20.3
BL200 BL201
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BR11.1
OE10.1 OE10.2
...
ARHSET7 COMPANY Subset AR191
CUSTOMER Where NOTICE-FL = Spaces
TRANS-TYPE And ORIG-CODE = "C"
INVOICE Or ORIG-CODE = "E"
AROIHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Not Required
ARH-TRANS-USER1 -> CNT-CONTRACT
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
Achisthdr ACHISTHDR
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
HIH-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
Arusersort ARUSERSORT
ARH-COMPANY -> USS-COMPANY
ARH-TRANS-TYPE -> USS-TRANS-TYPE
ARH-INVOICE -> USS-INVOICE
USS-PAYMENT-SEQ
|