INV_TRANS_ORDER_DIST_INT
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 serves as an interface table to create transfer order distributions.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
INV_TRANS_ORDER_DIST_INT_PK |
INTERFACE_DISTRIBUTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
INTERFACE_DISTRIBUTION_ID | NUMBER | 18 | Yes | Transfer order distribution unique identifier | ||
INTERFACE_LINE_ID | NUMBER | 18 | Yes | Transfer order line unique identifier | ||
DISTRIBUTION_NUMBER | NUMBER | 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. | ||||
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. | Obsolete | ||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | |||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | ||||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | |||
LAST_UPDATE_DATE | TIMESTAMP | 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. | |||
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 | The context of the project cost collection flexfield. | |||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield. | |||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield. | |||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield | |||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield | |||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield | |||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield | |||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield | |||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield | |||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield | |||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future use in the project cost collection flexfield | |||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | User-defined segment of the project cost collection flexfield. | |||
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_TRANS_ORDER_DIST_INT | inv_transfer_orders_int | INTERFACE_LINE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
INV_TRANS_ORDER_DIST_INT_U1 | Unique | Default | INTERFACE_DISTRIBUTION_ID |
INV_TRANS_ORDER_DIST_INT_U2 | Unique | Default | INTERFACE_LINE_ID, INTERFACE_DISTRIBUTION_ID |