选OracleERP库存管理INV8个表结构 ln.docx

1、选OracleERP库存管理INV8个表结构 lnOracle_ERP_库存管理INV_8个表结构下载Oracle ERP INV 模块8个重要表结构 - Create tablecreate 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_

2、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),ATTRIB

3、UTE2 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),AT

4、TRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE_CATEGORY VARCHAR2(30),TYPE_CLASS NUMBER,STATUS_CONTROL_FLAG NUMBER)tablespace APPS_TS_SEEDpctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);- Create/Recreate indexes create index INV.

5、MTL_TRANSACTION_TYPES_N1 on INV.MTL_TRANSACTION_TYPES (TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID)tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_TRANSACTION_TYPES_U1 on INV.MTL_TRA

6、NSACTION_TYPES (TRANSACTION_TYPE_ID)tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);- Grant/Revoke object privileges grant select, insert, update, delete, references, alter, index on INV.MTL_TRANSACTION_TYPES to APPS

7、 with grant option;grant select on INV.MTL_TRANSACTION_TYPES to CUX;下载Oracle ERP INV 模块8个重要表结构 - Create tablecreate 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 nul

8、l,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 VARCHAR

9、2(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),SE

10、GMENT16 VARCHAR2(40),SEGMENT17 VARCHAR2(40),SEGMENT18 VARCHAR2(40),SEGMENT19 VARCHAR2(40),SEGMENT20 VARCHAR2(40),ATTRIBUTE_CATEGORY VARCHAR2(30),ATTRIBUTE1 VARCHAR2(240),ATTRIBUTE2 VARCHAR2(240),ATTRIBUTE3 VARCHAR2(240),ATTRIBUTE4 VARCHAR2(240),ATTRIBUTE5 VARCHAR2(240),ATTRIBUTE6 VARCHAR2(240),ATTRI

11、BUTE7 VARCHAR2(240),ATTRIBUTE8 VARCHAR2(240),ATTRIBUTE9 VARCHAR2(240),ATTRIBUTE10 VARCHAR2(240),ATTRIBUTE11 VARCHAR2(240),ATTRIBUTE12 VARCHAR2(240),ATTRIBUTE13 VARCHAR2(240),ATTRIBUTE14 VARCHAR2(240),ATTRIBUTE15 VARCHAR2(240),PURCHASING_ITEM_FLAG VARCHAR2(1) not null,SHIPPABLE_ITEM_FLAG VARCHAR2(1)

12、not null,CUSTOMER_ORDER_FLAG VARCHAR2(1) not null,INTERNAL_ORDER_FLAG VARCHAR2(1) not null,SERVICE_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ITEM_FLAG VARCHAR2(1) not null,ENG_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ASSET_FLAG VARCHAR2(1) not null,PURCHASING_ENABLED_FLAG VARCHAR2(1) not null,CUSTOME

13、R_ORDER_ENABLED_FLAG VARCHAR2(1) not null,INTERNAL_ORDER_ENABLED_FLAG VARCHAR2(1) not null,SO_TRANSACTIONS_FLAG VARCHAR2(1) not null,MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2(1) not null,STOCK_ENABLED_FLAG VARCHAR2(1) not null,BOM_ENABLED_FLAG VARCHAR2(1) not null,BUILD_IN_WIP_FLAG VARCHAR2(1) not null

14、,REVISION_QTY_CONTROL_CODE NUMBER,ITEM_CATALOG_GROUP_ID NUMBER,CATALOG_STATUS_FLAG VARCHAR2(1),RETURNABLE_FLAG VARCHAR2(1),DEFAULT_SHIPPING_ORG NUMBER,COLLATERAL_FLAG VARCHAR2(1),TAXABLE_FLAG VARCHAR2(1),QTY_RCV_EXCEPTION_CODE VARCHAR2(25),ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2(1),INSPECTION_REQUIRED_

15、FLAG VARCHAR2(1),RECEIPT_REQUIRED_FLAG VARCHAR2(1),MARKET_PRICE NUMBER,HAZARD_CLASS_ID NUMBER,RFQ_REQUIRED_FLAG VARCHAR2(1),QTY_RCV_TOLERANCE NUMBER,LIST_PRICE_PER_UNIT NUMBER,UN_NUMBER_ID NUMBER,PRICE_TOLERANCE_PERCENT NUMBER,ASSET_CATEGORY_ID NUMBER,ROUNDING_FACTOR NUMBER,UNIT_OF_ISSUE VARCHAR2(25

16、),ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25),ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1),ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1),ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2(1),DAYS_EARLY_RECEIPT_ALLOWED NUMBER,DAYS_LATE_RECEIPT_ALLOWED NUMBER,RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25),RECEIVING_ROUTING_ID N

