往来单位实体表
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| priuserdefdecm5 (T+16.0) | 数值自定义项5 | decimal | 13 | True | |
| priuserdefdecm4 (T+16.0) | 数值自定义项4 | decimal | 13 | True | |
| SellCustomer (T+16.0) | 零售客户 | tinyint | 1 | True | |
| priuserdefnvc5 (T+16.0) | 字符专用自定义项5 | nvarchar | 1000 | True | |
| taxRegcode (T+16.0) | 纳税号 | nvarchar | 100 | True | |
| IsNeedCompetitorPhoto (T+16.0) | 竞品拍照 | tinyint | 1 | True | |
| idsaleman (T+16.0) | 分管人员id | int | 4 | True | |
| Changer (T+16.0) | 修改人 | nvarchar | 400 | True | |
| representative (T+16.0) | 法人代表 | nvarchar | 100 | True | |
| CheckInScope (T+16.0) | 有效签到范围 | decimal | 17 | True | |
| CustomerAddress (T+16.0) | 客户地址 | nvarchar | 400 | True | |
| TelephoneNo (T+16.0) | 联系电话 | nvarchar | 200 | True | |
| VisitFrequency (T+16.0) | 拜访频度 | decimal | 17 | True | |
| saleCheckDate (T+16.0) | 销售结帐日 | int | 4 | True | |
| ElectronicInvoiceReceiveMobilePhone (T+16.0) | 接收手机号 | nvarchar | 100 | True | |
| saleSettleStyle (T+16.0) | 销售收款方式 | int | 4 | True | |
| MsnAddress (T+16.0) | MSN地址 | nvarchar | 100 | True | |
| saleSpaceMonth (T+16.0) | 销售对帐区间间隔月 | int | 4 | True | |
| customeraddressphone (T+16.0) | 客户地址电话 | nvarchar | 500 | True | |
| HasEverChanged (T+16.0) | 编码是否手工修改过 | nvarchar | 64 | True | |
| Route (T+16.0) | 路线 | nvarchar | 1000 | True | |
| eAccount (T+16.0) | 电商账号 | varchar | 200 | True | |
| MobilePhone (T+16.0) | 手机号 | nvarchar | 60 | True | |
| idLogisticsNetwork (T+16.0) | 物流网点 | int | 4 | True | |
| Creater (T+16.0) | 创建人 | nvarchar | 400 | True | |
| priuserdefnvc1 (T+16.0) | 字符专用自定义项1 | nvarchar | 1000 | True | |
| RunShop (T+16.0) | 跑店 | tinyint | 1 | True | |
| ARBalance_Abandon (T+16.0) | 应收余额废弃字段 | decimal | 13 | True | |
| idsaledepartment (T+16.0) | 分管部门id | int | 4 | True | |
| extendedAccounts (T+16.0) | 超期应收 | decimal | 13 | True | |
| baseauditor (T+16.0) | 审核人 | nvarchar | 100 | True | |
| priuserdefdecm2 (T+16.0) | 数值专用自定义项2 | decimal | 13 | True | |
| Changedate (T+16.0) | 修改时间 | datetime | 8 | True | |
| id (T+16.0) | 主键 | int | 4 | False | |
| IsSystem (T+16.0) | 是否系统字段 | tinyint | 1 | True | |
| IsNeedPromotionPhoto (T+16.0) | 促销拍照 | tinyint | 1 | True | |
| IsNeedLyHuoPhoto (T+16.0) | 理货拍照 | tinyint | 1 | True | |
| ElectronicInvoiceReceiveMode (T+16.0) | 电子发票接收方式 | int | 4 | True | |
| madeDate (T+16.0) | 制单日期 | datetime | 8 | True | |
| saleStartDate (T+16.0) | 销售起始日期 | datetime | 8 | True | |
| createdTime (T+16.0) | CreatedTime | datetime | 8 | True | |
| updatedBy (T+16.0) | 更新者 | nvarchar | 64 | True | |
| name (T+16.0) | 名称 | nvarchar | 400 | True | |
| idpartnerclass (T+16.0) | 往来单位分类id | int | 4 | True | |
| Latitude (T+16.0) | 坐标地址(纬度) | nvarchar | 400 | True | |
| isAutoCancel (T+16.0) | 自动核销 | tinyint | 1 | True | |
| QqNo (T+16.0) | QQ号 | nvarchar | 100 | True | |
| priuserdefnvc3 (T+16.0) | 字符专用自定义项3 | nvarchar | 1000 | True | |
| partnerAbbName (T+16.0) | 简称 | nvarchar | 200 | True | |
| SavedRoutes (T+16.0) | 保存的路线 | nvarchar | 1000 | True | |
| creditBalance (T+16.0) | 信用余额 | decimal | 13 | True | |
| idPmarketingOrgan (T+16.0) | 对应营销机构ID | int | 4 | True | |
| Coordinate (T+16.0) | 坐标地址 | nvarchar | 400 | True | |
| priceGrade (T+16.0) | 客户价格等级 | int | 4 | True | |
| EmailAddr (T+16.0) | 电子邮件 | nvarchar | 200 | True | |
| IsNeedCheckInPhoto (T+16.0) | 签到拍照 | tinyint | 1 | True | |
| Birthday (T+16.0) | 出生日期 | datetime | 8 | True | |
| taxRate (T+16.0) | 税率 | int | 4 | True | |
| UuNo (T+16.0) | UU号 | nvarchar | 100 | True | |
| iddefaultSettleStyleOfReceive (T+16.0) | 默认结算方式ID | int | 4 | True | |
| purchaseCheckDate (T+16.0) | 采购结帐日 | int | 4 | True | |
| APBalance_Abandon (T+16.0) | 应付余额废弃字段 | decimal | 13 | True | |
| ShipmentAddress (T+16.0) | 到货地址 | nvarchar | 400 | True | |
| AdvRBalance_Abandon (T+16.0) | 预收余额废弃字段 | decimal | 13 | True | |
| CheckAddress (T+16.0) | 坐标地址 | nvarchar | 400 | True | |
| idMarketingOrgan (T+16.0) | 所属营销机构ID | int | 4 | True | |
| purchaseCreditDays (T+16.0) | 采购信用天数 | decimal | 13 | True | |
| baseauditorid (T+16.0) | 审核人id | nvarchar | 100 | True | |
| customerType (T+16.0) | 客商类型 | int | 4 | True | |
| purchaseSpaceMonth (T+16.0) | 采购对帐区间间隔月 | int | 4 | True | |
| purchaseCheckMonth (T+16.0) | 采购结帐间隔月 | int | 4 | True | |
| saleCreditDays (T+16.0) | 销售信用天数 | decimal | 13 | True | |
| AutoCreateMember (T+16.0) | 自动生成会员 | tinyint | 1 | True | |
| addressJC (T+16.0) | 地址简称 | nvarchar | 400 | True | |
| code (T+16.0) | 编号 | nvarchar | 100 | True | |
| DefaultInvoiceTypeOfReceive (T+16.0) | 默认票据类型 | int | 4 | True | |
| priuserdefdecm3 (T+16.0) | 数值自定义项3 | decimal | 13 | True | |
| ts (T+16.0) | 分布时间戳 | timestamp | 8 | True | |
| VisitAddress (T+16.0) | 拜访地址 | nvarchar | 1000 | True | |
| LogisticsSettleStyle (T+16.0) | 物流结算方式 | int | 4 | True | |
| Contact (T+16.0) | 联系人 | nvarchar | 100 | True | |
| Longitude (T+16.0) | 坐标地址(经度) | nvarchar | 400 | True | |
| saleCreditLine (T+16.0) | 销售信用额度 | decimal | 13 | True | |
| iddefaultSettleStyleOfPayment (T+16.0) | 默认结算方式ID | int | 4 | True | |
| codeSettlementPartner (T+16.0) | 结算客户编号 | nvarchar | 100 | True | |
| disabled (T+16.0) | 停用 | tinyint | 1 | True | |
| idsettlementPartner (T+16.0) | 结算客户id | int | 4 | True | |
| accbank (T+16.0) | 开户银行 | int | 4 | True | |
| saleCheckMonth (T+16.0) | 销售结帐间隔月 | int | 4 | True | |
| isContainTaxOnPurchase (T+16.0) | 采购报价是否含税 | tinyint | 1 | True | |
| AdvPBalance_Abandon (T+16.0) | 预付余额废弃字段 | decimal | 13 | True | |
| priuserdefnvc4 (T+16.0) | 字符专用自定义项4 | nvarchar | 1000 | True | |
| shortHand (T+16.0) | 助记码 | nvarchar | 200 | True | |
| Position (T+16.0) | Position | varchar | 50 | True | |
| updated (T+16.0) | 更新时间 | datetime | 8 | True | |
| iddefaultBankAccountOfPayment (T+16.0) | 默认账号ID | int | 4 | True | |
| Fax (T+16.0) | 传真 | nvarchar | 40 | True | |
| ElectronicInvoiceReceiveEMail (T+16.0) | 接收邮件 | nvarchar | 200 | True | |
| idMemberType (T+16.0) | 会员类型id | int | 4 | True | |
| PrintCount (T+16.0) | 打印数量 | int | 4 | True | |
| partnerType (T+16.0) | 性质 | int | 4 | True | |
| basevoucherstate (T+16.0) | 审核状态 | tinyint | 1 | True | |
| purchaseStartDate (T+16.0) | 采购起始日期 | datetime | 8 | True | |
| priuserdefnvc2 (T+16.0) | 字符专用自定义项2 | nvarchar | 1000 | True | |
| IsModifiedCode (T+16.0) | 是否更改过往来单位编码 | tinyint | 1 | True | |
| DefaultInvoiceTypeOfPayment (T+16.0) | 默认票据类型 | int | 4 | True | |
| iddistrict (T+16.0) | 地区id | int | 4 | True | |
| priuserdefdecm1 (T+16.0) | 数值专用自定义项1 | decimal | 13 | True | |
| MadeRecordDate (T+16.0) | 建档日期 | datetime | 8 | True | |
| bankAccount (T+16.0) | BankAccount | nvarchar | 100 | True | |
| baseauditeddate (T+16.0) | 审核日期 | datetime | 8 | True | |
| purchaseSettleStyle (T+16.0) | 采购付款方式 | int | 4 | True | |
| iddefaultBankAccountOfReceive (T+16.0) | 默认账号ID | int | 4 | True |
Copyright 2016 Chanjet Inc.