AROIHDR

Acct Receivables Trans 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 AR09.1 AR09.4 AR10.1
AR11.1 AR12.1 AR12.2 AR13.1 AR13.2 AR210
AR301 AR501 AR550 BR11.1 BR48.1 CB06.2
CB191 GL235 TX140 WH20.2 WH20.7 AR17.1


UPDATED BY
ARLL.1 TX101

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARH-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ARLL.1
ARH-TRANS-TYPE
Element: Transaction Type
Alpha 1
Indicates the type of transaction. Valid values are: C = Credit Memo D = Debit Memo I = Invoice M = Mixed
ARLL.1
ARH-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
ARLL.1
ARH-STATUS
Element: Transaction Status
Numeric 1
This field contains the status of the transaction. Valid values are 0 = Unreleased 1 = Released
ARLL.1
ARH-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Customer number.
ARLL.1
ARH-BATCH-NBR
Element: Batch Number
Numeric 6
This identifies the batch the entered invoices and debit memos are part of.
ARLL.1
ARH-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
ARLL.1
ARH-TRANS-DATE
Element: Transaction Date
Numeric 8 (yyyymmdd)
This field contains the date of the transaction.
ARLL.1
ARH-GL-DATE
Element: General Ledger Date
Numeric 8 (yyyymmdd)
This field contains the general ledger posting date.
ARLL.1
ARH-ORIG-CURRENCY
Element: Transaction Currency
Alpha 5
The transaction currency code.
ARLL.1
ARH-ORIG-ND
Element: Number of Decimals
Numeric 1
Currency decimal indicator.
ARLL.1
ARH-ORIG-AMT
Element: Transaction Amount
Signed 18.2
The amount of the transaction in transaction currency.
ARLL.1
ARH-TRAN-AMT
Element: Base Amount
Signed 18.2
The total amount of the transaction in the company base currency.
ARLL.1
ARH-CUST-PO-NBR
Element: Customer PO Number
Alpha 22
The customer purchase order number assigned to the invoice.
ARLL.1
ARH-XREF-COMPANY
Cross Reference
Company
Numeric 4
The company associated with the cross referenced transaction.
ARLL.1
ARH-XREF-CUSTOMER
Cross Reference
Customer
Alpha 9 (Right Justified)
The customer associated with the cross referenced transaction.
ARLL.1
ARH-XREF-TYPE
Element: Cross Reference Type
Alpha 1
The type of cross reference. Used to identify the reference number being cross referenced in this transaction. Valid values are: I = Invoice D = Debit Memo C = Credit Memo
ARLL.1
ARH-XREF-NBR
Cross Reference
Number
Alpha 22
The cross reference number entered when the transaction was created.
ARLL.1
ARH-XREF-PYMT-SEQ
Element: Xref Pymt Seq
Numeric 6
The sequence number of the cross reference transaction.
ARLL.1
ARH-XREF-DUE-DATE
Cross Reference Due
Date
Numeric 8 (yyyymmdd)
The due date of the cross referenced transaction.
ARH-AUTO-APP-FL
Automatic
Application Flag
Alpha 1
Indicates if the transaction is eligible for automatic cash application.
ARLL.1
ARH-DESC
Element: Description
Alpha 30 (Lower Case)
The description of invoice or debit memo.
ARLL.1
ARH-TRANS-USER1
Element: Transaction User 1
Alpha 10
A user-defined field that is built with an access path to the transaction. This is used for sorting and selecting purposes.
ARLL.1
ARH-TRANS-USER2
Element: Transaction User 2
Alpha 15
Transaction 2 user-defined field.
ARLL.1
ARH-TRANS-USER3
Element: Transaction User 3
Numeric 8 (yyyymmdd)
Transaction 3 user-defined field.
ARLL.1
ARH-TRANS-USER4
Element: Transaction User 4
Numeric 9
Transaction 4 user-defined field.
ARLL.1
ARH-TRANS-USER5
Element: Transaction User 5
Signed 18.2
Transaction 5 user-defined field.
ARLL.1
ARH-AR-CODE
Accounts Receivable
Code
Alpha 4
The accounts receivable code that identifies the accounts receivable general ledger account to be credited (or debited if a credit memo) during cash application.
ARLL.1
ARH-SALESMAN
Element: SalesRep
Numeric 4
The sales representative. Defaults from AR Company Customer file.
ARLL.1
ARH-ORIG-RATE
Element: Exchange Rate
Signed 14.7
The currency exchange rate used to convert a non-base currency transaction amount to the company base currency.
ARLL.1
ARH-CURR-MUDV
Currency
Multiply/Divide
Alpha 1
The currency multiply/divide indicator. Indicates whether the currency exchange rate is to be multiplied or divided by the original, transaction amount to calculate the base currency amount.
ARLL.1
ARH-GROUP-RATE
Element: Group Rate
Signed 14.7
The group currency exchange rate. Used to convert a non-base currency transaction amount to the group currency.
ARLL.1
ARH-GROUP-MUDV
Group
Multiply/Divide
Alpha 1
The group currency multiply/divide indicator.
ARLL.1
ARH-BASE-DETAIL
Element: Base Detail
Signed 18.2
This is a working field used to insure balancing non-base distributions in a rounding situation.
ARH-BANK-INST-CODE
Element: Payment Code
Alpha 3
A transaction code representing a type of cash payment (with atributes for either receiving AP payments, or creating EFT payments), bill of exchange payment, or bank service transaction.
ARLL.1
ARH-BANK-INST-TYPE
Element: Bank Inst Type
Alpha 1
This categorizes the type of bank instrument.
C = Cash Payment
D = Bill of Exchange
ARLL.1
ARH-TERMS-CD
Element: Terms Code
Alpha 5
The terms code used in the generation of invoice obligations. Used to calculate prepayment discount dates and net due dates.
ARLL.1
ARH-PAYMENT-SEQ
Element: Payment Sequence
Numeric 6
The last sequence number used in generating invoice obligations. An invoice may have multiple records with the same transaction number; each will have its own due date, but will be tied to the primary transaction number.
ARLL.1
ARH-DIST-SEQ
Distribution
Sequence Number
Numeric 4
The last distribution sequence number assigned to the transaction.
ARLL.1
ARH-ORIG-CODE
Element: Origin Code
Alpha 1
A system-generated code that identifies where the record originated. Valid values are: B = AR invoice (AR42) C = Chargeback F = Finance and/or Late Payment Charges 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
ARLL.1
ARH-BILL-TO
Element: Bill To
Numeric 4
The bill to location for the open item.
ARLL.1
ARH-REVALUE-FL
Element: Revaluation
Alpha 1
This field indicates if a currency revaluation is needed for this non-base invoice or debit memo. Valid values are: N = No; no revaluation needed Y = Yes; revaluation needed
ARLL.1
ARH-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
This is the customer tax exempt indicator. Used by the Lawson Order Entry system and AR invoice entry. Valid values are: T = Taxable E = Exempt
ARLL.1
ARH-NOTICE-FL
Element: Notice Flag
Alpha 1
Identifies whether to print notices.
ARH-CB-REASON
Element: Chargeback Reason
Alpha 4
The chargeback reason code.
ARH-CB-ORIG-COMP
Element: Chargeback Company
Numeric 4
The chargeback company.
ARH-CB-SEQ-NBR
Chargeback Sequence
Number
Numeric 4
The sequence number of the chargeback.
ARH-CANCEL-FLAG
Element: Cancellation Flag
Alpha 1
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
Element: Reason Code
Alpha 4
Indicates the reason for memos.
ARLL.1
ARH-JRNL-BOOK-NBR
Element: Journal Book Number
Alpha 12
This field contains the journal book number for this transaction header record.
ARLL.1
ARH-TAX-FL
Element: Tax Point
Alpha 1
Indicates tax point origin, used for tax calculation. Valid values are: N = No tax calculation Y = Payment origin
ARLL.1
ARH-LATE-CH-FL
Element: Late Ch Fl
Alpha 1
Late Charge Flag. Indicate if late charge is to be applied to the invoice.
ARLL.1
ARH-LATE-CH-TR-NBR
Element: Late Ch Tr Nbr
Alpha 10 (Right Justified)
The transaction number of the late payment charge invoice.
ARH-LATE-CH-OR-AMT
Element: Intl Amt
Signed 18.2
ARH-LATE-CH-TR-AMT
Element: Intl Amt
Signed 18.2
ARH-ALT-TYPE
Element: Alt Type
Alpha 1

