Oracle App 培训笔记(7) -- 成本管理模块表结构整理 续

表7. BOM.BOM_DEPARTMENTS 和 8. BOM.BOM_RESOURCES

[@more@]

 

7.    TABLE: BOM.BOM_DEPARTMENTS

BOM_DEPARTMENTS stores department information. You cannot
use the department in an operation after its DISABLE_DATE.
DEPARTMENT_ID uniquely identifies each row. You can assign
a delivery location for each department if you use outside
processing resources.

Primary Key: BOM_DEPARTMENTS_PK
  1. DEPARTMENT_ID

Primary Key: BOM_DEPARTMENTS_UK1

DEPARTMENT_CODE

ORGANIZATION_ID

Columns

Name

Datatype

Length

Mandatory

Comments

DEPARTMENT_ID

NUMBER

 

Yes

Department unique identifier

DEPARTMENT_CODE

VARCHAR2

(10)

Yes

Department code

ORGANIZATION_ID

NUMBER

 

Yes

Organization identifier

DESCRIPTION

VARCHAR2

(240)

 

Description

DISABLE_DATE

DATE

 

 

Disable date

DEPARTMENT_CLASS_CODE

VARCHAR2

(10)

 

Department class code

LOCATION_ID

NUMBER

 

 

Location identifier

PA_EXPENDITURE_ORG_ID

NUMBER

 

 

Organization identifier for the expenditure organization

 

8.    TABLE: BOM.BOM_RESOURCES

BOM_RESOURCES stores information about resources, overheads, material
overheads, and material sub-elements. COST_ELEMENT_ID determines the
type of the resource. Resources are additionally classified as either
material resources or outside processing resources
.
If the resource represents a currency unit, UNIT_OF_MEASURE stores the
currency code associated with the set of books the organization points
to.

 

Primary Key: BOM_RESOURCES_PK
RESOURCE_ID

Primary Key: BOM_RESOURCES_UK1

RESOURCE_CODE

ORGANIZATION_ID

COST_CODE_TYPE

Name

Datatype

Length

Mandatory

Comments

RESOURCE_ID

NUMBER

 

Yes

Resource unique identifier

RESOURCE_CODE

VARCHAR2

(10)

Yes

Resource code

ORGANIZATION_ID

NUMBER

 

Yes

Organization identifier

DESCRIPTION

VARCHAR2

(240)

 

Description

DISABLE_DATE

DATE

 

 

Disable date

COST_ELEMENT_ID

NUMBER

 

Yes

Cost element identifier

PURCHASE_ITEM_ID

NUMBER

 

 

Purchase item identifier

COST_CODE_TYPE

NUMBER

 

Yes

Cost code type

FUNCTIONAL_CURRENCY_FLAG

NUMBER

 

Yes

Unit of measure is functional currency

UNIT_OF_MEASURE

VARCHAR2

(3)

 

Unit of measure

RESOURCE_TYPE

NUMBER

 

 

Resource type

ALLOW_COSTS_FLAG

NUMBER

 

Yes

Allow costs to be defined

EXPENDITURE_TYPE

VARCHAR2

(30)

 

Expenditure type

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/207/viewspace-780031/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/207/viewspace-780031/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值