PO_POTRANTYPE 采购订单交易类型返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BARRIVE | CHAR | 1 | | | | √ | | 到货 |
2 | BCHECKCENPUR | CHAR | 1 | | | | √ | | 采购订单是否检查采购业务委托关系 |
3 | BCONFIRM | CHAR | 1 | | | | √ | | 对方确认 |
4 | BCONFIRMCODE | CHAR | 1 | | | | √ | | 对方确认单据号 |
5 | BCONFIRMDATE | CHAR | 1 | | | | √ | | 对方确认单据日期 |
6 | BCONFIRMNUM | CHAR | 1 | | | | √ | | 对方确认单据数量 |
7 | BCONSIGN | CHAR | 1 | | | | √ | | 发货环节 |
8 | BCONSIGNCODE | CHAR | 1 | | | | √ | | 发货单据号 |
9 | BCONSIGNDATE | CHAR | 1 | | | | √ | | 发货单据日期 |
10 | BCONSIGNNUM | CHAR | 1 | | | | √ | | 发货单据数量 |
11 | BCUSTOM | CHAR | 1 | | | | √ | | 报关环节 |
12 | BCUSTOMCODE | CHAR | 1 | | | | √ | | 报关单据号 |
13 | BCUSTOMDATE | CHAR | 1 | | | | √ | | 报关单据日期 |
14 | BDIRECT | CHAR | 1 | | | | √ | | 直运采购 |
15 | BLOAD | CHAR | 1 | | | | √ | | 装运环节 |
16 | BLOADCODE | CHAR | 1 | | | | √ | | 装运单据号 |
17 | BLOADDATE | CHAR | 1 | | | | √ | | 装运单据日期 |
18 | BOUTCUSTOM | CHAR | 1 | | | | √ | | 出关环节 |
19 | BOUTCUSTOMCODE | CHAR | 1 | | | | √ | | 出关单据号 |
20 | BOUTCUSTOMDATE | CHAR | 1 | | | | √ | | 出关单据日期 |
21 | BOUTPUT | CHAR | 1 | | | | √ | | 输出 |
22 | BOVERPAY | CHAR | 1 | | | | √ | | 允许超订单付款 |
23 | BRECEIVEPLAN | CHAR | 1 | | | | √ | | 进行到货计划安排 |
24 | BSTORE | CHAR | 1 | | | | √ | | 入库 |
25 | BVMI | CHAR | 1 | | | | √ | | 供应商寄存 |
26 | CTRANTYPEID | VARCHAR2 | 20 | | | | √ | | 交易类型 |
27 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
28 | IAPPROVEAFT | NUMBER | 38 | 0 | | | √ | | 审核后置状态 |
29 | ICONFIRMAFT | NUMBER | 38 | 0 | | | √ | | 确认后置状态 |
30 | ICONSIGNAFT | NUMBER | 38 | 0 | | | √ | | 发货后置状态 |
31 | ICUSTOMAFT | NUMBER | 38 | 0 | | | √ | | 报关后置状态 |
32 | ILOADAFT | NUMBER | 38 | 0 | | | √ | | 装运后置状态 |
33 | IONWAYBEGIN | NUMBER | 38 | 0 | | | √ | | 在途开始 |
34 | IONWAYEND | NUMBER | 38 | 0 | | | √ | | 在途结束 |
35 | IOUTCUSTOMAFT | NUMBER | 38 | 0 | | | √ | | 出关后置状态 |
36 | IOUTPUTAFT | NUMBER | 38 | 0 | | | √ | | 输出后置状态 |
37 | IPRTOPOLIMIT | NUMBER | 38 | 0 | | | √ | | 请购单生成订单限制方式 |
38 | PK_GROUP | VARCHAR2 | 20 | | | | √ | | 集团 |
39 | PK_POTRANTYPE | CHAR | 20 | | √ | | | | 主键 |
40 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
41 | VTRANTYPECODE | VARCHAR2 | 20 | | | | | | 交易类型编码 |
|