非常复杂而多的Table,求一存贮过程,我是初学者,着急在线等!
coaddr: cust_numcust_seq name statecurr_code
D0001820 Vendor_name ECSHCNY
artran:
cust_numinv_numinv_seqtypeco_num acct amount exch_ratesales_tax tax_code1refdo_num
D0001821760ID070000046 11311000 9958.1211692.88ARI176
D0001822110ID070000046 11311000 9958.1211692.88ARI211
CO:
co_num cust_num cust_seq cust_poorder_datepricestatcostsales_tax_ttax_code1 matl_cost_texch_rate
D070046 D000182 0FS0001142007-4-26 61640.76O32899.423385.76 17% 32899.421
serial:
ser_numitem inv_numtrans_num ref_numref_lineref_release
70111006A1-00660 1795 D070046 10
70111306A1-0066176 1795 D070046 10
70111406A1-0066211 1795 D070046 10
journal:
seqacctdom_amountrefvend_num ref_numref_line_sufref_release curr_code exch_ratefor_amount
205540116630.93 IC D070046 D000182 D070046
1 0 CNY 16630.93
20612433-6630.93 IC D070046 D000182 D070046
1 0 CNY 1-6630.93
coitem:
co_numco_lineco_release item qty_ordered qty_readyqty_shippedpricedue_date u_mprice_convco_cust_num
D07004610 06A1-0066 5 23116515-28PCS 11651 D000182
CO_ship:
co_numco_lineco_release qty_invoicedship_date qty_shippedqty_returnedprice
D07004610 1 6-14 1
0 11651
D07004610 1 7-9 1
0 11651
D07004610 0 8-7 1
0 11651
我要得到的数据结果如下:
Vend_numName CO_num Item Date Ser_num invoice QTYprice VAT amount Account
D000182Vender_name D070046 06A1-0066 7-6 0701114 211 1
11,651.00 1,692.88 9,958.12 54011000
[解决办法]
楼主，你问问题的方法真的需要改进。
先不说数据很乱，你也不介绍查询逻辑，你让我们怎么帮你。
