Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACHISTDTL


                             ACHISTDTL FILE

                             Invoice Detail

The Billing and Revenue Invoice detail file contains the records associated
with an invoice header.  The file is keyed by the OBJ-ID associated with the
invoice header.

REFERENCED BY

BR02.3    BR120     BR121     BR122     BR123     BR145
BR151     BR152     BR156     BR16.1    BR21.1    BR245
BR420     BR45.1    BR521     TX101     AC10.1    AC300
AC310     BR580     BR400

UPDATED BY

BR131     BR140     BR20.1    BR20.2    BR20.3    BR20.4
BR20.5    BR300     BR46.1    BR46.2    BR46.4    BRIP.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HDT-OBJ-ID             Numeric 12                                BR46.1  BR46.2
Element: Obj Id        The object identifier is a number used    BR46.4  BRIP.1
                       to relate the invoice detail records to
                       the invoice header. The object type is
                       INVID in the OBJID file.

HDT-LINE-NBR           Numeric 6                                 BR20.1  BR20.2
Element: Line Nbr      The line number associated with the       BR20.3  BR20.4
                       invoice detail record.  It, in            BR20.5  BR46.1
                       combination with the OBJ-ID field, keeps  BR46.2  BR46.4
                       the ACHISTDTL record unique.              BRIP.1

HDT-CNSL-LINE-NBR      Numeric 6                                 BRIP.1
Element: Line Nbr      The number that maps the ACHISTCNSL
                       file line number to this record.

HDT-PT-ACTIVITY        Alpha 15                                  BR20.1  BR20.2
Element: Activity      The posting activity associated with      BR20.3  BR20.4
                       the original activity transaction being   BR20.5  BR46.1
                       billed on this invoice.                   BR46.2  BR46.4
                                                                 BRIP.1

HDT-ACCT-CATEGORY      Alpha 5                                   BR20.1  BR20.2
Element: Acct Category The account category associated with      BR20.3  BR20.4
                       the original activity transaction being   BR20.5  BR46.1
                       billed on this invoice.                   BR46.2  BR46.4
                                                                 BRIP.1


HDT-BILLING-METHOD     Numeric 1                                 BR20.1  BR20.2
Element: Billing MethodThe billing method maintained for the     BR20.3  BR20.4
                       activity associated with the invoice      BR20.5  BR46.1
                       transaction in the Activity Billing       BR46.2  BR46.4
                       (BR00) or Billing Detail (BR00.2)         BRIP.1
                       1=Time and Materials
                       2=Cost Plus
                       3=Units of Production
                       4=Milestone
                       5=Pass Thru
                       9=User defined
                       1 = Time and Materials
                       2 = Cost Plus
                       3 = Units of Production
                       4 = Milestone
                       5 = Pass Thru
                       9 = User defined

HDT-TRAN-DATE          Numeric 8  (yyyymmdd)                     BR20.1  BR20.2
Element: Tran Date     The transaction date associated with      BR20.3  BR20.4
                       the original activity transaction being   BR20.5  BR46.1
                       billed on this invoice.                   BR46.2  BR46.4
                                                                 BRIP.1

HDT-DESCRIPTION        Alpha 30  (Lower Case)                    BR20.1  BR20.2
Element: Description   The description associated with the       BR20.3  BR20.4
                       original activity transaction being       BR20.5  BR46.1
                       billed on this invoice.                   BR46.2  BR46.4
                                                                 BRIP.1

HDT-RESOURCE-TYPE      Alpha 1                                   BR20.1  BR20.2
Element: Resource Type The type of resource associated with      BR20.3  BR20.4
                       the original activity transaction. The    BR20.5  BR46.1
                       valid values are:                         BR46.2  BR46.4
                       P=AC Person                               BRIP.1
                       Q=Equipment
                       E=Employee
                       V=Vendor
                       Q = Equipment
                       P = Person

HDT-RESOURCE-COMP      Numeric 4                                 BR46.1  BR46.2
Element: Company       The resource company or from company on   BR46.4  BRIP.1
                       the original activity transaction.

