Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACHISTHDR


                             ACHISTHDR FILE

                             Invoice Header

The Billing and Revenue Invoice Header file contains the control information
associated with an invoice.  The file is keyed by Obj-ID.

REFERENCED BY

AC300     AC310     BR02.3    BR02.1    BR09.1    BR120
BR121     BR123     BR140     BR151     BR152     BR156
BR16.1    BR21.1    BR220     BR420     BR521     BR580
BR245     BR400

UPDATED BY

BR122     BR131     BR145     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR20.7    BR45.1    BR46.1    BR46.2
BR46.4    BRIP.1    TX101     BR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HIH-OBJ-ID             Numeric 12                                BRIP.1
Element: Obj Id        The object identifier. It is a unique
                       number used to relate the invoice Header
                       to the  invoice detail lines
                       (ACHISTDTL).

HIH-COMPANY            Numeric 4                                 BRIP.1
Element: Company       Identifies the Accounts Receivable
                       company which is maintained in AR10.

HIH-CUSTOMER           Alpha 9  (Right Justified)                BRIP.1
Element: Customer      Identifies the AR customer associated
                       with the invoice.

HIH-INVOICE            Alpha 22                                  BRIP.1
Element: Invoice       Used to identify the invoice. Represents
                       the invoice prefix and the invoice
                       number and will be the invoice in AR.

HIH-INVOICE-PREFIX     Alpha 2                                   BRIP.1
Element: Invoice PrefixThe Invoice Prefix or the Credit Memo
                       Prefix value that is maintained in the
                       AC Customer (BR11). This must be unique
                       by system code and company.

HIH-INVOICE-NBR        Numeric 8                                 BRIP.1
Element: Invoice Nbr   The next sequential Accounts Receivable
                       invoice  number.

HIH-PROCESS-LEVEL      Alpha 5                                   BRIP.1
Element: Process Level The Accounts Receivable process level,
                       which is the reporting hierarchy below
                       the AR Company.  Defined in AC Customer
                       (BR11).

HIH-DUE-DATE           Numeric 8  (yyyymmdd)                     BRIP.1
Element: Due Date      The invoice due date, derived from the
                       "Invoice Terms Code" in Accounts
                       Receivable Customer (AR10).

HIH-BILL-TO            Numeric 4                                 BR02.3  BR120
Element: Bill To       This is the "Bill To" code that           BR121   BR122
                       represents the customers billing          BR123   BR140
                       address.  The address will be defaulted   BR151   BR152
                       from the AR Customer address if this      BR156   BR20.1
                       Bill-To code field is not filled in. The  BR20.2  BR20.3
                       Bill To addresses are maintained in the   BR20.4  BR20.5
                       AR Bill To (AR09.4).                      BR20.7  BR420
                                                                 BR521   BRIP.1

HIH-CONTRACT           Alpha 15                                  BRIP.1
Element: Contract      The contract maintained on Contract
                       (BR10).  This field is blank if the
                       invoice combines multiple contracts or
                       the invoice is created using the Single
                       Invoice Calculation (BR19).

HIH-CONTACT-CODE       Alpha 5                                   BR20.7  BRIP.1
Element: Contact Code  The contact code represents the contact
                       information, this is attached to he AC
                       Customer in (BR11).

HIH-AR-DETAIL          Alpha 1                                   BRIP.1
Element: Ar Detail     The AR Interface Option maintained on
                       the AC Customer (BR11).
                       The valid values are:
                       S=Summary
                       D=Detail
                       A=Activity
                       S = Summary
                       D = Detail
                       A = Activity/Acct Cat

HIH-INVOICE-TYPE       Alpha 1                                   BRIP.1
Element: Invoice Type  Indicates whether the invoice is a
                       retainer, regular or cancelled invoice.
                       The values are:
                       R=Retainer
                       I=Invoice
                       B=Invoice Cancel
                       R = Retainer
                       I = Invoice
                       B = Invoice Cancel
                       C = Auto generated retainer credit

