数据库数据字典

字段名	数据类型	字段说明
billdate	datetime	-
pzlbz	varchar	-
pzh	varchar	-
fjzs	numeric	-
zy	varchar	-
kmcode	varchar	-
jftotal	numeric	-
dtotal	numeric	-
field1	varchar	-
field2	varchar	-
Field3	varchar	-
cbill	varchar	-
csettle	char	-
cn_id	char	-
dt_date	datetime	-
cdept_id	varchar	-
cperson_id	varchar	-
csup_id	varchar	-
ccus_id	varchar	-
cname	varchar	-
citem_id	varchar	-
billtype	int	-

AdPriceBill (库存成本调价单)

字段名	数据类型	字段说明
BillID	ctID	单据ID
Comment	ctComment	备注
PRec	ctID	商品
Qty	ctQty	数量
AssQty	ctQty	单据数量
Price	ctPrice	单价
AssPrice	ctPrice	单据单价
total	ctTotal	金额
JobNumber	ctShortStr	批号
GoodsNo	int	GoodsNo
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
CostPrice	ctPrice	成本单价
unit	tinyint	单位
UnitRate	smallmoney	单位比率
ProviderId	ctID	供应商
PtypeSource	tinyint	商品来源
ord	int	行号
GRec	ctID	货位
StockUniqueid	uniqueidentifier	入库唯一标志
StockUniqueid2	uniqueidentifier	入库唯一标志2
KRec	ctID	仓库
JobCode	ctShortStr	药品监管码
StopUse	tinyint	停售标志
GermJobNumber	ctShortStr	灭菌批号
kcqty	ctQty	库存数量
CheckReportNo	ctShortStr	药监报告好
ChangeID	ctInt	-
newGJobid	bigint	-
GJobID	bigint	-
NewJobtaxprice	ctPrice	-

↑ 回到目录

AdjustJobNumberBill

字段名	数据类型	字段说明
BillID	ctID	-
PRec	ctID	-
KRec	ctID	-
GoodsID	ctInt	-
Unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
Price	ctPrice	-
OldJobNumber	ctShortStr	-
OldOutFactoryDate	ctDate	-
OldValidityPeriod	ctDate	-
NewJobNumber	ctShortStr	-
NewOutFactoryDate	ctDate	-
NewValidityPeriod	ctDate	-
Comment	ctComment	-
Ord	ctInt	-
ProviderID	ctID	-
PTypeSource	tinyint	-
GRec	ctID	-
StockUniqueid	ctUID	-
StockUniqueid2	ctUID	-
OldJobCode	ctShortStr	-
NewJobCode	ctShortStr	-
StopUse	tinyint	-
OldGermJobNumber	ctShortStr	-
NewGermJobNumber	ctShortStr	-
OldCheckReportNo	ctShortStr	-
NewCheckReportNo	ctShortStr	-
ChangeID	ctInt	-
oldGJobID	bigint	-
newGJobID	bigint	-

↑ 回到目录

AdjustPriceD

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
PRec	ctID	-
Unit	smallint	-
BatchStdPrice	ctPrice	-
RetailStdPrice	ctPrice	-
RetailPrice	ctPrice	-
PrePrice1	ctPrice	-
PrePrice2	ctPrice	-
PrePrice3	ctPrice	-
PrePrice4	ctPrice	-
PrePrice5	ctPrice	-
PrePrice6	ctPrice	-
PrePrice7	ctPrice	-
PrePrice8	ctPrice	-
PrePrice9	ctPrice	-
PrePrice10	ctPrice	-
PrePrice11	ctPrice	-
PrePrice12	ctPrice	-
PrePrice13	ctPrice	-
PrePrice14	ctPrice	-
PrePrice15	ctPrice	-
recprice	ctPrice	-
MinPrice	ctPrice	-
MaxPrice	ctPrice	-
VipPrice	ctPrice	-
bRetailPrice	money	-
bMinprice	money	-
bMaxprice	money	-
bVipprice	money	-
bPrePrice1	money	-
bPrePrice2	money	-
bPrePrice3	money	-
bPrePrice4	money	-
bPrePrice5	money	-
bPrePrice6	money	-
bPrePrice7	money	-
bPrePrice8	money	-
bPrePrice9	money	-
bPrePrice10	money	-
bPrePrice11	money	-
bPrePrice12	money	-
bPrePrice13	money	-
bPrePrice14	money	-
bPrePrice15	money	-
TinyPrice	money	-
bTinyPrice	money	-
CommRetailPrice	money	-
bCommRetailPrice	money	-

↑ 回到目录

字段名	数据类型	字段说明
billid	ctID	-
posid	ctID	-
billstatus	ctID	-

字段名	数据类型	字段说明
Typeid	varchar	科目编号
ClassType	int	财务系统编号
kmbh	varchar	对应科目编号
J_D	varchar	借贷关系

字段名	数据类型	字段说明
Rec	ctInt	-
type	ctID	-
ent_name	ctName	-
ref_ent_id	ctShortStr	-
ent_id	ctShortStr	-
network_type	ctShortStr	-
last_verdate	ctShortStr	-
_MD	timestamp	-

字段名	数据类型	字段说明
Guiud	ctUID	-
prec	ctID	-
krec	ctID	-
grec	ctID	-
qty	ctQty	-
jobnumber	ctComment	-

Android_FTP_Task

字段名	数据类型	字段说明
AutoID	int	-
FileTime	nvarchar	-
Android_Path	nvarchar	-
Android_FtpIP	nvarchar	-
Android_FtpPort	nvarchar	-
Android_FtpUser	nvarchar	-
Android_FtpPw	nvarchar	-
Android_Number	nvarchar	-
IsAgain	int	-
FileSize	nvarchar	-
CurrFileSize	nvarchar	-
Task_State	int	-
ErrorMessage	nvarchar	-
TableNum	int	-
CurrTableNum	int	-
RowNum	int	-
CurrRowNum	int	-
Data_DataBase	nvarchar	-
M_DataBase	nvarchar	-
M_TableName	nvarchar	-
M_SelectSql	nvarchar	-
IsZip	int	-
Other	nvarchar	-
Other_ConnStr	nvarchar	-
Other_SelectSql	nvarchar	-
FTP_Code	nvarchar	-
IsWebFTP	nvarchar	-
FTP_IP	nvarchar	-
FTP_Port	nvarchar	-
FTP_User	nvarchar	-
FTP_PW	nvarchar	-
FTP_DownFilePath	nvarchar	-

↑ 回到目录

字段名	数据类型	字段说明
ArchivesType	char	-
Leveal	tinyint	-
AutoCode	tinyint	-
Length	tinyint	-
MaxLevel	tinyint	-
MaxLength	tinyint	-
Counter	int	-

字段名	数据类型	字段说明
Rec	ctID	片区数字ID
TypeID	ctTypeID	片区字符ID
ParID	ctTypeID	父节点字符ID
Leveal	tinyint	当前级别
Sonnum	ctInt	当前儿子数
SonCount	ctInt	历史儿子数
usercode	ctShortStr	用户编码
Fullname	ctName	片区全称
Name	ctName	片区简称
PYZJM	ctShortStr	拼音助记码
Comment	ctComment	注释
deleted	ctbit	是否删除
Updatetag	ctInt	Updatetag
RowIndex	ctInt	默认排序行号
OutDay	ctInt	-

字段名	数据类型	字段说明
ERec	ctID	-
StartDate	datetime	-
EndDate	datetime	-
ID	ctID	-
Date	datetime	-

Atype (会计科目表)

字段名	数据类型	字段说明
Rec	ctID	会计科目数字ID
typeId	ctTypeID	会计科目字符ID
parid	ctTypeID	父节点字符ID
leveal	tinyint	当前级别
sonnum	ctInt	当前儿子数
soncount	ctInt	历史儿子数
FullName	ctName	会计科目全称
Name	ctName	会计科目简称
UserCode	ctShortStr	会计科目编号
Comment	ctComment	备注
Total	ctTotal	科目总余额
Total00	ctTotal	科目期初余额
sysflag	char	科目标识
sysrow	ctbit	系统标识
deleted	ctbit	是否删除
PYZJM	ctShortStr	拼音助记码
WBZJM	ctShortStr	五笔助记码
UFUserCode	varchar	用友接口代码
Counter	ctInt	序号
_Md	timestamp	同步标志
Updatetag	ctInt	Updatetag
RowIndex	varchar	默认排序行号
OnLinePay	ctShortStr	-

↑ 回到目录

字段名	数据类型	字段说明
Period	tinyint	-
ARec	ctID	-
Total	ctTotal	-

字段名	数据类型	字段说明
krec	ctInt	-
CareE	ctInt	-
Keeper	ctInt	-
Principal	ctInt	-
selected	int	-
ORec	ctInt	-

字段名	数据类型	字段说明
ID	ctUID	-
AutoDate	ctDate	-
ERec	ctInt	-

字段名	数据类型	字段说明
Billdate	datetime	-
PRec	int	-
KRec	int	-
Total	money	-
Qty	numeric	-
taxCostTotal	money	-
taxCostPrice	money	-

字段名	数据类型	字段说明
TableName	varchar	-
FirstRun	bit	-
SumProc	varchar	-
LastRunDate	datetime	-

字段名	数据类型	字段说明
MonthNo	datetime	-
BillType	int	-
ERec	int	-
officeid	int	-
BRec	int	-
ORec	int	-
HKTotal	ctTotal	-
XSTotal	ctTotal	-
CBTotal	ctTotal	-
FYTotal	ctTotal	-
FKTotal	ctTotal	-
TaxCostTotal	ctTotal	-
TaxSaleLR	ctTotal	-
JSTotal	ctTotal	-
XSML	ctTotal	-
SaleCount	ctInt	-
NoBackXSTotal	ctTotal	-
period	tinyint	-
MinusTotal	ctTotal	-
RealTotal	ctTotal	-
RealtaxTotal	ctTotal	-

字段名	数据类型	字段说明
id	ctID	-
name	varchar	-
posreclist	varchar	-
posnamelist	varchar	-
area	int	-
zq	varchar	-
date	varchar	-
billtypelist	varchar	-
billtypenamelist	varchar	-
bhindex	int	-
gs	varchar	-
gsshow	varchar	-
bhdays	int	-
xsdays	int	-

字段名	数据类型	字段说明
id	ctID	-
name	varchar	-
posreclist	varchar	-
posnamelist	varchar	-
area	int	-
zq	varchar	-
date	varchar	-
billtypelist	varchar	-
billtypenamelist	varchar	-
bhindex	int	-
gs	varchar	-
gsshow	varchar	-
bhdays	int	-
xsdays	int	-

字段名	数据类型	字段说明
billid	ctInt	-
ord	ctInt	-
prec	ctInt	-
unit	ctInt	-
times	ctInt	-
TinyPrice	money	-
RetailPrice	money	-
Minprice	money	-
Maxprice	money	-
Vipprice	money	-
PrePrice1	money	-
PrePrice2	money	-
PrePrice3	money	-
PrePrice4	money	-
PrePrice5	money	-
PrePrice6	money	-
PrePrice7	money	-
PrePrice8	money	-
PrePrice9	money	-
PrePrice10	money	-
PrePrice11	money	-
PrePrice12	money	-
PrePrice13	money	-
PrePrice14	money	-
PrePrice15	money	-
CommRetailPrice	money	-

字段名	数据类型	字段说明
billid	int	-
BillDate	datetime	-
BillCode	varchar	-
BillType	smallint	-
posrec	ctInt	-
ERec	ctInt	-
CheckEID	ctInt	-
Comment	ctComment	-
Explain	ctComment	-
BillStatus	smallint	-
checkdate	datetime	-
printnum	int	-
isupload	int	-
UniqueBillid	uniqueidentifier	-

字段名	数据类型	字段说明
Id	int	-
Name	varchar	-

字段名	数据类型	字段说明
Id	int	-
ReportId	int	-
LoginID	int	-
BillTypeID	int	-

字段名	数据类型	字段说明
Id	int	-
TypeId	int	-
Name	nvarchar	-
Start	numeric	-
End	numeric	-

字段名	数据类型	字段说明
BRec	ctID	单位数字ID
AttorneyID	ctShortStr	委托书编号
Name	ctShortStr	委托人姓名
IDCard	ctShortStr	身份证号码
Area	varchar	受托区域
BeginDate	ctDate	开始日期
EndDate	datetime	结束日期
imageid	int	图片ID
Flags	int	标志
ID	int	-
wtType	ctInt	-
Comment	ctComment	-
ywType	tinyint	-
PosId	ctInt	-
isStop	bit	-

字段名	数据类型	字段说明
BRec	ctID	单位数字ID
PRec	ctID	商品数字ID
ID	int	-

字段名	数据类型	字段说明
BRec	ctID	-
ARJSTotal	ctTotal	-
APJSTotal	ctTotal	-

字段名	数据类型	字段说明
SelfbtID	ctInt	-
CRec	ctInt	-
down	ctQty	-
up	ctQty	-

字段名	数据类型	字段说明
SelfbtID	ctInt	-
UpdateDay	ctComment	-
SaleDay	ctInt	-
SelfType	ctInt	-
BillType	ctComment	-
Express	varchar	-

BaseCustomFields (基本信息自定义字段表)

字段名	数据类型	字段说明
ID	ctID	ID
IDFlag	ctInt	对应基本信息主表
BaseRec	ctID	基本信息Rec
C0	ctComment	自定义字段0
C1	ctComment	自定义字段1
C2	ctComment	自定义字段2
C3	ctComment	自定义字段3
C4	ctComment	自定义字段4
C5	ctComment	自定义字段5
C6	ctComment	自定义字段6
C7	ctComment	自定义字段7
C8	ctComment	自定义字段8
C9	ctComment	自定义字段9
C10	ctComment	-
C11	ctComment	-
C12	ctComment	-
C13	ctComment	-
C14	ctComment	-
C15	ctComment	-
C16	ctComment	-
C17	ctComment	-
C18	ctComment	-
C19	ctComment	-
C20	varchar	-
C21	varchar	-
C22	varchar	-
C23	varchar	-
C24	varchar	-
C25	varchar	-
C26	varchar	-
C27	varchar	-
C28	varchar	-
C29	varchar	-
C30	varchar	-
C31	varchar	-
C32	varchar	-
C33	varchar	-
C34	varchar	-
C35	varchar	-
C36	varchar	-
C37	varchar	-
C38	varchar	-
C39	varchar	-
C40	varchar	-
C41	varchar	-
C42	varchar	-
C43	varchar	-
C44	varchar	-
C45	varchar	-
C46	varchar	-
C47	varchar	-
C48	varchar	-
C49	varchar	-

↑ 回到目录

字段名	数据类型	字段说明
ChangeID	int	修改的记录ID
BaseType	tinyint	基本信息类型
BaseRec	ctID	基本信息id
Name	ctName	当时的名称

字段名	数据类型	字段说明
ID	int	约束大于100000
FieldName	nvarchar	-
Type	varchar	-
DisplayName	nvarchar	-
TableName	nvarchar	-
Flag	int	第一位是否用于查询条件、第二位是否用于grid列显示、第三位是否用于grid隐藏列、第四位是否用于汇总依据
CreateDate	datetime	-
Visible	bit	-
Auth	varchar	-
Order	int	-
FieldRename	varchar	-
KindList	int	-
TableReName	varchar	-

BillIndex (单据索引表)

字段名	数据类型	字段说明
BillID	ctID	单据ID
BillDate	ctBillDate	制单日期
BillCode	ctShortStr	单据编号
BillType	smallint	单据类型
Comment	ctComment	备注
BRec	ctID	往来单位Rec
ERec	ctID	经手人Rec
KRec	ctID	仓库Rec
KRec2	ctID	仓库2Rec
checke	ctID	审核人
IFChecked	ctbit	IFChecked
BillE	ctID	制单人
totalmoney	ctTotal	含税总金额
totalinmoney	ctTotal	实际收付现金额
totalqty	ctQty	总数量
BenefitMoney	ctTotal	优惠金额
tax	ctTax	税率
period	tinyint	单据期号
explain	ctComment	说明
RedWord	bit	是否红字单据
draft	bit	是否过账
OrderId	ctInt	定单ID号
Department	ctID	经手人所在部门ID
posid	ctID	门店ID
area	ctID	往来单位所在片区ID
AuditingDate	datetime	过账日期
MoneyDate	ctDate	收款期限
JsYetotal	ctTotal	未结余额
JsFlag	char	结算标志
QualityStatus	tinyint	质检状态标志
GspId	ctID	GSP单据内部ID
PriceDiff	tinyint	退补标志
UniqueBillid	uniqueidentifier	单据唯一ID
RedBillid	uniqueidentifier	红字单据ID
NextBillid	uniqueidentifier	原单ID
InvoiceId	uniqueidentifier	发票ID
BillStatus	tinyint	（单据状态，表示单据传输状态： 0表示普通单据或还未传输 11表示门店上传到配送中心单据 13表示配送中心单据已经下传到门店）
PrintTime	smallint	打印次数
nSysFlag	tinyint	系统标志
OfficeId	ctID	操作门店ID
OutStockLaw	char	出库规则
SendWay	ctComment	送货方式
IsRedWordNew	tinyint	红冲生成新单
BillDetailCount	int	单据明细行数
CanDelete	tinyint	能否删除
HandoverTime	datetime	零售交班时间
invoice	ctShortStr	进项发票号
Status	tinyint	-
Flag	int	-
VipCardID	int	-
ChangeID	ctInt	-
Auditid	int	-
JSBRec	int	-
BillTime	datetime	-
_MD	timestamp	-
ORec	int	-
ORec2	int	-
InvoiceCode	varchar	-

↑ 回到目录

BillIndex_HIS

字段名	数据类型	字段说明
BillID	ctID	-
BillDate	ctBillDate	-
BillCode	ctShortStr	-
BillType	smallint	-
Comment	ctComment	-
BRec	ctID	-
ERec	ctID	-
KRec	ctID	-
KRec2	ctID	-
checke	ctID	-
IFChecked	ctbit	-
BillE	ctID	-
totalmoney	ctTotal	-
totalinmoney	ctTotal	-
totalqty	ctQty	-
BenefitMoney	ctTotal	-
tax	ctTax	-
period	tinyint	-
explain	ctComment	-
RedWord	bit	-
draft	bit	-
OrderId	ctInt	-
Department	ctID	-
posid	ctID	-
area	ctID	-
AuditingDate	datetime	-
MoneyDate	ctDate	-
JsYetotal	ctTotal	-
JsFlag	char	-
QualityStatus	tinyint	-
GspId	ctID	-
PriceDiff	tinyint	-
UniqueBillid	uniqueidentifier	-
RedBillid	uniqueidentifier	-
NextBillid	uniqueidentifier	-
InvoiceId	uniqueidentifier	-
BillStatus	tinyint	-
PrintTime	smallint	-
nSysFlag	tinyint	-
OfficeId	ctID	-
OutStockLaw	char	-
SendWay	ctComment	-
IsRedWordNew	tinyint	-
BillDetailCount	int	-
CanDelete	tinyint	-
HandoverTime	datetime	-
invoice	ctShortStr	-
Status	tinyint	-
Flag	int	-
VipCardID	int	-
ChangeID	ctInt	-
Auditid	int	-
JSBRec	int	-
BillTime	datetime	-
_MD	timestamp	-
ORec	int	-
ORec2	int	-
InvoiceCode	varchar	-

↑ 回到目录

BillIndexhis (单据索引表2)

字段名	数据类型	字段说明
BillDate	ctBillDate	制单日期
BillCode	ctShortStr	单据编号
BillType	smallint	单据类型
Comment	ctComment	备注
BRec	ctID	往来单位Rec
ERec	ctID	经手人Rec
KRec	ctID	仓库Rec
KRec2	ctID	仓库2Rec
checke	ctID	审核人Rec
IFChecked	ctbit	IFChecked
BillE	ctID	制单人Rec
totalmoney	ctTotal	金额
totalinmoney	ctTotal	实际收付现金额
totalqty	ctQty	数量
BenefitMoney	ctTotal	优惠金额
tax	ctTax	税率
period	tinyint	单据期号
explain	ctComment	说明
RedWord	bit	是否红字
draft	bit	是否过账
OrderId	ctInt	订单ID
Department	ctID	经手人所在部门
posid	ctID	门店ID
area	ctID	片区
AuditingDate	datetime	过账日期
MoneyDate	ctDate	收款期限
JsYetotal	ctTotal	未结金额
JsFlag	char	结算标志
QualityStatus	tinyint	质检状态
GspId	ctID	GspId
PriceDiff	tinyint	退补标志
UniqueBillid	uniqueidentifier	单据唯一编号
RedBillid	uniqueidentifier	红字单据编号
NextBillid	uniqueidentifier	原单唯一编号
InvoiceId	uniqueidentifier	发票号
BillStatus	tinyint	单据状态
PrintTime	smallint	打印次数
nSysFlag	tinyint	系统标志
OfficeId	ctID	机构ID
OutStockLaw	char	出库规则
SendWay	ctComment	送货方式
IsRedWordNew	tinyint	IsRedWordNew
BillDetailCount	int	单据明细行数
CanDelete	tinyint	是否删除
HandoverTime	datetime	零售单过账日期
invoice	ctShortStr	进项发票号
BillID	int	单据ID
Status	tinyint	-
Flag	int	-

↑ 回到目录

BillindexBak

字段名	数据类型	字段说明
BillDate	ctBillDate	-
BillCode	ctShortStr	-
BillType	smallint	-
Comment	ctComment	-
BRec	ctID	-
ERec	ctID	-
KRec	ctID	-
KRec2	ctID	-
checke	ctID	-
IFChecked	ctbit	-
BillE	ctID	-
totalmoney	ctTotal	-
totalinmoney	ctTotal	-
totalqty	ctQty	-
BenefitMoney	ctTotal	-
tax	ctTax	-
period	tinyint	-
explain	ctComment	-
RedWord	bit	-
draft	bit	-
OrderId	ctInt	-
Department	ctID	-
posid	ctID	-
area	ctID	-
AuditingDate	datetime	-
MoneyDate	ctDate	-
JsYetotal	ctTotal	-
JsFlag	char	-
QualityStatus	tinyint	-
GspId	ctID	-
PriceDiff	tinyint	-
UniqueBillid	uniqueidentifier	-
RedBillid	uniqueidentifier	-
NextBillid	uniqueidentifier	-
InvoiceId	uniqueidentifier	-
BillStatus	tinyint	-
PrintTime	smallint	-
nSysFlag	tinyint	-
OfficeId	ctID	-
OutStockLaw	char	-
SendWay	ctComment	-
IsRedWordNew	tinyint	-
BillDetailCount	int	-
CanDelete	tinyint	-
HandoverTime	datetime	-
VipCardID	int	-
ChangeID	ctInt	-
JSBRec	int	-
BillTime	datetime	-
_MD	timestamp	-
ORec	int	-
ORec2	int	-
InvoiceCode	varchar	-
BillID	int	-

↑ 回到目录

BtypeModify

字段名	数据类型	字段说明
ID	ctID	-
LoginUser	ctID	-
QualityID	ctID	-
Rec	ctID	-
typeId	ctTypeID	-
parid	ctTypeID	-
leveal	tinyint	-
soncount	int	-
sonnum	int	-
UserCode	ctShortStr	-
FullName	ctName	-
Name	ctName	-
Area	int	-
Tel	ctShortStr	-
Address	ctComment	-
PostCode	varchar	-
Person	ctShortStr	-
TaxNumber	ctShortStr	-
Bank	ctMidStr	-
Account	ctMidStr	-
Comment	ctComment	-
ARTotal	ctTotal	-
APTotal	ctTotal	-
CreditCount	ctTotal	-
ARTotal00	ctTotal	-
APTotal00	ctTotal	-
deleted	ctbit	-
PYZJM	ctShortStr	-
WBZJM	ctShortStr	-
PriceMode	tinyint	-
preArTotal	ctTotal	-
preArTotal00	ctTotal	-
preApTotal	ctTotal	-
preApTotal00	ctTotal	-
FirstCheck	tinyint	-
UFUserCode	varchar	-
CreditDays	int	-
ifUnitType	tinyint	-
Email	ctShortStr	-
Fax	ctShortStr	-
ID_Card	ctMidStr	-
LinkPhone	ctShortStr	-
corporation	ctShortStr	-
ProjectType	ctInt	-
charter	ctShortStr	-
license	ctShortStr	-
scope	ctComment	-
UID	ctUID	-
Counter	int	-
isclient	tinyint	-
_Md	timestamp	-
SendWay	ctComment	-
ERec	ctID	-
StopSale	ctbit	-
GSPValidityPeriod	ctDate	-
AddDate	ctDate	-
EditDate	ctDate	-
Updatetag	ctInt	-
RowIndex	varchar	-
BTypeFlags	bigint	-
GMPGSPCode	ctShortStr	-
YfQuota	ctTotal	-
ckdz	ctComment	-
JSBRec	ctID	-
ckdz2	varchar	-
ckdz3	varchar	-
ckdz4	varchar	-
IncomeBillJsType	int	-
PayBillJsType	int	-
PriceRate	numeric	-

↑ 回到目录

BtypeTemp

字段名	数据类型	字段说明
Rec	int	-
typeId	ctTypeID	-
parid	ctTypeID	-
leveal	tinyint	-
soncount	int	-
sonnum	int	-
UserCode	ctShortStr	-
FullName	ctName	-
Name	ctName	-
Area	int	-
Tel	ctShortStr	-
Address	ctComment	-
PostCode	varchar	-
Person	ctShortStr	-
TaxNumber	ctShortStr	-
Bank	ctMidStr	-
Account	ctMidStr	-
Comment	ctComment	-
ARTotal	ctTotal	-
APTotal	ctTotal	-
CreditCount	ctTotal	-
ARTotal00	ctTotal	-
APTotal00	ctTotal	-
deleted	ctbit	-
PYZJM	ctShortStr	-
WBZJM	ctShortStr	-
PriceMode	tinyint	-
preArTotal	ctTotal	-
preArTotal00	ctTotal	-
preApTotal	ctTotal	-
preApTotal00	ctTotal	-
FirstCheck	tinyint	-
UFUserCode	varchar	-
CreditDays	int	-
ifUnitType	tinyint	-
Email	ctShortStr	-
Fax	ctShortStr	-
ID_Card	ctMidStr	-
LinkPhone	ctShortStr	-
corporation	ctShortStr	-
ProjectType	ctInt	-
charter	ctShortStr	-
license	ctShortStr	-
scope	ctComment	-
UID	ctUID	-
Counter	int	-
isclient	tinyint	-
SendWay	ctComment	-
ERec	ctID	-
StopSale	ctbit	-
GSPValidityPeriod	ctDate	-
AddDate	ctDate	-
EditDate	ctDate	-
RowIndex	varchar	-
BTypeFlags	bigint	-
Updatetag	ctInt	-
GMPGSPCode	ctShortStr	-
YfQuota	ctTotal	-
YSTotal	ctTotal	-
YFTotal	ctTotal	-
YsTotal00	ctTotal	-
YFTotal00	ctTotal	-
ckdz	ctComment	-
ChangeID	ctID	-
WebUniCode	ctShortStr	-
JSBRec	ctID	-
C0	ctComment	-
C1	ctComment	-
C2	ctComment	-
C3	ctComment	-
C4	ctComment	-
C5	ctComment	-
C6	ctComment	-
C7	ctComment	-
C8	ctComment	-
C9	ctComment	-
C10	ctComment	-
C11	ctComment	-
C12	ctComment	-
C13	ctComment	-
C14	ctComment	-
C15	ctComment	-
C16	ctComment	-
C17	ctComment	-
C18	ctComment	-
C19	ctComment	-
C20	varchar	-
C21	varchar	-
C22	varchar	-
C23	varchar	-
C24	varchar	-
C25	varchar	-
C26	varchar	-
C27	varchar	-
C28	varchar	-
C29	varchar	-
C30	varchar	-
C31	varchar	-
C32	varchar	-
C33	varchar	-
C34	varchar	-
C35	varchar	-
C36	varchar	-
C37	varchar	-
C38	varchar	-
C39	varchar	-
C40	varchar	-
C41	varchar	-
C42	varchar	-
C43	varchar	-
C44	varchar	-
C45	varchar	-
C46	varchar	-
C47	varchar	-
C48	varchar	-
C49	varchar	-
editoper	varchar	-
ckdz2	varchar	-
ckdz3	varchar	-
ckdz4	varchar	-
IncomeBillJsType	int	-
PayBillJsType	int	-

↑ 回到目录

BuyBill (采购入库单)

字段名	数据类型	字段说明
BillID	int	单据ID
KRec	ctID	仓库Rec
GRec	ctID	货位Rec
PRec	ctID	商品Rec
Qty	ctQty	入库数量
AssQty	ctQty	单据数量
SalePrice	ctPrice	采购单价
AssSalePrice	ctPrice	单据单价
discount	ctDiscount	折扣
DiscountPrice	ctPrice	折扣单价
AssDiscountPrice	ctPrice	单据折扣单价
total	ctTotal	金额
tax	ctTax	税率
TaxPrice	ctPrice	含税单价
AssTaxPrice	ctPrice	单据含税单价
TaxTotal	ctTotal	含税金额
CostPrice	ctPrice	成本单价
jobnumber	ctShortStr	批次
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
ProviderId	ctID	供应商
PtypeSource	tinyint	商品来源
comment	ctComment	备注
Eligible	ctShortStr	合格标志
unit	tinyint	单位
UnitRate	smallmoney	单位比率
buyid	ctInt	GSP标志
retailprice	ctPrice	零售价
ord	ctInt	单据内部编号
BackQty	ctQty	退货数量
StockUniqueid	ctUID	入库唯一标志
PriceDiffQty	ctQty	退补数量
PriceType	tinyint	单价类型
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
ChangeID	ctInt	-
BackReason	varchar	-
CheckResult	varchar	-
SNTEXT	text	-
JGMQty	int	-
_MD	timestamp	-
GJobid	bigint	-

