MM_SAOPTION 分析选项返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BDEPT | VARCHAR2 | 1 | | | | √ | | 部门 |
2 | BENABLELOG | CHAR | 1 | | | | √ | | 启用日志 |
3 | BILLTYPE | VARCHAR2 | 20 | | | | √ | '~' | 单据配置方案 |
4 | BLANKETORDER | VARCHAR2 | 1 | | | | √ | | 总括订单 |
5 | CONTRACTIN | VARCHAR2 | 1 | | | | √ | | 进口合同 |
6 | CREATIONTIME | VARCHAR2 | 19 | | | | √ | | 创建时间 |
7 | CREATOR | VARCHAR2 | 20 | | | | √ | '~' | 创建人 |
8 | DELIVERYSCHEDULE | VARCHAR2 | 1 | | | | √ | | 到货计划 |
9 | DMO | VARCHAR2 | 1 | | | | √ | | 离散生产订单 |
10 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
11 | FDEMANDTYPE | NUMBER | 38 | 0 | | | √ | | 需求类型 |
12 | HISTORYSUPPLYNUM | NUMBER | 38 | 0 | | | √ | 0 | 历史供给天数 |
13 | ISDISSIPATION | VARCHAR2 | 1 | | | | √ | | 子件损耗 |
14 | MPS | CHAR | 1 | | | | √ | | 主生产计划 |
15 | MULTISET | VARCHAR2 | 1 | | | | √ | | 多层齐套 |
16 | PK_GROUP | VARCHAR2 | 20 | | | | √ | '~' | 集团 |
17 | PK_OPTION | CHAR | 20 | | √ | | | | 分析选项主键 |
18 | PK_ORG | VARCHAR2 | 20 | | | | √ | '~' | 工厂最新版本 |
19 | PK_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 工厂 |
20 | PMO | VARCHAR2 | 1 | | | | √ | | 流程生产订单 |
21 | PO | VARCHAR2 | 1 | | | | √ | | 计划订单 |
22 | PURSCHEDULE | VARCHAR2 | 1 | | | | √ | | 采购排程 |
23 | SCMPO | VARCHAR2 | 1 | | | | √ | | 采购订单 |
24 | SCMPRAY | VARCHAR2 | 1 | | | | √ | | 请购单 |
25 | SINGLESET | VARCHAR2 | 1 | | | | √ | | 单层齐套 |
26 | STOCK | VARCHAR2 | 1 | | | | √ | | 存量 |
27 | TRANSA | VARCHAR2 | 1 | | | | √ | | 调拨订单 |
28 | TRANSP | VARCHAR2 | 1 | | | | √ | | 调入申请 |
29 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
30 | WWBILL | VARCHAR2 | 1 | | | | √ | | 委外订单 |
|