资源描述:
《Oracle_ERP_库存管理INV_8个表结构.docx》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、下载《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
2、_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),AT
3、TRIBUTE5VARCHAR2(150),ATTRIBUTE6VARCHAR2(150),ATTRIBUTE7VARCHAR2(150),ATTRIBUTE8VARCHAR2(150),ATTRIBUTE9VARCHAR2(150),ATTRIBUTE10VARCHAR2(150),ATTRIBUTE11VARCHAR2(150),ATTRIBUTE12VARCHAR2(150),ATTRIBUTE13VARCHAR2(150),ATTRIBUTE14VARCHAR2(150),ATTRIBUTE15VARCHAR2(150),ATTRIBUTE_CATEGORYVARCH
4、AR2(30),TYPE_CLASSNUMBER,STATUS_CONTROL_FLAGNUMBER)tablespaceAPPS_TS_SEEDpctfree10initrans10maxtrans255storage(initial128next128minextents1maxextentsunlimitedpctincrease0);--Create/RecreateindexescreateindexINV.MTL_TRANSACTION_TYPES_N1onINV.MTL_TRANSACTION_TYPES(TRANSACTION_SOURCE_TYPE_ID,T
5、RANSACTION_ACTION_ID)tablespaceAPPS_TS_SEEDpctfree10initrans11maxtrans255storage(initial128Knext128Kminextents1maxextentsunlimitedpctincrease0);createuniqueindexINV.MTL_TRANSACTION_TYPES_U1onINV.MTL_TRANSACTION_TYPES(TRANSACTION_TYPE_ID)tablespaceAPPS_TS_SEEDpctfree10initrans11maxtrans255st
6、orage(initial128Knext128Kminextents1maxextentsunlimitedpctincrease0);--Grant/Revokeobjectprivilegesgrantselect,insert,update,delete,references,alter,indexonINV.MTL_TRANSACTION_TYPEStoAPPSwithgrantoption;grantselectonINV.MTL_TRANSACTION_TYPEStoCUX;下载《OracleERPINV模块8个重要表结构》--Createtablecreate
7、tableINV.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,ENABL