↑ 回到目录

BuyBill_His

字段名	数据类型	字段说明
BillID	int	-
KRec	ctID	-
GRec	ctID	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
SalePrice	ctPrice	-
AssSalePrice	ctPrice	-
discount	ctDiscount	-
DiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
CostPrice	ctPrice	-
jobnumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
ProviderId	ctID	-
PtypeSource	tinyint	-
comment	ctComment	-
Eligible	ctShortStr	-
unit	tinyint	-
UnitRate	smallmoney	-
buyid	ctInt	-
retailprice	ctPrice	-
ord	ctInt	-
BackQty	ctQty	-
StockUniqueid	ctUID	-
PriceDiffQty	ctQty	-
PriceType	tinyint	-
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
ChangeID	ctInt	-
BackReason	varchar	-
CheckResult	varchar	-
SNTEXT	text	-
JGMQty	int	-
_MD	timestamp	-
GJobID	bigint	-

↑ 回到目录

CheckStockStatD (仓库盘点统计明细表)

字段名	数据类型	字段说明
StatID	ctInt	统计ID
PRec	ctID	商品
JobNumber	ctShortStr	批号
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
Unit	varchar	单位
Qty	ctQty	原始数量
CheckQty	ctQty	盘点数量
ProfitQty	numeric	盘亏数量
ord	smallint	行号
CostPrice	ctPrice	成本单价
TinyFlag	tinyint	拆零标志
comment	ctComment	备注
StopUse	tinyint	停售标志
Rate	int	比率
UQty	ctQty	-
U1Qty	ctQty	-
U2Qty	ctQty	-
PosRetailPrice	ctPrice	-
ProfitPosRetailTotal	ctTotal	-
GJobID	bigint	-

↑ 回到目录

CommissionBill (代销单)

字段名	数据类型	字段说明
BillID	ctID	单据ID
KRec	ctID	仓库Rec
GRec	ctID	货位Rec
PRec	ctID	商品Rec
Qty	ctQty	数量
AssQty	ctQty	单据数量
SalePrice	ctPrice	单价
AssSalePrice	ctPrice	单据单价
discount	ctDiscount	折扣
DiscountPrice	ctPrice	折后单价
AssDiscountPrice	ctPrice	单据折后单价
Total	ctTotal	金额
tax	ctTax	税率
TaxPrice	ctPrice	含税单价
AssTaxPrice	ctPrice	单据含税单价
TaxTotal	ctTotal	含税金额
Jobnumber	ctShortStr	批号
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
ProviderId	ctID	生产厂商
PtypeSource	tinyint	商品来源
StockUniqueid	ctUID	入库唯一编号
Comment	ctShortStr	备注
CostPrice	ctPrice	成本单价
unit	tinyint	单位
UnitRate	smallmoney	单位比率
Eligible	ctShortStr	是否合格
ord	int	顺序号
RetailPrice	ctPrice	零售价
PriceType	tinyint	价格类型
BackQty	ctQty	-
Commissionid	int	-
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
SNTEXT	text	-
_MD	timestamp	-
GJobID	bigint	-

↑ 回到目录

CommissionBill_His

字段名	数据类型	字段说明
BillID	ctID	-
KRec	ctID	-
GRec	ctID	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
SalePrice	ctPrice	-
AssSalePrice	ctPrice	-
discount	ctDiscount	-
DiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
Total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
Jobnumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
ProviderId	ctID	-
PtypeSource	tinyint	-
StockUniqueid	ctUID	-
Comment	ctShortStr	-
CostPrice	ctPrice	-
unit	tinyint	-
UnitRate	smallmoney	-
Eligible	ctShortStr	-
ord	int	-
RetailPrice	ctPrice	-
PriceType	tinyint	-
BackQty	ctQty	-
Commissionid	int	-
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
SNTEXT	text	-
_MD	timestamp	-
GJobID	bigint	-

↑ 回到目录

Crm_ClientManager (客户表)

字段名	数据类型	字段说明
ClientID	int	客户ID
Usercode	varchar	客户编号
Fullname	varchar	客户名称
Namepy	varchar	拼音码
areaID	varchar	片区
ClientTypeID	int	客户类型
TradeType	varchar	单位类型
Address	varchar	地址
TelPhone	varchar	联系电话
Fax	varchar	传真
BakPhone	varchar	备用电话
createID	varchar	创建人
createdate	varchar	创建日期
post	varchar	邮编
LegalPerson	varchar	法人代表
HomePage	varchar	主页
Email	varchar	邮件
qyxz	varchar	企业性质
BankAccounts	varchar	银行账户
TaxAccounts	varchar	税号
Comment	varchar	备注
deleted	int	删除
Bank	varchar	开户银行
Accounts	varchar	账户

↑ 回到目录

DisassembleBill (拆装单)

字段名	数据类型	字段说明
BillID	ctID	单据ID
ord	ctInt	行号
KRec	ctID	仓库编号
GRec	ctID	货位编号
PRec	ctID	商品编号
Qty	ctQty	数量
AssQty	ctQty	单据数量
Price	ctPrice	单价
AssPrice	ctPrice	单据单价
Total	ctTotal	金额
CostPrice	ctPrice	成本金额
Unit	ctbit	单位
UnitRate	smallmoney	单位比率
inorout	char	出入库标志
jobnumber	ctShortStr	批次号
outfactorydate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
ProviderID	ctID	供应商
PtypeSource	tinyint	商品来源
StockUniqueid	uniqueidentifier	入库唯一标志
JobCode	ctShortStr	药品监管码
StopUse	tinyint	停售标志
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
comment	ctComment	备注
SNTEXT	text	-
_MD	timestamp	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
GJobID	bigint	-

↑ 回到目录

DisassembleBill_His

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
KRec	ctID	-
GRec	ctID	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
Price	ctPrice	-
AssPrice	ctPrice	-
Total	ctTotal	-
CostPrice	ctPrice	-
Unit	ctbit	-
UnitRate	smallmoney	-
inorout	char	-
jobnumber	ctShortStr	-
outfactorydate	ctDate	-
ValidityPeriod	ctDate	-
ProviderID	ctID	-
PtypeSource	tinyint	-
StockUniqueid	uniqueidentifier	-
JobCode	ctShortStr	-
StopUse	tinyint	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
comment	ctComment	-
SNTEXT	text	-
_MD	timestamp	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
GJobID	bigint	-

↑ 回到目录

EmployeeTEMP

字段名	数据类型	字段说明
Rec	int	-
typeId	ctTypeID	-
Parid	ctTypeID	-
leveal	tinyint	-
soncount	int	-
sonnum	int	-
FullName	ctName	-
Name	ctName	-
UserCode	ctShortStr	-
Department	ctID	-
Tel	ctShortStr	-
Address	ctShortStr	-
Comment	ctComment	-
deleted	ctbit	-
PYZJM	ctShortStr	-
WBZJM	ctShortStr	-
Credit	ctTotal	-
Aptotal	ctTotal	-
Artotal	ctTotal	-
Posid	ctID	-
Sex	char	-
Birthday	ctDate	-
Edu_Level	ctShortStr	-
Specialty	ctShortStr	-
School	ctMidStr	-
Graduate_Date	ctDate	-
Duty	ctShortStr	-
Technic_Level	ctShortStr	-
Station	ctShortStr	-
WorkTime	ctShortStr	-
WorkCompetency	ctShortStr	-
Certificate	ctShortStr	-
Certificate_Dept	ctShortStr	-
Train_Dept	ctShortStr	-
Work_No	ctShortStr	-
Archives_No	ctShortStr	-
UID	ctUID	-
Counter	ctInt	-
salediscount	ctDiscount	-
LowPriceSetBl	smallmoney	-
BenefitScope	smallmoney	-
ETypeFlags	bigint	-
doctorNo	ctShortStr	-
doctorDate	ctDate	-
UpDateTag	ctInt	-
isStop	ctbit	-
RowIndex	varchar	-
WebUniCode	ctShortStr	-
DoctorCode	ctShortStr	-

↑ 回到目录

GSP_BackBill (GSP退货通知单据)

字段名	数据类型	字段说明
BillID	ctID	BillID
Ord	int	序号
PRec	ctID	商品Rec
jobnumber	ctShortStr	批号
ValidityPeriod	ctDate	有效期至
OutFactoryDate	ctDate	生产日期
qty	ctQty	数量
price	ctPrice	单价
Total	ctTotal	金额
unitIndex	tinyint	单位Index
UnitRate	smallmoney	小单位换算率
memo	ctShortStr	注释
Costprice	ctPrice	成本价
ProviderId	ctID	供应商ID
PtypeSource	tinyint	商品来源
StockUniqueid	ctUID	入库唯一号
JobCode	ctShortStr	批次条码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
PriceType	tinyint	-
BackReason	varchar	-
ChangeID	ctInt	-
Sourcesaleid	ctInt	-
Tax	numeric	-
TaxPrice	numeric	-
TaxTotal	numeric	-
GJobID	bigint	-

↑ 回到目录

GSP_CheckOutP

字段名	数据类型	字段说明
BillNumberID	int	-
btypeid	varchar	-
bfullname	varchar	-
dtdate	datetime	-
BillCode	varchar	-
ptypeid	varchar	-
pfullname	varchar	-
standard	varchar	-
unit	varchar	-
qty	numeric	-
Area	varchar	-
jobnumber	varchar	-
EName	varchar	-
memo	varchar	-
pName	varchar	-
ValidDate	datetime	-
source	varchar	-
Reason	varchar	-
DealIdea	varchar	-
DealInstance	varchar	-
Bill_Type	int	-
Bill_ID	int	-
Status	int	-
Lose_Id	int	-
GoodsID	int	-
BillDate	datetime	-
KTypeID	varchar	-
CostPrice	numeric	-
CostTotal	numeric	-
GermJobNumber	varchar	-
CheckReportNo	varchar	-
CheckRec	ctID	-
OutFactoryDate	datetime	-
Prec	ctInt	-
posid	int	-
GJobID	bigint	-
ZgrDate	datetime	-
ZgrName	varchar	-
FzrDate	datetime	-
FzrName	varchar	-
DealAdvice	varchar	-
CgrDate	datetime	-
CgrName	varchar	-

↑ 回到目录

GSP_G_BadFeedbackReportNdx

字段名	数据类型	字段说明
no	int	-
EnterpriseName	varchar	-
Tel	varchar	-
dtDate	varchar	-
Sufferer_Name	varchar	-
Sufferer_Sex	varchar	-
Sufferer_Birthday	varchar	-
Sufferer_Nation	varchar	-
Sufferer_Weight	numeric	-
GY_BadFeedback	int	-
MedicalNo	varchar	-
Sufferer_Addr	varchar	-
Sufferer_Tel	varchar	-
JY_BadFeedback	int	-
OldIllness	varchar	-
BadFeedback_Name	varchar	-
BadFeedback_Date	varchar	-
BadFeedback_Status	varchar	-
BadFeedback_Deal	varchar	-
BadFeedback_Result	int	-
BadFeedback_Death	bit	-
BadFeedback_DeathReason	varchar	-
BadFeedback_DeathDate	varchar	-
IllnessInfection	int	-
InfectionDeath	bit	-
Province_ADR	int	-
Province_Sign	varchar	-
Nation_ADR	int	-
Nation_Sign	varchar	-
Inside_Feedback	varchar	-
Outer_Feedback	varchar	-
Other_Feedback	varchar	-
Reporter	varchar	-
Duty	varchar	-
BillDate	datetime	-
PosID	ctInt	-

↑ 回到目录

GSP_G_EnterpriseCheckup

字段名	数据类型	字段说明
no	int	-
dtDate	datetime	-
CodeNo	varchar	-
dept	varchar	-
BtypeId	varchar	-
BFullName	varchar	-
Addr	varchar	-
Tel	varchar	-
Type	varchar	-
Edelegate	varchar	-
Bdelegate	varchar	-
RegisterMoney	varchar	-
EnterpriseKind	varchar	-
Licence	varchar	-
LicenceValidDate	datetime	-
PermitNo	varchar	-
PermitValidDate	datetime	-
Tend	varchar	-
QualityAgreement	varchar	-
AfterSellService	varchar	-
ApplyReason	varchar	-
ApplyDeptMind	varchar	-
ManagerMind	varchar	-
GeneralMind	varchar	-
Memo	varchar	-
EName	varchar	-
Signor	varchar	-
BdelegateId	varchar	-
CorporationAccredit	varchar	-
PeriodOfValidity	varchar	-
IsCheck	char	-
BillDate	datetime	-
ProvideGoods	varchar	-
Postcode	varchar	-
Faxes	varchar	-
Principal	varchar	-
PermitName	varchar	-
ProduceBound	varchar	-
LicenceImage	image	-
TrafficImage	image	-
OperationUnit	varchar	-
MassCredit	varchar	-
EmailNo	varchar	-
PermitTitle	varchar	-
PermitUnit	varchar	-
PermitAdd	varchar	-
LicenceTitle	varchar	-
LicenceUnit	varchar	-
LicenceAdd	varchar	-
WorkMode	varchar	-
CheckMind	int	-
OperateName	varchar	-
OperateDate	datetime	-
CreditName	varchar	-
CreditDate	datetime	-
MassName	varchar	-
MassDate	datetime	-
MgrName	varchar	-
MgrDate	datetime	-
taxdjh	varchar	-
tmh	varchar	-
BUserCode	varchar	-
BPartID	varchar	-
Quality	varchar	-
QualityName	varchar	-
QualityDate	ctDate	-
TendID	varchar	-
AImage	varchar	-
BImage	varchar	-
AImageName	varchar	-
BImageName	varchar	-
TaxValidity	ctDate	-
BankNO	ctShortStr	-
BankName	ctShortStr	-
posid	int	-

↑ 回到目录

GSP_G_PMoveRec

字段名	数据类型	字段说明
no	int	-
pTypeid	varchar	-
BatchNo	varchar	-
ValidDate	varchar	-
OutFactoryCheckBill	varchar	-
QlyChecker	varchar	-
OutBFullName	varchar	-
OutDate	varchar	-
OutQty	numeric	-
InBFullName	varchar	-
Principal	varchar	-
ysAdd	varchar	-
zlzk	varchar	-
ysresult	varchar	-
bz	varchar	-
OutFactoryDate	datetime	-
InBtypeid	varchar	-
OutBtypeid	varchar	-
Price	numeric	-
Total	numeric	-
OutPrice	numeric	-
OutTotal	numeric	-
GermJobNumber	varchar	-
QlyChecker2	varchar	-
ERec	ctInt	-
JobCode	ctShortStr	-
CheckReportNo	ctShortStr	-
PFullName	ctName	-
SourceBillID	int	-
SourceOrd	int	-
SampleQty	ctQty	-
Prec	ctInt	-
GJobID	bigint	-

↑ 回到目录

GSP_InBill (GSP入库记录表)

字段名	数据类型	字段说明
BillID	ctID	BillID
Billtype	smallint	单据类型
BillDate	ctDate	单据日期
PRec	ctID	商品Rec
Jobnumber	ctShortStr	批号
Jobnumber1	ctShortStr	批号1
OutFactoryDate	ctDate	生产日期
ValidityPeriod	ctDate	有效期至
BeforeCheckQty	ctQty	数量
EligibleQty	ctQty	合格数量
UnqualifiedQty	ctQty	拒收数量
Price	ctPrice	单价
TotalMoney	ctTotal	金额
BRec	ctID	单位Rec
ArriveDate	ctDate	到货日期
InDate	ctDate	入库日期
QualityStatus	ctComment	质量情况
CheckResult	ctComment	处理结果
BackReason	ctComment	退货原因
ImportReg	ctShortStr	注册证号
ImportTestAdvice	ctShortStr	检验报告书
ChineseExplain	ctShortStr	中文说明书
Ename	ctName	请验人
Operator	ctName	业务员
Warehouseman	ctName	保管员
Checker	ctName	质检员
Checker1	ctName	质检员1
CheckDate	datetime	质检员日期
GspId	int	GspId
KRec	ctID	仓库Rec
PosId	ctID	门店ID
I_sign	ctInt	I_sign
ifCheck	ctbit	ifCheck
Memo	ctComment	注释
IsCreateBill	ctbit	IsCreateBill
CheckTotalQty	ctQty	验收数量
billcode	ctShortStr	单据编号
unitIndex	tinyint	单位类型
UnitRate	smallmoney	单位换算率
audited	ctbit	过账标志
plan_id	ctID	计划id
SourceOrd	ctInt	源Ord
SampleQty	ctQty	抽样数量
OldOrd	ctInt	OldOrd
Costprice	ctPrice	成本价
GRec	ctID	货位Rec
ProviderId	ctID	供应商ID
PtypeSource	tinyint	商品来源
StockUniqueid	ctUID	入库唯一编号
Informer	ctName	通知人
Accepter	ctName	签收人
piece	ctShortStr	件数
AcceptDate	ctDate	签收日期
InformDate	ctDate	通知日期
JobCode	ctShortStr	批次条码
invoice	ctShortStr	进项发票号
CheckDate1	datetime	CheckDate1
CheckReportNo	ctShortStr	药监报告号
sourcetype	smallint	sourcetype
GJJLBY1	varchar	购进记录备用字段1
GJJLBY2	varchar	购进记录备用字段2
GJJLBY3	varchar	购进记录备用字段3
GJJLBY4	varchar	购进记录备用字段4
GJJLBY5	varchar	购进记录备用字段5
Ysjl1	varchar	验收记录备用字段1
Ysjl2	varchar	验收记录备用字段2
Ysjl3	varchar	验收记录备用字段3
Ysjl4	varchar	验收记录备用字段4
Ysjl5	varchar	验收记录备用字段5
rktz1	varchar	入库通知备用字段1
rktz2	varchar	入库通知备用字段2
rktz3	varchar	入库通知备用字段3
rktz4	varchar	入库通知备用字段4
rktz5	varchar	入库通知备用字段5
dhqy1	varchar	到货请验备用字段1
dhqy2	varchar	到货请验备用字段2
dhqy3	varchar	到货请验备用字段3
dhqy4	varchar	到货请验备用字段4
dhqy5	varchar	到货请验备用字段5
PriceType	tinyint	-
YS_Weway	varchar	-
YS_DW	varchar	-
YS_Date	datetime	-
YS_WKFS	varchar	-
YS_DHWD	varchar	-
YS_BackQty	numeric	-
YS_SHName	varchar	-
YS_ADDR	varchar	-
bhgcomment	ctShortStr	-
YS_WKZT	varchar	-
YS_Qty	numeric	-
YS_JSReason	varchar	-
SH_YSName	varchar	-
SH_YSDate	datetime	-
SplitFlags	int	-
OrderReachDate	datetime	-
SHJLBY1	varchar	-
SHJLBY2	varchar	-
SHJLBY3	varchar	-
SHJLBY4	varchar	-
SHJLBY5	varchar	-
JHQty	numeric	-
JS_Reason	varchar	-
PChangeID	ctInt	-
BChangeID	ctInt	-
SNTEXT	text	-
Tax	numeric	-
TaxPrice	numeric	-
TaxTotal	numeric	-
WareHouseman2	ctName	-
GJobID	bigint	-
OtherFlags	int	-

↑ 回到目录

GSP_L_ChinaDrkPartRecord

字段名	数据类型	字段说明
ID	numeric	-
ManageCode	varchar	-
FillDate	datetime	-
FillMan	varchar	-
FullName	varchar	-
PartDate	datetime	-
PartTime	varchar	-
PartStandard	varchar	-
PartJobNumber	varchar	-
CastWeight	numeric	-
InFnWeight	numeric	-
InFnQty	numeric	-
InFnPercent	numeric	-
MtPtypeid	varchar	-
BuyDate	datetime	-
MtmManufacture	varchar	-
MtJobNumber	varchar	-
MtArea	varchar	-
BuyWeight	numeric	-
QualityStatus	varchar	-
PartCircs	varchar	-
PartHandler	varchar	-
PartPrincipal	varchar	-
PartSignDate	datetime	-
QualityCircs	varchar	-
QualityPrincipal	varchar	-
QualitySignDate	datetime	-
Prec	ctInt	-
GJobID	bigint	-

↑ 回到目录

GSP_L_InnerMeasure (库房温湿度记录表明细)

字段名	数据类型	字段说明
BillNumberID	numeric	单据ID
BillDate	datetime	单据日期
DateSerial	int	日期
AMTemperature	varchar	上午温度
AMHumid	varchar	上午相对湿度
AMMaintainU	varchar	上午超标养护措施
AMMaintainL	varchar	AMMaintainL
AMResultTem	varchar	上午养护温度
AMResultHumid	varchar	上午养护湿度
PMTemperature	varchar	下午温度
PMHumid	varchar	下午相对湿度
PMMaintainU	varchar	下午超标养护措施
PMMaintainL	varchar	PMMaintainL
PMResultTem	varchar	下午养护温度
PMResultHumid	varchar	下午养护湿度
AMTime	varchar	上午时间
PMTime	varchar	下午时间

↑ 回到目录

GSP_Lcb_RejectReport (药品拒收报告单)

字段名	数据类型	字段说明
VchCode	varchar	-
UserCode	varchar	-
PTypeID	varchar	-
FullName	ctName	-
Qty	ctQty	-
Total	ctTotal	-
Vender	varchar	-
BatchCode	varchar	-
Price	ctPrice	-
StockCredence	varchar	-
CheckQty	ctQty	-
CheckDate	varchar	-
CheckStandard	varchar	-
CheckResult	varchar	-
CheckerIdea	varchar	-
CheckGroupIdea	varchar	-
MgrDepartmentIdea	varchar	-
Checker	varchar	-
VchDate	varchar	-
AuditDate	varchar	-
TypeID	varchar	-
OrderID	int	-
BillDate	datetime	-
ifcheck	bit	-
GermJobNumber	varchar	-
OperateName	varchar	-
OperateDate	varchar	-
QualityName	varchar	-
QualityDate	varchar	-
CheckReportNo	ctShortStr	-
JobCode	ctShortStr	-
BTypeID	ctShortStr	-
Prec	ctInt	-
posid	int	-
GJobID	bigint	-

↑ 回到目录

GSP_LoseApprove (报损审批表)

字段名	数据类型	字段说明
BillNumberId	int	单据ID
BillCode	varchar	单据编号
dtDate	datetime	单据日期
LoseQty	numeric	报损数量
LoseMoney	numeric	报损金额
Ename	varchar	制单人
memo	varchar	备注
LoseReason	varchar	报损原因
Stock_director	varchar	仓库主任签字
Stock_Admi	varchar	仓库管理员签字
parlor_Idea	varchar	业务部门意见
parlor_Date	datetime	业务部门签字日期
Quality_Idea	varchar	质管部门意见
Quality_Date	datetime	质管签字日期
finance_Idea	varchar	财会意见
finance_Date	datetime	财会签字日期
Mgr_Idea	varchar	经理意见
Mgr_Date	datetime	经理签字日期
Destroy_Id	int	销毁ID
Lose_Id	int	报损清单ID
Status	int	状态
parlorName	varchar	业务员
QualityName	varchar	质管员
FinanceName	varchar	财会部人员
ManagerName	varchar	经理名称
posid	int	-
ZL_Idea	varchar	-
ZL_Date	datetime	-
ZLName	varchar	-

↑ 回到目录

GSP_LoseDetail (报损清单明细)

字段名	数据类型	字段说明
BillNumberId	int	单据ID
btypeid	varchar	单位ID
bfullname	varchar	单位名称
pfullname	varchar	商品名称
pName	varchar	商品全名
type	varchar	剂型
standard	varchar	规格
unit	varchar	单位
qty	numeric	数量
area	varchar	生产厂家
jobnumber	varchar	批号
ValidDate	datetime	效期
Reason	varchar	不合格原因
LoseMoney	numeric	报损金额
memo	varchar	备注
CheckOutPID	int	台帐ID
KTypeID	varchar	仓库ID
ORd	smallint	行号码
GoodsID	int	GoodsID
GermJobNumber	varchar	灭菌批号
CheckReportNo	varchar	药监报告号
OutFactoryDate	datetime	-
CostPrice	ctPrice	-
Prec	ctInt	-
GJobID	bigint	-

↑ 回到目录

GSP_N_AdmitLicence (许可证)

字段名	数据类型	字段说明
ID	ctID	ID
brec	ctID	单位数字ID
AdmitLicenceName	ctName	许可证名称
AdmitLicenceNO	ctShortStr	许可证编号
UnitName	ctMidStr	单位名称
Principal	ctName	负责人
AdmissionRange	varchar	-
ValidityPeriod	ctDate	有效期
UnitAddress	ctComment	单位地址
Provider	ctComment	发证机关
ProvideDate	ctDate	发证日期
BillDate	ctDate	录单日期
FacArea	varchar	区域
ImageID	ctID	照片编号
StockAdress	ctComment	-
FacAdress	ctComment	-
FRDB	ctName	-
JYFS	ctComment	-
comment01	varchar	-
comment02	varchar	-
comment03	varchar	-
comment04	varchar	-
comment05	varchar	-
comment06	varchar	-
comment07	varchar	-
comment08	varchar	-
comment09	varchar	-
comment10	varchar	-
isStop	bit	-

↑ 回到目录

GSP_N_BusinessLicence (营业执照)

字段名	数据类型	字段说明
ID	ctID	ID
brec	ctID	单位数字编号
UnitName	ctName	单位名称
BusinessLicenceNO	ctMidStr	营业证编号
RegisterFund	varchar	注册资金
Artificial	ctComment	-
Character	ctComment	经济性质
DealMode	ctComment	经营方式
UnitAddress	ctComment	单位地址
Provider	ctComment	发照机关
ProvideDate	ctDate	发照时间
BillDate	ctDate	录单日期
FacArea	ctComment	没用
ImageID	ctID	-
DealRange	ctDate	到效时间
comment01	varchar	-
comment02	varchar	-
comment03	varchar	-
comment04	varchar	-
comment05	varchar	-
comment06	varchar	-
comment07	varchar	-
comment08	varchar	-
comment09	varchar	-
comment10	varchar	-

↑ 回到目录

GSP_N_CustomerCheckup

字段名	数据类型	字段说明
ID	numeric	-
SerialNumber	varchar	-
MarkYear	int	-
MarkNumber	varchar	-
btypeid	varchar	-
CustomerFullName	varchar	-
CustomerArchNO	varchar	-
Type	varchar	-
Address	varchar	-
ZipCode	varchar	-
EMail	varchar	-
Fax	varchar	-
ContactPerson	varchar	-
ContactTel	varchar	-
LicenceNO	varchar	-
BusinessLicenceNO	varchar	-
MarketAudit	varchar	-
MarketSign	varchar	-
MarketSignDate	datetime	-
QualityManageAudit	varchar	-
QualityManageSign	varchar	-
QualityManageDate	datetime	-
FinanceAudit	varchar	-
FinanceSign	varchar	-
FinanceDate	datetime	-
ManagerAudit	varchar	-
ManagerSign	varchar	-
ManagerDate	datetime	-
BillDate	datetime	-
ifcheck	ctInt	-
QualityName	varchar	-
QualityDate	ctDate	-
Quality	varchar	-
Tend	varchar	-
TendID	varchar	-
AImage	varchar	-
BImage	varchar	-
AImageName	varchar	-
BImageName	varchar	-
BPartID	varchar	-
Buyer	ctName	-
BankNO	ctName	-
BankName	ctName	-
TaxNO	ctName	-
TaxValidity	ctDate	-

↑ 回到目录

GSP_OutBill (GSP出库记录表)

字段名	数据类型	字段说明
BillID	ctInt	BillID
Billtype	smallint	单据类型
BillCode	ctShortStr	单据编号
BillDate	ctDate	单据日期
PRec	ctID	商品Rec
Jobnumber	ctShortStr	批号
Jobnumber1	ctShortStr	灭菌批号
OutFactoryDate	ctDate	生产日期
Qty	ctQty	数量
OutQty	ctQty	出库数量
Price	ctPrice	单价
TotalMoney	ctTotal	合计金额
BRec	ctID	往来单位Rec
OutDate	datetime	仓库日期
QualityStatus	ctShortStr	质量状态
BackReason	ctComment	退回原因
Ename	ctName	业务员
Operator	ctName	操作员
Warehouseman	ctName	发货人
Checker	ctName	复核人
Checker1	ctName	复核人2
CheckDate	ctDate	复核日期
GspId	ctInt	GspId
KRec	ctID	仓库Rec
GRec	ctID	货位Rec
PosId	ctID	门店Id
O_sign	ctInt	审核标记
ifCheck	tinyint	审核标志
Memo	ctComment	备注
unitIndex	tinyint	单位ID
UnitRate	smallmoney	跟基本单位换算率
JobCode	ctShortStr	批次条码
CheckReportNo	ctShortStr	药监报告号
ValidityPeriod	ctDate	有效期至
xsjl1	varchar	销售记录1
xsjl2	varchar	销售记录2
xsjl3	varchar	销售记录3
xsjl4	varchar	销售记录4
xsjl5	varchar	销售记录5
ckfh1	varchar	出库复核1
ckfh2	varchar	出库复核2
ckfh3	varchar	出库复核3
ckfh4	varchar	出库复核4
ckfh5	varchar	出库复核5
UnqualifiedQty	numeric	-
bhgDoWith	varchar	-
bhg_Reason	varchar	-
PChangeID	ctInt	-
BChangeID	ctInt	-
SNTEXT	text	-
Ord	ctInt	-
GJobID	bigint	-
Warehouseman2	ctName	-

