PO_DISTRIBUTIONS_GT
Temporary table used in validations
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PO_DISTRIBUTIONS_GT_PK |
PO_DISTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Document distribution unique identifier | |
| BUDGET_DATE | DATE | Budget or Accounting date on distribution | |||
| DEST_CHARGE_ACCOUNT_ID | NUMBER | 18 | Destination Charge Account | ||
| DEST_VARIANCE_ACCOUNT_ID | NUMBER | 18 | Destination Variance Account | ||
| ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates entity change type - added or updated | ||
| PRC_BU_ID | NUMBER | 18 | Procurement Business Unit ID. This should be a NOT NULL column | ||
| REQ_BU_ID | NUMBER | 18 | Requisitioning Business Unit Id | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| PO_HEADER_ID | NUMBER | 18 | Yes | Document header unique identifier. | |
| PO_LINE_ID | NUMBER | 18 | Document line unique identifier. | ||
| LINE_LOCATION_ID | NUMBER | 18 | Document shipment unique identifier. | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Set of Books unique identifier. References GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID. | |
| CODE_COMBINATION_ID | NUMBER | 18 | Unique identifier for the General Ledger charge account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. | ||
| QUANTITY_ORDERED | NUMBER | Quantity ordered on the distribution | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| QUANTITY_DELIVERED | NUMBER | Quantity delivered against the distribution | |||
| QUANTITY_BILLED | NUMBER | Quantity invoiced by Oracle Payables against the distribution | |||
| QUANTITY_CANCELLED | NUMBER | Quantity cancelled for the distribution | |||
| REQ_HEADER_REFERENCE_NUM | VARCHAR2 | 25 | Identifies the requisition number of the corresponding paper requisition, if you do not autocreate the purchase order from online requisitions. | ||
| REQ_LINE_REFERENCE_NUM | VARCHAR2 | 25 | Identifies the requisition line number of the corresponding paper requisition, if you do not autocreate the purchase order from online requisitions. | ||
| REQ_DISTRIBUTION_ID | NUMBER | 18 | Requisition distribution unique identifier. References PO_REQ_DISTRIBUTIONS_ALL.DISTRIBUTION_ID. | ||
| DELIVER_TO_LOCATION_ID | NUMBER | 18 | Unique identifier for the delivery location. | ||
| DELIVER_TO_PERSON_ID | NUMBER | 18 | Unique identifier for the requester | ||
| RATE_DATE | DATE | Currency conversion date | |||
| RATE | NUMBER | Currency conversion rate. References GL_DAILY_CONVERSION_RATES_R10.CONVERSION_RATE. | |||
| AMOUNT_BILLED | NUMBER | Amount invoiced by Oracle Payables against the distribution | |||
| ACCRUED_FLAG | VARCHAR2 | 1 | Indicates whether the distribution was accrued (received but not yet billed). | ||
| ENCUMBERED_FLAG | VARCHAR2 | 1 | Distribution encumbered flag | ||
| ENCUMBERED_AMOUNT | NUMBER | Encumbered amount for distribution | |||
| UNENCUMBERED_QUANTITY | NUMBER | Quantity unencumbered on the distribution | |||
| UNENCUMBERED_AMOUNT | NUMBER | Amount unencumbered on the distribution | |||
| FAILED_FUNDS_LOOKUP_CODE | VARCHAR2 | 25 | Type of budgetary control approval failure | ||
| GL_ENCUMBERED_DATE | DATE | Date the distribution was encumbered | |||
| GL_ENCUMBERED_PERIOD_NAME | VARCHAR2 | 15 | Period in which the distribution was encumbered | ||
| GL_CANCELLED_DATE | DATE | Date the distribution was cancelled | |||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Final destination of the purchased items | ||
| DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Final destination organization unique identifier. References HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID. Combined with DESTINATION_SUBINVENTORY, forms a foreign key to INV_SECONDARY_INVENTORIES. Combined with WIP_ENTITY_ID, forms a foreign key to WIP_ENTITIES. Combined with WIP_LINE_ID, forms a foreign key to WIP_LINES. Combined with WIP_ENTITY_ID, WIP_OPERATION_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATIONS. Combined with WIP_ENTITY_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATION_RESOURCES. | ||
| DESTINATION_SUBINVENTORY | VARCHAR2 | 10 | Subinventory unique identifier for inventory purchases. Combined with DESTINATION_ORGANIZATION_ID, forms a foreign key to INV_SECONDARY_INVENTORIES. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| WIP_ENTITY_ID | NUMBER | WIP job or repetitive assembly identifier. Combined with DESTINATION_ORGANIZATION_ID, forms a foreign key to WIP_ENTITIES. Combined with DESTINATION_ORGANIZATION_ID, WIP_OPERATION_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATIONS. Combined with DESTINATION_ORGANIZATION_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATION_RESOURCES. | |||
| WIP_OPERATION_SEQ_NUM | NUMBER | WIP operation sequence number within a routing. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATIONS. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, WIP_RESOURCE_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATION_RESOURCES. | |||
| WIP_RESOURCE_SEQ_NUM | NUMBER | WIP resource sequence number. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, WIP_OPERATION_SEQ_NUM, and WIP_REPETITIVE_SCHEDULE_ID, forms a foreign key to WIP_OPERATION_RESOURCES. | |||
| WIP_REPETITIVE_SCHEDULE_ID | NUMBER | 18 | WIP repetitive schedule identifier. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, and WIP_OPERATION_SEQ_NUM, forms a foreign key to WIP_OPERATIONS. Combined with WIP_ENTITY_ID, DESTINATION_ORGANIZATION_ID, WIP_OPERATION_SEQ_NUM, and WIP_RESOURCE_SEQ_NUM, forms a foreign key to WIP_OPERATION_RESOURCES. | ||
| WIP_LINE_ID | NUMBER | 18 | WIP line identifier. Combined with DESTINATION_ORGANIZATION_ID, forms a foreign key to WIP_LINES. | ||
| BOM_RESOURCE_ID | NUMBER | 18 | BOM resource unique identifier. References BOM_RESOURCES.RESOURCE_ID. | ||
| BUDGET_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger budget account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. | ||
| ACCRUAL_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger accrual account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. | ||
| VARIANCE_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger variance account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. | ||
| PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | 1 | Indicates whether distribution should be encumbered | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | United States standard general ledger transaction code. References GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE. | ||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | ||
| DESTINATION_CONTEXT | VARCHAR2 | 30 | Protected descriptive flexfield context column for destination details | ||
| DISTRIBUTION_NUM | NUMBER | Yes | Distribution number | ||
| SOURCE_DISTRIBUTION_ID | NUMBER | 18 | Unique identifier of the planned purchase order distribution that was referenced when creating this scheduled release distribution. References PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID. | ||
| GL_CLOSED_DATE | DATE | Date the distribution was final-closed | |||
| ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether items are accrued upon receipt | ||
| SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | ||
| KANBAN_CARD_ID | NUMBER | 18 | Primary key for the kanban card. References MTL_KANBAN_CARDS.KANBAN_CARD_ID. | ||
| AWARD_ID | NUMBER | 18 | Award identifier. References GMS_AWARD_DISTRIBUTIONS.AWARD_SET_ID. | ||
| MRC_RATE_DATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion date pairs | ||
| MRC_RATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenatedstring of reporting Set of Books ID and currency conversion rate pairs | ||
| MRC_ENCUMBERED_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books Id and encumbered amount for distribution pairs | ||
| MRC_UNENCUMBERED_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and amount unencumbered on the distribution pairs | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | Project Manufacturing end item unit number | ||
| TAX_RECOVERY_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicator of whether tax recovery should be used | ||
| RECOVERABLE_TAX | NUMBER | The Recoverable exclusive tax amount for the distribution. | |||
| NONRECOVERABLE_TAX | NUMBER | The Nonrecoverable exclusive tax amount for the distribution. | |||
| RECOVERABLE_INCLUSIVE_TAX | NUMBER | The portion of the taxes paid that is included in the Distribution Ordered amount and which is recoverable. | |||
| NONRECOVERABLE_INCLUSIVE_TAX | NUMBER | The portion of the taxes paid that is included in the Distribution Ordered amount and which is nonrecoverable. | |||
| TAX_EXCLUSIVE_AMOUNT | NUMBER | The Purchase order distribution amount that is exclusive of all the taxes. | |||
| RECOVERY_RATE | NUMBER | Percentage of tax that can be recovered | |||
| OKE_CONTRACT_LINE_ID | NUMBER | 18 | Line Id associated with a contract | ||
| OKE_CONTRACT_DELIVERABLE_ID | NUMBER | 18 | Deliverable Id corresponding to contract | ||
| AMOUNT_CANCELLED | NUMBER | Amount cancelled for service lines | |||
| AMOUNT_DELIVERED | NUMBER | Amount delivered for service lines | |||
| AMOUNT_ORDERED | NUMBER | Amount ordered for service lines | |||
| AMOUNT_TO_ENCUMBER | NUMBER | -- FPJ Encumbrance Rewrite Project | |||
| DISTRIBUTION_TYPE | VARCHAR2 | 25 | -- FPJ Encumbrance Rewrite Project | ||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection | ||
| PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions | ||
| PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions | ||
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions | ||
| PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which a project-related transaction is incurred | |||
| PJC_ORGANIZATION_ID | NUMBER | 18 | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions | ||
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is available to be billed to customers | ||
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is eligible for capitalization | ||
| PJC_WORK_TYPE_ID | NUMBER | 18 | Identifier for project-related classification of the worked performed | ||
| PJC_CONTRACT_ID | NUMBER | 18 | Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed | ||
| PJC_CONTRACT_LINE_ID | NUMBER | 18 | Tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed | ||
| PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Specifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed | ||
| PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable project information | ||
| QUANTITY_CONSUMED | NUMBER | Quantity consumed against the distribution | |||
| DELIVER_TO_CUST_LOCATION_ID | NUMBER | 18 | The final location where goods will be delivered that were previously received from a supplier. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| SHIPPING_UOM_QUANTITY | NUMBER | Quantity in shipping unit of measure | |||
| SHIPPING_UOM_QUANTITY_CANCELED | NUMBER | Quantity in shipping unit of measure canceled up until today | |||
| TXN_QUANTITY_ORDERED | NUMBER | Quantity ordered on the distribution | |||
| TXN_AMOUNT_ORDERED | NUMBER | Amount ordered for service lines | |||
| TXN_SHIP_UOM_QTY_DELIVERED | NUMBER | Quantity in shipping unit of measure delivered against the distribution | |||
| TXN_SHIPPING_UOM_QUANTITY | NUMBER | Quantity in shipping unit of measure | |||
| TXN_DEL_TO_LOC_ID | NUMBER | 18 | Unique identifier for the delivery location. References HR_LOCATIONS_ALL.LOCATION_ID. | ||
| TXN_DEL_TO_CUST_LOC_ID | NUMBER | 18 | The final location where goods will be delivered that were previously received from a supplier. | ||
| TXN_DEST_CHARGE_ACCOUNT_ID | NUMBER | 18 | Added in Shared Procurement Services Project (FPJ). This is the Charge Account of the Destination OU (DOU), when the DOU is different from the Purchasing OU (POU) and a Transaction Flow exists between the DOU and POU. It is a unique identifier for a General Ledger account and references GL_CODE_COMBINATIONS.code_combination_id. | ||
| TXN_CODE_COMBINATION_ID | NUMBER | 18 | Unique identifier for the General Ledger charge account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. | ||
| TXN_BUDGET_DATE | DATE | Budget date used for commitment control |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| PO_DISTRIBUTIONS_GT_N1 | Non Unique | PO_HEADER_ID |
| PO_DISTRIBUTIONS_GT_N3 | Non Unique | PO_LINE_ID |
| PO_DISTRIBUTIONS_GT_N4 | Non Unique | LINE_LOCATION_ID |
| PO_DISTRIBUTIONS_GT_U1 | Unique | PO_DISTRIBUTION_ID |