C = Credit Memo
D = Debit Memo
I = Invoice
ARLL.1
ARH-SUM-LINE
Element: Sum Line
Alpha 1

N = No
Y = Yes
ARLL.1
ARH-SYSTEM
Element: System
Alpha 2
A two-character code representing an application used within the Lawson system. (i.e.: BR = Billing & Revenue).
ARLL.1
ARH-DUN-LTR-IND
Element: Dun Ltr Ind
Alpha 1
Dunning letters in use for customer. Yes or No. Specified in AR10.1 (customer). Applies only to the advanced dunning process.
ARH-OVERIDE-DUNPRC
Element: Overide Dunprc
Alpha 1
Override Dunning Process.
ARH-DUN-PROCESS-CD
Element: Dun Process Cd
Alpha 6
Dunning letter process code for thetransaction A unique code that represents a combinatioin of Dunning Letter options.
ARH-LST-DUNLTR-STM
Element: Lst Dunltr Stm
Numeric 2
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
Element: Last Ltr Date
Numeric 8 (yyyymmdd)
Date last dunning letter was sent for the invoice.
ARH-LST-LTRTEXT-CD
Element: Lst Ltrtext Cd
Alpha 6
Text Code for last Dunning Letter sent on this invoice.
ARH-SENT-FOR-COLL
Element: Sent For Coll
Alpha 1
Sent for collection. This indicates whether the invoice has been sent for collection (Yes or No).
ARH-ASSESS-DUN-FEE
Element: Assess Dun Fee
Alpha 1
Specifies whether to assess a dunning letter fee.
ARH-INV-OBJ-ID
Element: Inv Obj Id
Numeric 12
ARH-AC-CUSTOMER-ID
Element: Ac Customer Id
Alpha 5
This field enables a link to BR-created transactions and is used in Drill views.
ARLL.1
ARH-TAX-FLAG
Element: All Flag
Alpha 1
This is the tax flag which indicates to the system whether this transaction has been interfaced into the Tax Report files or not.
TX101
ARH-FOB-CODE
Element: Fob Code
Alpha 3
The user defined Free On Board Code.
ARH-PORT-CD
Element: Port Cd
Alpha 5
The Intrastat port code. Must be defined in IN04.1 (Port Maintenance)
ARH-NOTC
Element: Notc
Alpha 2
The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
ARH-STAT-PROC
Element: Stat Proc
Alpha 6
The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).
ARH-ORIGIN-COUNTRY
Element: Origin Country
Alpha 2
The country from which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance)
ARLL.1
ARH-DEST-COUNTRY
Element: Dest Country
Alpha 2
The country to which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance).
ARLL.1
ARH-ORIGIN-REGION
Element: Origin Region
Alpha 2
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
Element: Dest Region
Alpha 2
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
Element: Drop Ship Ind
Alpha 1
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
Element: Transport Mode
Alpha 1
The 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
ARH-GRANT
Element: Grant
Alpha 30
ARLL.1
ARH-FOR-ECON-CODE
Element: Code
Alpha 10
ARH-GLBL-DOC-TYPE
Element: Glbl Doc Type
Alpha 10
ARH-TAX-AMT
Element: Intl Amt
Signed 18.2


AROIHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARHSET1 COMPANY
TRANS-TYPE
INVOICE
KeyChange
AC56.1 AC560
AR01.1 AR09.1
AR09.4 AR10.1
AR11.1 AR12.1
AR12.2 AR13.1
AR13.2 AR210
AR301 AR501
AR550 ARLL.1
BR11.1 BR48.1
CB06.2 CB191
GL235 TX101
TX140 WH20.2
WH20.7
ARHSET2 CUST-PO-NBR
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
KeyChange
ARHSET3 COMPANY
BATCH-NBR
CUSTOMER
TRANS-TYPE
INVOICE
KeyChange
ARLL.1
ARHSET4 COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
KeyChange
AR10.1 AR17.1
TX101
ARHSET5 ALT-TYPE
INVOICE
COMPANY
KeyChange
AC56.1 AC560
AR01.1 ARLL.1
BR11.1 BR48.1
WH20.2 WH20.7
ARHSET6 COMPANY
ALT-TYPE
INVOICE
KeyChange
AC56.1 AC560
AR01.1 ARLL.1
BR11.1 BR48.1
WH20.2 WH20.7
ARHSET7 COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
Subset
WhereNOTICE-FL =Spaces
AndORIG-CODE ="C"
OrORIG-CODE ="E"


AROIHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Not Required
ARH-TRANS-USER1->CNT-CONTRACT (CNTSET1)
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
NAME
RELATED 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
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


File created: Thu Jun 09 02:09:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.