17、UMBER,INVOICE_CLOSE_TOLERANCE NUMBER,RECEIVE_CLOSE_TOLERANCE NUMBER,AUTO_LOT_ALPHA_PREFIX VARCHAR2(30),START_AUTO_LOT_NUMBER VARCHAR2(30),LOT_CONTROL_CODE NUMBER,SHELF_LIFE_CODE NUMBER,SHELF_LIFE_DAYS NUMBER,SERIAL_NUMBER_CONTROL_CODE NUMBER,START_AUTO_SERIAL_NUMBER VARCHAR2(30),AUTO_SERIAL_ALPHA_PR

18、EFIX VARCHAR2(30),SOURCE_TYPE NUMBER,SOURCE_ORGANIZATION_ID NUMBER,SOURCE_SUBINVENTORY VARCHAR2(10),EXPENSE_ACCOUNT NUMBER,ENCUMBRANCE_ACCOUNT NUMBER,RESTRICT_SUBINVENTORIES_CODE NUMBER,UNIT_WEIGHT NUMBER,WEIGHT_UOM_CODE VARCHAR2(3),VOLUME_UOM_CODE VARCHAR2(3),UNIT_VOLUME NUMBER,RESTRICT_LOCATORS_CO

19、DE NUMBER,LOCATION_CONTROL_CODE NUMBER,SHRINKAGE_RATE NUMBER,ACCEPTABLE_EARLY_DAYS NUMBER,PLANNING_TIME_FENCE_CODE NUMBER,DEMAND_TIME_FENCE_CODE NUMBER,LEAD_TIME_LOT_SIZE NUMBER,STD_LOT_SIZE NUMBER,CUM_MANUFACTURING_LEAD_TIME NUMBER,OVERRUN_PERCENTAGE NUMBER,MRP_CALCULATE_ATP_FLAG VARCHAR2(1),ACCEPT

20、ABLE_RATE_INCREASE NUMBER,ACCEPTABLE_RATE_DECREASE NUMBER,CUMULATIVE_TOTAL_LEAD_TIME NUMBER,PLANNING_TIME_FENCE_DAYS NUMBER,DEMAND_TIME_FENCE_DAYS NUMBER,END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1),REPETITIVE_PLANNING_FLAG VARCHAR2(1),PLANNING_EXCEPTION_SET VARCHAR2(10),BOM_ITEM_TYPE NUMBER not null,PICK_

21、COMPONENTS_FLAG VARCHAR2(1) not null,REPLENISH_TO_ORDER_FLAG VARCHAR2(1) not null,BASE_ITEM_ID NUMBER,ATP_COMPONENTS_FLAG VARCHAR2(1) not null,ATP_FLAG VARCHAR2(1) not null,FIXED_LEAD_TIME NUMBER,VARIABLE_LEAD_TIME NUMBER,WIP_SUPPLY_LOCATOR_ID NUMBER,WIP_SUPPLY_TYPE NUMBER,WIP_SUPPLY_SUBINVENTORY VA

22、RCHAR2(10),PRIMARY_UOM_CODE VARCHAR2(3),PRIMARY_UNIT_OF_MEASURE VARCHAR2(25),ALLOWED_UNITS_LOOKUP_CODE NUMBER,COST_OF_SALES_ACCOUNT NUMBER,SALES_ACCOUNT NUMBER,DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2(1),INVENTORY_ITEM_STATUS_CODE VARCHAR2(10) not null,INVENTORY_PLANNING_CODE NUMBER,PLANNER_CODE VARC

23、HAR2(10),PLANNING_MAKE_BUY_CODE NUMBER,FIXED_LOT_MULTIPLIER NUMBER,ROUNDING_CONTROL_TYPE NUMBER,CARRYING_COST NUMBER,POSTPROCESSING_LEAD_TIME NUMBER,PREPROCESSING_LEAD_TIME NUMBER,FULL_LEAD_TIME NUMBER,ORDER_COST NUMBER,MRP_SAFETY_STOCK_PERCENT NUMBER,MRP_SAFETY_STOCK_CODE NUMBER,MIN_MINMAX_QUANTITY

24、 NUMBER,MAX_MINMAX_QUANTITY NUMBER,MINIMUM_ORDER_QUANTITY NUMBER,FIXED_ORDER_QUANTITY NUMBER,FIXED_DAYS_SUPPLY NUMBER,MAXIMUM_ORDER_QUANTITY NUMBER,ATP_RULE_ID NUMBER,PICKING_RULE_ID NUMBER,RESERVABLE_TYPE NUMBER,POSITIVE_MEASUREMENT_ERROR NUMBER,NEGATIVE_MEASUREMENT_ERROR NUMBER,ENGINEERING_ECN_COD

25、E VARCHAR2(50),ENGINEERING_ITEM_ID NUMBER,ENGINEERING_DATE DATE,SERVICE_STARTING_DELAY NUMBER,VENDOR_WARRANTY_FLAG VARCHAR2(1) not null,SERVICEABLE_COMPONENT_FLAG VARCHAR2(1),SERVICEABLE_PRODUCT_FLAG VARCHAR2(1) not null,BASE_WARRANTY_SERVICE_ID NUMBER,PAYMENT_TERMS_ID NUMBER,PREVENTIVE_MAINTENANCE_

26、FLAG VARCHAR2(1),PRIMARY_SPECIALIST_ID NUMBER,SECONDARY_SPECIALIST_ID NUMBER,SERVICEABLE_ITEM_CLASS_ID NUMBER,TIME_BILLABLE_FLAG VARCHAR2(1),MATERIAL_BILLABLE_FLAG VARCHAR2(30),EXPENSE_BILLABLE_FLAG VARCHAR2(1),PRORATE_SERVICE_FLAG VARCHAR2(1),COVERAGE_SCHEDULE_ID NUMBER,SERVICE_DURATION_PERIOD_CODE

27、 VARCHAR2(10),SERVICE_DURATION NUMBER,WARRANTY_VENDOR_ID NUMBER,MAX_WARRANTY_AMOUNT NUMBER,RESPONSE_TIME_PERIOD_CODE VARCHAR2(30),RESPONSE_TIME_VALUE NUMBER,NEW_REVISION_CODE VARCHAR2(30),INVOICEABLE_ITEM_FLAG VARCHAR2(1) not null,TAX_CODE VARCHAR2(50),INVOICE_ENABLED_FLAG VARCHAR2(1) not null,MUST_

28、USE_APPROVED_VENDOR_FLAG VARCHAR2(1) not null,REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE,OUTSIDE_OPERATION_FLAG VARCHAR2(1) not null,OUTSIDE_OPERATION_UOM_TYPE VARCHAR2(25),SAFETY_STOCK_BUCKET_DAYS NUMBER,AUTO_REDUCE_MPS NUMBER(22),COSTING_ENABLED_FLAG

29、 VARCHAR2(1) not null,AUTO_CREATED_CONFIG_FLAG VARCHAR2(1) not null,CYCLE_COUNT_ENABLED_FLAG VARCHAR2(1) not null,ITEM_TYPE VARCHAR2(30),MODEL_CONFIG_CLAUSE_NAME VARCHAR2(10),SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1),MRP_PLANNING_CODE NUMBER,RETURN_INSPECTION_REQUIREMENT NUMBER,ATO_FORECAST_CONTROL NUMBE

30、R,RELEASE_TIME_FENCE_CODE NUMBER,RELEASE_TIME_FENCE_DAYS NUMBER,CONTAINER_ITEM_FLAG VARCHAR2(1),VEHICLE_ITEM_FLAG VARCHAR2(1),MAXIMUM_LOAD_WEIGHT NUMBER,MINIMUM_FILL_PERCENT NUMBER,CONTAINER_TYPE_CODE VARCHAR2(30),INTERNAL_VOLUME NUMBER,WH_UPDATE_DATE DATE,PRODUCT_FAMILY_ITEM_ID NUMBER,GLOBAL_ATTRIB

31、UTE_CATEGORY VARCHAR2(150),GLOBAL_ATTRIBUTE1 VARCHAR2(150),GLOBAL_ATTRIBUTE2 VARCHAR2(150),GLOBAL_ATTRIBUTE3 VARCHAR2(150),GLOBAL_ATTRIBUTE4 VARCHAR2(150),GLOBAL_ATTRIBUTE5 VARCHAR2(150),GLOBAL_ATTRIBUTE6 VARCHAR2(150),GLOBAL_ATTRIBUTE7 VARCHAR2(150),GLOBAL_ATTRIBUTE8 VARCHAR2(150),GLOBAL_ATTRIBUTE9 VARCHAR2(150),GLOBAL_ATTRIB