PO_SETTLEBILL_B 结算单明细返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BWASHEST | CHAR | 1 | | | | √ | | 冲销暂估/确认成本标志 |
2 | CROWNO | VARCHAR2 | 20 | | | | √ | | 行号 |
3 | CUNITID | VARCHAR2 | 20 | | | | √ | | 主单位 |
4 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
5 | FROWTYPE | NUMBER | 38 | 0 | | | √ | | 行类型 |
6 | INVOICEBILLDATE | CHAR | 19 | | | | √ | | 开票日期 |
7 | NADJUSTMNY | NUMBER | 28 | 8 | | | √ | | 调整货物金额 |
8 | NCLASHESTMONEY | NUMBER | 28 | 8 | | | √ | | 冲销暂估金额 |
9 | NCOSTFACTOR1 | NUMBER | 28 | 8 | | | √ | | 成本要素1 |
10 | NCOSTFACTOR2 | NUMBER | 28 | 8 | | | √ | | 成本要素2 |
11 | NCOSTFACTOR3 | NUMBER | 28 | 8 | | | √ | | 成本要素3 |
12 | NCOSTFACTOR4 | NUMBER | 28 | 8 | | | √ | | 成本要素4 |
13 | NCOSTFACTOR5 | NUMBER | 28 | 8 | | | √ | | 成本要素5 |
14 | NCOSTFACTOR6 | NUMBER | 28 | 8 | | | √ | | 成本要素6 |
15 | NCOSTFACTOR7 | NUMBER | 28 | 8 | | | √ | | 成本要素7 |
16 | NCOSTFACTOR8 | NUMBER | 28 | 8 | | | √ | | 成本要素8 |
17 | NDISCOUNT | NUMBER | 28 | 8 | | | √ | | 折扣 |
18 | NGOODSMONEY | NUMBER | 28 | 8 | | | √ | | 货物结算金额 |
19 | NGOODSPRICE | NUMBER | 28 | 8 | | | √ | | 货物结算单价 |
20 | NMONEY | NUMBER | 28 | 8 | | | √ | | 金额 |
21 | NOPPOCONFMAPMNY | NUMBER | 28 | 8 | | | √ | | 相应的确认应付原币价税合计 |
22 | NOPPOCONFMMONEY | NUMBER | 28 | 8 | | | √ | | 相应的确认成本 |
23 | NPRICE | NUMBER | 28 | 8 | | | √ | | 单价 |
24 | NREASONALWASTMNY | NUMBER | 28 | 8 | | | √ | | 合理损耗金额 |
25 | NREASONALWASTNUM | NUMBER | 28 | 8 | | | √ | | 合理损耗数量 |
26 | NREASONALWASTPRICE | NUMBER | 28 | 8 | | | √ | | 合理损耗单价 |
27 | NSETTLENUM | NUMBER | 28 | 8 | | | √ | | 结算数量 |
28 | PK_ARRSTOCKORG | VARCHAR2 | 20 | | | | √ | | 收货库存组织 |
29 | PK_ARRSTOCKORG_V | VARCHAR2 | 20 | | | | √ | | 收货库存组织版本 |
30 | PK_COSTREGION | VARCHAR2 | 20 | | | | √ | | 成本域 |
31 | PK_DEPT | VARCHAR2 | 20 | | | | √ | | 采购部门原始信息 |
32 | PK_DEPT_V | VARCHAR2 | 20 | | | | √ | | 采购部门 |
33 | PK_DTRANSALEBID | VARCHAR2 | 20 | | | | √ | | 相应的直运销售订单行 |
34 | PK_DTRANSALEID | VARCHAR2 | 20 | | | | √ | | 相应的直运销售订单 |
35 | PK_GENERALIN | VARCHAR2 | 20 | | | | √ | | 其他入表头 |
36 | PK_GENERALIN_B | VARCHAR2 | 20 | | | | √ | | 其他入表体 |
37 | PK_GROUP | VARCHAR2 | 20 | | | | √ | | 所属集团 |
38 | PK_INITIALEST | VARCHAR2 | 20 | | | | √ | | 期初暂估表头 |
39 | PK_INITIALEST_B | VARCHAR2 | 20 | | | | √ | | 期初暂估表体 |
40 | PK_INVOICE | VARCHAR2 | 20 | | | | √ | | 发票 |
41 | PK_INVOICE_B | VARCHAR2 | 20 | | | | √ | | 发票行 |
42 | PK_INVOICEORDER | VARCHAR2 | 20 | | | | √ | | 发票的订单头 |
43 | PK_INVOICEORDER_B | VARCHAR2 | 20 | | | | √ | | 发票的订单体 |
44 | PK_MATERIAL | VARCHAR2 | 20 | | | | √ | | 物料版本 |
45 | PK_ORG | VARCHAR2 | 20 | | | | √ | | 财务组织版本 |
46 | PK_ORG_V | VARCHAR2 | 20 | | | | √ | | 财务组织 |
47 | PK_PSNDOC | VARCHAR2 | 20 | | | | √ | | 业务员 |
48 | PK_PURCHASEIN | VARCHAR2 | 20 | | | | √ | | 采购入表头 |
49 | PK_PURCHASEIN_B | VARCHAR2 | 20 | | | | √ | | 采购入表体 |
50 | PK_RUSHINVOICE | VARCHAR2 | 20 | | | | √ | | 对冲的发票 |
51 | PK_RUSHINVOICE_B | VARCHAR2 | 20 | | | | √ | | 对冲的发票行 |
52 | PK_RUSHSTOCK | VARCHAR2 | 20 | | | | √ | | 对冲的库存单据 |
53 | PK_RUSHSTOCK_B | VARCHAR2 | 20 | | | | √ | | 对冲的库存单据行 |
54 | PK_SETTLEBILL | CHAR | 20 | | | | | | 结算单头_主键 |
55 | PK_SETTLEBILL_B | CHAR | 20 | | √ | | | | 结算明细 |
56 | PK_SRCMATERIAL | VARCHAR2 | 20 | | | | √ | | 物料 |
57 | PK_STOCK | VARCHAR2 | 20 | | | | √ | | 库存单据 |
58 | PK_STOCK_B | VARCHAR2 | 20 | | | | √ | | 库存单据行 |
59 | PK_STOCKORDER | VARCHAR2 | 20 | | | | √ | | 库存单据的订单头 |
60 | PK_STOCKORDER_B | VARCHAR2 | 20 | | | | √ | | 库存单据的订单体 |
61 | PK_SUBCONTRACT | VARCHAR2 | 20 | | | | √ | | 委外入表头 |
62 | PK_SUBCONTRACT_B | VARCHAR2 | 20 | | | | √ | | 委外入表体 |
63 | PK_SUPPLIER | VARCHAR2 | 20 | | | | √ | | 供应商 |
64 | PK_TRANSIN | VARCHAR2 | 20 | | | | √ | | 调拨入表头 |
65 | PK_TRANSIN_B | VARCHAR2 | 20 | | | | √ | | 调拨入表体 |
66 | PK_VOICONSUME | VARCHAR2 | 20 | | | | √ | | 消耗汇总表头 |
67 | PK_VOICONSUME_B | VARCHAR2 | 20 | | | | √ | | 消耗汇总表体 |
68 | STOCKBILLDATE | CHAR | 19 | | | | √ | | 入库日期 |
69 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
70 | VINVOICECODE | VARCHAR2 | 40 | | | | √ | | 发票号 |
71 | VINVOICETRANTYPE | VARCHAR2 | 20 | | | | √ | | 发票交易类型 |
72 | VITCTCODE | VARCHAR2 | 40 | | | | √ | | 进口合同号 |
73 | VSTOCKBILLTYPE | VARCHAR2 | 20 | | | | √ | | 库存单据类型 |
74 | VSTOCKCODE | VARCHAR2 | 40 | | | | √ | | 入库单号/消耗汇总 |
75 | VSTOCKTRANTYPE | VARCHAR2 | 20 | | | | √ | | 入库单交易类型 |
|