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 |