Oracle-ERP-库存管理INV-8个表结构.docx
版权申诉
195 浏览量
2024-05-03
12:02:36
上传
评论
收藏 40KB DOCX 举报
下载《Oracle ERP INV 模块 8 个重要表结构》
-- Create table
create table INV.MTL_TRANSACTION_TYPES
(
TRANSACTION_TYPE_ID NUMBER not null,
LAST_UPDATE_DATE DATE not null,
LAST_UPDATED_BY NUMBER not null,
CREATION_DATE DATE not null,
CREATED_BY NUMBER not null,
TRANSACTION_TYPE_NAME VARCHAR2(80) not null,
DESCRIPTION VARCHAR2(240),
TRANSACTION_ACTION_ID NUMBER not null,
TRANSACTION_SOURCE_TYPE_ID NUMBER not null,
SHORTAGE_MSG_BACKGROUND_FLAG VARCHAR2(1),
SHORTAGE_MSG_ONLINE_FLAG VARCHAR2(1),
DISABLE_DATE DATE,
USER_DEFINED_FLAG VARCHAR2(1) not null,
ATTRIBUTE1 VARCHAR2(150),
ATTRIBUTE2 VARCHAR2(150),
ATTRIBUTE3 VARCHAR2(150),
ATTRIBUTE4 VARCHAR2(150),
ATTRIBUTE5 VARCHAR2(150),
ATTRIBUTE6 VARCHAR2(150),
ATTRIBUTE7 VARCHAR2(150),
ATTRIBUTE8 VARCHAR2(150),
ATTRIBUTE9 VARCHAR2(150),
ATTRIBUTE10 VARCHAR2(150),
ATTRIBUTE11 VARCHAR2(150),
ATTRIBUTE12 VARCHAR2(150),
ATTRIBUTE13 VARCHAR2(150),
ATTRIBUTE14 VARCHAR2(150),
ATTRIBUTE15 VARCHAR2(150),
ATTRIBUTE_CATEGORY VARCHAR2(30),
TYPE_CLASS NUMBER,
STATUS_CONTROL_FLAG NUMBER
)
剩余28页未读，继续阅读
资源评论
