浪潮个人往来数据结构

1.职工单据（ZWZGDJ）别名列名数据类型空值缺省规则注释内码ZWZGDJ_NMvarchar(9)N职工编号ZWZGDJ_ZGBHvarchar(20)N会计年度ZWZGDJ_KJNDchar(4)N会计区间ZWZGDJ_KJQJchar(2)N凭证日期ZWZGDJ_PZRQchar(8)N凭证编号ZWZGDJ_PZBHvarchar(8)N分录编号ZWZGDJ_FLBHchar(4)N摘要ZWZGDJ_ZYvarchar(60)N科目编号ZWZGDJ_KMBHvarchar(30)N记账方向ZWZGDJ_JZFXchar(1)外币ZWZGDJ_WBBHvarchar(10)金额ZWZGDJ_JEu001N0外币ZWZGDJ_WBu001N0汇率ZWZGDJ_HLu001N0票据编号ZWZGDJ_PJBHvarchar(20)业务日期ZWZGDJ_YWRQchar(8)责任人ZWZGDJ_ZRRvarchar(20)部门编号ZWZGDJ_BMBHvarchar(20)项目1ZWZGDJ_XM01varchar(20)项目2ZWZGDJ_XM02varchar(20)项目3ZWZGDJ_XM03varchar(20)项目4ZWZGDJ_XM04varchar(20)项目5ZWZGDJ_XM05varchar(20)业务号ZWZGDJ_YWHvarchar(40)核销金额ZWZGDJ_HXJEu001N‘0’核销外币ZWZGDJ_HXWBu001N‘0’完成否ZWZGDJ_WCFchar(1)N‘0’原始编号ZWZGDJ_YSBHchar(4)是否初始ZWZGDJ_SFCSchar(1)‘0’业务号来源ZWZGDJ_YWHLYchar(1)‘0’INDEXzwzgdj1ONZWZGDJ(ZWZGDJ_ZGBH,ZWZGDJ_KMBH,ZWZGDJ_WBBH)UNIQUEINDEXzwzgdj2ONZWZGDJ(ZWZGDJ_NM)2.职工启用（ZWZGQY）别名列名数据类型空值缺省规则注释职工编号ZWZGQY_ZGBHvarchar(20)N科目编号ZWZGQY_KMBHvarchar(30)N币种ZWZGQY_WBBHvarchar(10)日期ZWZGQY_QYRQchar(8)NUNIQUEINDEXzwzgqyONZWZGQY(ZWZGQY_KMBH,ZWZGQY_ZGBH,ZWZGQY_WBBH)3．职工核销（ZWZGHX）别名列名数据类型空值缺省规则注释核销日期ZWZGHX_HXRQvarchar(8)N职工编号ZWZGHX_ZGBHvarchar(20)N会计年度ZWZGHX_KJNDchar(4)N会计区间ZWZGHX_KJQJchar(2)N凭证日期ZWZGHX_PZRQchar(8)N凭证编号ZWZGHX_PZBHvarchar(8)N分录编号ZWZGHX_FLBHchar(4)N摘要ZWZGHX_ZYvarchar(60)N科目编号ZWZGHX_KMBHvarchar(30)N记账方向ZWZGHX_JZFXchar(1)币种ZWZGHX_WBBHvarchar(10)金额ZWZGHX_JEu001N0外币ZWZGHX_WBu001N0汇率ZWZGHX_HLu001N0票据编号ZWZGHX_PJBHvarchar(20)业务日期ZWZGHX_YWRQchar(8)责任人ZWZGHX_ZRRvarchar(20)部门编号ZWZGHX_BMBHvarchar(20)项目1ZWZGHX_XM01varchar(20)项目2ZWZGHX_XM02varchar(20)项目3ZWZGHX_XM03varchar(20)项目4ZWZGHX_XM04varchar(20)项目5ZWZGHX_XM05varchar(20)业务号ZWZGHX_YWHvarchar(40)核销金额ZWZGHX_HXJEu001N‘0’核销外币ZWZGHX_HXWBu001N‘0’完成否ZWZGHX_WCFchar(1)N‘0’原始编号ZWZGHX_YSBHchar(4)内码ZWZGHX_NMvarchar(9)N是否初始ZWZGHX_SFCSc