GL与其他ERP Module 的联系(Table)

纵横四海 · 发表于 2009/10/6 08:54:37

您需要登录才可以下载或查看，没有帐号？注册

x

1.AR - GL

gl_import_references

①reference_1
--- posting_control_id

reference_2
--- customer_trx_id

AR Transactions GL Journal Name: 'Sales Invoices USD'

reference_3
--- customer_trx_line_gl_dist_id

reference_4
--- trx_number

reference_5
--- batch_source_id

reference_6
=
'CUSTOMER'

AR Receipts GL Journal Name:'Trade Receipts USD'

②
reference_1
--- posting_control_id

reference_2
--- cash_receipt_id&receivable_application_id

或cash_receipt_id&cash_receipt_history_id

2.
PO – GL

rcv_receiving_sub_leger

gl_interface
gl_import_references

rcv_transaction_id
reference25
reference_5

3. AP – GL

ap_ae_lines_all(

gl_sl_link_table: APECL)
gl_import_references
table
Columns

reference_1
po_venders

vender_num

reference_2
ap_invoices_all
invoice_id

reference_3
ap_checks_all
check_id

reference_4

reference_5
ap_invoices_all
invoice_num

4. INV – GL

gl_import_references

reference_1
gl_batch_id

reference_2

reference_3
transaction_id

LC_SH · 发表于 2009/10/16 20:19:56

谢谢，学习下

jerry_wjl · 发表于 2009/10/20 02:42:46

谢谢，学习下

帐号		自动登录	找回密码
密码			注册

社区人物壹佰网重点话题	分享知识原创连载活动正式启动已有673人参加查看全部会员靓照旅行分享文学连载	壹佰读书会开始招收成员了
招聘求职壹佰网信息化选型平台	倾听用户的心声纵横四海谈IT如何提升企业管理管理小说连载《苏州桥》	如何获取努力值
原创连载－我来管管看 ERP分享+	推荐连载：[已结帖][分享知识原创连载]财务供应链项目新手实施手记：记录自己正	入门学习-致所有初学者