Items can be assigned to a master organization or a child organization. When you assign an item to a child organization, all item-level attributes default down from the master organization only if the attribute column is null. The only exceptions are attributes under status control.Revisions always exist at the item organization-level. You need revision data for each item organization you update. If you choose not to use revisions table, do not include revisions in the biz doc. The item interface import assigns each item a beginning revision, using the default specified in the organization parameters.Script | Description |
wm_install_into_invitem.sql | Runs the scripts listed below, except the uninstall script. |
wm_into_invitem_pkg.sql | Installs WM_INV_ITEM_IMP_HANDLER_PKG. WM_HANDLE_INV_ITEM, which calls the WM_CONC_REQUEST. WM_REQUEST_SUBMIT procedure to submit the Item Import process. |
wm_into_invitem_seq.sql | Creates the following component: WM_MTL_SYSTEM_ITEMS_SETS_S, which creates the SET_PROCESS_ID. |
wm_drop_into_invitem.sql | Uninstalls all components created by wm_install_into_invitem.sql. |
setItemTxn1227.txpItemTxn1227.txpspecifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.specifyConcProgParams specifies the default parameter settings required for concurrent program execution. You should change these settings accordingly.bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).getCoverageScheduleId is a transformer that gets COVERAGE_SCHEDULE_ID querying Oracle Applications database using COVERAGE_SCHEDULE_NAME. This service also checks the null condition for queryParams (same as all other services which are being used in transformers). In case of null value passed to queryParams, this service exits.getFACategoryId is a transformer for mapping the business document that takes the ASSET_CATEGORY as input, and returns CATEGORY_ID.getFNDLookUpCode converts the incoming Lookup type to LOOKUP_CODE required by Oracle Applications database.getHazardClassId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes HAZARD_CLASS as the input parameter, and gets the HAZARD_CLASS_ID querying Oracle Applications database.getItemGroupId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes DESCRIPTION as input to get the corresponding ITEM_CATALOG_GROUP_ID querying Oracle Applications database.getLookUpCode is a transformer for the business document IData structure to the interface table IData structure. It takes LOOKUP_TYPE and MEANING as input parameters, and queries the table MFG_LOOKUPS to get the LOOKUP_CODE corresponding to the MEANING and TYPE.getPOVendorId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes VENDOR_NAME as the input parameter, and queries the table AP_SUPPLIERS to get the VENDOR_ID corresponding to the VENDOR_NAME.getPaymentTermId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes PAYMENT_TERM_NAME as the input parameter, and queries the table RA_TERMS_B to get the TERM_ID corresponding to the PAYMENT_TERM_NAME.getRoutingHeaderId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ROUTING_NAME as the input parameter, and queries the table RCV_ROUTING_HEADERS to get the ROUTING_HEADER_ID corresponding to the ROUTING_NAMEgetRuleId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes RULE_NAME as the input parameter, and queries the table RA_RULES to get the RULE_ID corresponding to the input parameters.getServiceableItemClassId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes SERVICEABLE_ITEM_CLASS_NAME as the input parameter, and queries the table CS_SERVICEABLE_ITEM_CLASSES to get the SERVICEABLE_ITEM_CLASS_ID corresponding to the SERVICEABLE_ITEM_CLASS_NAME.getTransactionSourceId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes TRANSACTION_SOURCE_TYPE_NAME as the input parameter, and queries the table MTL_TXN_SOURCE_TYPES to get the TRANSACTION_SOURCE_TYPE_NAME corresponding to the name.getProcessId is a transformer for mapping the business document IData structure to the interface table IData structure. There are two types of transactions: CREATE or UPDATE. Based on the transaction type used as an input parameter to this service, the service returns the associated process ID, and sets a flag to indicate whether the transaction is an insertion or an update.getOrgId takes ORGANIZATION_NAME as the input parameter, and queries the table ORG_ORGANIZATION_DEFINITIONS to get the ORGANIZATION_ID corresponding to the ORGANIZATION_NAME.getOracleAppsUserId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORACLE_APPS_USER_NAME as the input parameter from the business document, and queries the table FND_USER to get the USER_ID. The USER_ID information is required for insertion into the interface tables.getOASystemDateObject returns the Oracle Applications system date as a date object.getInventoryItemId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ITEM_CODE as the input parameter, and queries the table MTL_SYSTEM_ITEMS_B_KFV to get the INVENTORY_ITEM_ID corresponding to the current ORGANIZATION_NAME.getCodeCombinationId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes CONCATENATED_SEGMENTS as the input parameter, and queries the table GL_CODE_COMBINATIONS_KFV to get the CODE_COMBINATION_ID corresponding to the passed code.convertToDateObject gets the date string as input, and converts it to a date object.pickSequence gets the sequence name as an input, and picks up the next sequence for that particular one.getLocatorId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes LOCATOR and ORGANIZATION_NAME as the input parameter, and queries the view MTL_ITEM_LOCATIONS_KFV and the table ORG_ORGANIZATION_DEFINITIONS to get the INVENTORY_LOCATION_ID corresponding to the LOCATOR and ORGANIZATION_NAME.getEmplIdFromFullName converts the input of BUYER_FULL_NAME to a BUYER_ID.setItemTxn inserts data into the interface table. It extracts data from the IData structure that results from the bizDocMapping service, and puts the data into the Oracle Applications Item Import interface.importItem imports data to the production table from the interface table. It calls the services execItemConcProg, checkItemImportStatus, and getItemImport_ERR to execute the corresponding concurrent program that inserts data into the production table, and to generate the error/acknowledgement message. If the status of the execution is SUCCESS (returned by the service execItemConcProg), it checks for records in the interface table. If records are found, it then indicates an error during import. In this case, this service calls getItemImport_ERR to retrieve the errors. If no records are found, it comes out of the flow, indicating success of the data import process. If the status of the execution is FAILED, it comes out of execution. There can be two types of action on the record that must be imported: update and insert. This flow checks for the mode of action, and calls the appropriate import program.execItemConcProg invokes the stored procedure WM_INV_ITEM_IMP_HANDLER_PKG.WM_HANDLE_INV_ITEM. The procedure calls the corresponding concurrent subroutine to execute the data import process for the Item into Oracle Applications. This service returns Status ID, Request ID, Execution Status Message (for normal concurrent program completion), and database Stored Procedure error message (if an exception occurs in Stored Procedure execution).checkItemImportStatus checks the status of the execution by checking the Interface Table for any rejected records corresponding to the current REQUEST_ID. If the query does not return rows, it indicates a successful import. If the query returns rows, it indicates that the concurrent program could not import data successfully in the production tables of Oracle Applications.getItemImport_ERR service gets the error message that occurs during the data import to the production table from interface table. Based on the parameter REQUEST_ID, it scans the table MTL_TRANSACTIONS_INTERFACE to get the corresponding message.1.0. MTL_SYSTEM_ITEMS1.1. MTL_ITEM_CATEGORIES1.2. MTL_ITEM_REVISIONSField Name | Maps to Column | Description |
ITEM_NUMBER | ITEM_NUMBER | Segmented item number. |
ORGANIZATION_NAME | ORGANIZATION_ID | Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS. |
SUMMARY_FLAG | SUMMARY_FLAG | Required. Flexfield summary flag. |
ENABLED_FLAG | ENABLED_FLAG | |
START_DATE_ACTIVE | START_DATE_ ACTIVE | Flexfield segment start date. |
END_DATE_ACTIVE | END_DATE_ ACTIVE | Flexfield segment end date. |
DESCRIPTION | DESCRIPTION | Item description. |
BUYER_FULL_NAME | BUYER_ID | Derived AGENT_ID from PO_AGENTS and PER_ALL_PEOPLE_F, where PO_AGENTS.AGENT_ID = PER_ALL_PEOPLE_F. PERSON_ID. |
ACCOUNTING_RULE_NAME | ACCOUNTING_ RULE_ID | Derives the RULE_ID from RA_RULES. |
INVOICING_RULE_NAME | INVOICING_ RULE_ID | Derives the RULE_ID from RA_RULES. |
PURCHASING_ITEM_FLAG | PURCHASING_ ITEM_FLAG | |
SHIPPABLE_ITEM_FLAG | SHIPPABLE_ ITEM_FLAG | Indicates whether the item can be shipped (Y/N). |
CUSTOMER_ORDER_FLAG | CUSTOMER_ ORDER_FLAG | |
INTERNAL_ORDER_FLAG | INTERNAL_ ORDER_FLAG | |
SERVICE_ITEM_FLAG | SERVICE_ ITEM_FLAG | |
INVENTORY_ITEM_FLAG | INVENTORY_ ITEM_FLAG | |
ENG_ITEM_FLAG | ENG_ITEM_FLAG | Indicates engineering item (Y/N). |
INVENTORY_ASSET_FLAG | INVENTORY_ ASSET_FLAG | |
PURCHASING_ENABLED_ FLAG | PURCHASING_ ENABLED_FLAG | Indicates whether item can be purchased (Y/N). |
CUSTOMER_ORDER_ ENABLED_FLAG | CUSTOMER_ ORDER_ ENABLED_FLAG | Indicates whether item can be customer ordered (Y/N). |
INTERNAL_ORDER_ ENABLED_FLAG | INTERNAL_ ORDER_ ENABLED_FLAG | Indicates whether item can be internally ordered (Y/N). |
SO_TRANSACTIONS_FLAG | SO_ TRANSACTIONS_ FLAG | Sales order transaction (Y/N). |
MTL_TRANSACTIONS_ ENABLED_FLAG | MTL_TRANSACTIONS_ ENABLED_FLAG | Indicates whether item is transactable (Y/N). |
STOCK_ENABLED_FLAG | STOCK_ENABLED_FLAG | Indicates item can be stocked (Y/N). |
BOM_ENABLED_FLAG | BOM_ENABLED_FLAG | Indicates whether item can appear on a Bill of Materials. |
BUILD_IN_WIP_FLAG | BUILD_IN_WIP_FLAG | Indicates whether item can be built in WIP. |
REVISION_QTY_CONTROL | REVISION_QTY_ CONTROL_CODE | Derived LOOKUP_CODE from MFG_LOOKUPS where LOOKUP_TYPE is MTL_ENG_QUANTITY for meaning column. |
CATALOG_GROUP_ DESCRIPTION | ITEM_CATALOG_ GROUP_ID | Derives ITEM_CATALOG_GROUP_ID from MTL_ITEM_CATALOG_GROUPS. |
CATALOG_STATUS_FLAG | CATALOG_ STATUS_FLAG | Indicates whether item is catalog complete (Y/N). |
RETURNABLE_FLAG | RETURNABLE_FLAG | Indicates whether item can be returned (Y/N). |
DEFAULT_SHIPPING_ ORGANIZATION_NAME | DEFAULT_ SHIPPING_ORG | Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS. |
COLLATERAL_FLAG | COLLATERAL_FLAG | Indicates whether the item is a collateral item (Y/N). |
TAXABLE_FLAG | TAXABLE_FLAG | Indicates whether item is taxable (Y/N). |
QTY_RCV_EXCEPTION_ CODE | QTY_RCV_ EXCEPTION_CODE | Use: NONE for no receiving control enforced.REJECT for preventing receipt of goods or services.WARNING for displaying warning message. |
ALLOW_ITEM_DESC_ UPDATE_FLAG | ALLOW_ ITEM_DESC_ UPDATE_FLAG | Indicates whether to allow item description updates on purchase order lines (Y/N). |
INSPECTION_ REQUIRED_FLAG | INSPECTION_FLAG | Indicates whether inspection is required (Y/N). |
RECEIPT_REQUIRED_FLAG | RECEIPT_FLAG | Indicates whether supplier receipt is required (Y/N). |
MARKET_PRICE | MARKET_PRICE | Purchasing market price. |
HAZARD_CLASS | HAZARD_CLASS_ID | Derives the HAZARD_CLASS_ID from PO_HAZARD_ CLASSES_B. |
RFQ_REQUIRED_FLAG | RFQ_REQUIRED_FLAG | Indicates whether RFQ is required (Y/N). |
QTY_RCV_TOLERANCE | QTY_RCV_ TOLERANCE | Maximum permissible over receipt percentage. |
LIST_PRICE_PER_UNIT | LIST_PRICE_PER_UNIT | |
UN_NUMBER_ID | UN_NUMBER_ID | UN purchasing number. |
PRICE_TOLERANCE_ PERCENT | PRICE_TOLERANCE_ PERCENT | Price tolerance percentage. |
ASSET_CATEGORY | ASSET_CATEGORY_ID | Derives the ASSET_CATEGORY_ID from FA_CATEGORIES_ B_KFV for the concatenated segment. |
ROUNDING_FACTOR | ROUNDING_FACTOR | Determines order quantity. |
UNIT_OF_ISSUE | UNIT_OF_ISSUE | |
ENFORCE_SHIP_TO_ LOCATION_CODE | ENFORCE_ SHIP_TO_ LOCATION_CODE | Requires receipt location to match ship to location. |
ALLOW_SUBSTITUTE_ RECEIPTS_FLAG | ALLOW_ SUBSTITUTE_ RECEIPTS_FLAG | Indicates whether substitute receipts are allowed (Y/N). |
ALLOW_UNORDERED_ RECEIPTS_FLAG | ALLOW_ UNORDERED_ RECEIPTS_FLAG | Indicates whether to allow unordered receipts (Y/N). |
ALLOW_EXPRESS_ DELIVERY_FLAG | ALLOW_ EXPRESS_ DELIVERY_FLAG | Indicates whether to allow express delivery (Y/N). |
DAYS_EARLY_RECEIPT_ ALLOWED | DAYS_EARLY_ RECEIPT_ALLOWED | |
DAYS_LATE_RECEIPT_ ALLOWED | DAYS_LATE_ RECEIPT_ALLOWED | |
RECEIPT_DAYS_EXCEPTION_ CODE | RECEIPT_DAYS_ EXCEPTION_CODE | Use: NONE for no receiving control enforced.REJECT for preventing receipt of goods or services.WARNING for displaying warning message. |
RECEIVING_ROUTING_NAME | RECEIVING_ ROUTING_ID | Derives ROUTING_HEADER_ID from RCV_ROUTING_HEADERS. |
INVOICE_CLOSE_ TOLERANCE | INVOICE_ CLOSE_ TOLERANCE | |
RECEIVE_CLOSE_ TOLERANCE | RECEIVE_ CLOSE_ TOLERANCE | |
AUTO_LOT_ALPHA_PREFIX | AUTO_LOT_ ALPHA_PREFIX | Lot prefix for lot number controlled item. |
START_AUTO_LOT_NUMBER | START_AUTO_ LOT_NUMBER | |
LOT_CONTROL | LOT_ CONTROL_CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_LOT_CONTROL for the meaning column. Use: 1 for No lot control.2 for Full lot control. |
SHELF_LIFE | SHELF_LIFE_CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SHELF_LIFE for the meaning column. Use: 1 for No shelf life control.2 for Item shelf life days.4 for User-defined expiration date. |
SHELF_LIFE_DAYS | SHELF_LIFE_DAYS | |
SERIAL_NUMBER_ CONTROL_CODE | SERIAL_NUMBER_ CONTROL_CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SERIAL_NUMBER for the meaning column. Use: 1 for No serial number control,2 for Predefined serial numbers,5 for Dynamic entry at inventory receipt,6 for Dynamic entry at sales order issue. |
START_AUTO_SERIAL_ NUMBER | START_AUTO_ SERIAL_NUMBER | Start auto serial number. |
AUTO_SERIAL_ALPHA_ PREFIX | AUTO_SERIAL_ ALPHA_PREFIX | Serial number prefix. |
SOURCE_TYPE | SOURCE_TYPE | Use either Inventory or Supplier. Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SOURCE_TYPES for the meaning column. |
SOURCE_ORGANIZATION_ NAME | SOURCE_ ORGANIZATION_ID | Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS. |
SOURCE_SUBINVENTORY | SOURCE_ SUBINVENTORY | |
EXPENSE_ACCOUNT | EXPENSE_ ACCOUNT | Derives CODE_COMBINATION_ID from GL_CODE_ COMBINATIONS_KFV. |
ENCUMBRANCE_ACCOUNT | ENCUMBRANCE_ ACCOUNT | Derives CODE_COMBINATION_ID from GL_CODE_ COMBINATIONS_KFV. |
RESTRICT_SUBINVENTORIES | RESTRICT_ SUBINVENTORIES_ CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SUBINVENTORY_ RESTRICTIONS for the meaning column. Use: 1 for Subinventories restricted to predefined list.2 for Subinventories not restricted to predefined list. |
UNIT_WEIGHT | UNIT_WEIGHT | |
WEIGHT_UOM_CODE | WEIGHT_ UOM_CODE | Weight unit of measure code. |
VOLUME_UOM_CODE | VOLUME_ UOM_CODE | Volume unit of measure code. |
UNIT_VOLUME | UNIT_VOLUME | |
RESTRICT_LOCATORS | RESTRICT_ LOCATORS_ CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_LOCATOR_ RESTRICTIONS for the meaning column. Use: 1 for Locators restricted to predefined list, or2 for Locators not restricted to predefined list. |
LOCATION_CONTROL | LOCATION_ CONTROL_ CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_LOCATION_ CONTROL for the meaning column. Use: 1 for No locator control.2 for Previously specified locator control.3 for Dynamic entry locator control.4 for Locator control determined at subinventory level.5 for Locator control determined at item level. |
SHINKRAGE_RATE | SHINKRAGE_ RATE | Planned shrinkage rate. |
ACCEPTABLE_EARLY_DAYS | ACCEPTABLE_ EARLY_DAYS | Days an order may be early before rescheduling is recommended. |
PLANNING_TIME_FENCE | PLANNING_ TIME_ FENCE_CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_TIME_FENCE for the meaning column. Use: 1 for Cumulative total lead time,2 for Cumulative manufacturing lead time.3 for Total lead time.4 for User-defined time fence. |
DEMAND_TIME_FENCE | DEMAND_TIME_ FENCE_CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_TIME_FENCE for the meaning column. Use: 1 for Cumulative total lead time.2 for Cumulative manufacturing lead time.3 for Total lead time.4 for User-defined time fence. |
LEAD_TIME_LOT_SIZE | LEAD_TIME_LOT_SIZE | Lead time lot size. |
STD_LOT_SIZE | STD_LOT_SIZE | Standard lot size. |
CUM_MANUFACTURING_ LEAD_TIME | CUM_ MANUFACTURING_ LEAD_TIME | Cumulative lead time. |
OVERRUN_PERCENTAGE | OVERRUN_ PERCENTAGE | MRP repetitive overrun rate. |
MRP_CALCULATE_ATP_FLAG | MRP_CALCULATE_ ATP_FLAG | |
ACCEPTABLE_RATE_INCREASE | ACCEPTABLE_ RATE_INCREASE | MRP repetitive acceptable rate increase. |
ACCEPTABLE_RATE_DECREASE | ACCEPTABLE_ RATE_DECREASE | MRP repetitive acceptable rate decrease. |
CUMULATIVE_TOTAL_LEAD_TIME | CUMULATIVE_ TOTAL_LEAD_ TIME | |
PLANNING_TIME_FENCE_DAYS | PLANNING_TIME_ FENCE_DAYS | |
DEMAND_TIME_FENCE_DAYS | DEMAND_TIME_ FENCE_DAYS | |
END_ASSEMBLY_PEGGING_ FLAG | END_ASSEMBLY_ PEGGING_FLAG | |
REPETITIVE_PLANNING_ FLAG | REPETITIVE_ PLANNING_FLAG | |
PLANNING_EXCEPTION_SET | PLANNING_ EXCEPTION_SET | Exception control set. |
BOM_ITEM_TYPE | BOM_ITEM_TYPE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE is BOM_ITEM_TYPE for meaning column. |
PICK_COMPONENTS_FLAG | PICK_ COMPONENTS_ FLAG | |
REPLENISH_TO_ORDER_FLAG | REPLENISH_TO_ ORDER_FLAG | |
BASE_ITEM | BASE_ITEM_ID | Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the ITEM and Organization. |
ATP_COMPONENTS_FLAG | ATP_ COMPONENTS_ FLAG | Required. |
ATP_FLAG | ATP_FLAG | Required. Indicates whether ATP must be checked when ordering the item. |
FIXED_LEAD_TIME | FIXED_LEAD_TIME | Fixed portion of the assembly lead time. |
VARIABLE_LEAD_TIME | VARIABLE_ LEAD_TIME | Variable lead time. |
WIP_SUPPLY_LOCATOR | WIP_SUPPLY_ LOCATOR_ID | Derives LOCATION_ID from MTL_ITEM_LOCATIONS_KFV for the concatenated segment. |
WIP_SUPPLY_TYPE | WIP_SUPPLY_TYPE | Derived from MFG_LOOKUPS for LOOKUP_TYPE.WIP_SUPPLY. |
WIP_SUPPLY_SUBINVENTORY | WIP_SUPPLY_ SUBINVENTORY | |
PRIMARY_UOM_CODE | PRIMARY_ UOM_CODE | Primary unit of measure code. |
ALLOWED_UNITS_LOOKUP | ALLOWED_UNITS_ LOOKUP_CODE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_CONVERSION_TYPE for the meaning column’s Allowed Units Lookup Code. |
COST_OF_SALES_ACCOUNT | COST_OF_ SALES_ACCOUNT | Derives ACCOUNT_ID from GL_CODE_COMBINATIONS_KFV for the concatenated segment. |
SALES_ACCOUNT | SALES_ACCOUNT | Derives ACCOUNT_ID from GL_CODE_COMBINATIONS_ KFV for the concatenated segment. |
DEFAULT_INCLUDE_IN_ ROLLUP_FLAG | DEFAULT_ INCLUDE_IN_ ROLLUP_FLAG | Indicates whether to include default value in cost rollup (Y/N). |
INVENTORY_ITEM_ STATUS_CODE | INVENTORY_ ITEM_STATUS_ CODE | |
INVENTORY_PLANNING | INVENTORY_ PLANNING_ CODE | Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_MATERIAL_PLANNING Inventory Planning Code. |
PLANNER_CODE | PLANNER_CODE | |
PLANNING_MAKE_BUY | PLANNING_ MAKE_BUY_CODE | Indicates whether item is planned as manufactured or purchased. Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_PLANNING_MAKE_BUY. |
FIXED_LOT_MULTIPLIER | FIXED_LOT_ MULTIPLIER | |
ROUNDING_CONTROL_TYPE | ROUNDING_ CONTROL_TYPE | Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_ROUNDING for the meaning column. |
CARRYING_COST | CARRYING_COST | Annual carrying cost. |
POSTPROCESSING_LEAD_ TIME | POSTPROCESSING_ LEAD_TIME | |
PREPROCESSING_LEAD_ TIME | PREPROCESSING_ LEAD_TIME | |
FULL_LEAD_TIME | FULL_LEAD_ TIME | |
ORDER_COST | ORDER_COST | |
MRP_SAFETY_STOCK_PERCENT | MRP_SAFETY_ STOCK_PERCENT | |
MRP_SAFETY_STOCK | MRP_SAFETY_ STOCK_CODE | Derives the LOOKUP_CODE from MFG_LOOKUPS for LOOKUP_TYPE. MTL_SAFETY_STOCK_TYPE. |
MIN_MINMAX_QUANTITY | MIN_MINMAX_ QUANTITY | Minimum minmax quantity. |
MAX_MINMAX_QUANTITY | MAX_MINMAX_ QUANTITY | Maximum minmax quantity. |
MINIMUM_ORDER_QUANTITY | MINIMUM_ ORDER_QUANTITY | |
FIXED_ORDER_QUANTITY | FIXED_ ORDER_QUANTITY | |
FIXED_DAYS_SUPPLY | FIXED_ DAYS_SUPPLY | |
MAXIMUM_ORDER_QUANTITY | MAXIMUM_ ORDER_QUANTITY | |
ATP_RULE_NAME | ATP_RULE_ID | Derives RULE_ID from MTL_ATP_RULES for the RULE_NAME. |
PICKING_RULE_NAME | PICKING_RULE_ID | Derives PICKING_RULE_ID from MTL_PICKING_RULES. |
RESERVABLE_TYPE | RESERVABLE_ TYPE | Derives the LOOKUP_CODE from MFG_LOOKUPS for LOOKUP_TYPE. MTL_RESERVATION_CONTROL. |
POSITIVE_MEASUREMENT_ ERROR | POSITIVE_ MEASUREMENT_ ERROR | Percent error above measured quantity. |
NEGATIVE_MEASUREMENT_ ERROR | NEGATIVE_ MEASUREMENT_ ERROR | Percent error below measured quantity. |
ENGINEERING_ECN_CODE | ENGINEERING_ ECN_CODE | Engineering Change code. |
ENGINEERING_ITEM | ENGINEERING_ ITEM_ID | Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the concatenated segment. |
ENGINEERING_DATE | ENGINEERING_ DATE | |
SERVICE_STARTING_DATE | SERVICE_ START_DATE | For inbound transactions only. |
SERVICE_STARTING_DELAY | SERVICE_ STARTING_ DELAY | Days after shipment that service begins. |
VENDOR_WARRANTY_FLAG | VENDOR_ WARRANTY_ FLAG | |
SERVICEABLE_COMPONENT_ FLAG | SERVICEABLE_ COMPONENT_ FLAG | * |
SERVICEABLE_PRODUCT_ FLAG | SERVICEABLE_ PRODUCT_FLAG | |
BASE_WARRANTY_SERVICE_ ITEM | BASE_ WARRANTY_ SERVICE_ID | Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the concatenated segment and organization. |
PAYMENT_TERMS_NAME | PAYMENT_ TERM_ID | Derives PAYMENT_TERM_ID from RA_TERMS_B. |
PREVENTATIVE_ MAINTENANCE_FLAG | PREVENTATIVE_ MAINTENANCE_ FLAG | |
PRIMARY_SPECIALIST_ FULL_NAME | PRIMARY_ SPECIALIST_ID | Derives PERSON_ID from PER_ALL_PEOPLE_F for the active record. |
SECONDARY_SPECIALIST_ FULL_NAME | SECONDARY_ SPECIALIST_ID | Derives PERSON_ID from PER_ALL_PEOPLE_F for the active record. |
SERVICEABLE_ITEM_CLASS_ NAME | SERVICEABLE_ ITEM_CLASS_ID | Derives SERVICEABLE_ITEM_CLASS_ID from CS_SERVICEABLE_ITEM_CLASSES for the Class Name. |
TIME_BILLABLE_FLAG | TIME_ BILLABLE_FLAG | Indicates whether service hours are billable. |
MATERIAL_BILLABLE_FLAG | MATERIAL_ BILLABLE_FLAG | Indicates whether service items are billable. |
EXPENSE_BILLABLE_FLAG | EXPENSE_ BILLABLE_FLAG | Indicates whether service expenses are billable. |
PRORATE_SERVICE_FLAG | PRORATE_ SERVICE_FLAG | Indicates whether cost of service may be prorated. |
COVERAGE_SCHEDULE_NAME | COVERAGE_ SCHEDULE_ID | Derives COVERAGE_SCHEDULE_ID from CS_COVERAGE_SCHEDULES for the Name. |
SERVICE_DURATION_PERIOD_ CODE | SERVICE_ DURATION_ PERIOD_CODE | |
SERVICE_DURATION | SERVICE_ DURATION | Default service duration. |
WARRANTY_VENDOR_NAME | WARRANTY_ VENDOR_ID | Derives VENDOR_ID from AP_SUPPLIERS for the Vendor Name. |
MAX_WARRANTY_AMOUNT | MAX_WARRANTY_ AMOUNT | Maximum warranty amount. |
RESPONSE_TIME_PERIOD_ CODE | RESPONSE_ TIME_PERIOD_ CODE | |
RESPONSE_TIME_VALUE | RESPONSE_ TIME_VALUE | |
NEW_REVISION_CODE | NEW_ REVISION_ CODE | Indicates how to inform customers in case of revisions. |
INVOICEABLE_ITEM_FLAG | INVOICEABLE_ ITEM_FLAG | Required. |
INVOICE_ENABLED_FLAG | INVOICE_ ENABLED_FLAG | Required. |
MUST_USE_APPROVED_ VENDOR_FLAG | MUST_USE_ APPROVED_ VENDOR_FLAG | Required. Indicates whether purchases are restricted to approved supplier. |
OUTSIDE_OPERATION_FLAG | OUTSIDE_ OPERATION_ FLAG | Required. |
OUTSIDE_OPERATION_ UOM_TYPE | OUTSIDE_ OPERATION_ UOM_TYPE | Outside operation unit of measure. |
SAFETY_STOCK_BUCKET_DAYS | SAFETY_ STOCK_BUCKET_ DAYS | |
AUTO_REDUCE_MPS | AUTO_ REDUCE_MPS | Automatically deletes MPS entries in a period. |
COSTING_ENABLED_FLAG | COSTING_ ENABLED_ FLAG | Required. |
CYCLE_COUNT_ENABLED_ FLAG | CYCLE_COUNT_ ENABLED_FLAG | Required. Indicates whether item may be cycle counted. |
DEMAND_SOURCE_LINE | DEMAND_ SOURCE_LINE | For inbound transactions only. |
COPY_ITEM_NUMBER | COPY_ITEM_ID | Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the concatenated segment. For inbound transactions only. |
SET_ID | SET_ID | Set identifier used for ATO. For inbound transactions only. |
REVISION | REVISION | Item revision. |
AUTO_CREATED_CONFIG_ FLAG | AUTO_CREATED_ CONFIG_FLAG | Required. Indicates whether configuration item is automatically created. |
ITEM_TYPE | ITEM_TYPE | User-defined item type. Derives LOOKUP_CODE from FND_COMMON_LOOKUPS where LOOKUP_TYPE = ITEM_TYPE for the meaning. |
MODEL_CONFIG_CLAUSE_ NAME | MODEL_CONFIG_ CLAUSE_NAME | Model configuration clause name. |
SHIP_MODEL_COMPLETE_ FLAG | SHIP_MODEL_ COMPLETE_FLAG | Indicates whether model must be complete to ship. |
MRP_PLANNING | MRP_ PLANNING_ CODE | Derived from MFG_LOOKUPS where LOOKUP_TYPE = MRP_PLANNING_CODE for the meaning column. |
RETURN_INSPECTION_ REQUIREMENT | RETURN_ INSPECTION_ REQUIREMENT | RMA inspection requirement. Derived from MFG_LOOKUPS where LOOKUP_TYPE = MTL_RETURN_INSPECTION. |
DEMAND_SOURCE_TYPE | DEMAND_ SOURCE_TYPE | Derives TRANSACTION_ SOURCE_TYPE_ID from MTL_TXN_ SOURCE_TYPES for TRANSACTION_ SOURCE_TYPE_NAME. For inbound transactions only. |
DEMAND_SOURCE_HEADER_ ID | DEMAND_ SOURCE_ HEADER_ID | |
TEMPLATE_NAME | TEMPLATE_NAME | Item template name. For inbound transactions only. |
COPY_ORGANIZATION_NAME | COPY_ ORGANIZATION_ ID | Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS. For inbound transactions only. |
ATO_FORECAST_CONTROL | ATO_ FORECAST_ CONTROL | Type of forecast control for ATO. Derived from MFG_LOOKUPS where LOOKUP_TYPE = MRP_ATO_ FORECAST_CONTROL for the meaning column. |
TRANSACTION_TYPE | TRANSACTION_TYPE | Either CREATE or UPDATE. Item cost cannot be updated using the UPDATE mode in this interface. For inbound transactions only. |
MATERIAL_COST | MATERIAL_COST | For inbound transactions only. |
MATERIAL_SUB_ELEMENT | MATERIAL_ SUB_ELEMENT | For inbound transactions only. |
MATERIAL_OH_RATE | MATERIAL_ OH_RATE | Material overhead rate. For inbound transaction only. |
MATERIAL_OH_SUB_ELEMENT | MATERIAL_ OH_SUB_ ELEMENT | Material overhead sub element. For inbound transaction only. |
CONTAINER_ITEM_FLAG | CONTAINER_ ITEM_FLAG | Indicates whether the item is a container. For shipping sales orders. |
VEHICLE_ITEM_FLAG | VEHICLE_ ITEM_FLAG | Indicates whether the item is a vehicle. For shipping sales orders. |
MAXIMUM_LOAD_WEIGHT | MAXIMUM_ LOAD_WEIGHT | Maximum load weight of a container or a vehicle that can be used for shipping sales orders. |
MINIMUM_FILL_PERCENT | MINIMUM_ FILL_PERCENT | Minimum fill condition under which the container or vehicle should be used. |
CONTAINER_TYPE_CODE | CONTAINER_ TYPE_CODE | User-defined container type code for container items. |
INTERNAL_VOLUME | INTERNAL_VOLUME | Internal volume for container items used by shipping to calculate container capacity restrictions. |
CHECK_SHORTAGES_FLAG | CHECK_ SHORTAGES_ FLAG | Indicates whether material shortages should be checked (Y/N). |
RELEASE_TIME_FENCE_CODE | RELEASE_ TIME_ FENCE_CODE | Indicates whether this item is auto releasable by MRP. Derives LOOKUP_CODE from MFG_LOOKUPS where LOOKUP_TYPE is MTL_RELEASE_TIME_FENCE. |
RELEASE_TIME_FENCE_DAYS | RELEASE_ TIME_ FENCE_DAYS | Number of days that this item should be automatically released. |
WH_UPDATE_DATE | WH_UPDATE_DATE | Warehouse update date for tracking changes relevant to data collected in the data warehouse. |
PRODUCT_FAMILY_ITEM | PRODUCT_ FAMILY_ ITEM_ID | Derives ITEM_ID from MTL_SYSTEM_ ITEMS_B_KFV for the concatenated segment. |
PURCHASING_TAX_CODE | PURCHASING_ TAX_CODE | |
OVERCOMPLETION_TOLER ANCE_TYPE | OVERCOMPLETION_ TOLERANCE_ TYPE | Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE is WIP_TOLERANCE_TYPE. |
OVERCOMPLETION_TOLER ANCE_VALUE | OVERCOMPLETION_ TOLERANCE_ VALUE | |
EFFECTIVITY_CONTROL | EFFECTIVITY_ CONTROL | Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE is MTL_EFFECTIVITY_CONTROL. |
OVER_SHIPMENT_ TOLERANCE | OVER_ SHIPMENT_ TOLERANCE | |
UNDER_SHIPMENT_ TOLERANCE | UNDER_ SHIPMENT_ TOLERANCE | |
OVER_RETURN_TOLERANCE | OVER_RETURN_ TOLERANCE | |
UNDER_RETURN_TOLERANCE | UNDER_RETURN_ TOLERANCE | |
EQUIPMENT_TYPE | EQUIPMENT_ TYPE | Use: 1 for Yes.2 for No. |
RECOVERED_PART_DISP_CODE | RECOVERED_ PART_DISP_ CODE | Indicates that return is required for recovered parts, scrap in field, which is used for spare Parts. |
DEFECT_TRACKING_ON_FLAG | DEFECT_ TRACKING_ ON_FLAG | Indicates whether a defect or bug can be filed against the product. |
USAGE_ITEM_FLAG | USAGE_ITEM_FLAG | |
EVENT_FLAG | EVENT_FLAG | Indicates whether item is to be treated as an event. |
ELECTRONIC_FLAG | ELECTRONIC_ FLAG | Indicates whether an item exists only in electronic format. |
DOWNLOADABLE_FLAG | DOWNLOADABLE_ FLAG | |
VOL_DISCOUNT_EXEMPT_ FLAG | VOL_DISCOUNT_ EXEMPT_FLAG | Indicates whether an item does not contribute to volume discount for any order. |
COUPON_EXEMPT_FLAG | COUPON_EXEMPT_ FLAG | Indicates whether an item is excluded from coupons. |
COMMS_NL_TRACKABLE_ FLAG | COMMS_NL_ TRACKABLE_FLAG | Indicates whether network logistics can be tracked. |
ASSET_CREATION_CODE | ASSET_CREATION_ CODE | |
COMMS_ACTIVATION_REQD_ FLAG | COMMS_ ACTIVATION_ REQD_FLAG | Indicates whether network activation is required. |
ORDERABLE_ON_WEB_FLAG | ORDERABLE_ ON_WEB_FLAG | |
BACK_ORDERABLE_FLAG | BACK_ ORDERABLE_ FLAG | If ATP failed, can item be back ordered. |
WEB_STATUS | WEB_STATUS | |
INDIVISIBLE_FLAG | INDIVISIBLE_FLAG | Item cannot be separated. |
DIMENSION_UOM_CODE | DIMENSION_ UOM_CODE | Dimension unit of measure code. |
UNIT_LENGTH | UNIT_LENGTH | |
UNIT_WIDTH | UNIT_WIDTH | |
UNIT_HEIGHT | UNIT_HEIGHT | |
BULK_PICKED_FLAG | BULK_PICKED_FLAG | |
LOT_STATUS_ENABLED | LOT_STATUS_ ENABLED | |
LOT_TRANSLATE_ENABLED | LOT_TRANSLATE_ ENABLED | Indicates whether Lot Translate is enabled. (This can be enabled only if LOT_CONTROL is Full lot control.) |
DEFAULT_SO_SOURCE_TYPE | DEFAULT_SO_ SOURCE_TYPE | Default Sales Order source type. (External/ Internal) If an item is not purchasable, this field cannot be External. Set PURCHASING_ITEM_FLAG and PURCHASING_ENABLED_FLAG to Y for this field to be External. |
CREATE_SUPPLY_FLAG | CREATE_SUPPLY_ FLAG | Create supply flag. |
SUBSTITUTION_WINDOW_ CODE | SUBSTITUTION_ WINDOW_CODE | Substitution window code. Use: 1 for Cumulative Total Lead Time.2 for Cumulative Mfg Lead Time.3 for Total Lead Time.4 for User Defined. |
SUBSTITUTION_WINDOW_ DAYS | SUBSTITUTION_ WINDOW_DAYS | Substitution window days. |
CONFIG_MODEL_TYPE | CONFIG_MODEL_ TYPE | Configurator model type. Use: N for Container.Null for Standard.This field can be non- standard only if: BOM_ITEM_TYPE is Model and Orderable flag (CUSTOMER_ORDERED and CUSTOMER_ORDERS_ ENABLED flags in Order Management Tab) is Yes, and PICK_COMPONENTS_FLAG is Yes. |
LOT_SUBSTITUTION_FLAG | LOT_ SUBSTITUTION_ FLAG | Lot substitution flag. This field can be enabled only if LOT_CONTROL is Full lot control. |
MINIMUM_LICENSE_ QUANTITY | MINIMUM_ LICENSE_ QUANTITY | Minimum license quantity. |
Field Name | Maps to Column | Description |
CATEGORY_SET_NAME | CATEGORY_SET_NAME | |
CATEGORY_NAME | CATEGORY_NAME | Required. Concatenated Category Name. |
TRANSACTION_TYPE | TRANSACTION_TYPE | Use CREATE or DELETE. If you select DELETE, you must also CREATE. For inbound transactions only. |
Field Name | Maps to Column | Description |
REVISION | REVISION | Item revision code. |
TRANSACTION_TYPE | TRANSACTION_TYPE | Must be CREATE. For inbound transactions only. |
CHANGE_NOTICE | CHANGE_NOTICE | |
ECN_INITIATION_DATE | ECN_INITIATION_DATE | Engineering Change Initiation Date. |
IMPLEMENTATION_DATE | IMPLEMENTATION_DATE | |
IMPLEMENTED_ SERIAL_NUMBER | IMPLEMENTED_ SERIAL_NUMBER | |
EFFECTIVITY_DATE | EFFECTIVITY_DATE | |
REVISED_ITEM_ SEQUENCE_ID | REVISED_ITEM_ SEQUENCE_ID | Identifies multiple occurrences of the same item on an engineering change order. |
DESCRIPTION | DESCRIPTION | Item revision description. |