HIH-INVOICE-DATE       Numeric 8  (yyyymmdd)                     BR20.7  BRIP.1
Element: Invoice Date  The date of the invoice, which is
                       defined on the BR19 or BR120 programs.
                       If not entered in these programs then
                       the  Through Date will default. If the
                       Through date is left blank the system
                       date will default.

HIH-POSTING-DATE       Numeric 8  (yyyymmdd)                     BR20.7  BRIP.1
Element: Posting Date  The date assigned to the journal entry
                       for posting. This date will be defaulted
                       from the Through Date on the BR19 or
                       BR120 forms, or if the Through Date is
                       left blank the system date will default.

HIH-REFERENCE          Alpha 10  (Lower Case)                    BRIP.1
Element: Reference     This is filled with the program token
                       that created the record.  They can only
                       be BR02, BR19, BR21, BR45, BR120, BR121
                       and BR140.

HIH-CURRENCY-CODE      Alpha 5                                   BRIP.1
Element: Currency Code The contract currency code established
                       in Contract (BR10).

HIH-CURR-ND            Numeric 1                                 BRIP.1
Element: Acct Nd       The number of decimals defined for the
                       currency of the object.

HIH-INVOICE-AMT        Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The total invoice amount.                 BR20.3  BR20.4
                                                                 BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HIH-UNITS-AMOUNT       Signed 15.2                               BR20.1  BR20.2
Element: Units Amount  The total units for the invoice.          BR20.3  BR20.4
                                                                 BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HIH-CUST-PO-NBR        Alpha 22                                  BR20.7  BRIP.1
Element: Cust Po Nbr   The purchase order number maintained in
                       the Contract (BR10).

HIH-INVC-OPTIONS       Alpha 1                                   BRIP.1
Element: Invc Options  The first Summarize by option
                       maintained on the AC Customer (BR11).
                       The valid values are:
                       A=Account Category
                       B=Summary Acct Cat
                       C=Attribute
                       D=Resource
                       A = Accountt Category
                       B = Contract Category Group
                       C = Attribute
                       D = Resource
                       E = Summary Account Category

HIH-INVC-FORMAT        Alpha 1                                   BRIP.1
Element: Invc Format   The Invoice Format option maintained on
                       the AC Customer (BR11).
                       The valid values are:
                       S=Standard
                       C=Customized
                       F=Fax with Standard
                       E=EDI with Standard
                       S = Standard
                       C = Customized
                       F = Fax
                       E = EDI
                       V = Custom Vat

HIH-RETAIN-ID          Numeric 6                                 BRIP.1
Element: Retain Id     The Retainer Sequence maintained on the
                       Retainer Parameters (BR02).

HIH-RETAIN-DESC        Alpha 30                                  BRIP.1
Element: Retain Desc   The retainer description maintained on
                       the Retainer Parameters (BR02).

HIH-CUM-FLAG           Alpha 1                                   BRIP.1
Element: Cum Flag      The Cumlative Totals flag maintained on
                       the AC Customer (BR11). This tells us
                       whether or not the cumulative totals
                       are to be displayed on the invoice.
                       The valid values are:
                       Y=Yes
                       N=No

HIH-INVC-SUMM-OPT      Alpha 1                                   BRIP.1
Element: Invc Summ Opt The Invoice Print Option maintained on
                       the AC Customer (BR11).
                       The valid values are:
                       D=Detail
                       S=Summary
                       D = Detail
                       S = Summary

HIH-INVC-OPTION-2      Alpha 1                                   BRIP.1
Element: Invc Option 2 The second Summarize by option
                       maintained on the AC Customer (BR11).
                       The valid values are:
                       A=Account Category
                       B=Summary Acct Cat
                       C=Attribute
                       D=Resource
                       A = Account Category
                       B = Contract Category Group
                       C = Attribute
                       D = Resource
                       E = Summary Account Category

HIH-AC-CUSTOMER-ID     Alpha 5                                   BRIP.1
Element: Ac Customer IdThe "Customer Invoice Option"
                       established on the AC Customer(BR11),
                       and attached to the Contract on the
                       Contract parameters (BR10). This option
                       stores the AC Customer information for
                       processing an invoice. Only one option
                       can be attached to each contract on the
                       BR10.  When creating a combined contract
                       invoice in the Single Calculation (BR19)
                       with different options, the user must
                       specify one option for the invoice.

