Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACHISTCNSL


                            ACHISTCNSL FILE

                         Billing Consolidation

UPDATED BY

BRIP.1    BR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IHC-OBJ-ID             Numeric 12                                BRIP.1
Element: Obj Id        The object identifier is a number used
                       to relate the invoice consolidated
                       records to the invoice header/detail
                       records.  The object Type is INVID in
                       the OBJID  file.

IHC-LINE-NBR           Numeric 6                                 BRIP.1
Element: Line Nbr      The unique number of the invoice
                       consolidated record.

IHC-DESCRIPTION        Alpha 60  (Lower Case)                    BRIP.1
Element: Long Desc     The description that displays in the
                       print file for the invoice, based on
                       what the summarize options are set for
                       in the AC Customer(BR11).

IHC-BILL-RATE          Signed 13.4                               BRIP.1
Element: Bill Rate     The billing rate set up for a resource
                       for a specific activity.

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

IHC-INVC-AMT           Signed 18.2                               BRIP.1
Element: Intl Amt

IHC-CUM-AMT            Signed 18.2                               BRIP.1
Element: Intl Amt

IHC-CUM-UNIT           Signed 15.2                               BRIP.1
Element: Cum Unit      This field stores the cumulative units
                       used to calculate fee.  It is all costs
                       available for billing or revenue based
                       on the account categories set up as
                       drivers on fee code set up.

IHC-CONTRACT           Alpha 15                                  BRIP.1
Element: Contract      Activity Management contract.

IHC-LINE-TYPE          Alpha 1                                   BRIP.1
Element: Line Type     This field contains the type of
                       inventory on this line.
                       The values are:
                       A = Transaction
                       B = Milestone
                       C = Tax
                       F = Fee
                       G = Retention on Fee
                       H = Overage of Fee
                       I = Billed Retention on Fee
                       J = Billed Overage on Fee
                       K = Overage
                       L = Billed Overage
                       M = Retention
                       N = Billed Retention
                       O = Retainer
                       P = Billed Retainer

IHC-LINE-LVL           Numeric 1                                 BRIP.1
Element: Line Lvl      1 = Detail
                       2 = Footer
                       3 = Total
                       4 = Gross Total
                       5 = Sub Total
                       6 = Final Total
                       7 = Invoice Tax Total
                       8 = Invoice Total

IHC-FEE-CD             Alpha 5                                   BRIP.1
Element: Fee Cd        The fee code name will be a user defined
                       identifier of the code that will be used
                       to calculate fee.

IHC-ACCT-CATEGORY      Alpha 5                                   BRIP.1
Element: Acct Category The account category associated with the
                       invoice detail records.

IHC-SUM-ACCT-CAT       Alpha 5                                   BRIP.1
Element: Sum Acct Cat  The name of the summary account
                       category.

IHC-MATRIX-CAT         Alpha 12                                  BRIP.1
Element: Matrix Cat    Attribute name assigned to an object
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

IHC-MX-VALUE           Alpha 32                                  BRIP.1
Element: Mx Value      The attribute value.

IHC-RESOURCE-TYPE      Alpha 1                                   BRIP.1
Element: Resource Type The type of resource.  Valid values
                       include:
                       P - AC Person
                       Q - Equipment
                       E - Employee
                       V - Vendor

IHC-RESOURCE-CODE      Alpha 10                                  BRIP.1
Element: Resource Code The code identifying the resource
                       assigned to the activity or activity
                       group associated with the invoice
                       transactions.

IHC-RESOURCE-COMP      Numeric 4                                 BRIP.1
Element: Resource Comp Resource Company.  Identifies the AP
                       company if the resource type = V.
                       Identifies the HR company if the
                       resource type = E.  It is the from
                       company blank with  the from company for
                       type P or Q  resources.

IHC-FIELD1-DESC        Alpha 30  (Lower Case)                    BRIP.1
Element: Description   This field displays the description.

IHC-FIELD2-DESC        Alpha 30  (Lower Case)                    BRIP.1
Element: Description   This field displays the description.

IHC-CTR-CAT-GRP        Alpha 5                                   BRIP.1
Element: Ctr Cat Grp

IHC-FIELD3-DESC        Alpha 30  (Lower Case)                    BRIP.1
Element: Description   This field displays the description.

IHC-FIELD4-DESC        Alpha 30  (Lower Case)                    BRIP.1
Element: Description   This field displays the description.

IHC-FIELD5-DESC        Alpha 30  (Lower Case)                    BRIP.1
Element: Description   This field displays the description.

IHC-TAX-CODE           Alpha 10 Occurs 8 Times                   BRIP.1
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


IHC-TAX-RATE           Percent 7.5  (Percent) Occurs 8 Times     BRIP.1
Element: Tax Rate      The tax rate defined for the tax code.

IHC-TAX-AMT            Signed 18.2 Occurs 8 Times                BRIP.1
Element: Intl Amt

IHC-TAXABLE            Signed 18.2                               BRIP.1
Element: Intl Amt

                         ACHISTCNSL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IHCSET1   OBJ-ID                                                 BR300   BRIP.1
          LINE-NBR

IHCSET2   CONTRACT      KeyChange
          OBJ-ID
          LINE-NBR

                         ACHISTCNSL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Achisthdr      ACHISTHDR    Required

                            IHC-OBJ-ID      -> HIH-OBJ-ID  (HIHSET1)

                         ACHISTCNSL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Achistdtl      ACHISTDTL

                            IHC-OBJ-ID      -> HDT-OBJ-ID
                            IHC-LINE-NBR    -> HDT-CNSL-LINE-NBR
                                               HDT-LINE-NBR

Acinvaudit     ACINVAUDIT

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