prm_salequotation - 销售报价单主表
字段列表
| 编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | | csalequotationid | 销售报价单主表ID | CHAR | Y | 20 | 0 | | | | |
| bdeliver | 是否发运 | CHAR | | 1 | 0 | N | | | |
| cassistantcurrencyid | 辅币ID | CHAR | | 20 | 0 | | | | |
| cauditorid | 审批人ID | CHAR | | 20 | 0 | | | | |
| cbilltemplateid | 单据模板ID | CHAR | | 20 | 0 | | | | |
| cbiztypeid | 业务类型ID | CHAR | | 20 | 0 | | | | |
| ccurrencyid | 币种ID | CHAR | | 20 | 0 | | | | |
| ccustomerid | 客户ID | CHAR | | 20 | 0 | | | | |
| cdeliveraddrid | 交货地址ID | VARCHAR | | 382 | 0 | | | | |
| cdepartmentid | 部门ID | CHAR | | 20 | 0 | | | | |
| cemployeeid | 业务员ID | CHAR | | 20 | 0 | | | | |
| coperatorid | 制单人ID | CHAR | | 20 | 0 | | | | |
| coriginalcurrencyid | 原币ID | CHAR | | 20 | 0 | | | | |
| cpayprotclid | 收款协议ID | CHAR | | 20 | 0 | | | | |
| creceiptcustomerid | 收货单位ID | CHAR | | 20 | 0 | | | | |
| creceipttype | 单据类型 | VARCHAR | | 4 | 0 | | | | |
| creceiveaddrid | 收货地址ID | VARCHAR | | 382 | 0 | | | | |
| csalestructid | 销售组织ID | CHAR | | 20 | 0 | | | | |
| cstatus | 状态 | VARCHAR | | 10 | 0 | | | | |
| ctransmodeid | 运输方式ID | CHAR | | 20 | 0 | | | | |
| cupdatereason | 审批变动原因 | VARCHAR | | 181 | 0 | | | | |
| cyear | 会计年度 | CHAR | | 4 | 0 | | | | |
| dauditdate | 审批日期 | CHAR | | 10 | 0 | | | | |
| ddeliverdate | 交货日期 | CHAR | | 10 | 0 | | | | |
| dexpiredate | 失效日期 | CHAR | | 10 | 0 | | | | |
| dmakedate | 制单日期 | CHAR | | 10 | 0 | | | | |
| dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
| dreceiptdate | 报价日期 | CHAR | | 10 | 0 | | | | |
| iprintcount | 打印次数 | SMALLINT | | 2 | 0 | 0 | | | |
| ndiscountrate | 整单折扣率 | DECIMAL | | 20 | 6 | | | | |
| nevaluatecarriage | 预估运费 | DECIMAL | | 20 | 8 | | | | |
| nexchangerate | 汇率 | DECIMAL | | 15 | 8 | | | | |
| pk_corp | 公司ID | CHAR | | 4 | 0 | | | | |
| pk_defdoc1 | 自定义项主键1 | CHAR | | 20 | 0 | | | | |
| pk_defdoc10 | 自定义项主键10 | CHAR | | 20 | 0 | | | | |
| pk_defdoc11 | 自定义项主键11 | CHAR | | 20 | 0 | | | | |
| pk_defdoc12 | 自定义项主键12 | CHAR | | 20 | 0 | | | | |
| pk_defdoc13 | 自定义项主键13 | CHAR | | 20 | 0 | | | | |
| pk_defdoc14 | 自定义项主键14 | CHAR | | 20 | 0 | | | | |
| pk_defdoc15 | 自定义项主键15 | CHAR | | 20 | 0 | | | | |
| pk_defdoc16 | 自定义项主键16 | CHAR | | 20 | 0 | | | | |
| pk_defdoc17 | 自定义项主键17 | CHAR | | 20 | 0 | | | | |
| pk_defdoc18 | 自定义项主键18 | CHAR | | 20 | 0 | | | | |
| pk_defdoc19 | 自定义项主键19 | CHAR | | 20 | 0 | | | | |
| pk_defdoc2 | 自定义项主键2 | CHAR | | 20 | 0 | | | | |
| pk_defdoc20 | 自定义项主键20 | CHAR | | 20 | 0 | | | | |
| pk_defdoc3 | 自定义项主键3 | CHAR | | 20 | 0 | | | | |
| pk_defdoc4 | 自定义项主键4 | CHAR | | 20 | 0 | | | | |
| pk_defdoc5 | 自定义项主键5 | CHAR | | 20 | 0 | | | | |
| pk_defdoc6 | 自定义项主键6 | CHAR | | 20 | 0 | | | | |
| pk_defdoc7 | 自定义项主键7 | CHAR | | 20 | 0 | | | | |
| pk_defdoc8 | 自定义项主键8 | CHAR | | 20 | 0 | | | | |
| pk_defdoc9 | 自定义项主键9 | CHAR | | 20 | 0 | | | | |
| ts | 时间戳 | CHAR | | 19 | 0 | | | | |
| vdef1 | 自定义项1 | VARCHAR | | 100 | 0 | | | | |
| vdef10 | 自定义项10 | VARCHAR | | 100 | 0 | | | | |
| vdef11 | 自定义项11 | VARCHAR | | 100 | 0 | | | | |
| vdef12 | 自定义项12 | VARCHAR | | 100 | 0 | | | | |
| vdef13 | 自定义项13 | VARCHAR | | 100 | 0 | | | | |
| vdef14 | 自定义项14 | VARCHAR | | 100 | 0 | | | | |
| vdef15 | 自定义项15 | VARCHAR | | 100 | 0 | | | | |
| vdef16 | 自定义项16 | VARCHAR | | 100 | 0 | | | | |
| vdef17 | 自定义项17 | VARCHAR | | 100 | 0 | | | | |
| vdef18 | 自定义项18 | VARCHAR | | 100 | 0 | | | | |
| vdef19 | 自定义项19 | VARCHAR | | 100 | 0 | | | | |
| vdef2 | 自定义项2 | VARCHAR | | 100 | 0 | | | | |
| vdef20 | 自定义项20 | VARCHAR | | 100 | 0 | | | | |
| vdef3 | 自定义项3 | VARCHAR | | 100 | 0 | | | | |
| vdef4 | 自定义项4 | VARCHAR | | 100 | 0 | | | | |
| vdef5 | 自定义项5 | VARCHAR | | 100 | 0 | | | | |
| vdef6 | 自定义项6 | VARCHAR | | 100 | 0 | | | | |
| vdef7 | 自定义项7 | VARCHAR | | 100 | 0 | | | | |
| vdef8 | 自定义项8 | VARCHAR | | 100 | 0 | | | | |
| vdef9 | 自定义项9 | VARCHAR | | 100 | 0 | | | | |
| vmemo | 备注 | VARCHAR | | 181 | 0 | | | | |
| vreceiptno | 单据号 | VARCHAR | | 30 | 0 | | | | |
外键列表
索引列表