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_VARIANCE_ACCOUNT NUMBER (super) handles the difference account
STD_COST_ADJUSTMENT_ACCOUNT NUMBER standard cost adjustment account
OVERHEAD_ACCOUNT NUMBER recurring expense account
OVERHEAD_VARIANCE_ACCOUNT NUMBER regular expense difference account
SCHEDULED_START_DATE DATE is scheduled to start
Date_release DATE task order release time
SCHEDULED_COMPLETION_DATE DATE is scheduled for completion
DATE_COMPLETED DATE completion time
DATE_CLOSED DATE closing time
The NUMBER of START_QUANTITY NUMBER starts
QUANTITY_COMPLETED NUMBER completion NUMBER
QUANTITY_SCRAPPED NUMBER scrap quantity
NET_QUANTITY NUMBER NUMBER
BOM_REFERENCE_ID NUMBER BOM reference identifier
ROUTING_REFERENCE_ID NUMBER process route reference code
COMMON_BOM_SEQUENCE_ID NUMBER public BOM sequence NUMBER COMMON_ROUTING_SEQUENCE_ID NUMBER public process route NUMBER BOM_REVISION VARCHAR2 (3) BOM version
ROUTING_REVISION VARCHAR2 (3) process route version
BOM_REVISION_DATE DATE DATE BOM version DATE
ROUTING_REVISION_DATE DATE DATE method version DATE
Batch LOT_NUMBER VARCHAR2 (30)
The ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10) replaces the BOM
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10) can replace the process route
reference groupCOMPLETION_SUBINVENTORY VARCHAR2 (10) should be completed into the sublibrary
COMPLETION_LOCATOR_ID NUMBER should be completed
The MPS_SCHEDULED_COMPLETION_DATE datemps plan completion time
MPS_NET_QUANTITY NUMBER NUMBER MPS net NUMBER

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。