↑ 回到目录

GSP_Y_Acuuse (药品质量投诉记录表)

字段名	数据类型	字段说明
id	numeric	id
ComeDate	datetime	投诉日期
RecNo	varchar	编号
ComName	varchar	商品名称
CommonName	varchar	通用名
Type	varchar	剂型
Spec	varchar	规格
BatchCode	varchar	批号
PeriodOfVali	datetime	有效期至
Number	float	数量
MadeFactory	varchar	生产厂家
AName	varchar	投诉方姓名
Aunit	varchar	投诉方单位
AAdreess	varchar	投诉方地址
PostalCode	varchar	邮政编码
Phone	varchar	电话
ASay	varchar	投诉方意见或建议
Qsay	varchar	质量管理部门审核意见
Qwho	varchar	质量管理部门负责人
Qdate	datetime	质量管理部门负责人签字日期
Result	varchar	问题处理或反馈结果
RWho	varchar	问题处理或反馈处理人
RDate	datetime	问题处理或反馈处理日期
Who	varchar	填表人
dw	varchar	数量单位

↑ 回到目录

GSP_Y_Qualitydowith (药品质量处理通知单)

字段名	数据类型	字段说明
id	numeric	id
RecNo	varchar	编号
WhoBuy	varchar	购货单位
DateAndNo	varchar	购货日期
CommonName	varchar	通用名称
ComName	varchar	商品名称
Spec	varchar	规格
Number	float	数量
Unit	varchar	单位
BatchCode	varchar	批号
MadeFactory	varchar	生产厂家
QualityStatus	varchar	质量情况
QWho	varchar	质量经办人
Qdate	datetime	质量经办人签字日期
dowith	varchar	质管部门鉴定处理意见
dWho	varchar	质管签字
dDate	datetime	质管签字日期
Libstatus	varchar	仓库处理情况
lwho	varchar	仓库执行人
ldate	datetime	仓库执行人日期

↑ 回到目录

GSP_Z_QualityCheckNotice

字段名	数据类型	字段说明
BillID	ctInt	-
BillCode	ctShortStr	-
BillDate	ctBillDate	-
PRec	ctInt	-
JobNumber	ctShortStr	-
Qty	ctQty	-
CheckQty	ctQty	-
NormalQty	ctQty	-
ADDRESS	ctComment	-
Factorydate	ctShortStr	-
Quality	ctComment	-
QualityChecker	ctName	-
QualityDate	ctDate	-
Checkresult	ctComment	-
Checker	ctName	-
CheckDate	ctDate	-
ReConclusion	ctComment	-
ReName	ctName	-
ReDate	ctDate	-
IFCheck	ctInt	-
KRec	ctInt	-
Price	ctPrice	-
ProviderID	ctInt	-
GRec	ctInt	-
StockUniqueid	uniqueidentifier	-
GermJobNumber	ctShortStr	-
jobcode	ctShortStr	-
CheckReportNo	ctShortStr	-
validDate	ctShortStr	-
CSFullName	ctName	-
GSPID	ctInt	-
GJobID	bigint	-

↑ 回到目录

GoodsStocks (库存信息表)

字段名	数据类型	字段说明
KRec	ctID	仓库数字ID
GRec	ctID	货位数字ID
PRec	ctID	商品数字ID
JobNumber	ctShortStr	商品批次号
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
ProviderId	ctID	供应商
PtypeSource	tinyint	商品来源
StockUniqueid	ctUID	入库唯一标志
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告码
StopUse	tinyint	停售标志
Qty	ctQty	库存数量
TinyQty	ctQty	拆零数量
Price	ctPrice	成本单价
Total	ctTotal	库存总金额
GoodsOrder	ctInt	商品入库序号
intime	ctDate	入库时间
GoodsId	ctID	仓库标志
lastmaintainTime	ctDate	最后养护手机那
Type	char	Type
GJobid	bigint	-

↑ 回到目录

Gsp_F_Infomove

字段名	数据类型	字段说明
ORDERID	int	-
NUMBER	varchar	-
LEVEAL	int	-
SENDDATE	varchar	-
SENDDARPARTMENTID	varchar	-
SENDDARPARTMENTNAME	varchar	-
SENDETYPEID	varchar	-
SENDEFULLNAME	varchar	-
SENDINFO	varchar	-
MOVEINDATE	varchar	-
MOVEOUTDATE	varchar	-
MOVEDARPARTMENTID	varchar	-
MOVEDARPARTMENTNAME	varchar	-
MOVEETYPEID	varchar	-
MOVEEFULLNAME	varchar	-
MOVEINFO	varchar	-
RECEIVEDATE	varchar	-
RECEIVEETYPEID	varchar	-
RECEIVEFULLNAME	varchar	-
RECEIVEINFO	varchar	-
RECEIVEDARPARTMENTID	varchar	-
RECEIVEDARPARTMENTNAME	varchar	-
DOWITHDATE	varchar	-
DOWITHWAY	varchar	-
BillDate	datetime	-

↑ 回到目录

Gsp_L_MaintainRecord

字段名	数据类型	字段说明
billnumberid	numeric	-
recordDate	datetime	-
number	varchar	-
ptypeid	varchar	-
pname	varchar	-
pstandard	varchar	-
palias	varchar	-
authorize	varchar	-
foreignname	varchar	-
userful	varchar	-
quality	varchar	-
state	varchar	-
store	varchar	-
factoryname	varchar	-
factoryadd	varchar	-
trademark	varchar	-
validitydate	datetime	-
chargedate	datetime	-
userfuldate	datetime	-
admission	varchar	-
checkitem	varchar	-
packinfo	varchar	-
cubage	varchar	-
CommerceNo	varchar	-
BillDate	datetime	-
Gmp	varchar	-
Tel	varchar	-
jdmd	varchar	-
mailadd	varchar	-
PermitNoValidDate	datetime	-
GMPValidDate	datetime	-
Prec	ctInt	-

↑ 回到目录

ImportBill

字段名	数据类型	字段说明
BillID	int	-
ord	int	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
costprice	ctPrice	-
Price	ctPrice	-
AssPrice	ctPrice	-
discount	ctDiscount	-
DiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
jobnumber	ctShortStr	-
OutFactoryDate	datetime	-
ValidityPeriod	datetime	-
JobCode	ctMidStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
comment	ctComment	-
ProviderId	ctID	-
PtypeSource	tinyint	-
StockUniqueid	ctUID	-
Eligible	ctShortStr	-
unit	tinyint	-
UnitRate	smallmoney	-
RetailPrice	ctPrice	-
SourceBillID	ctID	-
SourceOrd	ctID	-
PriceType	tinyint	-
InorOut	char	-
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
ViceQty	ctQty	-
Registration	ctShortStr	-
LotCustom1	ctShortStr	-
LotCustom2	ctShortStr	-
LotCustom3	ctQty	-
LotCustom4	ctQty	-
LotCustom5	ctDate	-
SourceUID	ctUID	-
SNTEXTIM	varchar	-
aid	int	-
SNTEXT	text	-

↑ 回到目录

InOutStockTableTemp

字段名	数据类型	字段说明
BillID	ctID	-
ord	int	-
BillDate	ctBillDate	-
BillType	smallint	-
PRec	ctID	-
BRec	ctID	-
ERec	ctID	-
KRec	ctID	-
GRec	ctID	-
Qty	ctQty	-
Price	ctPrice	-
Total	ctTotal	-
CostPrice	ctPrice	-
CostTotal	ctTotal	-
TaxPrice	ctPrice	-
TaxTotal	ctTotal	-
GoodsNo	ctID	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
ProviderId	ctID	-
PtypeSource	tinyint	-
Audited	ctbit	-
Status	tinyint	-
StockUniqueid	ctUID	-
StopUse	tinyint	-
JobCode	ctShortStr	-
discount	ctPrice	-
BeforeDiscountPrice	ctPrice	-
Tax	ctTax	-
RetailPrice	ctPrice	-
BillE	ctID	-
OfficeID	ctID	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
PriceType	tinyint	-
_MD	timestamp	-
GJobid	bigint	-
afterqty	ctQty	-
RealPrice	ctPrice	-
RealTotal	ctTotal	-
RealtaxPrice	ctPrice	-
RealtaxTotal	ctTotal	-
InTime	datetime	-

↑ 回到目录

InOutstocktable (商品出入库明细表)

字段名	数据类型	字段说明
BillID	ctID	单据ID
ord	int	单据行编号
BillDate	ctBillDate	单据日期
BillType	smallint	单据类型
PRec	ctID	商品Rec
BRec	ctID	往来单位Rec
ERec	ctID	经手人Rec
KRec	ctID	仓库Rec
GRec	ctID	货位Rec
Qty	ctQty	数量
Price	ctPrice	单价
Total	ctTotal	金额
CostPrice	ctPrice	成本单价
CostTotal	ctTotal	成本金额
TaxPrice	ctPrice	含税单价
TaxTotal	ctTotal	含税金额
GoodsNo	ctID	商品序号
JobNumber	ctShortStr	批号
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
ProviderId	ctID	供应商
PtypeSource	tinyint	商品来源
Audited	ctbit	是否红冲单据
Status	tinyint	单据状态（表示从门店上传上来的单据：配送704 706,自营店status=1 加盟店status=0）
StockUniqueid	ctUID	入库唯一标志
StopUse	tinyint	停售标志
JobCode	ctShortStr	药品监管码
discount	ctPrice	折扣
BeforeDiscountPrice	ctPrice	折前单价
Tax	ctTax	税率
RetailPrice	ctPrice	零售价
BillE	ctID	制单人
OfficeID	ctID	门店ID
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
PriceType	tinyint	-
_MD	timestamp	-
GJobid	bigint	-
afterqty	ctQty	-
inoutflags	int	-
RealPrice	ctPrice	-
RealTotal	ctTotal	-
RealtaxPrice	ctPrice	-
RealtaxTotal	ctTotal	-

↑ 回到目录

InOutstocktable_his

字段名	数据类型	字段说明
BillID	ctID	-
ord	int	-
BillDate	ctBillDate	-
BillType	smallint	-
PRec	ctID	-
BRec	ctID	-
ERec	ctID	-
KRec	ctID	-
GRec	ctID	-
Qty	ctQty	-
Price	ctPrice	-
Total	ctTotal	-
CostPrice	ctPrice	-
CostTotal	ctTotal	-
TaxPrice	ctPrice	-
TaxTotal	ctTotal	-
GoodsNo	ctID	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
ProviderId	ctID	-
PtypeSource	tinyint	-
Audited	ctbit	-
Status	tinyint	-
StockUniqueid	ctUID	-
StopUse	tinyint	-
JobCode	ctShortStr	-
discount	ctPrice	-
BeforeDiscountPrice	ctPrice	-
Tax	ctTax	-
RetailPrice	ctPrice	-
BillE	ctID	-
OfficeID	ctID	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
PriceType	tinyint	-
_MD	timestamp	-
GJobID	bigint	-
RealPrice	ctPrice	-
RealTotal	ctTotal	-
RealtaxPrice	ctPrice	-
RealtaxTotal	ctTotal	-
afterqty	ctQty	-
inoutflags	int	-

↑ 回到目录

IniGoodsStocksBak

字段名	数据类型	字段说明
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
JobNumber	varchar	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
StockUniqueId	uniqueidentifier	-
JobCode	varchar	-
GermJobNumber	varchar	-
CheckReportNo	varchar	-
ProviderId	ctID	-
PtypeSource	tinyint	-
Qty	ctQty	-
TinyQty	ctQty	-
Price	ctPrice	-
Total	ctTotal	-
GoodsOrder	ctInt	-
StopUse	tinyint	-
intime	ctDate	-
ifcheck	ctBillDate	-
LastMaintainTime	ctDate	-
settlement	tinyint	-
SourceStockID	ctID	-
Type	char	-
GJobID	bigint	-
JobTax	ctTax	-
JObTaxPrice	numeric	-
ORec	ctID	-
lotcustom1	ctShortStr	-
lotcustom2	ctShortStr	-
lotcustom3	ctShortStr	-
lotcustom4	ctShortStr	-
lotcustom5	ctShortStr	-
lotcustom6	ctShortStr	-
lotcustom7	ctShortStr	-
lotcustom8	ctShortStr	-
lotcustom9	ctShortStr	-
lotcustom10	ctShortStr	-
lotcustom11	ctQty	-
lotcustom12	ctQty	-
lotcustom13	ctQty	-
lotcustom14	ctQty	-
lotcustom15	ctQty	-

↑ 回到目录

InvoiceBill

字段名	数据类型	字段说明
BillID	ctID	-
InvoiceID	uniqueidentifier	-
SourceBillID	ctID	-
SourceBillType	smallint	-
SourceOrd	ctInt	-
PRec	ctID	-
Qty	ctQty	-
Price	ctPrice	-
Total	ctTotal	-
InvoiceQty	ctQty	-
InvoiceTotal	ctTotal	-
AuditedQty	ctQty	-
AuditedTotal	ctTotal	-
ord	ctInt	-
Unit	tinyint	-
SourceTax	ctTax	-
SourceBillDate	ctDate	-
SourceBillCode	ctShortStr	-
JobNumber	ctShortStr	-
GermJobNumber	ctShortStr	-
Comment	ctShortStr	-
DiscountPrice	ctPrice	-
unitrate	smallmoney	-
COSTPRICE	ctPrice	-
COSTTOTAL	ctTotal	-
GJobID	bigint	-
InFBCode	ctShortStr	-
InFBBillid	ctID	-

↑ 回到目录

JiDieInterFace

字段名	数据类型	字段说明
FDate	datetime	-
FPeriod	numeric	-
FGroup	varchar	-
FNum	numeric	-
FEntryID	numeric	-
FExp	varchar	-
FAcctID	varchar	-
FClsName1	varchar	-
FObjID1	varchar	-
FObjName1	varchar	-
FClsName2	varchar	-
FObjID2	varchar	-
FObjName2	varchar	-
FClsName3	varchar	-
FObjID3	varchar	-
FObjName3	varchar	-
FClsName4	varchar	-
FObjID4	varchar	-
FObjName4	varchar	-
FTransID	varchar	-
FCyID	varchar	-
FExchRate	numeric	-
FDC	varchar	-
FFCyAmt	numeric	-
FQty	numeric	-
FPrice	numeric	-
FDebit	numeric	-
FCredit	numeric	-
FSettlCode	varchar	-
FSettleNo	varchar	-
FPreparer	varchar	-
FPay	varchar	-
FCash	varchar	-
FPoster	varchar	-
FChecker	varchar	-
FAttchment	numeric	-
FPosted	bit	-
FModule	varchar	-
FDeleted	bit	-
FSerialNo	numeric	-
FTRANSDATE	datetime	-
FCLSNAME5	varchar	-
FOBJID5	varchar	-
FOBJNAME5	varchar	-
FCLSNAME6	varchar	-
FOBJID6	varchar	-
FOBJNAME6	varchar	-
FCLSNAME7	varchar	-
FOBJID7	varchar	-
FOBJNAME7	varchar	-
FCLSNAME8	varchar	-
FOBJID8	varchar	-
FOBJNAME8	varchar	-

↑ 回到目录

MedicalHistoryD

字段名	数据类型	字段说明
Rec	ctID	-
CFZ	tinyint	-
FBSJ	datetime	-
FBDD	varchar	-
BloodType	ctName	-
ActionInChief	varchar	-
HistoryIllness	varchar	-
HistoryPer	varchar	-
HealthCheckup	varchar	-
Testing	varchar	-
Diagnose	varchar	-
AnimalHeat	ctName	-
HeartRate	ctName	-
Breathe	ctName	-
Blood	ctName	-
IsInfect	tinyint	-
CurativeEffect	tinyint	-
Treatment	varchar	-
Picture1	ctName	-
pName1	ctName	-
pDate1	datetime	-
Picture2	ctName	-
pName2	ctName	-
pDate2	datetime	-
picture3	ctName	-
pName3	ctName	-
pDate3	datetime	-
picture4	ctName	-
pName4	ctName	-
pDate4	datetime	-
Comment	ctComment	-
CHECKE	ctShortStr	-
BloodGl	ctName	-

↑ 回到目录

MoveBack_Employee

字段名	数据类型	字段说明
MoveID	int	-
typeId	ctTypeID	-
Parid	ctTypeID	-
leveal	tinyint	-
soncount	int	-
sonnum	int	-
FullName	ctName	-
Name	ctName	-
UserCode	ctShortStr	-
Department	ctID	-
Tel	ctShortStr	-
Address	ctShortStr	-
Comment	ctComment	-
deleted	ctbit	-
PYZJM	ctShortStr	-
Credit	ctTotal	-
Aptotal	ctTotal	-
Artotal	ctTotal	-
Posid	ctID	-
Sex	char	-
Birthday	ctDate	-
Edu_Level	ctShortStr	-
Specialty	ctShortStr	-
School	ctShortStr	-
Graduate_Date	ctDate	-
Duty	ctShortStr	-
Technic_Level	ctShortStr	-
Station	ctShortStr	-
WorkTime	ctShortStr	-
WorkCompetency	ctShortStr	-
Certificate	ctShortStr	-
Certificate_Dept	ctShortStr	-
Train_Dept	ctShortStr	-
Work_No	ctShortStr	-
Archives_No	ctShortStr	-
ETypeFlags	bigint	-

↑ 回到目录

MoveBack_btype

字段名	数据类型	字段说明
MoveID	int	-
typeId	ctTypeID	-
parid	ctTypeID	-
leveal	tinyint	-
soncount	int	-
sonnum	int	-
UserCode	ctShortStr	-
FullName	ctName	-
Name	ctName	-
Area	int	-
Tel	ctShortStr	-
Address	ctMidStr	-
PostCode	varchar	-
Person	ctShortStr	-
TaxNumber	ctShortStr	-
Bank	ctMidStr	-
Account	ctMidStr	-
Comment	ctComment	-
ARTotal	ctTotal	-
APTotal	ctTotal	-
CreditCount	ctTotal	-
ARTotal00	ctTotal	-
APTotal00	ctTotal	-
deleted	ctbit	-
BTypeFlags	bigint	-
PYZJM	ctShortStr	-
PriceMode	tinyint	-
preArTotal	ctTotal	-
preArTotal00	ctTotal	-
preApTotal	ctTotal	-
preApTotal00	ctTotal	-
FirstCheck	tinyint	-
UFUserCode	varchar	-
CreditDays	int	-
ifUnitType	tinyint	-
Email	ctShortStr	-
Fax	ctShortStr	-
ID_Card	ctMidStr	-
LinkPhone	ctShortStr	-
corporation	ctShortStr	-
ProjectType	ctInt	-
charter	ctShortStr	-
license	ctShortStr	-
scope	ctComment	-

↑ 回到目录

MoveBack_ptype

字段名	数据类型	字段说明
MoveID	int	-
typeId	ctTypeID	-
ParId	ctTypeID	-
leveal	tinyint	-
sonnum	int	-
soncount	int	-
UserCode	ctShortStr	-
FullName	ctName	-
Name	ctName	-
Standard	ctShortStr	-
Type	ctShortStr	-
PermitNo	ctShortStr	-
Unit1	varchar	-
Unit2	varchar	-
UnitRate1	int	-
UsefulLifeMonth	smallint	-
UsefulLifeDay	smallint	-
Comment	ctComment	-
recprice	ctPrice	-
deleted	ctbit	-
TradeMark	ctShortStr	-
BatchStdPrice	ctPrice	-
RetailStdPrice	ctPrice	-
StopSale	ctbit	-
BarCode	ctShortStr	-
PYZJM	ctShortStr	-
Firstcheck	tinyint	-
KindOfQlyCheck	int	-
E_Name	ctMidStr	-
Flags	bigint	-
D_Std	ctMidStr	-
if_tiny	bit	-
TinyUnit	varchar	-
TinyRate	int	-
Tinyprice	ctPrice	-
StorageCondition	ctShortStr	-
ChymistryName	ctName	-
ChymistryPY	ctShortStr	-
NamePY	ctShortStr	-
classify	ctShortStr	-
Conserve	tinyint	-
GMPCode	ctShortStr	-
GMPPeriod	ctDate	-
Area	int	-

↑ 回到目录

MoveBill (同价配送单)

字段名	数据类型	字段说明
BillID	ctID	单据ID
ord	ctInt	单据行顺序
PRec	ctID	商品
KRec	ctID	仓库
GRec	ctID	货位
KRec2	ctID	仓库2
GRec2	ctID	货位2
unit	tinyint	单位
UnitRate	smallmoney	单位比率
Qty	ctQty	数量
AssQty	ctQty	单据数量
Rate	smallmoney	Rate
Price	ctPrice	单价
AssPrice	ctPrice	单据单价
Total	ctTotal	金额
Jobnumber	ctShortStr	批号
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
CostPrice	ctPrice	成本单价
ProviderID	ctID	供应商
PtypeSource	tinyint	药品来源
StockUniqueid	ctUID	入库唯一编号
StockUniqueid2	ctUID	入库唯一编号2
StopUse	tinyint	是否停售
RetailPrice	ctPrice	零售价
Comment	ctComment	备注
ChangeID	ctInt	-
SNTEXT	text	-
_MD	timestamp	-
movetax	smallmoney	-
mtaxPrice	numeric	-
mtaxTotal	money	-
GJobID	bigint	-

↑ 回到目录

MoveBill_His

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
KRec2	ctID	-
GRec2	ctID	-
unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
AssQty	ctQty	-
Rate	smallmoney	-
Price	ctPrice	-
AssPrice	ctPrice	-
Total	ctTotal	-
Jobnumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
CostPrice	ctPrice	-
ProviderID	ctID	-
PtypeSource	tinyint	-
StockUniqueid	ctUID	-
StockUniqueid2	ctUID	-
StopUse	tinyint	-
RetailPrice	ctPrice	-
Comment	ctComment	-
ChangeID	ctInt	-
SNTEXT	text	-
_MD	timestamp	-
movetax	smallmoney	-
mtaxPrice	numeric	-
mtaxTotal	money	-
GJobID	bigint	-

↑ 回到目录

NewPtypeBill (新品需求单)

字段名	数据类型	字段说明
BillID	ctID	单据ID
Ord	int	行号
PtypeName	ctName	商品名称
Type	ctShortStr	剂型
Area	ctMidStr	生产厂商
Standard	ctShortStr	规格
Unit	varchar	基本单位
Qty	ctQty	数量
Comment	ctMidStr	备注
OrdStatus	tinyint	行状态
pBarCode	ctShortStr	-
retailprice	ctPrice	-
buyername	ctName	-
buyertel	ctName	-
Comment1	ctMidStr	-
Comment2	ctMidStr	-
Comment3	ctMidStr	-
Comment4	ctMidStr	-
Comment5	ctMidStr	-
Comment6	ctMidStr	-
Comment7	ctMidStr	-
Comment8	ctMidStr	-
Comment9	ctMidStr	-
Comment10	ctMidStr	-
Comment11	ctMidStr	-
Comment12	ctMidStr	-

↑ 回到目录

OrderCenterD (采购计划)

字段名	数据类型	字段说明
BillID	ctID	单据ID
PRec	ctID	商品
BRec	ctID	往来单位
QtyNeedBuy	ctQty	当自动生成时为计划数量，否则为0
QtyPreBuy	ctQty	计划数量
AssQty	ctQty	单据数量
QtyRealBuy	ctQty	实际数量
BuyFlag	bit	购买标志
price	ctPrice	单价
AssPrice	ctPrice	单据单价
Total	ctTotal	金额
Saletotal	ctTotal	库存数量
unitRate	smallmoney	单位比率
unitIndex	smallint	单位类型
TaxPrice	ctPrice	含税单击
AssTaxPrice	ctPrice	单据含税单价
TaxTotal	ctTotal	含税金额
ord	int	序号
tax	ctTax	税率
mxord	int	明细序号
PChangeID	ctInt	-
BChangeID	ctInt	-

↑ 回到目录

OrderIndex (订单索引表)

字段名	数据类型	字段说明
BillID	ctID	单据ID
BRec	ctID	往来单位Rec
ERec	ctID	经手人Rec
CheckEID	ctID	审核人Rec
BillEID	ctID	制单人Rec
KRec	ctID	仓库Rec
BillDate	ctDate	制单日期
ReachDate	ctDate	到货日期
Billcode	ctShortStr	单据编号
billtype	smallint	单据类型
totalmoney	ctTotal	金额
totalqty	ctQty	数量
period	tinyint	单据期号
checked	ctbit	是否审核
BillOver	ctbit	单据是否完成
comment	ctComment	备注
explain	ctComment	说明
plan_id	ctInt	计划ID
gspid	ctID	gspid
Tax	ctTax	税率
BTYPEAttorneyid	ctInt	-
BeforePayID	ctInt	-
ChangeID	ctInt	-
CGJLSinge	ctName	-
ZGJLSinge	ctName	-
XSJLSinge	ctName	-
CWJLSinge	ctName	-
YS_Weway	varchar	-
YS_ADDR	varchar	-
YS_DW	varchar	-
BillTime	datetime	-
pricetype	ctID	-
costrate	ctDiscount	-
_MD	timestamp	-
OREC	ctID	-

↑ 回到目录

OrderIndex_His

字段名	数据类型	字段说明
BillID	ctID	-
BRec	ctID	-
ERec	ctID	-
CheckEID	ctID	-
BillEID	ctID	-
KRec	ctID	-
BillDate	ctDate	-
ReachDate	ctDate	-
Billcode	ctShortStr	-
billtype	smallint	-
totalmoney	ctTotal	-
totalqty	ctQty	-
period	tinyint	-
checked	ctbit	-
BillOver	ctbit	-
comment	ctComment	-
explain	ctComment	-
plan_id	ctInt	-
gspid	ctID	-
Tax	ctTax	-
BTYPEAttorneyid	ctInt	-
BeforePayID	ctInt	-
ChangeID	ctInt	-
CGJLSinge	ctName	-
ZGJLSinge	ctName	-
XSJLSinge	ctName	-
CWJLSinge	ctName	-
YS_Weway	varchar	-
YS_ADDR	varchar	-
YS_DW	varchar	-
BillTime	datetime	-
_MD	timestamp	-

↑ 回到目录

PosDataMx (门店上传数据明细表)

字段名	数据类型	字段说明
BillID	int	单据索引号
ARec	ctID	科目数字ID
PRec	ctID	商品数字ID
BRec	ctID	往来单位数字ID
ERec	ctID	员工数字ID
KRec	ctID	仓库数字ID
Qty	ctQty	数量
AssQty	ctQty	辅助数量
Price	ctPrice	单价
AssPrice	ctPrice	辅助单价
Total	ctTotal	金额
CostPrice	ctPrice	成本单价
CostTotal	ctTotal	成本金额
TaxPrice	ctPrice	含税单价
AssTaxPrice	ctPrice	辅助含税单价
TaxTotal	ctTotal	含税金额
JobNumber	ctShortStr	批次
JobNumber2	ctShortStr	批次2
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
comment	ctComment	备注
discount	ctDiscount	折扣
DiscountPrice	ctPrice	折扣单价
AssDisCountPrice	ctPrice	辅助折扣单价
unit	int	单位
UnitRate	smallmoney	换算比率
ProviderId	ctID	供应商
PtypeSource	tinyint	商品来源
Ord	int	顺序号
kRec2	ctID	仓库数字ID2
gRec	ctID	货位数字ID
gRec2	ctID	货位数字ID2
StockUniqueID	uniqueidentifier	库存唯一标识
StockUniqueID2	uniqueidentifier	库存唯一标识2
StopUse	tinyint	停售标志
tax	ctTax	税率
JobCode	ctShortStr	批次条码
JobCode2	ctShortStr	批次条码2
SaleERec	ctID	业务员数字ID
RetailPrice	ctPrice	零售价
OutFactoryDate2	datetime	出厂日期2
ValidityPeriod2	datetime	有效期2
GermJobNumber	ctShortStr	灭菌批号
GermJobNumber2	ctShortStr	灭菌批号2
CheckReportNo	ctShortStr	药监报告码
CheckReportNo2	ctShortStr	药监报告码2
PriceType	ctInt	价格类型
ChangeID	ctID	-
BackReason	varchar	-
GJobID	bigint	-

↑ 回到目录

PosInfo (门店信息表)

