Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPRODDTL


                             ACPRODDTL FILE

REFERENCED BY

BR02.3    BR10.9    BR120     BR121     BR122     BR123
BR140     BR151     BR152     BR156     BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR31.2    BR420     BR52.4
BR521     BR54.2    BR54.3    BR54.4    BRIP.1    BR251
BR253

UPDATED BY

BR153     BR51.1    BR51.2    BR53.1    BR53.2    BR570


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AHD-CONTRACT           Alpha 15                                  BR51.1  BR570
Element: Contract      Activity Management contract.

AHD-OBJ-ID             Numeric 12                                BR51.1  BR570
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.

AHD-PRODUCT            Alpha 15                                  BR51.1  BR570
Element: Product

AHD-PROD-VERSION       Alpha 10                                  BR51.1  BR570
Element: Prod Version

AHD-EFFECTIVE-DT       Numeric 8  (yyyymmdd)                     BR51.1  BR570
Element: Effective Dt  The effective date is the date the
                       record is first valid.

AHD-USERS              Numeric 12                                BR51.1  BR570
Element: Users

AHD-LIST-PRICE         Signed 18.2                               BR51.1  BR570
Element: Intl Amt

AHD-DISCOUNT-AMT       Signed 18.2                               BR51.1
Element: Intl Amt

AHD-NET-PRICE          Signed 18.2                               BR51.1
Element: Intl Amt

AHD-FREE-MAINT         Signed 18.2                               BR51.1  BR570
Element: Intl Amt

AHD-SHIP-DATE          Numeric 8  (yyyymmdd)                     BR51.1  BR570
Element: Ship Date     This field contains the ship date.  If
                       left blank, the system date defaults.

AHD-ANT-SHIP-DATE      Numeric 8  (yyyymmdd)                     BR51.1  BR570
Element: Ship Date     This field contains the ship date.  If
                       left blank, the system date defaults.

AHD-DEFERRED-FL        Alpha 1                                   BR153   BR51.1
Element: Deferred Fl   Y = Yes                                   BR570
                       N = No
                       X = Not Shipped

AHD-DEFERRED-AMT       Signed 18.2                               BR153   BR51.1
Element: Intl Amt                                                BR53.1  BR53.2
                                                                 BR570

AHD-REASON-CODE        Alpha 4                                   BR51.1  BR570
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

AHD-TOT-REV-AMT        Signed 18.2                               BR153   BR570
Element: Intl Amt

AHD-DISCOUNT-PCT       Signed 8.5                                BR51.1  BR570
Element: Discount Pct

AHD-MAINT-PERCENT      Signed 7.3                                BR51.1  BR570
Element: Percent       The percentage determines how much
                       retention is held. It can either be a
                       percentage of each invoice, or it can be
                       a percentage of a total.

AHD-LIST-NET-FLAG      Alpha 1                                   BR51.1  BR570
Element: List Net Flag 1 = List
                       2 = Net

AHD-MAINT-PERIOD       Numeric 2                                 BR570
Element: Period        This is the current accounting period.
                       This field is updated by Period Closing
                       (GL199).

AHD-INCLUDE-BASE       Alpha 1                                   BR51.1  BR570
Element: Include Base  Y = Yes
                       N = No

AHD-REV-ACCT-CAT       Alpha 5                                   BR51.1  BR570
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

AHD-REV-GL-CD          Alpha 4                                   BR51.1  BR570
Element: Ac Gl Code

AHD-REV-ACCOUNT        Numeric 6                                 BR51.1  BR570
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

AHD-REV-SUB-ACCT       Numeric 4                                 BR51.1  BR570
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

AHD-COST-BASIS-FL      Alpha 1                                   BR570
Element: List Net Flag

AHD-TOTAL-COST         Signed 18.2                               BR51.1  BR51.2
Element: Intl Amt                                                BR570

AHD-PREV-EXP-AMT       Signed 18.2                               BR153   BR570
Element: Intl Amt

AHD-CGSL-ACCT-CAT      Alpha 5                                   BR51.1  BR51.2
Element: Acct Category Account categories are groupings of       BR570
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

AHD-CGSL-GL-CD         Alpha 4                                   BR51.1  BR51.2
Element: Ac Gl Code                                              BR570

AHD-CGSL-ACCOUNT       Numeric 6                                 BR51.1  BR51.2
Element: Account       This field along with the accounting      BR570
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

AHD-CGSL-SUB-ACCT      Numeric 4                                 BR51.1  BR51.2
Element: Sub Acct      This field contains the subaccount from   BR570
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

AHD-CGSX-ACCT-CAT      Alpha 5                                   BR51.1  BR51.2
Element: Acct Category Account categories are groupings of       BR570
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

AHD-CGSX-GL-CD         Alpha 4                                   BR51.1  BR51.2
Element: Ac Gl Code                                              BR570

AHD-CGSX-ACCOUNT       Numeric 6                                 BR51.1  BR51.2
Element: Account       This field along with the accounting      BR570
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

AHD-CGSX-SUB-ACCT      Numeric 4                                 BR51.1  BR51.2
Element: Sub Acct      This field contains the subaccount from   BR570
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

AHD-LAST-SEQ-NBR       Numeric 6
Element: Last Seq Nbr  Identifies the last sequence number
                       used.  Ensures the record is unique.

AHD-TAX-EXEMPT-CD      Alpha 1                                   BR570
Element: Tax Exempt Cd Code indicating the taxing status. E -
                       Exempt, T - Taxable.

