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

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