HIH-WBS-INVC-NBR       Numeric 8                                 BRIP.1
Element: Wbs Invc Nbr  The sequential invoice number for the
                       invoice group (BILLl-WBS-CODE)
                       maintained on the Activity (AC10). Used
                       by Gov't Contractors to keep invoices
                       sequentially numbered when billing
                       different posting activities separately
                       within a contract.

HIH-CUST-NAME          Derived
Element: Cust Name     The name of the customer established on
                       the AR customer group address (AR09).

HIH-LOCK-BOX           Alpha 2                                   BRIP.1
Element: Lock Box      The lock box code for the invoice
                       company maintained in AR Customer
                       Defaults  (AR08).

HIH-XREF-NBR           Alpha 22                                  BRIP.1
Element: Xref Nbr      The original invoice number for a
                       cancelled or deleted invoice or credit
                       memo.  Used to map the original invoice
                       to the invoice created for a cancel or
                       delete.

HIH-BILL-WBS-CODE      Alpha 3                                   BRIP.1
Element: Bill Wbs Code The Invoice Group identified on the
                       Activity (AC10) for the posting level
                       activity.  This is for creating
                       separate invoices by activity group.
                       Related to the WBS-INVC-NBR field.

HIH-EXCEED-OPTION      Alpha 1                                   BRIP.1
Element: Exceed Option The "Ceiling Overage" option indicated
                       on the AC Customer (BR11).
                       The valid values are:
                       I=Include
                       E=Exclude
                       I = Include
                       E = Exclude

HIH-REALIZATION-FL     Alpha 1                                   BR122   BR131
Element: Realization FlFlag used to determine if the Revenue     BRIP.1
                       Realization (BR131) program has been run
                       for these invoices. The valid values
                       are:
                       Y=Yes
                       N=No
                       Y = Yes
                       N = No

HIH-WBS-XREF-NBR       Alpha 22
Element: Wbs Xref Nbr  The historical combined contract
                       reference number.

HIH-STATUS             Numeric 1                                 BR122   BR145
Element: Status        The status of the invoice.                BR20.1  BR20.2
                       The valid values are:                     BR20.3  BR20.4
                       0=Unreleased                              BR20.5  BR45.1
                       1=Released                                BRIP.1
                       2=Pending Approval
                       3=Processed
                       4=Cancelled
                       5=Invoice Delete
                       0 = Unreleased
                       1 = Released
                       2 = Pending Approval
                       3 = Processed
                       4 = Cancelled
                       5 = Invoice Delete

HIH-LAST-LINE-NBR      Numeric 6                                 BR20.1  BR20.2
Element: Line Nbr      The number of the last line item added    BR20.3  BR20.4
                       to the document. It is used to            BR20.5  BR46.1
                       determine what the next line number is    BR46.2  BR46.4
                       when you add another item.                BRIP.1

HIH-USER-NAME          Alpha 10  (Lower Case)                    BRIP.1
Element: User          The system user name that identifies
                       who creatd the invoice.

HIH-BILL-TO-GRP        Numeric 4                                 BRIP.1
Element: Bill To Grp   This is the "Bill to Group" maintained
                       on the AC Customer (BR11). It represents
                       the Bill to Group that is attached to
                       the customer.  It will print multiple
                       invoices with different bill to
                       addresses.  It will only be used when
                       using the "Custom Invoice" option.

HIH-CNT-WBS-CODE       Alpha 3                                   BRIP.1
Element: Cnt Wbs Code  The Invoice Group associated with the
                       Contract Activity.  This is used to
                       combine invoices across contracts. The
                       invoice group must be set up with the
                       Combine Contracts flag set to Y=Yes on
                       the Invoice Groups (BR06).

HIH-FEE-EXCEED-OPT     Alpha 1                                   BRIP.1
Element: Fee Exceed OptThe "Fee Ceiling Overage" option
                       maintained on the AC Customer (BR11).
                       The valid values are:
                       I=Include
                       E=Exclude
                       I = Include
                       E = Exclude

