# DW_OM_HOLDS_CF

This table contains details of Holds Facts

## Details

Module: Order Management

## Key Columns

FULFILL_LINE_ID, HOLD_INSTANCE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
HOLD_INSTANCE_ID | NUMBER | 38 | 0 | True | Unique identifier of the hold instance |  |
FULFILL_LINE_ID | NUMBER | 38 | 0 | True | Unique Identifier for a fulfillment line |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. System Identifier |  |
ACTIVE_FLAG | VARCHAR2 | 16 |  |  | Identifies whether a hold is active on a transaction. |  |
APPLY_TIMESTAMP | TIMESTAMP |  |  |  | Date hold was placed. |  |
APPLY_DATE | DATE |  |  |  | Date hold was placed. | DW_DAY_D | CALENDAR_DATE
APPLIED_BY | VARCHAR2 | 128 |  |  | The user name that requested to apply this hold instance. This is only applicable when the apply system is DOO workbench. | DW_USER_D | USERNAME
HOLD_CODE_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for hold codes | DW_OM_HOLD_CODES_D | HOLD_CODE_ID
HOLD_COMMENTS | VARCHAR2 | 256 |  |  | Comments the user who is initiating the hold adds to the hold. |  |
HOLD_CREATION_DATE | DATE |  |  |  | Who column: indicates the date of the creation of the row. | DW_DAY_D | CALENDAR_DATE
HOLD_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
HOLD_LAST_UPDATE_DATE | DATE |  |  |  | Who column: indicates the date and time of the last update of the row. | DW_DAY_D | CALENDAR_DATE
HOLD_LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
HOLD_CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
HOLD_LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who last updated the row. | DW_USER_D | USERNAME
HOLD_RELEASE_COMMENTS | VARCHAR2 | 256 |  |  | Comments added by user while releasing a hold. |  |
HOLD_RELEASE_REASON_CODE | VARCHAR2 | 32 |  |  | Reason for releasing the hold. | DW_HOLD_RELEASE_REASON_LKP_TL | HOLD_RELEASE_REASON_CODE
TRANSACTION_ENTITY_NAME1 | VARCHAR2 | 32 |  |  | Entity name corresponding to Transaction Entity Id1. |  |
HOLD_LEVEL | VARCHAR2 | 32 |  |  | Reference to the level at which the hold is applied | DW_MSG_ENTITY_TYPE_LKP_TL | HOLD_LEVEL_CODE
RELEASE_TIMESTAMP | TIMESTAMP |  |  |  | The date when the hold is released. |  |
RELEASE_DATE | DATE |  |  |  | The date when the hold is released. | DW_DAY_D | CALENDAR_DATE
RELEASED_BY | VARCHAR2 | 128 |  |  | The user name that requested to release this hold instance. | DW_USER_D | USERNAME
HOLD_SOURCE_ORDER_SYSTEM | VARCHAR2 | 64 |  |  | Reference to the order capture system that the source order came from. |  |
APPLY_SYSTEM | VARCHAR2 | 32 |  |  | The system that requested to apply this hold instance. |  |
ORDER_HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of the orchestration order |  |
ORDER_NUMBER | VARCHAR2 | 64 |  |  | Representation of a sales order used in communication with fulfillment systems |  |
LINE_ID | NUMBER | 38 | 0 |  | Unique identifier of the sales order line |  |
ORDER_LINE_NUMBER | NUMBER | 38 | 0 |  | Representation of a sales order line used in communication with fulfillment systems |  |
FULFILL_LINE_NUMBER | NUMBER | 38 | 0 |  | Numerical value associated to fulfillment line. It is defaulted to 1 and increments in integers as fulfillment lines split |  |
LINE_DISPLAY_LINE_NUMBER | VARCHAR2 | 128 |  |  | Line number for display purposes. Corresponds to the line number on UI |  |
FULFILL_DISPLAY_LINE_NUMBER | VARCHAR2 | 256 |  |  | Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI |  |
ORGANIZATION_ID | NUMBER | 38 | 0 |  | Indicates the identifier of the inventory organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID
FULFILL_ORG_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the fulfillment organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit ID | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROFIT_CENTER_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Reference to Unique Identifier of Profit Center Business Unit | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
ORGANIZATION_BU_ID | NUMBER | 38 | 0 |  | Inventory Business Unit ID | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
INVENTORY_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 |  | Profit Center Business Unit Id of the Inventory Organization. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
ORDER_TYPE_CODE | VARCHAR2 | 32 |  |  | Name of the type of order that was placed | DW_ORDER_TYPE_LKP_TL | ORDER_TYPE_CODE
ORDER_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the order | DW_OM_STATUS_D | STATUS_CODE
LINE_CATEGORY_CODE | VARCHAR2 | 32 |  |  | Represents whether a sales order line belongs to a regular order or a return order | DW_ORDER_LINE_CATEGORY_LKP_TL | LINE_CATEGORY_CODE
LINE_TYPE_CODE | VARCHAR2 | 32 |  |  | Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed. Use DW_ORDER_LINE_TYPE_LKP_TL to resolve the lookup codes for order lines, and DW_ORDER_RETURN_TYPE_LKP_TL for return lines | DW_ORDER_LINE_TYPE_LKP_TL | LINE_TYPE_CODE
FULFILL_LINE_STATUS_CODE | VARCHAR2 | 32 |  |  | Current fulfillment status of the fulfillment line | DW_OM_STATUS_D | STATUS_CODE
SOURCE_ORDER_NUMBER | VARCHAR2 | 64 |  |  | Reference to the number of the originating sales order |  |
SOURCE_ORDER_SYSTEM | VARCHAR2 | 64 |  |  | Reference to the order capture system that the source order came from |  |
SOURCE_ORDER_LINE_NUMBER | VARCHAR2 | 128 |  |  | Reference to the number of the originating sales order line |  |
SOURCE_DOCUMENT_TYPE_CODE | VARCHAR2 | 64 |  |  | Indicates the Original Document document type on the order |  |
PARENT_FULFILL_LINE_ID | NUMBER | 38 | 0 |  | Used in fulfillment line hierarchies (models) to identify the immediate parent fulfillment line |  |
ROOT_PARENT_FULFILL_LINE_ID | NUMBER | 38 | 0 |  | Used in fulfillment line hierarchies (models) to identify the highest fulfillment line in the hierarchy |  |
PARENT_LINE_ID | NUMBER | 38 | 0 |  | Parent Line Identifier |  |
ROOT_PARENT_LINE_ID | NUMBER | 38 | 0 |  | Root Parent Line Identifier |  |
COMP_SEQ_PATH | VARCHAR2 | 999 |  |  | Defines the hierarchical relation of a model. Derived from BOM table |  |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the inventory item | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_TYPE_CODE | VARCHAR2 | 32 |  |  | Indicates a grouping of all items of a particular type that share the same set of item attributes | DW_ORDER_ITEM_TYPE_LKP_TL | ORDER_ITEM_TYPE_CODE
ITEM_SUBTYPE_CODE | VARCHAR2 | 32 |  |  | More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC) | DW_ORDER_ITEM_SUBTYPE_LKP_TL | ORDER_ITEM_SUBTYPE_CODE
SALES_PRODUCT_TYPE_CODE | VARCHAR2 | 32 |  |  | Identifies sales product type of product on the fulfillment line | DW_SALES_PRODUCT_TYPE_LKP_TL | SALES_PRODUCT_TYPE_CODE
PAYMENT_TERM_ID | NUMBER | 38 | 0 |  | Identifies the AR payment term associated with the Payment terms | DW_AR_PAYMENT_TERMS_D | PAYMENT_TERM_ID
PARENT_LINE_DISPLAY_LINE_NUM | VARCHAR2 | 128 |  |  | Display line number of parent line |  |
PARENT_FLINE_DISPLAY_LINE_NUM | VARCHAR2 | 128 |  |  | Display line number of parent fulfill line |  |
RP_LINE_DISPLAY_LINE_NUM | VARCHAR2 | 128 |  |  | Display line number of root parent line |  |
RP_FLINE_DISPLAY_LINE_NUM | VARCHAR2 | 128 |  |  | Display line number of root parent fulfill line |  |
CONFIGURED_ITEM_ID | NUMBER | 38 | 0 |  | Inventory item of shippable ATO configuration | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ORIGINAL_INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the original inventory item that was populated on the fulfillment line from decomposition | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ORDER_BILL_TO_CUST_ACCT_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the bill-to customer(Order Header level) | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
ORDER_BILL_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for bill-to Party(Order Header Level) | DW_PARTY_D | PARTY_ID
ORDER_BILL_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for bill-to contact Party(Order Header Level) | DW_PARTY_D | PARTY_ID
ORDER_BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the bill-to customer location(Order Header Level) | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
BILL_TO_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the bill-to customer(Fulfillment Line Level) | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
BILL_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for bill-to Party(Fulfillment Line Level) | DW_PARTY_D | PARTY_ID
BILL_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for bill-to contact Party(Fulfillment Line Level) | DW_PARTY_D | PARTY_ID
BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the bill-to customer location(Fulfillment Line Level) | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SOLD_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the sold-to Party. | DW_PARTY_D | PARTY_ID
SOLD_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the sold-to contact Party. | DW_PARTY_D | PARTY_ID
ORDER_SHIP_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for ship-to Party(Order Header Level) | DW_PARTY_D | PARTY_ID
ORDER_SHIP_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for ship-to contact Party(Order Header Level) | DW_PARTY_D | PARTY_ID
ORDER_SHIP_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the ship-to party location(Order Header Level) | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SHIP_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for ship-to Party(Fulfillment Line Level) | DW_PARTY_D | PARTY_ID
SHIP_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for ship-to contact Party(Fulfillment Line Level) | DW_PARTY_D | PARTY_ID
SHIP_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the ship-to party location(Fulfillment Line Level) | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SHIP_TO_PARTY_SITE_NAME | VARCHAR2 | 256 |  |  | Fulfillment line ship to party site name |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledger id | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Period type | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Period Set Name | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
ORDER_OPEN_FLAG | VARCHAR2 | 16 |  |  | Indicates that the status of an order that is not closed or canceled |  |
ORDER_ON_HOLD_FLAG | VARCHAR2 | 16 |  |  | Indicates an order is not accepting further processing |  |
FULFILL_LINE_OPEN_FLAG | VARCHAR2 | 16 |  |  | Indicates that the status of a fulfillment line that is not closed or canceled |  |
FULFILL_LINE_ON_HOLD_FLAG | VARCHAR2 | 16 |  |  | Indicates fulfillment lines are not accepting further processing |  |
SALES_AGREEMENT_FLAG | VARCHAR2 | 16 |  |  | Indicated application of a Sales Agreement |  |
ORDER_SUBMIT_DATE | DATE |  |  |  | The date and time of the submission of the order | DW_DAY_D | CALENDAR_DATE
ORDER_SUBMIT_TIMESTAMP | TIMESTAMP |  |  |  | The date and time of the submission of the order |  |
ORDERED_DATE | DATE |  |  |  | Date when the items where ordered | DW_DAY_D | CALENDAR_DATE
ORDERED_TIMESTAMP | TIMESTAMP |  |  |  | Date when the items where ordered |  |
SCHEDULE_SHIP_DATE | DATE |  |  |  | The current date the shipment is planned to ship on | DW_DAY_D | CALENDAR_DATE
SCHEDULE_SHIP_TIMESTAMP | TIMESTAMP |  |  |  | The current date the shipment is planned to ship on |  |
PROMISE_SHIP_DATE | DATE |  |  |  | The date that was promised to the customer that the item would ship | DW_DAY_D | CALENDAR_DATE
PROMISE_SHIP_TIMESTAMP | TIMESTAMP |  |  |  | The date that was promised to the customer that the item would ship |  |
REQUEST_SHIP_DATE | DATE |  |  |  | The original date the customer requested the item ship on | DW_DAY_D | CALENDAR_DATE
REQUEST_SHIP_TIMESTAMP | TIMESTAMP |  |  |  | The original date the customer requested the item ship on |  |
ACTUAL_SHIP_DATE | DATE |  |  |  | The date the shipment was actually sent | DW_DAY_D | CALENDAR_DATE
ACTUAL_SHIP_TIMESTAMP | TIMESTAMP |  |  |  | The date the shipment was actually sent |  |
SCHEDULE_ARRIVAL_DATE | DATE |  |  |  | The current date the shipment is planned to arrive on | DW_DAY_D | CALENDAR_DATE
SCHEDULE_ARRIVAL_TIMESTAMP | TIMESTAMP |  |  |  | The current date the shipment is planned to arrive on |  |
PROMISE_ARRIVAL_DATE | DATE |  |  |  | The date that was promised to the customer that the item would arrive | DW_DAY_D | CALENDAR_DATE
PROMISE_ARRIVAL_TIMESTAMP | TIMESTAMP |  |  |  | The date that was promised to the customer that the item would arrive |  |
REQUEST_ARRIVAL_DATE | DATE |  |  |  | The original date the customer requested the item arrive on | DW_DAY_D | CALENDAR_DATE
REQUEST_ARRIVAL_TIMESTAMP | TIMESTAMP |  |  |  | The original date the customer requested the item arrive on |  |
FULFILLED_DATE | DATE |  |  |  | Date when the order line is fulfilled (Goods shipped, hardware installed etc.) | DW_DAY_D | CALENDAR_DATE
FULFILLED_TIMESTAMP | TIMESTAMP |  |  |  | Date when the order line is fulfilled (Goods shipped, hardware installed etc.) |  |
FULFILL_LINE_CANCEL_DATE | DATE |  |  |  | Date on which customer requested cancellation on the fulfill line | DW_DAY_D | CALENDAR_DATE
FULFILL_LINE_CANCEL_TIMESTAMP | TIMESTAMP |  |  |  | Date on which customer requested cancellation on the fulfill line |  |
ORDER_CANCELLED_FLAG | VARCHAR2 | 16 |  |  | Indicates if the entire order has been cancelled or not |  |
ORDER_CANCELLED_REASON_CODE | VARCHAR2 | 32 |  |  | Reason for cancelation of order | DW_RETURN_REASON_LKP_TL | RETURN_REASON_CODE
FULFILL_LINE_CANCEL_FLAG | VARCHAR2 | 16 |  |  | Indicates if the order fulfill line has been cancelled or not |  |
RMA_RECEIPT_DATE | DATE |  |  |  | Actual Receipt Date of items for a return order, populated here by the receiving fulfillment system | DW_DAY_D | CALENDAR_DATE
RMA_RECEIPT_TIMESTAMP | TIMESTAMP |  |  |  | Actual Receipt Date of items for a return order, populated here by the receiving fulfillment system |  |
ORIGINAL_ORDER_NUMBER | VARCHAR2 | 64 |  |  | Corresponds to the original order number for which return is generated |  |
SUBMITTED_BY | VARCHAR2 | 64 |  |  | Order submitted by | DW_USER_D | USERNAME
CREATION_DATE | DATE |  |  |  | fulfill line creation date | DW_DAY_D | CALENDAR_DATE
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | fulfill line creation date |  |
ORDER_CREATION_DATE | DATE |  |  |  | order creation date | DW_DAY_D | CALENDAR_DATE
ORDER_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | order creation date |  |
CREATED_BY | VARCHAR2 | 64 |  |  | Fulfill line created by | DW_USER_D | USERNAME
LAST_UPDATE_DATE | DATE |  |  |  | Fulfill line last update date | DW_DAY_D | CALENDAR_DATE
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Fulfill line last update date |  |
LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | Fulfill line last updated by | DW_USER_D | USERNAME
CUSTOMER_PO_NUMBER | VARCHAR2 | 64 |  |  | Customer PO Number |  |
CUSTOMER_PO_LINE_NUMBER | VARCHAR2 | 64 |  |  | An identifier of the line record on a transaction. The purchase order line describes an item or service, with a price and quantity ordered. |  |
CUSTOMER_PO_SCHEDULE_NUMBER | VARCHAR2 | 64 |  |  | Contains Customers Purchase Order Shipment Schedule number , if specified while submitting an order. |  |
DROP_SHIPMENT_PO_HEADER_ID | NUMBER | 38 | 0 |  | Header ID for Drop ship PO |  |
DROP_SHIPMENT_PO_NUMBER | VARCHAR2 | 256 |  |  | Header Number for Drop ship PO |  |
DROP_SHIPMENT_PO_LINE_ID | NUMBER | 38 | 0 |  | Line ID for Drop ship PO |  |
DROP_SHIPMENT_PO_LINE_NUMBER | VARCHAR2 | 256 |  |  | Line Number for Drop ship PO |  |
DROP_SHIPMENT_PO_SCHEDULE_ID | NUMBER | 38 | 0 |  | Schedule ID for Drop ship PO |  |
DROP_SHIPMENT_PO_SCHEDULE_NUMBER | VARCHAR2 | 256 |  |  | Schedule Number for Drop ship PO |  |
DROP_SHIPMENT_REQUISITION_HEADER_ID | NUMBER | 38 | 0 |  | Requisition Header ID for Drop ship PO |  |
DROP_SHIPMENT_REQUISITION_NUMBER | VARCHAR2 | 256 |  |  | Requisition Header Number for Drop ship PO |  |
DROP_SHIPMENT_REQUISITION_LINE_ID | NUMBER | 38 | 0 |  | Requisition Line ID for Drop ship PO |  |
DROP_SHIPMENT_REQUISITION_LINE_NUMBER | VARCHAR2 | 256 |  |  | Requisition Line Number for Drop ship PO |  |
DROP_SHIPMENT_REQUISITION_BU_ID | NUMBER | 38 | 0 |  | Maps to BU Id as per Fusion Enterprise structure. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
DROP_SHIPMENT_REQUISITION_INVENTORY_ORG_ID | NUMBER | 38 | 0 |  | Maps to Organization Id as per Fusion Enterprise structure. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
DROP_SHIPMENT_PO_BUYER_ID | NUMBER | 38 | 0 |  | Holds Buyer information for a schedule, this is a reference column and it is referenced to BUYER PUBLIC VIEW that is published by purchase Order product. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
SHIP_STATUS | VARCHAR2 | 32 |  |  | Status of a fulfillment line where the detail level task type is shipment. | DW_OM_STATUS_D | STATUS_CODE
ORDER_PRICING_SEGMENT_CODE | VARCHAR2 | 32 |  |  | Stores either the pricing segment code passed in from the caller or the pricing segment code derived by the pricing engine | DW_ORA_QP_CUST_PRICING_SEGMENTS_LKP_TL | ORA_QP_CUST_PRICING_SEGMENTS_CODE
ORDER_PRICING_SEGMENT_EXPLANATION | VARCHAR2 | 999 |  |  | Message explaining why the Pricing Segment was applied |  |
ORDER_PRICING_STRATEGY_EXPLANATION | VARCHAR2 | 999 |  |  | Message explaining why the Pricing Strategy was applied |  |
SHIPPING_INSTRUCTIONS | VARCHAR2 | 999 |  |  | A message on a document that provides details about cargo and any requirements for its physical movement. |  |
PACKING_INSTRUCTIONS | VARCHAR2 | 999 |  |  | A document that contains information concerning the packing of an item. |  |
SALESPERSON_ID | NUMBER | 38 | 0 |  | Primary Sales person identifier. | DW_PARTY_D | PARTY_ID
ORDER_CUSTOMER_PO_NUMBER | VARCHAR2 | 64 |  |  | Header level customer PO number |  |
PJC_PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. | DW_PROJECT_D | PROJECT_ID
PJC_TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
PJC_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
PJC_EXPENDITURE_ITEM_DATE | DATE |  |  |  | Date on which a project-related transaction is incurred | DW_DAY_D | CALENDAR_DATE
PJC_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. | DW_INTERNAL_ORG_D | ORGANIZATION_ID

Copyright © 2019, 2026, Oracle and/or its affiliates.