PJS_FP_EXTR_COST_B
This table is obsolete and not being used anywhere.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| WORKER_ID | NUMBER | 18 | A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance. | |
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Each TXN_ACCUM_HEADER_ID corresponds to a unique combination of resource attributes and is used for RBS mapping | |
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit ID | |
| TASK_ID | NUMBER | 18 | Task ID | |
| CONTRACT_ID | NUMBER | 18 | Contains the Contract ID, not the Contract Number. | |
| CONTRACT_LINE_ID | NUMBER | 18 | Contains the Contract Line ID. | |
| PERSON_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| ORGANIZATION_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | |
| JOB_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| VENDOR_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| RESOURCE_CLASS_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| BOM_LABOR_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| BOM_EQUIPMENT_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| PERSON_TYPE | VARCHAR2 | 30 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| ITEM_CATEGORY_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| ROLE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |
| GL_DATE | DATE | GL date | ||
| GL_PERIOD_NAME | VARCHAR2 | 30 | Period name | |
| PA_DATE | DATE | PA Date | ||
| PA_PERIOD_NAME | VARCHAR2 | 30 | Period name | |
| TXN_CURRENCY_CODE | VARCHAR2 | 3 | Transaction currency code | |
| TXN_RAW_COST | NUMBER | Transaction raw cost | ||
| TXN_BILL_RAW_COST | NUMBER | Transaction billable raw cost | ||
| TXN_CAP_RAW_COST | NUMBER | Transaction capitalizable raw cost | ||
| TXN_EXPENSE_RAW_COST | NUMBER | Transaction expense raw cost | ||
| TXN_BRDN_COST | NUMBER | Transaction burdened cost | ||
| TXN_BILL_BRDN_COST | NUMBER | Transaction billable burdened cost | ||
| TXN_CAP_BRDN_COST | NUMBER | Transaction capitalizable burdened cost | ||
| TXN_EXPENSE_BRDN_COST | NUMBER | Transaction expense burdened cost | ||
| TXN_UBR | NUMBER | Transaction unbilled receivable | ||
| TXN_UER | NUMBER | Transaction unearned revenue | ||
| PRJ_CURRENCY_CODE | VARCHAR2 | 3 | Project currency code | |
| PRJ_RAW_COST | NUMBER | Project raw cost | ||
| PRJ_BILL_RAW_COST | NUMBER | Project billable raw cost | ||
| PRJ_CAP_RAW_COST | NUMBER | Project capitalizable raw cost | ||
| PRJ_EXPENSE_RAW_COST | NUMBER | Project expense raw cost | ||
| PRJ_BRDN_COST | NUMBER | Project burdened cost | ||
| PRJ_BILL_BRDN_COST | NUMBER | Project billable burdened cost | ||
| PRJ_CAP_BRDN_COST | NUMBER | Project capitalizable burdened cost | ||
| PRJ_EXPENSE_BRDN_COST | NUMBER | Project expense burdened cost | ||
| PRJ_UBR | NUMBER | Project unbilled receivable | ||
| PRJ_UER | NUMBER | Project unearned revenue | ||
| FUN_CURRENCY_CODE | VARCHAR2 | 3 | Project functional currency code | |
| FUN_RAW_COST | NUMBER | Project functional raw cost | ||
| FUN_BILL_RAW_COST | NUMBER | Project functional billable raw cost | ||
| FUN_CAP_RAW_COST | NUMBER | Project functional capitalizable raw cost | ||
| FUN_EXPENSE_RAW_COST | NUMBER | Project functional expense raw cost | ||
| FUN_BRDN_COST | NUMBER | Project functional burdened cost | ||
| FUN_BILL_BRDN_COST | NUMBER | Project functional billable burdened cost | ||
| FUN_CAP_BRDN_COST | NUMBER | Project functional capitalizable burdened cost | ||
| FUN_EXPENSE_BRDN_COST | NUMBER | Project functional expense burdened cost | ||
| FUN_UBR | NUMBER | Project functional unbilled receivable | ||
| FUN_UER | NUMBER | Project functional unearned revenue | ||
| QUANTITY | NUMBER | Quantity | ||
| BILL_QUANTITY | NUMBER | Quantity | ||
| CAP_QUANTITY | NUMBER | Quantity | ||
| EXPENSE_QUANTITY | NUMBER | Quantity | ||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code |