ERP接口表SQL.docx
- 文档编号:3729756
- 上传时间:2022-11-25
- 格式:DOCX
- 页数:10
- 大小:16.17KB
ERP接口表SQL.docx
《ERP接口表SQL.docx》由会员分享,可在线阅读,更多相关《ERP接口表SQL.docx(10页珍藏版)》请在冰豆网上搜索。
ERP接口表SQL
1、客户接口表(TMSIO11)
createtableTMSIO11(
IMPORT_IDNUMBER(18)notnull,
CLIENT_IDNUMBER(18)notnull,
CLIENT_CODEVARCHAR2(20),
CLIENT_NAMEVARCHAR2(200),
OU_IDNUMBER(18),
LAST_UPDATE_TIMEDATE,
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO11primarykey(IMPORT_ID)
);
commentoncolumnTMSIO11.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO11.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
2、供应商接口表(TMSIO12)
createtableTMSIO12(
IMPORT_IDNUMBER(18)notnull,
SUPPLIER_IDNUMBER(18)notnull,
SUPPLIER_CODEVARCHAR2(20),
SUPPLIER_NAMEVARCHAR2(200),
OU_IDNUMBER(18),
LAST_UPDATE_TIMEDATE,
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO12primarykey(IMPORT_ID)
);
commentoncolumnTMSIO12.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO12.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
3、物料接口表(TMSIO18)
createtableTMSIO18(
IMPORT_IDNUMBER(18)notnull,
MATERIAL_IDNUMBER(18)notnull,
MATERIAL_CODEVARCHAR2(20)notnull,
MATERIAL_NAMEVARCHAR2(200)notnull,
MATERIAL_SPECVARCHAR2(80),
MATERIAL_UNITVARCHAR2(40)default'吨',
MATERIAL_TYPECHAR
(1)notnull,
PROCESS_TIMEDATE,
PROCESS_FLAGCHAR
(1)default'0'notnull,
LAST_UPDATE_TIMEDATE,
constraintPK_TMSIO18primarykey(IMPORT_ID)
);
commentoncolumnTMSIO18.MATERIAL_IDis
'计量系统增加的为负数';
commentoncolumnTMSIO18.MATERIAL_TYPEis
'1-原料,2-辅料,3-废料';
commentoncolumnTMSIO18.PROCESS_FLAGis
'0-未处理,1-已处理';
4、物料库存组织接口表(TMSIO19)
createtableTMSIO19(
IMPORT_IDNUMBER(18)notnull,
MATERIAL_IDNUMBER(18)notnull,
ORG_IDNUMBER(18)notnull,
USE_FLAGCHAR
(1)default'1'notnull,
QUALITY_FLAGVARCHAR2(50)default'1',
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO19primarykey(IMPORT_ID)
);
commentoncolumnTMSIO19.MATERIAL_IDis
'计量系统增加的为负数';
commentoncolumnTMSIO19.USE_FLAGis
'0-停用,1-使用';
commentoncolumnTMSIO19.QUALITY_FLAGis
'0-直接,1-标准,2-质检';
commentoncolumnTMSIO19.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO19.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
5、库存组织接口表(TMSIO13)
createtableTMSIO13(
IMPORT_IDNUMBER(18)notnull,
ORG_IDNUMBER(18)notnull,
ORG_NAMEVARCHAR2(200)notnull,
ORG_CODEVARCHAR2(20),
OU_IDNUMBER(18),
LAST_UPDATE_TIMEDATEnotnull,
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO13primarykey(IMPORT_ID)
);
commentoncolumnTMSIO13.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO13.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
6、业务实体接口表(TMSIO20)
createtableTMSIO20(
IMPORT_IDNUMBER(18)notnull,
OU_IDNUMBER(18)notnull,
OU_CODEVARCHAR2(20),
OU_NAMEVARCHAR2(200),
LAST_UPDATE_TIMEDATE,
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO20primarykey(IMPORT_ID)
);
commentoncolumnTMSIO20.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO20.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
7、帐户别名接口表(TMSIO15)
createtableTMSIO15(
IMPORT_IDNUMBER(18)notnull,
ACCOUNT_IDNUMBER(18)notnull,
ACCOUNT_NAMEVARCHAR2(200),
ACCOUNT_CODEVARCHAR2(80),
LAST_UPDATE_TIMEDATE,
ORG_IDNUMBER(18),
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO15primarykey(IMPORT_ID)
);
commentoncolumnTMSIO15.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO15.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
8、子库存接口表(TMSIO16)
createtableTMSIO16(
IMPORT_IDNUMBER(18)notnull,
STOCK_NAMEVARCHAR2(200),
STOCK_CODEVARCHAR2(20),
LAST_UPDATE_TIMEDATE,
ORG_IDNUMBER(18),
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO16primarykey(IMPORT_ID)
);
commentoncolumnTMSIO16.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO16.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
9、仓库货位接口表(TMSIO17)
createtableTMSIO17(
IMPORT_IDNUMBER(18)notnull,
GOOD_IDNUMBER(18)notnull,
GOOD_CODEVARCHAR2(20)notnull,
GOOD_NAMEVARCHAR2(200),
STOCK_CODEVARCHAR2(20),
LAST_UPDATE_TIMEDATE,
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO17primarykey(IMPORT_ID)
);
commentoncolumnTMSIO17.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO17.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
10、订单接口表(TMSIO21)
createtableTMSIO21(
IMPORT_IDNUMBER(18)notnull,
ORDER_HEAD_IDNUMBER(18)notnull,
ORDER_LINE_IDNUMBER(18)notnull,
ORDER_NOVARCHAR2(20),
GRANDT_NOVARCHAR2(20),
ORDER_TYPEVARCHAR2(20),
QUALITY_FLAGVARCHAR2(50),
SUPPLIER_IDNUMBER(18),
MATERIAL_IDNUMBER(18),
MATERIAL_CODEVARCHAR2(20)notnull,
MATERIAL_NAMEVARCHAR2(200)notnull,
MATERIAL_SPECVARCHAR2(80),
MATERIAL_UNITVARCHAR2(40)default'吨',
ORDER_WGTNUMBER(18,4),
LAST_UPDATE_TIMEDATE,
CLOSE_FLAGCHAR
(1)default'0',
OU_IDNUMBER(18),
ORG_IDNUMBER(18)notnull,
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0'notnull,
PROCESS_TIMEDATE,
constraintPK_TMSIO21primarykey(IMPORT_ID)
);
commentoncolumnTMSIO21.ORDER_TYPEis
'一揽子协议、标准订单';
commentoncolumnTMSIO21.CLOSE_FLAGis
'0-未关闭,1-已关闭';
commentoncolumnTMSIO21.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO21.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
11、库存事务类型接口表(TMSIO14)
createtableTMSIO14(
IMPORT_IDNUMBER(18)notnull,
TRANS_IDNUMBER(18)notnull,
TRANS_CODEVARCHAR2(20)notnull,
TRANS_NAMEVARCHAR2(200)notnull,
LAST_UPDATE_TIMEDATE,
MODIFY_FLAGCHAR
(1),
PROCESS_INFOVARCHAR2(200),
PROCESS_FLAGCHAR
(1)default'0',
PROCESS_TIMEDATE,
constraintPK_TMSIO14primarykey(IMPORT_ID)
);
commentoncolumnTMSIO14.MODIFY_FLAGis
'1-新增,2-修改';
commentoncolumnTMSIO14.PROCESS_FLAGis
'0-未处理,1-成功,2-失败';
12、计量称重接口表(TMSIO23)
createtableTMSIO23(
MEASURE_IDNUMBER(18)notnull,
ERP_MEASURE_FLAGCHAR
(1)notnull,
FAC_IDNUMBER(6)notnull,
MATERIAL_IDNUMBER(18)notnull,
MATERIAL_CODEVARCHAR2(20)notnull,
MATERIAL_NAMEVARCHAR2(200)notnull,
MATERIAL_SPECVARCHAR2(80),
MATERIAL_UNITVARCHAR2(40)default'吨',
PLAN_WGTNUMBER(18,4),
NET_WGTNUMBER(18,4),
IN_OUT_FLAGCHAR
(1)default'0'notnull,
A_GOOD_NAMEVARCHAR2(200),
A_GOOD_IDNUMBER(18),
S_GOOD_NAMEVARCHAR2(200),
S_GOOD_IDNUMBER(18),
A_ORG_NAMEVARCHAR2(200),
A_ORG_IDNUMBER(18),
S_ORG_NAMEVARCHAR2(200),
S_ORG_IDNUMBER(18),
A_STOCK_CODEVARCHAR2(20),
A_STOCK_NAMEVARCHAR2(200),
S_STOCK_CODEVARCHAR2(20),
S_STOCK_NAMEVARCHAR2(200),
SUPPLIER_IDNUMBER(18),
SUPPLIER_CODEVARCHAR2(20),
SUPPLIER_NAMEVARCHAR2(200),
SEND_NOVARCHAR2(20),
ORDER_NOVARCHAR2(20),
ORDER_HEAD_IDNUMBER(18),
ORDER_LINE_IDNUMBER(18),
LINK_IDVARCHAR2(80),
ERP_FLAGCHAR
(1)default'0'notnull,
ERP_TIMEDATE,
QUALITY_RESULTCHAR
(1)default'0'notnull,
SUB_WGTNUMBER(18,4),
BACK_WGTNUMBER(18,4),
RECEIVE_NOVARCHAR2(20),
ACCOUNT_IDNUMBER(18),
ACCOUNT_NAMEVARCHAR2(200),
ACCOUNT_CODEVARCHAR2(20),
TRANS_IDNUMBER(18),
TRANS_CODEVARCHAR2(20),
TRANS_NAMEVARCHAR2(200),
constraintPK_TMSIO23primarykey(MEASURE_ID)
);
commentoncolumnTMSIO23.ERP_MEASURE_FLAGis
'1-接收、2-接收事务处理、3-退货、4-子库存转移、5-组织间转移、6-组织间间接转移、7-杂项';
commentoncolumnTMSIO23.MATERIAL_IDis
'计量系统增加的为负数';
commentoncolumnTMSIO23.PLAN_WGTis
'销售为提货重量,采购为送货重量,否则为投料重量。
退料,调拨为0,没有计划。
';
commentoncolumnTMSIO23.IN_OUT_FLAGis
'0-出库,1-入库,2-调拨';
commentoncolumnTMSIO23.ERP_FLAGis
'0-未处理,1-已处理';
commentoncolumnTMSIO23.QUALITY_RESULTis
'0-未处理,1-合格,2-不合格';
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ERP 接口 SQL
![提示](https://static.bdocx.com/images/bang_tan.gif)