速达ERP5000数据库表结构docWord格式.docx
《速达ERP5000数据库表结构docWord格式.docx》由会员分享,可在线阅读,更多相关《速达ERP5000数据库表结构docWord格式.docx(135页珍藏版)》请在冰豆网上搜索。
S_OrderS_Orderdetail
13
委托代销
SD
S_DeputeSaleS_DeputeSaledetail
14
销售开单
SS
S_SaleS_Saledetail
15
发出商品
SG
S_SendOutGoodsS_SendOutGoodsdetail
16
出口订单
FO
F_ExportOrderF_ExportOrderDetail
17
出口单证
FE
F_ExportF_ExportDetail
18
装箱单
FL
F_ExportLoadF_ExportLoadDetail
21
出入库单
IO
I_IOStoreI_IOStoredetail
22
其他收货单
OI
I_OtherInI_OtherIndetail
23
其他发货单
OO
I_OtherOutI_OtherOutdetail
25
领料单
DR
I_DrawI_Drawdetail
26
调拨单
AL
I_AllotI_Allotdetail
27
组装单
CO
I_combinI_combindetail
28
拆卸单
DC
I_DisCombinI_DisCombindetail
29
报损单
AT
I_AttaintI_Attaintdetail
30
盘点单
BA
I_BalItemI_BalItemdetail
31
调价单
AD
I_ADJAPI_ADJAPdetail
32
货位调整单
PA
I_PlaceAdjustI_PlaceAdjustdetail
40
采购费用分摊
PUp_PPurchaseAppp_PPurchaseAppdetail
41
验收单
MF
MNF_FinishedMNF_Finisheddetail
42
加工单
MMMNF
_ManuOrderMNF_ManuOrderdetail
43
主生产计划
MP
MNF_ManuPlanMNF_ManuPlan
44
MRP运算
MR
MNF_MrpMNF_Mrpdetail
45
费用分摊
ME
MNF_ExpenseMNF_Expensedetail
46
在制品单
MWMNF_ManuWorkMNF_ManuWorkdetail
47
工序计划单
WP
W_PlanW_Plandetail
48
工序流程
卡
WOW_ProcW_Procdetail
49
工序交接单
WA
W_PassW_passItem
50
工序调度单
WDW_DispatchW_Dispatchdetail
51
银行存取款
BM
B_MoveB_Movedetail
52
费用开支
BE
B_ExpenseB_Expensedetail
53
其他收入
BI
B_InComeB_InComedetail
54
委托加工单
CM
Cm_MachiningCm_Machiningdetail
55
委托加工领料单
CDCm_DrawCm_Drawdetail
56
委托加工验收单
CFCm_FinishedCm_Finisheddetail
57
委托加工费用单
CECm_ExpenseCm_Expensedetail
58
委托加工费用分摊单
CACm_ExpenseAppCm_ExpenseAppdetail
61
应付款单
AP
A_PayA_Paydetail
62
应收款单
AC
A_ChargeA_Chargedetail
63
往来帐核销
A_CounteractA_Counteractdetail
64
开票管理
IN
detail
65
汇兑损益
AE
A_ExchProlosA_ExchProlosDetail
71
POS零售单
POS_SalePOS_Saledetail
72
POS出入款单
SMPos_inoutcashPos_inoutcashdetail
73
POS日结单
SF
Pos_closePos_closedetail
74
POS储值卡充值
CZpos_savingcardpos_savingcarddetail
75
POS促销价调整
CXpos_adjpricepos_adjpricedetail
76
请配单QD
D_RequestD_Requestdetail
77
配送单DP
D_DistributeD_Distributedetail
78
机会报价单
QU
crm_chancecrm_chancedetail
79
行动单XD
crm
_activitycrm_activitydetail
80
员工档案
HE
L_EmployL_Employdetail
81
入职申请单
HA
Hr_AccessionHr_Accessiondetail
82
离职申请单
HD
Hr_DimissionHr_Dimissiondetail
83
工作调动
HP
Hr_JobplacementHr_Jobplacementdetail
84
用工合同
HC
Hr_LaborcontractHr_Laborcontractdetail
85
薪金调整
HS
Hr_StipendadjustHr_Stipendadjustdetail
90
报检单QB
qlt_applyqlt_applydetail
91
检验单QC
qlt_checkupqlt_checkupdetail
92
项目检验单
QI
qlt_itemcheckupqlt_itemcheckupdetail
93
内检费用单
QE
qlt_expenseqlt_expensedetail
94
设备校验单
QV
qlt_deviceqlt_devicedetail
111
服务反馈单
AS
Crm_ServiceCrm_Servicedetail
112
维修派工单
AM
Crm_ManuorderCrm_Manuorderdetail
113
维修验收单
AF
Crm_FinishedCrm_Finisheddetail
114
维修发货单
AG
Crm_ConsignmentCrm_Consignmentdetail
8001
BMAC_MoveAC_Movedetail
8002
BEAC_ExpenseAC_Expensedetail
8003
BIAC_InComeAC_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
2450
2451
2452
2454
2455
2456
2457
2458
2459
2460
2461
2462
2464
2465
2466
往来单位案例tradercaselistform产品案例goodscaselistform备忘录todolistform
到期货品报警maturegoodsform超期应收款duegatheringform超期应付款duepaymentform初始化货品库存goodsinitlistform往来单位跟踪价格settraderpricelistform车间资料workshoplistform分仓库存onhandlistform设置货品价格setgoodspriceform银行bankdatalistform任务类别tasktypelistform项目任务jobtasklistform项目资料joblistform公告信息informationlistform
公告栏boardlistform
POS机器posmachinelistform
柜台资料poscounterlistform会员卡posviplistform储值卡possavingscardlistform储值卡类型possavingstypelistform采购订单到期报警maturedpurchaseorderform
销售订单到期报警maturedsaleorderform
货品库存报警goodsstockwarningform分支机构资料shoplistform单位组unitgrouplistform加工类型machiningtypelistform委托加工费用名称machiningexpenselistform供应商资料vendorlistform替代品资料subgoodslistform机构间业务核算类型betweenshoplistform班组资料workgrouplistform工作中心workcenterlistform工序资料workproclistform工艺路线worklinelistform
bankactwarningformsalemsnmodellistformpurchasemsnmodellistformcontractwarningfo