This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | This table stores all amounts of a Shipment, prorated into its Shipment Lines. |
---|
This table stores all amounts of a Shipment, prorated into its Shipment Lines.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_ALLOCATIONS_U1 | UNIQUE | APPS_TS_TX_IDX | ALLOCATION_ID |
INL_ALLOCATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SHIP_HEADER_ID
ADJUSTMENT_NUM |
INL_ALLOCATIONS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
FROM_PARENT_TABLE_ID
FROM_PARENT_TABLE_NAME |
INL_ALLOCATIONS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
TO_PARENT_TABLE_ID
TO_PARENT_TABLE_NAME |
INL_ALLOCATIONS_N4 | NONUNIQUE | APPS_TS_TX_IDX | ASSOCIATION_ID |
INL_ALLOCATIONS_N5 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALLOCATION_ID | NUMBER | Y | Allocation Identifier | |
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
ASSOCIATION_ID | NUMBER | Association Identifier | ||
FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES |
FROM_PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID | |
TO_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the amount goes to: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES |
TO_PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the amount goes to: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID | |
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
PARENT_ALLOCATION_ID | NUMBER | Parent Allocation Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
ALLOCATION_AMT | NUMBER | Y | Allocation Amount | |
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_ALLOCATIONS does not reference any database object
INL.INL_ALLOCATIONS is referenced by following:
Description: | This table stores Shipment Line Types that are allowed either for Shiment Types. |
---|
This table stores Shipment Line Types for Shipment Types.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_ALWD_LINE_TYPES_U1 | UNIQUE | APPS_TS_TX_IDX | ALWD_LINE_TYPE_ID |
INL_ALWD_LINE_TYPES_N1 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_LINE_TYPE_ID |
INL_ALWD_LINE_TYPES_N2 | NONUNIQUE | APPS_TS_TX_IDX |
PARENT_TABLE_ID
PARENT_TABLE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALWD_LINE_TYPE_ID | NUMBER | Y | Allowed Line Type Identifier | |
PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the Line Type refers to: INL_SHIP_TYPES. |
PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the Line Type refers to: SHIP_TYPE_ID. | |
SHIP_LINE_TYPE_ID | NUMBER | Y | Shipment Line Type Identifier | |
DFLT_SHIP_LINE_TYPE_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the Shipment Line Type is default |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_ALWD_LINE_TYPES does not reference any database object
INL.INL_ALWD_LINE_TYPES is referenced by following:
Description: | This table stores Party Types that are allowed for a Shipment Type. |
---|
This table stores Party Types that are allowed for a Shipment Type.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_ALWD_PARTY_TYPES_U1 | UNIQUE | APPS_TS_TX_IDX | ALWD_PARTY_TYPE_ID |
INL_ALWD_PARTY_TYPES_U2 | UNIQUE | APPS_TS_TX_IDX |
PARENT_TABLE_NAME
PARENT_TABLE_ID PARTY_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALWD_PARTY_TYPE_ID | NUMBER | Y | Allowed Party Type Identifier | |
PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the Party Type refers to: INL_SHIP_TYPES. |
PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the Party Type refers to: SHIP_TYPE_ID. | |
PARTY_TYPE_CODE | VARCHAR2 | (30) | Y | Party Site Code |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_ALWD_PARTY_TYPES does not reference any database object
INL.INL_ALWD_PARTY_TYPES is referenced by following:
Description: | This table stores Party Usages that are allowed for a Shipment Type. |
---|
This table stores Party Usages that are allowed for a Shipment Type.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_ALWD_PARTY_USAGES_U1 | UNIQUE | APPS_TS_TX_IDX | ALWD_PARTY_USAGE_ID |
INL_ALWD_PARTY_USAGES_U2 | UNIQUE | APPS_TS_TX_IDX |
PARENT_TABLE_NAME
PARENT_TABLE_ID PARTY_USAGE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALWD_PARTY_USAGE_ID | NUMBER | Y | Allowed Party Usage Identifier | |
PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the Party Usage refers to: INL_SHIP_TYPES. |
PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the Party Usage refers to: SHIP_TYPE_ID. | |
PARTY_USAGE_CODE | VARCHAR2 | (30) | Y | Third Party Type Code |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_ALWD_PARTY_USAGES does not reference any database object
INL.INL_ALWD_PARTY_USAGES is referenced by following:
Description: | This table stores Source Types that are allowed for a Shipment Type. |
---|
This table stores Source Types that are allowed for a Shipment Type.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_ALWD_SOURCE_TYPES_U1 | UNIQUE | APPS_TS_TX_IDX | ALWD_SOURCE_TYPE_ID |
INL_ALWD_SOURCE_TYPES_U2 | UNIQUE | APPS_TS_TX_IDX |
SHIP_TYPE_ID
SHIP_LINE_SRC_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALWD_SOURCE_TYPE_ID | NUMBER | Y | Allowed Source Type Identifier | |
SHIP_TYPE_ID | NUMBER | Y | Shipment Type Identifier | |
SHIP_LINE_SRC_TYPE_CODE | VARCHAR2 | (30) | Y | Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES |
DFLT_SOURCE_TYPE_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the Source Type Code is default | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_ALWD_SOURCE_TYPES does not reference any database object
INL.INL_ALWD_SOURCE_TYPES is referenced by following:
Description: | This table stores associations between landed cost components of the same or different Shipments. |
---|
This table stores associations between landed cost components of the same or different Shipments.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_ASSOCIATIONS_U1 | UNIQUE | APPS_TS_TX_IDX | ASSOCIATION_ID |
INL_ASSOCIATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_HEADER_ID |
INL_ASSOCIATIONS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
FROM_PARENT_TABLE_ID
FROM_PARENT_TABLE_NAME |
INL_ASSOCIATIONS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
TO_PARENT_TABLE_ID
TO_PARENT_TABLE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSOCIATION_ID | NUMBER | Y | Association Identifier | |
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES |
FROM_PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID | |
TO_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the amount goes to: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES |
TO_PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the amount goes to: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID | |
ALLOCATION_BASIS | VARCHAR2 | (30) | Y | Criteria through which an associated amount will be distributed into two or more components of a shipment |
ALLOCATION_UOM_CODE | VARCHAR2 | (3) | Unit of measure through which the associated amount will be distributed into two or more components of a shipment | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_ASSOCIATIONS does not reference any database object
INL.INL_ASSOCIATIONS is referenced by following:
Description: | This table stores information on charges associated to Shipment components. |
---|
This table stores information on charges associated to Shipment components.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_CHARGE_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | CHARGE_LINE_ID |
INL_CHARGE_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX | CHARGE_LINE_TYPE_ID |
INL_CHARGE_LINES_N3 | NONUNIQUE | APPS_TS_TX_IDX | PARTY_ID |
INL_CHARGE_LINES_N4 | NONUNIQUE | APPS_TS_TX_IDX | PARTY_SITE_ID |
INL_CHARGE_LINES_N5 | NONUNIQUE | APPS_TS_TX_IDX | PARENT_CHARGE_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHARGE_LINE_ID | NUMBER | Y | Charge Line Identifier | |
CHARGE_LINE_NUM | NUMBER | Y | Charge Line Number | |
CHARGE_LINE_TYPE_ID | NUMBER | Y | Charge Line Type Identifier | |
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
UPDATE_ALLOWED | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the charge can be updated | |
SOURCE_CODE | VARCHAR2 | (25) | Source Application Code the charge is being created from | |
PARENT_CHARGE_LINE_ID | NUMBER | Parent Charge Line Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
MATCH_ID | NUMBER | Match Identifier | ||
MATCH_AMOUNT_ID | NUMBER | Match Amount Identifier | ||
CHARGE_AMT | NUMBER | Y | Charge Ammount | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Categorization of a transaction for tax purposes | |
INTENDED_USE | VARCHAR2 | (30) | Purpose for which a product may be used | |
PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | Classification of the product(s) by tax authority for tax purposes | |
PRODUCT_CATEGORY | VARCHAR2 | (240) | Used to classify products for tax purposes | |
PRODUCT_TYPE | VARCHAR2 | (240) | Product related classification for tax purposes | |
USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classifiction | |
TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax Classification Code | |
ASSESSABLE_VALUE | NUMBER | EBTAX Assessable Value | ||
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the taxes have already been calculated | |
SHIP_FROM_PARTY_ID | NUMBER | Ship From Party Identifier | ||
SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship From Party Site Identifier | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship To Organization Identifier | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
BILL_FROM_PARTY_ID | NUMBER | Bill From Party Identifier | ||
BILL_FROM_PARTY_SITE_ID | NUMBER | Bill From Party Site Identifier | ||
BILL_TO_ORGANIZATION_ID | NUMBER | Bill To Organization Identifier | ||
BILL_TO_LOCATION_ID | NUMBER | Bill To Location Identifier | ||
POA_PARTY_ID | NUMBER | Point of Order Acceptance Party Identifier | ||
POA_PARTY_SITE_ID | NUMBER | Point of Order Acceptance Party Site Identifier | ||
POO_ORGANIZATION_ID | NUMBER | Point of Order Origin Organization Identifier | ||
POO_LOCATION_ID | NUMBER | Point of Order Origin Location Identifier | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_CHARGE_LINES does not reference any database object
INL.INL_CHARGE_LINES is referenced by following:
Description: | This table stores information on errors occurred during LCM Open Interface Processor. |
---|
This table stores information on errors occurred during LCM Open Interface Processor.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_ERROR_ID | NUMBER | Y | Interface Error Identififer | |
PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the error refers to: INL_SHIP_HEADERS_INT, INL_SHIP_LINES_INT, INL_MATCHES_INT, INL_MATCH_AMOUNTS_INT |
PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the error refers to: SHIP_HEADER_INT_ID, SHIP_LINE_INT_ID, MATCH_INT_ID, MATCH_AMOUNT_INT_ID | |
COLUMN_NAME | VARCHAR2 | (30) | Column Name | |
COLUMN_VALUE | VARCHAR2 | (4000) | Column Value | |
PROCESSING_DATE | DATE | Processing Date | ||
ERROR_MESSAGE_NAME | VARCHAR2 | (30) | Error Message Name | |
ERROR_MESSAGE | VARCHAR2 | (2000) | Error Message | |
TOKEN1_NAME | VARCHAR2 | (100) | 1st token name of the message | |
TOKEN1_VALUE | VARCHAR2 | (200) | 1st token value of the message | |
TOKEN2_NAME | VARCHAR2 | (100) | 2nd token name of the message | |
TOKEN2_VALUE | VARCHAR2 | (200) | 2nd token value of the message | |
TOKEN3_NAME | VARCHAR2 | (100) | 3rd token name of the message | |
TOKEN3_VALUE | VARCHAR2 | (200) | 3rd token value of the message | |
TOKEN4_NAME | VARCHAR2 | (100) | 4th token name of the message | |
TOKEN4_VALUE | VARCHAR2 | (200) | 4th token value of the message | |
TOKEN5_NAME | VARCHAR2 | (100) | 5th token name of the message | |
TOKEN5_VALUE | VARCHAR2 | (200) | 5th token value of the message | |
TOKEN6_NAME | VARCHAR2 | (100) | 6th token name of the message | |
TOKEN6_VALUE | VARCHAR2 | (200) | 6th token value of the message | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
INL.INL_INTERFACE_ERRORS does not reference any database object
INL.INL_INTERFACE_ERRORS is referenced by following:
Description: | This table stores matches between actual and estimated amounts of a Landed Cost Shipment. |
---|
This table stores actual amounts and the shipment components they refer to, to be used in actual landed cost calculation.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_MATCHES_U1 | UNIQUE | APPS_TS_TX_IDX | MATCH_ID |
INL_MATCHES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
FROM_PARENT_TABLE_NAME
FROM_PARENT_TABLE_ID |
INL_MATCHES_N2 | NONUNIQUE | APPS_TS_TX_IDX | MATCH_AMOUNT_ID |
INL_MATCHES_N3 | NONUNIQUE | APPS_TS_TX_IDX |
TO_PARENT_TABLE_NAME
TO_PARENT_TABLE_ID |
INL_MATCHES_N4 | NONUNIQUE | APPS_TS_TX_IDX |
FROM_PARENT_TABLE_NAME
FROM_PARENT_TABLE_ID TO_PARENT_TABLE_NAME TO_PARENT_TABLE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATCH_ID | NUMBER | Y | Match Identifier | |
MATCH_TYPE_CODE | VARCHAR2 | (30) | Y | Match Type Code |
SHIP_HEADER_ID | NUMBER | Shipment Identifier | ||
FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Identifier of the table line the match comes from. | |
FROM_PARENT_TABLE_ID | NUMBER | Identifier of the table line the match comes from. | ||
TO_PARENT_TABLE_NAME | VARCHAR2 | (30) | Name of the table the match goes to: INL_SHIP_LINES | |
TO_PARENT_TABLE_ID | NUMBER | Identifier of the table line the match goes to: SHIP_LINE_ID | ||
PARENT_MATCH_ID | NUMBER | Parent Match Identifier | ||
MATCHED_QTY | NUMBER | Matched Quantity | ||
MATCHED_UOM_CODE | VARCHAR2 | (3) | Matched Unit of Measure Code | |
MATCHED_AMT | NUMBER | Matched Amount | ||
MATCHED_CURR_CODE | VARCHAR2 | (15) | Matched Currency Code | |
MATCHED_CURR_CONVERSION_TYPE | VARCHAR2 | (30) | Match Currency Conversion Type | |
MATCHED_CURR_CONVERSION_DATE | DATE | Match Currency Conversion Date | ||
MATCHED_CURR_CONVERSION_RATE | NUMBER | Match Currency Conversion Rate | ||
ADJ_ALREADY_GENERATED_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the match has already generated adjustments |
REPLACE_ESTIM_QTY_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts. |
EXISTING_MATCH_INFO_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the match corresponds to data already matched (match update) |
CHARGE_LINE_TYPE_ID | NUMBER | Charge Line Type Identifier | ||
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
TAX_CODE | VARCHAR2 | (30) | Tax Code | |
NREC_TAX_AMT | NUMBER | Non Recoverable Tax Amount | ||
TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the tax is included to the unit price. | |
MATCH_AMOUNT_ID | NUMBER | Match Amount Identifier | ||
MATCH_INT_ID | NUMBER | Match Interface Identifier | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_MATCHES does not reference any database object
INL.INL_MATCHES is referenced by following:
Description: | This table stores Open Interface data for matches between actual and estimated amounts of a Landed Cost Shipment. |
---|
This table stores Open Interface data for Matches.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_MATCHES_INT_U1 | UNIQUE | APPS_TS_TX_IDX | MATCH_INT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATCH_INT_ID | NUMBER | Y | Match Interface Identifier | |
GROUP_ID | NUMBER | Y | Open Interface Group Identifier | |
PROCESSING_STATUS_CODE | VARCHAR2 | (25) | Y | Processing Status Code |
TRANSACTION_TYPE | VARCHAR2 | (25) | Y | Open Interface Transaction Type |
MATCH_TYPE_CODE | VARCHAR2 | (30) | Y | Match Type Code |
FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Identifier of the table line the match comes from | |
FROM_PARENT_TABLE_ID | NUMBER | Identifier of the table line the match comes from | ||
TO_PARENT_TABLE_NAME | VARCHAR2 | (30) | Name of the table the match goes to: INL_SHIP_LINES | |
TO_PARENT_TABLE_ID | NUMBER | Identifier of the table line the match goes to: SHIP_LINE_ID | ||
MATCHED_QTY | NUMBER | Matched Quantity | ||
MATCHED_UOM_CODE | VARCHAR2 | (3) | Matched Unit of Measure Code | |
MATCHED_AMT | NUMBER | Matched Amount | ||
MATCHED_CURR_CODE | VARCHAR2 | (15) | Matched Currency Code | |
MATCHED_CURR_CONVERSION_TYPE | VARCHAR2 | (30) | Match Currency Conversion Type | |
MATCHED_CURR_CONVERSION_DATE | DATE | Match Currency Conversion Date | ||
MATCHED_CURR_CONVERSION_RATE | NUMBER | Match Currency Conversion Rate | ||
REPLACE_ESTIM_QTY_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts. |
CHARGE_LINE_TYPE_ID | NUMBER | Charge Line Type Identifier | ||
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_NUMBER | VARCHAR2 | (30) | Party Number | |
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
PARTY_SITE_NUMBER | VARCHAR2 | (30) | Party Site Number | |
TAX_CODE | VARCHAR2 | (30) | Tax Code | |
NREC_TAX_AMT | NUMBER | Non Recoverable Tax Amount | ||
TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts. | |
MATCH_AMOUNT_INT_ID | NUMBER | Match Amount Interface Identifier | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). |
INL.INL_MATCHES_INT does not reference any database object
INL.INL_MATCHES_INT is referenced by following:
Description: | This table stores matches between actual and estimated charge amounts of a Landed Cost Shipment, grouped by Charge Line Type. |
---|
This table stores actual charge amounts, grouped by cost factor, and the shipment components they refer to, to be used as actual charges, in actual landed cost calculation.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_MATCH_AMOUNTS_U1 | UNIQUE | APPS_TS_TX_IDX | MATCH_AMOUNT_ID |
INL_MATCH_AMOUNTS_N1 | NONUNIQUE | APPS_TS_TX_IDX | MATCH_AMOUNT_INT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATCH_AMOUNT_ID | NUMBER | Y | Match Amount Identifier | |
MATCHED_AMT | NUMBER | Y | Matched Amount | |
MATCHED_CURR_CODE | VARCHAR2 | (15) | Y | Matched Currency Code |
MATCHED_CURR_CONVERSION_TYPE | VARCHAR2 | (30) | Match Currency Conversion Type | |
MATCHED_CURR_CONVERSION_DATE | DATE | Match Currency Conversion Date | ||
MATCHED_CURR_CONVERSION_RATE | NUMBER | Match Currency Conversion Rate | ||
MATCH_AMOUNT_INT_ID | NUMBER | Match Amount Interface Identifier | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_MATCH_AMOUNTS does not reference any database object
INL.INL_MATCH_AMOUNTS is referenced by following:
Description: | This table stores Open Interface data for matches between actual and estimated charge amounts of a Landed Cost Shipment, grouped by Charge Line Type. |
---|
This table stores Open Interface data for Match Amounts.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_MATCH_AMOUNTS_INT_U1 | UNIQUE | APPS_TS_TX_IDX | MATCH_AMOUNT_INT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATCH_AMOUNT_INT_ID | NUMBER | Y | Match Amount Interface Identifier | |
GROUP_ID | NUMBER | Y | Open Interface Group Identifier | |
PROCESSING_STATUS_CODE | VARCHAR2 | (25) | Y | Processing Status Code |
TRANSACTION_TYPE | VARCHAR2 | (25) | Y | Open Interface Transaction Type |
MATCHED_AMT | NUMBER | Y | Matched Amount | |
MATCHED_CURR_CODE | VARCHAR2 | (15) | Y | Matched Currency Code |
MATCHED_CURR_CONVERSION_TYPE | VARCHAR2 | (30) | Match Currency Conversion Type | |
MATCHED_CURR_CONVERSION_DATE | DATE | Match Currency Conversion Date | ||
MATCHED_CURR_CONVERSION_RATE | NUMBER | Match Currency Conversion Rate | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_MATCH_AMOUNTS_INT does not reference any database object
INL.INL_MATCH_AMOUNTS_INT is referenced by following:
Description: | This table stores the general LCM setup options by Inventory Organization. |
---|
This table stores the general LCM setup options by Inventory Organization.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_PARAMETERS_U1 | UNIQUE | APPS_TS_TX_IDX | ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Y | Inventory Organization Identifier | |
USER_DEFINED_SHIP_NUM_CODE | VARCHAR2 | (25) | Lookup to determine when Shipment Number is filled manually or automatically | |
MANUAL_SHIP_NUM_TYPE | VARCHAR2 | (25) | Lookup to determine when Shipment Number could have Numeric and Alphanumeric values | |
NEXT_SHIP_NUM | NUMBER | Y | Next Shipment Number | |
PO_PRICE_TOLER_PERC | NUMBER | Tolerance Percentual against PO Price | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
INL.INL_PARAMETERS does not reference any database object
INL.INL_PARAMETERS is referenced by following:
Description: | This table stores header information on Shipments. |
---|
This table stores header information on Shipments.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_HEADERS_ALL_U1 | UNIQUE | APPS_TS_TX_IDX | SHIP_HEADER_ID |
INL_SHIP_HEADERS_ALL_U2 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SHIP_NUM |
INL_SHIP_HEADERS_ALL_N1 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_TYPE_ID |
INL_SHIP_HEADERS_ALL_N2 | NONUNIQUE | APPS_TS_TX_IDX | LEGAL_ENTITY_ID |
INL_SHIP_HEADERS_ALL_N3 | NONUNIQUE | APPS_TS_TX_IDX | LOCATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
SHIP_NUM | VARCHAR2 | (25) | Y | Shipment Number |
SHIP_DATE | DATE | Y | Shipment Date | |
SHIP_TYPE_ID | NUMBER | Y | Shipment Type Identifier | |
SHIP_STATUS_CODE | VARCHAR2 | (30) | Y | Shipment Status, taken from lookup INL_SHIP_STATUSES |
PENDING_MATCHING_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating the existence of lines matched but not absorbed by the landed cost calculation | |
LEGAL_ENTITY_ID | NUMBER | Y | Legal Entity Identifier | |
ORGANIZATION_ID | NUMBER | Y | Inventory Organization Identifier | |
LOCATION_ID | NUMBER | Location Identifier | ||
ORG_ID | NUMBER | Y | Organization identifier | |
TAXATION_COUNTRY | VARCHAR2 | (30) | Y | Specifies the country for taxation for tax calculation purposes |
DOCUMENT_SUB_TYPE | VARCHAR2 | (150) | EBTAX Header level field | |
SHIP_HEADER_INT_ID | NUMBER | Shipment Interface Identifier | ||
INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | Source of the interface row | |
INTERFACE_SOURCE_TABLE | VARCHAR2 | (30) | Source Table of the interface row | |
INTERFACE_SOURCE_LINE_ID | NUMBER | Source line identifier of the interface row | ||
ADJUSTMENT_NUM | NUMBER | Adjustment Number | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
INL.INL_SHIP_HEADERS_ALL does not reference any database object
INL.INL_SHIP_HEADERS_ALL is referenced by following:
Description: | This table stores Open Interface data for Shipment Headers. |
---|
This table stores Open Interface data for Shipment Headers.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_HEADERS_INT_U1 | UNIQUE | APPS_TS_TX_IDX | SHIP_HEADER_INT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_INT_ID | NUMBER | Y | Shipment Interface Identifier | |
GROUP_ID | NUMBER | Y | Open Interface Group Identifier | |
PROCESSING_STATUS_CODE | VARCHAR2 | (25) | Y | Processing Status Code |
TRANSACTION_TYPE | VARCHAR2 | (25) | Open Interface Transaction Type | |
INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | Y | Source of the interface row |
INTERFACE_SOURCE_TABLE | VARCHAR2 | (30) | Source Table of the interface row | |
INTERFACE_SOURCE_LINE_ID | NUMBER | Source line identifier of the interface row | ||
VALIDATION_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the record should be validated |
SHIP_NUM | VARCHAR2 | (25) | Shipment Number | |
SHIP_DATE | DATE | Y | Shipment Date | |
SHIP_TYPE_ID | NUMBER | Shipment Type Identifier | ||
SHIP_TYPE_CODE | VARCHAR2 | (15) | Shipment Type Code | |
LEGAL_ENTITY_ID | NUMBER | Legal Entity Identifier | ||
LEGAL_ENTITY_NAME | VARCHAR2 | (50) | Legal Entity Name | |
ORGANIZATION_ID | NUMBER | Inventory Organization Identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Inventory Organization Code | |
LOCATION_ID | NUMBER | Location Identifier | ||
LOCATION_CODE | VARCHAR2 | (60) | Location Code | |
ORG_ID | NUMBER | Organization identifier | ||
TAXATION_COUNTRY | VARCHAR2 | (30) | Y | Specifies the country for taxation for tax calculation purposes |
DOCUMENT_SUB_TYPE | VARCHAR2 | (150) | EBTAX Header level field | |
SHIP_HEADER_ID | NUMBER | Shipment Identifier | ||
LAST_TASK_CODE | VARCHAR2 | (25) | Last Task to be executed by the LCM Open Interface Processor | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
INL.INL_SHIP_HEADERS_INT does not reference any database object
INL.INL_SHIP_HEADERS_INT is referenced by following:
Description: | This table stores information on holds occurred during LCM Shipment validation process. |
---|
This table stores information on holds occurred during LCM Shipment validation process.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_HOLDS_U1 | UNIQUE | APPS_TS_TX_IDX | SHIP_HOLD_ID |
INL_SHIP_HOLDS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_HEADER_ID |
INL_SHIP_HOLDS_N2 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HOLD_ID | NUMBER | Y | Shipment Hold Identifier | |
SHIP_HEADER_ID | NUMBER | Shipment Identifier | ||
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
CHARGE_LINE_ID | NUMBER | Charge Line Identifier | ||
TABLE_NAME | VARCHAR2 | (30) | Table Name | |
COLUMN_NAME | VARCHAR2 | (30) | Column Name | |
COLUMN_VALUE | VARCHAR2 | (4000) | Column Value | |
PROCESSING_DATE | DATE | Processing Date | ||
ERROR_MESSAGE | VARCHAR2 | (2000) | Error Message | |
ERROR_MESSAGE_NAME | VARCHAR2 | (30) | Error Message Name | |
TOKEN1_NAME | VARCHAR2 | (100) | 1st token name of the message | |
TOKEN1_VALUE | VARCHAR2 | (200) | 1st token value of the message | |
TOKEN2_NAME | VARCHAR2 | (100) | 2nd token name of the message | |
TOKEN2_VALUE | VARCHAR2 | (200) | 2nd token value of the message | |
TOKEN3_NAME | VARCHAR2 | (100) | 3rd token name of the message | |
TOKEN3_VALUE | VARCHAR2 | (200) | 3rd token value of the message | |
TOKEN4_NAME | VARCHAR2 | (100) | 4th token name of the message | |
TOKEN4_VALUE | VARCHAR2 | (200) | 4th token value of the message | |
TOKEN5_NAME | VARCHAR2 | (100) | 5th token name of the message | |
TOKEN5_VALUE | VARCHAR2 | (200) | 5th token value of the message | |
TOKEN6_NAME | VARCHAR2 | (100) | 6th token name of the message | |
TOKEN6_VALUE | VARCHAR2 | (200) | 6th token value of the message | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
INL.INL_SHIP_HOLDS does not reference any database object
INL.INL_SHIP_HOLDS is referenced by following:
Description: | This table stores information on Shipment Lines. |
---|
This table stores information on Shipment Lines.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_LINES_ALL_U1 | UNIQUE | APPS_TS_TX_IDX | SHIP_LINE_ID |
INL_SHIP_LINES_ALL_N1 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_LINE_GROUP_ID |
INL_SHIP_LINES_ALL_N2 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_LINE_TYPE_ID |
INL_SHIP_LINES_ALL_N3 | NONUNIQUE | APPS_TS_TX_IDX | PARENT_SHIP_LINE_ID |
INL_SHIP_LINES_ALL_N4 | NONUNIQUE | APPS_TS_TX_IDX |
SHIP_HEADER_ID
ADJUSTMENT_NUM |
INL_SHIP_LINES_ALL_N5 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_LINE_SOURCE_ID |
INL_SHIP_LINES_ALL_N6 | NONUNIQUE | APPS_TS_TX_IDX | INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
SHIP_LINE_GROUP_ID | NUMBER | Y | Line Group Identifier | |
SHIP_LINE_ID | NUMBER | Y | Shipment Line Identifier | |
SHIP_LINE_NUM | NUMBER | Y | Shipment Line Number | |
SHIP_LINE_TYPE_ID | NUMBER | Y | Shipment Line Type Identifier | |
SHIP_LINE_SRC_TYPE_CODE | VARCHAR2 | (30) | Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES | |
SHIP_LINE_SOURCE_ID | NUMBER | Source Identifier, according to the Source Type Code | ||
PARENT_SHIP_LINE_ID | NUMBER | Parent Shipment Line Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
MATCH_ID | NUMBER | Match Identifier | ||
CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency Code |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
TXN_QTY | NUMBER | Transaction Quantity | ||
TXN_UOM_CODE | VARCHAR2 | (3) | Transaction Unit of Measure | |
TXN_UNIT_PRICE | NUMBER | Transaction Unit Price | ||
PRIMARY_QTY | NUMBER | Primary Quantity | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure Code | |
PRIMARY_UNIT_PRICE | NUMBER | Primary Unit Price | ||
SECONDARY_QTY | NUMBER | Secondary Quantity | ||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | Secondary Unit of Measure | |
SECONDARY_UNIT_PRICE | NUMBER | Secondary Unit Price | ||
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
ALLOCATION_ENABLED_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amounts of the line are associable |
TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Categorization of a transaction for tax purposes | |
INTENDED_USE | VARCHAR2 | (30) | Purpose for which a product may be used | |
PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | Classification of the product(s) by tax authority for tax purposes | |
PRODUCT_CATEGORY | VARCHAR2 | (240) | Used to classify products for tax purposes | |
PRODUCT_TYPE | VARCHAR2 | (240) | Product related classification for tax purposes | |
USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classifiction | |
TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax Classification Code | |
ASSESSABLE_VALUE | NUMBER | EBTAX Assessable Value | ||
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the taxes have already been calculated | |
SHIP_FROM_PARTY_ID | NUMBER | Ship From Party Identifier | ||
SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship From Party Site Identifier | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship To Organization Identifier | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
BILL_FROM_PARTY_ID | NUMBER | Bill From Party Identifier | ||
BILL_FROM_PARTY_SITE_ID | NUMBER | Bill From Party Site Identifier | ||
BILL_TO_ORGANIZATION_ID | NUMBER | Bill To Organization Identifier | ||
BILL_TO_LOCATION_ID | NUMBER | Bill To Location Identifier | ||
POA_PARTY_ID | NUMBER | Point of Order Acceptance Party Identifier | ||
POA_PARTY_SITE_ID | NUMBER | Point of Order Acceptance Party Site Identifier | ||
POO_ORGANIZATION_ID | NUMBER | Point of Order Origin Organization Identifier | ||
POO_LOCATION_ID | NUMBER | Point of Order Origin Location Identifier | ||
ORG_ID | NUMBER | Y | Organization identifier | |
SHIP_LINE_INT_ID | NUMBER | Shipment Line Interface Identifier | ||
INTERFACE_SOURCE_TABLE | VARCHAR2 | (30) | Source Table of the interface row | |
INTERFACE_SOURCE_LINE_ID | NUMBER | Source line identifier of the interface row | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
INL.INL_SHIP_LINES_ALL does not reference any database object
INL.INL_SHIP_LINES_ALL is referenced by following:
Description: | This table stores Open Interface data for Shipment Line Groups and Shipment Lines. |
---|
This table stores Open Interface data for Shipment Line Groups and Shipment Lines.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_LINES_INT_U1 | UNIQUE | APPS_TS_TX_IDX | SHIP_LINE_INT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_INT_ID | NUMBER | Y | Shipment Interface Identifier | |
SHIP_LINE_INT_ID | NUMBER | Y | Shipment Line Interface Identifier | |
GROUP_ID | NUMBER | Y | Open Interface Group Identifier | |
PROCESSING_STATUS_CODE | VARCHAR2 | (25) | Y | Processing Status Code |
VALIDATION_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the record should be validated |
SHIP_LINE_GROUP_REFERENCE | VARCHAR2 | (30) | Line Group Reference | |
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_NUMBER | VARCHAR2 | (30) | Party Number | |
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
PARTY_SITE_NUMBER | VARCHAR2 | (30) | Party Site Number | |
SOURCE_ORGANIZATION_ID | NUMBER | Source Inventory Organization Identifier | ||
SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | Source Inventory Organization Code | |
SHIP_LINE_NUM | NUMBER | Shipment Line Number | ||
SHIP_LINE_TYPE_ID | NUMBER | Shipment Line Type Identifier | ||
SHIP_LINE_TYPE_CODE | VARCHAR2 | (15) | Shipment Line Type Code | |
SHIP_LINE_SRC_TYPE_CODE | VARCHAR2 | (30) | Y | Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES |
SHIP_LINE_SOURCE_ID | NUMBER | Source Identifier, according to the Source Type Code | ||
CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency Code |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
TXN_QTY | NUMBER | Transaction Quantity | ||
TXN_UOM_CODE | VARCHAR2 | (3) | Transaction Unit of Measure | |
TXN_UNIT_PRICE | NUMBER | Transaction Unit Price | ||
PRIMARY_QTY | NUMBER | Primary Quantity | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure Code | |
PRIMARY_UNIT_PRICE | NUMBER | Primary Unit Price | ||
SECONDARY_QTY | NUMBER | Secondary Quantity | ||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | Secondary Unit of Measure | |
SECONDARY_UNIT_PRICE | NUMBER | Secondary Unit Price | ||
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
ALLOCATION_ENABLED_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amounts of the line are associable |
TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Categorization of a transaction for tax purposes | |
INTENDED_USE | VARCHAR2 | (30) | Purpose for which a product may be used | |
PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | Classification of the product(s) by tax authority for tax purposes | |
PRODUCT_CATEGORY | VARCHAR2 | (240) | Used to classify products for tax purposes | |
PRODUCT_TYPE | VARCHAR2 | (240) | Product related classification for tax purposes | |
USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classifiction | |
TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax Classification Code | |
ASSESSABLE_VALUE | NUMBER | EBTAX Assessable Value | ||
SHIP_FROM_PARTY_ID | NUMBER | Ship From Party Identifier | ||
SHIP_FROM_PARTY_NUMBER | VARCHAR2 | (30) | Ship From Party Number | |
SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship From Party Site Identifier | ||
SHIP_FROM_PARTY_SITE_NUMBER | VARCHAR2 | (30) | Ship From Party Site Number | |
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship To Organization Identifier | ||
SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | (3) | Ship To Organization Code | |
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
SHIP_TO_LOCATION_CODE | VARCHAR2 | (60) | Ship To Location Code | |
BILL_FROM_PARTY_ID | NUMBER | Bill From Party Identifier | ||
BILL_FROM_PARTY_NUMBER | VARCHAR2 | (30) | Bill From Party Number | |
BILL_FROM_PARTY_SITE_ID | NUMBER | Bill From Party Site Identifier | ||
BILL_FROM_PARTY_SITE_NUMBER | VARCHAR2 | (30) | Bill From Party Site Number | |
BILL_TO_ORGANIZATION_ID | NUMBER | Bill To Organization Identifier | ||
BILL_TO_ORGANIZATION_CODE | VARCHAR2 | (3) | Bill To Organization Code | |
BILL_TO_LOCATION_ID | NUMBER | Bill To Location Identifier | ||
BILL_TO_LOCATION_CODE | VARCHAR2 | (60) | Bill To Location Code | |
POA_PARTY_ID | NUMBER | Point of Order Acceptance Party Identifier | ||
POA_PARTY_NUMBER | VARCHAR2 | (30) | Point of Order Acceptance Party Number | |
POA_PARTY_SITE_ID | NUMBER | Point of Order Acceptance Party Site Identifier | ||
POA_PARTY_SITE_NUMBER | VARCHAR2 | (30) | Point of Order Acceptance Party Site Number | |
POO_ORGANIZATION_ID | NUMBER | Point of Order Origin Organization Identifier | ||
POO_TO_ORGANIZATION_CODE | VARCHAR2 | (3) | Point of Order Origin Organization Code | |
POO_LOCATION_ID | NUMBER | Point of Order Origin Location Identifier | ||
POO_LOCATION_CODE | VARCHAR2 | (60) | Point of Order Origin Location Code | |
ORG_ID | NUMBER | Y | Organization identifier | |
SHIP_HEADER_ID | NUMBER | Shipment Identifier | ||
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
INTERFACE_SOURCE_TABLE | VARCHAR2 | (30) | Source Table of the interface row | |
INTERFACE_SOURCE_LINE_ID | NUMBER | Source line identifier of the interface row | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ATTRIBUTE_CATEGORY_LG | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15_LG | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE_CATEGORY_SL | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14_SL | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15_SL | VARCHAR2 | (150) | Descriptive Flexfield |
INL.INL_SHIP_LINES_INT does not reference any database object
INL.INL_SHIP_LINES_INT is referenced by following:
Description: | This table stores attributes common to all Shipment Lines below it |
---|
This table stores attributes common to all Shipment Lines below it
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_LINE_GROUPS_U1 | UNIQUE | APPS_TS_TX_IDX | SHIP_LINE_GROUP_ID |
INL_SHIP_LINE_GROUPS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_HEADER_ID |
INL_SHIP_LINE_GROUPS_N2 | NONUNIQUE | APPS_TS_TX_IDX | PARTY_ID |
INL_SHIP_LINE_GROUPS_N3 | NONUNIQUE | APPS_TS_TX_IDX | PARTY_SITE_ID |
INL_SHIP_LINE_GROUPS_N4 | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_LINE_GROUP_ID | NUMBER | Y | Line Group Identifier | |
SHIP_LINE_GROUP_REFERENCE | VARCHAR2 | (30) | Line Group Reference | |
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
SHIP_LINE_GROUP_NUM | NUMBER | Y | Line Group Number | |
SRC_TYPE_CODE | VARCHAR2 | (30) | Y | Source Type Code |
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
SOURCE_ORGANIZATION_ID | NUMBER | Source Inventory Organization Identifier | ||
SHIP_LINE_INT_ID | NUMBER | Shipment Line Interface Identifier | ||
INTERFACE_SOURCE_TABLE | VARCHAR2 | (30) | Source Table of the interface row | |
INTERFACE_SOURCE_LINE_ID | NUMBER | Source line identifier of the interface row | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
INL.INL_SHIP_LINE_GROUPS does not reference any database object
INL.INL_SHIP_LINE_GROUPS is referenced by following:
Description: | This table stores common characteristics of Shipment Lines. |
---|
This table stores common characteristics of Shipment Lines.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_LINE_TYPES_B_U1 | UNIQUE | APPS_TS_TX_IDX | SHIP_LINE_TYPE_ID |
INL_SHIP_LINE_TYPES_B_U2 | UNIQUE | APPS_TS_TX_IDX | SHIP_LINE_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_LINE_TYPE_ID | NUMBER | Y | Shipment Line Type Identifier | |
SHIP_LINE_TYPE_CODE | VARCHAR2 | (15) | Y | Shipment Line Type Code |
DFLT_LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amounts of the line should be considered in the landed cost |
DFLT_ALLOCATION_ENABLED_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amounts of the line are associable |
ACTIVE_FROM_DATE | DATE | Y | Active From Date | |
ACTIVE_TO_DATE | DATE | Active To Date | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
INL.INL_SHIP_LINE_TYPES_B does not reference any database object
INL.INL_SHIP_LINE_TYPES_B is referenced by following:
Description: | This table stores translatable data for Shipment Line Types. |
---|
This table stores translatable data for Shipment Line Types.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_LINE_TYPES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
SHIP_LINE_TYPE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_LINE_TYPE_ID | NUMBER | Y | Shipment Line Type Identifier | |
LANGUAGE | VARCHAR2 | (4) | Y | Translated language |
SOURCE_LANG | VARCHAR2 | (4) | Y | User environment language |
SHIP_LINE_TYPE_NAME | VARCHAR2 | (30) | Y | Shipment Line Type Name |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_SHIP_LINE_TYPES_TL does not reference any database object
INL.INL_SHIP_LINE_TYPES_TL is referenced by following:
Description: | This table stores common characteristics of Shipments. |
---|
This table stores common characteristics of Shipments.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_TYPES_B_U1 | UNIQUE | APPS_TS_TX_IDX | SHIP_TYPE_ID |
INL_SHIP_TYPES_B_U2 | UNIQUE | APPS_TS_TX_IDX | SHIP_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_TYPE_ID | NUMBER | Y | Shipment Type Identifier | |
SHIP_TYPE_CODE | VARCHAR2 | (15) | Y | Shipment Type Code |
TRD_PTIES_ALWD_CODE | VARCHAR2 | (1) | Y | Third Parties Allowed Code, taken from lookup INL_3RD_PARTIES_ALLOWED |
ACTIVE_FROM_DATE | DATE | Y | Active From Date | |
ACTIVE_TO_DATE | DATE | Active To Date | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
INL.INL_SHIP_TYPES_B does not reference any database object
INL.INL_SHIP_TYPES_B is referenced by following:
Description: | This table stores translatable data for Shipment Types. |
---|
This table stores translatable data for Shipment Types.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_SHIP_TYPES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
SHIP_TYPE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_TYPE_ID | NUMBER | Y | Shipment Type Identifier | |
LANGUAGE | VARCHAR2 | (4) | Y | Translated language |
SOURCE_LANG | VARCHAR2 | (4) | Y | User environment language |
SHIP_TYPE_NAME | VARCHAR2 | (30) | Y | Shipment Type Name |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_SHIP_TYPES_TL does not reference any database object
INL.INL_SHIP_TYPES_TL is referenced by following:
Description: | This table stores information on taxes associated to Shipment components. |
---|
This table stores information on taxes associated to Shipment components.
Index | Type | Tablespace | Column |
---|---|---|---|
INL_TAX_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | TAX_LINE_ID |
INL_TAX_LINES_U2 | UNIQUE | APPS_TS_TX_IDX |
SHIP_HEADER_ID
TAX_LINE_NUM SOURCE_PARENT_TABLE_NAME SOURCE_PARENT_TABLE_ID ADJUSTMENT_NUM |
INL_TAX_LINES_N2 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAX_LINE_ID | NUMBER | Y | Tax Line Identifier | |
TAX_LINE_NUM | NUMBER | Y | Tax Line Number | |
TAX_CODE | VARCHAR2 | (30) | Y | Tax Code |
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
PARENT_TAX_LINE_ID | NUMBER | Parent Tax Line Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
MATCH_ID | NUMBER | Match Identifier | ||
MATCH_AMOUNT_ID | NUMBER | Match Amount Identifier | ||
SOURCE_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the tax is captured from: INL_TAX_LINES, ZX_LINES, AP_INVOICE_DISTRIBUTIONS |
SOURCE_PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the tax is captured from: TAX_LINE_ID, INVOICE_DISTRIBUTION_ID | |
TAX_AMT | NUMBER | Y | Tax Amount | |
NREC_TAX_AMT | NUMBER | Non Recoverable Tax Amount | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the tax is inclusive | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
INL.INL_TAX_LINES does not reference any database object
INL.INL_TAX_LINES is referenced by following:
A public view which may be useful for custom reporting or other data requirements.
This view shows adjusted associations between landed cost components of the same or different Shipments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSOCIATION_ID | NUMBER | Y | Association Identifier | |
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES |
FROM_PARENT_TABLE_ID | NUMBER | Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID | ||
TO_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the amount goes to: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES |
TO_PARENT_TABLE_ID | NUMBER | Identifier of the table line the amount goes to: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID | ||
ALLOCATION_BASIS | VARCHAR2 | (30) | Y | Criteria through which an associated amount will be distributed into two or more components of a shipment |
ALLOCATION_UOM_CODE | VARCHAR2 | (3) | Unit of measure through which the associated amount will be distributed into two or more components of a shipment |
A public view which may be useful for custom reporting or other data requirements.
This view shows adjusted information on Charge Lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHARGE_LINE_ID | NUMBER | Y | Charge Line Identifier | |
CHARGE_LINE_NUM | NUMBER | Y | Charge Line Number | |
CHARGE_LINE_TYPE_ID | NUMBER | Y | Charge Line Type Identifier | |
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
PARENT_CHARGE_LINE_ID | NUMBER | Parent Charge Line Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
MATCH_ID | NUMBER | Match Identifier | ||
MATCH_AMOUNT_ID | NUMBER | Match Amount Identifier | ||
CHARGE_AMT | NUMBER | Y | Charge Ammount | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Categorization of a transaction for tax purposes | |
INTENDED_USE | VARCHAR2 | (30) | Purpose for which a product may be used | |
PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | Classification of the product(s) by tax authority for tax purposes | |
PRODUCT_CATEGORY | VARCHAR2 | (240) | Used to classify products for tax purposes | |
PRODUCT_TYPE | VARCHAR2 | (240) | Product related classification for tax purposes | |
USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classifiction | |
TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax Classification Code | |
ASSESSABLE_VALUE | NUMBER | EBTAX Assessable Value | ||
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the taxes have already been calculated | |
SHIP_FROM_PARTY_ID | NUMBER | Ship From Party Identifier | ||
SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship From Party Site Identifier | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship To Organization Identifier | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
BILL_FROM_PARTY_ID | NUMBER | Bill From Party Identifier | ||
BILL_FROM_PARTY_SITE_ID | NUMBER | Bill From Party Site Identifier | ||
BILL_TO_ORGANIZATION_ID | NUMBER | Bill To Organization Identifier | ||
BILL_TO_LOCATION_ID | NUMBER | Bill To Location Identifier | ||
POA_PARTY_ID | NUMBER | Point of Order Acceptance Party Identifier | ||
POA_PARTY_SITE_ID | NUMBER | Point of Order Acceptance Party Site Identifier | ||
POO_ORGANIZATION_ID | NUMBER | Point of Order Origin Organization Identifier | ||
POO_LOCATION_ID | NUMBER | Point of Order Origin Location Identifier |
A public view which may be useful for custom reporting or other data requirements.
This view shows adjusted information on Shipment Lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Y | ||
SHIP_LINE_GROUP_ID | NUMBER | Y | ||
SHIP_LINE_ID | NUMBER | Y | ||
SHIP_LINE_NUM | NUMBER | Y | ||
SHIP_LINE_TYPE_ID | NUMBER | Y | ||
SHIP_LINE_SRC_TYPE_CODE | VARCHAR2 | (30) | ||
SHIP_LINE_SOURCE_ID | NUMBER | |||
PARENT_SHIP_LINE_ID | NUMBER | |||
ADJUSTMENT_NUM | NUMBER | Y | ||
MATCH_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
TXN_QTY | NUMBER | |||
TXN_UOM_CODE | VARCHAR2 | (3) | ||
TXN_UNIT_PRICE | NUMBER | |||
PRIMARY_QTY | NUMBER | |||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
PRIMARY_UNIT_PRICE | NUMBER | |||
FC_PRIMARY_UNIT_PRICE | NUMBER | Functional primary unit price | ||
SECONDARY_QTY | NUMBER | |||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | ||
SECONDARY_UNIT_PRICE | NUMBER | |||
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | |
ALLOCATION_ENABLED_FLAG | VARCHAR2 | (1) | Y | |
TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | ||
INTENDED_USE | VARCHAR2 | (30) | ||
PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | ||
PRODUCT_CATEGORY | VARCHAR2 | (240) | ||
PRODUCT_TYPE | VARCHAR2 | (240) | ||
USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | ||
TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | ||
ASSESSABLE_VALUE | NUMBER | |||
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | ||
SHIP_FROM_PARTY_ID | NUMBER | |||
SHIP_FROM_PARTY_SITE_ID | NUMBER | |||
SHIP_TO_ORGANIZATION_ID | NUMBER | |||
SHIP_TO_LOCATION_ID | NUMBER | |||
BILL_FROM_PARTY_ID | NUMBER | |||
BILL_FROM_PARTY_SITE_ID | NUMBER | |||
BILL_TO_ORGANIZATION_ID | NUMBER | |||
BILL_TO_LOCATION_ID | NUMBER | |||
POA_PARTY_ID | NUMBER | |||
POA_PARTY_SITE_ID | NUMBER | |||
POO_ORGANIZATION_ID | NUMBER | |||
POO_LOCATION_ID | NUMBER | |||
ORG_ID | NUMBER | Y | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
A public view which may be useful for custom reporting or other data requirements.
This view shows adjusted information on Tax Lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAX_LINE_ID | NUMBER | Y | Tax Line Identifier | |
TAX_LINE_NUM | NUMBER | Y | Tax Line Number | |
TAX_CODE | VARCHAR2 | (30) | Y | Tax Code |
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
PARENT_TAX_LINE_ID | NUMBER | Parent Tax Line Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
MATCH_ID | NUMBER | Match Identifier | ||
MATCH_AMOUNT_ID | NUMBER | Match Amount Identifier | ||
SOURCE_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the tax is captured from: INL_TAX_LINES, ZX_LINES, AP_INVOICE_DISTRIBUTIONS. |
SOURCE_PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the tax is captured from: TAX_LINE_ID, INVOICE_DISTRIBUTION_ID | |
TAX_AMT | NUMBER | Y | Tax Amount | |
NREC_TAX_AMT | NUMBER | Non Recoverable Tax Amount | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the tax is inclusive | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
A public view which may be useful for custom reporting or other data requirements.
This view shows all amounts of a Shipment, prorated into its Shipment Lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALLOCATION_ID | NUMBER | Y | Allocation Identifier | |
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
ASSOCIATION_ID | NUMBER | Association Identifier | ||
PARENT_ALLOCATION_ID | NUMBER | Parent Allocation Identifier | ||
FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES |
FROM_PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID | |
TO_PARENT_TABLE_NAME | VARCHAR2 | (30) | Y | Name of the table the amount goes to: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES |
TO_PARENT_TABLE_ID | NUMBER | Y | Identifier of the table line the amount goes to: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID | |
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
ESTIMATED_AMT | NUMBER | Estimated Amount | ||
ALLOCATION_AMT | NUMBER | Y | Allocation Amount | |
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
APPS.INL_ALLOCATIONS_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALLOCATION_BASIS_ID | NUMBER | Allocation Basis Identifier | ||
ALLOCATION_BASIS_CODE | VARCHAR2 | (30) | Y | Allocation Basis Code |
ALLOCATION_BASIS_NAME | VARCHAR2 | (80) | Y | Allocation Basis Name |
UOM_CLASS | VARCHAR2 | (10) | Class of Unif of Measure | |
BASE_UOM_CODE | VARCHAR2 | (3) | Base Unit of Measure of the Class |
A public view which may be useful for custom reporting or other data requirements.
This view shows information on the flow of the Shipment amounts to get the corresponding Shipment Lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Shipment Identifier | ||
ADJUSTMENT_NUM | NUMBER | Adjustment Number | ||
ASSOCIATION_ID | NUMBER | Association Identifier | ||
PARENT_TABLE_NAME | VARCHAR2 | (30) | Name of the table the amount comes from: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES | |
PARENT_TABLE_ID | NUMBER | Identifier of the table line the amount comes from: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID | ||
ALLOCATION_AMT | NUMBER | Allocation Amount | ||
ASSOC_FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES | |
ASSOC_FROM_PARENT_TABLE_ID | NUMBER | Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID |
APPS.INL_ALLOCATION_FLOW_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
This view shows the summary of the allocation of Shipment amounts.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
ORGANIZATION_ID | NUMBER | Y | Inventory Organization Identifier | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
PRIMARY_QTY | NUMBER | Primary Quantity | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure Code | |
SHIP_LINE_GROUP_ID | NUMBER | Line Group Identifier | ||
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
SHIP_LINE_NUM | NUMBER | Shipment Line Number | ||
ASSOCIATION_ID | NUMBER | Association Identifier | ||
ASSOC_FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES | |
ASSOC_FROM_PARENT_TABLE_ID | NUMBER | Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID | ||
CHARGE_LINE_ID | NUMBER | Charge Line Identifier | ||
TAX_LINE_ID | NUMBER | Tax Line Identifier | ||
ALLOCATION_ID | NUMBER | Y | Allocation Identifier | |
ALLOCATION_AMT | NUMBER | Y | Allocation Amount | |
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHARGE_LINE_TYPE_ID | NUMBER | Y | Charge Line Type Identifier | |
CHARGE_LINE_TYPE_CODE | VARCHAR2 | (30) | Y | Charge Line Type Code |
CHARGE_LINE_TYPE_NAME | VARCHAR2 | (80) | Y | Charge Line Type Name |
DFLT_LANDED_COST_FLAG | CHAR | (1) | "Y" or "N" flag indicating whether the amounts of the line should be considered in the landed cost | |
AP_LINE_TYPE_CODE | CHAR | (13) | Payables Invoice Line Type lookup code | |
ALLOCATION_BASIS | VARCHAR2 | (30) | Criteria through which an associated amount will be distributed into two or more components of a shipment | |
ACTIVE_FROM_DATE | CHAR | (11) | Active From Date | |
ACTIVE_TO_DATE | VARCHAR2 | (11) | Active To Date | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. |
A public view which may be useful for custom reporting or other data requirements.
This view shows overall information on Charges.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
ORGANIZATION_ID | NUMBER | Y | Inventory Organization Identifier | |
LOCATION_ID | NUMBER | Location Identifier | ||
ORG_ID | NUMBER | Y | Organization identifier | |
SHIP_TYPE_ID | NUMBER | Y | Shipment Type Identifier | |
SHIP_NUM | VARCHAR2 | (25) | Y | Shipment Number |
SHIP_DATE | DATE | Y | Shipment Date | |
SHIP_STATUS_CODE | VARCHAR2 | (30) | Y | Shipment Status, taken from lookup INL_SHIP_STATUSES |
PENDING_MATCHING_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating the existence of lines matched but not absorbed by the landed cost calculation | |
LINE_GROUP_PARTY_ID | NUMBER | Line Group Party Identifier | ||
LINE_GROUP_PARTY_SITE_ID | NUMBER | Line Group Party Site Identifier | ||
CHARGE_LINE_ID | NUMBER | Y | Charge Line Identifier | |
CHARGE_LINE_NUM | NUMBER | Y | Charge Line Number | |
CHARGE_LINE_TYPE_ID | NUMBER | Y | Charge Line Type Identifier | |
LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
PARENT_CHARGE_LINE_ID | NUMBER | Parent Charge Line Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
MATCH_ID | NUMBER | Match Identifier | ||
CHARGE_AMT | NUMBER | Y | Charge Ammount | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
PARTY_ID | NUMBER | Party Identifier | ||
GROUP_PARTY_NAME | VARCHAR2 | (360) | Group Party Name | |
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
GROUP_PARTY_SITE_NAME | VARCHAR2 | (240) | Group Party Site Name | |
TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Categorization of a transaction for tax purposes | |
INTENDED_USE | VARCHAR2 | (30) | Purpose for which a product may be used | |
PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | Classification of the product(s) by tax authority for tax purposes | |
PRODUCT_CATEGORY | VARCHAR2 | (240) | Used to classify products for tax purposes | |
PRODUCT_TYPE | VARCHAR2 | (240) | Product related classification for tax purposes | |
USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classifiction | |
TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax Classification Code | |
ASSESSABLE_VALUE | NUMBER | EBTAX Assessable Value | ||
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the taxes have already been calculated | |
SHIP_FROM_PARTY_ID | NUMBER | Ship From Party Identifier | ||
SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship From Party Site Identifier | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship To Organization Identifier | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
BILL_FROM_PARTY_ID | NUMBER | Bill From Party Identifier | ||
BILL_FROM_PARTY_SITE_ID | NUMBER | Bill From Party Site Identifier | ||
BILL_TO_ORGANIZATION_ID | NUMBER | Bill To Organization Identifier | ||
BILL_TO_LOCATION_ID | NUMBER | Bill To Location Identifier | ||
POA_PARTY_ID | NUMBER | Point of Order Acceptance Party Identifier | ||
POA_PARTY_SITE_ID | NUMBER | Point of Order Acceptance Party Site Identifier | ||
POO_ORGANIZATION_ID | NUMBER | Point of Order Origin Organization Identifier | ||
POO_LOCATION_ID | NUMBER | Point of Order Origin Location Identifier |
APPS.INL_CHARGE_OVERALL_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
This view shows corrected information of matches between actual and estimated amounts of a Landed Cost Shipment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATCH_ID | NUMBER | Y | Match Identifier | |
MATCH_TYPE_CODE | VARCHAR2 | (30) | Y | Match Type Code |
SHIP_HEADER_ID | NUMBER | Shipment Identifier | ||
FROM_PARENT_TABLE_NAME | VARCHAR2 | (30) | Identifier of the table line the match comes from. | |
FROM_PARENT_TABLE_ID | NUMBER | Identifier of the table line the match comes from. | ||
TO_PARENT_TABLE_NAME | VARCHAR2 | (30) | Name of the table the match goes to: INL_SHIP_LINES, INL_CHARGE_LINES. | |
TO_PARENT_TABLE_ID | NUMBER | Identifier of the table line the match goes to: SHIP_LINE_ID, CHARGE_LINE_ID. | ||
MATCHED_QTY | NUMBER | Matched Quantity | ||
MATCHED_UOM_CODE | VARCHAR2 | (3) | Matched Unit of Measure Code | |
MATCHED_AMT | NUMBER | Matched Amount | ||
CORRECTION_MATCH_ID | VARCHAR2 | (40) | Correction Match Identifier | |
MATCHED_CURR_CODE | VARCHAR2 | (15) | Matched Currency Code | |
MATCHED_CURR_CONVERSION_TYPE | VARCHAR2 | (30) | Match Currency Conversion Type | |
MATCHED_CURR_CONVERSION_DATE | DATE | Match Currency Conversion Date | ||
MATCHED_CURR_CONVERSION_RATE | NUMBER | Match Currency Conversion Rate | ||
ADJ_ALREADY_GENERATED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the match has already generated adjustments | |
REPLACE_ESTIM_QTY_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts. |
EXISTING_MATCH_INFO_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the match corresponds to data already matched (match update) | |
CHARGE_LINE_TYPE_ID | NUMBER | Charge Line Type Identifier | ||
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
TAX_CODE | VARCHAR2 | (30) | Tax Code | |
NREC_TAX_AMT | NUMBER | Non Recoverable Tax Amount | ||
TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the tax is included to the unit price. | |
MATCH_AMOUNT_ID | NUMBER | Match Amount Identifier | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
A public view which may be useful for custom reporting or other data requirements.
This view shows matches between actual and estimated charge amounts of a Landed Cost Shipment, grouped by Charge Line Type.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATCH_AMOUNT_ID | NUMBER | Y | Match Amount Identifier | |
MATCHED_AMT | NUMBER | Matched Amount | ||
MATCHED_CURR_CODE | VARCHAR2 | (15) | Y | Matched Currency Code |
MATCHED_CURR_CONVERSION_TYPE | VARCHAR2 | (30) | Match Currency Conversion Type | |
MATCHED_CURR_CONVERSION_DATE | DATE | Match Currency Conversion Date | ||
MATCHED_CURR_CONVERSION_RATE | NUMBER | Match Currency Conversion Rate | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
A public view which may be useful for custom reporting or other data requirements.
This view shows detailed landed cost information for a Shipment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
SHIP_LINE_GROUP_ID | NUMBER | Line Group Identifier | ||
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
ORGANIZATION_ID | NUMBER | Y | Inventory Organization Identifier | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
INV_ITEM | VARCHAR2 | (40) | Inventory Item Concatenated Segments | |
PRIMARY_QTY | NUMBER | Primary Quantity | ||
UNIT_OF_MEASURE | VARCHAR2 | (25) | Y | Unit of Measure |
ALLOCATED_AMT | NUMBER | Allocation Amount | ||
ALLOCATION_PERCENT | NUMBER | Percentual of Allocation | ||
COMPONENT_TYPE | VARCHAR2 | (10) | Component Type | |
COMPONENT_NAME | VARCHAR2 | (80) | Component Name |
APPS.INL_DET_LANDED_COSTS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
This view shows EBTAX Line information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE | VARCHAR2 | (9) | Source | |
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
SHIP_LINE_GROUP_ID | NUMBER | Line Group Identifier | ||
SHIP_LINE_NUM | NUMBER | Shipment Line Number | ||
SHIP_LINE_TYPE_ID | NUMBER | Shipment Line Type Identifier | ||
SRC_TYPE_CODE | VARCHAR2 | (30) | Source Type Code | |
SRC_ID | NUMBER | Source Identifier | ||
SHIP_HEADER_ID | NUMBER | Shipment Identifier | ||
UNIT_PRICE | NUMBER | Unit Price | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
UOM_CODE | VARCHAR2 | (3) | Unit of Measure | |
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Categorization of a transaction for tax purposes | |
INTENDED_USE | VARCHAR2 | (30) | Purpose for which a product may be used | |
PRODUCT_FISCAL_CLASS | VARCHAR2 | (240) | Classification of the product(s) by tax authority for tax purposes | |
PRODUCT_CATEGORY | VARCHAR2 | (240) | Used to classify products for tax purposes | |
PRODUCT_TYPE | VARCHAR2 | (240) | Product related classification for tax purposes | |
USER_DEF_FISCAL_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classifiction | |
TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax Classification Code | |
ASSESSABLE_VALUE | NUMBER | EBTAX Assessable Value | ||
LINE_AMT | NUMBER | Line Amount | ||
LINE_QTY | NUMBER | Line Quantity | ||
TAX_ALREADY_CALCULATED_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether the taxes have already been calculated | |
SHIP_FROM_PARTY_ID | NUMBER | Ship From Party Identifier | ||
SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship From Party Site Identifier | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship To Organization Identifier | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
BILL_FROM_PARTY_ID | NUMBER | Bill From Party Identifier | ||
BILL_FROM_PARTY_SITE_ID | NUMBER | Bill From Party Site Identifier | ||
BILL_TO_ORGANIZATION_ID | NUMBER | Bill To Organization Identifier | ||
BILL_TO_LOCATION_ID | NUMBER | Bill To Location Identifier | ||
POA_PARTY_ID | NUMBER | Point of Order Acceptance Party Identifier | ||
POA_PARTY_SITE_ID | NUMBER | Point of Order Acceptance Party Site Identifier | ||
POO_ORGANIZATION_ID | NUMBER | Point of Order Origin Organization Identifier | ||
POO_LOCATION_ID | NUMBER | Point of Order Origin Location Identifier | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
ADJUSTMENT_NUM | NUMBER | Adjustment Number |
A public view which may be useful for custom reporting or other data requirements.
A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_PO_V).
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_CHKBOX | CHAR | (1) | Line Checkbox | |
SOURCE_TYPE_CODE | CHAR | (6) | Source Type Code | |
RECEIPT_SOURCE_CODE | CHAR | (6) | Receipt Source Code | |
ORDER_TYPE_CODE | CHAR | (2) | Order Type Code | |
ORDER_TYPE | VARCHAR2 | (25) | Y | Order Type |
PO_HEADER_ID | NUMBER | Y | PO Header Identifier | |
PO_NUMBER | VARCHAR2 | (20) | Y | PO Number |
PO_LINE_ID | NUMBER | Y | PO Line Identifier | |
PO_LINE_NUMBER | NUMBER | Y | PO Line Number | |
PO_LINE_LOCATION_ID | NUMBER | Y | PO Shipment Identifier | |
PO_SHIPMENT_NUMBER | NUMBER | PO Shipment Number | ||
PO_RELEASE_ID | NUMBER | PO Release Identifier | ||
PO_RELEASE_NUMBER | NUMBER | PO Release Number | ||
REQ_HEADER_ID | NUMBER | Requisition Header Identifier | ||
REQ_NUMBER | VARCHAR2 | (0) | Requisition Number | |
REQ_LINE_ID | NUMBER | Requisition Line Identifier | ||
REQ_LINE | NUMBER | Requisition Line | ||
REQ_DISTRIBUTION_ID | NUMBER | Requisition Distribution Identifier | ||
RCV_SHIPMENT_HEADER_ID | NUMBER | Receiving Shipment Header Identifier | ||
RCV_SHIPMENT_NUMBER | VARCHAR2 | (0) | Receiving Shipment Number | |
RCV_SHIPMENT_LINE_ID | NUMBER | Receiving Shipment Line Identifier | ||
RCV_LINE_NUMBER | NUMBER | Receiving Line Number | ||
FROM_ORGANIZATION_ID | NUMBER | Y | From Organization Identifier | |
TO_ORGANIZATION_ID | NUMBER | Destination Inventory Organization Identifier | ||
VENDOR_ID | NUMBER | Vendor Identifier | ||
SOURCE | VARCHAR2 | (240) | Source | |
VENDOR_SITE_ID | NUMBER | Vendor Site Identifier | ||
OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Outside Operation Flag | |
ITEM_ID | NUMBER | Inventory Item Identifier | ||
PRIMARY_UOM | VARCHAR2 | (25) | Primary Unit of Measure | |
PRIMARY_UOM_CLASS | VARCHAR2 | (10) | Primary Unit of Measure Class | |
ITEM_ALLOWED_UNITS_LOOKUP_CODE | NUMBER | Inventory Item Allowed Units | ||
ITEM_LOCATOR_CONTROL | NUMBER | Inventory Item Locator Control | ||
RESTRICT_LOCATORS_CODE | VARCHAR2 | (1) | Restrict Locators Code | |
RESTRICT_SUBINVENTORIES_CODE | VARCHAR2 | (1) | Restrict Subinventories Code | |
SHELF_LIFE_CODE | NUMBER | Shelf Life Code | ||
SHELF_LIFE_DAYS | NUMBER | Shelf Life Days | ||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | Serial Number Control Code | ||
LOT_CONTROL_CODE | NUMBER | Lot Control Code | ||
ITEM_REV_CONTROL_FLAG_TO | VARCHAR2 | (1) | Inventory Item Revision Control Flag To | |
ITEM_REV_CONTROL_FLAG_FROM | VARCHAR2 | (0) | Inventory Item Revision Control Flag From | |
ITEM_NUMBER | VARCHAR2 | (0) | Inventory Item Number | |
ITEM_REVISION | VARCHAR2 | (3) | Inventory Item Revision | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory Item Description | |
ITEM_CATEGORY_ID | NUMBER | Inventory Item Category Identifier | ||
HAZARD_CLASS | VARCHAR2 | (40) | Hazard Class | |
UN_NUMBER | VARCHAR2 | (25) | UN Number | |
VENDOR_ITEM_NUMBER | VARCHAR2 | (25) | Vendor Item Number | |
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
SHIP_TO_LOCATION | VARCHAR2 | (60) | Ship To Location | |
PACKING_SLIP | VARCHAR2 | (0) | Packing Slip | |
ROUTING_ID | NUMBER | Routing Identifier | ||
ROUTING_NAME | VARCHAR2 | (80) | Routing Name | |
NEED_BY_DATE | DATE | Need By Date | ||
EXPECTED_RECEIPT_DATE | DATE | Expecte Arrival Date | ||
ORDERED_QTY | NUMBER | Ordered Quantity | ||
ORDERED_UOM | VARCHAR2 | (25) | Ordered Unit of Measure | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (0) | USSGL Transaction Code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | Government Context | |
INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Inspection Required Flag | |
RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Receipt Required Flag | |
ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | Enforce Ship to Location Code | |
UNIT_PRICE | NUMBER | Unit Price | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to Receiver | |
DESTINATION_TYPE_CODE | VARCHAR2 | (0) | Destination Type | |
DELIVER_TO_PERSON_ID | NUMBER | Deliver to Person Identifier | ||
DELIVER_TO_LOCATION_ID | NUMBER | Deliver to Location Identifier | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (0) | Destination Subinventory | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CLOSED_CODE | VARCHAR2 | (30) | Closed Code | |
ASN_TYPE | VARCHAR2 | (0) | ASN Type | |
BILL_OF_LADING | VARCHAR2 | (0) | Bill Of Lading Number | |
SHIPPED_DATE | DATE | Shipped Date | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (0) | Freight Carrier Code | |
WAYBILL_AIRBILL_NUM | VARCHAR2 | (0) | Waybill/Airbill Number | |
FREIGHT_BILL_NUM | VARCHAR2 | (0) | Freight Bill Number | |
VENDOR_LOT_NUM | VARCHAR2 | (0) | Vendor Lot Number | |
CONTAINER_NUM | VARCHAR2 | (0) | Container Number | |
TRUCK_NUM | VARCHAR2 | (0) | Truck Number | |
BAR_CODE_LABEL | VARCHAR2 | (0) | Bar Code Label | |
RATE_TYPE_DISPLAY | VARCHAR2 | (30) | Rate Type Display | |
MATCH_OPTION | VARCHAR2 | (25) | Match Option | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Country of Origin | |
OE_ORDER_HEADER_ID | NUMBER | OE Order Header Identifier | ||
OE_ORDER_NUM | NUMBER | OE Order Number | ||
OE_ORDER_LINE_ID | NUMBER | OE Order Line Identifier | ||
OE_ORDER_LINE_NUM | NUMBER | OE Order Line Number | ||
CUSTOMER_ID | NUMBER | Customer Identifier | ||
CUSTOMER_SITE_ID | NUMBER | Customer Site Identifier | ||
CUSTOMER_ITEM_NUM | VARCHAR2 | (0) | Customer Item Number | |
PLL_NOTE_TO_RECEIVER | VARCHAR2 | (480) | PO Shipment Note to Receiver | |
SECONDARY_ORDERED_QTY | NUMBER | Ordered Quantity in Secondary unit of measure | ||
SECONDARY_ORDERED_UOM | VARCHAR2 | (25) | Ordered items secondary unit of measure | |
QC_GRADE | VARCHAR2 | (150) | QC Grade | |
LPN_ID | NUMBER | LPN Identifier | ||
SECONDARY_DEFAULT_IND | VARCHAR2 | (30) | Secondary Default | |
ORG_ID | NUMBER | Operating Unit Identifier | ||
OE_ORDER_SHIP_NUM | NUMBER | OE Order Shipment Number | ||
LCM_SHIPMENT_LINE_ID | NUMBER | Shipment Line Identifier | ||
UNIT_LANDED_COST | NUMBER | Unit Landed Cost | ||
LCM_SHIPMENT_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether a given Shipment is enabled for LCM |
A public view which may be useful for custom reporting or other data requirements.
A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_V).
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_CHKBOX | CHAR | (1) | Line Checkbox | |
SOURCE_TYPE_CODE | VARCHAR2 | (8) | Source Type Code | |
RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | Receipt Source Code | |
ORDER_TYPE_CODE | VARCHAR2 | (30) | Order Type Code | |
ORDER_TYPE | VARCHAR2 | (30) | Order Type | |
PO_HEADER_ID | NUMBER | PO Header Identifier | ||
PO_NUMBER | VARCHAR2 | (20) | PO Number | |
PO_LINE_ID | NUMBER | PO Line Identifier | ||
PO_LINE_NUMBER | NUMBER | PO Line Number | ||
PO_LINE_LOCATION_ID | NUMBER | PO Shipment Identifier | ||
PO_SHIPMENT_NUMBER | NUMBER | PO Shipment Number | ||
PO_RELEASE_ID | NUMBER | PO Release Identifier | ||
PO_RELEASE_NUMBER | NUMBER | PO Release Number | ||
REQ_HEADER_ID | NUMBER | Requisition Header Identifier | ||
REQ_NUMBER | VARCHAR2 | (20) | Requisition Number | |
REQ_LINE_ID | NUMBER | Requisition Line Identifier | ||
REQ_LINE | NUMBER | Requisition Line | ||
REQ_DISTRIBUTION_ID | NUMBER | Requisition Distribution Identifier | ||
RCV_SHIPMENT_HEADER_ID | NUMBER | Receiving Shipment Header Identifier | ||
RCV_SHIPMENT_NUMBER | VARCHAR2 | (30) | Receiving Shipment Number | |
RCV_SHIPMENT_LINE_ID | NUMBER | Receiving Shipment Line Identifier | ||
RCV_LINE_NUMBER | NUMBER | Receiving Line Number | ||
FROM_ORGANIZATION_ID | NUMBER | From Organization Identifier | ||
TO_ORGANIZATION_ID | NUMBER | Destination Inventory Organization Identifier | ||
VENDOR_ID | NUMBER | Vendor Identifier | ||
SOURCE | VARCHAR2 | (360) | Source | |
VENDOR_SITE_ID | NUMBER | Vendor Site Identifier | ||
OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Outside Operation Flag | |
ITEM_ID | NUMBER | Inventory Item Identifier | ||
PRIMARY_UOM | VARCHAR2 | (25) | Primary Unit of Measure | |
PRIMARY_UOM_CLASS | VARCHAR2 | (10) | Primary Unit of Measure Class | |
ITEM_ALLOWED_UNITS_LOOKUP_CODE | NUMBER | Inventory Item Allowed Units | ||
ITEM_LOCATOR_CONTROL | NUMBER | Inventory Item Locator Control | ||
RESTRICT_LOCATORS_CODE | VARCHAR2 | (1) | Restrict Locators Code | |
RESTRICT_SUBINVENTORIES_CODE | VARCHAR2 | (1) | Restrict Subinventories Code | |
SHELF_LIFE_CODE | NUMBER | Shelf Life Code | ||
SHELF_LIFE_DAYS | NUMBER | Shelf Life Days | ||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | Serial Number Control Code | ||
LOT_CONTROL_CODE | NUMBER | Lot Control Code | ||
ITEM_REV_CONTROL_FLAG_TO | VARCHAR2 | (1) | Inventory Item Revision Control Flag To | |
ITEM_REV_CONTROL_FLAG_FROM | VARCHAR2 | (1) | Inventory Item Revision Control Flag From | |
ITEM_NUMBER | VARCHAR2 | (40) | Inventory Item Number | |
ITEM_REVISION | VARCHAR2 | (3) | Inventory Item Revision | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory Item Description | |
ITEM_CATEGORY_ID | NUMBER | Inventory Item Category Identifier | ||
HAZARD_CLASS | VARCHAR2 | (40) | Hazard Class | |
UN_NUMBER | VARCHAR2 | (25) | UN Number | |
VENDOR_ITEM_NUMBER | VARCHAR2 | (25) | Vendor Item Number | |
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
SHIP_TO_LOCATION | VARCHAR2 | (60) | Ship To Location Identifier | |
PACKING_SLIP | VARCHAR2 | (25) | Packing Slip | |
ROUTING_ID | NUMBER | Routing Identifier | ||
ROUTING_NAME | VARCHAR2 | (80) | Routing Name | |
NEED_BY_DATE | DATE | Need By Date | ||
EXPECTED_RECEIPT_DATE | DATE | Expecte Arrival Date | ||
ORDERED_QTY | NUMBER | Ordered Quantity | ||
ORDERED_UOM | VARCHAR2 | (25) | Ordered Unit of Measure | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL Transaction Code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | Government Context | |
INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Inspection Required Flag | |
RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Receipt Required Flag | |
ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | Enforce Ship to Location Code | |
UNIT_PRICE | NUMBER | Unit Price | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to Receiver | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination Type | |
DELIVER_TO_PERSON_ID | NUMBER | Deliver to Person Identifier | ||
DELIVER_TO_LOCATION_ID | NUMBER | Deliver to Location Identifier | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Destination Subinventory | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
CLOSED_CODE | VARCHAR2 | (30) | Closed Code | |
ASN_TYPE | VARCHAR2 | (25) | ASN Type | |
BILL_OF_LADING | VARCHAR2 | (25) | Bill Of Lading Number | |
SHIPPED_DATE | DATE | Shipped Date | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | Freight Carrier Code | |
WAYBILL_AIRBILL_NUM | VARCHAR2 | (20) | Waybill/Airbill Number | |
FREIGHT_BILL_NUM | VARCHAR2 | (35) | Freight Bill Number | |
VENDOR_LOT_NUM | VARCHAR2 | (30) | Vendor Lot Number | |
CONTAINER_NUM | VARCHAR2 | (35) | Container Number | |
TRUCK_NUM | VARCHAR2 | (35) | Truck Number | |
BAR_CODE_LABEL | VARCHAR2 | (35) | Bar Code Label | |
RATE_TYPE_DISPLAY | VARCHAR2 | (30) | Rate Type Display | |
MATCH_OPTION | VARCHAR2 | (25) | Match Option | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Country of Origin | |
OE_ORDER_HEADER_ID | NUMBER | OE Order Header Identifier | ||
OE_ORDER_NUM | NUMBER | OE Order Number | ||
OE_ORDER_LINE_ID | NUMBER | OE Order Line Identifier | ||
OE_ORDER_LINE_NUM | NUMBER | OE Order Line Number | ||
CUSTOMER_ID | NUMBER | Customer Identifier | ||
CUSTOMER_SITE_ID | NUMBER | Customer Site Identifier | ||
CUSTOMER_ITEM_NUM | VARCHAR2 | (50) | Customer Item Number | |
PLL_NOTE_TO_RECEIVER | VARCHAR2 | (2000) | PO Shipment Note to Receiver | |
SECONDARY_ORDERED_QTY | NUMBER | Ordered Quantity in Secondary unit of measure | ||
SECONDARY_ORDERED_UOM | VARCHAR2 | (25) | Ordered items secondary unit of measure | |
QC_GRADE | VARCHAR2 | (150) | QC Grade | |
LPN_ID | NUMBER | LPN Identifier | ||
SECONDARY_DEFAULT_IND | VARCHAR2 | (30) | Secondary Default | |
ORG_ID | NUMBER | Organization identifier | ||
OE_ORDER_SHIP_NUM | NUMBER | OE Order Shipment Number | ||
LCM_SHIPMENT_LINE_ID | NUMBER | Shipment Line Identifier | ||
UNIT_LANDED_COST | NUMBER | Unit Landed Cost | ||
LCM_SHIPMENT_FLAG | VARCHAR2 | (1) | "Y" or "N" flag indicating whether a given Shipment is enabled for LCM |
A public view which may be useful for custom reporting or other data requirements.
This view shows expected receipts from Internal Requisition.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_CHKBOX | CHAR | (1) | Line Checkbox | |
SOURCE_TYPE_CODE | VARCHAR2 | (8) | Source Type Code | |
RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | Receipt Source Code | |
ORDER_TYPE_CODE | VARCHAR2 | (30) | Order Type Code | |
ORDER_TYPE | VARCHAR2 | (30) | Order Type | |
PO_HEADER_ID | NUMBER | PO Header Identifier | ||
PO_NUMBER | VARCHAR2 | (20) | PO Number | |
PO_LINE_ID | NUMBER | PO Line Identifier | ||
PO_LINE_NUMBER | NUMBER | PO Line Number | ||
PO_LINE_LOCATION_ID | NUMBER | PO Shipment Identifier | ||
PO_SHIPMENT_NUMBER | NUMBER | PO Shipment Number | ||
PO_RELEASE_ID | NUMBER | PO Release Identifier | ||
PO_RELEASE_NUMBER | NUMBER | PO Release Number | ||
REQ_HEADER_ID | NUMBER | Requisition Header Identifier | ||
REQ_NUMBER | VARCHAR2 | (20) | Requisition Number | |
REQ_LINE_ID | NUMBER | Requisition Line Identifier | ||
REQ_LINE | NUMBER | Requisition Line | ||
REQ_DISTRIBUTION_ID | NUMBER | Requisition Distribution Identifier | ||
RCV_SHIPMENT_HEADER_ID | NUMBER | Receiving Shipment Header Identifier | ||
RCV_SHIPMENT_NUMBER | VARCHAR2 | (30) | Receiving Shipment Number | |
RCV_SHIPMENT_LINE_ID | NUMBER | Receiving Shipment Line Identifier | ||
RCV_LINE_NUMBER | NUMBER | Receiving Line Number | ||
FROM_ORGANIZATION_ID | NUMBER | From Organization Identifier | ||
TO_ORGANIZATION_ID | NUMBER | Destination Inventory Organization Identifier | ||
VENDOR_ID | NUMBER | Vendor Identifier | ||
SOURCE | VARCHAR2 | (360) | Source | |
VENDOR_SITE_ID | NUMBER | Vendor Site Identifier | ||
OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Outside Operation Flag | |
ITEM_ID | NUMBER | Inventory Item Identifier | ||
PRIMARY_UOM | VARCHAR2 | (25) | Primary Unit of Measure | |
PRIMARY_UOM_CLASS | VARCHAR2 | (10) | Primary Unit of Measure Class | |
ITEM_ALLOWED_UNITS_CODE | NUMBER | Inventory Item Allowed Units | ||
ITEM_LOCATOR_CONTROL | NUMBER | Inventory Item Locator Control | ||
RESTRICT_LOCATORS_CODE | VARCHAR2 | (1) | Restrict Locators Code | |
RESTRICT_SUBINVENTORIES_CODE | VARCHAR2 | (1) | Restrict Subinventories Code | |
SHELF_LIFE_CODE | NUMBER | Shelf Life Code | ||
SHELF_LIFE_DAYS | NUMBER | Shelf Life Days | ||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | Serial Number Control Code | ||
LOT_CONTROL_CODE | NUMBER | Lot Control Code | ||
ITEM_REV_CONTROL_FLAG_TO | VARCHAR2 | (1) | Inventory Item Revision Control Flag To | |
ITEM_REV_CONTROL_FLAG_FROM | VARCHAR2 | (1) | Inventory Item Revision Control Flag From | |
ITEM_NUMBER | VARCHAR2 | (40) | Inventory Item Number | |
ITEM_REVISION | VARCHAR2 | (3) | Inventory Item Revision | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory Item Description | |
ITEM_CATEGORY_ID | NUMBER | Inventory Item Category Identifier | ||
HAZARD_CLASS | VARCHAR2 | (40) | Hazard Class | |
UN_NUMBER | VARCHAR2 | (25) | UN Number | |
VENDOR_ITEM_NUMBER | VARCHAR2 | (25) | Vendor Item Number | |
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
SHIP_TO_LOCATION | VARCHAR2 | (60) | Ship To Location Identifier | |
PACKING_SLIP | VARCHAR2 | (25) | Packing Slip | |
ROUTING_ID | NUMBER | Routing Identifier | ||
ROUTING_NAME | VARCHAR2 | (80) | Routing Name | |
NEED_BY_DATE | DATE | Need By Date | ||
EXPECTED_RECEIPT_DATE | DATE | Expected Arrival Date | ||
ORDERED_QTY | NUMBER | Ordered Quantity | ||
ORDERED_UOM | VARCHAR2 | (25) | Ordered Unit of Measure | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL Transaction Code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | Government Context | |
INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Inspection Required Flag | |
RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Receipt Required Flag | |
ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | Enforce Ship to Location Code | |
UNIT_PRICE | NUMBER | Unit Price | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to Receiver | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination Type | |
DELIVER_TO_PERSON_ID | NUMBER | Deliver to Person Identifier | ||
DELIVER_TO_LOCATION_ID | NUMBER | Deliver to Location Identifier | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Destination Subinventory | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
CLOSED_CODE | VARCHAR2 | (30) | Closed Code | |
ASN_TYPE | VARCHAR2 | (25) | ASN Type | |
BILL_OF_LADING | VARCHAR2 | (25) | Bill of Lading | |
SHIPPED_DATE | DATE | Shipped Date | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | Freight Carrier Code | |
WAYBILL_AIRBILL_NUM | VARCHAR2 | (20) | Waybill/Airbill Number | |
FREIGHT_BILL_NUM | VARCHAR2 | (35) | Freight Bill Number | |
VENDOR_LOT_NUM | VARCHAR2 | (30) | Vendor Lot Number | |
CONTAINER_NUM | VARCHAR2 | (35) | Container Number | |
TRUCK_NUM | VARCHAR2 | (35) | Truck Number | |
BAR_CODE_LABEL | VARCHAR2 | (35) | Bar Code Label | |
RATE_TYPE_DISPLAY | VARCHAR2 | (30) | Rate Type Display | |
MATCH_OPTION | VARCHAR2 | (25) | Match Option | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Country of Origin | |
OE_ORDER_HEADER_ID | NUMBER | OE Order Header Identifier | ||
OE_ORDER_NUM | NUMBER | OE Order Number | ||
OE_ORDER_LINE_ID | NUMBER | OE Order Line Identifier | ||
OE_ORDER_LINE_NUM | NUMBER | OE Order Line Number | ||
CUSTOMER_ID | NUMBER | Customer Identifier | ||
CUSTOMER_SITE_ID | NUMBER | Customer Site Identifier | ||
CUSTOMER_ITEM_NUM | VARCHAR2 | (50) | Customer Item Number | |
PLL_NOTE_TO_RECEIVER | VARCHAR2 | (2000) | PO Shipment Note to Receiver | |
SECONDARY_ORDERED_QTY | NUMBER | Secondary Ordered Quantity | ||
SECONDARY_ORDERED_UOM | VARCHAR2 | (25) | Secondary Ordered Unit of Measure | |
QC_GRADE | VARCHAR2 | (150) | QC Grade | |
LPN_ID | NUMBER | LPN Identifier | ||
SECONDARY_DEFAULT_IND | VARCHAR2 | (30) | Secondary Default | |
ORG_ID | NUMBER | Organization identifier | ||
OE_ORDER_SHIP_NUM | NUMBER | OE Order Shipment Number |
APPS.INL_IR_SOURCE_LINES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
This view shows expected receipts from Purchase Orders.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_CHKBOX | CHAR | (1) | Line Checkbox | |
SOURCE_TYPE_CODE | VARCHAR2 | (8) | Source Type Code | |
RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | Receipt Source Code | |
ORDER_TYPE_CODE | VARCHAR2 | (30) | Order Type Code | |
ORDER_TYPE | VARCHAR2 | (30) | Order Type | |
PO_HEADER_ID | NUMBER | PO Header Identifier | ||
PO_NUMBER | VARCHAR2 | (20) | PO Number | |
PO_LINE_ID | NUMBER | PO Line Identifier | ||
PO_LINE_NUMBER | NUMBER | PO Line Number | ||
PO_LINE_LOCATION_ID | NUMBER | PO Shipment Identifier | ||
PO_SHIPMENT_NUMBER | NUMBER | PO Shipment Number | ||
PO_RELEASE_ID | NUMBER | PO Release Identifier | ||
PO_RELEASE_NUMBER | NUMBER | PO Release Number | ||
REQ_HEADER_ID | NUMBER | Requisition Header Identifier | ||
REQ_NUMBER | VARCHAR2 | (20) | Requisition Number | |
REQ_LINE_ID | NUMBER | Requisition Line Identifier | ||
REQ_LINE | NUMBER | Requisition Line | ||
REQ_DISTRIBUTION_ID | NUMBER | Requisition Distribution Identifier | ||
RCV_SHIPMENT_HEADER_ID | NUMBER | Receiving Shipment Header Identifier | ||
RCV_SHIPMENT_NUMBER | VARCHAR2 | (30) | Receiving Shipment Number | |
RCV_SHIPMENT_LINE_ID | NUMBER | Receiving Shipment Line Identifier | ||
RCV_LINE_NUMBER | NUMBER | Receiving Line Number | ||
FROM_ORGANIZATION_ID | NUMBER | From Organization Identifier | ||
TO_ORGANIZATION_ID | NUMBER | Destination Inventory Organization Identifier | ||
VENDOR_ID | NUMBER | Vendor Identifier | ||
SOURCE | VARCHAR2 | (360) | Source | |
VENDOR_SITE_ID | NUMBER | Vendor Site Identifier | ||
OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Outside Operation Flag | |
ITEM_ID | NUMBER | Inventory Item Identifier | ||
PRIMARY_UOM | VARCHAR2 | (25) | Primary Unit of Measure | |
PRIMARY_UOM_CLASS | VARCHAR2 | (10) | Primary Unit of Measure Class | |
ITEM_ALLOWED_UNITS_CODE | NUMBER | Inventory Item Allowed Units | ||
ITEM_LOCATOR_CONTROL | NUMBER | Inventory Item Locator Control | ||
RESTRICT_LOCATORS_CODE | VARCHAR2 | (1) | Restrict Locators Code | |
RESTRICT_SUBINVENTORIES_CODE | VARCHAR2 | (1) | Restrict Subinventories Code | |
SHELF_LIFE_CODE | NUMBER | Shelf Life Code | ||
SHELF_LIFE_DAYS | NUMBER | Shelf Life Days | ||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | Serial Number Control Code | ||
LOT_CONTROL_CODE | NUMBER | Lot Control Code | ||
ITEM_REV_CONTROL_FLAG_TO | VARCHAR2 | (1) | Inventory Item Revision Control Flag To | |
ITEM_REV_CONTROL_FLAG_FROM | VARCHAR2 | (1) | Inventory Item Revision Control Flag From | |
ITEM_NUMBER | VARCHAR2 | (40) | Inventory Item Number | |
ITEM_REVISION | VARCHAR2 | (3) | Inventory Item Revision | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory Item Description | |
ITEM_CATEGORY_ID | NUMBER | Inventory Item Category Identifier | ||
HAZARD_CLASS | VARCHAR2 | (40) | Hazard Class | |
UN_NUMBER | VARCHAR2 | (25) | UN Number | |
VENDOR_ITEM_NUMBER | VARCHAR2 | (25) | Vendor Item Number | |
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
SHIP_TO_LOCATION | VARCHAR2 | (60) | Ship To Location Identifier | |
PACKING_SLIP | VARCHAR2 | (25) | Packing Slip | |
ROUTING_ID | NUMBER | Routing Identifier | ||
ROUTING_NAME | VARCHAR2 | (80) | Routing Name | |
NEED_BY_DATE | DATE | Need By Date | ||
EXPECTED_RECEIPT_DATE | DATE | Expecte Arrival Date | ||
ORDERED_QTY | NUMBER | Ordered Quantity | ||
ORDERED_UOM | VARCHAR2 | (25) | Ordered Unit of Measure | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL Transaction Code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | Government Context | |
INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Inspection Required Flag | |
RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Receipt Required Flag | |
ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | Enforce Ship to Location Code | |
UNIT_PRICE | NUMBER | Unit Price | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to Receiver | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination Type | |
DELIVER_TO_PERSON_ID | NUMBER | Deliver to Person Identifier | ||
DELIVER_TO_LOCATION_ID | NUMBER | Deliver to Location Identifier | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Destination Subinventory | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
CLOSED_CODE | VARCHAR2 | (30) | Closed Code | |
ASN_TYPE | VARCHAR2 | (25) | ASN Type | |
BILL_OF_LADING | VARCHAR2 | (25) | Bill of Lading | |
SHIPPED_DATE | DATE | Shipped Date | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | Freight Carrier Code | |
WAYBILL_AIRBILL_NUM | VARCHAR2 | (20) | Waybill/Airbill Number | |
FREIGHT_BILL_NUM | VARCHAR2 | (35) | Freight Bill Number | |
VENDOR_LOT_NUM | VARCHAR2 | (30) | Vendor Lot Number | |
CONTAINER_NUM | VARCHAR2 | (35) | Container Number | |
TRUCK_NUM | VARCHAR2 | (35) | Truck Number | |
BAR_CODE_LABEL | VARCHAR2 | (35) | Bar Code Label | |
RATE_TYPE_DISPLAY | VARCHAR2 | (30) | Rate Type Display | |
MATCH_OPTION | VARCHAR2 | (25) | Match Option | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Country of Origin | |
OE_ORDER_HEADER_ID | NUMBER | OE Order Header Identifier | ||
OE_ORDER_NUM | NUMBER | OE Order Number | ||
OE_ORDER_LINE_ID | NUMBER | OE Order Line Identifier | ||
OE_ORDER_LINE_NUM | NUMBER | OE Order Line Number | ||
CUSTOMER_ID | NUMBER | Customer Identifier | ||
CUSTOMER_SITE_ID | NUMBER | Customer Site Identifier | ||
CUSTOMER_ITEM_NUM | VARCHAR2 | (50) | Customer Item Number | |
PLL_NOTE_TO_RECEIVER | VARCHAR2 | (2000) | PO Shipment Note to Receiver | |
SECONDARY_ORDERED_QTY | NUMBER | Secondary Ordered Quantity | ||
SECONDARY_ORDERED_UOM | VARCHAR2 | (25) | Secondary Ordered Unit of Measure | |
QC_GRADE | VARCHAR2 | (150) | QC Grade | |
LPN_ID | NUMBER | LPN Identifier | ||
SECONDARY_DEFAULT_IND | VARCHAR2 | (30) | Secondary Default | |
ORG_ID | NUMBER | Organization identifier | ||
OE_ORDER_SHIP_NUM | NUMBER | OE Order Shipment Number | ||
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | (15) | Party Site Identifier |
APPS.INL_PO_SOURCE_LINES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
This view shows expected receipts from Return Material Authorizations.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_CHKBOX | CHAR | (1) | Line Checkbox | |
SOURCE_TYPE_CODE | VARCHAR2 | (8) | Source Type Code | |
RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | Receipt Source Code | |
ORDER_TYPE_CODE | VARCHAR2 | (30) | Order Type Code | |
ORDER_TYPE | VARCHAR2 | (30) | Order Type | |
PO_HEADER_ID | NUMBER | PO Header Identifier | ||
PO_NUMBER | VARCHAR2 | (20) | PO Number | |
PO_LINE_ID | NUMBER | PO Line Identifier | ||
PO_LINE_NUMBER | NUMBER | PO Line Number | ||
PO_LINE_LOCATION_ID | NUMBER | PO Shipment Identifier | ||
PO_SHIPMENT_NUMBER | NUMBER | PO Shipment Number | ||
PO_RELEASE_ID | NUMBER | PO Release Identifier | ||
PO_RELEASE_NUMBER | NUMBER | PO Release Number | ||
REQ_HEADER_ID | NUMBER | Requisition Header Identifier | ||
REQ_NUMBER | VARCHAR2 | (20) | Requisition Number | |
REQ_LINE_ID | NUMBER | Requisition Line Identifier | ||
REQ_LINE | NUMBER | Requisition Line | ||
REQ_DISTRIBUTION_ID | NUMBER | Requisition Distribution Identifier | ||
RCV_SHIPMENT_HEADER_ID | NUMBER | Receiving Shipment Header Identifier | ||
RCV_SHIPMENT_NUMBER | VARCHAR2 | (30) | Receiving Shipment Number | |
RCV_SHIPMENT_LINE_ID | NUMBER | Receiving Shipment Line Identifier | ||
RCV_LINE_NUMBER | NUMBER | Receiving Line Number | ||
FROM_ORGANIZATION_ID | NUMBER | From Organization Identifier | ||
TO_ORGANIZATION_ID | NUMBER | Destination Inventory Organization Identifier | ||
VENDOR_ID | NUMBER | Vendor Identifier | ||
SOURCE | VARCHAR2 | (360) | Source | |
VENDOR_SITE_ID | NUMBER | Vendor Site Identifier | ||
OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Outside Operation Flag | |
ITEM_ID | NUMBER | Inventory Item Identifier | ||
PRIMARY_UOM | VARCHAR2 | (25) | Primary Unit of Measure | |
PRIMARY_UOM_CLASS | VARCHAR2 | (10) | Primary Unit of Measure Class | |
ITEM_ALLOWED_UNITS_CODE | NUMBER | Inventory Item Allowed Units | ||
ITEM_LOCATOR_CONTROL | NUMBER | Inventory Item Locator Control | ||
RESTRICT_LOCATORS_CODE | VARCHAR2 | (1) | Restrict Locators Code | |
RESTRICT_SUBINVENTORIES_CODE | VARCHAR2 | (1) | Restrict Subinventories Code | |
SHELF_LIFE_CODE | NUMBER | Shelf Life Code | ||
SHELF_LIFE_DAYS | NUMBER | Shelf Life Days | ||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | Serial Number Control Code | ||
LOT_CONTROL_CODE | NUMBER | Lot Control Code | ||
ITEM_REV_CONTROL_FLAG_TO | VARCHAR2 | (1) | Inventory Item Revision Control Flag To | |
ITEM_REV_CONTROL_FLAG_FROM | VARCHAR2 | (1) | Inventory Item Revision Control Flag From | |
ITEM_NUMBER | VARCHAR2 | (40) | Inventory Item Number | |
ITEM_REVISION | VARCHAR2 | (3) | Inventory Item Revision | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory Item Description | |
ITEM_CATEGORY_ID | NUMBER | Inventory Item Category Identifier | ||
HAZARD_CLASS | VARCHAR2 | (40) | Hazard Class | |
UN_NUMBER | VARCHAR2 | (25) | UN Number | |
VENDOR_ITEM_NUMBER | VARCHAR2 | (25) | Vendor Item Number | |
SHIP_TO_LOCATION_ID | NUMBER | Ship To Location Identifier | ||
SHIP_TO_LOCATION | VARCHAR2 | (60) | Ship To Location Identifier | |
PACKING_SLIP | VARCHAR2 | (25) | Packing Slip | |
ROUTING_ID | NUMBER | Routing Identifier | ||
ROUTING_NAME | VARCHAR2 | (80) | Routing Name | |
NEED_BY_DATE | DATE | Need By Date | ||
EXPECTED_RECEIPT_DATE | DATE | Expecte Arrival Date | ||
ORDERED_QTY | NUMBER | Ordered Quantity | ||
ORDERED_UOM | VARCHAR2 | (25) | Ordered Unit of Measure | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL Transaction Code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | Government Context | |
INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Inspection Required Flag | |
RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Receipt Required Flag | |
ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | Enforce Ship to Location Code | |
UNIT_PRICE | NUMBER | Unit Price | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to Receiver | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination Type | |
DELIVER_TO_PERSON_ID | NUMBER | Deliver to Person Identifier | ||
DELIVER_TO_LOCATION_ID | NUMBER | Deliver to Location Identifier | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Destination Subinventory | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
CLOSED_CODE | VARCHAR2 | (30) | Closed Code | |
ASN_TYPE | VARCHAR2 | (25) | ASN Type | |
BILL_OF_LADING | VARCHAR2 | (25) | Bill of Lading | |
SHIPPED_DATE | DATE | Shipped Date | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | Freight Carrier Code | |
WAYBILL_AIRBILL_NUM | VARCHAR2 | (20) | Waybill/Airbill Number | |
FREIGHT_BILL_NUM | VARCHAR2 | (35) | Freight Bill Number | |
VENDOR_LOT_NUM | VARCHAR2 | (30) | Vendor Lot Number | |
CONTAINER_NUM | VARCHAR2 | (35) | Container Number | |
TRUCK_NUM | VARCHAR2 | (35) | Truck Number | |
BAR_CODE_LABEL | VARCHAR2 | (35) | Bar Code Label | |
RATE_TYPE_DISPLAY | VARCHAR2 | (30) | Rate Type Display | |
MATCH_OPTION | VARCHAR2 | (25) | Match Option | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Country of Origin | |
OE_ORDER_HEADER_ID | NUMBER | OE Order Header Identifier | ||
OE_ORDER_NUM | NUMBER | OE Order Number | ||
OE_ORDER_LINE_ID | NUMBER | OE Order Line Identifier | ||
OE_ORDER_LINE_NUM | NUMBER | OE Order Line Number | ||
CUSTOMER_ID | NUMBER | Customer Identifier | ||
CUSTOMER_SITE_ID | NUMBER | Customer Site Identifier | ||
CUSTOMER_ITEM_NUMBER | VARCHAR2 | (50) | Customer Item Number | |
PLL_NOTE_TO_RECEIVER | VARCHAR2 | (2000) | PO Shipment Note to Receiver | |
SECONDARY_ORDERED_QTY | NUMBER | Secondary Ordered Quantity | ||
SECONDARY_ORDERED_UOM | VARCHAR2 | (25) | Secondary Ordered Unit of Measure | |
QC_GRADE | VARCHAR2 | (150) | QC Grade | |
LPN_ID | NUMBER | LPN Identifier | ||
SECONDARY_DEFAULT_IND | VARCHAR2 | (30) | Secondary Default | |
ORG_ID | NUMBER | Organization identifier | ||
OE_ORDER_SHIP_NUM | NUMBER | OE Order Shipment Number | ||
PARTY_ID | NUMBER | (15) | Party Identifier |
APPS.INL_RMA_SOURCE_LINES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
This view shows landed cost information for Shipment Lines
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
SHIP_LINE_GROUP_ID | NUMBER | Line Group Identifier | ||
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
SHIP_LINE_NUM | NUMBER | Shipment Line Number | ||
ORGANIZATION_ID | NUMBER | Y | Inventory Organization Identifier | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
ITEM_PRICE | NUMBER | Inventory Item Price | ||
CHARGES | NUMBER | Amount of Charges | ||
TAXES | NUMBER | Taxes Amount | ||
PRIMARY_QTY | NUMBER | Primary Quantity | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure Code | |
UNIT_LANDED_COST | NUMBER | Unit Landed Cost |
A public view which may be useful for custom reporting or other data requirements.
This view shows landed cost information for a Shipment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Y | Shipment Identifier | |
ADJUSTMENT_NUM | NUMBER | Y | Adjustment Number | |
ORGANIZATION_ID | NUMBER | Y | Inventory Organization Identifier | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
ITEM_PRICE | NUMBER | Inventory Item Price | ||
CHARGES | NUMBER | Amount of Charges | ||
TAXES | NUMBER | Taxes Amount | ||
PRIMARY_QTY | NUMBER | Primary Quantity | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure Code | |
UNIT_LANDED_COST | NUMBER | Unit Landed Cost |
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
SHIP_LINE_TYPE_ID | NUMBER | Y | Shipment Line Type Identifier | |
SHIP_LINE_TYPE_CODE | VARCHAR2 | (15) | Y | Shipment Line Type Code |
SHIP_LINE_TYPE_NAME | VARCHAR2 | (30) | Y | Shipment Line Type Name |
DFLT_LANDED_COST_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amounts of the line should be considered in the landed cost |
DFLT_ALLOCATION_ENABLED_FLAG | VARCHAR2 | (1) | Y | "Y" or "N" flag indicating whether the amounts of the line are associable |
ACTIVE_FROM_DATE | DATE | Y | Active From Date | |
ACTIVE_TO_DATE | DATE | Active To Date | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
A public view which may be useful for custom reporting or other data requirements.
This view shows overall information on Shipments and their sources such as Purchase Orders, Internal Requisitions and RMA.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
LOCATION_ID | NUMBER | |||
ORG_ID | NUMBER | |||
SHIP_TYPE_ID | NUMBER | |||
SHIP_TYPE_CODE | VARCHAR2 | (15) | ||
SHIP_NUM | VARCHAR2 | (25) | ||
SHIP_DATE | DATE | |||
SHIP_STATUS_CODE | VARCHAR2 | (30) | ||
PENDING_MATCHING_FLAG | VARCHAR2 | (1) | ||
SHIP_LINE_GROUP_ID | NUMBER | Line Group Identifier | ||
SHIP_LINE_GROUP_NUM | NUMBER | Line Group Number | ||
SHIP_LINE_GROUP_REFERENCE | VARCHAR2 | (30) | Line Group Reference | |
SRC_TYPE_CODE | VARCHAR2 | (30) | Source Type Code | |
GROUP_PARTY_ID | NUMBER | Group Party Identifier | ||
GROUP_PARTY_NAME | VARCHAR2 | (360) | Group Party Name | |
GROUP_PARTY_SITE_ID | NUMBER | Group Party Site Identifier | ||
GROUP_PARTY_SITE_NAME | VARCHAR2 | (240) | Group Party Site Name | |
GROUP_ORGANIZATION_ID | NUMBER | Group Inventory Organization Identifier | ||
GROUP_ORGANIZATION_NAME | VARCHAR2 | (240) | Group Inventory Organization Name | |
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
SHIP_LINE_NUM | NUMBER | Shipment Line Number | ||
EST_SHIP_LINE_ID | NUMBER | Estimated Shipment Line Identifier | ||
EST_TXN_UNIT_PRICE | NUMBER | Estimated Transaction Unit Price | ||
SHIP_LINE_SRC_TYPE_CODE | VARCHAR2 | (30) | Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES | |
SHIP_LINE_SOURCE_ID | NUMBER | Source Identifier, according to the Source Type Code | ||
SHIP_LINE_TYPE_CODE | VARCHAR2 | (15) | Shipment Line Type Code | |
ITEM_ID | NUMBER | Inventory Item Identifier | ||
ITEM | VARCHAR2 | (40) | Inventory Item Segment 1 | |
ITEM_REVISION | VARCHAR2 | (3) | Inventory Item Revision | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory Item Description | |
TXN_QTY | NUMBER | Transaction Quantity | ||
TXN_UOM_CODE | VARCHAR2 | (3) | Transaction Unit of Measure | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure Code | |
PRIMARY_QTY | NUMBER | Primary Quantity | ||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | Secondary Unit of Measure | |
SECONDARY_QTY | NUMBER | Secondary Quantity | ||
TXN_UNIT_PRICE | NUMBER | Transaction Unit Price | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
LINE_AMT | NUMBER | Line Amount | ||
SRC_ID | NUMBER | Source Identifier | ||
SRC_TYPE | VARCHAR2 | (80) | Source Type Code | |
SRC_NUMBER | VARCHAR2 | (40) | Source Number | |
SRC_DESCRIPTION | VARCHAR2 | (240) | Source Description | |
SRC_ORG_ID | NUMBER | Source Operating Unit | ||
SRC_PARTY_ID | NUMBER | Source Party Identifier | ||
SRC_PARTY_NAME | VARCHAR2 | (360) | Source Party Name | |
SRC_PARTY_SITE_ID | NUMBER | Source Party Site Identifier | ||
SRC_PARTY_SITE_NAME | VARCHAR2 | (240) | Source Party Site Name | |
SRC_VENDOR_ID | NUMBER | Source Vendor Identifier | ||
SRC_VENDOR_NAME | VARCHAR2 | (240) | Source Vendor Name | |
SRC_VENDOR_SITE_ID | NUMBER | Source Vendor Site Identifier | ||
SRC_VENDOR_SITE_CODE | VARCHAR2 | (15) | Source Vendor Site Code | |
SRC_ORGANIZATION_ID | NUMBER | Source Inventory Organization Identifier | ||
SRC_LOCATION_ID | NUMBER | Source Location Identifier | ||
SRC_CUSTOMER_ID | NUMBER | Source Customer Identifier | ||
SRC_CUSTOMER_NAME | VARCHAR2 | (360) | Source Customer Name | |
SRC_CUSTOMER_NUMBER | VARCHAR2 | (30) | Source Customer Number | |
SRC_CUSTOMER_SITE_CODE | VARCHAR2 | (30) | Source Customer Site Code | |
SRC_CUST_ITEM_NUM | VARCHAR2 | (0) | Source Customer Item Number | |
SRC_RELEASE_NUM | NUMBER | Source Release Number | ||
SRC_RELEASE_ID | NUMBER | Source Release Identitier | ||
SRC_RELEASE_DATE | DATE | Source Release Date | ||
SRC_LINE_ID | NUMBER | Source Line Identifier | ||
SRC_LINE_NUM | NUMBER | Source Line Number | ||
SRC_SHIP_ID | NUMBER | Source Shipment Identifier | ||
SRC_SHIP_NUM | VARCHAR2 | (40) | Source Shipment Number | |
SRC_SHIPPED_DATE | DATE | Source Shipped Date | ||
SRC_QTY | NUMBER | Source Quantity | ||
SRC_ITEM_ID | NUMBER | Source Item Identifier | ||
SRC_ITEM_REVISION | VARCHAR2 | (3) | Source Item Revision | |
SRC_ITEM_DESCRIPTION | VARCHAR2 | (240) | Source Item Description | |
SRC_CONTAINER_NUM | VARCHAR2 | (35) | Source Customer Identifier | |
SRC_TRUCK_NUM | VARCHAR2 | (35) | Source Truck Number | |
SRC_BAR_CODE_LABEL | VARCHAR2 | (35) | Source Bar Code Label | |
SRC_DELIVER_TO_PERSON_ID | NUMBER | Source Deliver To Person Identifier | ||
SRC_VENDOR_ITEM_NUM | VARCHAR2 | (25) | Source Vendor Item Number | |
SRC_PACKING_SLIP | VARCHAR2 | (25) | Source Packing Slip | |
SRC_EMPLOYEE_ID | NUMBER | Source Employee Identifier | ||
SRC_FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | Source Freight Carrier Code | |
SRC_BILL_OF_LADING | VARCHAR2 | (25) | Source Container Number | |
SRC_ROUTING_ID | NUMBER | Source Routing Identifier | ||
SRC_INSPECTION_STATUS_CODE | VARCHAR2 | (25) | Source Inspection Status Code | |
SRC_TRANSACTION_DATE | DATE | Source Transaction Date |
APPS.INL_SHIP_OVERALL_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_TYPE_ID | NUMBER | Y | Shipment Type Identifier | |
SHIP_TYPE_CODE | VARCHAR2 | (15) | Y | Shipment Type Code |
SHIP_TYPE_NAME | VARCHAR2 | (30) | Y | Shipment Type Name |
TRD_PTIES_ALWD_CODE | VARCHAR2 | (1) | Y | Third Parties Allowed Code, taken from lookup INL_3RD_PARTIES_ALLOWED |
ACTIVE_FROM_DATE | DATE | Y | Active From Date | |
ACTIVE_TO_DATE | DATE | Active To Date | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |