PO_DISTRIBUTIONS_ARCHIVE_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL contains archived distribution information. Oracle Purchasing only archives distributions for the following documents: Standard purchase orders, Planned purchase orders, Planned purchase order releases and Blanket purchase order releases. When you modify a distribution, Oracle Purchasing will archive it after you (re)approve the purchase order or after you print it (this depends on the purchasing system options). You can retrieve revisions of the distributions using this table. The latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'. You need one row for each distribution archive. Each row contains the same information as the PO_DISTRIBUTIONS_ALL table. Oracle Purchasing uses this information to ensure you keep copies of your legal documents.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PO_DISTRIBUTIONS_ARCHIVE_PK |
PO_DISTRIBUTION_ID, FROM_CO_SEQ |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Document distribution unique identifier | |
| FUNDS_STATUS | VARCHAR2 | 25 | status to indicate whether funds have been reserved on the distribution or not | ||
| BUDGET_DATE | DATE | Budget date for commitment control | |||
| CANCEL_BUDGET_DATE | DATE | Budget date used for commitment control for cancel action | |||
| CO_QUANTITY_CANCELLED | NUMBER | CO_QUANTITY_CANCELLED | |||
| CO_AMOUNT_CANCELLED | NUMBER | CO_AMOUNT_CANCELLED | |||
| ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates if the row is new or changed. | ||
| EXTERNAL_CHANGE_FLAG | VARCHAR2 | 1 | indicates if the change is external (supplier facing ) or not | ||
| REASON_FOR_CHANGE | VARCHAR2 | 240 | This column documents the reason for changing this distribution | ||
| DIST_INTENDED_USE | VARCHAR2 | 240 | Intended Use is the purpose for which a product is likely to be used in the business by the purchaser | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| ENTITY_CO_DISPOSITION | VARCHAR2 | 25 | ENTITY_CO_DISPOSITION | ||
| FROM_CO_SEQ | NUMBER | Yes | The starting point of the co sequence range within which the record is valid (Inclusive) | ||
| PRC_BU_ID | NUMBER | 18 | Yes | procurement bu id | |
| REQ_BU_ID | NUMBER | 18 | Yes | requisition bu id | |
| TO_CO_SEQ | NUMBER | The ending point of the co sequence range within which the record is valid (Exclusive) | |||
| 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 schedule unique identifier | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Set of Books unique identifier | |
| CODE_COMBINATION_ID | NUMBER | 18 | Unique identifier for the General Ledger charge account | ||
| 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. | |
| REQ_HEADER_REFERENCE_NUM | VARCHAR2 | 25 | Requisition number of the requisition line placed on this distribution | ||
| REQ_LINE_REFERENCE_NUM | VARCHAR2 | 25 | Line number of the requisition line placed on the distribution | ||
| REQ_DISTRIBUTION_ID | NUMBER | 18 | Requisition distribution unique identifier | ||
| 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 | |||
| ACCRUED_FLAG | VARCHAR2 | 1 | Indicates whether the distribution was accrued or not | ||
| ENCUMBERED_FLAG | VARCHAR2 | 1 | Indicator of whether the distribution was encumbered | ||
| 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 | ||
| DESTINATION_SUBINVENTORY | VARCHAR2 | 10 | Subinventory unique identifier for inventory purchases | ||
| 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. | |||
| 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. | |||
| WIP_ENTITY_ID | NUMBER | 18 | WIP job or repetitive assembly identifier | ||
| WIP_OPERATION_SEQ_NUM | NUMBER | WIP operation sequence number within a routing | |||
| WIP_RESOURCE_SEQ_NUM | NUMBER | WIP resource sequence number | |||
| WIP_REPETITIVE_SCHEDULE_ID | NUMBER | 18 | WIP repetitive schedule identifier | ||
| WIP_LINE_ID | NUMBER | 18 | WIP line identifier | ||
| BOM_RESOURCE_ID | NUMBER | 18 | BOM resource unique identifier | ||
| BUDGET_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger budget account | ||
| ACCRUAL_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger accrual account | ||
| VARIANCE_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger variance account | ||
| DESTINATION_CONTEXT | VARCHAR2 | 30 | Destination details protected descriptive flexfield context column | ||
| 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 | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Concurrent program application name | ||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | ||
| PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | 1 | Indicates whether distribution should be encumbered | ||
| ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether items are accrued on receipt | ||
| SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | Project Manufacturing end item unit number | ||
| KANBAN_CARD_ID | NUMBER | 18 | Primary key for the kanban card | ||
| AWARD_ID | NUMBER | 18 | Award identifier | ||
| 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 | |||
| TAX_RECOVERY_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicator of whether tax recovery should be used | ||
| OKE_CONTRACT_LINE_ID | NUMBER | 18 | Line Id associated with a contract | ||
| OKE_CONTRACT_DELIVERABLE_ID | NUMBER | 18 | Deliverable Id corresponding to contract | ||
| AMOUNT_ORDERED | NUMBER | Amount Ordered | |||
| DISTRIBUTION_TYPE | VARCHAR2 | 25 | -- FPJ Encumbrance Rewrite project | ||
| AMOUNT_TO_ENCUMBER | NUMBER | -- FPJ Encumbrance Rewrite Project | |||
| 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. | ||
| DEST_VARIANCE_ACCOUNT_ID | NUMBER | 18 | Added in Shared Procurement Services Project (FPJ). This is the Variance Account of the DOU, when the DOU is different from the 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. | ||
| 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 project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for 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 | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ORIGINAL_DISTRIBUTION_ID | NUMBER | 18 | Holds the po_distribution_id of the distribution from which this shipment was copied/split over | ||
| DELIVER_TO_CUST_LOCATION_ID | NUMBER | 18 | The final location where goods will be delivered that were previously received from a supplier. | ||
| DELIVER_TO_CUST_ID | NUMBER | 18 | Customer to whom merchandise is being delivered. | ||
| DELIVER_TO_CUST_CONTACT_ID | NUMBER | 18 | Contact from the company where the good are being delivered. | ||
| SHIPPING_UOM_QUANTITY | NUMBER | Quantity in shipping unit of measure | |||
| CO_SHIPPING_QUANTITY_CANCELLED | NUMBER | Changed quantity in shipping unit of measure canceled up until today |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_DISTRIBUTIONS_ARCHIVE_ALL | po_headers_all | PO_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PO_DISTRIBUTIONS_ARCHIVE_N1 | Non Unique | Default | DELIVER_TO_PERSON_ID | |
| PO_DISTRIBUTIONS_ARCHIVE_N2 | Non Unique | Default | PO_HEADER_ID | |
| PO_DISTRIBUTIONS_ARCHIVE_N5 | Non Unique | Default | PO_LINE_ID | |
| PO_DISTRIBUTIONS_ARCHIVE_N6 | Non Unique | Default | LINE_LOCATION_ID, DISTRIBUTION_NUM | Obsolete |
| PO_DISTRIBUTIONS_ARCHIVE_N7 | Non Unique | Default | DELIVER_TO_CUST_ID | |
| PO_DISTRIBUTIONS_ARCHIVE_N8 | Non Unique | Default | DELIVER_TO_CUST_CONTACT_ID | |
| PO_DISTRIBUTIONS_ARCHIVE_U1 | Unique | Default | PO_DISTRIBUTION_ID, FROM_CO_SEQ | |
| PO_DISTRIB_ARCHIVE_ALL_U1 | Unique | Default | LINE_LOCATION_ID, DISTRIBUTION_NUM, FROM_CO_SEQ |