Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTEMPACT


                             ACTEMPACT FILE

REFERENCED BY

AC19.1    AC19.3    AC56.1    AC560

UPDATED BY

AC71.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AEC-TEMPLATE           Alpha 15                                  AC71.1
Element: Template      The name of the template the detail
                       records are associated to.

AEC-DESCRIPTION        Alpha 30  (Lower Case)                    AC71.1
Element: Description   This field displays the description.

AEC-CURRENCY-CODE      Alpha 5                                   AC71.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

AEC-COMPANY            Numeric 4                                 AC71.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AEC-ACCT-UNIT          Alpha 15                                  AC71.1
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


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

AEC-SUB-ACCT           Numeric 4                                 AC71.1
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.

AEC-USR-STATUS         Alpha 2                                   AC71.1
Element: Usr Status

AEC-ACCT-CATEGORY      Alpha 5                                   AC71.1
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

AEC-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC71.1
Element: Date          This field displays the system date
                       when this was created.

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

AEC-BILLABLE-FLAG      Alpha 1                                   AC71.1
Element: Billable      Y = Yes
                       N = No

AEC-BILL-WBS-CODE      Alpha 3                                   AC71.1
Element: Bill Wbs Code

AEC-LOCATION-NAME      Alpha 15                                  AC71.1
Element: Destination

AEC-DIVISION           Alpha 15                                  AC71.1
Element: Division      A user-defined division which is used
                       for reporting assets.

AEC-ACT-SEG-BLOCK      Alpha 103                                 AC71.1
Element: Segment Block This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

AEC-BUDGET-EDIT        Alpha 1                                   AC71.1
Element: Budget Edit   1 = No Edit
                       2 = Period Edit
                       3 = Annual Edit
                       4 = Total Edit

AEC-BUDGET-LEVEL       Alpha 1                                   AC71.1
Element: Budget Level  1 = Activity-Acct Cat
                       3 = Activity
                       4 = Activity-Summary Account Cat

AEC-BUD-TOLERANCE      Signed 5.2                                AC71.1
Element: Bud Tolerance

AEC-AWARD-FLAG         Alpha 1                                   AC71.1
Element: Award Flag    Flag to indicate whether this activity
                       is an award for the GM system or a
                       posting level activity within an award.
                       Y = Yes
                       N = No

AEC-EFFORT-FLAG        Alpha 1                                   AC71.1
Element: Effort Flag   Flag to indicate whether this activity
                       is subject to effort reporting, and if
                       it is, whether it prints in the
                       sponsored or non-sponsored section of
                       the report for effort reporting.
                       Y = Yes
                       N = No

AEC-SALARY-CAP-FL      Alpha 1                                   AC71.1
Element: Salary Cap Fl This flag indicates whether the salary
                       cap applies to this grant/project.  The
                       actual salary cap amount is stored on
                       the GMSALCAP record.
                       Y = Yes
                       N = No

AEC-SCHEDULE           Alpha 9                                   AC71.1
Element: Schedule

AEC-CURRENT-CAP        Alpha 1                                   AC71.1
Element: Flag          Y = Yes
                       N = No

AEC-CAP-ACTIVITY       Alpha 15                                  AC71.1
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


AEC-CAP-ACCT-CAT       Alpha 5                                   AC71.1
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

AEC-CAP-COMPANY        Numeric 4                                 AC71.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AEC-CAP-ACCT-UNIT      Alpha 15                                  AC71.1
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


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

AEC-CAP-SUB-ACCT       Numeric 4                                 AC71.1
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.

AEC-CAP-SEG-BLOCK      Alpha 103                                 AC71.1
Element: Segment Block This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

                         ACTEMPACT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AECSET1   TEMPLATE                                               AC19.1  AC19.3
                                                                 AC56.1  AC560
                                                                 AC71.1