Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACHISTHDR FILE

REFERENCED BY

BR02.1    BR400     BR420

UPDATED BY

AC300     AC310     BR131     BR21.1    BRIP.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HIH-COMPANY          Numeric 4                                   BRIP.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


HIH-CUSTOMER         Alpha 9  (Right Justified)                  BRIP.1
Customer Number      This field contains the number that
                     represents a customer.

HIH-INVOICE          Alpha 22                                    BRIP.1
Invoice Number       Used to identify the invoice.

HIH-INVOICE-PREFIX   Alpha 2                                     BRIP.1
Invoice Prefix

HIH-INVOICE-NBR      Numeric 8                                   BRIP.1
Invoice Nbr

HIH-INVOICE-ID       Numeric 6                                   BRIP.1
Invoice Id

HIH-PROCESS-LEVEL    Alpha 5                                     BRIP.1
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.


HIH-DUE-DATE         Numeric 8  (yyyymmdd)                       BRIP.1
Due Date             The transaction due date.

HIH-BILL-TO          Numeric 4                                   BRIP.1
Bill To

HIH-CONTRACT         Alpha 10                                    BRIP.1
Contract

HIH-CONTACT-CODE     Alpha 5                                     BRIP.1
Contact Code

HIH-AR-DETAIL        Alpha 1
Ar Detail

HIH-INVOICE-TYPE     Alpha 1                                     BRIP.1
Invoice Type

HIH-INVOICE-DATE     Numeric 8  (yyyymmdd)                       BRIP.1
Invoice Date

HIH-POSTING-DATE     Numeric 8  (yyyymmdd)                       BRIP.1
Posting Date         The date assigned to the journal entry
                     for posting.

HIH-REFERENCE        Alpha 10  (Lower Case)                      BRIP.1
Reference            The reference number associated with
                     the transaction.

HIH-UNITS-AMOUNT     Signed 15.2                                 BRIP.1
Units Amount         This is the units amount included in
                     the file.

HIH-CONTRACT-CURR    Alpha 5                                     BRIP.1
Contract Curr

HIH-CONTRACT-ND      Numeric 1                                   BRIP.1
Contract Nd

HIH-INVC-AMT-TOT     Signed 15.2                                 BRIP.1
Invc Amt Tot

HIH-TAX-AMT-TOT      Signed 15.2                                 BRIP.1
Tax Amt Tot

HIH-RETAIN-AMT       Signed 15.2                                 BRIP.1
Retain Amt

HIH-CUST-PO-NBR      Alpha 22                                    BRIP.1
Customer P.O. Number

HIH-INVC-OPTIONS     Alpha 1                                     BRIP.1
Invc Options

HIH-INVC-FORMAT      Alpha 1                                     BRIP.1
Invc Format

HIH-RETAIN-DESC      Alpha 30                                    BRIP.1
Retain Desc

HIH-CUM-AMT          Signed 15.2                                 BRIP.1
Cum Amt

HIH-CUM-UNIT         Signed 15.2                                 BRIP.1
Cum Unit

HIH-CUM-TAX-AMT      Signed 15.2                                 BRIP.1
Cum Tax Amt

HIH-CUM-RETAIN-AMT   Signed 15.2                                 BRIP.1
Cum Retain Amt

HIH-CUM-FLAG         Alpha 1                                     BRIP.1
Cum Flag

HIH-INVC-SUMM-OPT    Alpha 1                                     BRIP.1
Invc Summ Opt

HIH-EXCEED-AMT       Signed 15.2                                 BRIP.1
Exceed Amt

HIH-EXCEED-UNIT      Signed 15.2                                 BRIP.1
Exceed Unit

HIH-CUM-EXCEED-AMT   Signed 15.2                                 BRIP.1
Cum Exceed Amt

HIH-CUM-EXCEED-UNT   Signed 15.2                                 BRIP.1
Cum Exceed Unt

HIH-RETAINAGE-AMT    Signed 15.2                                 BRIP.1
Retainage Amt

HIH-CUM-RETAINAGE    Signed 15.2                                 BRIP.1
Cum Retainage

HIH-INVC-OPTION-2    Alpha 1                                     BRIP.1
Invc Option 2

HIH-AC-CUSTOMER-ID   Alpha 5                                     BRIP.1
Ac Customer Id

HIH-WBS-INVC-NBR     Numeric 8                                   BRIP.1
Wbs Invc Nbr

HIH-CUST-NAME        Derived
Cust Name

HIH-LOCK-BOX         Alpha 2
Lock Box

HIH-XREF-NBR         Alpha 22                                    BR21.1  BRIP.1
Xref Nbr

HIH-BILL-WBS-CODE    Alpha 3                                     BRIP.1
Bill Wbs Code

HIH-EXCEED-OPTION    Alpha 1
Exceed Option        I = Include
                     E = Exclude

HIH-REALIZATION-FL   Alpha 1                                     BR131   BR21.1
Realization Fl       Y = Yes                                     BRIP.1
                     N = No

HIH-WBS-XREF-NBR     Alpha 22                                    BRIP.1
Wbs Xref Nbr

                         ACHISTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HIHSET1   CONTRACT                                               AC300   AC310
          COMPANY                                                BR02.1  BR131
          CUSTOMER                                               BR21.1  BR400
          AC-CUSTOMER-ID                                         BR420   BRIP.1
          INVOICE-PREFIX
          INVOICE-NBR

HIHSET2   CONTRACT      KeyChange
          COMPANY
          CUSTOMER
          AC-CUSTOMER-ID
          INVOICE

HIHSET3   CONTRACT
          COMPANY
          CUSTOMER
          AC-CUSTOMER-ID
          WBS-INVC-NBR
          INVOICE-PREFIX
          INVOICE-NBR

HIHSET4   COMPANY
          CUSTOMER
          CONTRACT
          INVOICE-PREFIX
          INVOICE-NBR
          AC-CUSTOMER-ID

HIHSET5   INVOICE-PREFIX
          INVOICE-NBR
          COMPANY
          CUSTOMER
          AC-CUSTOMER-ID
          CONTRACT

                         ACHISTHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Not Required

                            HIH-CONTRACT          -> CNT-CONTRACT  (CNTSET1)

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

Acfeehist      ACFEEHIST

                            HIH-COMPANY           -> FHI-COMPANY
                            HIH-CUSTOMER          -> FHI-CUSTOMER
                            HIH-INVOICE           -> FHI-INVOICE
                                                     FHI-ACCT-CATEGORY

Achistcnsl     ACHISTCNSL

                            HIH-CONTRACT          -> IHC-CONTRACT
                            HIH-COMPANY           -> IHC-COMPANY
                            HIH-CUSTOMER          -> IHC-CUSTOMER
                            HIH-AC-CUSTOMER-ID    -> IHC-AC-CUSTOMER-ID
                            HIH-INVOICE-PREFIX    -> IHC-INVOICE-PREFIX
                            HIH-INVOICE-NBR       -> IHC-INVOICE-NBR
                                                     IHC-LINE-NBR

Achistdtl      ACHISTDTL

                            HIH-CONTRACT          -> HDT-CONTRACT
                            HIH-COMPANY           -> HDT-COMPANY
                            HIH-CUSTOMER          -> HDT-CUSTOMER
                            HIH-AC-CUSTOMER-ID    -> HDT-AC-CUSTOMER-ID
                            HIH-INVOICE-PREFIX    -> HDT-INVOICE-PREFIX
                            HIH-INVOICE-NBR       -> HDT-INVOICE-NBR
                                                     HDT-LINE-NBR
                                                     HDT-SEQ-NBR

Acinvaudit     ACINVAUDIT

                            HIH-CONTRACT          -> IVA-CONTRACT
                            HIH-COMPANY           -> IVA-COMPANY
                            HIH-CUSTOMER          -> IVA-CUSTOMER
                            HIH-AC-CUSTOMER-ID    -> IVA-AC-CUSTOMER-ID
                            HIH-INVOICE-PREFIX    -> IVA-INVOICE-PREFIX
                            HIH-INVOICE-NBR       -> IVA-INVOICE-NBR
                                                     IVA-LINE-NBR
                                                     IVA-TRANS-DATE
                                                     IVA-SEQUENCE-NBR