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
Course Code Contains the course code.
CST-COST-TYPE Alpha 10 TR10.1
Cost Type Contains the specific cost
classification.
CST-COST-CAT Alpha 10 TR10.1
Cost Category Contains the general cost
classification.
CST-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR10.1
Start Date Contains the date the cost becomes
effective. The course start date
defaults.
CST-END-DATE Numeric 8 (yyyymmdd) TR10.1
End Date Contains the date the cost ends.
CST-COST Signed 11.2 TR10.1
Cost Contains the amount of the cost.
CST-DIST-COMPANY Numeric 4 TR10.1
Distribution Company Contains 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
Distribution Account Contains 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
Actual or Budget Indicates whether the cost is actual or
budgeted.
A = Actual
B = Budget
CST-CURRENCY-CODE Alpha 5 TR10.1
Currency Code Contains the currency in which the cost
is recorded.
CST-CURR-ND Numeric 1 TR10.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
CST-BASE-CURRENCY Alpha 5 TR10.1
Base Currency Contains the training system's base
currency.
CST-BASE-ND Numeric 1 TR10.1
Base Number Of The number of decimal positions defined
Decimals for the training system's base currency.
CST-BASE-AMOUNT Signed 15.2 TR10.1
Base Amount 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 Not Required
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 Not Required
"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
"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
|