字段名	数据类型	字段说明
PosId	int	门店ID
KRec	ctID	相应仓库数字ID
BRec	ctID	相应往来单位数字ID
PosCode	ctShortStr	门店用户编号
PosName	ctName	门店名称
Comment	ctComment	说明
path	ctMidStr	本地路径
PosToBTypeRec	ctID	门店转往来ID
RigidBackGoods	ctbit	退货按严格流程执行
PYZJM	ctShortStr	拼音助记码
PosType	ctbit	门店类型
ConnectType	ctbit	连接类型
PriceMode	ctbit	配送价格方式
SendWay	ctComment	送货方式
Updatetag	ctInt	Updatetag
Deleted	tinyint	-
ManageRec	ctInt	-
ARea	ctInt	-
Flags	int	-
CostRate	ctTotal	-
adres	varchar	-
pszq	int	-
PosArea	money	-
IntegralTotal00	ctTotal	-
IntegralTotal	ctTotal	-
posadrtype	int	-
BuildDate	ctDate	-
DZJGMManageIndex	int	-
DZJGMManageControl	int	-

↑ 回到目录

PosMoveBill

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
SourceBillID	uniqueidentifier	-
SourceBillCode	varchar	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
FactQty	ctQty	-
AssQty	ctQty	-
AuditQty	ctQty	-
SourceCostPrice	ctPrice	-
costprice	ctPrice	-
SalePrice	ctPrice	-
AssSalePrice	ctPrice	-
total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
SourceOutFactoryDate	ctDate	-
OutFactoryDate	ctDate	-
SourceValidityPeriod	ctDate	-
ValidityPeriod	ctDate	-
Sourcejobnumber	ctShortStr	-
jobnumber	ctShortStr	-
comment	ctComment	-
Eligible	ctShortStr	-
RetailPrice	ctPrice	-
OrdStatus	tinyint	-
ProviderID	ctInt	-
PtypeSource	tinyint	-
StockUniqueid	uniqueidentifier	-
SourceJobCode	ctShortStr	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
SourceGermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
SourceCheckReportNo	ctShortStr	-
SendDate	ctDate	-
ChangeID	ctInt	-
GJobID	bigint	-

↑ 回到目录

PosMoveBillBak

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
SourceBillID	uniqueidentifier	-
SourceBillCode	varchar	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
FactQty	ctQty	-
AssQty	ctQty	-
AuditQty	ctQty	-
SourceCostPrice	ctPrice	-
costprice	ctPrice	-
SalePrice	ctPrice	-
AssSalePrice	ctPrice	-
total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
SourceOutFactoryDate	ctDate	-
OutFactoryDate	ctDate	-
SourceValidityPeriod	ctDate	-
ValidityPeriod	ctDate	-
Sourcejobnumber	ctShortStr	-
jobnumber	ctShortStr	-
comment	ctComment	-
Eligible	ctShortStr	-
RetailPrice	ctPrice	-
OrdStatus	tinyint	-
ProviderID	ctInt	-
PtypeSource	tinyint	-
StockUniqueid	uniqueidentifier	-
SourceJobCode	ctShortStr	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
SourceGermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
SourceCheckReportNo	ctShortStr	-
SendDate	ctDate	-
ChangeID	ctInt	-
GJobID	bigint	-

↑ 回到目录

PosMoveBillTemp

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
SourceBillID	uniqueidentifier	-
SourceBillCode	varchar	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
FactQty	ctQty	-
AssQty	ctQty	-
AuditQty	ctQty	-
SourceCostPrice	ctPrice	-
costprice	ctPrice	-
SalePrice	ctPrice	-
AssSalePrice	ctPrice	-
total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
SourceOutFactoryDate	ctDate	-
OutFactoryDate	ctDate	-
SourceValidityPeriod	ctDate	-
ValidityPeriod	ctDate	-
Sourcejobnumber	ctShortStr	-
jobnumber	ctShortStr	-
comment	ctComment	-
Eligible	ctShortStr	-
RetailPrice	ctPrice	-
OrdStatus	tinyint	-
ProviderID	ctInt	-
PtypeSource	tinyint	-
StockUniqueid	uniqueidentifier	-
SourceJobCode	ctShortStr	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
SourceGermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
SourceCheckReportNo	ctShortStr	-
SendDate	ctDate	-
ChangeID	ctInt	-

↑ 回到目录

PosPrice (门店价格表)

字段名	数据类型	字段说明
PRec	ctID	商品数字ID
PosId	int	门店ID
Unit	ctbit	单位
RetailPrice	ctPrice	零售价
PrePrice1	ctPrice	预设售价1
PrePrice2	ctPrice	预设售价2
PrePrice3	ctPrice	预设售价3
Preprice4	ctPrice	预设售价4
PrePrice5	ctPrice	预设售价5
PrePrice6	ctPrice	预设售价6
PrePrice7	ctPrice	预设售价7
PrePrice8	ctPrice	预设售价8
PrePrice9	ctPrice	预设售价9
PrePrice10	ctPrice	预设售价10
PrePrice11	ctPrice	预设售价11
PrePrice12	ctPrice	预设售价12
PrePrice13	ctPrice	预设售价13
PrePrice14	ctPrice	预设售价14
PrePrice15	ctPrice	预设售价15
vipprice	ctPrice	会员价
tinyprice	ctPrice	拆零价
MaxPrice	ctPrice	最大售价
MinPrice	ctPrice	最小售价
RecPrice	ctPrice	最近进价
_MD	timestamp	上下传标识
CommRetailPrice	ctPrice	日常零售特价

↑ 回到目录

PriceDiffBill (退补单)

字段名	数据类型	字段说明
BillID	ctID	单据ID
ord	ctInt	行编号
PRec	ctID	药品编号
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
jobnumber	ctShortStr	批号
ProviderID	ctID	供应商
PtypeSource	tinyint	商品来源
StockUniqueid	ctUID	入库唯一标志
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
unit	tinyint	单位
UnitRate	smallmoney	单位比率
Qty	ctQty	数量
AssQty	ctQty	单据数量
SourcePrice	ctPrice	原单价
Price	ctPrice	现单价
AssPrice	ctPrice	单据单价
DiffPrice	ctPrice	退补单价
AssDiffPrice	ctPrice	单据退补单价
Difftotal	ctTotal	退补金额
costprice	ctPrice	成本单价
SourceTaxPrice	ctPrice	原含税单价
tax	ctTax	税率
TaxPrice	ctPrice	含税单价
AssTaxprice	ctPrice	单据含税单价
DiffTaxPrice	ctPrice	退补含税单价
AssDiffTaxPrice	ctPrice	单据退补含税单价
DiffTaxTotal	ctTotal	退补含税金额
comment	ctComment	说明
RetailPrice	ctPrice	零售价
SourceID	ctID	原单据ID
SourceOrd	ctInt	原单据行号
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
Krec	ctInt	-
_MD	timestamp	-
GJobID	bigint	-

↑ 回到目录

PriceDiffBill_His

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
PRec	ctID	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
jobnumber	ctShortStr	-
ProviderID	ctID	-
PtypeSource	tinyint	-
StockUniqueid	ctUID	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
AssQty	ctQty	-
SourcePrice	ctPrice	-
Price	ctPrice	-
AssPrice	ctPrice	-
DiffPrice	ctPrice	-
AssDiffPrice	ctPrice	-
Difftotal	ctTotal	-
costprice	ctPrice	-
SourceTaxPrice	ctPrice	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxprice	ctPrice	-
DiffTaxPrice	ctPrice	-
AssDiffTaxPrice	ctPrice	-
DiffTaxTotal	ctTotal	-
comment	ctComment	-
RetailPrice	ctPrice	-
SourceID	ctID	-
SourceOrd	ctInt	-
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
Krec	ctInt	-
_MD	timestamp	-
GJobID	bigint	-

↑ 回到目录

PriceDiffBillbak

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
PRec	ctID	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
jobnumber	ctShortStr	-
ProviderID	ctID	-
PtypeSource	tinyint	-
StockUniqueid	ctUID	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
AssQty	ctQty	-
SourcePrice	ctPrice	-
Price	ctPrice	-
AssPrice	ctPrice	-
DiffPrice	ctPrice	-
AssDiffPrice	ctPrice	-
Difftotal	ctTotal	-
costprice	ctPrice	-
SourceTaxPrice	ctPrice	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxprice	ctPrice	-
DiffTaxPrice	ctPrice	-
AssDiffTaxPrice	ctPrice	-
DiffTaxTotal	ctTotal	-
comment	ctComment	-
RetailPrice	ctPrice	-
SourceID	ctID	-
SourceOrd	ctInt	-
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
Krec	ctInt	-
_MD	timestamp	-
GJobID	bigint	-

↑ 回到目录

PriceRecordTable (价格修改记录表)

字段名	数据类型	字段说明
PRec	ctID	商品数字ID
Modidate	datetime	修改日期
ERec	ctID	职员数字ID
Posid	ctID	门店ID
BeForeRetailprice	ctPrice	修改前零售价
AfterRetailprice	ctPrice	修改后零售价
BeForePreprice1	ctPrice	修改前预设售价1
AfterPreprice1	ctPrice	修改后预设售价1
BeForePreprice2	ctPrice	修改前预设售价2
AfterPreprice2	ctPrice	修改后预设售价2
BeForePreprice3	ctPrice	修改前预设售价3
AfterPreprice3	ctPrice	修改后预设售价3
BeForePreprice4	ctPrice	修改前预设售价4
AfterPreprice4	ctPrice	修改后预设售价4
BeForerecPrice	ctPrice	修改前最近进价
AfterrecPrice	ctPrice	修改后最近进价
BeForeBatchStdPrice	ctPrice	修改前国批价
AfterBatchStdPrice	ctPrice	修改后国批价
BeForeRetailStdPrice	ctPrice	修改前国零价
AfterRetailStdPrice	ctPrice	修改后国零价
BeForeD_RetailPrice	ctPrice	修改前整件零售价(未用)
AfterD_RetailPrice	ctPrice	修改后整件零售价(未用)
BeForeD_BatchPrice	ctPrice	修改前整件批发价(未用)
AfterD_BatchPrice	ctPrice	修改后整件批发价(未用)
BeforeVipPrice	ctPrice	修改前会员价
AfterVipPrice	ctPrice	修改后会员价
BeforeTinyPrice	ctPrice	修改前拆零价
AfterTinyPrice	ctPrice	修改后拆零价
Beforerecsaleprice	ctPrice	修改前最近售价
Afterrecsaleprice	ctPrice	修改后最近售价
iffinished	bit	批量修改标志
pricerecordunique	uniqueidentifier	唯一标志
_MD	int	上下传标志
BeforeMaxPrice	ctPrice	修改前最大售价
AfterMaxPrice	ctPrice	修改后最大售价
Unit	int	单位
BeforePrePrice5	ctPrice	修改前预设售价5
AfterPrePrice5	ctPrice	修改后预设售价5
BeforePrePrice6	ctPrice	修改前预设售价6
AfterPrePrice6	ctPrice	修改后预设售价6
BeforePrePrice7	ctPrice	修改前预设售价7
AfterPrePrice7	ctPrice	修改后预设售价7
BeforePrePrice8	ctPrice	修改前预设售价8
AfterPrePrice8	ctPrice	修改后预设售价8
BeforePrePrice9	ctPrice	修改前预设售价9
AfterPrePrice9	ctPrice	修改后预设售价9
BeforePrePrice10	ctPrice	修改前预设售价10
AfterPrePrice10	ctPrice	修改后预设售价10
BeforePrePrice11	ctPrice	修改前预设售价11
AfterPrePrice11	ctPrice	修改后预设售价11
BeforePrePrice12	ctPrice	修改前预设售价12
AfterPrePrice12	ctPrice	修改后预设售价12
BeforePrePrice13	ctPrice	修改前预设售价13
AfterPrePrice13	ctPrice	修改后预设售价13
BeforePrePrice14	ctPrice	修改前预设售价14
AfterPrePrice14	ctPrice	修改后预设售价14
BeforePrePrice15	ctPrice	修改前预设售价15
AfterPrePrice15	ctPrice	修改后预设售价15
Comment	ctComment	-
BeforeCommRetailPricece	ctPrice	-
AfterCommRetailPricece	ctPrice	-

↑ 回到目录

PriceRecordTableTemp

字段名	数据类型	字段说明
PRec	ctID	-
Modidate	datetime	-
ERec	ctID	-
Posid	ctID	-
BeForeRetailprice	ctPrice	-
AfterRetailprice	ctPrice	-
BeForePreprice1	ctPrice	-
AfterPreprice1	ctPrice	-
BeForePreprice2	ctPrice	-
AfterPreprice2	ctPrice	-
BeForePreprice3	ctPrice	-
AfterPreprice3	ctPrice	-
BeForePreprice4	ctPrice	-
AfterPreprice4	ctPrice	-
BeForerecPrice	ctPrice	-
AfterrecPrice	ctPrice	-
BeForeBatchStdPrice	ctPrice	-
AfterBatchStdPrice	ctPrice	-
BeForeRetailStdPrice	ctPrice	-
AfterRetailStdPrice	ctPrice	-
BeForeD_RetailPrice	ctPrice	-
AfterD_RetailPrice	ctPrice	-
BeForeD_BatchPrice	ctPrice	-
AfterD_BatchPrice	ctPrice	-
BeforeVipPrice	ctPrice	-
AfterVipPrice	ctPrice	-
BeforeTinyPrice	ctPrice	-
AfterTinyPrice	ctPrice	-
Beforerecsaleprice	ctPrice	-
Afterrecsaleprice	ctPrice	-
iffinished	bit	-
pricerecordunique	uniqueidentifier	-
BeforeMaxPrice	ctPrice	-
AfterMaxPrice	ctPrice	-
Unit	int	-
BeforePrePrice5	ctPrice	-
AfterPrePrice5	ctPrice	-
BeforePrePrice6	ctPrice	-
AfterPrePrice6	ctPrice	-
BeforePrePrice7	ctPrice	-
AfterPrePrice7	ctPrice	-
BeforePrePrice8	ctPrice	-
AfterPrePrice8	ctPrice	-
BeforePrePrice9	ctPrice	-
AfterPrePrice9	ctPrice	-
BeforePrePrice10	ctPrice	-
AfterPrePrice10	ctPrice	-
BeforePrePrice11	ctPrice	-
AfterPrePrice11	ctPrice	-
BeforePrePrice12	ctPrice	-
AfterPrePrice12	ctPrice	-
BeforePrePrice13	ctPrice	-
AfterPrePrice13	ctPrice	-
BeforePrePrice14	ctPrice	-
AfterPrePrice14	ctPrice	-
BeforePrePrice15	ctPrice	-
AfterPrePrice15	ctPrice	-

↑ 回到目录

PromotionIndex

字段名	数据类型	字段说明
BillID	ctID	-
BillDate	ctDate	-
BillCode	ctShortStr	-
BillType	ctInt	-
Comment	ctShortStr	-
KRec	ctInt	-
BillE	ctInt	-
Checke	ctID	-
IfChecked	ctInt	-
Period	ctInt	-
UniqueBillId	uniqueidentifier	-
OfficeId	ctInt	-
BillDetailCount	ctInt	-
BeginDate	ctDate	-
EndDate	ctDate	-
BeginTime	ctDate	-
EndTime	ctDate	-
UseDayType	ctInt	-
DayList	varchar	-
SaleLimittype	ctInt	-
OnePosDayClientlimit	ctInt	-
UseIntegral	ctID	-
UseCommpirce	ctInt	-
deleflag	ctInt	-
ERec	ctInt	-
Auditingdate	ctDate	-
vipUse	ctInt	-
UseDis	ctInt	-
UseVipPrice	ctInt	-
cycle	ctInt	-
BaseType	ctInt	-
tjcx	ctInt	-
BillStatus	tinyint	-
VipDayInter	ctbit	-
BillTotal	ctTotal	-
PromotionName	ctShortStr	-
ComTotal	ctTotal	-
Lesstotal	ctTotal	-
SendPRec	ctInt	-
ComType	ctInt	-
SendQty	ctQty	-
SendPrice	ctPrice	-
SendLimitQty	ctQty	-
SendTotalQty	ctQty	-
ljcx	int	-
BillExplain	ctComment	-
ProType	ctInt	-
ProLimit	ctInt	-
DiscountType	ctInt	-
CommodityType	ctInt	-
AgeLowerLimit	ctInt	-
AgeUpperLimit	ctInt	-
Days	ctInt	-
SendCheck	ctInt	-
lscx	ctInt	-
AutoSend	ctInt	-
TerminateDate	ctDate	-
PresentType	ctInt	-
lunar	ctInt	-
PresentPriceBase	ctInt	-
dispose	ctInt	-
ORec	ctInt	-
DiscountMode	ctInt	-
VipPointsLow	int	-
VipPointsUp	int	-
VipSendDate	int	-
VipSendLow	ctDate	-
VipSendUp	ctDate	-
VipUseVipPriceCX	tinyint	-
AfterBuyUseDaysCalc	tinyint	-
NolAllowShopCard	tinyint	-
OtherBillOverlyingUse	tinyint	-
MultFullIFExec	ctInt	-
XFFMode	tinyint	-
GiveNumber	ctInt	-
EachBillLimitShopQty	ctInt	-
PayMoneyCalc	ctInt	-
CashType	ctID	-
PresentControlMode	int	-
ProVipMode	int	-

↑ 回到目录

PtypeModify (药品质量信息变更表)

字段名	数据类型	字段说明
ID	ctID	ID
ERec	ctID	修改人
QualityID	ctID	质量信息变更id
Rec	ctID	药品数字id
typeId	ctTypeID	药品字符id
ParId	ctTypeID	父ID
leveal	tinyint	当前级别
sonnum	int	当前儿子数
soncount	int	历史儿子数
UserCode	ctShortStr	药品编码
FullName	ctName	药品全称
Name	ctName	药品简称
Standard	varchar	规格
Type	ctShortStr	型号
PermitNo	varchar	批准文号
Unit1	ctShortStr	小单位
Unit2	ctShortStr	大单位
UnitRate1	smallmoney	单位换算比率(大单位/小单位)
UsefulLifeMonth	smallint	有效月数
UsefulLifeDay	smallint	有效天数
Comment	ctComment	备注
deleted	ctbit	是否删除
TradeMark	ctShortStr	商标
BatchStdPrice	ctPrice	国家指导批发价
RetailStdPrice	ctPrice	国家指导零售价
BarCode	ctShortStr	条码
PYZJM	ctShortStr	拼音助记码
WBZJM	ctShortStr	五笔助记码
Firstcheck	tinyint	是否首营药品
KindOfQlyCheck	int	GSP验收属性
E_Name	ctMidStr	英文名称
Tinyprice	ctPrice	拆零价格
recprice	ctPrice	最近进价
D_Std	ctMidStr	装箱量
if_tiny	bit	是否拆零商品
TinyUnit	varchar	拆零单位
TinyRate	int	拆零比率
StorageCondition	ctShortStr	储藏条件
ChymistryName	ctName	化学名称
ChymistryPY	ctShortStr	化学名拼音码
NamePY	ctShortStr	通用名拼音码
classify	ctShortStr	药品类别
PtypeClassid	int	药品分类
Conserve	tinyint	养护方式
ProArea	ctName	产地
proareaPY	ctShortStr	产地拼音码
UID	ctUID	唯一标志
TypeStatus	varchar	药品性状
Status	tinyint	是否合并药品
Counter	int	最大编号
_Md	timestamp	传输同步标志
ltax	ctTax	税率
tcway	ctName	提成公式
SS_DM	ctShortStr	-
SS_Status	ctbit	医保状态
StopSale	int	销售停止
SafeStockDays	smallint	安全在库天数
UseWay	ctComment	用法
UseNum	varchar	用量
AddDate	ctDate	添加日期
EditDate	ctDate	修改日期
ValDateType	ctbit	有效期至格式
PermitNoPeriod	ctDate	-
Flags	bigint	标志
Updatetag	ctInt	Updatetag
RowIndex	varchar	默然排序编号
CostType	ctbit	价格方式
CommRetailPriceLimit	ctInt	-
FImage	ctInt	-
GMPCode	ctShortStr	-
GMPPeriod	ctDate	-
POutStockLaw	char	-
RX	tinyint	-
ValidityDays	ctInt	-
Area	int	生产厂商
unit3	ctShortStr	-
unitrate2	smallmoney	-
BeforeStopDays	int	-
TranTimeLimit	ctInt	-
QXClass	ctInt	-
QXType	ctInt	-
MZSFtype	varchar	-
WebUniCode	ctShortStr	-
LicenseHolder	int	-
StandardCode	ctMidStr	-
Indications	varchar	-
SendCostRate	ctDiscount	-
TaxCode	varchar	-
JGMType	ctInt	-

↑ 回到目录

PtypePrice (商品价格)

字段名	数据类型	字段说明
PRec	ctID	商品数字ID
Unit	ctbit	单位类型(大小)
PrePrice1	ctPrice	预设价格1
PrePrice2	ctPrice	预设价格2
PrePrice3	ctPrice	预设价格3
Preprice4	ctPrice	预设价格4
PrePrice5	ctPrice	预设价格5
PrePrice6	ctPrice	预设价格6
PrePrice7	ctPrice	预设价格7
PrePrice8	ctPrice	预设价格8
PrePrice9	ctPrice	预设价格9
PrePrice10	ctPrice	预设价格10
PrePrice11	ctPrice	预设价格11
PrePrice12	ctPrice	预设价格12
PrePrice13	ctPrice	预设价格13
PrePrice14	ctPrice	预设价格14
PrePrice15	ctPrice	预设价格15
Vipprice	ctPrice	会员价
Tinyprice	ctPrice	拆零价
MaxPrice	ctPrice	最高售价
MinPrice	ctPrice	最低售价
RecPrice	ctPrice	最近进价
RetailPrice	ctPrice	零售价
CommRetailPrice	ctPrice	日常零售价

↑ 回到目录

PtypeTemp

字段名	数据类型	字段说明
rec	int	-
typeId	ctTypeID	-
ParId	ctTypeID	-
leveal	tinyint	-
sonnum	int	-
soncount	int	-
UserCode	ctShortStr	-
FullName	ctName	-
Name	ctName	-
Standard	varchar	-
Type	ctShortStr	-
PermitNo	varchar	-
Area	int	-
Unit1	ctShortStr	-
Unit2	ctShortStr	-
UnitRate1	smallmoney	-
unit3	ctShortStr	-
unitrate2	smallmoney	-
UsefulLifeMonth	smallint	-
UsefulLifeDay	smallint	-
Comment	ctComment	-
deleted	ctbit	-
TradeMark	ctShortStr	-
BatchStdPrice	ctPrice	-
RetailStdPrice	ctPrice	-
BarCode	ctShortStr	-
PYZJM	ctShortStr	-
WBZJM	ctShortStr	-
Firstcheck	tinyint	-
KindOfQlyCheck	int	-
E_Name	ctMidStr	-
Tinyprice	ctPrice	-
recprice	ctPrice	-
D_Std	ctMidStr	-
if_tiny	bit	-
TinyUnit	varchar	-
TinyRate	int	-
StorageCondition	ctShortStr	-
ChymistryName	ctName	-
ChymistryPY	varchar	-
NamePY	ctShortStr	-
classify	ctShortStr	-
PtypeClassid	int	-
Conserve	tinyint	-
ProArea	ctName	-
proareaPY	ctShortStr	-
UID	ctUID	-
TypeStatus	varchar	-
Status	tinyint	-
Counter	int	-
ltax	ctTax	-
tcway	ctName	-
StopSale	int	-
SafeStockDays	smallint	-
UseWay	ctComment	-
UseNum	varchar	-
AddDate	ctDate	-
EditDate	ctDate	-
ValDateType	ctbit	-
PermitNoPeriod	ctDate	-
Flags	bigint	-
RowIndex	varchar	-
CostType	ctbit	-
Updatetag	ctInt	-
FImage	ctInt	-
ValidityDays	ctInt	-
C0	ctComment	-
C1	ctComment	-
C2	ctComment	-
C3	ctComment	-
C4	ctComment	-
C5	ctComment	-
C6	ctComment	-
C7	ctComment	-
C8	ctComment	-
C9	ctComment	-
C10	ctComment	-
C11	ctComment	-
C12	ctComment	-
C13	ctComment	-
C14	ctComment	-
C15	ctComment	-
C16	ctComment	-
C17	ctComment	-
C18	ctComment	-
C19	ctComment	-
C20	varchar	-
C21	varchar	-
C22	varchar	-
C23	varchar	-
C24	varchar	-
C25	varchar	-
C26	varchar	-
C27	varchar	-
C28	varchar	-
C29	varchar	-
C30	varchar	-
C31	varchar	-
C32	varchar	-
C33	varchar	-
C34	varchar	-
C35	varchar	-
C36	varchar	-
C37	varchar	-
C38	varchar	-
C39	varchar	-
C40	varchar	-
C41	varchar	-
C42	varchar	-
C43	varchar	-
C44	varchar	-
C45	varchar	-
C46	varchar	-
C47	varchar	-
C48	varchar	-
C49	varchar	-
CommRetailPriceLimit	ctInt	-
gmpcode	ctShortStr	-
gmpperiod	ctDate	-
Rx	tinyint	-
POutStockLaw	char	-
color	ctInt	-
ChangeID	ctID	-
TranTimeLimit	ctInt	-
BeforeStopDays	int	-
QXClass	ctInt	-
QXType	ctInt	-
Ingredient	varchar	-
MZSFtype	varchar	-
WebUniCode	ctShortStr	-
DefaultSupplier	ctInt	-
FirstBuyDate	ctDate	-
LicenseHolder	int	-
editoper	varchar	-
StandardCode	ctMidStr	-
Indications	varchar	-
SERVICE	ctbit	-
YLProject	ctbit	-
IsRx	ctbit	-
SS_DM	ctShortStr	-
IsFourtypes	ctbit	-
TaxCode	varchar	-
JGMType	ctInt	-

↑ 回到目录

QualityTrack

字段名	数据类型	字段说明
TrackID	ctID	-
TrackCode	ctShortStr	-
TrackDate	ctDate	-
BillE	ctInt	-
PRec	ctInt	-
OutDate	ctDate	-
JobNumber	ctShortStr	-
InBRec	ctInt	-
OutBRec	ctInt	-
OutBAddress	ctName	-
OutBPhone	ctShortStr	-
OutBLink	ctShortStr	-
Comment	ctComment	-
ifCheck	ctbit	-
OutBSex	ctbit	-
OutBAge	ctQty	-
OutBTXAdd	ctComment	-
HospitalRec	ctInt	-
HospitalName	ctComment	-
Department	ctComment	-
OperationDate	ctDate	-
OperationName	ctComment	-
Qty	ctQty	-
Std	ctComment	-
ProARea	ctComment	-
CSAdd	ctComment	-
CSANO	ctComment	-
CSBNO	ctComment	-
SN	ctComment	-
ValidityPeriod	ctDate	-
BXKZNo	ctComment	-
CheckEName	ctName	-
PersonCode	ctComment	-
GJobID	bigint	-

↑ 回到目录

RFQbill (询报价单明细表)

字段名	数据类型	字段说明
Billid	ctID	单据id
Ord	ctID	单据明细
prec	ctID	商品rec
Qty	ctQty	数量
AssQty	ctQty	单据数量
price	ctPrice	单价
AssPrice	ctPrice	单据单价
total	ctTotal	金额
Tax	ctTax	税率
TaxPrice	ctPrice	含税单价
AssTaxPrice	ctPrice	单据含税单价
TaxTotal	ctTotal	含税金额
Unit	tinyint	单位
UnitRate	smallmoney	单位换算率
refPrice	ctPrice	参考单价
reftotal	ctTotal	参考金额
refGross	ctTotal	参考毛利
comment	ctComment	备注
discount	ctDiscount	折扣
DiscountPrice	ctPrice	折扣单价
AssDiscountPrice	ctPrice	折扣单据单价
ChangeID	ctInt	修改记录id

↑ 回到目录

ROtherBillIndex

字段名	数据类型	字段说明
BillID	ctID	-
BillDate	datetime	-
BillCode	ctShortStr	-
BillType	smallint	-
BillE	ctShortStr	-
CheckE	ctShortStr	-
Qty	ctQty	-
TotalMoney	ctTotal	-
BtypeName	ctMidStr	-
DoctorName	ctShortStr	-
SickName	ctShortStr	-
BillStatus	tinyint	-
CheckDate	datetime	-
Comment	ctComment	-
Subject	ctMidStr	-
Sex	char	-
Age	varchar	-
OfficeId	ctID	-
IsModule	ctbit	-
ModuleName	ctMidStr	-
ModePY	ctShortStr	-
Explain	varchar	-
CheckDesc	ctComment	-
UniqueBillid	ctUID	-
RxType	ctInt	-
RxTime	ctInt	-
IsFY	ctInt	-
HRec	ctInt	-
TRec	ctInt	-
Frec	ctInt	-
Diagnose	varchar	-
DocYZ	varchar	-
DocRec	ctInt	-
FYDate	ctDate	-
Phone	varchar	-
Address	varchar	-
IDNo	varchar	-
Zycf	ctInt	-
Days	ctInt	-
Jishu	ctInt	-
FyDays	ctInt	-
Yyfs	varchar	-
Mjyl	varchar	-
AgeIndex	ctInt	-
Scope	ctInt	-
RoomID	int	-
BillERec	ctInt	-
CheckERec	ctInt	-
IDCard	ctShortStr	-
bizOrderId	ctShortStr	-
ValidDays	ctInt	-
RxOrd	ctInt	-
DocterCode	varchar	-
diag_code	varchar	-
diag_name	varchar	-
diag_type	varchar	-
diag_typename	varchar	-
IsChronic	int	-
dise_codg	varchar	-
dise_name	varchar	-
PriceType	tinyint	-
HName	ctShortStr	-
TName	ctShortStr	-
FName	ctShortStr	-
GroupPrint	tinyint	-

