数据库表:SETCURR

此表包含关于不同本地货币的信息。货币的字母和数字代码派生于 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 级联