EC_WEB_ORDER_B 门户订单子表返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BATCH_NO | VARCHAR2 | 50 | | | | √ | | 批次号 |
2 | CONFIR_PRICE | NUMBER | 28 | 8 | | | √ | | 确认单价 |
3 | CONFIRM_ARR_DATE | CHAR | 19 | | | | √ | | 确认计划到货日期 |
4 | CONFIRM_NUM | NUMBER | 28 | 8 | | | √ | | 确认数量 |
5 | CONTRACT_NAME | VARCHAR2 | 300 | | | | √ | | 合同名称 |
6 | CONTRACT_NO | VARCHAR2 | 50 | | | | √ | | 合同号 |
7 | CUR_NAME | VARCHAR2 | 300 | | | | √ | | 币种名称 |
8 | DEF1 | VARCHAR2 | 101 | | | | √ | | 自定义项1 |
9 | DEF10 | VARCHAR2 | 101 | | | | √ | | 自定义项10 |
10 | DEF2 | VARCHAR2 | 101 | | | | √ | | 自定义项2 |
11 | DEF3 | VARCHAR2 | 101 | | | | √ | | 自定义项3 |
12 | DEF4 | VARCHAR2 | 101 | | | | √ | | 自定义项4 |
13 | DEF5 | VARCHAR2 | 101 | | | | √ | | 自定义项5 |
14 | DEF6 | VARCHAR2 | 101 | | | | √ | | 自定义项6 |
15 | DEF7 | VARCHAR2 | 101 | | | | √ | | 自定义项7 |
16 | DEF8 | VARCHAR2 | 101 | | | | √ | | 自定义项8 |
17 | DEF9 | VARCHAR2 | 101 | | | | √ | | 自定义项9 |
18 | DISCOUNT | NUMBER | 28 | 8 | | | √ | | 折扣率(%) |
19 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
20 | EC_WEB_ORDER_B | VARCHAR2 | 50 | | √ | | | | 订单子表主键 |
21 | FIRSTBILLNO | VARCHAR2 | 50 | | | | √ | | 源头单据号 |
22 | FIRSTBILLTYPE | VARCHAR2 | 20 | | | | √ | | 源头单据类型 |
23 | FIRSTBPK | VARCHAR2 | 50 | | | | √ | | 源头单据子表ID |
24 | FIRSTHPK | VARCHAR2 | 50 | | | | √ | | 源头单据主表ID |
25 | FIRSTTRANTYPE | VARCHAR2 | 20 | | | | √ | | 源头交易类型 |
26 | ISCOMMIT | VARCHAR2 | 50 | | | | √ | | 是否提交 |
27 | ISCONFIRM | VARCHAR2 | 50 | | | | √ | | 是否确认 |
28 | MEASURE_NAME | VARCHAR2 | 300 | | | | √ | | 单位名称 |
29 | NET_TAX_PRICE | NUMBER | 28 | 8 | | | √ | | 净含税单价 |
30 | ORDER_LINE_NO | VARCHAR2 | 50 | | | | √ | | 订单行号 |
31 | ORDER_NO | VARCHAR2 | 50 | | | | √ | | 订单号 |
32 | ORDER_NUM | NUMBER | 28 | 8 | | | √ | | 订单数量 |
33 | ORDER_PRICE | NUMBER | 28 | 8 | | | √ | | 订单单价 |
34 | ORIGINAL_ARR_DATE | CHAR | 19 | | | | √ | | 原始计划到货日期 |
35 | ORIGINAL_ORDER_NUM | NUMBER | 28 | 8 | | | √ | | 原始订单数量 |
36 | ORIGINAL_TAX_PRICE | NUMBER | 28 | 8 | | | √ | | 原始订单净含税单价 |
37 | PK_CONTRACT | VARCHAR2 | 50 | | | | √ | | 合同号主键 |
38 | PK_CURRENCY | VARCHAR2 | 20 | | | | √ | '~' | 币种主键 |
39 | PK_GROUP | CHAR | 20 | | | | √ | | 所属集团 |
40 | PK_MEASURE | VARCHAR2 | 20 | | | | √ | '~' | 单位主键 |
41 | PK_ORDER_B | VARCHAR2 | 50 | | | | √ | | 关联子表主键 |
42 | PK_ORDER_H | VARCHAR2 | 50 | | | | √ | | 关联主表主键 |
43 | PK_ORG | CHAR | 20 | | | | √ | | 主组织 |
44 | PK_ORG_V | CHAR | 20 | | | | √ | | 版本主组织 |
45 | PK_PROD | VARCHAR2 | 50 | | | | √ | | 产品主键 |
46 | PK_PRODUCER | VARCHAR2 | 50 | | | | √ | | 生产厂商主键 |
47 | PK_QUALITY_LEVEL | VARCHAR2 | 50 | | | | √ | | 质量等级主键 |
48 | PK_RECEIVE_ADS | VARCHAR2 | 50 | | | | √ | '~' | 收货地址主键 |
49 | PK_TRANSFER_TYPE | VARCHAR2 | 20 | | | | √ | '~' | 运输方式主键 |
50 | PK_WEB_ORDER_H | VARCHAR2 | 50 | | | | √ | | 订单主表主键 |
51 | PLAN_ARR_DATE | CHAR | 19 | | | | √ | | 订单计划到货日期 |
52 | PRICE_TAX_TOTAL | NUMBER | 28 | 8 | | | √ | | 价税合计 |
53 | PROD_DESC | VARCHAR2 | 256 | | | | √ | | 描述 |
54 | PROD_MODULE | VARCHAR2 | 50 | | | | √ | | 规格 |
55 | PROD_NAME | VARCHAR2 | 300 | | | | √ | | 产品名称 |
56 | PROD_STATUS | NUMBER | 38 | 0 | | | √ | | 产品状态 |
57 | PROD_STATUS_PRE_CMT | NUMBER | 38 | 0 | | | √ | | 产品提交前状态 |
58 | PROD_TYPE | VARCHAR2 | 50 | | | | √ | | 型号 |
59 | PRODUCER_NAME | VARCHAR2 | 300 | | | | √ | | 生产厂商 |
60 | QULITY_LEVEL_NAME | VARCHAR2 | 300 | | | | √ | | 质量等级 |
61 | RATE | NUMBER | 28 | 8 | | | √ | | 税率(%) |
62 | RECEIVE_ADS | VARCHAR2 | 50 | | | | √ | | 收货地址 |
63 | SRCBILLNO | VARCHAR2 | 50 | | | | √ | | 来源单据号 |
64 | SRCBILLTYPE | VARCHAR2 | 20 | | | | √ | | 来源单据类型 |
65 | SRCBPK | VARCHAR2 | 50 | | | | √ | | 来源单据子表ID |
66 | SRCHPK | VARCHAR2 | 50 | | | | √ | | 来源单据主表ID |
67 | SRCORDER | VARCHAR2 | 50 | | | | √ | | 来源信息 |
68 | SRCTRANTYPE | VARCHAR2 | 20 | | | | √ | | 来源交易类型 |
69 | TAX_NUM | NUMBER | 28 | 8 | | | √ | | 税额 |
70 | TAX_PRICE | NUMBER | 28 | 8 | | | √ | | 含税单价 |
71 | TOTAL_ARR_BACK_NUM | NUMBER | 28 | 8 | | | √ | | 累计退货数量 |
72 | TOTAL_ARR_NUM | NUMBER | 28 | 8 | | | √ | | 累计到货数量 |
73 | TOTAL_ARR_PLAN_NUM | NUMBER | 28 | 8 | | | √ | | 累计到货计划数量 |
74 | TOTAL_CAL_AMOUNT | NUMBER | 28 | 8 | | | √ | | 累计结算金额 |
75 | TOTAL_CAL_NUM | NUMBER | 28 | 8 | | | √ | | 累计结算数量 |
76 | TOTAL_INVOICE_NUM | NUMBER | 28 | 8 | | | √ | | 累计发票数量 |
77 | TOTAL_PAY_AMOUNT | NUMBER | 28 | 8 | | | √ | | 累计付款金额 |
78 | TOTAL_STROAGE_NUM | NUMBER | 28 | 8 | | | √ | | 累计入库数量 |
79 | TOTAL_UNSTORAGE_NUM | NUMBER | 28 | 8 | | | √ | | 累计退库数量 |
80 | TRANSFER_NAME | VARCHAR2 | 300 | | | | √ | | 运输方式 |
81 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|