PO_DISTRIBUTIONS_INTERFACE
PO_DISTRIBUTIONS_INTERFACE is the interface table that holds distribution information for the PDOI program to create standard purchase order. The PDOI program validates your data, derives or defaults additional information and writes an error message for every validation that fails into the PO_INTERFACE_ERRORS table. Scope: public Product: PO Display Name: PO Distributions Interface Category: BUSINESS_ENTITY PO_STANDARD_PURCHASE_ORDER
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PO_DISTRIBUTIONS_INTERFACE_PK |
INTERFACE_DISTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_HEADER_ID | NUMBER | 18 | Interface header unique identifier | ||
| PJC_FUNDING_SOURCE | VARCHAR2 | 360 | Funding Source : Grants Attribute | ||
| PJC_CONTRACT_NUMBER | VARCHAR2 | 120 | Project contract number : Grants attribute | ||
| LOAD_REQUEST_ID | NUMBER | 18 | LOAD_REQUEST_ID | ||
| PJC_WORK_TYPE | VARCHAR2 | 240 | PJC_WORK_TYPE | ||
| INTERFACE_DISTRIBUTION_KEY | VARCHAR2 | 50 | Distribution record identifier, unique within L OAD_REQUEST_ID. Reserved for data uploaded through cloud interface only. | ||
| INTERFACE_LINE_LOCATION_KEY | VARCHAR2 | 50 | Schedule record identifier, unique within LOAD_ REQUEST_ID. Reserved for data uploaded through cloud interface only. | ||
| INTERFACE_LINE_ID | NUMBER | 18 | Interface line unique identifier | ||
| INTERFACE_DISTRIBUTION_ID | NUMBER | 18 | Yes | Interface distribution unique identifier | |
| PO_HEADER_ID | NUMBER | 18 | Document header unique identifier | ||
| PO_LINE_ID | NUMBER | 18 | Document line unique identifier | ||
| LINE_LOCATION_ID | NUMBER | 18 | Document shipment unique identifier | ||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Document distribution unique identifier | ||
| DISTRIBUTION_NUM | NUMBER | Document distribution number | |||
| SOURCE_DISTRIBUTION_ID | NUMBER | 18 | Unique identifier of the planned purchase order distribution that was referenced when creating this scheduled release distribution | ||
| SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | ||
| QUANTITY_ORDERED | NUMBER | Quantity ordered on the distribution | |||
| 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 | |||
| RATE_DATE | DATE | Currency conversion date | |||
| RATE | NUMBER | Currency conversion rate | |||
| DELIVER_TO_LOCATION | VARCHAR2 | 60 | Delivery location code | ||
| DELIVER_TO_LOCATION_ID | NUMBER | 18 | Delivery location unique identifier | ||
| DELIVER_TO_PERSON_FULL_NAME | VARCHAR2 | 2000 | Deliver-to person name | ||
| DELIVER_TO_PERSON_ID | NUMBER | 18 | Deliver-to person unique identifier | ||
| DESTINATION_TYPE | VARCHAR2 | 25 | Final destination name of the purchased item | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Final destination code for the purchased item | ||
| DESTINATION_ORGANIZATION | VARCHAR2 | 240 | Final destination organization | ||
| DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Final destination organization unique identifier | ||
| DESTINATION_SUBINVENTORY | VARCHAR2 | 10 | Final destination subinventory for inventory purchases | ||
| DESTINATION_CONTEXT | VARCHAR2 | 30 | Destination details protected descriptive flexfield context column | ||
| SET_OF_BOOKS | VARCHAR2 | 30 | Set of Books | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Set of Books unique identifier | ||
| CHARGE_ACCOUNT | VARCHAR2 | 2000 | General Ledger charge account | ||
| CHARGE_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger charge account | ||
| BUDGET_ACCOUNT | VARCHAR2 | 2000 | General Ledger budget account | ||
| BUDGET_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger budget account | ||
| ACCURAL_ACCOUNT | VARCHAR2 | 2000 | General Ledger accrual account | ||
| ACCRUAL_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger accrual account | ||
| VARIANCE_ACCOUNT | VARCHAR2 | 2000 | General Ledger variance account | ||
| VARIANCE_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger variance account | ||
| AMOUNT_BILLED | NUMBER | Amount invoiced against distribution by Oracle Payables | |||
| ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether the items are accrued upon receipt | ||
| ACCRUED_FLAG | VARCHAR2 | 1 | Indicates whether distribution was accrued | ||
| PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | 1 | Indicates whether distribution should be encumbered | ||
| 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 | VARCHAR2 | 25 | Type of budgetary control approval failure | ||
| 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 | |||
| GL_CLOSED_DATE | DATE | Date the distribution was final-closed | |||
| REQ_HEADER_REFERENCE_NUM | VARCHAR2 | 25 | Requisition number of the requisition line placed on this distribution | ||
| REQ_LINE_REFERENCE_NUM | VARCHAR2 | 25 | Paper requisition line number | ||
| REQ_DISTRIBUTION_ID | NUMBER | 18 | Requisition line number of the requisition line placed on this distribution | ||
| WIP_ENTITY | VARCHAR2 | 240 | WIP job or repetitive assembly | ||
| 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 | VARCHAR2 | 240 | WIP repetitive schedule | ||
| WIP_REPETITIVE_SCHEDULE_ID | NUMBER | 18 | WIP repetitive schedule identifier | ||
| WIP_LINE_CODE | VARCHAR2 | 10 | WIP line | ||
| WIP_LINE_ID | NUMBER | 18 | WIP line identifier | ||
| BOM_RESOURCE_CODE | VARCHAR2 | 10 | BOM resource code | ||
| BOM_RESOURCE_ID | NUMBER | 18 | BOM resource identifier | ||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | ||
| PROJECT | VARCHAR2 | 240 | Project accounting project | ||
| TASK | VARCHAR2 | 100 | Project accounting task | ||
| EXPENDITURE | VARCHAR2 | 240 | Project accounting expenditure | ||
| EXPENDITURE_ORGANIZATION | VARCHAR2 | 240 | Project accounting expenditure organization | ||
| 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. | |||
| 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. | |
| 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. | |
| 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 | PROGRAM_NAME | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | PROGRAM_APP_NAME | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | Project Manufacturing end item unit number | ||
| 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 | ||
| AWARD_ID | NUMBER | 18 | award id | ||
| CHARGE_ACCOUNT_SEGMENT1 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT2 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT3 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT4 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT5 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT6 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT7 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT8 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT9 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT10 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT11 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT12 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT13 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT14 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT15 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT16 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT17 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT18 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT19 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT20 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT21 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT22 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT23 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT24 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT25 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT26 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT27 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT28 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT29 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| CHARGE_ACCOUNT_SEGMENT30 | VARCHAR2 | 25 | Key Flexfield segment column | ||
| OKE_CONTRACT_LINE_ID | NUMBER | 18 | Oracle Project Contracts unique line identifier | ||
| OKE_CONTRACT_LINE_NUM | VARCHAR2 | 150 | Oracle Project Contracts line number | ||
| OKE_CONTRACT_DELIVERABLE_ID | NUMBER | 18 | Oracle Project Contracts unique deliverable identifier | ||
| OKE_CONTRACT_DELIVERABLE_NUM | VARCHAR2 | 150 | Oracle Project Contracts deliverable number | ||
| AWARD_NUMBER | VARCHAR2 | 15 | Number input by user to identify the award | ||
| AMOUNT_ORDERED | NUMBER | Amount ordered on the distributions for service line types | |||
| INVOICE_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Flag to indicate invoice adjustment | ||
| 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. | ||
| INTERFACE_LINE_LOCATION_ID | NUMBER | 18 | Reference to line location interface | ||
| PROCESSING_ID | NUMBER | 18 | Identifier for records to be processed by a certain PDOI run | ||
| PROCESS_CODE | VARCHAR2 | 25 | Processing status | ||
| INTERFACE_DISTRIBUTION_REF | VARCHAR2 | 240 | Interface Distribution Reference | ||
| 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. | |
| REQ_BU_ID | NUMBER | 18 | REQ_BU_ID | ||
| PRC_BU_ID | NUMBER | 18 | PRC_BU_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 future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for project-related functionality | ||
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for 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 | ||
| BUDGET_DATE | DATE | Date used for budgetary control and encumbrance accounting | |||
| DELIVER_TO_PERSON_EMAIL_ADDR | VARCHAR2 | 240 | DELIVER_TO_PERSON_EMAIL_ADDR | ||
| 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 ordered on the distribution in shipping unit of measure. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_DISTRIBUTIONS_INTERFACE | po_line_locations_interface | INTERFACE_LINE_LOCATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_DISTRIBUTIONS_INTERFACE_N1 | Non Unique | Default | INTERFACE_HEADER_ID |
| PO_DISTRIBUTIONS_INTERFACE_N2 | Non Unique | Default | INTERFACE_LINE_ID |
| PO_DISTRIBUTIONS_INTERFACE_N3 | Non Unique | Default | INTERFACE_LINE_LOCATION_ID |
| PO_DISTRIBUTIONS_INTERFACE_N4 | Non Unique | Default | PROCESSING_ID |
| PO_DISTRIBUTIONS_INTERFACE_N6 | Non Unique | Default | DELIVER_TO_CUST_ID |
| PO_DISTRIBUTIONS_INTERFACE_N7 | Non Unique | Default | DELIVER_TO_CUST_CONTACT_ID |
| PO_DISTRIBUTIONS_INTERFACE_U1 | Unique | Default | INTERFACE_DISTRIBUTION_ID |
| PO_DISTRIBUTIONS_INT_N5 | Non Unique | Default | LOAD_REQUEST_ID, INTERFACE_LINE_LOCATION_KEY |