HDT-RESOURCE-CODE      Alpha 10                                  BR20.1  BR20.2
Element: Resource Code The resource code associated with the     BR20.3  BR20.4
                       original activity transacton being        BR20.5  BR46.1
                       billed on this invoice.                   BR46.2  BR46.4
                                                                 BRIP.1

HDT-RESOURCE-DESC      Alpha 30  (Lower Case)                    BR20.1  BR20.2
Element: Description   The description of the resource code      BR20.3  BR20.4
                       maintained in Resource (AC03).            BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-BILL-RATE          Signed 13.4                               BR46.1  BR46.2
Element: Bill Rate     The billing rate that is associated       BR46.4  BRIP.1
                       with the original activity transaction
                       being billed on this invoice.  Only
                       populated when the billing method is
                       Time and Materials.

HDT-MARK-UP-PCT        Signed 5.2                                BR46.2  BR46.4
Element: Mark Up Pct   The percentage of markup for billing      BRIP.1
                       associated with the account category on
                       the original activity transaction. The
                       markup  percent is maintained in Account
                       Category Detail (AC08.3) and/or Billing
                       Detail (BR00.2). Markup percentages will
                       increase the cost amount by the
                       percentage entered.

HDT-UNITS-AMOUNT       Signed 15.2                               BR20.1  BR20.2
Element: Units Amount  The billable units amount associated      BR20.3  BR20.4
                       with the original activity transaction.   BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-UNIT-MEASURE       Alpha 12                                  BR46.1  BR46.2
Element: Unit Measure  The unit of measure associated with the   BR46.4  BRIP.1
                       original activity transaction.

HDT-MILESTONE          Alpha 3                                   BR20.1  BR20.2
Element: Milestone     The milestone code maintained in          BR20.3  BR20.4
                       Milestone (BR05).  Only populated when    BR20.5  BR46.1
                       the billing method is Milestone.          BR46.2  BR46.4
                                                                 BRIP.1

HDT-PERC-COMPLETE      Signed 7.3
Element: Perc Complete The percentage of completion associated
                       with the percent complete milestone
                       maintained in Percent Complete
                       Milestones (BR05).

HDT-TAX-EXEMPT-CD      Alpha 1                                   BR20.1  BR20.2
Element: Tax Exempt Cd The code indicating the taxing status.    BR20.3  BR20.4
                       The valid values are:                     BR20.5  BR46.1
                       E=Exempt                                  BR46.2  BR46.4
                       T=Taxable                                 BRIP.1
                       E = Exempt
                       T = Taxable

HDT-TAX-CODE           Alpha 10                                  BR20.1  BR20.2
Element: Tax Code      The code representing specific tax        BR20.3  BR20.4
                       information.  Must be a valid Tax Code.   BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-INVC-AMT           Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The invoice amount. Any billing           BR20.3  BR20.4
                       adjustments made to the invoice line      BR20.5  BR46.1
                       will be included in this line.            BR46.2  BR46.4
                                                                 BRIP.1

HDT-TAX-AMT            Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The tax amount calculated for the         BR20.3  BR20.4
                       invoice line.                             BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-POST-COMPANY       Numeric 4                                 BR20.1  BR20.2
Element: Company       The company used for posting              BR20.3  BR20.4
                       transactions to the General Ledger.       BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-ACCT-UNIT          Alpha 15                                  BR20.1  BR20.2
Element: Acct Unit     The accounting unit used in the           BR20.3  BR20.4
                       transaction that is posted to General     BR20.5  BR46.1
                       Ledger.  This field along with the        BR46.2  BR46.4
                       account and subaccount make up the        BRIP.1
                       location (account) where the amount and
                       other account information is stored.

HDT-ACCOUNT            Numeric 6                                 BR46.1  BR46.2
Element: Account       The Account used in the transaction       BR46.4  BRIP.1
                       that is posted to General Ledger.
                       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

HDT-SUB-ACCT           Numeric 4                                 BR46.1  BR46.2
Element: Sub Acct      The subaccount used in the transaction    BR46.4  BRIP.1
                       that is posted ot General Ledger.
                       This field along with the accounting
                       unit and account make up the location
                       (account) where ammounts and other
                       account information is stored.
                       subaccount from your  general ledger
                       chart of accounts that  was charged with
                       the amount carried on this record.

