oracle wip表,ORACLE EBS WIP表关系（ORACLE EBS WIP table relationship）.doc

ORACLE EBS WIP表关系(ORACLE EBS WIP table relationship)

The table name: the wip. Wip_accounting_classes

Description: discrete job accounting

CLASS_CODE VARCHAR2 (10) account

ORGANIZATION_ID NUMBER organization code

CLASS_TYPE NUMBER account type

The DESCRIPTION VARCHAR2 (240)

DISABLE_DATE DATE expiration DATE

MATERIAL_ACCOUNT NUMBER material account

MATERIAL_VARIANCE_ACCOUNT NUMBER material difference account

MATERIAL_OVERHEAD_ACCOUNT NUMBER material regular expense account

RESOURCE_ACCOUNT NUMBER resource account

RESOURCE_VARIANCE_ACCOUNT NUMBER resource difference account

OUTSIDE_PROCESSING_ACCOUNT NUMBER

OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

OVERHEAD_ACCOUNT NUMBER regular expense account

OVERHEAD_VARIANCE_ACCOUNT NUMBER regular expense difference account

STD_COST_ADJUSTMENT_ACCOUNT NUMBER standard cost reconciliation account

COMPLETION_COST_SOURCE NUMBER completes the cost source

The COST_TYPE_ID NUMBER cost type

BRIDGING_ACCOUNT NUMBER transition account

The table name: the wip. Wip_comment_codes

Note: discrete job annotations

COMMENT_CODE VARCHAR2 (10) comments

ORGANIZATION_ID NUMBER organization code

COMMENT_DESCRIPTION VARCHAR2 (240)

The table name: the wip. Wip_discrete_jobs

Explanation: discrete operation table

The WIP_ENTITY_ID NUMBER task makes the inside code

ORGANIZATION_ID NUMBER organization code

SOURCE_LINE_ID NUMBER source line NUMBER

Source SOURCE_CODE VARCHAR2 (20)

The DESCRIPTION VARCHAR2 (240)

STATUS_TYPE NUMBER state

PRIMARY_ITEM_ID NUMBER plus artifact

FIRM_PLANNED_FLAG NUMBER

JOB_TYPE NUMBER job type (1. Standard, 3. Non-standard)

The WIP_SUPPLY_TYPE NUMBER supply type

CLASS_CODE VARCHAR2 (10) task category

MATERIAL_ACCOUNT NUMBER material account

MATERIAL_OVERHEAD_ACCOUNT NUMBER material regular expense account

RESOURCE_ACCOUNT NUMBER resource account

OUTSIDE_PROCESSING_ACCOUNT NUMBER (super) handles the account

MATERIAL_VARIANCE_ACCOUNT NUMBER material difference account

RESOURCE_VARIANCE_ACCOUNT NUMBER resource difference account

OUTSIDE_PROC