↑ 回到目录

RXTran_580_BillIndex

字段名	数据类型	字段说明
BillID	ctInt	-
BillDate	ctDate	-
storeId	ctShortStr	-
serviceType	ctbit	-
locationUrl	ctComment	-
bizOrderId	ctShortStr	-
pageNum	ctInt	-
pageSize	ctInt	-
beginTime	ctShortStr	-
endTime	ctShortStr	-
pid	ctShortStr	-
diagnosisId	ctShortStr	-
doctorSignTime	ctShortStr	-
doctorOffice	ctShortStr	-
doctorName	ctShortStr	-
userId	ctShortStr	-
userPhone	ctShortStr	-
userFamilyId	ctShortStr	-
userFamilyName	ctShortStr	-
userFamilyPhone	ctShortStr	-
userFamilyGender	ctInt	-
userFamilyAge	ctInt	-
tags	ctComment	-
status	ctInt	-
memo	ctComment	-
auditStatus	ctInt	-
auditTime	ctShortStr	-
auditApothecaryName	ctName	-
remarks	ctComment	-
reason	ctComment	-
dstFilePath	ctComment	-
hospitalName	ctComment	-
mode	ctShortStr	-
Flags	ctInt	-
reviewName	ctName	-
allocateName	ctName	-
prescriptionStatus	ctInt	-
overruleReason	varchar	-
code	varchar	-

↑ 回到目录

RXTran_VipInfo

字段名	数据类型	字段说明
id	ctShortStr	-
create_time	ctShortStr	-
modify_time	ctShortStr	-
start_time	ctShortStr	-
end_time	ctShortStr	-
user_id	ctShortStr	-
token	ctComment	-
ids	ctShortStr	-
page_size	ctShortStr	-
page_index	ctShortStr	-
s_time	ctShortStr	-
e_time	ctShortStr	-
sort_type	ctShortStr	-
dataset_sort	ctShortStr	-
now_role_code	ctComment	-
now_account_id	ctShortStr	-
app_id	ctShortStr	-
login_name	ctShortStr	-
PASSWORD	ctComment	-
nick_name	ctName	-
sex	ctID	-
height	ctShortStr	-
weight	ctShortStr	-
province_id	ctShortStr	-
city_id	ctShortStr	-
district_id	ctShortStr	-
is_delete	ctID	-
hx_id	ctShortStr	-
head_img	ctComment	-
cj_type	ctShortStr	-
cj_id	ctComment	-
age	ctShortStr	-
id_card	ctComment	-
is_vip	ctID	-
salt	ctComment	-
termi_type	ctShortStr	-
currency	ctComment	-
consume_currency	ctComment	-
member_level_id	ctShortStr	-
frozen_currency	ctComment	-
ry_token	ctComment	-
ry_user_id	ctShortStr	-
ADDRESS	ctComment	-
consume_total	ctComment	-
ic_card_id	ctComment	-
archives_number	ctComment	-
blood_pressure_state	ctComment	-
diabetes_state	ctComment	-
uric_acid_state	ctComment	-
next_visit_time	ctShortStr	-
is_get	ctID	-
third_party	ctComment	-
call_number	ctComment	-
member_level_name	ctComment	-
cur_token	ctComment	-
member_level_lev	ctComment	-
cardList	ctComment	-
lately_visit_time	ctShortStr	-
game_times	ctComment	-
gameRecord	ctComment	-
cj_name	ctName	-
groupCode	ctComment	-
temp	ctComment	-
vipcardId	ctID	-

↑ 回到目录

RealTimeDraft (实时可销库存抵扣表)

字段名	数据类型	字段说明
RealTimeBillID	ctInt	自增编号
Ord	ctInt	商品序号
PRec	ctID	商品数字ID
KRec	ctID	仓库数字ID
GRec	ctID	货位数字ID
JobNumber	ctShortStr	商品批次号
OutFactoryDate	ctDate	生产日期
ValidityPeriod	ctDate	有效期
StopUse	tinyint	停用标志
ProviderID	ctID	供应商
PtypeSource	tinyint	商品来源
StockUniqueID	ctUID	入库唯一标志
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告码
Price	ctPrice	成本单价
Qty	ctQty	数量
SpID	ctInt	数据库SpID
LastModifiedTime	ctDate	最后养护时间
BillID	ctID	对应单据草稿ID
RecordID	ctInt	多条数据对应ID
GJobid	bigint	-

↑ 回到目录

RegistrationInfo

字段名	数据类型	字段说明
Rec	ctID	-
ReNo	ctShortStr	-
NAME	ctName	-
Age	ctName	-
BirthTime	datetime	-
Telephone	ctName	-
Profession	ctName	-
ReRard	ctName	-
ADDRES	ctName	-
Sex	ctName	-
RegDepar	ctName	-
Doctor	ctID	-
RegistrationTime	datetime	-
ClinicTime	datetime	-
ClinicStatus	tinyint	-
DELETED	tinyint	-
RegPay	ctTotal	-
OperRec	ctID	-
postid	ctID	-
posid	ctID	-
Comment	ctComment	-
Members	ctShortStr	-
payments	ctShortStr	-
BillId	ctID	-
BacBillId	ctID	-
XH	ctName	-
Change	ctTotal	-
Pay	ctTotal	-
vipID	ctID	-
ARec1	ctInt	-
Total1	ctTotal	-
AgeIndex	ctInt	-
jzid	varchar	-
IsYB	int	-
IsAutoCreate	tinyint	-

↑ 回到目录

RetailBill

字段名	数据类型	字段说明
BillID	ctID	-
Ord	ctInt	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
RetailPrice	ctPrice	-
AssRetailPrice	ctPrice	-
Discount	ctDiscount	-
DiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
DiscountTotal	ctTotal	-
total	ctTotal	-
comment	ctComment	-
RecipeNo	ctShortStr	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
validityPeriod	ctDate	-
CostPrice	ctPrice	-
Unit	tinyint	-
UnitRate	smallmoney	-
KRec	ctID	-
ProviderId	ctID	-
PtypeSource	tinyint	-
GRec	ctID	-
DisRec	ctShortStr	-
SourceRetailPrice	ctPrice	-
StockUniqueid	ctUID	-
SaleEtypeid	ctID	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
backqty	ctQty	-
RecipeNum	smallint	-
PromotionBillNo	ctID	-
PriceType	ctInt	-
limitQty	ctInt	-
PromotionId	ctInt	-
PromotionStatus	ctMidStr	-
PromotionLessId	ctComment	-
PromotionDZId	ctComment	-
PromotionZKId	ctInt	-
dLessTotal	ctTotal	-
sPromotionBillNo	ctMidStr	-
ROutStockLaw	char	-
PromotionNoVipinter	ctInt	-
ChangeID	ctInt	-
PromotionSend	ctInt	-
PromotionZHId	ctComment	-
RxBillId	ctID	-
RxOrd	ctID	-
BeforeChangeTotal	ctTotal	-
_MD	timestamp	-
GJobID	bigint	-
Flags	ctInt	-
RealPrice	ctPrice	-
RealTotal	ctTotal	-
MinusTotal	ctTotal	-
SNTEXT	text	-

↑ 回到目录

RetailBillIndex

字段名	数据类型	字段说明
BillID	ctID	-
BillDate	datetime	-
BillCode	ctShortStr	-
BillType	smallint	-
Comment	ctComment	-
ERec	ctID	-
KRec	ctID	-
Posid	ctID	-
SaleEtypeid	ctID	-
totalmoney	ctTotal	-
totalqty	ctQty	-
DiscountMoney	ctTotal	-
Cash	ctTotal	-
Change	ctTotal	-
explain	ctComment	-
Flags	ctbit	-
HandOverDate	datetime	-
MachineNo	ctInt	-
LinkStatus	tinyint	-
multiple	smallint	-
BuyerName	ctShortStr	-
CurrIntegral	ctTotal	-
CurrIntegralTotal	ctTotal	-
SS_ID	int	-
SS_Status	tinyint	-
Vipid	int	-
ifcheck	char	-
draft	bit	-
DisTinyMoney	numeric	-
printtime	smallint	-
SQERec	ctID	-
SaleChecke	ctInt	-
RxChecke	ctInt	-
ShopCashID	varchar	-
ShopCashCode	varchar	-
ShopSaleID	varchar	-
ShopSaleCode	varchar	-
ShopPromoID	varchar	-
ShopPromoCode	varchar	-
BillFlags	bigint	-
GroupID	ctInt	-
VipChange	ctTotal	-
UniqueBIllid	uniqueidentifier	-
billstatus	int	-
CZBalance	ctTotal	-
BillCash	ctTotal	-
_MD	timestamp	-
CreditIntegrationTotal	ctTotal	-

↑ 回到目录

RetailBillIndexBak

字段名	数据类型	字段说明
BillID	ctID	-
BillDate	datetime	-
BillCode	ctShortStr	-
BillType	smallint	-
Comment	ctComment	-
ERec	ctID	-
KRec	ctID	-
Posid	ctID	-
SaleEtypeid	ctID	-
totalmoney	ctTotal	-
totalqty	ctQty	-
DiscountMoney	ctTotal	-
Cash	ctTotal	-
Change	ctTotal	-
explain	ctComment	-
Flags	ctbit	-
HandOverDate	datetime	-
MachineNo	ctInt	-
LinkStatus	tinyint	-
multiple	smallint	-
BuyerName	ctShortStr	-
CurrIntegral	int	-
CurrIntegralTotal	int	-
SS_ID	int	-
SS_Status	tinyint	-
Vipid	int	-
ifcheck	char	-
draft	bit	-
DisTinyMoney	numeric	-
printtime	smallint	-
SQERec	ctID	-
SaleChecke	ctInt	-
ShopCashID	varchar	-
ShopCashCode	varchar	-
ShopSaleID	varchar	-
ShopSaleCode	varchar	-
ShopPromoID	varchar	-
ShopPromoCode	varchar	-

↑ 回到目录

RetailBillIndex_His

字段名	数据类型	字段说明
BillID	ctID	-
BillDate	datetime	-
BillCode	ctShortStr	-
BillType	smallint	-
Comment	ctComment	-
ERec	ctID	-
KRec	ctID	-
Posid	ctID	-
SaleEtypeid	ctID	-
totalmoney	ctTotal	-
totalqty	ctQty	-
DiscountMoney	ctTotal	-
Cash	ctTotal	-
Change	ctTotal	-
explain	ctComment	-
Flags	ctbit	-
HandOverDate	datetime	-
MachineNo	ctInt	-
LinkStatus	tinyint	-
multiple	smallint	-
BuyerName	ctShortStr	-
CurrIntegral	ctTotal	-
CurrIntegralTotal	ctTotal	-
SS_ID	int	-
SS_Status	tinyint	-
Vipid	int	-
ifcheck	char	-
draft	bit	-
DisTinyMoney	numeric	-
printtime	smallint	-
SQERec	ctID	-
SaleChecke	ctInt	-
RxChecke	ctInt	-
ShopCashID	varchar	-
ShopCashCode	varchar	-
ShopSaleID	varchar	-
ShopSaleCode	varchar	-
ShopPromoID	varchar	-
ShopPromoCode	varchar	-
BillFlags	int	-
GroupID	ctInt	-
VipChange	ctTotal	-
UniqueBIllid	uniqueidentifier	-
billstatus	int	-
CZBalance	ctTotal	-
BillCash	ctTotal	-
_MD	timestamp	-
CreditIntegrationTotal	ctTotal	-

↑ 回到目录

RetailBillTmp

字段名	数据类型	字段说明
DataKey	varchar	-
BillID	ctID	-
Ord	ctInt	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
RetailPrice	ctPrice	-
AssRetailPrice	ctPrice	-
Discount	ctDiscount	-
DiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
DiscountTotal	ctTotal	-
total	ctTotal	-
comment	ctComment	-
RecipeNo	ctShortStr	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
validityPeriod	ctDate	-
CostPrice	ctPrice	-
Unit	tinyint	-
UnitRate	smallmoney	-
KRec	ctID	-
ProviderId	ctID	-
PtypeSource	tinyint	-
GRec	ctID	-
DisRec	ctShortStr	-
SourceRetailPrice	ctPrice	-
StockUniqueid	ctUID	-
SaleEtypeid	ctID	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
backqty	ctQty	-
RecipeNum	smallint	-
PromotionBillNo	ctID	-
PriceType	ctInt	-
limitQty	ctInt	-
PromotionId	ctInt	-
PromotionStatus	ctMidStr	-
PromotionLessId	ctComment	-
PromotionDZId	ctComment	-
PromotionZKId	ctInt	-
dLessTotal	ctTotal	-
sPromotionBillNo	ctMidStr	-
ROutStockLaw	char	-
PromotionNoVipinter	ctInt	-
ChangeID	ctInt	-
PromotionSend	ctInt	-
PromotionZHId	ctComment	-
RxBillId	ctID	-
RxOrd	ctID	-
BeforeChangeTotal	ctTotal	-
_MD	timestamp	-
GJobID	bigint	-
Flags	ctInt	-
RealPrice	ctPrice	-
RealTotal	ctTotal	-
MinusTotal	ctTotal	-
SNTEXT	text	-

↑ 回到目录

RetailBill_His

字段名	数据类型	字段说明
BillID	ctID	-
Ord	ctInt	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
RetailPrice	ctPrice	-
AssRetailPrice	ctPrice	-
Discount	ctDiscount	-
DiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
DiscountTotal	ctTotal	-
total	ctTotal	-
comment	ctComment	-
RecipeNo	ctShortStr	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
validityPeriod	ctDate	-
CostPrice	ctPrice	-
Unit	tinyint	-
UnitRate	smallmoney	-
KRec	ctID	-
ProviderId	ctID	-
PtypeSource	tinyint	-
GRec	ctID	-
DisRec	ctShortStr	-
SourceRetailPrice	ctPrice	-
StockUniqueid	ctUID	-
SaleEtypeid	ctID	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
backqty	ctQty	-
RecipeNum	smallint	-
PromotionBillNo	ctID	-
PriceType	ctInt	-
limitQty	ctInt	-
PromotionId	ctInt	-
PromotionStatus	ctMidStr	-
PromotionLessId	ctComment	-
PromotionDZId	ctComment	-
PromotionZKId	ctInt	-
dLessTotal	ctTotal	-
sPromotionBillNo	ctMidStr	-
ROutStockLaw	char	-
PromotionNoVipinter	ctInt	-
ChangeID	ctInt	-
PromotionSend	ctInt	-
PromotionZHId	ctComment	-
RxBillId	ctInt	-
RxOrd	ctInt	-
BeforeChangeTotal	ctTotal	-
_MD	timestamp	-
GJobID	bigint	-
Flags	ctInt	-
RealPrice	ctPrice	-
RealTotal	ctTotal	-
MinusTotal	ctTotal	-
SNTEXT	text	-

↑ 回到目录

RetailBillbak

字段名	数据类型	字段说明
BillID	ctID	-
Ord	ctInt	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
RetailPrice	ctPrice	-
AssRetailPrice	ctPrice	-
Discount	ctDiscount	-
DiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
DiscountTotal	ctTotal	-
total	ctTotal	-
comment	ctComment	-
RecipeNo	ctShortStr	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
validityPeriod	ctDate	-
CostPrice	ctPrice	-
Unit	tinyint	-
UnitRate	smallmoney	-
KRec	ctID	-
ProviderId	ctID	-
PtypeSource	tinyint	-
GRec	ctID	-
DisRec	ctShortStr	-
SourceRetailPrice	ctPrice	-
StockUniqueid	ctUID	-
SaleEtypeid	ctID	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
backqty	ctQty	-
RecipeNum	smallint	-
PromotionBillNo	ctID	-
PriceType	ctInt	-
limitQty	ctInt	-
PromotionId	ctInt	-
PromotionStatus	ctMidStr	-
PromotionLessId	ctInt	-
PromotionDZId	ctInt	-
PromotionZKId	ctInt	-
dLessTotal	ctTotal	-
sPromotionBillNo	ctMidStr	-
ROutStockLaw	char	-
PromotionNoVipinter	ctInt	-
ChangeID	ctInt	-
GJobID	bigint	-

↑ 回到目录

RetailBuyer

字段名	数据类型	字段说明
BillID	ctID	-
BuyerNo	ctShortStr	-
BuyerName	ctShortStr	-
Phone	ctShortStr	-
Adress	ctMidStr	-
Memo	ctComment	-
Sex	ctShortStr	-
BeginDate	ctDate	-
EndDate	ctDate	-
Nation	ctShortStr	-
Birthday	ctDate	-
organs	ctMidStr	-
RetailType	ctInt	-
img	image	-
Uses	ctInt	-
Heat	ctQty	-
Inspector	ctName	-
InspectorResult	ctInt	-
InspectorDate	ctDate	-
C1	ctComment	-
C2	ctComment	-
C3	ctComment	-
C4	ctComment	-
C5	ctComment	-
C6	ctComment	-
C7	ctComment	-
C8	ctComment	-
C9	ctComment	-
C10	ctComment	-
C11	ctComment	-
C12	ctComment	-
C13	ctComment	-
C14	ctComment	-
C15	ctComment	-
C16	ctComment	-
C17	ctComment	-
C18	ctComment	-
C19	ctComment	-
C20	ctComment	-
drugname	ctComment	-
registrationtime	datetime	-

↑ 回到目录

SNChangeList (序列号调整明细表)

字段名	数据类型	字段说明
BillID	ctInt	单据ID
BillType	ctInt	单据类型
BillDate	ctDate	单据日期
BillE	ctID	-
CheckE	ctID	审核人
Changed	ctbit	是否已经完成修改过程
comment	ctComment	备注
SNID	ctID	-
PRec	ctID	-
OldSN	ctShortStr	-
OldJobNumber	ctShortStr	-
OldGermJobNumber	ctShortStr	-
OldOutFactoryDate	ctDate	-
OldValidityPeriod	ctDate	-
OldProviderID	ctID	-
OldKrec	ctID	-
OldGrec	ctID	-
Oldstatus	ctID	-
OldInDate	ctDate	-
OldOutDate	ctDate	-
OldComment	ctComment	-
NewSN	ctShortStr	-
NewJobNumber	ctShortStr	-
NewGermJobNumber	ctShortStr	-
NewOutFactoryDate	ctDate	-
NewValidityPeriod	ctDate	-
NewProviderID	ctID	-
NewKrec	ctID	-
NewGrec	ctID	-
NewStatus	ctID	-
NewInDate	ctDate	-
NewOutDate	ctDate	-
NewComment	ctComment	-
isCreateBill	ctID	-
OldBRec	ctInt	-
NewBRec	ctInt	-
GJobID	bigint	-

↑ 回到目录

SaleBill (销售出库单)

字段名	数据类型	字段说明
BillID	ctID	单据ID
PRec	ctID	商品编号
KRec	ctID	仓库编号
GRec	ctID	货位编号
Qty	ctQty	数量
AssQty	ctQty	单据数量
costprice	ctPrice	成本单价
SalePrice	ctPrice	单价
AssSalePrice	ctPrice	单据单价
discount	ctDiscount	折扣
DiscountPrice	ctPrice	折后单价
AssDiscountPrice	ctPrice	单据折后单价
total	ctTotal	金额
tax	ctTax	税率
TaxPrice	ctPrice	含税单价
AssTaxPrice	ctPrice	单据含税单价
TaxTotal	ctTotal	含税金额
jobnumber	ctShortStr	批次号
OutFactoryDate	ctDate	出厂日期
ValidityPeriod	ctDate	有效期
comment	ctComment	备注
Eligible	ctShortStr	合格标志
unit	tinyint	单位
UnitRate	smallmoney	单位比率
saleid	ctID	GSP标志
RetailPrice	ctPrice	零售价
ord	int	单据行号
ProviderId	ctID	供应商
PtypeSource	tinyint	商品来源
BackQty	ctQty	退货数量
StockUniqueid	ctUID	入库唯一标志
PriceDiffQty	ctQty	退补数量
SaleEtypeid	ctID	业务员
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告号
PriceType	tinyint	单价类型
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
PromotionID	ctInt	-
PromotionBillCode	ctComment	-
PromotionComment	ctComment	-
PromotionBillID	ctInt	-
ChangeID	ctInt	-
BackReason	varchar	-
oldbillcode	varchar	-
SNTEXT	text	-
JGMQty	int	-
_MD	timestamp	-
GJobid	bigint	-
RealPrice	ctPrice	-
RealTotal	ctTotal	-
RealtaxPrice	ctPrice	-
RealtaxTotal	ctTotal	-

↑ 回到目录

SaleBill_His

字段名	数据类型	字段说明
BillID	ctID	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
costprice	ctPrice	-
SalePrice	ctPrice	-
AssSalePrice	ctPrice	-
discount	ctDiscount	-
DiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
jobnumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
comment	ctComment	-
Eligible	ctShortStr	-
unit	tinyint	-
UnitRate	smallmoney	-
saleid	ctID	-
RetailPrice	ctPrice	-
ord	int	-
ProviderId	ctID	-
PtypeSource	tinyint	-
BackQty	ctQty	-
StockUniqueid	ctUID	-
PriceDiffQty	ctQty	-
SaleEtypeid	ctID	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
PriceType	tinyint	-
InvoceTotal	ctTotal	-
InvoceTag	ctInt	-
PromotionID	ctInt	-
PromotionBillCode	ctComment	-
PromotionComment	ctComment	-
PromotionBillID	ctInt	-
ChangeID	ctInt	-
BackReason	varchar	-
oldbillcode	varchar	-
SNTEXT	text	-
JGMQty	int	-
_MD	timestamp	-
GJobID	bigint	-
RealPrice	ctPrice	-
RealTotal	ctTotal	-
RealtaxPrice	ctPrice	-
RealtaxTotal	ctTotal	-

↑ 回到目录

SendBill (配送模块单据)

字段名	数据类型	字段说明
BillID	ctID	单据ID
ord	ctInt	单据行序号
SourceBillID	uniqueidentifier	原单据索引ID
SourceBillCode	varchar	原单据编号
PRec	ctID	商品
KRec	ctID	仓库
GRec	ctID	货位
unit	tinyint	单位
UnitRate	smallmoney	单位比率
Qty	ctQty	数量
FactQty	ctQty	处理数量
AssQty	ctQty	单据数量
AuditQty	ctQty	预留数量
SourceCostPrice	ctPrice	原成本单价
costprice	ctPrice	成本单价
SalePrice	ctPrice	单价
AssSalePrice	ctPrice	单据单价
total	ctTotal	金额
tax	ctTax	税率
TaxPrice	ctPrice	含税单价
AssTaxPrice	ctPrice	单据含税单价
TaxTotal	ctTotal	含税金额
SourceOutFactoryDate	ctDate	原出厂日期
OutFactoryDate	ctDate	出厂日期
SourceValidityPeriod	ctDate	原有效期
ValidityPeriod	ctDate	有效期
Sourcejobnumber	ctShortStr	原批号
jobnumber	ctShortStr	批号
comment	ctComment	备注
Eligible	ctShortStr	质量状态
RetailPrice	ctPrice	零售价
OrdStatus	tinyint	数据记录行状态
ProviderID	ctInt	供应商
PtypeSource	tinyint	商品来源
StockUniqueid	uniqueidentifier	入库唯一标志
SourceJobCode	ctShortStr	原批次条码
JobCode	ctShortStr	药品监管码
GermJobNumber	ctShortStr	灭菌批号
SourceGermJobNumber	ctShortStr	原灭菌批号
CheckReportNo	ctShortStr	药监报告号
SourceCheckReportNo	ctShortStr	原药监报告号
SendDate	ctDate	-
ChangeID	ctInt	-
JGMQty	int	-
Sendbillcode	varchar	-
StopUse	ctInt	-
PreQty	ctQty	已配送数量
PromotionID	ctInt	-
PromotionBillCode	ctComment	-
PromotionComment	ctComment	-
PromotionBillID	ctInt	-
PriceType	tinyint	-
_MD	timestamp	-
InvoceTag	ctInt	-
GJobID	bigint	-
SourceGJobID	bigint	-
kcqty	ctQty	-
SNTEXT	text	-

↑ 回到目录

SendBillBak

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
SourceBillID	uniqueidentifier	-
SourceBillCode	varchar	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
FactQty	ctQty	-
AssQty	ctQty	-
AuditQty	ctQty	-
SourceCostPrice	ctPrice	-
costprice	ctPrice	-
SalePrice	ctPrice	-
AssSalePrice	ctPrice	-
total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
SourceOutFactoryDate	ctDate	-
OutFactoryDate	ctDate	-
SourceValidityPeriod	ctDate	-
ValidityPeriod	ctDate	-
Sourcejobnumber	ctShortStr	-
jobnumber	ctShortStr	-
comment	ctComment	-
Eligible	ctShortStr	-
RetailPrice	ctPrice	-
OrdStatus	tinyint	-
ProviderID	ctInt	-
PtypeSource	tinyint	-
StockUniqueid	uniqueidentifier	-
SourceJobCode	ctShortStr	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
SourceGermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
SourceCheckReportNo	ctShortStr	-
SendDate	ctDate	-
ChangeID	ctInt	-
JGMQty	int	-
Sendbillcode	varchar	-
StopUse	ctInt	-
PreQty	ctQty	-
PromotionID	ctInt	-
PromotionBillCode	ctComment	-
PromotionComment	ctComment	-
PromotionBillID	ctInt	-
PriceType	tinyint	-
_MD	timestamp	-
InvoceTag	ctInt	-
GJobID	bigint	-
SourceGJobID	bigint	-
kcqty	ctQty	-
SNTEXT	text	-

↑ 回到目录

SendBillOtherInfo (配送表其他信息表)

字段名	数据类型	字段说明
BillID	ctID	单据id
Ord	ctInt	行号
Info1	ctMidStr	外观情况
Info2	ctMidStr	证照情况
Info3	ctMidStr	异物情况
Info4	ctMidStr	验收人
Info5	ctMidStr	签字日期
Info6	ctMidStr	验收人
Info7	ctMidStr	签字日期
Info8	ctMidStr	运输方式
Info9	ctMidStr	发运地点
Info10	ctMidStr	运输单位
DHSJ	ctDate	到货时间
QYSJ	ctDate	启运时间
WKFS	ctMidStr	温控方式
WKZT	ctMidStr	温控状态
DHCTWD	ctMidStr	到货测定温度
SHR	ctShortStr	收货人
JSYY	ctMidStr	拒收原因
BGY	ctShortStr	保管员
BHGCLCS	ctMidStr	不合格事项及处理措施
CYSL	ctQty	抽样数量
SHSSSL	ctQty	-
SHJSSL	ctQty	-
YSSL	ctQty	-
YSHGSL	ctQty	-
YSJSSL	ctQty	-
YSJSYY	ctMidStr	-

↑ 回到目录

SendBill_His

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
SourceBillID	uniqueidentifier	-
SourceBillCode	varchar	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
unit	tinyint	-
UnitRate	smallmoney	-
Qty	ctQty	-
FactQty	ctQty	-
AssQty	ctQty	-
AuditQty	ctQty	-
SourceCostPrice	ctPrice	-
costprice	ctPrice	-
SalePrice	ctPrice	-
AssSalePrice	ctPrice	-
total	ctTotal	-
tax	ctTax	-
TaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
SourceOutFactoryDate	ctDate	-
OutFactoryDate	ctDate	-
SourceValidityPeriod	ctDate	-
ValidityPeriod	ctDate	-
Sourcejobnumber	ctShortStr	-
jobnumber	ctShortStr	-
comment	ctComment	-
Eligible	ctShortStr	-
RetailPrice	ctPrice	-
OrdStatus	tinyint	-
ProviderID	ctInt	-
PtypeSource	tinyint	-
StockUniqueid	uniqueidentifier	-
SourceJobCode	ctShortStr	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
SourceGermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
SourceCheckReportNo	ctShortStr	-
SendDate	ctDate	-
ChangeID	ctInt	-
JGMQty	int	-
_MD	timestamp	-
Sendbillcode	varchar	-
StopUse	ctInt	-
PreQty	ctQty	-
PromotionID	ctInt	-
PromotionBillCode	ctComment	-
PromotionComment	ctComment	-
PromotionBillID	ctInt	-
PriceType	tinyint	-
InvoceTag	ctInt	-
GJobID	bigint	-
SourceGJobID	bigint	-
kcqty	ctQty	-
SNTEXT	text	-

↑ 回到目录

Stock (仓库信息表)

