oracle ebs有多少表,oracle ebs各表关系.ppt

oracle ebs各表关系

概要 符号说明 库存(INV) 库存(INV) 库存(INV) 库存(INV) 库存(INV) 库存(INV) 库存(INV) 库存(INV) 库存(INV) 采购(PO) 采购(PO) 采购(PO) 采购(PO) 采购(PO) 采购(PO) 订单管理(OM) 订单管理(OM) 订单管理(OM) 物料清单(BOM) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 在制品(WIP) 成本(COST) 成本(COST) 成本(COST) 总帐(GL) 总帐(GL) 总帐(GL) 总帐(GL) 应收(AR) 应收(AR) 应收(AR) 应付(AP) 应付(AP) 应付(AP) 固定资产(FA) 固定资产(FA) 固定资产(FA) 弹性域 表名缩写对照表 弹性域 弹性域 表名缩写对照表 并发管理器 并发处理 表名缩写对照表 标准请求 表名缩写对照表 功能安全 登录安全 表名缩写对照表 预置文件 数据字典 货币与语言 MTL_MATERIAL_TXN_ALLOCATIONS This table stores the repetitive schedules charged by a material transaction. Each row contains the quantity transacted to each schedule for a given transaction. Oracle Work in Process uses this information to report changes to individual schedules for multischedule material transactions. The primary key is TRANSACTION_ID, REPETITIVE_SCHEDULE_ID, ORGANIZATION_ID. WIP_TRANSACTIONS This table stores information about each resource transaction in Oracle Work in Process. Oracle Work in Process uses this information to track resources and to calculate values stored in WIP_TRANSACTION_ACCOUNTS. The primary key is TRANSACTION_ID. WIP_MOVE_TRANSACTIONS WIP_MOVE_TRANSACTIONS stores information about shop floor move transactions. Each row represents a single move transaction and includes a unique transaction ID, a transaction date, the job or repetitive schedule in which the move occurs, the quantity moved, the from and to operation sequence numbers, operation codes, and intraoperation steps. Oracle Work in Process uses this information to track move transactions. The primary key is TRANSACTION_ID. WIP_MOVE_TXN_ALLOCATIONS This table stores Move quantity information for single shop floor Move transactions that transcend multiple repetitive schedules. The primary key is TRANSACTION_ID, REPETITIVE_SCHEDULE_ID. WIP_TXN_ALLOCATIONS WIP_TXN_ALLOCATIONS stores resource information for single resource cost transactions that transcend multiple repetitive schedules. Oracle Work in Process allocates