Lawson Insight Technical Documentation |
|
AROIHDR
AROIHDR FILE
AR Transaction Header
The AR Transaction Header represents invoice, debit memo and credit memo
header information. There will be subordinate records to this file that will
carry individual attributes (due dates, amounts, etc...) for each of the
"line items" of a transaction header. At least one "line item" will exist for
each transaction header record.
REFERENCED BY
AC56.1 AC560 AR01.1 AR110 AR112 AR12.1
AR12.2 AR124 AR129 AR131 AR135 AR140
AR141 AR150 AR155 AR180 AR196 AR20.1
AR21.1 AR21.2 AR21.3 AR21.4 AR21.6 AR21.5
AR235 AR239 AR24.1 AR25.1 AR251 AR255
AR257 AR274 AR282 AR286 AR287 AR293
AR300 AR35.1 AR35.2 AR36.1 AR36.2 AR38.1
AR38.2 AR38.3 AR39.1 AR39.2 AR46.1 AR48.1
AR48.3 AR50.1 AR504 AR505 AR507 AR53.1
AR570 AR575 AR58.1 AR580 AR74.1 AR80.1
AR80.2 AR800 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 BL98.1 BR11.1 BR48.1
CB06.2 CB191 DT170 DT520 GL235 WH20.7
AR199 AR242 AR10.1 AR17.1 AR234 AR506
AR72.1
UPDATED BY
AR115 AR130 AR137 AR145 AR190 AR191
AR29.3 AR30.1 AR30.8 AR32.1 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARH-COMPANY Numeric 4 AR115 AR130
Element: Company The number representing an AR company. AR137 AR190
AR30.1 AR30.8
AR32.1 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. Valid AR137 AR190
values are: AR30.1 AR30.8
AR32.1 AR33.3
C = Credit Memo AR33.5 AR34.1
D = Debit Memo AR42.2 AR42.7
I = Invoice AR44.3 AR502
M = Mixed AR560 AR82.1
ARLL.1 DT92.1
ARH-INVOICE Alpha 22 AR115 AR130
Element: Invoice Used to identify the invoice. AR137 AR190
AR30.1 AR30.8
AR32.1 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
AR32.1 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 AR32.1
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
AR32.1 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. AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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 AR32.1
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 AR32.1
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 AR32.1
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 The sequence number of the cross AR42.6 AR502
reference transaction. 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
AR32.1 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 to the transaction. This AR560 ARLL.1
is used for sorting and selecting
purposes.
ARH-TRANS-USER2 Alpha 15 AR190 AR42.2
Element: Transaction UsTransaction 2 user-defined field. AR42.6 AR502
AR560 ARLL.1
ARH-TRANS-USER3 Numeric 8 (yyyymmdd) AR190 AR42.2
Element: Transaction UsTransaction 3 user-defined field. AR42.6 AR502
AR560 ARLL.1
ARH-TRANS-USER4 Numeric 9 AR190 AR42.2
Element: Transaction UsTransaction 4 user-defined field. AR42.6 AR502
AR560 AR82.1
ARLL.1
ARH-TRANS-USER5 Signed 18.2 AR190 AR42.2
Element: Transaction UsTransaction 5 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 AR32.1 AR33.3
(or debited if a credit memo) during AR33.5 AR34.1
cash application. 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
AR32.1 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. AR32.1 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 AR32.1 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 AR32.1 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
AR32.1 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 AR33.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 A transaction code representing a type AR137 AR190
of cash payment (with atributes for AR30.1 AR30.8
either receiving AP payments, or AR32.1 AR33.3
creating EFT payments), bill of AR33.5 AR34.1
exchange payment, or bank service AR42.2 AR42.6
transaction. AR42.7 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARH-BANK-INST-TYPE Alpha 1 AR115 AR130
Element: Bank Inst TypeThis categorizes the type of bank AR137 AR190
instrument. AR30.1 AR30.8
C = Cash Payment AR32.1 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 AR32.1 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 AR32.1 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 AR33.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 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: AR32.1 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: AR32.1 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 Cd This is the customer tax exempt AR30.1 AR30.8
indicator. Used by the Lawson Order AR32.1 AR33.3
Entry system and AR invoice entry. Valid AR34.1 AR42.2
values are: AR502 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
AR32.1 AR33.3
AR34.1
ARH-CB-ORIG-COMP Numeric 4 AR130 AR190
Element: Chargeback ComThe chargeback company. AR30.1 AR30.8
AR32.1 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 AR32.1 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 AR33.5 AR42.2
Element: Reason Code Indicates the reason for memos. 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 AR502
charge is to be applied to the invoice. AR560 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
ARH-LATE-CH-TR-AMT Signed 18.2 AR137
Element: Intl Amt
ARH-ALT-TYPE Alpha 1 AR115 AR130
Element: Alt Type C = Credit Memo AR137 AR190
D = Debit Memo AR30.1 AR30.8
I = Invoice AR32.1 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 AR32.1
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 A two-character code representing an AR44.3 AR502
application used within the Lawson AR560 AR82.1
system. (i.e.: BR = Billing & Revenue). ARLL.1
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: Fob Code The user defined Free On Board Code.
ARH-PORT-CD Alpha 5 AR42.2
Element: Port Cd The Intrastat port code. Must be
defined 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 KeyChange AC56.1 AC560
TRANS-TYPE AR01.1 AR110
INVOICE AR112 AR115
AR12.1 AR12.2
AR124 AR129
AR130 AR131
AR135 AR137
AR140 AR141
AR145 AR150
AR155 AR180
AR190 AR191
AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR21.4
AR21.6 AR235
...
ARHSET2 CUST-PO-NBR KeyChange AR30.1 AR33.1
COMPANY AR58.1 AR90.1
CUSTOMER
TRANS-TYPE
INVOICE
ARHSET3 COMPANY KeyChange AR199 AR242
BATCH-NBR AR300 AR42.1
CUSTOMER AR42.2 AR42.7
TRANS-TYPE AR43.1 ARLL.1
INVOICE
ARHSET4 COMPANY KeyChange AR10.1 AR131
CUSTOMER AR17.1 AR191
TRANS-TYPE AR234 AR300
INVOICE AR34.1 AR35.1
AR45.1 AR506
AR58.1 AR72.1
AR90.1 TX101
ARHSET5 ALT-TYPE KeyChange AC56.1 AC560
INVOICE AR01.1 AR130
COMPANY AR21.4 AR21.5
AR30.2 AR33.1
AR33.5 AR42.2
AR42.7 AR44.3
AR502 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
...
ARHSET6 COMPANY KeyChange AC56.1 AC560
ALT-TYPE AR01.1 AR131
INVOICE AR30.1 AR33.5
AR42.2 AR42.6
AR42.7 AR44.3
AR502 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
...
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
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
Aradjust ARADJUST
ARH-COMPANY -> ADJ-COMPANY
ARH-TRANS-TYPE -> ADJ-TRANS-TYPE
ARH-INVOICE -> ADJ-INVOICE
ADJ-PAYMENT-SEQ
ADJ-BATCH-NBR
ADJ-APP-SEQ
ADJ-ADJ-SEQ
Arapplied ARAPPLIED
ARH-COMPANY -> ARA-COMPANY
ARH-TRANS-TYPE -> ARA-TRANS-TYPE
ARH-INVOICE -> ARA-INVOICE
ARA-PAYMENT-SEQ
ARA-BATCH-NBR
ARA-APP-SEQ
Arappliedcr ARAPPLIED
ARH-COMPANY -> ARA-CR-COMPANY
ARH-CUSTOMER -> ARA-CR-CUSTOMER
ARH-TRANS-TYPE -> ARA-CR-TYPE
ARH-INVOICE -> ARA-CR-NBR
ARA-CR-PYMNT-SEQ
ARA-CR-BATCH
ARA-CR-SUFFIX
ARA-CR-CANCEL-SEQ
ARA-CR-APP-SEQ
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
Arsadjust ARSADJUST
ARH-COMPANY -> ASJ-COMPANY
ARH-TRANS-TYPE -> ASJ-TRANS-TYPE
ARH-INVOICE -> ASJ-INVOICE
ARH-COMPANY -> ASJ-PAYMENT-SEQ
ASJ-ADJ-SEQ
Arsapplied ARSAPPLIED
ARH-COMPANY -> ASG-COMPANY
ARH-TRANS-TYPE -> ASG-TRANS-TYPE
ARH-INVOICE -> ASG-INVOICE
ASG-PAYMENT-SEQ
Arusersort ARUSERSORT
ARH-COMPANY -> USS-COMPANY
ARH-TRANS-TYPE -> USS-TRANS-TYPE
ARH-INVOICE -> USS-INVOICE
USS-PAYMENT-SEQ
|