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 |
| TR01.1 | TR10.1 |
| 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.