PJS_COMMITMENT_TXNS
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 | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| CMT_LINE_ID | NUMBER | 18 | Identifier of the commitment. | |||
| PROJECT_ID | NUMBER | 18 | Identifier of the project. | Active | ||
| TASK_ID | NUMBER | 18 | Identifier of the lowest level task. | Active | ||
| TRANSACTION_SOURCE | VARCHAR2 | 30 | Source of commitment, i.e., ORACLE_PURCHASING, ORACLE_PAYABLES, OUTSIDE_SYSTEM. | Active | ||
| LINE_TYPE | VARCHAR2 | 1 | Commitment line type is part of QuickCode. | Active | ||
| CMT_NUMBER | VARCHAR2 | 50 | The number of the commitment document. | Active | ||
| CMT_DISTRIBUTION_ID | NUMBER | The identifier of the requisition or purchase order distribution. | Active | |||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |||
| DESCRIPTION | VARCHAR2 | 255 | The description of either the requisition or purchase order line or the invoice distribution. | Active | ||
| EXPENDITURE_ITEM_DATE | DATE | The expenditure item date on which you expect to incur the commitment costs. | Active | |||
| PA_PERIOD | VARCHAR2 | 20 | PA period corresponding to the commitment. | Active | ||
| GL_PERIOD | VARCHAR2 | 15 | GL period corresponding to the commitment. | Active | ||
| CMT_LINE_NUMBER | NUMBER | The requisition, purchase order or invoice line number in which the distribution is included. | Active | |||
| CMT_CREATION_DATE | DATE | Date on which the requisition or purchase order was created or the invoice was incurred. | Active | |||
| CMT_APPROVED_DATE | DATE | Date on which the requisition, purchase order or invoice was approved | Active | |||
| CMT_REQUESTOR_NAME | VARCHAR2 | 240 | The full name of requestor. | Active | ||
| CMT_BUYER_NAME | VARCHAR2 | 240 | The full name of buyer. | Active | ||
| CMT_APPROVED_FLAG | VARCHAR2 | 1 | Indicator if the commitment is approved: 'Y' for approved, 'N' for not approved. | Active | ||
| CMT_PROMISED_DATE | DATE | Promised delivery date for commitment. | Active | |||
| CMT_NEED_BY_DATE | DATE | Date that commitment is needed by. | Active | |||
| CMT_HEADER_ID | NUMBER | Identifier for the Supplier on a commitment document. | Active | |||
| ORGANIZATION_ID | NUMBER | Identifier of the expenditure organization incurring the commitment. | Active | |||
| VENDOR_ID | NUMBER | Identifier of the Supplier. | Active | |||
| VENDOR_NAME | VARCHAR2 | 240 | Supplier Name. | Active | ||
| EXPENDITURE_TYPE | VARCHAR2 | 30 | Commitment expenditure type. | Active | ||
| EXPENDITURE_CATEGORY | VARCHAR2 | 30 | The expenditure category of the commitment expenditure type. | Active | ||
| REVENUE_CATEGORY | VARCHAR2 | 30 | The revenue category of the commitment expenditure type. | Active | ||
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 30 | Commitment system linkage function: VENDOR_INVOICES. | Active | ||
| UNIT_OF_MEASURE | VARCHAR2 | 30 | Not currently used in Oracle Projects, Version 4.0. | Active | ||
| UNIT_PRICE | NUMBER | Cost per unit of the project-related commitment distribution. | Active | |||
| CMT_IND_COMPILED_SET_ID | NUMBER | 18 | Identifier for the commitment's burden compiled set. | Active | ||
| TOT_CMT_RAW_COST | NUMBER | The project currency raw cost amount of the project-related commitment distribution. This amount is derived by the commitment summarization process. | Active | |||
| TOT_CMT_BRDND_COST | NUMBER | Commitment cost | Active | |||
| TOT_CMT_QUANTITY | NUMBER | Outstanding quantity of the project-related commitment distribution. | Active | |||
| QUANTITY_ORDERED | NUMBER | Distribution quantity ordered. | Active | |||
| AMOUNT_ORDERED | NUMBER | Distribution amount ordered. | Active | |||
| ORIGINAL_QUANTITY_ORDERED | NUMBER | Distribution original quantity ordered. | Active | |||
| ORIGINAL_AMOUNT_ORDERED | NUMBER | Distribution original amount ordered. | Active | |||
| QUANTITY_CANCELLED | NUMBER | Distribution quantity cancelled. | Active | |||
| AMOUNT_CANCELLED | NUMBER | Distribution amount cancelled. | Active | |||
| QUANTITY_DELIVERED | NUMBER | Distribution quantity delivered. | Active | |||
| AMOUNT_DELIVERED | NUMBER | Distribution amount delivered. | Active | |||
| QUANTITY_INVOICED | NUMBER | Distribution quantity invoiced. | Active | |||
| AMOUNT_INVOICED | NUMBER | Distribution amount invoiced. | Active | |||
| QUANTITY_OUTSTANDING_DELIVERY | NUMBER | Distribution quantity outstanding delivery. | ||||
| AMOUNT_OUTSTANDING_DELIVERY | NUMBER | Distribution amount outstanding delivery. | Active | |||
| QUANTITY_OUTSTANDING_INVOICE | NUMBER | Distribution quantity outstanding invoice. | ||||
| AMOUNT_OUTSTANDING_INVOICE | NUMBER | Distribution amount outstanding invoice. | Active | |||
| QUANTITY_OVERBILLED | NUMBER | Distribution quantity overbilled. | Active | |||
| AMOUNT_OVERBILLED | NUMBER | Distribution amount overbilled. | Active | |||
| ORIGINAL_TXN_REFERENCE1 | VARCHAR2 | 15 | Used to store original transaction reference for commitments from external systems. | Active | ||
| ORIGINAL_TXN_REFERENCE2 | VARCHAR2 | 15 | Used to store original transaction reference for commitments from external systems. | Active | ||
| ORIGINAL_TXN_REFERENCE3 | VARCHAR2 | 15 | Used to store original transaction reference for commitments from external systems. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| BURDEN_SUM_SOURCE_RUN_ID | NUMBER | 18 | Burden summarization source run id. Id will identify all the commitment items summarized in the run to create summarized commitment items | Active | ||
| BURDEN_SUM_DEST_RUN_ID | NUMBER | 18 | Burden summarization Destination run id. Id will identify commitment items created by burden component summarization process | Active | ||
| BURDEN_SUM_REJECTION_CODE | VARCHAR2 | 30 | Burden component summarization rejection code | Active | ||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | 3 | For expense reports, the receipt currency code (the currency in which the expenses originally occurred). | Active | ||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | For expense reports, the receipt currency amount. For all the other rows, this value is null. | Active | |||
| RECEIPT_EXCHANGE_RATE | NUMBER | For expense reports, the exchange rate to convert from the receipt currency to the transaction currency. | Active | |||
| DENOM_CURRENCY_CODE | VARCHAR2 | 3 | The transaction currency code. | Active | ||
| DENOM_RAW_COST | NUMBER | The transaction currency raw cost amount of the project-related commitment distribution. | Active | |||
| DENOM_BRDND_COST | NUMBER | Transaction burdened cost | Active | |||
| ACCT_CURRENCY_CODE | VARCHAR2 | 3 | The functional currency code. | Active | ||
| ACCT_RAW_COST | NUMBER | The functional currency raw cost amount of the project-related commitment distribution. | Active | |||
| ACCT_BRDND_COST | NUMBER | Burdened cost | Active | |||
| ACCT_RATE_DATE | DATE | The functional currency rate date. | Active | |||
| ACCT_RATE_TYPE | VARCHAR2 | 30 | The functional currency rate type (such as Spot or Corporate). | Active | ||
| ACCT_EXCHANGE_RATE | NUMBER | The functional currency exchange rate. | Active | |||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 3 | The project currency code. | Active | ||
| PROJECT_RATE_DATE | DATE | The project currency rate date. | Active | |||
| PROJECT_RATE_TYPE | VARCHAR2 | 30 | The project currency rate type (such as Spot or Corporate). | Active | ||
| PROJECT_EXCHANGE_RATE | NUMBER | The project currency exchange rate. | Active | |||
| CMT_REJECTION_CODE | VARCHAR2 | 80 | The reason why the item was rejected during commitments summarization. | Active | ||
| GENERATION_ERROR_FLAG | VARCHAR2 | 1 | Flag that indicates whether the item has encountered errors during commitments summarization. If Errors, this flag is set to Y. | Active | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier for inventory item | Active | ||
| BOM_LABOR_RESOURCE_ID | NUMBER | 18 | Identifier for BOM labor resource | Active | ||
| BOM_EQUIPMENT_RESOURCE_ID | NUMBER | 18 | Identifier for BOM equipment resource | Active | ||
| PRJ_RAW_COST | NUMBER | Project raw cost | Active | |||
| PRJ_BRDND_COST | NUMBER | Project burdened cost | Active | |||
| PRJ_CURRENCY_CODE | VARCHAR2 | 3 | Project currency code | Active | ||
| PRJ_RATE_DATE | DATE | Commitment attribute | Active | |||
| PRJ_RATE_TYPE | VARCHAR2 | 30 | Commitment attribute | Active | ||
| PRJ_EXCHANGE_RATE | NUMBER | Commitment attribute | Active | |||
| UOM_CODE | VARCHAR2 | 30 | Unit of measure code | Active | ||
| RESOURCE_CLASS | VARCHAR2 | 30 | Holds the code used to identify the resource class.The supported resource class codes are PEOPLE, EQUIPMENT,MATERIAL_ITEMS and FINANCIAL_ELEMENTS. | Active | ||
| SRC_SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 3 | The system linkage of the source expenditure items which were summarized to create separate burden transaction. | Active |