HDT-ATN-OBJ-ID         Numeric 12                                BR20.1  BR20.2
Element: Obj Id        The system-defined object id              BR20.3  BR20.4
                       representing the original activity        BR20.5  BR46.1
                       transaction.                              BR46.2  BR46.4
                                                                 BRIP.1

HDT-MATRIX-CAT-1       Alpha 12                                  BR20.1  BR20.2
Element: Matrix Cat    The Billing Category name associated      BR20.3  BR20.4
                       with the original activity transaction    BR20.5  BR46.1
                       for this invoice.                         BR46.2  BR46.4
                                                                 BRIP.1

HDT-MX-VALUE-1         Alpha 32                                  BR20.1  BR20.2
Element: Mx Value 1    The Billing Category value associated     BR20.3  BR20.4
                       with the original activity transaction.   BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-MATRIX-CAT-2       Alpha 12
Element: Matrix Cat    The Billing Category name associated
                       with the original activity transaction
                       for this invoice.

HDT-MX-VALUE-2         Alpha 32
Element: Mx Value 2    The Billing Category value associated
                       with the original activity transaction
                       for this invoice.

HDT-MATRIX-CAT-3       Alpha 12
Element: Matrix Cat    The Billing Category name associated
                       with the original activity transaction
                       for this invoice.

HDT-MX-VALUE-3         Alpha 32
Element: Mx Value      The Billing Category value associated
                       with the original activity transaction
                       for this invoice.

HDT-EXCEED-AMT         Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The amount of the detail invoice amoun    BR20.3  BR20.4
                       that exceeds a ceiling. The ceilings are  BR20.5  BR46.1
                       maintained in Contract Detail (BR102)     BR46.2  BR46.4
                       Activity Billing  (BR00.1) or Billing     BRIP.1
                       Detail (BR00.2) or  Ceiling  Levels
                       (BR00.3).

HDT-EXCEED-UNIT        Signed 15.2                               BR20.1  BR20.2
Element: Exceed Unit   The unit amount related to the exceed     BR20.3  BR20.4
                       amount that is over the ceiling.          BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-BILL-ACTIVITY      Alpha 15                                  BR20.1  BR20.2
Element: Bill Activity The billing activity assoicated with      BR20.3  BR20.4
                       the posting activity on the original      BR20.5  BR46.1
                       activity transaction.                     BR46.2  BR46.4
                                                                 BRIP.1

HDT-CONTRACT           Alpha 15                                  BR46.1  BR46.2
Element: Contract      The contract associated with the          BR46.4  BRIP.1
                       posting activity on the original
                       activity transaction.  The contract
                       activity associated with the posting
                       activity on the original transaction has
                       a one to one relationship with the
                       contract.

HDT-RETENTION-AMT      Signed 18.2                               BR46.2  BR46.4
Element: Intl Amt      The retention amount based on the         BRIP.1
                       Retention Percent maintained in Bill
                       Retention (BR01.2)

HDT-LEVEL              Numeric 1                                 BR20.1  BR20.2
Element: Level         Stores the level at which the exceeded    BR20.3  BR20.4
                       amount or unit is recaptured.             BR20.5  BR46.1
                       The billing level maintained on the Bill  BR46.2  BR46.4
                       Parameter (BR00).                         BRIP.1
                       The valid values are:
                       1=Billx
                       2=Resource Billx
                       3=Bill
                       4=Resource Bill
                       5=Contract Billx
                       6=Resource Contract Billx
                       7=Contract Bill
                       8=Resource Contract Bill
                       9=Contract
                       1 = Billx
                       2 = Resource Billx
                       3 = Bill
                       4 = Resource Bill
                       5 = Contract Billx
                       6 = Resource Contract Billx
                       7 = Contract Bill
                       8 = Resource Contract Bill
                       9 = Contract

