Clauses for Indexes
This appendix lists the clauses for indexes.
Clauses for Indexes
This list contains base currency conversion programs, the tables they convert, and a list of known clauses for creating indexes:
|
Conversion Program (UBE) |
Table |
“Where” Index |
Does index exist? |
“Order By” Index |
Does index exist? |
|
R893002E |
F3002 |
Not applicable |
|
IXTBM, IXKIT |
Yes |
|
R890010E |
F0010 |
Not applicable |
|
CO |
Yes |
|
R8900191E |
F00191 |
SY, RT |
No |
SY, RT, KY |
Yes |
|
R8903B112E |
F03B112 |
CO |
No |
DCT, DOC, SFX |
No |
|
R8903B11E |
F03B11, F0018 |
CO |
No |
CO, KCO, DCT, DOC |
No |
|
R8903B13E |
F03B13 |
CO |
No |
CO, PYID |
No |
|
R8903B14E |
F03B14 |
CO |
No |
CO, PYID |
No |
|
R8903B16E |
F03B16 |
Not applicable |
Not applicable |
||
|
R8903B16SE |
F03B16S |
Not applicable |
Not applicable |
||
|
R8903B22E |
F03B22 |
Not applicable |
Not applicable |
||
|
R8903B23E |
F03B23 |
Not applicable |
Not applicable |
||
|
R8903B40E |
F03B40 |
CO |
No |
CO, AN8 |
No |
|
R8903B41E |
F03B41 |
CO |
No |
CO, AN8 |
No |
|
R890411E |
F0411 |
CO |
No |
KCO, DCT, DOC, SFX |
No |
|
R890413E |
F0414 |
CO |
No |
PYID |
Yes |
|
R890902BE |
F0902 |
CO, LT |
No |
CO |
No |
|
R890902E |
F0902 |
CO, LT |
No |
CO, MCU, OBJ, SUB, SBL, SBLT, CTRY, FY, FQ, LT, CRCD |
Yes |
|
R890911E |
F0911 |
CO, POST, LT |
No |
ICU, ICUT, DOC, DGJ, DCT, LT, JELN, EXTL |
No |
|
R890911EB |
F0911 |
POST, LT |
Yes |
ICU, ICUT, DOC, DGJ, DCT, LT, JELN |
No |
|
R099102 (Repost) |
F0911 |
POST, SUMM, PN, LT, CTRY, FY, LT, CO |
No |
AID, CTRY, FY, FQ, LT, SBLT, SBL, CRCD |
No |
|
R891002E |
F1002 |
Not applicable |
No |
CO |
No |
|
R891204E |
Not applicable |
Not applicable |
|||
|
R891206EB |
Not applicable |
Not applicable |
|||
|
R891301EB |
Not applicable |
Not applicable |
|||
|
R891302E |
F1302 |
CO |
No |
Not applicable |
|
|
R891304E |
F1304 |
Not applicable |
|
Not applicable |
|
|
R891602E |
F1602 |
CO, LT |
No |
CO |
No |
|
R891611E |
F1611 |
Not applicable |
No |
CO |
No |
|
R891632E |
F1632 |
Not applicable |
CO, SERK |
No |
|
|
R891721E |
F1721, F1720, F1794 |
Not applicable |
DOCO, COCH, LIND |
Yes |
|
|
R8930008E |
F30008 |
Not applicable |
IWMCU, IWLEDG |
No |
|
|
R8930026EB |
F30026 |
Not applicable |
Not applicable |
|
|
|
R893002E |
F3002 |
Not applicable |
IXTBM, IXKIT |
Yes |
|
|
R893011E |
F3011 |
Not applicable |
IZMMCU, IZKIT, IZTBM, IZCPNT, IZBQTY |
No |
|
|
R893102E |
F3102 |
Not applicable |
Not applicable |
||
|
R893111E |
F3111 |
Not applicable |
Not applicable |
||
|
R893111SE |
F3111S |
Not applicable |
Not applicable |
||
|
R893111Z1E |
F3111Z1 |
Not applicable |
Not applicable |
||
|
R8931122E |
F31122 |
Not applicable |
Not applicable |
||
|
R8931122SE |
F31122S |
Not applicable |
Not applicable |
||
|
R8931122Z1 |
F31122Z1 |
Not applicable |
Not applicable |
||
|
R893293EB |
F3293 |
Not applicable |
MCU, KIT, ATOT, ATO_2, ATOS |
Yes |
|
|
R8932961E |
|
Not applicable |
Not applicable |
||
|
R8934007E |
F34007 |
Not applicable |
MCU, AN8, ITM |
No |
|
|
R893460E |
F3460 |
Not applicable |
MCU, AN8, ITM |
No |
|
|
R894001ZEB |
F4001Z |
Not applicable |
EDOC, EDCT, EKCO, MCU, EDSP, TRDJ |
No |
|
|
R894075EB |
F4075 |
Not applicable |
Not applicable |
||
|
R894105E |
F4105 |
Not applicable |
MCU, ITM, LOCN, LOTN, LEDG, UNCS |
No |
|
|
|
F41051 |
MCU, ITM |
No |
ITM, MCU, LOCN, LOTN |
Yes |
|
R8941112E |
F41112 |
Not applicable |
MCU, DCT, FY, CTRY, ITM, LOCN, LOTN, GLPT |
No |
|
|
R894111E |
F4111 |
CO |
No |
UKID |
Yes |
|
R894115E |
F4115 |
Not applicable |
Not applicable |
||
|
R8941181E |
F41181 |
CO |
No |
KCOO, CRCD |
No |
|
R894118E |
F4118 |
CO |
No |
CO, CRCD |
No |
|
R8941291E |
F41291 |
Not applicable |
Not applicable |
||
|
R894141E |
F4141 |
Not applicable |
CYNO, LITM, MCU, LOCN, LOTN, STUN |
Yes |
|
|
R8941511E |
F41511 |
KCO |
No |
KCO, DCT, DOC |
No |
|
R8942004EB |
F42004 |
AN8, DCTO, CXPJ |
Yes |
AN8, DCTO, CXPJ |
Yes |
|
R8942008E |
F42008 |
LTYP |
No |
HCOD, MCU |
Yes |
|
R8942019E |
F42019 |
CO |
No |
KCOO, CRCD |
No |
|
F42119 |
KCOO, DOCO, DCTO |
No |
DOCO, DCTO, KCOO, LNID |
Yes |
|
|
F49219 |
KCOO, DOCO, DCTO, LNID |
No |
DOCO, DCTO, KCOO, LNID |
Yes |
|
|
F42199 |
KCOO, DOCO, DCTO, LNID |
No |
DOCO, DCTO, KCOO, LNID, UPMJ, TDAY |
Yes |
|
|
F4074 |
KCOO, DOCO, DCTO, LNID |
No |
OSEQ |
No |
|
|
F42005 |
KCOO, DOCO, DCTO, LNID |
No |
DOCO, DCTO, KCOO, LNID, SLSP |
Yes |
|
|
R894201E |
F4201 |
CO |
No |
KCOO, CRCD |
No |
|
F4211 |
KCOO, DOCO, DCTO |
No |
DOCO, DCTO, KCOO, LNID |
Yes |
|
|
F42119 |
KCOO, DOCO, DCTO |
No |
DOCO, DCTO, KCOO, LNID |
Yes |
|
|
F49211 |
KCOO, DOCO, DCTO, LNID |
No |
DOCO, DCTO, KCOO, LNID |
Yes |
|
|
F49219 |
KCOO, DOCO, DCTO, LNID |
No |
DOCO, DCTO, KCOO, LNID |
Yes |
|
|
F42199 |
KCOO, DOCO, DCTO, LNID |
No |
DOCO, DCTO, KCOO, LNID, UPMJ, TDAY |
Yes |
|
|
F4074 |
KCOO, DOCO, DCTO, LNID |
No |
OSEQ |
No |
|
|
F42005 |
KCOO, DOCO, DCTO, LNID |
No |
DOCO, DCTO, KCOO, LNID, SLSP |
Yes |
|
|
R894207EB |
F4207 |
Not applicable |
Not applicable |
|
|
|
R8942119E |
F42119 |
CO, SO13 |
No |
DOCO, DCTO, KCOO, LNID |
Yes |
|
R894211E |
F4211 |
CO, SO13 |
No |
DOCO, DCTO, KCOO, LNID |
Yes |
|
R894229E |
F4229 |
Not applicable |
Not applicable |
||
|
R894301E |
F4301 |
MCU |
No |
MCU |
No |
|
F4311 |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
|
F4311T |
Not applicable |
Not applicable |
|||
|
R8943090E |
F43090 |
MCU |
No |
MCU |
No |
|
R8943121E |
F43121 |
UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
F43121T |
Not applicable |
Not applicable |
|||
|
R8943199E |
F43199 |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
R894322E |
F4332 |
CO |
No |
CO |
No |
|
R894332E |
F4332 |
Not applicable |
No |
MCU |
No |
|
R894343E |
F4343 |
Not applicable |
Not applicable |
||
|
R8947011E |
F47011, F47012 |
EDOC |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
R8947011EB |
F47011, F47012 |
EDOC |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
R8947016E |
F47016 |
MCU |
No |
MCU |
No |
|
F470161, F470171 |
Not applicable |
Not applicable |
|||
|
F47017 |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
|
R8947021E |
F47021 |
Not applicable |
Not applicable |
||
|
F47022 |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
|
R8947026E |
F47026 |
EDSP, EKCO |
No |
EKCO, EDOC, EDCT, EDLN |
No |
|
F47027 |
EDOC, EDCT, EKCO |
Yes |
EKCO, EDOC, EDCT, EDLN |
No |
|
|
R8947027E |
F47027 |
SO13, TCST |
No |
EKCO, EDOC, EDCT, EDLN |
No |
|
R8947037E |
F470371 |
Not applicable |
EDOC, EKCO, EDCT |
No |
|
|
R8947041E |
F47041, F47044 |
Not applicable |
Not applicable |
||
|
F47042 |
CRCD |
No |
CRCD |
No |
|
|
R8947046E |
F47046 |
CO |
No |
EDOC, EDCT, EKCO |
Yes |
|
F470461 |
EDOC, EDCT, EKCO |
Yes |
EDOC, EDCT, EKCO |
Yes |
|
|
F47047 |
EDOC, EDCT, EKCO, EDLN |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
|
F470471 |
EDOC, EDCT, EKCO, EDLN |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
|
R8947047E |
F47047 |
CO |
No |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
R8947071E |
F47071 |
Not applicable |
Not applicable |
||
|
F47072 |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
|
R8947076E |
F47076 |
MCU |
No |
MCU |
No |
|
F47077 |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
|
R8947091E |
F47091, F47092 |
EDOC |
Not applicable |
||
|
R8947091EB |
F47091, F47092 |
Not applicable |
Not applicable |
||
|
R8947096E |
F47096 |
MCU |
No |
MCU |
No |
|
F47097 |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
|
R8947106E |
F47106 |
CO, EDSP |
No |
EDOC, EDCT, EKCO |
Yes |
|
EDOC, EDCT, EKCO |
Yes |
EDOC, EDCT, EKCO |
Yes |
||
|
F471061 |
EDOC, EDCT, EKCO |
Yes |
EDOC, EDCT, EKCO |
Yes |
|
|
F47107 |
EDOC, EDCT, EKCO, EDLN |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
|
F470171 |
EDOC, EDCT, EKCO, EDLN |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
|
R8947107E |
F47107 |
CO, TCST, S013 |
No |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
EDOC, EDCT, EKCO, EDLN |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
||
|
R8947122E |
F47122 |
Not applicable |
EKCO, EDOC, EDCT |
No |
|
|
R8947127E |
F47127 |
Not applicable |
EKCO, EDOC, EDCT, EDLN, UNCS, PAID |
No |
|
|
R8947131E |
F47131, F47132 |
Not applicable |
Not applicable |
||
|
R8947132E |
F47132 |
Not applicable |
Not applicable |
||
|
R8947136E |
F47136 |
MCU |
No |
MCU |
No |
|
F47137 |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
UOM1, UOM3, LNTY, ITM, MCU, CRCD |
No |
|
|
R8947141E |
F47141, F47142 |
Not applicable |
Not applicable |
||
|
R8947146E |
F47146 |
CO, EDSP |
No |
EDOC, EDCT, EKCO |
Yes |
|
EDOC, EDCT, EKCO |
Yes |
EDOC, EDCT, EKCO |
Yes |
||
|
F47147 |
EDOC, EDCT, EKCO, EDLN |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
|
R8947147E |
F47147 |
CO, TCST, S013 |
No |
EDOC, EDCT, EKCO, EDLN |
Yes |
|
EDOC, EDCT, EKCO, EDLN |
Yes |
EDOC, EDCT, EKCO, EDLN |
Yes |
||
|
R894722E |
F4722 |
CO |
No |
EDST, AN8, EDER, CO |
Yes |
|
EDST, AN8, EDER, CO |
Yes |
EDST, AN8, EDER, CO |
Yes |
||
|
R894801E |
F4801 |
CO |
No |
Not applicable |
|
|
R894812E |
F4812 |
WDCO |
No |
WDDGL, WDPRSQ, WDSBSQ, WDSCSQ, WDBCI, WDSLNK, WDCLNK, WDCCOD |
Yes |
|
R894812HE |
F4812H |
WDCO |
No |
WDDGL, WDPRSQ, WDSBSQ, WDSCSQ, WDBCI, WDSLNK, WDCLNK, WDCCOD |
Yes |
|
R894822EB |
F4822 |
WDSFX, WDCO |
No |
WDDOCZ, WDDCTI, WDKCOI, WDSFX |
Yes |
|
R8948520EB |
F48520 |
WDCO |
No |
WDDOCO, WDDCTO, DKCOO, WDCOCH, WDLNID, WDAN8, WDMCU, WDOBJ, WDSUB, WDCCOD, WDCRCD, WDCRCF, WDDGL |
Yes |
|
R894915E |
F4215, F4942 |
ISSHPN |
Yes |
XHSHPN, ISSHPN, ISRSSN, ISDOCO, ISDCTO, ISKCOO, ISLNID |
No |
|
R8949332EB |
F40332, F4941 |
RSSHPN, RSRSSN |
Yes |
RSSHPN, RSRSSN |
Yes |
|
R894941E |
F4941, F4215 |
Not applicable |
RSSHPN, RSRSSN |
Yes |
|
|
R894945E |
F4945, F4941, F4215, F4960 |
RSDLNO, XHSHPN, TMVMCU |
No |
SCSHPN, SCRSSN, RSDLNO, RSSHPN, RSRSSN, XHSHPN, TMVMCU |
No |
|
R894950E |
F4950 |
Not applicable |
RTRTN |
Yes |
|
|
R894960E |
F4960 |
Not applicable |
TMVMCU, TMLDNM |
Yes |
|
|
R8949631E |
F49631 |
Not applicable |
TOUKID |
Yes |
|
|
R894963E |
F49631 |
Not applicable |
TIVMCU, TILDNM, TISHPN, TIITM, TILOTN, TIAN8 |
Yes |
|
|
R8949721EB |
F49721 |
Not applicable |
Not applicable |
|
|
|
R894972EB |
F4972 |
Not applicable |
RXRTNM |
Yes |
|
|
R894973EB |
F4973 |
Not applicable |
TLRTNM, TLOSEQ, TLLUTK |
Yes |
|
|
R894977EB |
F4977 |
Not applicable |
MRCARS, MRRTNM |
Yes |
|
|
R894981E |
F4981 |
Not applicable |
FHSHPN, FHRSSN |
Yes |
|
|
R895202EB |
F5202 |
G6CO |
No |
G6DOCO, G6DCTO, G6KCOO, G6COCH, G6LNID |
Yes |