速达ERP5000数据库表结构.doc

速达ERP5000数据库表结构.doc1
采购计划
PP
P_PurchasePlan P_PurchasePlandetail
2
采购订单
PO
P_Order P_Orderdetail
3
估价入库
PV
P_Value P_Valuedegedetail
63
往来帐核销
AT
A_Counteract A_Counteractdetail
64
开票管理
IN
detail
65
汇兑损益
AE
A_ExchProlos A_ExchProlosDetail
71
POS 零售单
SP
POS_Sale POS_Saledetail
72
POS 出入款单
SM Pos_inoutcash Pos_inoutcashdetail
73
POS 日结单
SF
Pos_close Pos_closedetail
74
POS 储值卡充值
CZ pos_savingcard pos_savingcarddetail
75
POS 促销价调整
CX pos_adjprice pos_adjpricedetail
76
请配单 QD
D_Request D_Requestdetail
77
配送单 DP
D_Distribute D_Distributedetail
78
机会报价单
QU
crm_chance crm_chancedetail
79
行动单 XD
crm
_activity crm_activitydetail
80
员工档案
HE
L_Employ L_Employdetail
81
入职申请单
HA
Hr_Accession Hr_Accessiondetail
82
离职申请单
HD
Hr_Dimission Hr_Dimissiondetail
83
工作调动
HP
Hr_Jobplacement Hr_Jobplacementdetail
84
用工合同
HC
Hr_Laborcontract Hr_Laborcontractdetail
85
薪金调整
HS
Hr_Stipendadjust Hr_Stipendadjustdetail
90
报检单 QB
qlt_apply qlt_applydetail
91
检验单 QC
qlt_checkup qlt_checkupdetail
92
项目检验单
QI
qlt_itemcheckup qlt_itemcheckupdetail
93
内检费用单
QE
qlt_expense qlt_expensedetail
94
设备校验单
QV
qlt_device qlt_devicedetail
111
服务反馈单
AS
Crm_Service Crm_Servicedetail
112
维修派工单
AM
Crm_Manuorder Crm_Manuorderdetail
113
维修验收单
AF
Crm_Finished Crm_Finisheddetail
114
维修发货单
AG
Crm_Consignment Crm_Consignmentdetail
8001
银行存取款
BM AC_Move AC_Movedetail
8002
费用开支
BE AC_Expense AC_Expensedetail
8003
其他收入
BI AC_InCome AC_InComedetail
2402
客户资料
clientlistform
2403
货品资料
goodslistform
2404
仓库资料
storelistform
2405
员工资料
employlistform
2406
部门资料
departmentlistform
2407
出纳帐户
bankactlistform
2410
存货类型
gcmlistform
2411
员工类型资料
emptypelistform
2413
结算方式
paymethodlistform
2416
出入库类型
iotypelistform
2417
2418
2419
2420
2421
2422
2423
2424
2425
2427
2428
2430
2431
2432
2433
2434
2435
2436
2438
2439
2440
2441
2442
2443
2444
2445
2446
2447
2448