Session Costs
Contains cost and account reference information for each session.
TR11.1 (Session Costs) is the primary program that updates this file.
UPDATED BY
TR04.1 | TR11.1 | TR210 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
COS-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||
COS-SESSION Element: Session | Numeric 5 Contains the session number. |
|
||
COS-START-DATE Element: Session Start Date | Numeric 8 (yyyymmdd) Contains the session start date. |
|
||
COS-COST-TYPE Element: Cost Type | Alpha 10 Contains the cost type, which is the specific cost classification. |
|
||
COS-COST-CAT Element: Cost Category | Alpha 10 Contains the cost category, which is the general cost classification. |
|
||
COS-COST Element: Cost | Signed 11.2 Contains the amount of the cost. |
|
||
COS-DIST-COMPANY Element: Distribution Company | Numeric 4 Contains the company number to which a transaction could be posted. |
|
||
COS-DST-ACCT-UNIT Distribution Account Unit | Alpha 15 Contains the general ledger accounting unit to which the amount could be posted. |
|
||
COS-DST-ACCOUNT Element: Distribution Account | Numeric 6 Contains the general ledger account to which the amount could be posted. |
|
||
COS-DST-SUB-ACCT Distribution Subaccount | Numeric 4 Contains the general ledger subaccount to which the amount could be posted. |
|
||
COS-COST-DESIGNATR Element: Actual or Budget | Alpha 1 Indicates whether the cost is actual or budget. A = Actual B = Budget |
|
||
COS-CURRENCY-CODE Element: Currency Code | Alpha 5 Contains the currency in which session costs are recorded. |
|
||
COS-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
COS-BASE-CURRENCY Element: Base Currency | Alpha 5 Contains the base currency for the training system. |
|
||
COS-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the training system base currency. |
|
||
COS-BASE-AMOUNT Element: Base Amt | Signed 15.2 Contains the session costs in the training system's base currency. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
COSSET1 |
COURSE SESSION START-DATE COST-TYPE COST-CAT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accounts | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Base Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Category | PCODES |
Required
| ||||||||||||||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Session | PASESSION |
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.