HIH-PRE-ADJUST-AMT     Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The cumulative amount of all adjustment   BR20.3  BR20.4
                       transactions within the invoice.          BR20.5  BRIP.1

HIH-PRE-HOLD-AMT       Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The cumulative amount of all held         BR20.3  BR20.4
                       transactions within the invoice.          BR20.5  BRIP.1

HIH-PRE-BILL-HIST      Signed 18.2                               BRIP.1
Element: Intl Amt      The billable amount including
                       transactions, milestones, overage,
                       retention and retainers prior to
                       adjustments.

HIH-FINAL-INVC-FL      Alpha 1                                   BRIP.1
Element: Final Invc Fl Flag indicating whether the invoice has
                       been processed final.
                       The valid values are:
                       Y=Yes
                       N=No
                       Y = Yes
                       N = No

HIH-PRE-BIA            Signed 18.2                               BR46.1
Element: Intl Amt      The cumulative amount of all bill in
                       advance transactions added to the
                       invoice.

HIH-PRE-XFER           Signed 18.2                               BR46.2  BR46.4
Element: Intl Amt      The cumulative amount of all the
                       transfer transactions added to or
                       subtracted from the invoice.

HIH-TAX-PRINT          Alpha 1                                   BRIP.1
Element: Tax Print     Determines how to summarize the tax
                       codes/amounts on the invoice. This is
                       maintained on the AC Customer (BR11).
                       The valid values are:
                       M=Multiple sum by code/level
                       S=Single tax line
                       M = Multiple sum by code/level
                       S = Single tax line

HIH-HIST-FLAG          Alpha 1
Element: Hist Flag

HIH-JURIS-CODE         Alpha 3                                   BRIP.1
Element: Juris Code

HIH-TAX-FLAG           Alpha 1                                   TX101
Element: Tax Flag

HIH-INVC-OPTION-3      Alpha 1                                   BRIP.1
Element: Invc Options  A = Account Category
                       B = Contract Category Group
                       C = Attribute
                       D = Resource
                       E = Summary Account Category

HIH-INVC-OPTION-4      Alpha 1                                   BRIP.1
Element: Invc Options  A = Account Category
                       B = Contract Category Group
                       C = Attribute
                       D = Resource
                       E = Summary Account Category

HIH-INVC-OPTION-5      Alpha 1                                   BRIP.1
Element: Invc Options  A = Account Category
                       B = Contract Category Group
                       C = Attribute
                       D = Resource
                       E = Summary Account Category

HIH-TAX-CALC-FLAG      Alpha 1                                   BRIP.1
Element: Tax Calc Flag This flag determines whether tax will be
                       calculated at a detail level or summary
                       level. If calculated at a detail level,
                       tax amounts will be calculated
                       separately for each invoice line. If
                       calculated at a summary level, taxable
                       amount for a tax code for the whole
                       invoice will be determined, and tax will
                       be calculated on that summarized taxable
                       amount.
                       1 = Detail
                       2 = Summary

HIH-PRO-ADJ-FL         Alpha 1
Element: Realization FlY = Yes
                       N = No
                       " "

                         ACHISTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HIHSET1   OBJ-ID                                                 AC300   AC310
                                                                 BR02.3  BR09.1
                                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR131   BR140
                                                                 BR145   BR151
                                                                 BR152   BR156
                                                                 BR16.1  BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR20.6  BR20.7
                                                                 BR21.1  BR220
                                                                 BR300   BR420
                                                                 BR45.1  BR46.1
                                                                 BR46.2  BR46.4
                                                                 ...

HIHSET2   CONTRACT      KeyChange                                BR121   BR131
          COMPANY                                                BR145   BR245
          CUSTOMER                                               BR300   BR400
          AC-CUSTOMER-ID                                         BR420
          INVOICE
          OBJ-ID

HIHSET3   CONTRACT      KeyChange
          OBJ-ID

HIHSET4   COMPANY       KeyChange                                BR420
          CUSTOMER
          CONTRACT
          INVOICE-PREFIX
          INVOICE-NBR
          OBJ-ID

