PACOST

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.
TR10.1
CST-COST-TYPE
Element: Cost Type
Alpha 10
Contains the specific cost classification.
TR10.1
CST-COST-CAT
Element: Cost Category
Alpha 10
Contains the general cost classification.
TR10.1
CST-EFFECTIVE-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the date the cost becomes effective. The course start date defaults.
TR10.1
CST-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Contains the date the cost ends.
TR10.1
CST-COST
Element: Cost
Signed 11.2
Contains the amount of the cost.
TR10.1
CST-DIST-COMPANY
Element: Distribution Company
Numeric 4
Contains the distribution company for the cost.
TR10.1
CST-DST-ACCT-UNIT
Distribution
Account Unit
Alpha 15
Contains the general ledger accounting unit to which the amount could be posted.
TR10.1
CST-DST-ACCOUNT
Element: Distribution Account
Numeric 6
Contains the general ledger account to which the amount could be posted.
TR10.1
CST-DST-SUB-ACCT
Distribution
Subaccount
Numeric 4
Contains the general ledger subaccount to which the amount could be posted.
TR10.1
CST-COST-DESIGNATR
Element: Actual or Budget
Alpha 1
Indicates whether the cost is actual or budgeted. A = Actual B = Budget
TR10.1
CST-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which the cost is recorded.
TR10.1
CST-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
TR10.1
CST-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains the training system's base currency.
TR10.1
CST-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the training system's base currency.
TR10.1
CST-BASE-AMOUNT
Element: Base Amt
Signed 15.2
Contains the cost in the training system's base currency.
TR10.1


PACOST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSTSET1 COURSE
COST-TYPE
COST-CAT
EFFECTIVE-DATE
TR01.1 TR10.1
TR201 TR210


PACOST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accounts GLMASTER Required
When (CST-DIST-COMPANY !=Zeroes )
And(CST-DST-ACCT-UNIT !=Spaces )
And(CST-DST-ACCOUNT !=Zeroes )
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 Required
When CST-COST-CAT !=Spaces
"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
When CST-COST-TYPE !=Spaces
"MT"->PCO-TYPE
CST-COST-TYPE->PCO-CODE


PACOST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE Required
CST-COURSE->CRS-COURSE
  CRS-EFFECTIVE-DATE


File created: Wed Jun 08 20:50:23 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.