EC_PURCONT_PROD_B 采购协议合同产品信息返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | AMOUNT | NUMBER | 28 | 8 | | | √ | | 数量 |
2 | ARRIVE_DATE | CHAR | 19 | | | | √ | | 计划到货日期 |
3 | ASSIS_PROPERTY1 | VARCHAR2 | 101 | | | | √ | | 辅助属性1 |
4 | ASSIS_PROPERTY10 | VARCHAR2 | 101 | | | | √ | | 辅助属性10 |
5 | ASSIS_PROPERTY2 | VARCHAR2 | 101 | | | | √ | | 辅助属性2 |
6 | ASSIS_PROPERTY3 | VARCHAR2 | 101 | | | | √ | | 辅助属性3 |
7 | ASSIS_PROPERTY4 | VARCHAR2 | 101 | | | | √ | | 辅助属性4 |
8 | ASSIS_PROPERTY5 | VARCHAR2 | 101 | | | | √ | | 辅助属性5 |
9 | ASSIS_PROPERTY6 | VARCHAR2 | 101 | | | | √ | | 辅助属性6 |
10 | ASSIS_PROPERTY7 | VARCHAR2 | 101 | | | | √ | | 辅助属性7 |
11 | ASSIS_PROPERTY8 | VARCHAR2 | 101 | | | | √ | | 辅助属性8 |
12 | ASSIS_PROPERTY9 | VARCHAR2 | 101 | | | | √ | | 辅助属性9 |
13 | COLLECT_ADDR | VARCHAR2 | 20 | | | | √ | '~' | 收货地址 |
14 | COLLECT_AREA | VARCHAR2 | 20 | | | | √ | '~' | 收货地区 |
15 | COLLECT_ORG | VARCHAR2 | 20 | | | | √ | '~' | 最新收货组织 |
16 | COLLECT_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 收货组织 |
17 | CONVERSION_RATE | VARCHAR2 | 60 | | | | √ | | 换算率 |
18 | COSTPRICE | NUMBER | 28 | 8 | | | √ | | 计成本单价 |
19 | DEF1 | VARCHAR2 | 101 | | | | √ | | 自定义项1 |
20 | DEF10 | VARCHAR2 | 101 | | | | √ | | 自定义项10 |
21 | DEF11 | VARCHAR2 | 101 | | | | √ | | 自定义项11 |
22 | DEF12 | VARCHAR2 | 101 | | | | √ | | 自定义项12 |
23 | DEF13 | VARCHAR2 | 101 | | | | √ | | 自定义项13 |
24 | DEF14 | VARCHAR2 | 101 | | | | √ | | 自定义项14 |
25 | DEF15 | VARCHAR2 | 101 | | | | √ | | 自定义项15 |
26 | DEF16 | VARCHAR2 | 101 | | | | √ | | 自定义项16 |
27 | DEF17 | VARCHAR2 | 101 | | | | √ | | 自定义项17 |
28 | DEF18 | VARCHAR2 | 101 | | | | √ | | 自定义项18 |
29 | DEF19 | VARCHAR2 | 101 | | | | √ | | 自定义项19 |
30 | DEF2 | VARCHAR2 | 101 | | | | √ | | 自定义项2 |
31 | DEF20 | VARCHAR2 | 101 | | | | √ | | 自定义项20 |
32 | DEF3 | VARCHAR2 | 101 | | | | √ | | 自定义项3 |
33 | DEF4 | VARCHAR2 | 101 | | | | √ | | 自定义项4 |
34 | DEF5 | VARCHAR2 | 101 | | | | √ | | 自定义项5 |
35 | DEF6 | VARCHAR2 | 101 | | | | √ | | 自定义项6 |
36 | DEF7 | VARCHAR2 | 101 | | | | √ | | 自定义项7 |
37 | DEF8 | VARCHAR2 | 101 | | | | √ | | 自定义项8 |
38 | DEF9 | VARCHAR2 | 101 | | | | √ | | 自定义项9 |
39 | DIS_NO_TAX_PRICE | NUMBER | 28 | 8 | | | √ | | 净无税单价 |
40 | DIS_NO_TAX_PRICE_M | NUMBER | 28 | 8 | | | √ | | 主单位净无税单价(主无税净价) |
41 | DIS_TAX_PRICE | NUMBER | 28 | 8 | | | √ | | 净含税单价 |
42 | DIS_TAX_PRICE_M | NUMBER | 28 | 8 | | | √ | | 主单位净含税单价(主含税净价) |
43 | DISCOUNT | NUMBER | 28 | 8 | | | √ | | 折扣率(%) |
44 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
45 | FACTORY | VARCHAR2 | 20 | | | | √ | '~' | 生产厂商 |
46 | FIRSTBILLNO | VARCHAR2 | 50 | | | | √ | | 源头单据号 |
47 | FIRSTBILLTYPE | VARCHAR2 | 20 | | | | √ | | 源头单据类型 |
48 | FIRSTBPK | VARCHAR2 | 50 | | | | √ | | 源头单据子表ID |
49 | FIRSTHPK | VARCHAR2 | 50 | | | | √ | | 源头单据主表ID |
50 | FIRSTTRANTYPE | VARCHAR2 | 20 | | | | √ | | 源头交易类型 |
51 | MAIN_AMOUNT | NUMBER | 28 | 8 | | | √ | | 主数量 |
52 | MARKET_PRICE | NUMBER | 28 | 8 | | | √ | | 市场单价(设计字段) |
53 | NCALCOSTMNY | NUMBER | 28 | 8 | | | √ | | 计成本金额 |
54 | NCALTAXMNY | NUMBER | 28 | 8 | | | √ | | 计税金额 |
55 | NO_TAX_AMOUNT | NUMBER | 28 | 8 | | | √ | | 无税金额 |
56 | NO_TAX_PRICE | NUMBER | 28 | 8 | | | √ | | 无税单价 |
57 | PK_GROUP | CHAR | 20 | | | | √ | | 集团 |
58 | PK_MAIN_UNIT | VARCHAR2 | 20 | | | | √ | '~' | 主单位 |
59 | PK_ORG | CHAR | 20 | | | | √ | | 主组织 |
60 | PK_ORG_V | CHAR | 20 | | | | √ | | 版本组织 |
61 | PK_PAY_ORG | VARCHAR2 | 20 | | | | √ | '~' | 最新应付财务组织 |
62 | PK_PAY_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 应付财务组织 |
63 | PK_PROD | VARCHAR2 | 20 | | | | √ | '~' | 产品主键 |
64 | PK_PROD_CLS | VARCHAR2 | 20 | | | | √ | '~' | 产品分类主键 |
65 | PK_PROD_V | VARCHAR2 | 20 | | | | √ | '~' | 产品版本信息 |
66 | PK_PROJECT | VARCHAR2 | 20 | | | | √ | '~' | 项目 |
67 | PK_PURCONT_PROD_B | CHAR | 20 | | √ | | | | 主键 |
68 | PK_PURCONTRACT_H | CHAR | 20 | | | | | | 采购协议合同_主键 |
69 | PK_UNIT | VARCHAR2 | 20 | | | | √ | '~' | 单位 |
70 | PLAN_AMOUNT | NUMBER | 28 | 8 | | | √ | | 计划数量 |
71 | QUALITY_CLS | VARCHAR2 | 101 | | | | √ | | 质量等级 |
72 | QUOTA_AMOUNT | NUMBER | 28 | 8 | | | √ | | 配额 |
73 | REAL_TAX | NUMBER | 28 | 8 | | | √ | | 不可抵扣税额 |
74 | SR_CHPK | VARCHAR2 | 50 | | | | √ | | 来源单据主表ID |
75 | SRC_BILLNO | VARCHAR2 | 50 | | | | √ | | 来源单据号 |
76 | SRC_BILLTYPE | VARCHAR2 | 20 | | | | √ | | 来源单据类型 |
77 | SRC_BPK | VARCHAR2 | 50 | | | | √ | | 来源单据子表ID |
78 | SRC_PK_PROJ | VARCHAR2 | 50 | | | | √ | | 来源采购方案id(分标分量) |
79 | SRC_PROJ_NO | VARCHAR2 | 50 | | | | √ | | 来源采购方案号(分标分量) |
80 | SRC_TRANTYPE | VARCHAR2 | 20 | | | | √ | | 来源交易类型 |
81 | SRCBILLNO | VARCHAR2 | 50 | | | | √ | | 来源单据号(分标分量) |
82 | SRCBILLTYPE | VARCHAR2 | 20 | | | | √ | '~' | 来源单据类型(分标分量) |
83 | SRCBPK | VARCHAR2 | 50 | | | | √ | | 来源单据子表ID(分标分量) |
84 | SRCHPK | VARCHAR2 | 50 | | | | √ | | 来源单据主表ID(分标分量) |
85 | SRCPURPERJMGR | VARCHAR2 | 50 | | | | √ | | 来源采购方案子表主键(设计字段) |
86 | SRCTRANTYPE | VARCHAR2 | 20 | | | | √ | | 来源交易类型(分标分量) |
87 | TAX_AMOUNT | NUMBER | 28 | 8 | | | √ | | 税额 |
88 | TAX_PRICE | NUMBER | 28 | 8 | | | √ | | 含税单价 |
89 | TAX_RATE | NUMBER | 28 | 8 | | | √ | | 税率(%) |
90 | TAX_TYPE | NUMBER | 38 | 0 | | | √ | | 扣税类别 |
91 | TAXCODE | VARCHAR2 | 20 | | | | √ | '~' | 税码 |
92 | TOTAL | NUMBER | 28 | 8 | | | √ | | 价税合计 |
93 | TOTAL_CONT_EXE | NUMBER | 28 | 8 | | | √ | | 合同累计执行数量 |
94 | TOTAL_PRICE_TAX | NUMBER | 28 | 8 | | | √ | | 合同累计执行价税合计 |
95 | TRANSPORT_TYPE | VARCHAR2 | 20 | | | | √ | '~' | 运输方式 |
96 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
97 | UNDEDUCTABLE | NUMBER | 28 | 8 | | | √ | | 不可抵扣税率(%) |
|