HDT-REASON-CODE        Alpha 4                                   BR20.1  BR20.2
Element: Reason Code   The reason code indicating the cause of   BR20.3  BR20.4
                       an invoice adjustment.                    BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-REVENUE-AMT        Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The revenue amount assoicated with the    BR20.3  BR20.4
                       original activity transaction.  Field     BR20.5  BR46.1
                       will only be populated when using         BR46.2  BR46.4
                       transaction based revenue methods (i.e.   BRIP.1
                       Full Accrual or Cost Plus Full Accrual).

HDT-ADJ-LEVEL          Alpha 1                                   BR20.1  BR20.2
Element: Adj Level     Indicates the invoice edit(BR20) level    BR20.3  BR20.4
                       of the adjustment.                        BR20.5  BR46.1
                       The valid values are:                     BR46.2  BR46.4
                       I=Invoice                                 BRIP.1
                       D=Invoice Detail
                       T=Transaction Detail
                       P=Posting Activity
                       A=Posting Activity Acct Cat
                       I = Invoice Level
                       D = Invoice Detail Level
                       T = Transaction Detail Level
                       P = Posting Activity Level
                       A = Posting Activity Acct Cat

HDT-LINE-NBR-MAP       Numeric 6                                 BR20.1  BR20.2
Element: Line Nbr Map  Indicates the detail line number that is  BR20.3  BR20.4
                       associated with the adjustment line.      BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-ADJUST-AMT         Signed 18.2                               BR131   BR20.1
Element: Intl Amt      The Adjustment amount is the prorated     BR20.2  BR20.3
                       revenue amount                            BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BRIP.1

HDT-LINE-TYPE          Alpha 1                                   BR46.1  BR46.2
Element: Line Type     This field contains the line type.        BR46.4  BRIP.1
                       The valid 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
                       A = Transaction
                       B = Milestone
                       C = Tax
                       F = Fee
                       G = Retention on Fee
                       H = Overage on 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

HDT-TAXABLE-AMT        Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The taxable amount.                       BR20.3  BR20.4
                                                                 BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-SERVICE-LOC        Numeric 4                                 BR20.1  BR20.2
Element: Service Loc   The service location used for the tax     BR20.3  BR20.4
                       calculation.                              BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-BACKED-OUT-FL      Alpha 1                                   BR140   BR46.1
Element: Backed Out Fl Y = Yes                                   BR46.2  BR46.4
                       N = No                                    BRIP.1

HDT-FEE-CD             Alpha 5                                   BR20.1  BR20.2
Element: Fee Cd        The Fee Code maintained in Assignment     BR20.3  BR20.4
                       for Billing (BR15.2) associated with the  BR20.5  BR46.1
                       contract.                                 BR46.2  BR46.4
                                                                 BRIP.1

HDT-RETAIN-CODE        Alpha 3                                   BR46.2  BR46.4
Element: Retain Code   The Retainer Code maintained in Retainer  BRIP.1
                       Detail (BR02.2).  Only populated when
                       applying specific type retainers.

HDT-RETAIN-ID          Numeric 6                                 BRIP.1
Element: Retain Id     The retainer sequence maintained in the
                       Retainer Parameters (BR02).

HDT-RETAINER-AMT       Signed 18.2                               BR46.2  BR46.4
Element: Intl Amt      The invoice amount associated with a      BRIP.1
                       retainer invoice type.

HDT-SUM-ACCT-CAT       Alpha 5                                   BR20.1  BR20.2
Element: Sum Acct Cat  The name of the summary account           BR20.3  BR20.4
                       category that is assoicated with the      BR20.5  BR46.1
                       detail account category.                  BR46.2  BR46.4
                                                                 BRIP.1

HDT-ADJUST-TYPE        Alpha 1                                   BR20.1  BR20.2
Element: Adjust Type   The category of adjustment related to     BR20.3  BR20.4
                       this invoice detail line.                 BR20.5  BR46.1
                       The values are:                           BR46.2  BR46.4
                       A=Write up or Down                        BRIP.1
                       B=Hold
                       C=Bill in Advance
                       D=Transfer
                       A = Write Up or Down
                       B = Hold
                       C = Bill in Advance
                       D = Transfer

HDT-ORIG-INVC-AMT      Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The original invoice amount from the      BR20.3  BR20.4
                       original activity transactions billable   BR20.5  BR46.1
                       amount.  Will not be populated on the     BR46.2  BR46.4
                       write up or write down adjustment lines.  BRIP.1
                       Used to display the original billable
                       amount on the detail lines in the
                       Invoice Edit (BR20).

