Table B-6 TPOVPARTITION 表格定義
| TPOVPARTITION 欄 | TPOVPARTITION 定義 |
|---|---|
| PARTITIONKEY | NUMBER(10,0) NOT NULL ENABLE |
| PARTNAME | VARCHAR2(20 CHAR) NOT NULL ENABLE |
| PARTDESC | VARCHAR2(100 CHAR) DEFAULT NULL |
| PARTNOTES | VARCHAR2(255 CHAR) DEFAULT NULL |
| PARTLASTIMPFILE | VARCHAR2(250 CHAR) DEFAULT NULL |
| PARTLASTEXPFILE | VARCHAR2(250 CHAR) DEFAULT NULL |
| PARTIMPGROUP | VARCHAR2(20 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTLOGICGROUP | VARCHAR2(20 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTVALGROUP | VARCHAR2(20 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTVALENTGROUP | VARCHAR2(20 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTCURRENCYKEY | VARCHAR2(25 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTPARENT | VARCHAR2(20 CHAR) DEFAULT NULL |
| PARTTYPE | NUMBER(6,0) DEFAULT 2 NOT NULL ENABLE |
| PARTSEQMAP | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PARTDATAVALUE | VARCHAR2(100 CHAR) DEFAULT NULL, |
| PARTSEGMENTKEY | NUMBER(6,0) DEFAULT 1 NOT NULL ENABLE, |
| PARTCONTROLSTYPE | NUMBER(10,0) DEFAULT 1 NOT NULL ENABLE |
| PARTCONTROLSGROUP1 | VARCHAR2(80 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTCONTROLSGROUP2 | VARCHAR2(80 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTCONTROLSAPPROVER | VARCHAR2(255 CHAR) DEFAULT NULL |
| PARTCONTROLSAPPROVERPROXY | VARCHAR2(255 CHAR) DEFAULT NULL |
| PARTCONTROLSREDFLAGLEVEL | NUMBER(10,0) DEFAULT 6 NOT NULL ENABLE |
| PARTCLOGICGROUP | VARCHAR2(20 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTINTGCONFIG1 | VARCHAR2(300 CHAR) DEFAULT NULL |
| PARTINTGCONFIG2 | VARCHAR2(300 CHAR) DEFAULT NULL |
| PARTINTGCONFIG3 | VARCHAR2(300 CHAR) DEFAULT NULL |
| PARTINTGCONFIG4 | VARCHAR2(300 CHAR) DEFAULT NULL |
| PARTADAPTOR | VARCHAR2(10 CHAR) DEFAULT '[NONE]' NOT NULL ENABLE |
| PARTSOURCESYSTEMID | NUMBER(15,0) |
| PARTSOURCELEDGERID | NUMBER(15,0) |
| PARTTARGETAPPLICATIONID | NUMBER(15,0) |
| PARTPARENTKEY | NUMBER(10,0) |
| PARTSOURCEAPPLICATIONID | NUMBER(15,0) |
| PARTTARGETSOURCESYSTEMID | NUMBER(15,0) |