T_CRM_COMPETITOR[T_CRM_COMPETITOR]
主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
---|---|---|---|---|---|---|---|
✓ | FID | FID | int | ||||
FMasterId | FMasterId | int | |||||
FNUMBER | FNUMBER | nvarchar | 255 | ||||
FCOUNTRY | FCOUNTRY | varchar | 36 | ||||
FPROVINCIAL | FPROVINCIAL | varchar | 36 | ||||
FWEBSITE | FWEBSITE | nvarchar | 255 | ||||
FDOCUMENTSTATUS | FDOCUMENTSTATUS | varchar | 1 | ||||
FFORBIDSTATUS | FFORBIDSTATUS | varchar | 1 | ||||
FCREATEORGID | FCREATEORGID | int | ~(0)~ | ||||
FUSEORGID | FUSEORGID | int | ~(0)~ | ||||
FCREATORID | FCREATORID | int | ~(0)~ | ||||
FMODIFIERID | FMODIFIERID | int | ~(0)~ | ||||
FCREATEDATE | FCREATEDATE | datetime | ✓ | ||||
FMODIFYDATE | FMODIFYDATE | datetime | ✓ | ||||
FSIGNDATE | FSIGNDATE | datetime | ✓ | ||||
FCOMPANYCLASSIFY | FCOMPANYCLASSIFY | varchar | 36 | ||||
FTEXT4 | FTEXT4 | nvarchar | 255 | ||||
FCOMPANYNATURE | FCOMPANYNATURE | varchar | 36 | ||||
FCOMBO | FCOMBO | varchar | 20 | ||||
FCOMPANYSCALE | FCOMPANYSCALE | varchar | 36 | ||||
FTEXT52 | FTEXT52 | nvarchar | 255 | ||||
FTEXT5 | FTEXT5 | nvarchar | 255 | ||||
FTEXT51 | FTEXT51 | nvarchar | 255 | ||||
FSINGER | FSINGER | int | ~(0)~ | ||||
FFORBIDER | FFORBIDER | int | ~(0)~ | ||||
FFORBIDDATE | FFORBIDDATE | datetime | ✓ | ||||
FADVANTAGEMEMO | FADVANTAGEMEMO | nvarchar | 255 | ||||
FMAINPRODUCT | FMAINPRODUCT | nvarchar | 255 | ||||
FMAINCUST | FMAINCUST | nvarchar | 255 | ||||
FADDRESS | FADDRESS | nvarchar | 255 | ||||
FLEVEL | FLEVEL | varchar | 20 |
T_CRM_COMPETITOR_L[T_CRM_COMPETITOR_L...]
主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
---|---|---|---|---|---|---|---|
✓ | FPKID | FPKID | int | ||||
FID | FID | int | |||||
FLocaleID | FLocaleID | int | |||||
FNAME | FNAME | nvarchar | 255 | ||||
FDESCRIPTION | FDESCRIPTION | nvarchar | 255 | ||||
备注: T_CRM_COMPETITOR_L |
T_CRM_COMPRODUCT[T_CRM_COMPRODUCT]
主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
---|---|---|---|---|---|---|---|
✓ | FID | FID | int | ||||
FNUMBER | FNUMBER | nvarchar | 30 | ||||
FDOCUMENTSTATUS | FDOCUMENTSTATUS | varchar | 1 | ||||
FFORBIDSTATUS | FFORBIDSTATUS | varchar | 1 | ||||
FMODIFIERID | FMODIFIERID | int | ~(0)~ | ||||
FCREATORID | FCREATORID | int | ~(0)~ | ||||
FCREATEDATE | FCREATEDATE | datetime | ✓ | ||||
FMODIFYDATE | FMODIFYDATE | datetime | ✓ | ||||
FCOMPETITOR | FCOMPETITOR | int | ~(0)~ | ||||
FPRONO | FPRONO | nvarchar | 50 | ||||
FPRICELOWWERLIMIT | FPRICELOWWERLIMIT | nvarchar | 50 | ||||
FPRICEUPPERLIMIT | FPRICEUPPERLIMIT | nvarchar | 50 | ||||
FPRODUCTTYPE | FPRODUCTTYPE | nvarchar | 50 | ||||
FORBIDER | FORBIDER | int | ~(0)~ | ||||
FFORBIDERDATE | FFORBIDERDATE | datetime | ✓ | ||||
FMARKETPERCENT | FMARKETPERCENT | decimal | 23,10 | ~(0)~ |
T_CRM_COMPRODUCT_L[T_CRM_COMPRODUCT_L...]
主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
---|---|---|---|---|---|---|---|
✓ | FPKID | FPKID | int | ||||
FID | FID | int | |||||
FLocaleID | FLocaleID | int | |||||
FNAME | FNAME | nvarchar | 50 | ||||
FDESCRIPTION | FDESCRIPTION | nvarchar | 255 | ||||
备注: T_CRM_COMPRODUCT_L |