PASCOST – Session Costs

System
Personnel (PA)
Prefix
COS
Primary key
COURSE, SESSION, START-DATE, COST-TYPE, COST-CAT
Fields
16
Updated by
2 programs
Referenced by
1 program

PASCOST is the Session Costs table in Lawson Personnel (prefix COS). It is indexed by COURSE, SESSION, START-DATE, COST-TYPE, COST-CAT (COSSET1). It is related 1:1 to GLMASTER, CUCODES, PCODES and PASESSION and 1:M to PACOURSE. It is updated by TR04.1 and TR11.1 and referenced by TR210. The table has 16 fields, 1 index and 7 documented relations.

About PASCOST

Contains cost and account reference information for each session. TR11.1 (Session Costs) is the primary program that updates this file.

Fields (16)

Column = COBOL field name without the COS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
COS-COURSE PK
COURSE		Alpha 10Contains the course code.TR11.1
COS-SESSION PK
SESSION		Numeric 5Contains the session number.TR11.1
COS-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the session start date.TR11.1
COS-COST-TYPE PK
COST_TYPE		Alpha 10Contains the cost type, which is the specific cost classification.TR11.1
COS-COST-CAT PK
COST_CAT		Alpha 10Contains the cost category, which is the general cost classification.TR11.1
COS-COST
COST		Signed 11.2Contains the amount of the cost.TR11.1
COS-DIST-COMPANY
DIST_COMPANY		Numeric 4Contains the company number to which a transaction could be posted.TR11.1
COS-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15Contains the general ledger accounting unit to which the amount could be posted.TR11.1
COS-DST-ACCOUNT
DST_ACCOUNT		Numeric 6Contains the general ledger account to which the amount could be posted.TR11.1
COS-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4Contains the general ledger subaccount to which the amount could be posted.TR11.1
COS-COST-DESIGNATR
COST_DESIGNATR		Alpha 1Indicates whether the cost is actual or budget.
  • A Actual
  • B Budget
TR11.1
COS-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which session costs are recorded.TR11.1
COS-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.TR11.1
COS-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the base currency for the training system.TR11.1
COS-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the training system base currency.TR11.1
COS-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the session costs in the training system's base currency.TR11.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
COSSET1COURSE, SESSION, START-DATE, COST-TYPE, COST-CATPrimaryTR04.1, TR11.1, TR210

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccountsGLMASTERRequiredWhen (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 CurrencyCUCODESRequiredWhen COS-CURRENCY-CODE != SpacesCOS-BASE-CURRENCY → CUC-CURRENCY-CODE
CategoryPCODESRequiredWhen COS-COST-CAT != Spaces"MC" → PCO-TYPE, COS-COST-CAT → PCO-CODE
CurrencyCUCODESRequiredWhen COS-CURRENCY-CODE != SpacesCOS-CURRENCY-CODE → CUC-CURRENCY-CODE
SessionPASESSIONRequiredCOS-COURSE → SES-COURSE, COS-SESSION → SES-SESSION, COS-START-DATE → SES-START-DATE
TypePCODESRequiredWhen COS-COST-TYPE != Spaces"MT" → PCO-TYPE, COS-COST-TYPE → PCO-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
CoursePACOURSERequiredCOS-COURSE → CRS-COURSE, → CRS-EFFECTIVE-DATE

Programs

Updated by (2)

Referenced by (1)