WIP模块常用表表名: wip.wip_accounting_classes说明: 离散作业会计科目CLASS_CODE VARCHAR2(10)ORGANIZATION_ID NUMBERCLASS_TYPE NUMBERDESCRIPTION VARCHAR2(240)DISABLE_DATE DATEMATERIAL_ACCOUNT NUMBERMATERIAL_VARIANCE_ACCOUNT NUMBERMATERIAL_OVERHEAD_ACCOUNT NUMBERRESOURCE_ACCOUNT NUMBERRESOURCE_VARIANCE_ACCOUNT NUMBEROUTSIDE_PROCESSING_ACCOUNT NUMBEROUTSIDE_PROC_VARIANCE_ACCONUMBEROVERHEAD_ACCOUNT NUMBEROVERHEAD_VARIANCE_ACCOUNT NUMBERSTD_COST_ADJUSTMENT_ACCOUNNUMBERCOMPLETION_COST_SOURCE NUMBERCOST_TYPE_ID NUMBERBRIDGING_ACCOUNTNUMBER表名: wip.wip_comment_codes说明: 离散作业注释COMMENT_CODE VARCHAR2(10)ORGANIZATION_ID NUMBERCOMMENT_DESCRIPTIONVARCHAR2(240)表名: wip.wip_discrete_jobs说明: 离散作业表WIP_ENTITY_ID NUMBERORGANIZATION_ID NUMBERSOURCE_LINE_ID NUMBERSOURCE_CODE VARCHAR2(20)DESCRIPTION VARCHAR2(240)STATUS_TYPE NUMBERPRIMARY_ITEM_ID NUMBERFIRM_PLANNED_FLAG NUMBERJOB_TYPE NUMBERWIP_SUPPLY_TYPE NUMBERCLASS_CODE VARCHAR2(10)MATERIAL_ACCOUNT NUMBERMATERIAL_OVERHEAD_ACCOUNT NUMBERRESOURCE_ACCOUNT NUMBEROUTSIDE_PROCESSING_ACCOUNTNUMBERMATERIAL_VARIANCE_ACCOUNT NUMBERRESOURCE_VARIANCE_ACCOUNTNUMBEROUTSIDE_PROC_VARIANCE_ACCONUMBERSTD_COST_ADJUSTMENT_ACCOUNTNUMBEROVERHEAD_ACCOUNT NUMBEROVERHEAD_VARIANCE_ACCOUNTNUMBERSCHEDULED_START_DATE DATEDATE_RELEASED DATESCHEDULED_COMPLETION_DATE DATEDATE_COMPLETED DATEDATE_CLOSED DATESTART_QUANTITY NUMBERQUANTITY_COMPLETED NUMBERQUANTITY_SCRAPPED NUMBERNET_QUANTITY NUMBERBOM_REFERENCE_ID NUMBERROUTING_REFERENCE_ID NUMBERCOMMON_BOM_SEQUENCE_IDNUMBERCOMMON_ROUTING_SEQUENCE_IDNUMBERBOM_REVISIONVARCHAR2(3)ROUTING_REVISIONVARCHAR2(3)BOM_REVISION_DATEDATEROUTING_REVISION_DATEDATELOT_NUMBER VARCHAR2(30)ALTERNATE_BOM_DESIGNATOR VARCHAR2(10)ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10)COMPLETION_SUBINVENTORYVARCHAR2(10)COMPLETION_LOCATOR_ID NUMBERMPS_SCHEDULED_COMPLETION_DDATEMPS_NET_QUANTITY NUMBERDEMAND_CLASSVARCHAR2(30)SCHEDULE_GROUP_IDNUMBERBUILD_SEQUENCE NUMBERLINE_IDNUMBER其中STATUS...
