Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PASCOST


                              PASCOST FILE

                             Session Costs

Contains cost and account reference information for each session.

TR11.1 (Session Costs) is the primary program that updates this file.

REFERENCED BY

TR210

UPDATED BY

TR04.1    TR11.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

COS-COURSE             Alpha 10                                  TR11.1
Element: Course Code   Contains the course code.

COS-SESSION            Numeric 5                                 TR11.1
Element: Session       Contains the session number.

COS-START-DATE         Numeric 8  (yyyymmdd)                     TR11.1
Element: Session Start Contains the session start date.

COS-COST-TYPE          Alpha 10                                  TR11.1
Element: Cost Type     Contains the cost type, which is the
                       specific cost classification.

COS-COST-CAT           Alpha 10                                  TR11.1
Element: Cost Category Contains the cost category, which is
                       the general cost classification.

COS-COST               Signed 11.2                               TR11.1
Element: Cost          Contains the amount of the cost.

COS-DIST-COMPANY       Numeric 4                                 TR11.1
Element: Distribution CContains the company number to which a
                       transaction could be posted.

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

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

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

COS-COST-DESIGNATR     Alpha 1                                   TR11.1
Element: Actual or BudgIndicates whether the cost is actual or
                       budget.
                       A = Actual
                       B = Budget

COS-CURRENCY-CODE      Alpha 5                                   TR11.1
Element: Currency Code Contains the currency in which session
                       costs are recorded.

COS-CURR-ND            Numeric 1                                 TR11.1
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

COS-BASE-CURRENCY      Alpha 5                                   TR11.1
Element: Base Currency Contains the base currency for the
                       training system.

COS-BASE-ND            Numeric 1                                 TR11.1
Base Number Of         The number of decimal positions defined
Decimals               for the training system base currency.

COS-BASE-AMOUNT        Signed 15.2                               TR11.1
Element: Base Amount   Contains the session costs in the
                       training system's base currency.

                         PASCOST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

COSSET1   COURSE                                                 TR04.1  TR11.1
          SESSION                                                TR210
          START-DATE
          COST-TYPE
          COST-CAT

                         PASCOST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

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

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

                            COS-BASE-CURRENCY    -> CUC-CURRENCY-CODE

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

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

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

                            COS-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Session        PASESSION    Required

                            COS-COURSE           -> SES-COURSE
                            COS-SESSION          -> SES-SESSION
                            COS-START-DATE       -> SES-START-DATE

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

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

                         PASCOST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course         PACOURSE     Required

                            COS-COURSE           -> CRS-COURSE
                                                    CRS-EFFECTIVE-DATE