字段名	数据类型	字段说明
Rec	ctID	仓库数字ID
typeId	varchar	仓库字符ID
parid	varchar	父仓库字符ID
leveal	tinyint	当前级别
sonnum	int	当前儿子数
soncount	int	历史儿子数
FullName	ctName	仓库全称
Name	ctName	仓库简称
UserCode	ctShortStr	仓库编码
Comment	ctComment	备注
deleted	ctbit	是否删除
flag	ctbit	是否为门店仓库
PYZJM	ctShortStr	拼音助记码
WBZJM	ctShortStr	五笔助记码
UID	ctUID	唯一标志
StockUse	ctbit	使用标志
Counter	ctInt	最大序号
KLManageType	ctbit	货位管理标志
Updatetag	ctInt	Updatetag
RowIndex	varchar	默认排序行号
Type	char	仓库类型标志
isStop	ctbit	-
BStorage	varchar	-
WholeType	ctInt	-
_Md	timestamp	-
GManageSet	ctInt	-

↑ 回到目录

StockBill (库存单据)

字段名	数据类型	字段说明
BillID	ctID	单据编号
ord	int	序号
PRec	ctID	商品数字ID
KRec	ctID	仓库数字ID
GRec	ctID	货位数字ID
Qty	ctQty	数量
AssQty	ctQty	辅助数量
price	ctPrice	价格
AssPrice	ctPrice	辅助价格
Total	ctTotal	金额
JobNumber	ctShortStr	批次
OutFactoryDate	ctDate	生产日期
ValidityPeriod	ctDate	有效期
comment	ctComment	备注
CostPrice	ctPrice	成本价
Eligible	ctShortStr	Eligible
unit	tinyint	单位
UnitRate	smallmoney	换算比率
providerid	ctID	供应商ID
ptypesource	tinyint	商品来源
StockUniqueid	ctUID	唯一ID
JobCode	ctShortStr	药品监管码
StopUse	tinyint	商品状态
GermJobNumber	ctShortStr	灭菌批号
CheckReportNo	ctShortStr	药监报告码
RetailPrice	ctPrice	-
PromotionID	ctID	-
PromotionBillCode	ctComment	-
PromotionComment	ctComment	-
PromotionBillID	ctID	-
ChangeID	ctID	-
SNTEXT	text	-
_MD	timestamp	-
GJobID	bigint	-

↑ 回到目录

StockBill_His

字段名	数据类型	字段说明
BillID	ctID	-
ord	int	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
price	ctPrice	-
AssPrice	ctPrice	-
Total	ctTotal	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
comment	ctComment	-
CostPrice	ctPrice	-
Eligible	ctShortStr	-
unit	tinyint	-
UnitRate	smallmoney	-
providerid	ctID	-
ptypesource	tinyint	-
StockUniqueid	ctUID	-
JobCode	ctShortStr	-
StopUse	tinyint	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
RetailPrice	ctPrice	-
PromotionID	ctInt	-
PromotionBillCode	ctComment	-
PromotionComment	ctComment	-
PromotionBillID	ctInt	-
ChangeID	ctInt	-
SNTEXT	text	-
_MD	timestamp	-
GJobID	bigint	-

↑ 回到目录

StopGoodsStocks (药品停售(解除停售)通知单)

字段名	数据类型	字段说明
number	int	编号
PtypeId	varchar	商品ID
KtypeId	varchar	仓库Id
JobNumber	varchar	批号
OutFactoryDate	datetime	生产日期
Qty	numeric	数量
Price	numeric	单价
Total	numeric	金额
GoodsOrder	int	商品入库序号
ValidityPeriod	datetime	有效期至
StopUse	int	停用标志
intime	datetime	入库时间
GoodsId	int	仓库标志
lastmaintainTime	datetime	最后养护时间
ProviderId	varchar	供应商ID
PtypeSource	tinyint	商品来源
GTypeID	uniqueidentifier	货位ID
StockUniqueid	uniqueidentifier	入库唯一标志
OperCostPrice	numeric	源成本价
jobcode	varchar	批次条码
GermJobNumber	varchar	灭菌批号
CheckReportNo	varchar	药监报告号
GJobID	bigint	-

↑ 回到目录

VipCard

字段名	数据类型	字段说明
CardNo	varchar	-
Name	ctName	-
Tel	ctShortStr	-
Address	ctShortStr	-
Comment	ctComment	-
CardType	ctInt	-
Discount	smallint	-
BulidDate	ctDate	-
ValidityDate	ctDate	-
Lose	ctbit	-
StopUse	ctbit	-
BuyTotal	ctTotal	-
BuyTotalPerDay	ctTotal	-
AutoDiscount	ctbit	-
membertotal	ctTotal	-
automembertotal	ctInt	-
cardid	ctUID	-
sex	ctbit	-
Birthday	ctDate	-
IdentityCard	ctShortStr	-
E-Mail	ctShortStr	-
MediFeedback	ctMidStr	-
Case	ctMidStr	-
AutoIntegral	ctbit	-
AutoOneoff	ctbit	-
IntegralTotal	ctTotal	-
_Md	timestamp	-
Deleted	ctbit	-
RemainTotal	ctTotal	-
PYZJM	ctShortStr	-
EditFlag	ctbit	-
ID	ctID	-
IsUse	ctbit	-
VipCz	ctbit	-
Cz00	ctTotal	-
CzTotal	ctTotal	-
Cz	ctTotal	-
UsePass	ctbit	-
Password	ctShortStr	-
PosId	int	-
ljIntegral	ctTotal	-
ChangeIntegral	ctTotal	-
UsedCount	ctInt	-
SelCount	ctInt	-
BRec	ctInt	-
IsLife	ctbit	-
giftTotal	numeric	-
giftTotal00	numeric	-
VIPBarCode	varchar	-
JSVIPCardID	int	-
JSNum	int	-
IsJSReward	bit	-
ERec	int	-
JSIntegralTotal	numeric	-
OfferIntegralTotal	numeric	-
Weight	numeric	-
BloodType	varchar	-
Marriage	varchar	-
Flags	bigint	-
BulidPosID	ctInt	-
IntegralTotal00	numeric	-
LastConsumeDate	ctDate	-

↑ 回到目录

VipType

字段名	数据类型	字段说明
CTypeId	ctID	-
TypeName	ctShortStr	-
Discount	ctDiscount	-
Comment	ctComment	-
AutoDiscount	ctbit	-
CanAllPos	ctbit	-
CanUseRemainTotal	ctbit	-
ChangeIntegralPos	ctInt	-
UseVipDay	ctInt	-
DayList	ctMidStr	-
UseDisAndVipPrice	ctbit	-
XIntegral	ctTotal	-
IsSaleLimit	bit	-
automembertotal	bit	-
IfVipPrice	bit	-
vipPriceType	int	-
IfVipPriceDisCount	bit	-
AutoIntegral	bit	-
IfPromotionPriceDisCount	bit	-
UsePtypeDisCount	bit	-
EsPriceNotIntegral	bit	-
vipdayDisCount	int	-
usebirthday	int	-
UseIntegral	ctInt	-
UseVipPrice	ctbit	-
BirthdyDisCount	ctInt	-
BirthdyXIntegral	ctTotal	-
BirthdyMontyDisCount	ctInt	-
BirthdyMonthXIntegral	ctTotal	-
MonthDayList	ctMidStr	-
_Md	timestamp	-
RepeatNum	int	-
IsOnlyJS	bit	-
IsCZPreferential	bit	-
IsIntroduceJS	bit	-
IntroduceJSLimitNum	int	-
IntroducerJS	numeric	-
NewMemberJS	numeric	-
IntroducerJSPer	numeric	-
LimitDays	int	-
WeekVIPDayDisCount	ctInt	-
WeekVIPDayXIntegral	ctTotal	-
WeekVIPDayUseVipPrice	ctbit	-
WeekVIPDayUseDis	ctbit	-
WeekVIPDayUseIntegral	ctbit	-
VIPDayOrder	tinyint	-
NotVIPDayFlags	int	-
VIPDayFlags	int	-
Color	ctShortStr	-
ValidType	ctInt	-
ValidDate	ctShortStr	-
VipDayMode	tinyint	-
IntegralCash	bit	-
IntegralThan	ctInt	-
CostMoneyThan	ctTotal	-
PerIntegral	ctInt	-
ServeMoney	ctTotal	-
ServePercent	ctTotal	-
IntegralServeRule	tinyint	-

↑ 回到目录

WMS_T_SendBill (配送清单明细表)

字段名	数据类型	字段说明
MXID	ctInt	明细ID
SendID	ctID	单据id
ord	ctInt	行号
BRec	ctID	单位ID
BillCount	ctInt	单据份数
BillTotalMoney	ctTotal	单据总金额
BillBenefitTotal	ctTotal	单据优惠总金额
BigQty	ctInt	整件数
SendQty	ctInt	箱数
BagQty	ctInt	袋数
GiftQty	ctInt	赠品数
BillCodeList	varchar	单据编号列表，用于显示用
BoxCodeList	varchar	箱号列表
comment	ctComment	备注
ArTotal	ctTotal	应收款
CurArTotal	ctTotal	本次应收
curArTotalStr	ctMidStr	本次应收的计算公司
ARec	ctID	回款科目
GatherTotal	ctTotal	回款金额
GatherBenefit	ctTotal	回款时的优惠金额
PayE	int	-
PayRet	int	-
PayComment	ctComment	-
PayDate	ctDate	-

↑ 回到目录

XH_Android_PriceTag_Grf

字段名	数据类型	字段说明
ID	int	-
MachineNumber	nvarchar	-
Barcode	nvarchar	-
Qty	int	-
GoodsID	nvarchar	-
GoodsCode	nvarchar	-
GoodsName	nvarchar	-
UnitName	nvarchar	-
Spec	nvarchar	-
obj1	varchar	-
obj2	varchar	-
obj3	varchar	-
obj4	varchar	-
obj5	varchar	-
obj6	varchar	-
obj7	varchar	-
obj8	varchar	-
obj9	varchar	-
obj10	varchar	-
updatetime	datetime	-
PrintCode	varchar	-
Price	varchar	-
obj11	varchar	-
obj12	varchar	-
obj13	varchar	-
obj14	varchar	-
obj15	varchar	-
obj16	varchar	-
obj17	varchar	-
obj18	varchar	-
obj19	varchar	-
obj20	varchar	-
obj21	varchar	-
obj22	varchar	-
obj23	varchar	-
obj24	varchar	-
obj25	varchar	-
obj26	varchar	-
obj27	varchar	-
obj28	varchar	-
obj29	varchar	-
obj30	varchar	-

↑ 回到目录

XH_FH_Temp

字段名	数据类型	字段说明
PickID	ctID	-
BillID	ctID	-
KRec	ctID	-
GRec	ctID	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
total	ctTotal	-
CostPrice	ctPrice	-
jobnumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
ProviderId	ctID	-
PtypeSource	tinyint	-
comment	ctComment	-
unit	tinyint	-
UnitRate	smallmoney	-
retailprice	ctPrice	-
ord	int	-
StockUniqueid	ctUID	-
ChangeID	ctInt	-
GoodsName	ctName	-
UserCode	ctShortStr	-
Standard	ctShortStr	-
BarCode	ctShortStr	-
stockName	ctName	-
GName	ctName	-
type	ctShortStr	-
UnitName	varchar	-
StockNum	numeric	-
areaname	ctMidStr	-
FZName	varchar	-
InputOutFactoryDate	varchar	-
InputValidityPeriod	varchar	-
GJobID	bigint	-
CheckQty	numeric	-
PDA_BackUp_RowNum	int	-
PDA_OldRowIndex	int	-
Check_AllNum	numeric	-

↑ 回到目录

XH_JH_Temp

字段名	数据类型	字段说明
PickID	ctID	-
BillID	ctID	-
KRec	ctID	-
GRec	ctID	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
total	ctTotal	-
CostPrice	ctPrice	-
jobnumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
ProviderId	ctID	-
PtypeSource	tinyint	-
comment	ctComment	-
unit	tinyint	-
UnitRate	smallmoney	-
retailprice	ctPrice	-
ord	int	-
StockUniqueid	ctUID	-
ChangeID	ctInt	-
GoodsName	ctName	-
UserCode	ctShortStr	-
Standard	ctShortStr	-
BarCode	ctShortStr	-
stockName	ctName	-
GName	ctName	-
type	ctShortStr	-
UnitName	varchar	-
StockNum	numeric	-
areaname	ctMidStr	-
FZName	varchar	-
InputOutFactoryDate	varchar	-
InputValidityPeriod	varchar	-
GJobID	bigint	-
check_position	varchar	-
UnitRate1	smallmoney	-
stock_AllNum	numeric	-
aux_qty	varchar	-
PDA_BackUp_RowNum	int	-
PDA_OldRowIndex	int	-
Check_AllNum	numeric	-

↑ 回到目录

XH_SJ_Temp

字段名	数据类型	字段说明
PickID	ctID	-
KRec	ctID	-
GRec	ctID	-
PRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
jobnumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
comment	ctComment	-
unit	tinyint	-
UnitRate	smallmoney	-
retailprice	ctPrice	-
ord	ctInt	-
StockUniqueid	ctUID	-
ChangeID	ctInt	-
GoodsName	ctName	-
UserCode	ctShortStr	-
Standard	ctShortStr	-
BarCode	ctShortStr	-
stockName	ctName	-
GName	ctName	-
UnitName	varchar	-
StockNum	numeric	-
areaname	ctMidStr	-
FZName	varchar	-
InputOutFactoryDate	varchar	-
InputValidityPeriod	varchar	-
SourceID	ctInt	-
UnitRate1	smallmoney	-
aux_qty	varchar	-
PDA_BackUp_RowNum	int	-
PDA_OldRowIndex	int	-
Check_AllNum	numeric	-

↑ 回到目录

YBPtype_ST

字段名	数据类型	字段说明
ypbm	varchar	-
ypmc	varchar	-
oriypbm	varchar	-
oriypmc	varchar	-
standardcode	varchar	-
jx	varchar	-
cj	varchar	-
pzwh	varchar	-
guige	varchar	-
zfbl	varchar	-
zxbzsl	varchar	-
zxbzdw	varchar	-
yxbz	varchar	-
mldzsc	int	-
zcmc	varchar	-
zcjx	varchar	-
sjjx	varchar	-
zcgg	varchar	-
bzcz	varchar	-
zxzjdw	varchar	-
fbzqy	varchar	-
sszt	varchar	-
sn	varchar	-
comment	varchar	-
sjly	varchar	-
daiyu	varchar	-
list_type	varchar	-
ybypmc	varchar	-
ybjx	varchar	-
xysdm	varchar	-
pzff	varchar	-
gxfl	varchar	-
yckly	varchar	-
yczly	varchar	-
yybw	varchar	-
xwygj	varchar	-
gnyzz	varchar	-
yfyyl	varchar	-
ybzfzc	varchar	-
bzmc	varchar	-
bzym	varchar	-
yjfl	varchar	-
ejfl	varchar	-
sjfl	varchar	-
cz	varchar	-
tz	varchar	-
gjdm	varchar	-
dfdm	varchar	-
dfmc	varchar	-
xmbh	varchar	-
xmmc	varchar	-
sfyb	varchar	-
mzyy	varchar	-
zyyy	varchar	-
qtyyxz	varchar	-
ybfyfw	varchar	-
fpxm	varchar	-
NamePY	varchar	-
AreaPY	varchar	-
lmt_used_flag	varchar	-

↑ 回到目录

YBService_JS

字段名	数据类型	字段说明
setl_id	ctShortStr	-
mdtrt_id	ctShortStr	-
psn_no	ctShortStr	-
psn_name	ctShortStr	-
psn_cert_type	ctShortStr	-
certno	ctShortStr	-
insutype	ctShortStr	-
psn_type	ctShortStr	-
emp_name	varchar	-
fixmedins_code	ctShortStr	-
fixmedins_name	varchar	-
setl_time	ctShortStr	-
mdtrt_cert_type	ctShortStr	-
medfee_sumamt	ctTotal	-
fulamt_ownpay_amt	ctTotal	-
overlmt_selfpay	ctTotal	-
preselfpay_amt	ctTotal	-
inscp_scp_amt	ctTotal	-
act_pay_dedc	ctTotal	-
hifp_pay	ctTotal	-
pool_prop_selfpay	ctTotal	-
cvlserv_pay	ctTotal	-
hifes_pay	ctTotal	-
hifmi_pay	ctTotal	-
hifob_pay	ctTotal	-
maf_pay	ctTotal	-
oth_pay	ctTotal	-
fund_pay_sumamt	ctTotal	-
psn_pay	ctTotal	-
acct_pay	ctTotal	-
cash_payamt	ctTotal	-
balc	ctTotal	-
acct_mulaid_pay	ctTotal	-
dise_codg	ctShortStr	-
dise_name	varchar	-
opter_name	ctShortStr	-
opt_time	ctShortStr	-

↑ 回到目录

YBSettlelist_OTO

字段名	数据类型	字段说明
ID	ctInt	-
setl_id	varchar	-
mdtrt_id	varchar	-
psn_no	varchar	-
psn_name	varchar	-
psn_cert_type	varchar	-
certno	varchar	-
gend	varchar	-
naty	varchar	-
brdy	varchar	-
age	int	-
insutype	varchar	-
psn_type	varchar	-
cvlserv_flag	varchar	-
setl_time	datetime	-
mdtrt_cert_type	varchar	-
med_type	varchar	-
medfee_sumamt	numeric	-
fulamt_ownpay_amt	numeric	-
overlmt_selfpay	numeric	-
preselfpay_amt	numeric	-
inscp_scp_amt	numeric	-
act_pay_dedc	numeric	-
hifp_pay	numeric	-
pool_prop_selfpay	numeric	-
cvlserv_pay	numeric	-
hifes_pay	numeric	-
hifmi_pay	numeric	-
hifob_pay	numeric	-
maf_pay	numeric	-
oth_pay	numeric	-
fund_pay_sumamt	numeric	-
psn_part_amt	numeric	-
acct_pay	numeric	-
psn_cash_pay	numeric	-
wlt_acct_pay	numeric	-
balc	numeric	-
acct_mulaid_pay	numeric	-
medins_setl_id	varchar	-
clr_optins	varchar	-
clr_way	varchar	-
clr_type	varchar	-
insuplc_admdvs	varchar	-
mdtrtarea_admvs	varchar	-
fixmedins_code	varchar	-
emp_name	varchar	-
dise_codg	varchar	-
dise_name	varchar	-
rxCircFlag	int	-
OrderID	varchar	-
YbFlags	int	-
Posid	int	-
billId	int	-
Retail_BillTotal	numeric	-
Retail_NotYBTotal	numeric	-
Retail_SplitTotal	numeric	-

↑ 回到目录

YBSettlelist_QT

字段名	数据类型	字段说明
ID	ctInt	-
FeeDate	ctDate	-
SettleNo	ctShortStr	-
TreatmentNO	ctShortStr	-
PsnNo	ctShortStr	-
CardName	ctShortStr	-
PsnCertType	ctShortStr	-
CardNo	ctShortStr	-
Sex	varchar	-
Insutype	varchar	-
EName	ctShortStr	-
Ylfzfy	ctTotal	-
Bczhzf	ctTotal	-
Grxjzf	ctTotal	-
Bczfye	ctTotal	-
DELETED	int	-
JsDate	ctShortStr	-
clr_optins	varchar	-
clr_type	varchar	-
fund_pay_sumamt	ctTotal	-
acct_pay	ctTotal	-
psn_selfpay	ctTotal	-
psn_ownpay	ctTotal	-
psn_cashpay	ctTotal	-
fulamt_ownpay_amt	ctTotal	-
overlmt_selfpay	ctTotal	-
preselfpay_amt	ctTotal	-
inscp_scp_amt	ctTotal	-
act_pay_dedc	ctTotal	-
hifp_pay	ctTotal	-
pool_prop_selfpay	ctTotal	-
cvlserv_pay	ctTotal	-
hifes_pay	ctTotal	-
hifmi_pay	ctTotal	-
hifob_pay	ctTotal	-
maf_pay	ctTotal	-
oth_pay	ctTotal	-
psn_part_amt	ctTotal	-
acct_mulaid_pay	ctTotal	-
medins_setl_id	varchar	-
thsetl_id	ctShortStr	-
brdy	varchar	-
naty	varchar	-
age	int	-
med_type	varchar	-
BillStatus	int	-
EMRFlag	int	-
emp_name	varchar	-
psn_type	varchar	-
grzf	ctTotal	-
xzf	ctTotal	-
dnzf	ctTotal	-
hi_rxno	varchar	-
WgFlag	int	-
fixmedins_code	varchar	-
mdtrtarea_admvs	varchar	-
insuplc_admdvs	varchar	-
PosId	int	-
dise_name	varchar	-
mdtrt_cert_type	varchar	-
psn_idet_type	varchar	-
phone	varchar	-
diag_name	varchar	-
acct_used_flag	varchar	-
psnPay	ctTotal	-
enttAcctPay	ctTotal	-
cashAcctPay	ctTotal	-
allEnttAcctPay	ctTotal	-
masonic_used_flag	varchar	-
ydFlag	int	-
DRGFlag	int	-
balance	ctTotal	-
allBalance	ctTotal	-
Retail_BillTotal	ctTotal	-
Retail_NotYBTotal	ctTotal	-
Retail_SplitTotal	ctTotal	-
account_check	ctInt	-
BackDate	ctBillDate	-
ybFlags	int	-
mdtrt_cert_no	varchar	-
card_sn	varchar	-
SuppleDate	datetime	-

↑ 回到目录

YBSettlelist_ST

字段名	数据类型	字段说明
ID	ctInt	-
FeeDate	ctDate	-
SettleNo	ctShortStr	-
TreatmentNO	ctShortStr	-
PsnNo	ctShortStr	-
CardName	ctShortStr	-
PsnCertType	ctShortStr	-
CardNo	ctShortStr	-
Sex	varchar	-
Insutype	varchar	-
EName	ctShortStr	-
Ylfzfy	ctTotal	-
Bczhzf	ctTotal	-
Grxjzf	ctTotal	-
Bczfye	ctTotal	-
DELETED	int	-
JsDate	ctShortStr	-
clr_optins	varchar	-
clr_type	varchar	-
fund_pay_sumamt	ctTotal	-
acct_pay	ctTotal	-
psn_selfpay	ctTotal	-
psn_ownpay	ctTotal	-
psn_cashpay	ctTotal	-
fulamt_ownpay_amt	ctTotal	-
overlmt_selfpay	ctTotal	-
preselfpay_amt	ctTotal	-
inscp_scp_amt	ctTotal	-
act_pay_dedc	ctTotal	-
hifp_pay	ctTotal	-
pool_prop_selfpay	ctTotal	-
cvlserv_pay	ctTotal	-
hifes_pay	ctTotal	-
hifmi_pay	ctTotal	-
hifob_pay	ctTotal	-
maf_pay	ctTotal	-
oth_pay	ctTotal	-
psn_part_amt	ctTotal	-
acct_mulaid_pay	ctTotal	-
medins_setl_id	varchar	-
thsetl_id	ctShortStr	-
brdy	varchar	-
naty	varchar	-
age	int	-
med_type	varchar	-
BillStatus	int	-
EMRFlag	int	-
emp_name	varchar	-
psn_type	varchar	-
grzf	ctTotal	-
xzf	ctTotal	-
dnzf	ctTotal	-
fixmedins_code	varchar	-
mdtrtarea_admvs	varchar	-
insuplc_admdvs	varchar	-
PosId	int	-
dise_name	varchar	-
mdtrt_cert_type	varchar	-
Retail_BillTotal	ctTotal	-
Retail_NotYBTotal	ctTotal	-
Retail_SplitTotal	ctTotal	-
account_check	ctInt	-
hi_rxno	varchar	-
WgFlag	int	-
dise_codg	varchar	-
psn_idet_type	varchar	-
phone	varchar	-
diag_name	varchar	-
acct_used_flag	varchar	-
psnPay	ctTotal	-
enttAcctPay	ctTotal	-
cashAcctPay	ctTotal	-
allEnttAcctPay	ctTotal	-
masonic_used_flag	varchar	-
ydFlag	int	-
DRGFlag	int	-
balance	ctTotal	-
allBalance	ctTotal	-
BackDate	datetime	-
ybFlags	int	-
mdtrt_cert_no	varchar	-
card_sn	varchar	-
wlt_acct_pay	ctTotal	-
hosp_part_amt	ctTotal	-
orderId	varchar	-
RxBillid	int	-
payChnlUrName	varchar	-
payCert	varchar	-
payChnlName	varchar	-

↑ 回到目录

YB_7203_mdtrtinfo

字段名	数据类型	字段说明
BillID	ctInt	-
mdtrt_id	varchar	-
med_type	varchar	-
ipt_op_no	varchar	-
psn_no	varchar	-
patn_name	varchar	-
age	varchar	-
patn_ht	varchar	-
patn_wt	varchar	-
gend	varchar	-
geso_val	varchar	-
nwb_flag	varchar	-
nwb_age	varchar	-
suck_prd_flag	varchar	-
algs_his	varchar	-
insuplc_admdvs	varchar	-
psn_cert_type	varchar	-
certno	varchar	-
insutype	varchar	-
prsc_dept_name	varchar	-
prsc_dept_code	varchar	-
prsc_dr_name	varchar	-
phar_name	varchar	-
phar_chk_time	varchar	-
mdtrt_time	varchar	-
dise_codg	varchar	-
dise_name	varchar	-
sp_dise_flag	varchar	-
diag_code	varchar	-
diag_name	varchar	-
dise_cond_dscr	varchar	-
fstdiag	varchar	-

↑ 回到目录

YB_7203_rxdrugdetail

字段名	数据类型	字段说明
BillID	ctInt	-
ord	ctInt	-
med_list_codg	varchar	-
fixmedins_hilist_id	varchar	-
hosp_prep_flag	varchar	-
rx_item_type_code	varchar	-
rx_item_type_name	varchar	-
tcmdrug_type_name	varchar	-
tcmdrug_type_code	varchar	-
tcmherb_foote	varchar	-
medn_type_code	varchar	-
medn_type_name	varchar	-
main_medc_flag	varchar	-
urgt_flag	varchar	-
bas_medn_flag	varchar	-
imp_drug_flag	varchar	-
prod_barc	varchar	-
drug_prodname	varchar	-
genname_codg	varchar	-
drug_genname	varchar	-
chemname	varchar	-
drugstdcode	varchar	-
drug_dosform	varchar	-
drug_spec	varchar	-
prdr_name	varchar	-
drug_pric	ctPrice	-
drug_cnt	ctQty	-
drug_sumamt	ctTotal	-
medc_way_codg	varchar	-
medc_way_dscr	varchar	-
medc_starttime	ctShortStr	-
medc_endtime	ctShortStr	-
medc_days	ctQty	-
drug_dosunt	varchar	-
sin_doscnt	ctQty	-
sin_dosunt	varchar	-
used_frqu_codg	varchar	-
used_frqu_name	varchar	-
drug_totlnt	varchar	-
drug_totlnt_emp	varchar	-
dise_codg	varchar	-
Prec	int	-
drug_cnt_unit	varchar	-

↑ 回到目录

YB_FeeDetail

字段名	数据类型	字段说明
mdtrt_id	ctShortStr	-
setl_id	ctShortStr	-
feedetl_sn	ctShortStr	-
rx_drord_no	ctShortStr	-
med_type	ctShortStr	-
fee_ocur_time	ctShortStr	-
cnt	ctQty	-
pric	ctPrice	-
sin_dos_dscr	varchar	-
used_frqu_dscr	varchar	-
prd_days	ctTotal	-
medc_way_dscr	varchar	-
det_item_fee_sumamt	ctTotal	-
pric_uplmt_amt	ctTotal	-
selfpay_prop	ctTotal	-
fulamt_ownpay_amt	ctTotal	-
overlmt_amt	ctTotal	-
preselfpay_amt	ctTotal	-
inscp_scp_amt	ctTotal	-
chrgitm_lv	varchar	-
hilist_code	ctShortStr	-
hilist_name	varchar	-
list_type	varchar	-
med_list_codg	ctShortStr	-
medins_list_codg	varchar	-
medins_list_name	varchar	-
med_chrgitm_type	varchar	-
prodname	varchar	-
spec	varchar	-
dosform_name	varchar	-
memo	varchar	-
opter_id	ctShortStr	-
opter_name	ctShortStr	-
opt_time	ctShortStr	-

↑ 回到目录

YB_JGMLPP

字段名	数据类型	字段说明
fixmedins_code	ctShortStr	-
medins_list_codg	ctShortStr	-
medins_list_name	varchar	-
insu_admdvs	ctShortStr	-
list_type	ctShortStr	-
med_list_codg	ctShortStr	-
begndate	ctShortStr	-
enddate	ctShortStr	-
aprvno	ctShortStr	-
dosform	varchar	-
exct_cont	varchar	-
item_cont	varchar	-
prcunt	varchar	-
spec	varchar	-
pacspec	varchar	-
memo	varchar	-
vali_flag	varchar	-
rid	ctShortStr	-
updt_time	ctShortStr	-
crter_id	ctShortStr	-
crter_name	ctShortStr	-
crte_time	ctShortStr	-
crte_optins_no	ctShortStr	-
opter_id	ctShortStr	-
opter_name	ctShortStr	-
opt_time	ctShortStr	-
optins_no	ctShortStr	-
poolarea_no	ctShortStr	-

↑ 回到目录

YB_XZ_rxDetlList