HIHSET5   INVOICE-PREFIXKeyChange                                BR02.3  BR21.1
          INVOICE-NBR                                            BR420
          COMPANY
          CUSTOMER
          OBJ-ID

HIHSET6   INVOICE-TYPE  KeyChange                                BR02.1
          CONTRACT
          RETAIN-ID
          INVOICE-PREFIX
          INVOICE-NBR
          OBJ-ID

HIHSET7   COMPANY       KeyChange                                BR20.1  BR20.2
          CUSTOMER                                               BR20.3  BR20.4
          INVOICE-PREFIX                                         BR20.5  BR20.7
          INVOICE-NBR                                            BR300   BR45.1
          OBJ-ID                                                 BR46.1  BR46.2
                                                                 BR46.4  TX101

                         ACHISTHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Not Required

                            HIH-CONTRACT         -> CNT-CONTRACT

Arcomp         ARCOMP       Not Required

                            HIH-COMPANY          -> ACO-COMPANY

Arcontacts     ARCONTACTS   Not Required

                            HIH-COMPANY          -> CON-COMPANY
                            HIH-CUSTOMER         -> CON-CUSTOMER
                            HIH-CONTACT-CODE     -> CON-RESP-CODE

Arcustomer     ARCUSTOMER   Not Required

                            HIH-COMPANY          -> ACM-COMPANY
                            HIH-CUSTOMER         -> ACM-CUSTOMER

Aroihdr C      AROIHDR      Not Required

                            HIH-COMPANY          -> ARH-COMPANY
                            "C"                  -> ARH-TRANS-TYPE
                            HIH-INVOICE          -> ARH-INVOICE

Aroihdr D      AROIHDR      Not Required

                            HIH-COMPANY          -> ARH-COMPANY
                            "D"                  -> ARH-TRANS-TYPE
                            HIH-INVOICE          -> ARH-INVOICE

Aroihdr I      AROIHDR      Not Required

                            HIH-COMPANY          -> ARH-COMPANY
                            "I"                  -> ARH-TRANS-TYPE
                            HIH-INVOICE          -> ARH-INVOICE

Aroihdr M      AROIHDR      Not Required

                            HIH-COMPANY          -> ARH-COMPANY
                            "M"                  -> ARH-TRANS-TYPE
                            HIH-INVOICE          -> ARH-INVOICE

Arproclevl     ARPROCLEVL   Not Required

                            HIH-COMPANY          -> APV-COMPANY
                            HIH-PROCESS-LEVEL    -> APV-PROCESS-LEVEL

Billto         BILLTO       Not Required

                            ACO-CUST-GROUP       -> ABS-CUST-GROUP
                            HIH-CUSTOMER         -> ABS-CUSTOMER
                            HIH-BILL-TO          -> ABS-BILL-TO

Custdesc       CUSTDESC     Not Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            HIH-CUSTOMER         -> CUD-CUSTOMER

                         ACHISTHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Achistcnsl     ACHISTCNSL

                            HIH-OBJ-ID           -> IHC-OBJ-ID
                                                    IHC-LINE-NBR

Achistdtl      ACHISTDTL

                            HIH-OBJ-ID           -> HDT-OBJ-ID
                                                    HDT-PT-ACTIVITY
                                                    HDT-ACCT-CATEGORY
                                                    HDT-LINE-NBR

Achistgm       ACHISTGM

                            HIH-OBJ-ID           -> IHG-HIH-OBJ-ID
                                                    IHG-CONTRACT-ACTVY
                                                    IHG-RECORD-TYPE
                                                    IHG-ACTIVITY

Achisttax      ACHISTTAX

                            HIH-OBJ-ID           -> HIT-OBJ-ID
                                                    HIT-HDT-LINE-NBR
                                                    HIT-SEQ-NBR

Acinvaudit     ACINVAUDIT

                            HIH-OBJ-ID           -> IVA-OBJ-ID
                                                    IVA-LINE-NBR
                                                    IVA-TRANS-DATE
                                                    IVA-SEQUENCE-NBR

Acinvord       ACINVORD

                            HIH-OBJ-ID           -> AIO-HIH-OBJ-ID
                                                    AIO-CONTRACT