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/