Oracle_ERP_库存管理INV_8个表结构

下载《OracleERPINV模块8个重要表结构》--CreatetablecreatetableINV.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_SEEDpctfree10initrans10maxtrans255storage(initial128next128minextents1maxextentsunlimitedpctincrease0);--Create/RecreateindexescreateindexINV.MTL_TRANSACTION_TYPES_N1onINV.MTL_TRANSACTION_TYPES(TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID)tablespaceAPPS_TS_SEEDpctfree10initrans11maxtrans255storage(initial128Knext128Kminextents1maxextentsunlimitedpctincrease0);createuniqueindexINV.MTL_TRANSACTION_TYPES_U1onINV.MTL_TRANSACTION_TYPES(TRANSACTION_TYPE_ID)tablespaceAPPS_TS_SEEDpctfree10initrans11maxtrans255storage(initial128Knext128Kminextents1maxextentsunlimitedpctincrease0);--Grant/Revokeobjectprivilegesgrantselect,insert,update,delete,references,alter,indexonINV.MTL_TRANSACTION_TYPEStoAPPSwithgrantoption;grantselectonINV.MTL_TRANSACTION_TYPEStoCUX;下载《OracleERPINV模块8个重要表结构》--CreatetablecreatetableINV.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),