| ALTERNATE_REVIEWER_ID |
Integer |
1 |
A foreign key for the ext_user table identifying an alternate reviewer. For example, alternate_reviewer_id INTEGER Y for a cost center review activity. The alternate reviewer is used when the owner of an expense report is also the default reviewer. |
| CHANGE_TIMESTAMP |
DateTime |
23 |
|
| COMPANY_CODE |
Integer |
10 |
The parent corporation's code for the company. |
| COMPANY_ID |
Integer |
5 |
A unique ID identifying the company. |
| COMPANY_NAME |
Varchar |
15 |
The name of a company. |
| COST_CENTER_ACTIVE_STATUS |
Integer |
1 |
Active status of the cost center. |
| COST_CENTER_CODE |
Varchar |
25 |
The cost center code value. |
| COST_CENTER_DESCRIPTION |
Varchar |
35 |
A description of the cost center. |
| COST_CENTER_ID |
Integer |
11 |
The primary key for this table, identifying a unique cost center, a decost_center_id INTEGER N department, a division, or a company combination. |
| COST_CENTER_NAME |
Varchar |
35 |
The name of a cost center. |
| DEFAULT_REVIEWER_ID |
Integer |
5 |
A foreign key for the ext_user table identifying the default reviewer. For example, the default_reviewer_id INTEGER Y for the cost center review. |
| DEPARTMENT_CODE |
Integer |
10 |
The company's department. |
| DEPARTMENT_ID |
Integer |
7 |
The department ID. |
| DEPARTMENT_NAME |
Varchar |
20 |
The name of the department. |
| DIVISION_CODE |
Integer |
10 |
The division code. |
| DIVISION_ID |
Integer |
7 |
The division ID. |
| DIVISION_NAME |
Varchar |
21 |
The division name. |
| USER_ID |
Integer |
1 |
A foreign key for the ext_user table identifying the user who created the cost center entry. |
| lastModified |
DateTime |
24 |
|
| VariationID |
Integer |
13 |
|
| ACTIVE_STATUS |
Varchar |
4 |
|