表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
- 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/