AROIHDR FILE AR Transaction Header AR Transaction Header REFERENCED BY AC115 AR01.1 AR100 AR105 AR110 AR124 AR131 AR132 AR135 AR136 AR140 AR141 AR150 AR155 AR161 AR180 AR194 AR196 AR20.1 AR21.1 AR21.2 AR21.3 AR21.4 AR21.5 AR230 AR232 AR233 AR235 AR24.1 AR25.1 AR250 AR251 AR252 AR253 AR255 AR256 AR258 AR274 AR275 AR282 AR286 AR287 AR294 AR35.1 AR35.2 AR36.1 AR36.2 AR46.1 AR50.1 AR504 AR505 AR506 AR507 AR53.1 AR570 AR575 AR58.1 AR580 AR700 AR73.1 AR74.1 AR80.1 AR80.2 AR90.1 AR980 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 CB06.2 CB191 DT170 GL235 OE114 OE129 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 AR72.1 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 AR953 AR954 AR976 DT150 DT180 DT181 DT40.1 DT45.1 DT520 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 AR953 AR954 AR976 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 AR82.1 AR953 AR954 AR976 DT92.1 ARH-TRANS-NBR Alpha 10 (Right Justified) AR115 AR130 Transaction Number The transaction number. This is either AR137 AR190 the invoice, credit memo or debit memo AR30.1 AR30.2 number, depending on the type of AR30.4 AR30.8 transaction. AR31.5 AR42.2 AR42.7 AR44.3 AR502 AR560 AR82.1 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR82.1 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR82.1 AR953 AR954 AR976 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 AR82.1 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR44.3 AR502 AR560 AR82.1 AR953 AR954 AR976 DT92.1 ARH-CUST-PO-NBR Alpha 20 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 AR953 AR954 AR976 ARH-XREF-COMPANY Numeric 4 AR42.2 AR42.6 Cross Reference The company associated with the cross AR502 AR560 Company referenced transaction. AR954 AR976 ARH-XREF-CUSTOMER Alpha 9 (Right Justified) AR42.2 AR42.6 Cross Reference The customer associated with the cross AR560 AR954 Customer referenced transaction. AR976 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 AR82.1 AR953 D = Debit Memo AR954 AR976 C = Credit Memo DT92.1 ARH-XREF-NBR Alpha 10 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 AR82.1 AR953 AR954 AR976 DT92.1 ARH-XREF-SEQ Numeric 3 AR190 AR42.2 Cross Reference The cross reference transaction AR42.6 AR502 Sequence sequence number. AR560 AR953 AR954 AR976 ARH-XREF-DUE-DATE Numeric 8 (yyyymmdd) AR42.2 AR42.6 Cross Reference Due The due date of the cross referenced AR954 AR976 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. AR954 AR976 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 AR953 AR954 AR976 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 AR953 transaction file. AR954 AR976 ARH-TRANS-USER2 Alpha 15 AR190 AR42.2 Transaction User 2 A user-defined field. AR42.6 AR502 AR560 AR953 AR954 AR976 ARH-TRANS-USER3 Numeric 8 (yyyymmdd) AR190 AR42.2 Transaction User 3 A user-defined field. AR42.6 AR502 AR560 AR953 AR954 AR976 ARH-TRANS-USER4 Numeric 9 AR190 AR42.2 Transaction User 4 A user-defined field. AR42.6 AR502 AR560 AR82.1 AR953 AR954 AR976 ARH-TRANS-USER5 Signed 13.2 AR190 AR42.2 Transaction User 5 A user-defined field. AR42.6 AR502 AR560 AR953 AR954 AR976 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 AR953 AR954 AR976 DT92.1 ARH-SALESMAN Numeric 4 AR115 AR130 Sales Rep 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR30.4 AR30.8 AR31.5 AR42.2 AR42.6 AR42.7 AR44.3 AR502 AR560 AR82.1 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR953 AR954 AR976 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 AR82.1 AR953 AR954 AR976 DT150 DT180 DT181 DT40.1 DT520 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 AR953 L = Converted data (Lawson) AR954 AR976 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 AR976 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 AR953 AR976 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 AR953 AR976 T = Taxable E = Exempt ARH-NOTICE-FL Alpha 1 AR191 AR953 Notice Flag Identifies whether to print notices. AR976 ARH-CB-REASON Alpha 4 AR130 AR190 Chargeback Reason The chargeback reason code. AR30.1 AR30.2 AR30.4 AR30.8 AR953 AR976 ARH-CB-ORIG-COMP Numeric 4 AR130 AR190 Chargeback Company The chargeback company. AR30.1 AR30.2 AR30.4 AR30.8 AR953 AR976 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 AR953 AR976 ARH-CANCEL-FLAG Alpha 1 AR29.3 AR976 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 AR42.2 AR42.6 Reason Code Indicates the reason for memos. AR42.7 AR976 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 AR953 AR976 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 AR42.2 AR42.6 Late Charge Flag Late Charge Flag. Indicates if late AR560 charge is to be applied to the invoice. Y = Yes N = No ARH-LATE-CH-TR-NBR Alpha 10 (Right Justified) AR137 Late Charge The transaction number of the late Transaction Number payment charge invoice. ARH-LATE-CH-OR-AMT Signed 15.2 AR137 Late Charge Amnt - The late payment charge amount in Trans Curr transaction currency. ARH-LATE-CH-TR-AMT Signed 15.2 AR137 Late Charge Amount The late payment charge amount in - Comp Curr company base currency. ARH-SUM-LINE Alpha 1 AR115 AR130 Summarize Open Item Determines whether line items are AR137 AR30.1 Line Items displayed in summary or detail. AR30.2 AR30.4 N = No AR30.8 AR42.1 Y = Yes AR42.2 AR42.6 AR42.7 AR43.1 AR44.3 AR502 AR560 AR82.1 ARH-INTRASTAT-NBR Numeric 10 AR42.2 AR560 Intrastat Number The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added. ARH-SHIP-TO-CTRY Alpha 2 AR42.2 AR560 Ship To Country The ship-to country code. Must be a valid Intrastat country code, defined in IN01.1 (Country Maintenance) ARH-SHIP-FR-CTRY Alpha 2 AR42.2 AR560 Ship From Country The ship-from country code. Must be a valid Intrastat country code defined in IN01.1 (Country Maintenance) ARH-SHIP-TO-REGION Alpha 2 AR42.2 AR560 Ship To Region The ship-to region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance). ARH-SHIP-FR-REGION Alpha 2 AR42.2 AR560 Ship From Region The ship-from region code. Used for Intrastat reporting only. Must be a valid region for the country in IN02.1 (Region Maintenance). ARH-DUN-LTR-IND Alpha 1 Dunning Letter Dunning Letters in use for customer. Yes Indicator or No. Specified in AR10.1 (Customer). Applies only to the advanced dunning process. Y = Yes N = No ARH-OVERIDE-DUNPRC Alpha 1 AR42.6 AR45.1 Override Dunning Override dunning process. Process " " = Normal processing 1 = Bypass dunning entirely 2 = Do not send for collection ARH-DUN-PROCESS-CD Alpha 6 AR145 Dunning Process Code Dunning letter process code for thetransaction. A unique code that represents a combination of Dunning Letter options. ARH-LST-DUNLTR-STM Numeric 2 AR145 Last Dunning Letter Level of the last dunning letter sent as Level 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 Dunning Letter Date last dunning letter was issued for Date this invoice. ARH-LST-LTRTEXT-CD Alpha 6 AR145 Last Dunning Letter Text code for last dunning letter sent Text Code on this invoice. ARH-SENT-FOR-COLL Alpha 1 AR145 Sent For Collection Sent for collection. This indicates whether the invoice has been sent for collection (Yes or No). Y = Yes N = No ARH-ASSESS-DUN-FEE Alpha 1 AR145 Assess Dunning Fee? Specifies whether to assess a dunning letter fee. Y = Yes N = No AROIHDR FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ARHSET1 COMPANY This path is used for record AC115 AR01.1 TRANS-TYPE uniqueness. AR100 AR105 TRANS-NBR AR110 AR115 AR124 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 AR230 ... 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 AR72.1 AR73.1 TRANS-TYPE AR90.1 TRANS-NBR ARHSET3 COMPANY This path is used to select records by AR199 AR242 BATCH-NBR batch number. AR300 AR42.1 CUSTOMER AR42.2 AR42.7 TRANS-TYPE AR43.1 TRANS-NBR ARHSET4 COMPANY This path is used to select records by AR10.1 AR131 CUSTOMER customer number. AR150 AR17.1 TRANS-TYPE AR191 AR227 TRANS-NBR AR230 AR232 AR233 AR234 AR271 AR300 AR45.1 AR506 AR58.1 AR72.1 ARHSET5 TRANS-TYPE This index is used to access open item AR130 AR21.4 TRANS-NBR records by transaction number AR21.5 AR30.3 COMPANY independent of company. AR30.4 AR30.9 AR44.3 AR575 AR58.1 AROIHDR FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH 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-TRANS-NBR -> UIH-TRANS-NBR 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-TRANS-NBR -> CMT-TRANS-NBR CMT-BEG-DATE CMT-SEQ-NBR Ardistrib ARDISTRIB Delete Cascades ARH-COMPANY -> AMD-COMPANY ARH-BATCH-NBR -> AMD-BATCH-NBR ARH-TRANS-TYPE -> AMD-TRANS-TYPE ARH-TRANS-NBR -> AMD-TRANS-NBR ARH-CUSTOMER -> AMD-CUSTOMER AMD-DIST-SEQ Aroitems AROITEMS Delete Cascades ARH-COMPANY -> ARO-COMPANY ARH-TRANS-TYPE -> ARO-TRANS-TYPE ARH-TRANS-NBR -> ARO-TRANS-NBR ARO-PAYMENT-SEQ |