HDT-TRANSFER-AMT       Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The transfer amount or billable amount    BR20.3  BR20.4
                       being transferred in Transfer Invoice     BR20.5  BR46.1
                       Transaction (BR40.6).  Stored in          BR46.2  BR46.4
                       Contract Currency. Only populated when
                       Adjust-Type equals D.

HDT-TRANSFER-UNITS     Signed 18.2                               BR20.1  BR20.2
Element: Adj Amt       The transfer units or billable units      BR20.3  BR20.4
                       being transferred in Transfer Invoice     BR20.5  BR46.1
                       Transaction (BR40.6).  Only populated     BR46.2  BR46.4
                       when Adjust-Type equals D.

HDT-CTR-CAT-GRP        Alpha 5                                   BR46.1  BR46.2
Element: Ctr Cat Grp                                             BR46.4  BRIP.1

HDT-XREF-HIH-OBJID     Numeric 12                                BRIP.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

HDT-XREF-LINE-NBR      Numeric 6                                 BRIP.1
Element: Line Nbr      This field contains the line number.

HDT-GLT-OBJ-ID         Numeric 12                                BRIP.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

HDT-BILL-ADJ-AMT       Signed 18.2
Element: Intl Amt

                         ACHISTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HDTSET1   OBJ-ID                                                 BR02.3  BR120
          LINE-NBR                                               BR121   BR122
                                                                 BR123   BR131
                                                                 BR140   BR145
                                                                 BR151   BR152
                                                                 BR156   BR16.1
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR21.1
                                                                 BR245   BR420
                                                                 BR45.1  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BR521   BRIP.1
                                                                 TX101

HDTSET2   CONTRACT      KeyChange                                AC10.1  AC300
          OBJ-ID                                                 AC310   BR122
          LINE-NBR                                               BR131   BR140
                                                                 BR580

HDTSET3   ATN-OBJ-ID    KeyChange
          CONTRACT
          OBJ-ID
          LINE-NBR

HDTSET4   OBJ-ID        KeyChange                                BR20.1  BR20.2
          TRAN-DATE*                                             BR20.3  BR20.4
          LINE-NBR                                               BR20.5  BR46.1
                                                                 BR46.2  BR46.4

HDTSET5   OBJ-ID        KeyChange                                BRIP.1
          CNSL-LINE-NBR
          LINE-NBR

HDTSET6   OBJ-ID        KeyChange                                BR120   BR121
          CONTRACT                                               BR122   BR123
          LINE-NBR                                               BR131   BR140
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR21.1  BR300
                                                                 BR400   BR420
                                                                 BR521

HDTSET7   OBJ-ID        KeyChange                                BR20.1  BR20.2
          PT-ACTIVITY                                            BR20.3  BR20.4
          ACCT-CATEGORY                                          BR20.5  BR46.1
          LINE-NBR                                               BR46.2  BR46.4

HDTSET8   GLT-OBJ-ID    KeyChange
          OBJ-ID
          LINE-NBR

HDTSET9   OBJ-ID        KeyChange                                BR20.1  BR20.2
          LINE-NBR*                                              BR20.3  BR20.4
          LINE-TYPE                                              BR20.5  BR46.1
                                                                 BR46.2  BR46.4

                         ACHISTDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            HDT-CONTRACT         -> CNT-CONTRACT

Achistcnsl     ACHISTCNSL   Required

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

Achisthdr      ACHISTHDR    Required

                            HDT-OBJ-ID           -> HIH-OBJ-ID

Acreasoncd     ACREASONCD   Required

                            HDT-REASON-CODE      -> CDE-REASON-CODE

Actrans        ACTRANS      Required

                            HDT-ATN-OBJ-ID       -> ATN-OBJ-ID

Gltrans        GLTRANS      Not Required

                            HDT-GLT-OBJ-ID       -> GLT-OBJ-ID

                         ACHISTDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Achisttax      ACHISTTAX

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

Acinvaudit     ACINVAUDIT

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