此表中的每行代表一个 QuantityUnit。QuantityUnit 是计量单位,例如千克、米、公升、镑、英尺、夸脱等。
注意:不要除去缺省 QTYUNIT_ID C62(无单位单元)的行。
列名 | 列类型 | 列描述 |
---|---|---|
FIELD1 | VARCHAR (254)
NULL |
可定制。 |
QTYUNIT_ID | CHARACTER (16)
NOT NULL |
唯一指定的标识。按照 UN/CEFACT Working Party on Facilitation of International Trade Procedures (WP.4), Recommendation No. 20, Codes for Units of Measure Used in International Trade 中的指定定义若干标识。 |
索引名 | 建立了索引的列名 | 索引类型 |
---|---|---|
SQL030416035045340 | QTYUNIT_ID | 主键 |
约束名称 | 列名 | 外表名 | 外列名 | 约束类型 |
---|---|---|---|---|
约束名称 | 引用列名 | 外表名 | 外列名 | 约束类型 |
---|---|---|---|---|
F_1017 | QTYUNIT_ID | ATTRVALUE | QTYUNIT_ID | 级联 |
F_1018 | QTYUNIT_ID | ATTRIBUTE | QTYUNIT_ID | 级联 |
F_107 | QTYUNIT_ID | BASEITEM | QUANTITYMEASURE | 级联 |
F_178 | QTYUNIT_ID | CALSCALE | QTYUNIT_ID | 级联 |
F_206 | QTYUNIT_ID | CATENTSHIP | QUANTITYMEASURE | 级联 |
F_207 | QTYUNIT_ID | CATENTSHIP | SIZEMEASURE | 级联 |
F_208 | QTYUNIT_ID | CATENTSHIP | WEIGHTMEASURE | 级联 |
F_394 | QTYUNIT_ID | INVENTORY | QUANTITYMEASURE | 级联 |
F_425 | QTYUNIT_ID | MANIFEST | WEIGHTMEASURE | 级联 |
F_469 | QTYUNIT_ID | OFFER | QTYUNIT_ID | 级联 |
F_572 | QTYUNIT_ID | PATTRVALUE | QTYUNIT_ID | 级联 |
F_640 | QTYUNIT_ID | QTYCONVERT | QTYUNIT_ID_FROM | 级联 |
F_641 | QTYUNIT_ID | QTYCONVERT | QTYUNIT_ID_TO | 级联 |
F_646 | QTYUNIT_ID | QTYFORMAT | QTYUNIT_ID | 级联 |
F_648 | QTYUNIT_ID | QTYUNITDSC | QTYUNIT_ID | 级联 |
F_649 | QTYUNIT_ID | QTYUNITMAP | QTYUNIT_ID | 级联 |
F_679 | QTYUNIT_ID | RFQPROD | QTYUNIT_ID | 级联 |
F_688 | QTYUNIT_ID | RFQRSPPROD | QTYUNIT_ID | 级联 |