Group Name
|
Item Attribute Name
|
Main
|
Primary Unit of Measure
|
Main
|
Dual Control
|
Main
|
Secondary
|
Main
|
Deviation Factor +
|
Main
|
Deviation Factor –
|
Main
|
User Item Type
|
Main
|
Item Status
|
Main
|
Conversions
|
Main
|
Long Description
|
Inventory
|
Inventory Item
|
Inventory
|
Stockable
|
Inventory
|
Transactable
|
Inventory
|
Revision Control
|
Inventory
|
Reservable
|
Inventory
|
Check Material Shortage
|
Inventory
|
Lot Expiration (Shelf Life)
Control
|
Inventory
|
Shelf Life Days
|
Inventory
|
Lot Control
|
Inventory
|
Starting Lot Prefix
|
Inventory
|
Starting Lot Number
|
Inventory
|
Cycle Count Enabled
|
Inventory
|
Negative Measurement Error
|
Inventory
|
Positive Measurement Error
|
Inventory
|
Serial Generation
|
Inventory
|
Starting Serial Prefix
|
Inventory
|
Starting Serial Number
|
Inventory
|
Lot Status Enabled
|
Inventory
|
Serial Status Enabled
|
Inventory
|
Lot Split Enabled
|
Inventory
|
Lot Merge Enabled
|
Inventory
|
Lot Translate Enabled
|
Inventory
|
Bulk Picked
|
Inventory
|
Locator Control
|
Inventory
|
Restrict Subinventories
|
Inventory
|
Restrict Locators
|
Bills of Material
|
BOM Allowed
|
Bills of Material
|
BOM Item Type
|
Bills of Material
|
Base Model
|
Bills of Material
|
Engineering Item (Oracle
Engineering only)
|
Bills of Material
|
Effectivity Control
|
Asset Management
|
Asset Item Type
|
Asset Management
|
Activity Type
|
Asset Management
|
Activity Cause
|
Asset Management
|
Activity Source
|
Asset Management
|
Shutdown Type
|
Asset Management
|
Activity Notification Required
|
Costing
|
Costing Enabled
|
Costing
|
Inventory Asset Value
|
Costing
|
Include in Rollup
|
Costing
|
Cost of Goods Sold Account
|
Costing
|
Standard Lot Size
|
Purchasing
|
Purchased
|
Purchasing
|
Purchasable
|
Purchasing
|
Use Approved Supplier
|
Purchasing
|
Allow Description Update
|
Purchasing
|
RFQ Required
|
Purchasing
|
Outside Processing Item
|
Purchasing
|
Outside Processing Unit Type
|
Purchasing
|
Taxable
|
Purchasing
|
Tax Code
|
Purchasing
|
Receipt Required (Three–Way
Invoice Matching)
|
Purchasing
|
Inspection Required (Four–Way
Invoice Matching)
|
Purchasing
|
Default Buyer
|
Purchasing
|
Unit of Issue
|
Purchasing
|
Receipt Close Tolerance
|
Purchasing
|
Invoice Close Tolerance
|
Purchasing
|
UN Number
|
Purchasing
|
Hazard Class
|
Purchasing
|
List Price
|
Purchasing
|
Market Price
|
Purchasing
|
Price Tolerance
|
Purchasing
|
Rounding Factor
|
Purchasing
|
Encumbrance Account
|
Purchasing
|
Expense Account
|
Purchasing
|
Asset Category
|
Receiving
|
Receipt Date Action
|
Receiving
|
Receipt Days Early
|
Receiving
|
Receipt Days Late
|
Receiving
|
Overreceipt Quantity Control
Action
|
Receiving
|
Overreceipt Quantity Control
Tolerance
|
Receiving
|
Allow Substitute Receipts
|
Receiving
|
Allow Unordered Receipts
|
Receiving
|
Allow Express Transactions
|
Receiving
|
Receipt Routing
|
Receiving
|
Enforce Ship–To
|
Physical Attributes
|
Weight Unit of Measure
|
Physical Attributes
|
Unit Weight
|
Physical Attributes
|
Volume Unit of Measure
|
Physical Attributes
|
Unit Volume
|
Physical Attributes
|
Container
|
Physical Attributes
|
Vehicle
|
Physical Attributes
|
Container Type
|
Physical Attributes
|
Internal Volume
|
Physical Attributes
|
Maximum Load Weight
|
Physical Attributes
|
Minimum Fill Percentage
|
Physical Attributes
|
Dimension Unit of Measure
|
Physical Attributes
|
Dimension Length
|
Physical Attributes
|
Dimension Width
|
Physical Attributes
|
Dimension Height
|
Physical Attributes
|
Collateral Item
|
Physical Attributes
|
Event
|
Physical Attributes
|
Equipment
|
Physical Attributes
|
Electronic Format
|
Physical Attributes
|
Downloadable
|
Physical Attributes
|
OM Indivisible
|
General Planning
|
Inventory Planning Method
|
General Planning
|
Planner
|
General Planning
|
Make or Buy
|
General Planning
|
Min–Max Minimum Quantity
|
General Planning
|
Min–Max Maximum Quantity
|
General Planning
|
Minimum Order Quantity
|
General Planning
|
Maximum Order Quantity
|
General Planning
|
Order Cost
|
General Planning
|
Carrying Cost Percent
|
General Planning
|
Source Type (Replenishment)
|
General Planning
|
Source Organization
|
General Planning
|
Source Subinventory
|
General Planning
|
Safety Stock Method
|
General Planning
|
Safety Stock Bucket Days
|
General Planning
|
Safety Stock Percent
|
General Planning
|
Fixed Order Quantity
|
General Planning
|
Fixed Days Supply
|
General Planning
|
Fixed Lot Multiplier
|
MPS/MRP Planning
|
Planning Method
|
MPS/MRP Planning
|
Forecast Control
|
MPS/MRP Planning
|
Exception Set
|
MPS/MRP Planning
|
Pegging
|
MPS/MRP Planning
|
Planned Inventory Point
|
MPS/MRP Planning
|
Create Supply
|
MPS/MRP Planning
|
Round Order Quantities
|
MPS/MRP Planning
|
Shrinkage Rate
|
MPS/MRP Planning
|
Acceptable Early Days
|
MPS/MRP Planning
|
Repetitive Planning
|
MPS/MRP Planning
|
Overrun Percentage
|
MPS/MRP Planning
|
Acceptable Rate Decrease
|
MPS/MRP Planning
|
Acceptable Rate Increase
|
MPS/MRP Planning
|
Calculate ATP
|
MPS/MRP Planning
|
Reduce MPS
|
MPS/MRP Planning
|
Planning Time Fence
|
MPS/MRP Planning
|
Planning Time Fence Days
|
MPS/MRP Planning
|
Demand Time Fence
|
MPS/MRP Planning
|
Demand Time Fence Days
|
MPS/MRP Planning
|
Release Time Fence
|
MPS/MRP Planning
|
Release Time Fence Days
|
MPS/MRP Planning
|
Substitution Window Type
|
MPS/MRP Planning
|
Substitution Window Days
|
Lead Times
|
Preprocessing
|
Lead Times
|
Processing
|
Lead Times
|
Postprocessing
|
Lead Times
|
Fixed
|
Lead Times
|
Variable
|
Lead Times
|
Cumulative Manufacturing
|
Lead Times
|
Cumulative Total
|
Lead Times
|
Lead Time Lot Size
|
Work in Process
|
Build in WIP
|
Work in Process
|
Supply Type
|
Work in Process
|
Supply Subinventory
|
Work in Process
|
Supply Locator
|
Work in Process
|
Overcompletion Tolerance Type
|
Work in Process
|
Overcompletion Tolerance Value
|
Work in Process
|
Scheduling Penalty Inventory Carry
|
Work in Process
|
Scheduling Penalty Operation Slack
|
Order Management
|
Customer Ordered
|
Order Management
|
Customer Orders Enabled
|
Order Management
|
Shippable
|
Order Management
|
Internal Ordered
|
Order Management
|
Internal Orders Enabled
|
Order Management
|
OE Transactable
|
Order Management
|
Pick Components
|
Order Management
|
Assemble to Order
|
Order Management
|
ATP Components
|
Order Management
|
Ship Model Complete
|
Order Management
|
Check ATP
|
Order Management
|
ATP Rule
|
Order Management
|
Picking Rule
|
Order Management
|
Default Shipping Organization
|
Order Management
|
Default SO Source Type
|
Order Management
|
Returnable
|
Order Management
|
RMA Inspection Required
|
Order Management
|
Financing Allowed
|
Order Management
|
Over Shipment Tolerance
|
Order Management
|
Under Shipment Tolerance
|
Order Management
|
Over Return Tolerance
|
Order Management
|
Under Return Tolerance
|
Invoicing
|
Invoiceable Item
|
Invoicing
|
Invoice Enabled
|
Invoicing
|
Accounting Rule
|
Invoicing
|
Invoicing Rule
|
Invoicing
|
Tax Code
|
Invoicing
|
Sales Account
|
Invoicing
|
Payment Terms
|
Service
|
Contract Item Type
|
Service
|
Contract Duration
|
Service
|
Contract Duration Period
|
Service
|
Service Duration
|
Service
|
Subscription Dependency Enabled
|
Service
|
Service Importance Level
|
Service
|
Billing Type
|
Service
|
Service Request Enabled
|
Service
|
Provisionable
|
Service
|
Serviceable Product
|
Service
|
Service Billing Enabled
|
Service
|
Defect Tracking Enabled
|
Service
|
Recovered Part Disposition
|
Service
|
Installed Base Tracking
|
Service
|
Asset Creation
|
Service
|
Starting Delay (Days)
|
Web Option
|
Web Status
|
Web Option
|
Orderable On the Web
|
Web Option
|
Back Orderable
|
Tuesday, October 24, 2017
Inventory Item Attribtes in Oracle Apps
Subscribe to:
Post Comments (Atom)
SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT
Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
LOT_CONTROL_CODE column contains values as 1 & 2 in mtl_system_items_b table. Inorder to find meaning for this values run below que...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...
No comments:
Post a Comment