ITPub博客

首页 > 数据库 > Oracle > Oracle App 培训笔记(7) -- 成本管理模块表结构整理 续

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

原创 Oracle 作者:zhyuh 时间:2004-11-05 09:33:09 0 删除 编辑

表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

  1. DEPARTMENT_CODE

  2. 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
  1. RESOURCE_ID

Primary Key: BOM_RESOURCES_UK1

  1. RESOURCE_CODE

  2. ORGANIZATION_ID

  3. 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    233
  • 访问量
    2012659