Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PACOST


                              PACOST FILE

                              Course Cost

Contains cost and account reference information for each course.

TR10.1 (Course Costs) is the primary program that updates this file.

REFERENCED BY

TR201     TR210

UPDATED BY

TR01.1    TR10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CST-COURSE             Alpha 10                                  TR10.1
Element: Course Code   Contains the course code.

CST-COST-TYPE          Alpha 10                                  TR10.1
Element: Cost Type     Contains the specific cost
                       classification.

CST-COST-CAT           Alpha 10                                  TR10.1
Element: Cost Category Contains the general cost
                       classification.

CST-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     TR10.1
Element: Start Date    Contains the date the cost becomes
                       effective. The course start date
                       defaults.

CST-END-DATE           Numeric 8  (yyyymmdd)                     TR10.1
Element: End Date      Contains the date the cost ends.

CST-COST               Signed 11.2                               TR10.1
Element: Cost          Contains the amount of the cost.

CST-DIST-COMPANY       Numeric 4                                 TR10.1
Element: Distribution CContains the distribution company for
                       the cost.

CST-DST-ACCT-UNIT      Alpha 15                                  TR10.1
Distribution           Contains the general ledger accounting
Account Unit           unit to which the amount could be
                       posted.

CST-DST-ACCOUNT        Numeric 6                                 TR10.1
Element: Distribution AContains the general ledger account to
                       which the amount could be posted.

CST-DST-SUB-ACCT       Numeric 4                                 TR10.1
Distribution           Contains the general ledger subaccount
Subaccount             to which the amount could be posted.

CST-COST-DESIGNATR     Alpha 1                                   TR10.1
Element: Actual or BudgIndicates whether the cost is actual or
                       budgeted.
                       A = Actual
                       B = Budget

CST-CURRENCY-CODE      Alpha 5                                   TR10.1
Element: Currency Code Contains the currency in which the cost
                       is recorded.

CST-CURR-ND            Numeric 1                                 TR10.1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


CST-BASE-CURRENCY      Alpha 5                                   TR10.1
Element: Base Currency Contains the training system's base
                       currency.

CST-BASE-ND            Numeric 1                                 TR10.1
Element: Base Nd       The number of decimal positions defined
                       for the training system's base currency.


CST-BASE-AMOUNT        Signed 15.2                               TR10.1
Element: Base Amt      Contains the cost in the training
                       system's base currency.

                         PACOST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CSTSET1   COURSE                                                 TR01.1  TR10.1
          COST-TYPE                                              TR201   TR210
          COST-CAT
          EFFECTIVE-DATE

                         PACOST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accounts       GLMASTER     Required
                            When (CST-DIST-COMPANY  != Zeroes )
                            And  (CST-DST-ACCT-UNIT != Spaces )
                            And  (CST-DST-ACCOUNT   != Zeroes )

                            CST-DIST-COMPANY     -> GLM-COMPANY
                            CST-DST-ACCT-UNIT    -> GLM-ACCT-UNIT
                            CST-DST-ACCOUNT      -> GLM-ACCOUNT
                            CST-DST-SUB-ACCT     -> GLM-SUB-ACCOUNT

Base Currency  CUCODES      Required
                            When CST-CURRENCY-CODE != Spaces

                            CST-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Category       PCODES       Required
                            When CST-COST-CAT != Spaces

                            "MC"                 -> PCO-TYPE
                            CST-COST-CAT         -> PCO-CODE

Currency       CUCODES      Required
                            When CST-CURRENCY-CODE != Spaces

                            CST-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Type           PCODES       Required
                            When CST-COST-TYPE != Spaces

                            "MT"                 -> PCO-TYPE
                            CST-COST-TYPE        -> PCO-CODE

                         PACOST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course         PACOURSE     Required

                            CST-COURSE           -> CRS-COURSE
                                                    CRS-EFFECTIVE-DATE