字段名	数据类型	字段说明
BillID	ctInt	-
ord	ctInt	-
medListCodg	varchar	-
fixmedinsHilistId	varchar	-
hospPrepFlag	varchar	-
rxItemTypeCode	varchar	-
rxItemTypeName	varchar	-
tcmdrugTypeName	varchar	-
tcmdrugTypeCode	varchar	-
tcmherbFoote	varchar	-
mednTypeCode	varchar	-
mednTypeName	varchar	-
mainMedcFlag	varchar	-
urgtFlag	varchar	-
basMednFlag	varchar	-
impDrugFlag	varchar	-
drugProdname	varchar	-
drugGenname	varchar	-
drugDosform	varchar	-
drugSpec	varchar	-
prdrName	varchar	-
medcWayCodg	varchar	-
medcWayDscr	varchar	-
medcBegntime	ctShortStr	-
medcEndtime	ctShortStr	-
medcDays	ctQty	-
drugCnt	ctQty	-
drugDosunt	varchar	-
sinDoscnt	ctQty	-
sinDosunt	varchar	-
usedFrquCodg	varchar	-
usedFrquName	varchar	-
drugTotlcnt	ctQty	-
drugTotlcntEmp	varchar	-
hospApprFlag	varchar	-
Prec	int	-
takeDrugFlag	varchar	-
otcFlag	varchar	-
selfPayRea	varchar	-
realDscr	varchar	-

↑ 回到目录

YB_YBMLXX

字段名	数据类型	字段说明
hilist_code	ctShortStr	-
hilist_name	varchar	-
insu_admdvs	varchar	-
begndate	ctShortStr	-
enddate	ctShortStr	-
med_chrgitm_type	varchar	-
chrgitm_lv	varchar	-
lmt_used_flag	varchar	-
list_type	varchar	-
med_use_flag	varchar	-
matn_used_flag	varchar	-
hilist_use_type	varchar	-
lmt_cpnd_type	varchar	-
wubi	ctShortStr	-
pinyin	ctShortStr	-
memo	varchar	-
vali_flag	varchar	-
rid	ctShortStr	-
updt_time	ctShortStr	-
crter_id	ctShortStr	-
crter_name	ctShortStr	-
crte_time	ctShortStr	-
crte_optins_no	ctShortStr	-
opter_id	ctShortStr	-
opter_name	ctShortStr	-
opt_time	ctShortStr	-
optins_no	ctShortStr	-
poolarea_no	ctShortStr	-

↑ 回到目录

YearReviewBill

字段名	数据类型	字段说明
BillID	ctInt	-
Ord	ctInt	-
PRec	ctInt	-
BRec	ctInt	-
BuyJob	ctInt	-
BuyRejectionJob	ctInt	-
AcceptJob	ctInt	-
AcceptPassRate	ctComment	-
BuyBack	ctInt	-
SaleAfterComplain	ctComment	-
StockMaintainQualityStatus	ctComment	-
SupervisionTakeOutNotice	ctComment	-
CredentialsStatus	ctComment	-
SaleAfterService	ctComment	-
ReviewConclusion	ctComment	-
StockQualityUnusualStatus	ctInt	-
QualitySaleBack	ctComment	-
QualityComplain	ctComment	-
QualityTakeOutUnqualified	ctComment	-
SaleJob	ctInt	-
SendRejectionJob	ctInt	-
CheckJob	ctInt	-
CheckPassRate	ctComment	-
SaleBack	ctInt	-
Comment	ctComment	-

↑ 回到目录

billindexOtherInfo (单据主表其他信息表)

字段名	数据类型	字段说明
Indexbillid	int	关联表的billid
BTYPEAttorneyid	int	-
YS_Weway	varchar	运输方式
YS_ADDR	varchar	发运地点
YS_DW	varchar	运输单位
YS_Date	datetime	启运时间
YS_WKFS	varchar	温控方式
YS_WKZT	varchar	温控状态
YS_DHWD	varchar	到货测定温度
CGJLSinge	ctName	-
ZGJLSinge	ctName	-
TSChecker	int	特殊管控药品审核人
WTPosId	ctID	委托posid
pricetype	ctID	价格类型
costrate	ctDiscount	成本率
DealBlackJGM	ctbit	目标监管码
SpecNum	ctInt	-
costtotal	ctTotal	-
ProfitTotal	ctTotal	-
taxcosttotal	ctTotal	-
taxProfitTotal	ctTotal	-
invoicetype	int	-

↑ 回到目录

btype (往来单位信息表)

字段名	数据类型	字段说明
Rec	ctID	往来单位数字ID
typeId	ctTypeID	往来单位字符ID
parid	ctTypeID	父节点字符ID
leveal	tinyint	当前级别
soncount	int	历史儿子数
sonnum	int	当前儿子数
UserCode	ctShortStr	往来单位编码
FullName	ctName	往来单位全称
Name	ctName	往来单位简称
Area	int	片区ID
Tel	ctShortStr	电话
Address	ctComment	地址
PostCode	varchar	邮编
Person	ctShortStr	联系人
TaxNumber	ctShortStr	税务登记号
Bank	ctMidStr	开户行
Account	ctMidStr	开户账号
Comment	ctComment	备注
ARTotal	ctTotal	应收账款总数
APTotal	ctTotal	应付账款总数
CreditCount	ctTotal	应收账款信用额度
ARTotal00	ctTotal	应收账款期初值
APTotal00	ctTotal	应付账款起初值
deleted	ctbit	是否删除
PYZJM	ctShortStr	拼音助记码
WBZJM	ctShortStr	五笔助记码
PriceMode	tinyint	价格模式
preArTotal	ctTotal	预收款总额
preArTotal00	ctTotal	预收款期初总额
preApTotal	ctTotal	预付款总额
preApTotal00	ctTotal	预付款期初总额
FirstCheck	tinyint	首营企业审批
UFUserCode	varchar	用油对应编号
CreditDays	int	信用额度天数
ifUnitType	tinyint	企业类型
Email	ctShortStr	电子邮件地址
Fax	ctShortStr	传真
ID_Card	ctMidStr	联系人身份证
LinkPhone	ctShortStr	联系电话
corporation	ctShortStr	法人代表
ProjectType	ctInt	企业性质
charter	ctShortStr	charter
license	ctShortStr	license
scope	ctComment	经营范围
UID	ctUID	唯一标志
Counter	int	最大数量标志
isclient	tinyint	客户标识
_Md	timestamp	同步标志
SendWay	ctComment	送货方式
ERec	ctID	业务员ID
StopSale	ctbit	是否停用
GSPValidityPeriod	ctDate	GSP/GMP有效时间至
AddDate	ctDate	添加时间
EditDate	ctDate	最后编辑时间
Updatetag	ctInt	Updatetag
RowIndex	varchar	默认排序行号
BTypeFlags	bigint	标志
GMPGSPCode	ctShortStr	-
YfQuota	ctTotal	-
YSTotal	ctTotal	-
YFTotal	ctTotal	-
YsTotal00	ctTotal	-
YFTotal00	ctTotal	-
ckdz	ctComment	-
ChangeID	ctID	-
WebUniCode	ctShortStr	-
JSBRec	ctID	-
EditOper	varchar	-
ckdz2	varchar	-
ckdz3	varchar	-
ckdz4	varchar	-
IncomeBillJsType	int	-
PayBillJsType	int	-
invoicetype	int	-
PriceRate	numeric	-

↑ 回到目录

conBaseInfoSet (基本信息配置表)

字段名	数据类型	字段说明
ID	int	ID
ModuleID	int	模块编号
OrderCount	int	顺序号
ControlType	int	控件类型
DisplayName	varchar	显示名称
FieldName	varchar	字段名称
ParamName	varchar	参数名称
Panel	int	包容控件
width	int	占用宽度
height	int	占用高度
Visible	bit	是否显示
ColCount	int	列数量
FieldList	int	对照xw的编码
FlagsPosition	int	顺序标志
otherInfo	int	其他信息
MustField	ctbit	是否必填
_DM	timestamp	_DM
defaultData	varchar	默认信息
UseCanVisible	bit	是否使用
FlagFieldList	int	对照xw的显示编码
Version	ctInt	版本号
configinfo	varchar	-
RowKey	ctID	-
CanModify	int	-

↑ 回到目录

cstype (生产厂商信息表)

字段名	数据类型	字段说明
Rec	ctInt	rec
typeid	ctTypeID	typeid
parid	ctTypeID	父类typeid
leveal	tinyint	层次数
soncount	int	曾经儿子数
sonnum	int	现有儿子数
UserCode	ctShortStr	编码
FullName	ctMidStr	全名
PYCode	ctShortStr	拼音码
NAME	ctShortStr	简称
EMail	ctMidStr	电子邮箱
FaxNo	ctShortStr	传真
Tel	ctShortStr	电话
AddDate	ctDate	增加日期
Adress	ctMidStr	地址
PostCode	varchar	邮政编码
Contact	ctShortStr	联系人
Comment	ctComment	备注
isStop	ctbit	是否停用
DELETED	ctbit	删除标志
Updatetag	int	基本信息本地化更新位
RowIndex	varchar	RowIndex
Counter	ctInt	计数器
_Md	timestamp	-

↑ 回到目录

employee (职员信息表)

字段名	数据类型	字段说明
REC	ctID	职员数字ID
typeId	ctTypeID	职员字符ID
Parid	ctTypeID	父节点字符ID
leveal	tinyint	当前级别
soncount	int	历史儿子数
sonnum	int	当前儿子数
FullName	ctName	职员全名
Name	ctName	简称
UserCode	ctShortStr	用户编码
Department	ctID	部门Id
Tel	ctShortStr	联系电话
Address	ctShortStr	联系地址
Comment	ctComment	注释
deleted	ctbit	是否删除
PYZJM	ctShortStr	拼音助记码
WBZJM	ctShortStr	五笔助记码
Credit	ctTotal	信用额度
Aptotal	ctTotal	应付金额
Artotal	ctTotal	应收金额
Posid	ctID	所属门店
Sex	char	性别
Birthday	ctDate	出生日期
Edu_Level	ctShortStr	学历
Specialty	ctShortStr	专业
School	ctMidStr	学校
Graduate_Date	ctDate	毕业时间
Duty	ctShortStr	职务
Technic_Level	ctShortStr	技术职称
Station	ctShortStr	岗位
WorkTime	ctShortStr	任职时间
WorkCompetency	ctShortStr	职业资格
Certificate	ctShortStr	资格证书号
Certificate_Dept	ctShortStr	职业资格证书鉴定单位
Train_Dept	ctShortStr	岗位培训部门
Work_No	ctShortStr	上岗证书号
Archives_No	ctShortStr	档案号
UID	ctUID	唯一标示
Counter	ctInt	最大序号
salediscount	ctDiscount	销售折扣
LowPriceSetBl	smallmoney	最低售价限制系数
BenefitScope	smallmoney	-
ETypeFlags	bigint	标示
UpDateTag	ctInt	UpDateTag
DoctorNo	ctShortStr	医师证书号
DoctorDate	ctDate	医师有效期
RowIndex	varchar	-
isStop	ctbit	-
DoctorCode	ctShortStr	-
WebUniCode	ctShortStr	-
IDCardNO	ctShortStr	-
Messageflages	int	-

↑ 回到目录

gsp_m_mdadvice (门店客户意见及投诉卡)

字段名	数据类型	字段说明
no	int	no
bh	varchar	编号
btsbm	varchar	被投诉部门
tszname	varchar	投诉者姓名
tszxb	varchar	性别
tsznl	int	投诉者年龄
tszphone	varchar	投诉者电话
tszAddress	varchar	投诉者地址
tszadvice	varchar	意见及投诉内容
tsslr	varchar	投诉受理人
sldate	datetime	受理日期
tsbmyj	varchar	被投诉部门陈述或核实
tsbmfzr	varchar	被投诉部门负责人
tsbmdate	datetime	签字日期
zgbmyj	varchar	质管部门意见
zgbmfzr	varchar	质管部门负责人
zgbmdate	datetime	质管部门签字日期
mdfzryj	varchar	门店负责人意见
mdfzr	varchar	门店负责人签字
mddate	datetime	门店负责人签字日期

↑ 回到目录

gsp_w_spjyspb

字段名	数据类型	字段说明
orderid	int	-
number	varchar	-
date	datetime	-
usercode	varchar	-
ptypeid	varchar	-
pfullname	varchar	-
stand	varchar	-
tbbm	varchar	-
scqy	varchar	-
sjzg	varchar	-
spqk	text	-
pzwh	varchar	-
zlbz	varchar	-
zxgg	varchar	-
yxq	varchar	-
gcfzq	varchar	-
cctj	varchar	-
sgsj	numeric	-
zccc	numeric	-
pfj	numeric	-
sqyy	varchar	-
cgyyj	varchar	-
yyzgbm	varchar	-
zlglbm	varchar	-
wjbmgl	varchar	-
jlspyj	varchar	-
Signor	varchar	-
IsCheck	char	-
BillDate	datetime	-
pname	varchar	-
type	varchar	-
GMPLetter	varchar	-
Attestation	datetime	-
PackUnit	varchar	-
SaveNeed	varchar	-
StockName	varchar	-
StockDate	datetime	-
OperateName	varchar	-
OperateDate	datetime	-
PriceName	varchar	-
PriceDate	datetime	-
MassName	varchar	-
MassDate	datetime	-
MgrDate	datetime	-
CheckMind	int	-
PPartID	varchar	-
PCSRec	int	-
RETAILSTDPRICE	numeric	-
QualityName	varchar	-
QualityDate	ctDate	-
Quality	varchar	-
PermitValidity	ctDate	-
GMPValidity	ctDate	-
Register	ctShortStr	-
RegisterValidity	ctDate	-
ApprovalWJ	ctShortStr	-
ApprovalWJValidity	ctDate	-
License	ctShortStr	-
LicenseValidity	ctDate	-
XKZCode	ctShortStr	-
XKZValidity	ctDate	-
ProduceName	ctComment	-
Comment	ctComment	-
BRec	ctInt	-
Prec	ctInt	-
posid	int	-
LicenseHolderName	varchar	-
PLicenseRec	int	-
ProArea	varchar	-

↑ 回到目录

gsp_ypzldaidx (药品质量档案表)

字段名	数据类型	字段说明
bh	varchar	编号
fullname	varchar	商品名称
name	varchar	通用名称
type	varchar	剂型
pinyincode	varchar	拼音码
standard	varchar	规格
UsefulLifeMonth	smallint	有效期月
zlbz	varchar	质量标准
PermitNo	varchar	批准文号
StorageCondition	varchar	存储条件
Area	varchar	生产企业
GMPzsh	varchar	GMP证书号
producexkz	varchar	药品生产许可证号
xkdatelimit	datetime	许可权限至
yyzzh	varchar	营业执照号
syqyshbh	varchar	企业资质审核表号
shdate	datetime	审核日期
sdkcry	varchar	实地考察人员
sypzspbh	varchar	药品资质审批表号
spdate	datetime	药品资质审批日期
spjydate	datetime	首批进货日期
producephone	varchar	生产企业联系电话
cz	varchar	传真
Email	varchar	Email
jdyy	varchar	建档原因及目的
ypbz	varchar	药品包装、标签和说明书规范情况
orderid	int	orderid
pzlb	varchar	品种类别
yyzzValidDate	datetime	-
Prec	ctInt	-
posid	int	-

↑ 回到目录

gspz_bhgypclhz

字段名	数据类型	字段说明
ORDERID	int	-
BH	varchar	-
TJSartRQ	datetime	-
TJEndRQ	datetime	-
jyzpc	numeric	-
bhgzpc	numeric	-
BHGBL	numeric	-
BHGBZZLS	varchar	-
BHGBZZLJE	varchar	-
BHGWGZLS	varchar	-
BHGWGZLJE	varchar	-
BHGNZZLS	varchar	-
BHGNZZLJE	varchar	-
NBGLS	varchar	-
NBGLJE	varchar	-
SHTHS	varchar	-
SHTHJE	varchar	-
YJGGS	varchar	-
YJGGJE	varchar	-
GJS	varchar	-
GJJE	varchar	-
CHECKS	varchar	-
CHECKJE	varchar	-
CCS	varchar	-
CCJE	varchar	-
YHS	varchar	-
YHJE	varchar	-
XSS	varchar	-
XXJE	varchar	-
YSS	varchar	-
YSJE	varchar	-
HZFXJL	varchar	-
ZLGJJY	varchar	-
JLYJ	varchar	-
JLQZRQ	datetime	-
ZLGLBMFZR	varchar	-
TBR	varchar	-
BBRQ	datetime	-
posid	int	-

↑ 回到目录

gspz_pmaintain (库存药品养护)

字段名	数据类型	字段说明
date	datetime	date
ptypeid	varchar	商品Id
pfullname	varchar	商品名称
standard	varchar	规格
qty	numeric	数量
produce	varchar	生产厂家
jobnumber	varchar	批号
factorydate	varchar	有效期至
address	varchar	地址
wanguan	varchar	质量状况
chuliyijian	varchar	处理意见
memo	varchar	备注
orderno	int	顺序号
number	varchar	记录号
IsStop	bit	停售复检
GoodsId	int	GoodsId
OutFactoryDate	varchar	生产日期
ConserveStep	varchar	养护措施
placestock	varchar	存放地点
KtypeId	varchar	仓库ID
Price	numeric	价格
ProviderId	varchar	供货商ID
PtypeSource	tinyint	商品来源
GTypeID	uniqueidentifier	货位ID
StockUniqueid	uniqueidentifier	入库唯一号
OperCostPrice	numeric	OperCostPrice
wgbz	varchar	外观包装(未用)
GermJobNumber	varchar	灭菌批号
jobcode	varchar	批次条码
CheckReportNo	varchar	药监报告号
intime	varchar	入库时间
OrderId	int	OrderId
validDate	varchar	-
xh	ctInt	-
Prec	ctInt	-
GJobID	bigint	-

↑ 回到目录

gspz_pmaintain_sgyhjl (库存养护三个月养护记录)

字段名	数据类型	字段说明
GoodsId	int	GoodsId
ptypeID	varchar	商品ID
jobnumber	varchar	批号
outfactoryDate	datetime	生产日期
Qty	numeric	数量
ValidityPeriod	datetime	有效期至
intime	datetime	入库日期
lastmaintainTime	datetime	上次养护时间
FullName	varchar	商品全名
Standard	varchar	规格
PFullName	varchar	商品名称
Area	varchar	生产厂家
Unit	varchar	单位
type	varchar	剂型
Name	varchar	简称
PermitNo	varchar	批准文号
zdcgbz	char	养护标志z,c
cs	int	次数
xh	int	序号
fpbz	int	季度养护次数序号
yyfcs	int	一个月内养护次数序号
ksyhdate	datetime	开始养护时间
KtypeId	varchar	库存ID
Price	numeric	单价
ProviderId	varchar	供货商ID
PtypeSource	tinyint	商品来源
GTypeID	uniqueidentifier	货位ID
StockUniqueid	uniqueidentifier	入库唯一号
OperCostPrice	numeric	OperCostPrice
JobCode	varchar	批次条码
GermJobNumber	varchar	灭菌批号
CheckReportNo	varchar	药监报告号
yhid	int	-
ifyh	int	-
posid	int	-
Prec	ctInt	-
GJobID	bigint	-

↑ 回到目录

gspz_precheck (GSP商品复检)

字段名	数据类型	字段说明
number	varchar	编号
ptypeid	varchar	商品ID
pfullname	varchar	商品名称
standard	varchar	规格
produce	varchar	产地
jobnumber	varchar	批号
qty	numeric	数量
address	varchar	存放地点
factorydate	varchar	生产日期
quality	varchar	质量问题
keeppeople	varchar	养护员
keepdate	datetime	养护时间
recheckresult	varchar	复检结果
department	varchar	质检人员
recheckdate	datetime	复检日期
orderno	int	单据ID
GoodsId	int	库存商品ID
IsEligible	bit	复检合格标志
ifCheck	bit	审核标志
BillDate	datetime	单据日期
RecheckConclusion	varchar	质量复查结论及处理意见
QlyDept	varchar	质量管理部门
QlyDept_Date	datetime	质量管理部门日期
KtypeId	varchar	仓库ID
Price	numeric	单价
ProviderId	varchar	供应商ID
PtypeSource	tinyint	商品来源
GTypeID	uniqueidentifier	货位ID
StockUniqueid	uniqueidentifier	库存唯一标志
OperCostPrice	numeric	源成本价
GermJobNumber	varchar	灭菌批号
jobcode	varchar	批次条码
CheckReportNo	varchar	药监报告号
validDate	varchar	-
Flag	tinyint	-
QualifiedQty	ctQty	-
Prec	ctInt	-
posid	int	-
GJobID	bigint	-

↑ 回到目录

gspz_pstopsale (药品停售（解除停售）)

字段名	数据类型	字段说明
number	varchar	编号
ptypeid	varchar	商品ID
pfullname	varchar	商品名称
standard	varchar	规格
produce	varchar	产地
unit	varchar	单位
qty	numeric	数量
jobnumber	varchar	批号
checkresult	varchar	质量状况
deal	varchar	处理意见
notifyno	varchar	报告号
notifydate	datetime	报告日期
dateno	varchar	dateno
address	varchar	存放地点
departmente	varchar	质管部门负责人
efullname	varchar	经手人
orderno	int	单据ID
date	datetime	停售日期
KTypeId	varchar	仓库ID
KFullName	varchar	仓库名称
price	money	成本价
GoodsId	int	库存商品ID
BillDate	datetime	单据日期
billtype	int	单据类型
validate	varchar	效期
producedate	datetime	生产日期
stop_id	int	停售ID
ifcheck	bit	审核标志
FjNumber	varchar	复检编号
bhgktypeid	varchar	bhgktypeid
ProviderId	varchar	供应商ID
PtypeSource	tinyint	商品来源
StopType	int	停售类型
GTypeID	uniqueidentifier	货位ID
StockUniqueid	uniqueidentifier	库存唯一号
OperCostPrice	numeric	原成本价
stopuse	int	停售标记
GermJobNumber	varchar	灭菌批号
jobcode	varchar	批次条码
CheckReportNo	varchar	药监报告号
Flag	tinyint	-
Prec	ctInt	-
posid	int	-
GJobID	bigint	-

↑ 回到目录

inigoodsstockstemp

字段名	数据类型	字段说明
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
JobNumber	varchar	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
StockUniqueId	uniqueidentifier	-
JobCode	varchar	-
GermJobNumber	varchar	-
CheckReportNo	varchar	-
ProviderId	ctID	-
PtypeSource	tinyint	-
Qty	ctQty	-
TinyQty	ctQty	-
Price	ctPrice	-
Total	ctTotal	-
GoodsOrder	ctInt	-
StopUse	tinyint	-
intime	ctDate	-
ifcheck	ctBillDate	-
LastMaintainTime	ctDate	-
settlement	tinyint	-
SourceStockID	ctID	-
Type	char	-
GJobID	bigint	-
JobTax	ctTax	-
JObTaxPrice	numeric	-
ORec	ctID	-
lotcustom1	ctShortStr	-
lotcustom2	ctShortStr	-
lotcustom3	ctShortStr	-
lotcustom4	ctShortStr	-
lotcustom5	ctShortStr	-
lotcustom6	ctShortStr	-
lotcustom7	ctShortStr	-
lotcustom8	ctShortStr	-
lotcustom9	ctShortStr	-
lotcustom10	ctShortStr	-
lotcustom11	ctQty	-
lotcustom12	ctQty	-
lotcustom13	ctQty	-
lotcustom14	ctQty	-
lotcustom15	ctQty	-

↑ 回到目录

klocation (货位表)

字段名	数据类型	字段说明
Rec	ctID	货位数字ID
TypeID	ctTypeID	货位字符ID
ParID	ctTypeID	父节点字符ID
UID	uniqueidentifier	UID
leveal	tinyint	当前级别
sonnum	int	当前儿子数
soncount	int	历史儿子数
usercode	ctShortStr	编码
fullname	ctName	名称
comment	ctComment	备注
KRec	ctID	仓库数字ID
deleted	ctbit	删除标志
PYZJM	ctShortStr	拼音助记码
WBZJM	ctShortStr	五笔助记码
IsChecking	ctbit	质检中
Acreage	ctTotal	面积
Cubage	ctTotal	体积
Duty	ctShortStr	负责人
LocationType	tinyint	货位类型
Updatetag	ctInt	Updatetag
POSGREC	int	-
CheckMode	int	-
MaxQty	ctQty	-
BStorage	varchar	-
isstop	int	-
_Md	timestamp	-
KPRec	ctInt	-
StorageCondition	ctShortStr	-
RelationSP	int	-
FromFlag	int	-
isqfbj	int	-

↑ 回到目录

promotionbill

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
PRec	ctID	-
begindate	ctDate	-
enddate	ctDate	-
promotionrate	smallmoney	-
promotionprice	ctPrice	-
begintime	ctDate	-
endtime	ctDate	-
deleflag	tinyint	-
retailprice	ctPrice	-
vippromotionprice	ctPrice	-
billlimitqty	ctInt	-
alllimitqty	ctInt	-
VipQty	ctInt	-
useqty	ctInt	-
timePromotion	bit	-
VipDayLimit	ctInt	-
saleStart	ctTotal	-
dis	ctDiscount	-
less	ctTotal	-
Billlesslimit	ctTotal	-
alllLessTotal	ctTotal	-
saleqty	ctInt	-
saletotal	ctInt	-
sumSaleQty	ctInt	-
SendPRec	ctInt	-
SendUnit	ctInt	-
SendQty	ctInt	-
Sendprice	ctPrice	-
sumsendlimt	ctInt	-
sendretailprice	ctPrice	-
sendtotal	ctTotal	-
SumSendQty	ctInt	-
billalltotal	ctInt	-
Comment	ctShortStr	-
PromotionID	int	-
Unit	ctInt	-
vippromotionrate	ctPrice	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
JobNumberControl	ctShortStr	-
GroupID	ctInt	-
GroupOrd	ctInt	-
dis_object	ctShortStr	-

↑ 回到目录

promotionbillBak

字段名	数据类型	字段说明
BillID	ctID	-
ord	ctInt	-
PRec	ctID	-
begindate	ctDate	-
enddate	ctDate	-
promotionrate	smallmoney	-
promotionprice	ctPrice	-
begintime	ctDate	-
endtime	ctDate	-
deleflag	tinyint	-
retailprice	ctPrice	-
vippromotionprice	ctPrice	-
billlimitqty	ctInt	-
alllimitqty	ctInt	-
VipQty	ctInt	-
useqty	ctInt	-
timePromotion	bit	-
VipDayLimit	ctInt	-
saleStart	ctTotal	-
dis	ctDiscount	-
less	ctTotal	-
Billlesslimit	ctTotal	-
alllLessTotal	ctTotal	-
saleqty	ctInt	-
saletotal	ctInt	-
sumSaleQty	ctInt	-
SendPRec	ctInt	-
SendUnit	ctInt	-
SendQty	ctInt	-
Sendprice	ctPrice	-
sumsendlimt	ctInt	-
sendretailprice	ctPrice	-
sendtotal	ctTotal	-
SumSendQty	ctInt	-
billalltotal	ctInt	-
Comment	ctShortStr	-
PromotionID	int	-
Unit	ctInt	-
vippromotionrate	ctPrice	-
JobNumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
JobNumberControl	ctShortStr	-
GroupID	ctInt	-
GroupOrd	ctInt	-
dis_object	ctShortStr	-

↑ 回到目录

promotionindextemp

字段名	数据类型	字段说明
BillID	int	-
BillDate	ctDate	-
BillCode	ctShortStr	-
BillType	ctInt	-
Comment	ctShortStr	-
KRec	ctInt	-
BillE	ctInt	-
Checke	ctID	-
IfChecked	ctInt	-
Period	ctInt	-
UniqueBillId	uniqueidentifier	-
OfficeId	ctInt	-
BillDetailCount	ctInt	-
BeginDate	ctDate	-
EndDate	ctDate	-
BeginTime	ctDate	-
EndTime	ctDate	-
UseDayType	ctInt	-
DayList	varchar	-
SaleLimittype	ctInt	-
OnePosDayClientlimit	ctInt	-
UseIntegral	ctID	-
UseCommpirce	ctInt	-
deleflag	ctInt	-
ERec	ctInt	-
Auditingdate	ctDate	-
vipUse	ctInt	-
UseDis	ctInt	-
UseVipPrice	ctInt	-
cycle	ctInt	-
BaseType	ctInt	-
tjcx	ctInt	-
BillStatus	tinyint	-
VipDayInter	ctbit	-
billtotal	ctTotal	-
PromotionName	ctShortStr	-
ComTotal	ctTotal	-
Lesstotal	ctTotal	-
SendPRec	ctInt	-
ComType	ctInt	-
SendQty	ctQty	-
SendPrice	ctPrice	-
SendLimitQty	ctQty	-
SendTotalQty	ctQty	-
ljcx	int	-
BillExplain	ctComment	-
ProType	ctInt	-
ProLimit	ctInt	-
DiscountType	ctInt	-
CommodityType	ctInt	-
AgeLowerLimit	ctInt	-
AgeUpperLimit	ctInt	-
Days	ctInt	-
SendCheck	ctInt	-
lscx	ctInt	-
AutoSend	ctInt	-
TerminateDate	ctDate	-
PresentType	ctInt	-
dispose	ctInt	-
lunar	ctInt	-
DiscountMode	ctInt	-
VipPointsLow	int	-
VipPointsUp	int	-
VipSendDate	int	-
VipSendLow	ctDate	-
VipSendUp	ctDate	-
VipUseVipPriceCX	tinyint	-
AfterBuyUseDaysCalc	tinyint	-
NolAllowShopCard	tinyint	-
OtherBillOverlyingUse	tinyint	-
MultFullIFExec	ctInt	-
XFFMode	tinyint	-
GiveNumber	ctInt	-
EachBillLimitShopQty	ctInt	-
PayMoneyCalc	ctInt	-
CashType	ctID	-
PresentControlMode	int	-
ProVipMode	int	-

