INV_TRANS_ORDER_TRANSPRICE_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 is an interface table to store the transfer price and tax determinants for Kit component items.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
inv_trans_order_transprice_PK |
SOURCE_HEADER_ID, SOURCE_LINE_ID, COMPONENT_SEQUENCE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_HEADER_ID | NUMBER | 18 | Transfer Order Interface Batch Identifier | ||
INTERFACE_LINE_ID | NUMBER | 18 | Transfer Order Interface Batch Identifier | ||
SOURCE_HEADER_ID | NUMBER | 18 | Yes | Reference back to supply header id | |
SOURCE_LINE_ID | NUMBER | 18 | Yes | Reference back to supply line id | |
SOURCE_ORGANIZATION_ID | NUMBER | 18 | Reference to the unique identifier for the source organization. | ||
DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Reference to the unique identifier for the destination organization. | ||
DESTINATION_TYPE_LOOKUP | VARCHAR2 | 30 | Destination type, whether Inventory or Expense | ||
DESTINATION_LOCATION_ID | NUMBER | 18 | Destination location (from hr_locations) | ||
KIT_ITEM_ID | NUMBER | 18 | This identifies the kit inventory item | ||
COMPONENT_ITEM_ID | NUMBER | 18 | This identifies the component inventory item. | ||
COMPONENT_SEQUENCE_ID | NUMBER | 18 | Yes | Sequence id of the Component Item. This is the ID column of the table EGP_COMPONENTS_B | |
SECONDARY_QTY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure of line quantity | ||
SECONDARY_REQUESTED_QTY | NUMBER | Quantity requested in secondary unit of measure | |||
UNIT_PRICE | NUMBER | Price per unit of item requested | |||
UNIT_TAX | NUMBER | This is tax per unit of item requested. | |||
INCL_NONRECOVERABLE_TAX | NUMBER | Included Unit Non-Recoverable Tax | |||
INCL_RECOVERABLE_TAX | NUMBER | This is the included unit recoverable tax. | |||
NONINCL_NONRECOVERABLE_TAX | NUMBER | Non-included Unit Non-Recoverable Tax | |||
NONINCL_RECOVERABLE_TAX | NUMBER | Non-included Unit Recoverable Tax | |||
CURRENCY_CODE | VARCHAR2 | 15 | Currency code. This is the Requesting Org's default currency, value supplied by SCO | ||
BUY_DEFAULT_TAX_COUNTRY | VARCHAR2 | 2 | Default taxation country code to buy. | ||
BUY_FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration ID for the transaction | ||
BUY_THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration ID for the transaction | ||
BUY_FINAL_DISCHARGE_LOC_ID | NUMBER | 18 | The final discharge location identifier | ||
BUY_DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Document Fiscal Classification code | ||
BUY_TAX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category code | ||
BUY_USR_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification code | ||
BUY_PRODUCT_FISC_CLASSIF | VARCHAR2 | 240 | Product fiscal classification code of the inventory item | ||
BUY_PRODUCT_CATEGORY | VARCHAR2 | 240 | Product category code of the transaction line | ||
BUY_INTEND_USE_CLASSIF_ID | NUMBER | 18 | Intended Use Classification Identifier | ||
BUY_PRODUCT_TYPE | VARCHAR2 | 240 | Product type code of the inventory item. Possible values are GOODS and SERVICES | ||
BUY_ASSESSABLE_VALUE | NUMBER | Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | |||
BUY_TAX_CLASSIF_CODE | VARCHAR2 | 50 | Tax classification code to buy. | ||
SELL_DEFAULT_TAX_COUNTRY | VARCHAR2 | 2 | This is the default taxation country code. | ||
SELL_FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration ID for the transaction | ||
SELL_THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration ID for the transaction | ||
SELL_FINAL_DISCHARGE_LOC_ID | NUMBER | 18 | The final discharge location identifier | ||
SELL_DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Document Fiscal Classification code | ||
SELL_TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category code | ||
SELL_USR_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification code | ||
SELL_PRODUCT_FISC_CLASSIF | VARCHAR2 | 240 | Product fiscal classification code of the inventory item | ||
SELL_PRODUCT_CATEGORY | VARCHAR2 | 240 | Product category code of the transaction line | ||
SELL_INTEND_USE_CLASSIF_ID | NUMBER | 18 | Intended Use Classification Identifier | ||
SELL_PRODUCT_TYPE | VARCHAR2 | 240 | Product type code of the inventory item. Possible values are GOODS and SERVICES | ||
SELL_ASSESSABLE_VALUE | NUMBER | Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | |||
SELL_TAX_CLASSIF_CODE | VARCHAR2 | 50 | This is the tax classification code. | ||
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. | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
inv_trans_order_transprice_N1 | Non Unique | FUSION_TS_TX_IDX | SOURCE_HEADER_ID, SOURCE_LINE_ID, KIT_ITEM_ID, COMPONENT_ITEM_ID |
inv_trans_order_transprice_U1 | Unique | FUSION_TS_TX_IDX | SOURCE_HEADER_ID, SOURCE_LINE_ID, COMPONENT_SEQUENCE_ID |