Oracle_ERP_库存管理INV_8个表结构
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Oracle_ERP_库存管理INV_8个表结构
下载《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
)
tablespace APPS_TS_SEED
pctfree 10
initrans 10
maxtrans 255
storage
(
initial 128
next 128
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate indexes
create index INV.MTL_TRANSACTION_TYPES_N1 on
INV.MTL_TRANSACTION_TYPES (TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID)
tablespace APPS_TS_SEED
pctfree 10
initrans 11
maxtrans 255
storage
(
initial 128K
next 128K
minextents 1
maxextents unlimited
pctincrease 0
);
create unique index INV.MTL_TRANSACTION_TYPES_U1 on
INV.MTL_TRANSACTION_TYPES (TRANSACTION_TYPE_ID) tablespace APPS_TS_SEED
pctfree 10
initrans 11
maxtrans 255
storage
(
initial 128K
next 128K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Grant/Revoke object privileges
grant select, insert, update, delete, references, alter, index on
INV.MTL_TRANSACTION_TYPES to APPS with grant option;
grant select on INV.MTL_TRANSACTION_TYPES to CUX;
下载《Oracle ERP INV 模块8个重要表结构》
-- Create table
create table INV.MTL_SYSTEM_ITEMS_B (
INVENTORY_ITEM_ID NUMBER not null, ORGANIZATION_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,
LAST_UPDATE_LOGIN NUMBER, SUMMARY_FLAG VARCHAR2(1) not null, ENABLED_FLAG VARCHAR2(1) not null,
START_DATE_ACTIVE DATE,
END_DATE_ACTIVE DATE,
DESCRIPTION VARCHAR2(240),
BUYER_ID NUMBER(9),
ACCOUNTING_RULE_ID NUMBER, INVOICING_RULE_ID NUMBER, SEGMENT1 VARCHAR2(40),
SEGMENT2 VARCHAR2(40),
SEGMENT3 VARCHAR2(40),
SEGMENT4 VARCHAR2(40),
SEGMENT5 VARCHAR2(40),
SEGMENT6 VARCHAR2(40),
SEGMENT7 VARCHAR2(40),
SEGMENT8 VARCHAR2(40),
SEGMENT9 VARCHAR2(40),
SEGMENT10 VARCHAR2(40),
SEGMENT11 VARCHAR2(40),
SEGMENT12 VARCHAR2(40),
SEGMENT13 VARCHAR2(40),
SEGMENT14 VARCHAR2(40),
SEGMENT15 VARCHAR2(40),