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