INTERNAL ORDER HISTORY Table
View exposing historical internal order master data by fiscal period and fiscal year including organizational, profit center, status, funding, costing, and hierarchy attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Addressee associated with the record. |
VARCHAR2 |
120 |
ADDRESSEE_ROOM |
Addressee room associated with the record. |
VARCHAR2 |
40 |
ADMIN_FLAG |
Indicator identifying whether admin (Y/N). |
VARCHAR2 |
8 |
ALLOCATION_GROUP |
Allocation group associated with the record. |
VARCHAR2 |
120 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the record. |
NUMBER |
13,2 |
CALC_CODE |
Code identifying calc. |
VARCHAR2 |
4 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
16 |
COSTING_SHEET_DESCRIPTION |
Description of costing sheet. |
VARCHAR2 |
120 |
COSTING_SHEET_PROCEDURE |
Costing sheet procedure associated with the record. |
VARCHAR2 |
24 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying cost collector category. |
VARCHAR2 |
20 |
COST_COLLECTOR_CATEGORY_DESC |
Description of cost collector category. |
VARCHAR2 |
120 |
COST_COLLECTOR_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
48 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
48 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
48 |
COST_SHARE |
Cost share associated with the record. |
VARCHAR2 |
4 |
EB_ADJUSTMENT |
Eb adjustment associated with the record. |
VARCHAR2 |
120 |
EB_ADJUSTMENT_KEY |
Surrogate key identifying the eb adjustment. |
VARCHAR2 |
24 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
24 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
16 |
FI_CODE |
Code identifying fi. |
VARCHAR2 |
4 |
FS_CODE |
Code identifying fs. |
VARCHAR2 |
4 |
FUNDING_CLASS |
Funding class associated with the record. |
VARCHAR2 |
12 |
FUND_CENTER_ID |
Business identifier for the fund center. |
VARCHAR2 |
24 |
FUND_ID |
Business identifier for the fund. |
VARCHAR2 |
28 |
INTERNAL_ORDER_CONTINUED_FROM |
Internal order continued from associated with the record. |
VARCHAR2 |
28 |
INTERNAL_ORDER_CONTINUED_TO |
Internal order continued to associated with the record. |
VARCHAR2 |
28 |
INTERNAL_ORDER_COUNTER |
Internal order counter associated with the record. |
NUMBER |
|
INTERNAL_ORDER_EFFECTIVE_DATE |
Date associated with internal order effective. |
DATE |
|
INTERNAL_ORDER_EXPIRATION_DATE |
Date associated with internal order expiration. |
DATE |
|
INTERNAL_ORDER_ID |
Business identifier for the internal order. |
VARCHAR2 |
28 |
INTERNAL_ORDER_NAME |
Internal order name associated with the record. |
VARCHAR2 |
160 |
INTERNAL_ORDER_PARENT_ID |
Business identifier for the internal order parent. |
VARCHAR2 |
28 |
INTERNAL_ORDER_STATUS |
Internal order status associated with the record. |
VARCHAR2 |
40 |
IS_CLOSED_INTERNAL_ORDER |
Indicator identifying whether closed internal order (Y/N). |
VARCHAR2 |
4 |
LAB_ALLOCATION |
Lab allocation associated with the record. |
VARCHAR2 |
120 |
LAB_ALLOCATION_KEY |
Surrogate key identifying the lab allocation. |
VARCHAR2 |
24 |
MAIL_CODE |
Code identifying mail. |
VARCHAR2 |
4 |
OH_ADJUSTMENT |
Oh adjustment associated with the record. |
VARCHAR2 |
120 |
OH_ADJUSTMENT_KEY |
Surrogate key identifying the oh adjustment. |
VARCHAR2 |
24 |
ON_OFF_CAMPUS_STATUS |
On off campus status associated with the record. |
VARCHAR2 |
40 |
ORDER_TYPE |
Order type associated with the record. |
VARCHAR2 |
160 |
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
24 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
160 |
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
4 |
POOL_UNIT |
Pool unit associated with the record. |
NUMBER |
10,4 |
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
28 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
160 |
RECORD_TYPE |
Record type associated with the record. |
VARCHAR2 |
4 |
SECTION_CODE |
Code identifying section. |
VARCHAR2 |
12 |
SECTION_NAME |
Section name associated with the record. |
VARCHAR2 |
240 |
SETTLEMENT_COST_ELEMENT |
Settlement cost element associated with the record. |
VARCHAR2 |
24 |
SUB_PLAN |
Sub plan associated with the record. |
VARCHAR2 |
4 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
120 |
SUPERVISOR_ROOM |
Supervisor room associated with the record. |
VARCHAR2 |
40 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
4 |
TERM_CODE_DESCRIPTION |
Description of term code. |
VARCHAR2 |
160 |
TREASURER_REPORT |
Treasurer report associated with the record. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |