选OracleERP库存管理INV8个表结构 ln.docx
- 文档编号:27782675
- 上传时间:2023-07-05
- 格式:DOCX
- 页数:31
- 大小:29.79KB
选OracleERP库存管理INV8个表结构 ln.docx
《选OracleERP库存管理INV8个表结构 ln.docx》由会员分享,可在线阅读,更多相关《选OracleERP库存管理INV8个表结构 ln.docx(31页珍藏版)》请在冰豆网上搜索。
选OracleERP库存管理INV8个表结构ln
Oracle_ERP_库存管理INV_8个表结构
下载《OracleERPINV模块8个重要表结构》
--Createtable
createtableINV.MTL_TRANSACTION_TYPES
(
TRANSACTION_TYPE_IDNUMBERnotnull,
LAST_UPDATE_DATEDATEnotnull,
LAST_UPDATED_BYNUMBERnotnull,
CREATION_DATEDATEnotnull,
CREATED_BYNUMBERnotnull,
TRANSACTION_TYPE_NAMEVARCHAR2(80)notnull,
DESCRIPTIONVARCHAR2(240),
TRANSACTION_ACTION_IDNUMBERnotnull,
TRANSACTION_SOURCE_TYPE_IDNUMBERnotnull,
SHORTAGE_MSG_BACKGROUND_FLAGVARCHAR2
(1),
SHORTAGE_MSG_ONLINE_FLAGVARCHAR2
(1),
DISABLE_DATEDATE,
USER_DEFINED_FLAGVARCHAR2
(1)notnull,
ATTRIBUTE1VARCHAR2(150),
ATTRIBUTE2VARCHAR2(150),
ATTRIBUTE3VARCHAR2(150),
ATTRIBUTE4VARCHAR2(150),
ATTRIBUTE5VARCHAR2(150),
ATTRIBUTE6VARCHAR2(150),
ATTRIBUTE7VARCHAR2(150),
ATTRIBUTE8VARCHAR2(150),
ATTRIBUTE9VARCHAR2(150),
ATTRIBUTE10VARCHAR2(150),
ATTRIBUTE11VARCHAR2(150),
ATTRIBUTE12VARCHAR2(150),
ATTRIBUTE13VARCHAR2(150),
ATTRIBUTE14VARCHAR2(150),
ATTRIBUTE15VARCHAR2(150),
ATTRIBUTE_CATEGORYVARCHAR2(30),
TYPE_CLASSNUMBER,
STATUS_CONTROL_FLAGNUMBER
)
tablespaceAPPS_TS_SEED
pctfree10
initrans10
maxtrans255
storage
(
initial128
next128
minextents1
maxextentsunlimited
pctincrease0
);
--Create/Recreateindexes
createindexINV.MTL_TRANSACTION_TYPES_N1onINV.MTL_TRANSACTION_TYPES(TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID)
tablespaceAPPS_TS_SEED
pctfree10
initrans11
maxtrans255
storage
(
initial128K
next128K
minextents1
maxextentsunlimited
pctincrease0
);
createuniqueindexINV.MTL_TRANSACTION_TYPES_U1onINV.MTL_TRANSACTION_TYPES(TRANSACTION_TYPE_ID)
tablespaceAPPS_TS_SEED
pctfree10
initrans11
maxtrans255
storage
(
initial128K
next128K
minextents1
maxextentsunlimited
pctincrease0
);
--Grant/Revokeobjectprivileges
grantselect,insert,update,delete,references,alter,indexonINV.MTL_TRANSACTION_TYPEStoAPPSwithgrantoption;
grantselectonINV.MTL_TRANSACTION_TYPEStoCUX;
下载《OracleERPINV模块8个重要表结构》
--Createtable
createtableINV.MTL_SYSTEM_ITEMS_B
(
INVENTORY_ITEM_IDNUMBERnotnull,
ORGANIZATION_IDNUMBERnotnull,
LAST_UPDATE_DATEDATEnotnull,
LAST_UPDATED_BYNUMBERnotnull,
CREATION_DATEDATEnotnull,
CREATED_BYNUMBERnotnull,
LAST_UPDATE_LOGINNUMBER,
SUMMARY_FLAGVARCHAR2
(1)notnull,
ENABLED_FLAGVARCHAR2
(1)notnull,
START_DATE_ACTIVEDATE,
END_DATE_ACTIVEDATE,
DESCRIPTIONVARCHAR2(240),
BUYER_IDNUMBER(9),
ACCOUNTING_RULE_IDNUMBER,
INVOICING_RULE_IDNUMBER,
SEGMENT1VARCHAR2(40),
SEGMENT2VARCHAR2(40),
SEGMENT3VARCHAR2(40),
SEGMENT4VARCHAR2(40),
SEGMENT5VARCHAR2(40),
SEGMENT6VARCHAR2(40),
SEGMENT7VARCHAR2(40),
SEGMENT8VARCHAR2(40),
SEGMENT9VARCHAR2(40),
SEGMENT10VARCHAR2(40),
SEGMENT11VARCHAR2(40),
SEGMENT12VARCHAR2(40),
SEGMENT13VARCHAR2(40),
SEGMENT14VARCHAR2(40),
SEGMENT15VARCHAR2(40),
SEGMENT16VARCHAR2(40),
SEGMENT17VARCHAR2(40),
SEGMENT18VARCHAR2(40),
SEGMENT19VARCHAR2(40),
SEGMENT20VARCHAR2(40),
ATTRIBUTE_CATEGORYVARCHAR2(30),
ATTRIBUTE1VARCHAR2(240),
ATTRIBUTE2VARCHAR2(240),
ATTRIBUTE3VARCHAR2(240),
ATTRIBUTE4VARCHAR2(240),
ATTRIBUTE5VARCHAR2(240),
ATTRIBUTE6VARCHAR2(240),
ATTRIBUTE7VARCHAR2(240),
ATTRIBUTE8VARCHAR2(240),
ATTRIBUTE9VARCHAR2(240),
ATTRIBUTE10VARCHAR2(240),
ATTRIBUTE11VARCHAR2(240),
ATTRIBUTE12VARCHAR2(240),
ATTRIBUTE13VARCHAR2(240),
ATTRIBUTE14VARCHAR2(240),
ATTRIBUTE15VARCHAR2(240),
PURCHASING_ITEM_FLAGVARCHAR2
(1)notnull,
SHIPPABLE_ITEM_FLAGVARCHAR2
(1)notnull,
CUSTOMER_ORDER_FLAGVARCHAR2
(1)notnull,
INTERNAL_ORDER_FLAGVARCHAR2
(1)notnull,
SERVICE_ITEM_FLAGVARCHAR2
(1)notnull,
INVENTORY_ITEM_FLAGVARCHAR2
(1)notnull,
ENG_ITEM_FLAGVARCHAR2
(1)notnull,
INVENTORY_ASSET_FLAGVARCHAR2
(1)notnull,
PURCHASING_ENABLED_FLAGVARCHAR2
(1)notnull,
CUSTOMER_ORDER_ENABLED_FLAGVARCHAR2
(1)notnull,
INTERNAL_ORDER_ENABLED_FLAGVARCHAR2
(1)notnull,
SO_TRANSACTIONS_FLAGVARCHAR2
(1)notnull,
MTL_TRANSACTIONS_ENABLED_FLAGVARCHAR2
(1)notnull,
STOCK_ENABLED_FLAGVARCHAR2
(1)notnull,
BOM_ENABLED_FLAGVARCHAR2
(1)notnull,
BUILD_IN_WIP_FLAGVARCHAR2
(1)notnull,
REVISION_QTY_CONTROL_CODENUMBER,
ITEM_CATALOG_GROUP_IDNUMBER,
CATALOG_STATUS_FLAGVARCHAR2
(1),
RETURNABLE_FLAGVARCHAR2
(1),
DEFAULT_SHIPPING_ORGNUMBER,
COLLATERAL_FLAGVARCHAR2
(1),
TAXABLE_FLAGVARCHAR2
(1),
QTY_RCV_EXCEPTION_CODEVARCHAR2(25),
ALLOW_ITEM_DESC_UPDATE_FLAGVARCHAR2
(1),
INSPECTION_REQUIRED_FLAGVARCHAR2
(1),
RECEIPT_REQUIRED_FLAGVARCHAR2
(1),
MARKET_PRICENUMBER,
HAZARD_CLASS_IDNUMBER,
RFQ_REQUIRED_FLAGVARCHAR2
(1),
QTY_RCV_TOLERANCENUMBER,
LIST_PRICE_PER_UNITNUMBER,
UN_NUMBER_IDNUMBER,
PRICE_TOLERANCE_PERCENTNUMBER,
ASSET_CATEGORY_IDNUMBER,
ROUNDING_FACTORNUMBER,
UNIT_OF_ISSUEVARCHAR2(25),
ENFORCE_SHIP_TO_LOCATION_CODEVARCHAR2(25),
ALLOW_SUBSTITUTE_RECEIPTS_FLAGVARCHAR2
(1),
ALLOW_UNORDERED_RECEIPTS_FLAGVARCHAR2
(1),
ALLOW_EXPRESS_DELIVERY_FLAGVARCHAR2
(1),
DAYS_EARLY_RECEIPT_ALLOWEDNUMBER,
DAYS_LATE_RECEIPT_ALLOWEDNUMBER,
RECEIPT_DAYS_EXCEPTION_CODEVARCHAR2(25),
RECEIVING_ROUTING_IDNUMBER,
INVOICE_CLOSE_TOLERANCENUMBER,
RECEIVE_CLOSE_TOLERANCENUMBER,
AUTO_LOT_ALPHA_PREFIXVARCHAR2(30),
START_AUTO_LOT_NUMBERVARCHAR2(30),
LOT_CONTROL_CODENUMBER,
SHELF_LIFE_CODENUMBER,
SHELF_LIFE_DAYSNUMBER,
SERIAL_NUMBER_CONTROL_CODENUMBER,
START_AUTO_SERIAL_NUMBERVARCHAR2(30),
AUTO_SERIAL_ALPHA_PREFIXVARCHAR2(30),
SOURCE_TYPENUMBER,
SOURCE_ORGANIZATION_IDNUMBER,
SOURCE_SUBINVENTORYVARCHAR2(10),
EXPENSE_ACCOUNTNUMBER,
ENCUMBRANCE_ACCOUNTNUMBER,
RESTRICT_SUBINVENTORIES_CODENUMBER,
UNIT_WEIGHTNUMBER,
WEIGHT_UOM_CODEVARCHAR2(3),
VOLUME_UOM_CODEVARCHAR2(3),
UNIT_VOLUMENUMBER,
RESTRICT_LOCATORS_CODENUMBER,
LOCATION_CONTROL_CODENUMBER,
SHRINKAGE_RATENUMBER,
ACCEPTABLE_EARLY_DAYSNUMBER,
PLANNING_TIME_FENCE_CODENUMBER,
DEMAND_TIME_FENCE_CODENUMBER,
LEAD_TIME_LOT_SIZENUMBER,
STD_LOT_SIZENUMBER,
CUM_MANUFACTURING_LEAD_TIMENUMBER,
OVERRUN_PERCENTAGENUMBER,
MRP_CALCULATE_ATP_FLAGVARCHAR2
(1),
ACCEPTABLE_RATE_INCREASENUMBER,
ACCEPTABLE_RATE_DECREASENUMBER,
CUMULATIVE_TOTAL_LEAD_TIMENUMBER,
PLANNING_TIME_FENCE_DAYSNUMBER,
DEMAND_TIME_FENCE_DAYSNUMBER,
END_ASSEMBLY_PEGGING_FLAGVARCHAR2
(1),
REPETITIVE_PLANNING_FLAGVARCHAR2
(1),
PLANNING_EXCEPTION_SETVARCHAR2(10),
BOM_ITEM_TYPENUMBERnotnull,
PICK_COMPONENTS_FLAGVARCHAR2
(1)notnull,
REPLENISH_TO_ORDER_FLAGVARCHAR2
(1)notnull,
BASE_ITEM_IDNUMBER,
ATP_COMPONENTS_FLAGVARCHAR2
(1)notnull,
ATP_FLAGVARCHAR2
(1)notnull,
FIXED_LEAD_TIMENUMBER,
VARIABLE_LEAD_TIMENUMBER,
WIP_SUPPLY_LOCATOR_IDNUMBER,
WIP_SUPPLY_TYPENUMBER,
WIP_SUPPLY_SUBINVENTORYVARCHAR2(10),
PRIMARY_UOM_CODEVARCHAR2(3),
PRIMARY_UNIT_OF_MEASUREVARCHAR2(25),
ALLOWED_UNITS_LOOKUP_CODENUMBER,
COST_OF_SALES_ACCOUNTNUMBER,
SALES_ACCOUNTNUMBER,
DEFAULT_INCLUDE_IN_ROLLUP_FLAGVARCHAR2
(1),
INVENTORY_ITEM_STATUS_CODEVARCHAR2(10)notnull,
INVENTORY_PLANNING_CODENUMBER,
PLANNER_CODEVARCHAR2(10),
PLANNING_MAKE_BUY_CODENUMBER,
FIXED_LOT_MULTIPLIERNUMBER,
ROUNDING_CONTROL_TYPENUMBER,
CARRYING_COSTNUMBER,
POSTPROCESSING_LEAD_TIMENUMBER,
PREPROCESSING_LEAD_TIMENUMBER,
FULL_LEAD_TIMENUMBER,
ORDER_COSTNUMBER,
MRP_SAFETY_STOCK_PERCENTNUMBER,
MRP_SAFETY_STOCK_CODENUMBER,
MIN_MINMAX_QUANTITYNUMBER,
MAX_MINMAX_QUANTITYNUMBER,
MINIMUM_ORDER_QUANTITYNUMBER,
FIXED_ORDER_QUANTITYNUMBER,
FIXED_DAYS_SUPPLYNUMBER,
MAXIMUM_ORDER_QUANTITYNUMBER,
ATP_RULE_IDNUMBER,
PICKING_RULE_IDNUMBER,
RESERVABLE_TYPENUMBER,
POSITIVE_MEASUREMENT_ERRORNUMBER,
NEGATIVE_MEASUREMENT_ERRORNUMBER,
ENGINEERING_ECN_CODEVARCHAR2(50),
ENGINEERING_ITEM_IDNUMBER,
ENGINEERING_DATEDATE,
SERVICE_STARTING_DELAYNUMBER,
VENDOR_WARRANTY_FLAGVARCHAR2
(1)notnull,
SERVICEABLE_COMPONENT_FLAGVARCHAR2
(1),
SERVICEABLE_PRODUCT_FLAGVARCHAR2
(1)notnull,
BASE_WARRANTY_SERVICE_IDNUMBER,
PAYMENT_TERMS_IDNUMBER,
PREVENTIVE_MAINTENANCE_FLAGVARCHAR2
(1),
PRIMARY_SPECIALIST_IDNUMBER,
SECONDARY_SPECIALIST_IDNUMBER,
SERVICEABLE_ITEM_CLASS_IDNUMBER,
TIME_BILLABLE_FLAGVARCHAR2
(1),
MATERIAL_BILLABLE_FLAGVARCHAR2(30),
EXPENSE_BILLABLE_FLAGVARCHAR2
(1),
PRORATE_SERVICE_FLAGVARCHAR2
(1),
COVERAGE_SCHEDULE_IDNUMBER,
SERVICE_DURATION_PERIOD_CODEVARCHAR2(10),
SERVICE_DURATIONNUMBER,
WARRANTY_VENDOR_IDNUMBER,
MAX_WARRANTY_AMOUNTNUMBER,
RESPONSE_TIME_PERIOD_CODEVARCHAR2(30),
RESPONSE_TIME_VALUENUMBER,
NEW_REVISION_CODEVARCHAR2(30),
INVOICEABLE_ITEM_FLAGVARCHAR2
(1)notnull,
TAX_CODEVARCHAR2(50),
INVOICE_ENABLED_FLAGVARCHAR2
(1)notnull,
MUST_USE_APPROVED_VENDOR_FLAGVARCHAR2
(1)notnull,
REQUEST_IDNUMBER,
PROGRAM_APPLICATION_IDNUMBER,
PROGRAM_IDNUMBER,
PROGRAM_UPDATE_DATEDATE,
OUTSIDE_OPERATION_FLAGVARCHAR2
(1)notnull,
OUTSIDE_OPERATION_UOM_TYPEVARCHAR2(25),
SAFETY_STOCK_BUCKET_DAYSNUMBER,
AUTO_REDUCE_MPSNUMBER(22),
COSTING_ENABLED_FLAGVARCHAR2
(1)notnull,
AUTO_CREATED_CONFIG_FLAGVARCHAR2
(1)notnull,
CYCLE_COUNT_ENABLED_FLAGVARCHAR2
(1)notnull,
ITEM_TYPEVARCHAR2(30),
MODEL_CONFIG_CLAUSE_NAMEVARCHAR2(10),
SHIP_MODEL_COMPLETE_FLAGVARCHAR2
(1),
MRP_PLANNING_CODENUMBER,
RETURN_INSPECTION_REQUIREMENTNUMBER,
ATO_FORECAST_CONTROLNUMBER,
RELEASE_TIME_FENCE_CODENUMBER,
RELEASE_TIME_FENCE_DAYSNUMBER,
CONTAINER_ITEM_FLAGVARCHAR2
(1),
VEHICLE_ITEM_FLAGVARCHAR2
(1),
MAXIMUM_LOAD_WEIGHTNUMBER,
MINIMUM_FILL_PERCENTNUMBER,
CONTAINER_TYPE_CODEVARCHAR2(30),
INTERNAL_VOLUMENUMBER,
WH_UPDATE_DATEDATE,
PRODUCT_FAMILY_ITEM_IDNUMBER,
GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(150),
GLOBAL_ATTRIBUTE1VARCHAR2(150),
GLOBAL_ATTRIBUTE2VARCHAR2(150),
GLOBAL_ATTRIBUTE3VARCHAR2(150),
GLOBAL_ATTRIBUTE4VARCHAR2(150),
GLOBAL_ATTRIBUTE5VARCHAR2(150),
GLOBAL_ATTRIBUTE6VARCHAR2(150),
GLOBAL_ATTRIBUTE7VARCHAR2(150),
GLOBAL_ATTRIBUTE8VARCHAR2(150),
GLOBAL_ATTRIBUTE9VARCHAR2(150),
GLOBAL_ATTRIB
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 选OracleERP库存管理INV8个表结构 ln OracleERP 库存 管理 INV8 结构