Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
EXP_CHARGE_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: Expense Charge Type. Description: The unique identifier for the charge type. |
S_EXP_LINE_TYPE_CD |
|
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. |