INV_TRANSFER_ORDER_DISTRIBS
A transfer orders serves as the orchestration document representing demand and supply for an internal material transfer. Automated or manual transfer requests of materials within and between two organizations within the same instance are supported via transfer orders. Transfer order object has header, line and distributions. This is the Transfer Order line distributions table.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_TRANSFER_ORDER_DISTRIBS_PK |
DISTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| DISTRIBUTION_ID | NUMBER | 18 | Yes | Transfer order distribution unique identifier | ||
| LINE_ID | NUMBER | 18 | Yes | Transfer order line unique identifier | ||
| DISTRIBUTION_NUMBER | NUMBER | Yes | Transfer order distribution number | |||
| PRIMARY_LEDGER_ID | NUMBER | 18 | Primary Ledger unique identifier for the charge account | |||
| CODE_COMBINATION_ID | NUMBER | 18 | Unique identifier for the General Ledger charge account | |||
| ACCOUNT_USER_OVERRIDE_FLAG | VARCHAR2 | 1 | Determine if the account is overridden by user | Obsolete | ||
| DISTRIBUTION_QTY | NUMBER | This is quantity for the distribution. | ||||
| DELIVERED_QTY | NUMBER | Quantity delivered on this distribution | ||||
| PERCENT | NUMBER | This is the allocation split value. | ||||
| DISTRIBUTION_AMOUNT | NUMBER | Amount on the transfer order line | ||||
| DISTRIBUTION_CURRENCY_AMOUNT | NUMBER | Foreign Currency Amount on the transfer order distribution | ||||
| RECOVERABLE_TAX | NUMBER | This is the amount of recoverable tax. | ||||
| NONRECOVERABLE_TAX | NUMBER | This is the amount of non-recoverable tax. | ||||
| ACCRUAL_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger accrual account | Obsolete | ||
| VARIANCE_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger variance account | Obsolete | ||
| REQ_BU_ID | NUMBER | 18 | Business Unit for requesting organization | |||
| STATUS | VARCHAR2 | 30 | Indicate whether distribution is newly created. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| 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. | ||
| 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 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 work 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 | Specified the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed | |||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection | |||
| 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 | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR20 | 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_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. | ||||
| PROPOSED_CODE_COMBINATION_ID | NUMBER | 18 | This column is not currently used. | |||
| PROPOSED_DISTRIBUTION_QTY | NUMBER | This is the proposed distribution quantity. | ||||
| PROPOSED_PERCENT | NUMBER | This column is the proposed percent. | ||||
| PROPOSED_DISTRIBUTION_AMOUNT | NUMBER | This is the proposed distribution account. | ||||
| PJCPROP_CONTEXT_CATEGORY | VARCHAR2 | 40 | This column is not currently used. | |||
| PJCPROP_PROJECT_ID | NUMBER | 18 | This column is not currently used. | |||
| PJCPROP_TASK_ID | NUMBER | 18 | This column is not currently used. | |||
| PJCPROP_EXPENDITURE_TYPE_ID | NUMBER | 18 | This column is not currently used. | |||
| PJCPROP_EXPENDITURE_ITEM_DATE | DATE | This column is not currently used. | ||||
| PJCPROP_ORGANIZATION_ID | NUMBER | 18 | This column is not currently used. | |||
| PJCPROP_BILLABLE_FLAG | VARCHAR2 | 1 | This column is not currently used. | |||
| PJCPROP_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | This column is not currently used. | |||
| PJCPROP_WORK_TYPE_ID | NUMBER | 18 | This column is not currently used. | |||
| PJCPROP_CONTRACT_ID | NUMBER | 18 | This column is not currently used. | |||
| PJCPROP_CONTRACT_LINE_ID | NUMBER | 18 | This column is not currently used. | |||
| PJCPROP_FUNDING_ALLOCATION_ID | NUMBER | 18 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | This column is not currently used. | |||
| PJCPROP_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | This column is not currently used. | |||
| IS_PROPOSED_PENDING | VARCHAR2 | 1 | Internal flag to indicate whether proposed fields have ever been used on this distribution. | |||
| APPROVER_ID | NUMBER | 18 | This column is not currently used. | |||
| FUNDS_STATUS | VARCHAR2 | 30 | Budgetary control funds status of the distribution. | |||
| BUDGET_DATE | DATE | Budgetary control budget date of the distribution. | ||||
| REQ_DISTRIBUTION_ID | NUMBER | 18 | The Requisition Distribution ID. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_TRANSFER_ORDER_DISTRIBS | inv_transfer_order_lines | LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_TRANSFER_ORDER_DISTRIBS_N1 | Non Unique | Default | PJC_PROJECT_ID |
| INV_TRANSFER_ORDER_DISTRIBS_N2 | Non Unique | Default | PJC_TASK_ID |
| INV_TRANSFER_ORDER_DISTRIBS_U1 | Unique | Default | DISTRIBUTION_ID |
| INV_TRANSFER_ORDER_DISTRIBS_U2 | Unique | Default | LINE_ID, DISTRIBUTION_NUMBER |