此表包含关于不同本地货币的信息。货币的字母和数字代码派生于 ISO 4217 标准。
列名 | 列类型 | 列描述 |
---|---|---|
SETCCODE | INTEGER
NOT NULL |
数字货币代码,例如 ISO 4217。 |
SETCCURR | CHARACTER (3)
NOT NULL |
根据 ISO 4217 的字母货币代码。这是主关键字。 |
SETCEXP | INTEGER
NOT NULL |
指数(10 的乘方)。指数值,货币子单位(例如,分)乘以它就得到了主货币单位。例如,用 10 的“-2”次方乘分数得到美元数。 |
SETCNOTE | VARCHAR (40) NULL |
可定制。此列不翻译。描述此表中的货币的可翻译文本存储在 SETCURRDSC 表中。 |
索引名 | 建立了索引的列名 | 索引类型 |
---|---|---|
SQL030416035103640 | SETCCURR | 主键 |
约束名称 | 列名 | 外表名 | 外列名 | 约束类型 |
---|---|---|---|---|
约束名称 | 引用列名 | 外表名 | 外列名 | 约束类型 |
---|---|---|---|---|
F_136 | SETCCURR | BUYERPO | SETCCURR | 级联 |
F_167 | SETCCURR | CALRLOOKUP | SETCCURR | 级联 |
F_175 | SETCCURR | CALSCALE | SETCCURR | 级联 |
F_268 | SETCCURR | CPPMN | SETCCURR | 级联 |
F_278 | SETCCURR | CREDITLINE | SETCCURR | 级联 |
F_284 | SETCCURR | CURCONVERT | TOCURR | 级联 |
F_285 | SETCCURR | CURCONVERT | FROMCURR | 级联 |
F_287 | SETCCURR | CURCVLIST | COUNTERVALUECURR | 级联 |
F_288 | SETCCURR | CURCVLIST | CURRSTR | 级联 |
F_294 | SETCCURR | CURFORMAT | SETCCURR | 级联 |
F_295 | SETCCURR | CURLIST | CURRSTR | 级联 |
F_377 | SETCCURR | ICTPRICES | SETCCURR | 级联 |
F_418 | SETCCURR | LISTPRICE | CURRENCY | 级联 |
F_422 | SETCCURR | LPOPURAMT | SETCCURR | 级联 |
F_426 | SETCCURR | MANIFEST | SETCCURR | 级联 |
F_473 | SETCCURR | OFFERPRICE | CURRENCY | 级联 |
F_580 | SETCCURR | PAYSUMMARY | SETCCURR | 级联 |
F_662 | SETCCURR | RECEIPT | SETCCURR | 级联 |
F_667 | SETCCURR | REFUNDMTHD | SETCCURR | 级联 |
F_678 | SETCCURR | RFQPROD | CURRENCY | 级联 |
F_687 | SETCCURR | RFQRSPPROD | CURRENCY | 级联 |
F_742 | SETCCURR | SETCURRDSC | SETCCURR | 级联 |
F_789 | SETCCURR | STOREENT | SETCCURR | 级联 |
F_800 | SETCCURR | STORELANG | SETCCURR | 级联 |
F_869 | SETCCURR | TRDDEPAMT | SETCCURR | 级联 |
F_875 | SETCCURR | TRDPURAMT | SETCCURR | 级联 |
F_879 | SETCCURR | TRDREFAMT | SETCCURR | 级联 |
F_898 | SETCCURR | USERS | SETCCURR | 级联 |