AHD-OPERATOR           Alpha 10                                  BR51.1  BR51.2
Element: Operator      This field is used to store the login     BR570
                       id of the person who entered the record.


AHD-DATE-STAMP         Numeric 8  (yyyymmdd)                     BR51.1  BR51.2
Element: Date Stamp    This field contains the server date       BR570
                       (month, date, and year) of the last
                       change to this record.

AHD-TIME-STAMP         Numeric 6  (hhmmss)                       BR51.1  BR51.2
Element: Time Stamp    Contains the server time (hour, minute,   BR570
                       and second) when the record was last
                       changed.

AHD-REVENUE-FLAG       Alpha 1                                   BR153   BR51.1
Element: Revenue Flag  This flag identifies whether an           BR51.2  BR570
                       activity/account category is eligible
                       for revenue recognition.

AHD-USER-FIELD1        Alpha 15  (Lower Case)                    BR51.1  BR51.2
Element: User Fld3                                               BR570

AHD-USER-FIELD2        Alpha 15  (Lower Case)                    BR51.1  BR51.2
Element: User Fld3                                               BR570

AHD-USER-FIELD3        Alpha 15  (Lower Case)                    BR51.1  BR51.2
Element: User Fld3                                               BR570

AHD-SITE-LOCATION      Numeric 2                                 BR51.1  BR51.2
Element: Site Location                                           BR570

AHD-INV-NET-PRICE      Signed 18.2                               BR51.1  BR570
Element: Intl Amt

AHD-SUITE              Alpha 6                                   BR51.1  BR570
Element: Prod Suite

AHD-ACTUAL-PRICE       Signed 18.2                               BR51.1  BR570
Element: Intl Amt

AHD-NET-PROD-REV       Derived
Element: Net Prod Rev

AHD-END-DATE           Numeric 8  (yyyymmdd)                     BR51.1  BR570
Element: Date          This field displays the system date
                       when this was created.

AHD-TOT-DEF-AMT        Signed 18.2                               BR51.1  BR53.1
Element: Intl Amt                                                BR53.2  BR570

AHD-DELIV-METHOD       Alpha 1                                   BR51.1  BR570
Element: Deliv Method  S = Shipped
                       H = Hosted at
                       E = Electronic
                       L = Loaded
                       1 = Method 1
                       2 = Method 2
                       3 = Method 3

                         ACPRODDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AHDSET1   CONTRACT                                               BR02.3  BR10.9
          OBJ-ID                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR140   BR151
                                                                 BR152   BR153
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR31.2  BR420
                                                                 BR51.1  BR51.2
                                                                 BR52.4  BR521
                                                                 BR53.1  BR53.2
                                                                 BR54.2  BR54.3
                                                                 BR54.4  BR570
                                                                 BRIP.1

AHDSET2   CONTRACT      KeyChange                                BR153   BR251
          PRODUCT                                                BR253   BR31.2
          PROD-VERSION                                           BR51.1  BR51.2
          OBJ-ID                                                 BR53.1  BR53.2
                                                                 BR570

                         ACPRODDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            AHD-CONTRACT        -> CNT-CONTRACT

Acglcode Cgsl  ACGLCODE     Not Required

                            AHD-CGSL-GL-CD      -> AGC-AC-GL-CODE

Acglcode Cgsx  ACGLCODE     Not Required

                            AHD-CGSX-GL-CD      -> AGC-AC-GL-CODE

Acglcode Rev   ACGLCODE     Not Required

                            AHD-REV-GL-CD       -> AGC-AC-GL-CODE

Acprodhdr      ACPRODHDR    Required

                            AHD-CONTRACT        -> AHR-CONTRACT

Acprodlstx     ACPRODLSTX   Required

                            AHR-PRODUCT-LIST    -> BRQ-PRODUCT-LIST
                            AHD-PRODUCT         -> BRQ-PRODUCT
                            AHD-PROD-VERSION    -> BRQ-PROD-VERSION

Acreasoncd     ACREASONCD   Not Required

                            AHD-REASON-CODE     -> CDE-REASON-CODE

                         ACPRODDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntrcmtx     ACCNTRCMTX

                            AHD-CONTRACT        -> CXM-CONTRACT
                            Spaces              -> CXM-MAINT-SCHEDULE
                            AHD-PRODUCT         -> CXM-PRODUCT
                            AHD-PROD-VERSION    -> CXM-PROD-VERSION
                            AHD-OBJ-ID          -> CXM-OBJ-ID
                                                   CXM-COMMENT-TYPE
                                                   CXM-DATE
                                                   CXM-SEQ-NBR

Acdefrev       ACDEFREV

                            AHD-CONTRACT        -> DRD-CONTRACT
                            AHD-PRODUCT         -> DRD-PRODUCT
                            AHD-PROD-VERSION    -> DRD-PROD-VERSION
                            AHD-OBJ-ID          -> DRD-OBJ-ID
                                                   DRD-SEQ-NBR

Acprodtax      ACPRODTAX

                            AHD-REV-ACCT-CAT    -> BTX-TAX-ACCT-CAT
                            AHD-DELIV-METHOD    -> BTX-DELIV-METHOD
                                                   BTX-EFFECTIVE-DATE

Acproduser     ACPRODUSER

                            AHR-PRODUCT-LIST    -> BRU-PRODUCT-LIST
                            AHD-PRODUCT         -> BRU-PRODUCT
                            AHD-PROD-VERSION    -> BRU-PROD-VERSION
                            AHD-EFFECTIVE-DT    -> BRU-EFFECTIVE-DT
                                                   BRU-RECORD-TYPE
                                                   BRU-MAX-USERS