oracle ebs wip表关系（oracle ebs wip table relationship）

《oracle ebs wip表关系（oracle ebs wip table relationship）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、ORACLEEBSWIP表关系（ORACLEEBSWIPtablerelationship）Thetablename:thewip.Wip_accounting_classesDescription:discretejobaccountingCLASS_CODEVARCHAR2(10)accountORGANIZATION_IDNUMBERorganizationcodeCLASS_TYPENUMBERaccounttypeTheDESCRIPTIONVARCHAR2(240)DISABLE_DATEDATEexpirationDATEMATERIAL_ACCOUNTNUMBER

2、materialaccountMATERIAL_VARIANCE_ACCOUNTNUMBERmaterialdifferenceaccountMATERIAL_OVERHEAD_ACCOUNTNUMBERmaterialregularexpenseaccountRESOURCE_ACCOUNTNUMBERresourceaccountRESOURCE_VARIANCE_ACCOUNTNUMBERresourcedifferenceaccountOUTSIDE_PROCESSING_ACCOUNTNUMBEROUTSIDE_PROC_VARIANCE_ACCOUNTNUMBEROV

3、ERHEAD_ACCOUNTNUMBERregularexpenseaccountOVERHEAD_VARIANCE_ACCOUNTNUMBERregularexpensedifferenceaccountSTD_COST_ADJUSTMENT_ACCOUNTNUMBERstandardcostreconciliationaccountCOMPLETION_COST_SOURCENUMBERcompletesthecostsourceTheCOST_TYPE_IDNUMBERcosttypeBRIDGING_ACCOUNTNUMBERtransitionaccountThetab

4、lename:thewip.Wip_comment_codesNote:discretejobannotationsCOMMENT_CODEVARCHAR2(10)commentsORGANIZATION_IDNUMBERorganizationcodeCOMMENT_DESCRIPTIONVARCHAR2(240)Thetablename:thewip.Wip_discrete_jobsExplanation:discreteoperationtableTheWIP_ENTITY_IDNUMBERtaskmakestheinsidecodeORGANIZATION_IDNUMB

5、ERorganizationcodeSOURCE_LINE_IDNUMBERsourcelineNUMBERSourceSOURCE_CODEVARCHAR2(20)TheDESCRIPTIONVARCHAR2(240)STATUS_TYPENUMBERstatePRIMARY_ITEM_IDNUMBERplusartifactFIRM_PLANNED_FLAGNUMBERJOB_TYPENUMBERjobtype(1.Standard,3.Non-standard)TheWIP_SUPPLY_TYPENUMBERsupplytypeCLASS_CODEVARCHAR2(10)t

6、askcategoryMATERIAL_ACCOUNTNUMBERmaterialaccountMATERIAL_OVERHEAD_ACCOUNTNUMBERmaterialregularexpenseaccountRESOURCE_ACCOUNTNUMBERresourceaccountOUTSIDE_PROCESSING_ACCOUNTNUMBER(super)handlestheaccountMATERIAL_VARIANCE_ACCOUNTNUMBERmaterialdifferenceaccountRESOURCE_VARIANCE_ACCOUNTNUMBERresou

7、rcedifferenceaccountOUTSIDE_PROC_VARIANCE_ACCOUNTNUMBER(super)handlesthedifferenceaccountSTD_COST_ADJUSTMENT_ACCOUNTNUMBERstandardcostadjustmentaccountOVERHEAD_ACCOUNTNUMBERrecurringexpenseaccountOVERHEAD_VARIANCE_ACCOUNTNUMBERregularexpensed