ETCUCONV FILE
UPDATED BY
ET700
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ET4-EXCH-ID Numeric 10
Element: Numeric 1
ET4-EXCH-CURTBL-ID Numeric 10 ET700
Element: Numeric 1
ET4-EXCH-FROM-CURR Numeric 10 ET700
Element: Numeric 1
ET4-EXCH-TO-CURR Numeric 10 ET700
Element: Numeric 1
ET4-EXCH-EFEC-DATE Numeric 8 (yyyymmdd) ET700
Element: Date
ET4-EXCH-RATE Signed 18.7 ET700
Element: Psa Rate52
ETCUCONV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ET4SET1 EXCH-ID
ET4SET2 EXCH-CURTBL-ID ET700
EXCH-FROM-CURR
EXCH-TO-CURR
EXCH-EFEC-DATE*
ETCUCONV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Etcurelat ETCURELAT Required
ET4-EXCH-CURTBL-ID -> ET3-CURREL-CURTBL
ET4-EXCH-FROM-CURR -> ET3-CURREL-FRM-CUR
ET4-EXCH-TO-CURR -> ET3-CURREL-TO-CUR
Fr Etcucodes ETCUCODES Required
ET4-EXCH-FROM-CURR -> ET1-CURRCD-ID
To Etcucodes ETCUCODES Required
ET4-EXCH-TO-CURR -> ET1-CURRCD-ID
|