Course Cost
Contains cost and account reference information for each course.
TR10.1 (Course Costs) is the primary program that updates this file.
UPDATED BY
TR01.1 | TR10.1 | TR201 | TR210 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
CST-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||
CST-COST-TYPE Element: Cost Type | Alpha 10 Contains the specific cost classification. |
|
||
CST-COST-CAT Element: Cost Category | Alpha 10 Contains the general cost classification. |
|
||
CST-EFFECTIVE-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the date the cost becomes effective. The course start date defaults. |
|
||
CST-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the date the cost ends. |
|
||
CST-COST Element: Cost | Signed 11.2 Contains the amount of the cost. |
|
||
CST-DIST-COMPANY Element: Distribution Company | Numeric 4 Contains the distribution company for the cost. |
|
||
CST-DST-ACCT-UNIT Distribution Account Unit | Alpha 15 Contains the general ledger accounting unit to which the amount could be posted. |
|
||
CST-DST-ACCOUNT Element: Distribution Account | Numeric 6 Contains the general ledger account to which the amount could be posted. |
|
||
CST-DST-SUB-ACCT Distribution Subaccount | Numeric 4 Contains the general ledger subaccount to which the amount could be posted. |
|
||
CST-COST-DESIGNATR Element: Actual or Budget | Alpha 1 Indicates whether the cost is actual or budgeted. A = Actual B = Budget |
|
||
CST-CURRENCY-CODE Element: Currency Code | Alpha 5 Contains the currency in which the cost is recorded. |
|
||
CST-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
CST-BASE-CURRENCY Element: Base Currency | Alpha 5 Contains the training system's base currency. |
|
||
CST-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the training system's base currency. |
|
||
CST-BASE-AMOUNT Element: Base Amt | Signed 15.2 Contains the cost in the training system's base currency. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CSTSET1 |
COURSE COST-TYPE COST-CAT EFFECTIVE-DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accounts | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Base Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Category | PCODES |
Required
| ||||||||||||||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Type | PCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Course | PACOURSE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.