|
·ÖÀർº½ |
 |
|
|
|
|
×ÊÔ´´óС£º14.83 KB |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 0 |
|
|
|
×ÊÔ´½éÉÜ |
|
Êý¾ÝÁ÷³ÌÉè¼Æ
101»ù±¾×Öµäн¨¡¢Î¬»¤ºÍ²éѯ
Ö÷Òª¶Ô×Öµä±íwz_zd_class
wz_zd_unit
wz_zd_manufacture
wz_zd_supplyer
wz_zd_group
wz_zd_in_out_typeµÄÊý¾Ý½øÐÐÔö¼Ó¡¢É¾³ýºÍÐ޸ġ£
¶Ô¼Ç¼ÖÃÉÏɾ³ý±êÖ¾ºódeleted_flagÓÉ¡¯0¡¯±äΪ¡¯1¡¯¡£±¾ÏµÍ³ËùÓбíÖеÄdeleted_flag¶¼×ñѸÃÔÔò¡£
102Îï×ÊÏîÄ¿×Öµäн¨¡¢Î¬»¤ºÍ²éѯ
¶Ôwz_dictµÄ¼Ç¼½øÐÐÔö¼Ó¡¢É¾³ýºÍÐ޸ġ£
Îï×ʱàÂëmaterial_codeΪÁ÷Ë®ºÅ£¬ÓÉwz__configureÖеÄkzh_no=¡¯%¡¯µÄ¼Ç¼material_codeÉú³É£¬¼´²»·Ö¿ÆÊÒ£¬È«Ôº´òͨ±àÂë¡£
Èô¸ÃÎï×ÊΪÄÍÓÃÆ·£¬Ôò½«durable_flag±äΪ¡¯1¡¯ ¡£
×¢£º´Ówz_configureÈ¡material_codeʱ£¬ÏÈupdateÆäֵʹ֮¼Ó1£¬update³É¹¦ºóÔÙÈ¡³ö×÷ΪÐÂÔöÎï×ÊÏîÄ¿µÄ±àÂë¡£±¾ÏµÍ³ÖÐËùÓдÓwz_configureÖÐÉú³ÉµÄÁ÷Ë®ºÅ¶¼×ñѸÃÔÔò¡£
103²ÆÎñºËËãÓÃ×Öµäн¨¡¢Î¬»¤ºÍ²éѯ
¶Ô×Öµäwz_zd_acct_property
wz_zd_inner_acct_no½øÐÐÔö¼Ó¡¢É¾³ýºÍÐ޸ġ£
ÈôΪ¿ÆÊÒµÄÄÚ²¿Õ˺ÅÔòÕ˺űàÂëΪ7룬¶ÔÓ¦ÁËzd_unit_codeÖеÄunit_sn£»ÈôΪ¸öÈ˵ÄÄÚ²¿Õ˺ÅÔòÕ˺űàÂëΪ12룬ºó5Ϊ¶ÔÓ¦ÁËa_employee_miÖеÄemp_sn£¬Ç°7λ¶ÔÓ¦ÁËa_employee_miÖÐemp_sn¶ÔÓ¦µÄdept_sn¡£
104¿â´æÎï×Êά»¤¡¢²éѯ
Éú³ÉʱÐèÒª´ÓÎï×ÊÏîÄ¿×ÖµäÖÐÑ¡Ôñ£¬¼´´Ówz_dictÖÐÑ¡Ôñ£¬Éú³ÉʱÔÊÐí¿´µ½µÄÎï×ÊÏîÄ¿ÈôÊDZ¾¿â·¿¶ÔÓ¦µÄÎï×Ê¿ÆÊÒά»¤µÄÎï×Ê£¬Ôò¸ù¾Ý³õʼ»¯ÎļþÖж¨ÒåµÄ¿âÕ˺ŴÓwz_dictÖÐֻȡ³ökzh_noΪ¸Ã²ÎÊýµÄÎï×ÊÏîÄ¿¡£
Éú³ÉʱÏòwz_base²åÈë¼Ç¼£¬ÆäÖУºstock_amount=0
stock_value=0
mini_stock_amount£½0
max_stock_amount£½0
shelf_flag=null
open_flag=¡¯0¡¯
105¿â¹ÜÈë¿â
(1) Èë¿âµ¥Â¼Èë¡¢±£´æ
Ïòwz_in_detl²åÈë¼Ç¼£¬ÆäÖУº
in_date=getdate()
in_serialΪÁ÷Ë®ºÅ£¬´Ówz_configure¶ÔÓ¦kzh_no¼Ç¼µÄin_seriÈ¡£¬Ã¿ÌìÍíÉϺǫ́ÈÎÎñ½«wz_configureµÄin_seriÖÃ0¡£
ÈôÓû§Â¼ÈëµÄΪ²É¹º¼Û¸ñ£¨package_price£©£¬buy_price=²É¹º¼Û¸ñ/package_amount£»ÈôÓû§Â¼ÈëµÄΪ¹ºÈë½ð¶î£¬buy_price=buy_value/£¨package_amount¡ÁÓû§Â¼ÈëµÄ·¢Æ±ÊýÁ¿£©
retprice£½buy_price¡Á£¨1+yp_dictµÄadd_rate£©
buy_valueΪÓû§Â¼ÈëµÄ¹ºÈë½ð¶î£»ÈôÓû§Â¼ÈëµÄΪ²É¹º¼Û£¬buy_value=package_price¡ÁÓû§Â¼ÈëµÄ·¢Æ±ÊýÁ¿
current_stock_amount£½buy_amount
Èôadd_rate£½0£¬current_stock_value=buy_value£¬·ñÔòcurrent_stock_value=retprice¡Ábuy_amount
stock_amount£½null
in_docu_noΪÁ÷Ë®ºÅ£¬´Ówz_configue¶ÔÓ¦kzh_no¼Ç¼µÄin_pagenoÈ¡
input_operΪϵͳµÇ½Óû§
check_flag=¡¯0¡¯
check_oper=null
group_no_out=null
acct_date¡¢acct_oper¡¢acct_pageno£½null
report_date=null
out_date¡¢out_seri=null
(2) ÍË»õµ¥Â¼Èë¡¢±£´æ
¼ÈëÎï×ÊÃû³Æºó£¬Óû§ÐèÑ¡ÔñÍËÄıʣ¬ÏÔʾµÄÈë¿â¼Ç¼´Ówz_in_detlÖÐÈ¡³ö£¬È¡ÊýÌõ¼þ£ºcheck_flag=¡¯1¡¯£¬acct_date£½null£¬in_typeΪÈë¿âµÄ±àÂ룬manu_code<>null£¬group_no_inΪ±¾¿â·¿ºÅ£¬²¢°´in_date¡¢in_seriÉýÐòÅÅÁС£
±£´æºóÏòwz_in_detlÖвåÈë¼Ç¼£¬ÆäÖУº
in_date£½getdate()
in_seri´Ówz_configure¶ÔÓ¦kzh_no¼Ç¼µÄin_seriÈ¡£¨Ã¿Ìõ¼Ç¼·¢ÉúÒ»¸öºÅ£¬wz_out_detlµÄout_seriͬÀí£©
buy_price¡¢retprice¡¢fix_priceΪ¶ÔÓ¦Èë¿â¼Ç¼µÄbuy_price¡¢reprice¡¢fix_price
buy_amount¡¢buy_valueΪ¶ÔÓ¦Èë¿â¼Ç¼buy_amount¡¢buy_vlaueµÄÏà·´Êý£¨¸ºÖµ£©
current_stock_amount¡¢current_stock_value=0
stock_amount=null
in_typeΪÍË»õµÄ±àÂë
in_docu_no´Ówz_configure¶ÔÓ¦kzh_no¼Ç¼µÄin_pagenoÈ¡£¨Ã¿Õŵ¥¾Ý·¢ÉúÒ»¸öºÅ£¬wz_out_detlµÄdraw_noͬÀí£©
check_flag=¡¯0¡¯
check_oper=null
group_no_out=null
manu_codeΪ¶ÔÓ¦Èë¿â¼Ç¼µÄmanu_code
acct_date¡¢acct_oper¡¢acct_pageno¡¢report_date£½null
out_date¡¢out_seriΪ¶ÔÓ¦Èë¿â¼Ç¼µÄin_date¡¢in_seri
£¨3£©Î´ÉóºËµ¥¾Ý²éѯ¡¢ÐÞ¸Ä
²éѯÌõ¼þ£ºcheck_flag=¡¯0¡¯£¬group_no_inΪ±¾¿â·¿ºÅ¡£
Ð޸ĵ¥¾Ýupdate wz_in_detlÖжÔÓ¦µÄÈë¿â/ÍË»õ¼Ç¼
ÌØÊâÒµÎñ£º×¨¹ºÆ·¹ý·£¨²»ÐèÒªÉóºË£©
a.Ïòwz_out_detlÖвåÈë¼Ç¼£¬ÆäÖУº
out_date=getdate()
out_seriΪÁ÷Ë®ºÅ£¬´Ówz_configureÖжÔÓ¦kzh_no¼Ç¼µÄout_seriÈ¡
in_dateΪ¶ÔӦר¹ºÈë¿â¼Ç¼µÄin_date¡¢in_seri
issue_amount£½¶ÔÓ¦Èë¿â¼Ç¼µÄbuy_amount
stock_amount¡¢in_stock_amount=null
giverΪϵͳµÇ½Óû§
eff_date¡¢buy_price¡¢retprice¡¢fix_priceΪ¶ÔÓ¦Èë¿â¼Ç¼µÄeff_date¡¢buy_price¡¢retprice¡¢fix_price
draw_noΪÁ÷Ë®ºÅ£¬´Ówz_configureÖжÔÓ¦¶ÔÓ¦kzh_no¼Ç¼µÄout_pagenoÈ¡
out_typeΪר¹º³ö¿â±àÂë
group_no_outΪ¶ÔÓ¦Èë¿â¼Ç¼µÄgroup_no_in
group_no_in =null
allo_unit¡¢allo_price£½null
accept_flag=¡¯0¡¯
report_date=null
b.Ïòwz_in_detlÖвåÈë¼Ç¼£¬ÆäÖÐÓëÆÕͨÈë¿â²»Í¬µÄ´¦Àí°üÀ¨£º
check_flag=¡¯1¡¯
check_oper£½input_oper
in_typeΪר¹ºÈë¿â±àÂë
106Èë¿âÉóºË
£¨1£© Èë¿â/ÍË»õµ¥ÉóºË
a.update wz_in_detlµÄÈë¿â/ÍË»õ¼Ç¼£¬¸üÐÂ×ֶΰüÀ¨£º
check_flagÓÉ¡¯0¡¯ÖÃΪ¡¯1¡¯
|
|
ÏÂÔØµØÖ· |
|
|
|
|
|