PO_VMIFI_FEE 消耗汇总费用暂估明细返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BOPPTAXFLAG | CHAR | 1 | | | | √ | | 逆向征税 |
2 | BTOAP | CHAR | 1 | | | | √ | 'N' | 传应付标志 |
3 | BTOIA | CHAR | 1 | | | | √ | 'N' | 传成本标志 |
4 | BTRIATRADEFLAG | CHAR | 1 | | | | √ | | 三角贸易 |
5 | CRECECOUNTRYID | VARCHAR2 | 20 | | | | √ | | 收货国家/地区 |
6 | CSENDCOUNTRYID | VARCHAR2 | 20 | | | | √ | | 发货国家/地区 |
7 | CTAXCODEID | VARCHAR2 | 20 | | | | √ | | 税码 |
8 | CTAXCOUNTRYID | VARCHAR2 | 20 | | | | √ | | 报税国家/地区 |
9 | DESTDATE | CHAR | 19 | | | | √ | | 暂估日期 |
10 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
11 | FBUYSELLFLAG | NUMBER | 38 | 0 | | | √ | | 购销类型 |
12 | FTAXTYPEFLAG | NUMBER | 38 | 0 | | | √ | | 扣税类别 |
13 | NCALCOSTMNY | NUMBER | 28 | 8 | | | √ | | 计成本金额 |
14 | NCALTAXMNY | NUMBER | 28 | 8 | | | √ | | 计税金额 |
15 | NESTEXCHGRATE | NUMBER | 28 | 8 | | | √ | | 折本汇率 |
16 | NESTMNY | NUMBER | 28 | 8 | | | √ | | 本币无税金额 |
17 | NESTOMNY | NUMBER | 28 | 8 | | | √ | | 原币无税金额 |
18 | NESTOTOTALMNY | NUMBER | 28 | 8 | | | √ | | 原币价税合计 |
19 | NESTTAXMNY | NUMBER | 28 | 8 | | | √ | | 税额 |
20 | NESTTAXRATE | NUMBER | 28 | 8 | | | √ | | 税率 |
21 | NESTTOTALMNY | NUMBER | 28 | 8 | | | √ | | 本币价税合计 |
22 | NNOSUBTAX | NUMBER | 28 | 8 | | | √ | | 不可抵扣税额 |
23 | NNOSUBTAXRATE | NUMBER | 28 | 8 | | | √ | | 不可抵扣税率 |
24 | PK_COSTFACTOR | VARCHAR2 | 20 | | | | √ | | 成本要素 |
25 | PK_ESTCURRENCY | VARCHAR2 | 20 | | | | √ | | 币种 |
26 | PK_ESTPSN | VARCHAR2 | 20 | | | | √ | | 暂估人 |
27 | PK_FEEMATERIAL | VARCHAR2 | 20 | | | | √ | | 费用项 |
28 | PK_FINANCEORG | VARCHAR2 | 20 | | | | √ | | 财务组织 |
29 | PK_FIRSTSETTLE | VARCHAR2 | 20 | | | | √ | | 暂估费用物料第一次结算的费用发票所在结算单 |
30 | PK_FIRSTSETTLE_B | VARCHAR2 | 20 | | | | √ | | 暂估费用物料第一次结算的费用发票所在结算单行 |
31 | PK_GROUP | VARCHAR2 | 20 | | | | √ | | 集团 |
32 | PK_LOCALCURRENCY | VARCHAR2 | 20 | | | | √ | | 本币 |
33 | PK_SRCFEEMATERIAL | VARCHAR2 | 20 | | | | √ | | 暂估费用物料 |
34 | PK_STOCKPS | CHAR | 20 | | | | √ | | 消耗汇总财务头 |
35 | PK_STOCKPS_B | CHAR | 20 | | | | | | 消耗汇总财务_主键 |
36 | PK_STOCKPS_FEE | CHAR | 20 | | √ | | | | 消耗汇总费用暂估明细 |
37 | PK_SUPPLIER | VARCHAR2 | 20 | | | | √ | | 供应商名称 |
38 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|