↑ 回到目录

ptype (商品字典表)

字段名	数据类型	字段说明
Rec	ctID	药品数字id
typeId	ctTypeID	药品字符id
ParId	ctTypeID	父ID
leveal	tinyint	当前级别
sonnum	int	当前儿子数
soncount	int	历史儿子数
UserCode	ctShortStr	药品编码
FullName	ctName	药品全称
Name	ctName	药品简称
Standard	varchar	规格
Type	ctShortStr	型号
PermitNo	varchar	批准文号
Unit1	ctShortStr	小单位
Unit2	ctShortStr	大单位
UnitRate1	smallmoney	单位换算比率(大单位/小单位)
UsefulLifeMonth	smallint	有效月数
UsefulLifeDay	smallint	有效天数
Comment	ctComment	备注
deleted	ctbit	是否删除
TradeMark	ctShortStr	商标
BatchStdPrice	ctPrice	国家指导批发价
RetailStdPrice	ctPrice	国家指导零售价
BarCode	ctShortStr	条码
PYZJM	ctShortStr	拼音助记码
WBZJM	ctShortStr	五笔助记码
Firstcheck	tinyint	是否首营药品
KindOfQlyCheck	int	GSP验收属性
E_Name	ctMidStr	英文名称
Tinyprice	ctPrice	拆零价格
recprice	ctPrice	最近进价
D_Std	ctMidStr	装箱量
if_tiny	bit	是否拆零商品
TinyUnit	varchar	拆零单位
TinyRate	int	拆零比率
StorageCondition	ctShortStr	储藏条件
ChymistryName	ctName	化学名称
ChymistryPY	varchar	化学名拼音码
NamePY	ctShortStr	通用名拼音码
classify	ctShortStr	药品类别
PtypeClassid	int	药品分类
Conserve	tinyint	养护方式
ProArea	ctName	产地
proareaPY	ctShortStr	产地拼音码
UID	ctUID	唯一标志
TypeStatus	varchar	药品性状
Status	tinyint	是否合并药品
Counter	int	最大编号
_Md	timestamp	传输同步标志
ltax	ctTax	税率
tcway	ctName	提成公式
SS_DM	ctShortStr	-
SS_Status	ctbit	医保状态
StopSale	int	销售停止
SafeStockDays	smallint	安全在库天数
UseWay	ctComment	用法
UseNum	varchar	用量
AddDate	ctDate	添加日期
EditDate	ctDate	修改日期
ValDateType	ctbit	有效期至格式
PermitNoPeriod	ctDate	-
Flags	bigint	标志
Updatetag	ctInt	Updatetag
RowIndex	varchar	默然排序编号
CostType	ctbit	价格方式
CommRetailPriceLimit	ctInt	-
FImage	ctInt	-
GMPCode	ctShortStr	-
GMPPeriod	ctDate	-
POutStockLaw	char	-
RX	tinyint	-
ValidityDays	ctInt	-
Area	int	生产厂商
unit3	ctShortStr	-
unitrate2	smallmoney	-
DefaultSupplier	ctInt	-
QXClass	ctInt	-
QXType	ctInt	-
Color	ctInt	-
TranTimeLimit	ctInt	-
ChangeID	ctID	-
BeforeStopDays	int	-
Ingredient	varchar	-
MZSFtype	varchar	-
WebUniCode	ctShortStr	-
FirstBuyDate	ctDate	-
LicenseHolder	int	-
EditOper	varchar	-
StandardCode	ctMidStr	-
Indications	varchar	-
SERVICE	ctbit	-
YLProject	ctbit	-
IsRx	ctbit	-
SendCostRate	ctDiscount	-
IsFourtypes	ctbit	-
TaxCode	varchar	-
JGMType	ctInt	-

↑ 回到目录

ptypeUDI

字段名	数据类型	字段说明
UDI	varchar	-
MinimuMmark	varchar	-
CodeType	varchar	-
MinimumUseNumber	int	-
UseUnitMark	varchar	-
MarkReleaseDate	datetime	-
IsDirectMark	int	-
IsBodyAndMinimumMark	int	-
BodyMark	varchar	-
ProduceName	varchar	-
TradeName	varchar	-
StandardModel	varchar	-
IsPackage	int	-
ProduceDescribe	varchar	-
ArticlenNmber	varchar	-
Category	varchar	-
OldClassCode	varchar	-
NewClassCode	varchar	-
RegistrantName	varchar	-
SocialCreditCode	varchar	-
RegistrantEnglistName	varchar	-
RegistrantCode	varchar	-
ProductCategory	varchar	-
IsOneOff	int	-
MaxReuseTimes	int	-
IsSterilization	int	-
IsSterilizationBeforeUse	int	-
SterilizationType	varchar	-
Url	varchar	-
InsuranceCode	varchar	-
IsContainJobNumber	int	-
IsContainSerialNumber	int	-
IsContainOutFactoryDate	int	-
IsContainValidityPeriod	int	-
SpecialStorageConditions	varchar	-
specialSize	varchar	-
Version	varchar	-
VersionPubDate	datetime	-
addtime	datetime	-
edittime	datetime	-

↑ 回到目录

t_ModifyPriceMX

字段名	数据类型	字段说明
BillID	ctID	-
sourcebillid	ctID	-
sourceOrd	int	-
PRec	ctID	-
KRec	ctID	-
GRec	ctID	-
Qty	ctQty	-
AssQty	ctQty	-
costprice	ctPrice	-
SalePrice	ctPrice	-
newSalePrice	ctPrice	-
AssSalePrice	ctPrice	-
newAssSalePrice	ctPrice	-
discount	ctDiscount	-
newdiscount	ctDiscount	-
DiscountPrice	ctPrice	-
newDiscountPrice	ctPrice	-
AssDiscountPrice	ctPrice	-
newAssDiscountPrice	ctPrice	-
total	ctTotal	-
newtotal	ctTotal	-
tax	ctTax	-
newtax	ctTax	-
TaxPrice	ctPrice	-
newTaxPrice	ctPrice	-
AssTaxPrice	ctPrice	-
newAssTaxPrice	ctPrice	-
TaxTotal	ctTotal	-
newTaxTotal	ctTotal	-
jobnumber	ctShortStr	-
OutFactoryDate	ctDate	-
ValidityPeriod	ctDate	-
comment	ctComment	-
unit	tinyint	-
UnitRate	smallmoney	-
ProviderId	ctID	-
PtypeSource	tinyint	-
StockUniqueid	ctUID	-
JobCode	ctShortStr	-
GermJobNumber	ctShortStr	-
CheckReportNo	ctShortStr	-
PriceType	tinyint	-
GJobid	bigint	-
NewGJobid	bigint	-
beforetotal	ctPrice	-
Newbeforetotal	ctPrice	-
newpricetype	tinyint	-

↑ 回到目录

tmp_Comm_StockChangeRep

字段名	数据类型	字段说明
ptypeid	ctTypeID	-
sonnum	int	-
parid	ctTypeID	-
RowIndex	varchar	-
saleqty	numeric	-
saletotal	money	-
buyqty	numeric	-
buytotal	money	-
buybackqty	numeric	-
buybacktotal	money	-
salebackqty	numeric	-
salebacktotal	money	-
loseckqty	numeric	-
losecktotal	money	-
overflowrkqty	numeric	-
overflowrktotal	money	-
tjdbrkqty	numeric	-
tjdbckqty	numeric	-
tjdbrktotal	money	-
tjdbcktotal	money	-
bjdbrkqty	numeric	-
bjdbckqty	numeric	-
bjdbrktotal	money	-
bjdbcktotal	money	-
qtrkqty	numeric	-
qtckqty	numeric	-
qtrktotal	money	-
qtcktotal	money	-
bqckqty	numeric	-
bqcktotal	money	-
bqrkqty	numeric	-
bqrktotal	money	-
sqcQty	numeric	-
bqcQty	numeric	-
sqcTotal	money	-
bqcTotal	money	-
saleCosttotal	money	-
salebackCosttotal	money	-
SendQty	numeric	-
SendCostTotal	money	-
SendTotal	money	-
SendBackQty	numeric	-
SendBackCosttotal	money	-
SendBackTotal	money	-
PosReceiveQty	numeric	-
PosReceiveCostTotal	money	-
PosbackQty	numeric	-
PosBackCostTotal	money	-
SaleProfit	money	-
SaleBackProfit	money	-
SendProfit	money	-
SendBackProfit	money	-
CombineSplitInQty	numeric	-
CombineSplitInTotal	money	-
CombineSplitOutQty	numeric	-
CombineSplitOutTotal	money	-
PresentedQty	numeric	-
PresentedTotal	money	-
PresentQty	numeric	-
PresentTotal	money	-
GUID	varchar	-
sqctaxTotal	money	-
bqctaxTotal	money	-
buytaxcosttotal	money	-
salebacktaxCosttotal	money	-
salebacktaxtotal	money	-
SaleBacktaxProfit	money	-
PosReceivetaxCostTotal	money	-
SendBacktaxcosttotal	money	-
SendBacktaxProfit	money	-
overflowrktaxcosttotal	money	-
PresentedtaxcostTotal	money	-
tjdbrktaxcosttotal	money	-
bjdbrktaxcosttotal	money	-
qtrktaxcosttotal	money	-
bqrktaxcosttotal	money	-
saletaxCosttotal	money	-
SaletaxProfit	money	-
buybacktaxcosttotal	money	-
SendtaxCostTotal	money	-
SendtaxProfit	money	-
PosBacktaxCostTotal	money	-
PresenttaxcostTotal	money	-
CombineSplitOuttaxcostTotal	money	-
losecktaxcosttotal	money	-
tjdbcktaxcosttotal	money	-
bjdbcktaxcosttotal	money	-
qtcktaxcosttotal	money	-
bqcktaxcosttotal	money	-
hzrkqty	numeric	-
hzrktotal	money	-
hzckqty	numeric	-
hzcktotal	money	-

↑ 回到目录

vipcardtemp

字段名	数据类型	字段说明
CardNo	varchar	-
Name	ctName	-
Tel	ctShortStr	-
Address	ctShortStr	-
Comment	ctComment	-
CardType	ctInt	-
Discount	smallint	-
BulidDate	ctDate	-
ValidityDate	ctDate	-
Lose	ctbit	-
StopUse	ctbit	-
BuyTotal	ctTotal	-
BuyTotalPerDay	ctTotal	-
AutoDiscount	ctbit	-
membertotal	ctTotal	-
automembertotal	ctInt	-
cardid	ctUID	-
sex	ctbit	-
Birthday	ctDate	-
IdentityCard	ctShortStr	-
E-Mail	ctShortStr	-
MediFeedback	ctMidStr	-
Case	ctMidStr	-
AutoIntegral	ctbit	-
AutoOneoff	ctbit	-
IntegralTotal	ctTotal	-
RemainTotal	ctTotal	-
Deleted	ctbit	-
PYZJM	ctShortStr	-
CzTotal	ctTotal	-
Cz	ctTotal	-
UsePass	ctbit	-
Password	ctShortStr	-
VipCz	ctbit	-
Cz00	ctTotal	-
PosId	int	-
ljIntegral	ctTotal	-
ChangeIntegral	ctTotal	-
UsedCount	ctInt	-
brec	ctInt	-
IsLife	ctbit	-
giftTotal	numeric	-
giftTotal00	numeric	-
VIPBarCode	varchar	-
JSVIPCardID	int	-
JSNum	int	-
IsJSReward	bit	-
ERec	int	-
JSIntegralTotal	numeric	-
OfferIntegralTotal	numeric	-
Weight	numeric	-
BloodType	varchar	-
Marriage	varchar	-
Flags	bigint	-
BulidPosID	ctInt	-
C0	ctComment	-
C1	ctComment	-
C2	ctComment	-
C3	ctComment	-
C4	ctComment	-
C5	ctComment	-
C6	ctComment	-
C7	ctComment	-
C8	ctComment	-
C9	ctComment	-
C10	ctComment	-
C11	ctComment	-
C12	ctComment	-
C13	ctComment	-
C14	ctComment	-
C15	ctComment	-
C16	ctComment	-
C17	ctComment	-
C18	ctComment	-
C19	ctComment	-
C20	varchar	-
C21	varchar	-
C22	varchar	-
C23	varchar	-
C24	varchar	-
C25	varchar	-
C26	varchar	-
C27	varchar	-
C28	varchar	-
C29	varchar	-
C30	varchar	-
C31	varchar	-
C32	varchar	-
C33	varchar	-
C34	varchar	-
C35	varchar	-
C36	varchar	-
C37	varchar	-
C38	varchar	-
C39	varchar	-
C40	varchar	-
C41	varchar	-
C42	varchar	-
C43	varchar	-
C44	varchar	-
C45	varchar	-
C46	varchar	-
C47	varchar	-
C48	varchar	-
C49	varchar	-
ID	int	-
EditFlag	int	-

↑ 回到目录

vipcardtrantemp

字段名	数据类型	字段说明
CardNo	varchar	-
Name	ctName	-
Tel	ctShortStr	-
Address	ctShortStr	-
Comment	ctComment	-
CardType	ctInt	-
Discount	smallint	-
BulidDate	ctDate	-
ValidityDate	ctDate	-
Lose	ctbit	-
StopUse	ctbit	-
BuyTotal	ctTotal	-
BuyTotalPerDay	ctTotal	-
AutoDiscount	ctbit	-
membertotal	ctTotal	-
automembertotal	ctInt	-
cardid	ctUID	-
sex	ctbit	-
Birthday	ctDate	-
IdentityCard	ctShortStr	-
email	ctShortStr	-
MediFeedback	ctMidStr	-
ACase	ctMidStr	-
AutoIntegral	ctbit	-
AutoOneoff	ctbit	-
IntegralTotal	ctTotal	-
RemainTotal	ctTotal	-
Deleted	ctbit	-
PYZJM	ctShortStr	-
CzTotal	ctTotal	-
Cz	ctTotal	-
UsePass	ctbit	-
APassword	ctShortStr	-
VipCz	ctbit	-
Cz00	ctTotal	-
PosId	int	-
ljIntegral	ctTotal	-
ChangeIntegral	ctTotal	-
UsedCount	ctInt	-
brec	ctInt	-
IsLife	ctbit	-
giftTotal	numeric	-
giftTotal00	numeric	-
VIPBarCode	varchar	-
JSVIPCardID	int	-
JSNum	int	-
IsJSReward	bit	-
ERec	int	-
JSIntegralTotal	numeric	-
OfferIntegralTotal	numeric	-
Weight	numeric	-
BloodType	varchar	-
Marriage	varchar	-
Flags	bigint	-
BulidPosID	ctInt	-
C0	ctComment	-
C1	ctComment	-
C2	ctComment	-
C3	ctComment	-
C4	ctComment	-
C5	ctComment	-
C6	ctComment	-
C7	ctComment	-
C8	ctComment	-
C9	ctComment	-
C10	ctComment	-
C11	ctComment	-
C12	ctComment	-
C13	ctComment	-
C14	ctComment	-
C15	ctComment	-
C16	ctComment	-
C17	ctComment	-
C18	ctComment	-
C19	ctComment	-
C20	varchar	-
C21	varchar	-
C22	varchar	-
C23	varchar	-
C24	varchar	-
C25	varchar	-
C26	varchar	-
C27	varchar	-
C28	varchar	-
C29	varchar	-
C30	varchar	-
C31	varchar	-
C32	varchar	-
C33	varchar	-
C34	varchar	-
C35	varchar	-
C36	varchar	-
C37	varchar	-
C38	varchar	-
C39	varchar	-
C40	varchar	-
C41	varchar	-
C42	varchar	-
C43	varchar	-
C44	varchar	-
C45	varchar	-
C46	varchar	-
C47	varchar	-
C48	varchar	-
C49	varchar	-
IntegralTotal00	numeric	-
LastConsumeDate	ctDate	-
ID	int	-
EditFlag	int	-

↑ 回到目录

viptypetemp

字段名	数据类型	字段说明
TypeName	ctShortStr	-
Discount	ctDiscount	-
Comment	ctComment	-
AutoDiscount	ctbit	-
CanAllPos	ctbit	-
CanUseRemainTotal	ctbit	-
ChangeIntegralPos	ctInt	-
UseVipDay	ctInt	-
DayList	ctMidStr	-
UseDisAndVipPrice	ctbit	-
XIntegral	ctTotal	-
IsSaleLimit	bit	-
automembertotal	bit	-
IfVipPrice	bit	-
vipPriceType	int	-
IfVipPriceDisCount	bit	-
AutoIntegral	bit	-
IfPromotionPriceDisCount	bit	-
UsePtypeDisCount	bit	-
EsPriceNotIntegral	bit	-
vipdayDisCount	int	-
usebirthday	int	-
UseIntegral	ctInt	-
UseVipPrice	ctbit	-
BirthdyDisCount	ctInt	-
BirthdyXIntegral	ctTotal	-
BirthdyMontyDisCount	ctInt	-
BirthdyMonthXIntegral	ctTotal	-
MonthDayList	ctMidStr	-
RepeatNum	int	-
IsOnlyJS	bit	-
IsCZPreferential	bit	-
IsIntroduceJS	bit	-
IntroduceJSLimitNum	int	-
IntroducerJS	numeric	-
NewMemberJS	numeric	-
IntroducerJSPer	numeric	-
LimitDays	int	-
WeekVIPDayDisCount	ctInt	-
WeekVIPDayXIntegral	ctTotal	-
WeekVIPDayUseVipPrice	ctbit	-
WeekVIPDayUseDis	ctbit	-
WeekVIPDayUseIntegral	ctbit	-
VIPDayOrder	tinyint	-
NotVIPDayFlags	int	-
VIPDayFlags	int	-
color	ctShortStr	-
ValidType	ctInt	-
ValidDate	ctShortStr	-
IntegralCash	bit	-
IntegralThan	ctInt	-
CostMoneyThan	ctTotal	-
PerIntegral	ctInt	-
ServeMoney	ctTotal	-
ServePercent	ctTotal	-
IntegralServeRule	tinyint	-
CTypeId	int	-

↑ 回到目录

字段名	数据类型	字段说明
AutoID	int	-
DownID	int	-
DownTime	datetime	-
Create_Sqlstr	text	-
Android_Number	nvarchar	-
IsZip	int	-
Create_TableName	nvarchar	-
Conn_DataBase	nvarchar	-
Remark	nvarchar	-
IsType	int	-
Create_Sqlstr1	text	-
Create_Sqlstr2	text	-
Create_Sqlstr3	text	-
Create_Sqlstr4	text	-

字段名	数据类型	字段说明
AutoID	int	-
BillName	nvarchar	-
Bill_Number	nvarchar	-
System_Number	nvarchar	-
Upload_Time	datetime	-
Upload_User	nvarchar	-
Upload_Number	int	-
Android_Number	nvarchar	-
IsAutoUpData	bit	-
MasterJson	text	-

字段名	数据类型	字段说明
ID	int	-
ControlName	varchar	-
Attribute	varchar	-
CreateDate	datetime	-
DisplayName	nvarchar	-
DisplayControl	varchar	-

字段名	数据类型	字段说明
ID	int	-
KeyName	varchar	-
sql	varchar	-
comment	varchar	-
LastRunTime	datetime	-
priority	int	-
Flag	int	-
Enabled	int	-
Interval	int	-

字段名	数据类型	字段说明
ID	int	-
Spid	int	-
StartTime	datetime	-
EndTime	datetime	-
TableName	varchar	-
SrcBefore	int	-
DestBefore	int	-
SrcAfter	int	-
DestAfter	int	-
DealResult	int	-

字段名	数据类型	字段说明
ID	ctID	ID
BasicType	ctID	-
CertType	ctID	证照类型
BasicID	ctID	基本信息Rec
CertID	ctID	对应证照明细id
ChangeID	ctInt	-

字段名	数据类型	字段说明
ID	int	-
Mode	int	-
SartDay	int	-
EndDay	int	-
Comment	varchar	-
iColor	varchar	-

字段名	数据类型	字段说明
BillID	int	-
InPutNO	int	-
InPutRec1	ctID	-
InPutRec2	ctID	-
InPutRec3	ctID	-
InPutRec4	ctID	-
InPutRec5	ctID	-

字段名	数据类型	字段说明
PrintID	ctInt	-
UniqueBillid	ctUID	-
PrintOrder	smallint	-
PrintDate	ctDate	-
Printer	ctID	-
BillType	smallint	-
PrintReason	ctMidStr	-

字段名	数据类型	字段说明
_ID	int	-
ApprovalCode	varchar	-
ApprovalDate	ctBillDate	-
UniqueBillid	uniqueidentifier	-
BillCode	ctShortStr	-
BillType	int	-
BillDate	ctBillDate	-
BillEname	varchar	-
EFullName	varchar	-
totalmoney	ctTotal	-
BillRedReason	ctComment	-
Comment	ctComment	-
Applyer	varchar	-
QualityExplain	ctComment	-
Checker	varchar	-
CheckDate	ctBillDate	-
ifChecked	tinyint	-
CheckMind	ctbit	-
posid	int	-

字段名	数据类型	字段说明
SBillType	ctInt	源单据type
NBillType	ctInt	新单据type
TFlag	ctInt	TFlag
PriceType	ctInt	价格方式
PricePlus	float	价格倍数
deleted	int	删除标志
Auto	int	自动标志
Color	int	灰色标志

字段名	数据类型	字段说明
billtype	int	单据类型号
Version	int	版本
billName	ctShortStr	单据类型名
orderNo	int	序号
UpdateTag	ctInt	更新标志
TableName	ctShortStr	表名称
parid	int	-
CanModfyprice	int	-

字段名	数据类型	字段说明
ProjectType	int	企业类型
IsYLQX	int	是否是医疗器械版本
CertTypeID	int	Certype表中id号

字段名	数据类型	字段说明
ID	ctInt	委托书id
PtypeClassID	ctInt	商品类别id
LARec	int	经营范围类型

字段名	数据类型	字段说明
ID	int	-
CategoryName	varchar	-
Procedure	varchar	-
CreateDate	datetime	-
Display	bit	-
Order	int	-

字段名	数据类型	字段说明
ID	int	-
CategoryID	int	-
WhereCondition	varchar	-
Order	int	-
CreateTime	datetime	-

字段名	数据类型	字段说明
CategoryID	int	-
SubID	int	-
CreateDate	datetime	-
Flag	int	-

字段名	数据类型	字段说明
ID	ctID	证照类型ID
Name	ctName	证照名称
Flag	ctbit	删除标志等
Deleted	ctbit	是否可用
TableName	ctShortStr	存储的表名
SPName	ctShortStr	保存数据的存储过程名称
Images	ctInt	允许的图片数
Limit	int	权限
IsAlter	ctbit	是否有效期报警
AlterFiledName	ctShortStr	报警字段名
AlterQueryFields	ctMidStr	证照报警显示的证照信息
AlterQueryNames	ctMidStr	报警显示证照名称
IssueDateName	ctShortStr	发证日期字段名称
NotThisCert	bit	-

字段名	数据类型	字段说明
CheckID	int	盘点ID
PRec	int	商品
JobNumber	varchar	批号
OutFactoryDate	datetime	出厂日期
ValidityPeriod	datetime	有效期
Checkqty	numeric	盘点数量
Ord	int	行号
Unit	varchar	单位
Rate	smallmoney	比率
TinyFlag	tinyint	拆零标志
JobCode	varchar	药品监管码
StopUse	int	停售标志
RetailPrice	numeric	零售单价
CostPrice	numeric	成本单价
GermJobNumber	varchar	灭菌批号
CheckReportNo	varchar	药监报告号
GJobID	bigint	-

字段名	数据类型	字段说明
CheckID	int	盘点ID
InputDate	datetime	录入日期
CheckCode	varchar	盘点编号
KRec	int	仓库
GRec	int	货位
CheckE	int	盘点人
BillE	int	制单人
IfAuditing	bit	审核标志
AuditingE	int	审核人
AuditingDate	datetime	审核日期
Comment	varchar	备注
HasCreateCheck	bit	统计标志
StatID	int	统计ID
CheckMode	ctInt	-

千方百剂数据库数据字典

目录索引

ABCSet

AccountInterFace

AccountYearCfg

AdDebtBill

AdDebtBill_His

AdPriceBill (库存成本调价单)

AdPriceCommissionBill

AdjustJobNumberBill

AdjustPriceD

AdjustPriceM

AdjustPricePos

AinterFace (会计科目对照表)

Alibaba_Alihealth_DrugTrace_Contrast

AllotGtypeTemp

Android_FTP_CreateTable_List

Android_FTP_DataFile_List

Android_FTP_NumberList

Android_FTP_Task

Android_Uploaded_List

ArchivesCodeConfig (基本信息编号设置)

Area (片区信息表)

AttendanceManage

Attributes

Atype (会计科目表)

AtypeMonth

AtypeTemp

AutoCXBSet

AutoOutStockTime

AutoRunSqlTable

AutoSumEveryDayStock

AutoSumTable

AutoSumYMDReport

AutoZNBH

AutoZNBHBak

BQDYData

BQDYIndex

BSTEST

BS_SaleBillType

BS_SaleRange

BTYPEAttorney (单位法人授权委托书)

BTYPEAttorneyPtype (法人授权委托书商品列表(允许/禁止))

BTypeARAPJS

BTypePrice (往来单位进价跟踪)

B_NoNeedCertList

BackTableToHisLog

BaiscCustomUpDateDetail

BaiscCustomUpDateSet

BaseCustomFields (基本信息自定义字段表)

BaseNameChange (基本信息名称变化记录表)

BaseProduct

BaseTemp

BasicCert (证照信息记录表)

BasicCertType (基本信息证照类型对照表)

BasicCerttemp

BasicCerttypeTemp

BasicInfoConfig

BatchColorConfig

BatchUpdatePtypeTmp

BillAuditFlow

BillCustomFields (单据自定义表)

BillGroupNO

BillIndex (单据索引表)

BillIndex_HIS

BillIndex_PayInfo_Name

BillIndex_Sum_YMDReport

BillIndexhis (单据索引表2)

BillOutTable (单据出库表)

BillPayInfo

BillPayInfo_His

BillPriceItem (单据价格项设置)

BillPrintReason

BillPrintRecord

BillRedApproval

BillTransferSet (单据自动转换设置表)

BillType (单据类型表)

BillTypeGSP

BillindexBak

BtypeCertTypeSet (企业类型及证照设置表)

字段名	数据类型	字段说明
ID	int	ID
StatDate	datetime	统计日期
KRec	int	仓库
GRec	int	货位
BillE	varchar	制单人
CheckMode	int	-
Gtype	int	-
KPRec	int	-

字段名	数据类型	字段说明
ID	ctInt	-
MAction	ctName	-
Caption	ctName	-
MedVersion	int	-
status	ctInt	-
RegisterCompany	ctShortStr	-
Dog	ctShortStr	-

字段名	数据类型	字段说明
BillID	int	-
PosID	int	-
PosCheckE	int	-
BillCode	varchar	-
BillDate	datetime	-
ERec	int	-
Comment	varchar	-
DELETED	int	-

字段名	数据类型	字段说明
ID	int	-
ControlType	int	-
ControlPoint	varchar	-
isControl	bit	-

字段名	数据类型	字段说明
AffID	varchar	-
AuthorID	varchar	-
SubJect	varchar	-
CreateDate	varchar	-
deleted	int	-
_md	timestamp	-

字段名	数据类型	字段说明
calid	int	-
createid	varchar	-
createdate	varchar	-
subject	varchar	-
warndate	varchar	-
warnflag	int	-
Deleted	int	-

字段名	数据类型	字段说明
ClientTypeID	int	索引DD
TypeName	varchar	类型名称
deleted	int	删除标志

字段名	数据类型	字段说明
LinkID	int	-
name	varchar	-
UserCode	varchar	-
birthday	varchar	-
duty	varchar	-
diploma	varchar	-
ClientID	int	-
telPhone	varchar	-
moPhone	varchar	-
Fax	varchar	-
createid	varchar	-
createdate	varchar	-
sex	varchar	-
DepartMent	varchar	-
address	varchar	-
post	varchar	-
email	varchar	-
Comment	varchar	-
deleted	int	-

字段名	数据类型	字段说明
ID	ctInt	-
PageIndex	int	-
ImgOn	ctShortStr	-
ImgDown	ctShortStr	-
MAction	ctName	-
Caption	ctName	-
ViewCaption	ctName	-
Sort	ctInt	-
MedVersion	int	-
Visible	ctbit	-

字段名	数据类型	字段说明
ID	int	ID
IDFlag	int	对应基本信息
ColID	tinyint	列宽
Name	varchar	名称
DataType	smallint	数据类型
InputType	int	是否输入
DataLen	smallint	数据长度
CommandText	varchar	备注
FieldsId	smallint	字段ID
OldColID	ctInt	-