EXP_CHARGE_TYPE_CHARGE 
Default Table Name  EXP_CHARGE_TYPE_CHARGE 
Definition 
 Name: Expense Charge Type Charges.     Description: This table contains the charge defaults for each user defined charge type.
 

EXP_CHARGE_TYPE_CHARGE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
EXP_CHARGE_TYPE_CD(PK)(FK)    VARCHAR(10)  NO 
Name: Expense Charge Type. Description: The unique identifier for the charge type.
 
S_EXP_LINE_TYPE_CD(PK)    VARCHAR(2)  NO 
Name: Type of Expense . Description: Indicator of the type of Expense Charge. The valid values are:UC – Under Ceiling. OC – Over Ceiling. U – Unallowable. T1 – Tax 1. T2 – Tax 2. 
 
DFLT_UDT01_ID    VARCHAR(50)  YES 
Name: Default UDT01 ID. Description: Default UDT01 that is used for this Expense Type.
 
DFLT_UDT02_ID    VARCHAR(50)  YES 
Name: Default UDT02 ID. Description: Default UDT02 that is used for this Expense Type.
 
DFLT_UDT03_ID    VARCHAR(20)  YES 
Name: Default UDT03 ID. Description: Default UDT03 that is used for this Expense Type.
 
DFLT_UDT04_ID    VARCHAR(20)  YES 
Name: Default UDT04 ID. Description: Default UDT04 that is used for this Expense Type.
 
DFLT_UDT05_ID    VARCHAR(20)  YES 
Name: Default UDT05 ID. Description: Default UDT05 that is used for this Expense Type.
 
DFLT_UDT06_ID    VARCHAR(20)  YES 
Name: Default UDT06 ID. Description: Default UDT06 that is used for this Expense Type.
 
DFLT_UDT07_ID    VARCHAR(20)  YES 
Name: Default UDT07 ID. Description: Default UDT07 that is used for this Expense Type.
 
DFLT_UDT08_ID    VARCHAR(20)  YES 
Name: Default UDT08 ID. Description: Default UDT08 that is used for this Expense Type.
 
DFLT_UDT09_ID    VARCHAR(20)  YES 
Name: Default UDT09 ID. Description: Default UDT09 that is used for this Expense Type.
 
DFLT_UDT10_ID    VARCHAR(20)  YES 
Name: Default UDT10 ID. Description: Default UDT10 that is used for this Expense Type.
 
EXPENSE_REF_CD    VARCHAR(20)  YES 
Name: Expense Reference Code. Description: User defined reference code.
 
S_UDT01_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT01 ID Source. Description: Indicates where to get UDT01 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. N – None. 
 
S_UDT02_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT02 ID Source. Description: Indicates where to get UDT02 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT03_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT03 ID Source. Description: Indicates where to get UDT03 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT04_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT04 ID Source. Description: Indicates where to get UDT04 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT05_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT05 ID Source. Description: Indicates where to get UDT05 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT06_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT06 ID Source. Description: Indicates where to get UDT06 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT07_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT07 ID Source. Description: Indicates where to get UDT07 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT08_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT08 ID Source. Description: Indicates where to get UDT08 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT09_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT09 ID Source. Description: Indicates where to get UDT09 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. A – Charge Allocation. . N – None. 1 - UDT02 User Defined . Code 1. 2 - UDT02 User Defined . Code 2. 3 - UDT02 User Defined . Code 3
 
S_UDT10_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT10 ID Source. Description: Indicates where to get UDT10 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
BILLABLE_FL    VARCHAR(1)  NO 
Name: Billable Flag. Description: Logical as to whether amounts charged to this charge are billable.
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
S_EXPENSE_REF_SOURCE_CD    VARCHAR(1)  NO 
Name: Expense Reference Code Source. Description: Indicates where to get the Expense Reference Code value. The valid values are as follows:U – User Input. T – Charge Type
 
UDT06_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: UDT06 Costpoint Company . Description: UDT06’s Costpoint Company Code Value should be “1” if not Costpoint Multi-Company.
 
UDT07_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: UDT07 Costpoint Company. Description: UDT07’s Costpoint Company Code Value should be “1” if not Costpoint Multi-Company.
 
S_UDT11_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT11 ID Source. Description: Indicates where to get UDT11 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT12_SOURCE_CD    VARCHAR(1)  NO 
UDT12 ID Source. Indicates where to get UDT12 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. N – None. 
 
S_UDT13_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT13 ID Source. Description: Indicates where to get UDT13 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT14_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT14 ID Source. Description: Indicates where to get UDT14 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
S_UDT15_SOURCE_CD    VARCHAR(1)  NO 
Name: UDT15 ID Source. Description: Indicates where to get UDT15 value. The valid values are as follows:U – User Input. E – Employee History. C – Charge Type. T – Charge Tree. S – Tax Schedule. 
 
DFLT_UDT11_ID    VARCHAR(20)  YES 
Name: Default UDT11 ID. Description: Default UDT11 that is used for this Expense Type.
 
DFLT_UDT12_ID    VARCHAR(20)  YES 
Name: Default UDT12 ID. Description: Default UDT12 that is used for this Expense Type.
 
DFLT_UDT13_ID    VARCHAR(20)  YES 
Name: Default UDT13 ID. Description: Default UDT13 that is used for this Expense Type.
 
DFLT_UDT14_ID    VARCHAR(20)  YES 
Name: Default UDT14 ID. Description: Default UDT14 that is used for this Expense Type.
 
DFLT_UDT15_ID    VARCHAR(20)  YES 
Name: Default UDT15 ID. Description: Default UDT15 that is used for this Expense Type.
 

EXP_CHARGE_TYPE_CHARGE Keys 
Key Name  Key Type  Keys 
RI_F00184  Inversion Entry  EXP_CHARGE_TYPE_CD 
PI_0171  PrimaryKey  EXP_CHARGE_TYPE_CD, S_EXP_LINE_TYPE_CD 

EXP_CHARGE_TYPE_CHARGE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
EXP_CHARGE_TYPE  Identifying  One To Zero or More        EXP_CHARGE_TYPE_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype