The following table details the relationships defined in the framework, including the relation names, columns, and types:
|
Relation Name |
Relation Columns |
Relation Type |
|---|---|---|
|
R5ACTIONCODES <--> R5ACTCLASSES |
R5ACTIONCODES.ACC_CODE = R5ACTCLASSES.ACL_ACTION |
R5ACTIONCODES left outer join R5ACTCLASSES |
|
R5ACTIVITIES <--> R5ACTQUALIFICATIONS |
R5ACTIVITIES.ACT_ACT = R5ACTQUALIFICATIONS.AQU_ACTIVITY AND R5ACTIVITIES.ACT_EVENT = R5ACTQUALIFICATIONS.AQU_EVENT |
R5ACTIVITIES left outer join R5ACTQUALIFICATIONS |
|
R5ACTIVITIES <--> R5ACTSCHEDULES |
R5ACTIVITIES.ACT_EVENT = R5ACTSCHEDULES.ACS_EVENT and R5ACTIVITIES.ACT_ACT = R5ACTSCHEDULES.ACS_ACTIVIT |
R5ACTIVITIES full outer join R5ACTSCHEDULES |
|
R5ACTIVITIES <--> R5ADDITIONALCHARGE |
R5ACTIVITIES.ACT_EVENT = R5ADDITIONALCHARGE.ADC_EVENT and R5ACTIVITIES.ACT_ACT= R5ADDITIONALCHARGE.ADC_ACT |
R5ACTIVITIES left outer join R5ADDITIONALCHARGE |
|
R5ACTIVITIES <--> R5MATLISTS |
R5ACTIVITIES.ACT_EVENT = R5MATLISTS.MTL_EVENT and R5ACTIVITIES.ACT_ACT = R5MATLISTS.MTL_ACT |
R5ACTIVITIES full outer join R5MATLISTS |
|
R5ACTIVITIES <--> R5ORDERLINES |
R5ACTIVITIES.ACT_EVENT = R5ORDERLINES.ORL_EVENT and R5ACTIVITIES.ACT_ACT = R5ORDERLINES.ORL_ACT |
R5ACTIVITIES full outer join R5ORDERLINES |
|
R5ACTIVITIES <--> R5PICKLISTS |
R5ACTIVITIES.ACT_EVENT = R5PICKLISTS.PIC_EVENT and R5ACTIVITIES.ACT_ACT = R5PICKLISTS.PIC_ACT |
R5ACTIVITIES full outer join R5PICKLISTS |
|
R5ACTIVITIES <--> R5QUOTLINES |
R5ACTIVITIES.ACT_EVENT = R5QUOTLINES.QUL_EVENT and R5ACTIVITIES.ACT_ACT = R5QUOTLINES.QUL_ACT |
R5ACTIVITIES full outer join R5QUOTLINES |
|
R5ACTIVITIES <--> R5QUOTTASKS |
R5ACTIVITIES.ACT_EVENT = R5QUOTTASKS.QUT_EVENT and R5ACTIVITIES.ACT_ACT = R5QUOTTASKS.QUT_ACT |
R5ACTIVITIES left outer join R5QUOTTASKS |
|
R5ACTIVITIES <--> R5REQUISITIONS |
R5ACTIVITIES.ACT_EVENT = R5REQUISITIONS.REQ_EVENT and R5ACTIVITIES.ACT_ACT = R5REQUISITIONS.REQ_ACT |
R5ACTIVITIES full outer join R5REQUISITIONS |
|
R5ACTIVITIES <--> R5REQUISLINES |
R5ACTIVITIES.ACT_EVENT = R5REQUISLINES.RQL_EVENT and R5ACTIVITIES.ACT_ACT = R5REQUISLINES.RQL_ACT |
R5ACTIVITIES full outer join R5REQUISLINES |
|
R5ACTIVITIES <--> R5RESERVATIONS |
R5ACTIVITIES.ACT_EVENT = R5RESERVATIONS.RES_EVENT and R5ACTIVITIES.ACT_ACT = R5RESERVATIONS.RES_ACT |
R5ACTIVITIES left outer join R5RESERVATIONS |
|
R5ACTIVITIES <--> R5SUPPEVALUATION |
R5ACTIVITIES.ACT_EVENT = R5SUPPEVALUATION.EVA_EVENT and R5ACTIVITIES.ACT_ACT = R5SUPPEVALUAUION.EVA_ACT |
R5ACTIVITIES full outer join R5SUPPEVALUATION |
|
R5ACTIVITIES <--> R5TOOLREQ |
R5ACTIVITIES.ACT_EVENT = R5TOOLREQ.TOR_EVENT and R5ACTIVITIES.ACT_ACT = R5TOOLREQ.TOR_ACT |
R5ACTIVITIES left outer join R5TOOLREQ |
|
R5ACTIVITIES <--> R5TOOLUSAGE |
R5ACTIVITIES.ACT_EVENT = R5TOOLUSAGE.TOU_EVENT and R5ACTIVITIES.ACT_ACT = R5TOOLUSAGE.TOU_ACT |
R5ACTIVITIES left outer join R5TOOLUSAGE |
|
R5ACTIVITIES <--> R5TRANSLINES |
R5ACTIVITIES.ACT_EVENT = R5TRANSLINES.TRL_EVENT and R5ACTIVITIES.ACT_ACT = R5TRANSLINES.TRL_ACT |
R5ACTIVITIES full outer join R5TRANSLINES |
|
R5AGREEMENTS <--> R5CALCEVENTS |
R5AGREEMENTS.AGR_CODE = R5CALCEVENTS.CEV_AGREEMENT |
R5AGREEMENTS full |
|
R5AGREEMENTS <--> R5FIXEDPAYMENTS |
R5AGREEMENTS.AGR_CODE = R5FIXEDPAYMENTS.FPA_AGREEMENT |
R5AGREEMENTS left outer join R5FIXEDPAYMENTS |
|
R5APPROVELISTS<--> R5APPROVEUSERS |
R5APPROVELISTS.APL_CODE = R5APPROVEUSERS.APU_LIST |
R5APPROVELISTS left outer join R5APPROVEUSERS |
|
R5APPROVELISTS<--> R5ENTAPPHEADER |
R5APPROVELISTS.APL_CODE = R5ENTAPPHEADER.EAH_APPLIST |
R5APPROVELISTS full outer join R5ENTAPPHEADER |
|
R5ARRANGEMENTS<--> R5AGREEMENTS |
R5ARRANGEMENTS.ARR_CODE = R5AGREEMENTS.AGR_ARRANGEMENT |
R5ARRANGEMENTS full outer join R5AGREEMENTS |
|
R5ARRANGEMENTS<--> R5ARRJOBS |
R5ARRANGEMENTS.ARR_CODE = R5ARRJOBS.AJO_ARRANGEMENT |
R5ARRANGEMENTS left outer join R5ARRJOBS |
|
R5ARRANGEMENTS<--> R5ARRPARTS |
R5ARRANGEMENTS.ARR_CODE = R5ARRPARTS.APA_ARRANGEMENT |
R5ARRANGEMENTS left outer join R5ARRPARTS |
|
R5ARRANGEMENTS<--> R5ARRPRICES |
R5ARRANGEMENTS.ARR_CODE = R5ARRPRICES.ARP_ARRANGEMENT |
R5ARRANGEMENTS left outer join R5ARRPRICES |
|
R5ARRANGEMENTS<--> R5EXTTARIFFS |
R5ARRANGEMENTS.ARR_CODE = R5EXTTARIFFS.ETA_ARRANGEMENT |
R5ARRANGEMENTS left outer join R5EXTTARIFFS |
|
R5ASPECTPOINTS<--> R5POINTCONDITIO NS |
R5ASPECTPOINTS.APO_OBJEC T = R5POINTCONDITIONS.POC_OBJECT and R5ASPECTPOINTS.APO_OBJECT_ORG = R5POINTCONDITIONS.POC_OBJECT_ORG and R5ASPECTPOINTS.APO_OBTYPE = R5POINTCONDITIONS.POC_OBTYPE and R5ASPECTPOINTS.APO_ASPECT = R5POINTCONDITIONS.POC_ASPECT and R5ASPECTPOINTS.APO_POINT = R5POINTCONDITIONS.POC_POINT and R5ASPECTPOINTS.APO_POINTTYPE = R5POINTCONDITIONS.POC_POINTTYPE |
R5ASPECTPOINTS full outer join R5POINTCONDITIONS |
|
R5ASPECTS <--> R5ASPECTPROMPTS |
R5ASPECTS.ASP_CODE = R5ASPECTPROMPTS.APM_ASPECT |
R5ASPECTS left outer join R5ASPECTPROMPTS |
|
R5ASPECTS <--> R5EVENTASPECTS |
R5ASPECTS.ASP_CODE = R5EVENTASPECTS.EAS_ASPECT |
R5ASPECTS left outer join R5EVENTASPECTS |
|
R5ASPECTS <--> R5OBJECTASPECTS |
R5ASPECTS.ASP_CODE = R5OBJECTASPECTS.OBA_ASPECT |
R5ASPECTS left outer join R5OBJECTASPECTS |
|
R5ASPECTS <--> R5POINTCONDITIONS |
R5ASPECTS.ASP_CODE = R5POINTCONDITIONS.POC_ASPECT |
R5ASPECTS full outer join R5POINTCONDITIONS |
|
R5ASPECTS <--> R5PROMPTVALUES |
R5ASPECTS.ASP_CODE = R5PROMPTVALUES.PMV_ASPECT |
where (R5ASPECTS.AS P_CODE = R5PROMPTVALUES.PMV_ASPECT) |
|
R5AUDATTRIBS <--> R5AUDVALUES |
R5AUDATTRIBS.AAT_CODE = R5AUDVALUES.AVA_ATTRIBUTE |
R5AUDATTRIBS full outer join R5AUDVALUES |
|
R5BILLINGADJUSTM ENTS <--> R5FLEETBILLSUBLINES |
R5BILLINGADJUSTMENTS.FBA_ PK = R5FLEETBILLSUBLINES.FBS_ADJPK |
R5BILLINGADJUSTMENTS full outer join R5FLEETBILLSUBLINES |
|
R5BINS <--> R5BINSTOCK |
R5BINS.BIN_STORE = R5BINSTOCK.BIS_STORE and R5BINS.BIN_CODE = R5BINSTOCK.BIS_BIN |
R5BINS left outer join R5BINSTOCK |
|
R5BINS <--> R5OBJECTS |
R5BINS.BIN_STORE = R5OBJECTS.OBJ_STORE and R5BINS.BIN_CODE = R5OBJECTS.OBJ_BIN |
R5BINS full outer join R5OBJECTS |
|
R5BINS <--> R5STOCK |
R5BINS.BIN_STORE = R5STOCK.STO_STORE and R5BINS.BIN_CODE = R5STOCK.STO_DEFAULTBIN |
R5BINS full outer join R5STOCK |
|
R5BINS <--> R5TRANSLINES |
R5BINS.BIN_STORE = R5TRANSLINES.TRL_STORE and R5BINS.BIN_CODE = R5TRANSLINES.TRL_BIN |
R5BINS full outer join R5TRANSLINES |
|
R5BINSTOCK <--> R5REPAIRBINS |
R5BINSTOCK.BIS_STORE = R5REPAIRBINS.RPB_STORE and R5BINSTOCK.BIS_PART = R5REPAIRBINS.RPB_PART and R5BINSTOCK.BIS_PART_ORG = R5REPAIRBINS.RPB_PART_ORG and R5BINSTOCK.BIS_BIN = R5REPAIRBINS.RPB_BIN and R5BINSTOCK.BIS_LOT = R5REPAIRBINS.RPB_LOT |
R5BINSTOCK full outer join R5REPAIRBINS |
|
R5BLANKETORDERS<--> R5BLANKETORDCLAUSES |
R5BLANKETORDERS.BLO_BLANKETORDER = R5BLANKETORDCLAUSES.BLC_BLANKETORDER |
R5BLANKETORDERS left outer join R5BLANKETORDCLAUSES |
|
R5BLANKETORDERS<--> R5BLANKETORDLIN ES |
R5BLANKETORDERS.BLO_BLANKETORDER = R5BLANKETORDLINES.BLL_BLANKETORDER |
R5BLANKETORDERS left outer join R5BLANKETORDLINES |
|
R5BLANKETORDERS<--> R5BLANKETORDUSERS |
R5BLANKETORDERS.BLO_BLANKETORDER = R5BLANKETORDUSERS.BLU_BLANKETORDER |
R5BLANKETORDERS left outer join R5BLANKETORDUSERS |
|
R5BLANKETORDERS<--> R5ORDERS |
R5BLANKETORDERS.BLO_BLANKETORDER = R5ORDERS.ORD_BLANKETORDER |
R5BLANKETORDERS full outer join R5ORDERS |
|
R5BLANKETORDERS<--> R5REQUISLINES |
R5BLANKETORDERS.BLO_BLANKETORDER = R5REQUISLINES.RQL_BLANKETORDER |
R5BLANKETORDERS full outer join R5REQUISLINES |
|
R5BUDGETDETAILS <--> R5BUDGETAMOUNTS |
R5BUDGETDETAILS.BDT_CODE = R5BUDGETAMOUNTS.BDA_CODE |
R5BUDGETDETAILS left outer join R5BUDGETAMOUNTS |
|
R5BUDGETGROUPS<--> R5BUDGETDETAILS |
R5BUDGETGROUPS.BGR_CODE = R5BUDGETDETAILS.BDT_MRCG R |
R5BUDGETGROUPS full outer join R5BUDGETDETAILS |
|
R5BUDGETGROUPS<--> R5BUDGETITEMS |
R5BUDGETGROUPS.BGR_CODE = R5BUDGETITEMS.BIT_GROUP |
R5BUDGETGROUPS left outer join R5BUDGETITEMS |
|
R5BUDGETS <--> R5BUDGETDETAILS |
R5BUDGETS.BUD_YEAR = R5BUDGETDETAILS.BDT_YEAR AND R5BUDGETS.BUD_CODE = R5BUDGETDETAILS.BDT_BUDGET |
R5BUDGETS full outer join R5BUDGETDETAILS |
|
R5BUDGETSTRUCTURE <--> R5BUDGETS |
R5BUDGETSTRUCTURE.BUS_CODE = R5BUDGETS.BUD_CODE |
R5BUDGETSTRUCTURE left outer join R5BUDGETS |
|
R5BUDGETSTRUCTURE <--> R5BUDGETSTRUCTURE |
R5BUDGETSTRUCTURE.BUS_CODE = R5BUDGETSTRUCTURE.BUS_PARENT |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5BZSNAP_A <--> R5BZSNAP_B |
R5BZSNAP_A.H_CODE = R5BZSNAP_B.L_PARENT |
PROMPT VALUES SCREEN |
|
R5CALCEVENTS <--> R5CALCEVTLINES |
R5CALCEVENTS.CEV_INCREMENT = R5CALCEVTLINES.CEL_INCREMENT AND R5CALCEVENTS.CEV_EVENT = R5CALCEVTLINES.CEL_EVENT |
R5CALCEVENTS left outer join R5CALCEVTLINES |
|
R5CALENDARS <--> R5BUDGETSTRUCTURE |
R5CALENDARS.CAL_CODE = R5BUDGETSTRUCTURE.BUS_CAL |
R5CALENDARS full outer join R5BUDGETSTRUCTURE |
|
R5CALENDARS <--> R5YEARS |
R5CALENDARS.CAL_CODE = R5YEARS.ACY_CAL |
R5CALENDARS full outer join R5YEARS |
|
R5CATALOGUE <--> R5CONVUOM |
R5CATALOGUE.CAT_PART_ORG = R5CONVUOM.CNV_PART_ORG AND R5CATALOGUE.CAT_SUPPLIER = R5CONVUOM.CNV_SUPPLIER AND R5CATALOGUE.CAT_SUPPLIER_ORG = R5CONVUOM.CNV_SUPPLIER_ORG AND R5CATALOGUE.CAT_PART = R5CONVUOM.CNV_PART |
R5CATALOGUE left outer join R5CONVUOM |
|
R5CATALOGUE <--> R5REDUCTIONS |
R5CATALOGUE.CAT_PART = R5REDUCTIONS.RED_PART and R5CATALOGUE.CAT_PART_ORG = R5REDUCTIONS.RED_PART_ORG and R5CATALOGUE.CAT_SUPPLIER = R5REDUCTIONS.RED_SUPPLIER and R5CATALOGUE.CAT_SUPPLIER_ORG = R5REDUCTIONS.RED_SUPPLIER_ORG |
R5CATALOGUE left outer join R5REDUCTIONS |
|
R5CAUSES <--> R5CAUSECLASSES |
R5CAUSES.CAU_CODE = R5CAUSECLASSES.CAC_CAUSE |
R5CAUSES left outer join R5CAUSECLASSES |
|
R5CHANGENOTICE<--> R5CNHIST |
R5CHANGENOTICE.CNH_CODE = R5CNHIST.CNI_CN |
R5CHANGENOTICE full outer join R5CNHIST |
|
R5CHANGENOTICE<--> R5CNLOCATIONS |
R5CHANGENOTICE.CNH_CODE = R5CNLOCATIONS.CNC_CN |
R5CHANGENOTICE left outer join R5CNLOCATIONS |
|
R5CHANGENOTICE<--> R5OBJECTS |
R5CHANGENOTICE.CNH_CODE = R5OBJECTS.OBJ_CN |
where (R5CHANGENOT ICE.CNH_CODE = R5OBJECTS.OBJ_CN) |
|
R5CHANGENOTICE<--> R5OBJECTS |
R5CHANGENOTICE.CNH_CODE = R5OBJECTS.OBJ_CN |
R5CHANGENOTICE full outer join R5OBJECTS |
|
R5CLASSES <--> R5ADDPROPERTIES |
R5CLASSES.CLS_RENTITY = R5ADDPROPERTIES.APR_RENTITY and R5CLASSES.CLS_CODE = R5ADDPROPERTIES.APR_CLASS and R5CLASSES.CLS_ORG = R5ADDPROPERTIES.APR_CLASS_ORG |
R5CLASSES left outer join R5ADDPROPERTIES |
|
R5COMMANDS <--> R5FUNCTIONS |
R5COMMANDS.CMD_CODE = R5FUNCTIONS.FUN_COMMAND |
R5COMMANDS full outer join R5FUNCTIONS |
|
R5COMMODITIES <--> R5BLANKETORDLINES |
R5COMMODITIES.CMD_CODE = R5BLANKETORDLINES.BLL_COMMODITY |
R5COMMODITIES full outer join R5BLANKETORDLINES |
|
R5COMMODITIES <--> R5COMPCOMMODITIES |
R5COMMODITIES.CMD_CODE = R5COMPCOMMODITIES.CCM_COMMODITY |
R5COMMODITIES left outer join R5COMPCOMMODITIES |
|
R5COMMODITIES <--> R5PARTS |
R5COMMODITIES.CMD_CODE = R5PARTS.PAR_COMMODITY |
R5COMMODITIES full outer join R5PARTS |
|
R5COMMODITIES <--> R5REQUISLINES |
R5COMMODITIES.CMD_CODE = R5REQUISLINES.RQL_COMMODITY |
R5COMMODITIES full outer join R5REQUISLINES |
|
R5COMMODITIES <--> R5TASKS |
R5COMMODITIES.CMD_CODE = R5TASKS.TSK_COMMODITY |
R5COMMODITIES full outer join R5TASKS |
|
R5COMPANIES <--> R5ACTIVITIES |
R5COMPANIES.COM_CODE = R5ACTIVITIES.ACT_SUPPLIER and R5COMPANIES.COM_ORG = R5ACTIVITIES.ACT_SUPPLIER_ORG |
R5COMPANIES full outer join R5ACTIVITIES |
|
R5COMPANIES <--> R5BLANKETORDERS |
R5COMPANIES.COM_CODE = R5BLANKETORDERS.BLO_SUPPLIER and R5COMPANIES.COM_ORG = R5BLANKETORDERS.BLO_SUPPLIER_ORG |
R5COMPANIES full outer join R5BLANKETORDERS |
|
R5COMPANIES <--> R5CALGROUPS |
R5COMPANIES.COM_CODE = R5CALGROUPS.CLG_CONTRAC TOR and R5COMPANIES.COM_ORG = R5CALGROUPS.CLG_CONTRACTOR_ORG |
R5COMPANIES full outer join R5CALGROUPS |
|
R5COMPANIES <--> R5CATALOGUE |
R5COMPANIES.COM_CODE = R5CATALOGUE.CAT_SUPPLIER and R5COMPANIES.COM_ORG = R5CATALOGUE.CAT_SUPPLIER_ORG |
R5COMPANIES left outer join R5CATALOGUE |
|
R5COMPANIES <--> R5COMPANIES |
R5COMPANIES.COM_CODE = R5COMPANIES.COM_PARENT and R5COMPANIES.COM_ORG = R5COMPANIES.COM_PARENT_ORG |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5COMPANIES <--> R5COMPCOMMODITIES |
R5COMPANIES.COM_CODE = R5COMPCOMMODITIES.CCM_COMPANY and R5COMPANIES.COM_ORG = R5COMPCOMMODITIES.CCM_COMPANY_ORG |
R5COMPANIES left outer join R5COMPCOMMODITIES |
|
R5COMPANIES <--> R5CONPARTS |
R5COMPANIES.COM_ORG = R5CONPARTS.CPA_SUPPLIER_ORG AND R5COMPANIES.COM_CODE = R5CONPARTS.CPA_SUPPLIER |
R5COMPANIES full outer join R5CONPARTS |
|
R5COMPANIES <--> R5CONTRACTS |
R5COMPANIES.COM_ORG = R5CONTRACTS.CON_SUPPLIER_ORG AND R5COMPANIES.COM_CODE = R5CONTRACTS.CON_SUPPLIER |
R5COMPANIES full outer join R5CONTRACTS |
|
R5COMPANIES <--> R5CONVUOM |
R5COMPANIES.COM_CODE = R5CONVUOM.CNV_SUPPLIER and R5COMPANIES.COM_ORG = R5CONVUOM.CNV_SUPPLIER_ORG |
R5COMPANIES left outer join R5CONVUOM |
|
R5COMPANIES <--> R5DOCKRECEIPTS |
R5COMPANIES.COM_CODE = R5DOCKRECEIPTS.DCK_SUPPLIER and R5COMPANIES.COM_ORG = R5DOCKRECEIPTS.DCK_SUPPLIER_ORG |
R5COMPANIES full outer join R5DOCKRECEIPTS |
|
R5COMPANIES <--> R5DOCUMENTS |
R5COMPANIES.COM_CODE = R5DOCUMENTS.DOC_SUPPLIER and R5COMPANIES.COM_ORG = R5DOCUMENTS.DOC_SUPPLIER_ORG |
R5COMPANIES full outer join R5DOCUMENTS |
|
R5COMPANIES <--> R5INVOICES |
R5COMPANIES.COM_CODE = R5INVOICES.INV_SUPPLIER and R5COMPANIES.COM_ORG = R5INVOICES.INV_SUPPLIER_ORG |
R5COMPANIES full outer join R5INVOICES |
|
R5COMPANIES <--> R5MANUFACTURERS |
R5COMPANIES.COM_CODE = R5MANUFACTURERS.MFG_SUPPLIER and R5COMPANIES.COM_ORG = R5MANUFACTURERS.MFG_SUPPLIER_ORG |
R5COMPANIES full outer join R5MANUFACTURERS |
|
R5COMPANIES <--> R5ORDERLINES |
R5COMPANIES.COM_CODE = R5ORDERLINES.ORL_SUPPLIER and R5COMPANIES.COM_ORG = R5ORDERLINES.ORL_SUPPLIER_ORG |
R5COMPANIES full outer join R5ORDERLINES |
|
R5COMPANIES <--> R5ORDERS |
R5COMPANIES.COM_CODE = R5ORDERS.ORD_SUPPLIER and R5COMPANIES.COM_ORG = R5ORDERS.ORD_SUPPLIER_ORG |
R5COMPANIES full outer join R5ORDERS |
|
R5COMPANIES <--> R5PICKLISTS |
R5COMPANIES.COM_CODE = R5PICKLISTS.PIC_SUPPLIER and R5COMPANIES.COM_ORG = R5PICKLISTS.PIC_SUPPLIER_ORG |
R5COMPANIES full outer join R5PICKLISTS |
|
R5COMPANIES <--> R5QUOTATIONS |
R5COMPANIES.COM_CODE = R5QUOTATIONS.QUO_SUPPLIER and R5COMPANIES.COM_ORG = R5QUOTATIONS.QUO_SUPPLIER_ORG |
R5COMPANIES full outer join R5QUOTATIONS |
|
R5COMPANIES <--> R5REQUISLINES |
R5COMPANIES.COM_CODE = R5REQUISLINES.RQL_SUPPLIER and R5COMPANIES.COM_ORG = R5REQUISLINES.RQL_SUPPLIER_ORG |
R5COMPANIES full outer join R5REQUISLINES |
|
R5COMPANIES <--> R5SERVICECATALOGUE |
R5COMPANIES.COM_CODE = R5SERVICECATALOGUE.SCA_SUPPLIER and R5COMPANIES.COM_ORG = R5SERVICECATALOGUE.SCA_SUPPLIER_ORG |
R5COMPANIES left outer join R5SERVICECATALOGUE |
|
R5COMPANIES <--> R5STOCK |
R5COMPANIES.COM_CODE = R5STOCK.STO_PREFSUP and R5COMPANIES.COM_ORG = R5STOCK.STO_PREFSUP_ORG |
R5COMPANIES full outer join R5STOCK |
|
R5COMPANIES <--> R5SUPPEVALUATION |
R5COMPANIES.COM_ORG = R5SUPPEVALUATION.EVA_SUPPLIER_ORG AND R5COMPANIES.COM_CODE = R5SUPPEVALUATION.EVA_SUPPLIER |
R5COMPANIES full outer join R5SUPPEVALUATION |
|
R5COMPANIES <--> R5TASKS |
R5COMPANIES.COM_CODE = R5TASKS.TSK_PREFSUP and R5COMPANIES.COM_ORG = R5TASKS.TSK_PREFSUP_ORG |
R5COMPANIES full outer join R5TASKS |
|
R5COMPANIES <--> R5TRADERATES |
R5COMPANIES.COM_CODE = R5TRADERATES.TRR_SUPPLIER and R5COMPANIES.COM_ORG = R5TRADERATES.TRR_SUPPLIER_ORG |
R5COMPANIES left outer join R5TRADERATES |
|
R5COMPANIES <--> R5TRANSLINES |
R5COMPANIES.COM_CODE = R5TRANSLINES.TRL_CONSIGNSUPPLIER and R5COMPANIES.COM_ORG = R5TRANSLINES.TRL_CONSIGNSUPPLIER_ORG |
R5COMPANIES full outer join R5TRANSLINES |
|
R5COMPANIES <--> R5WARCLAIMS |
R5COMPANIES.COM_CODE = R5WARCLAIMS.WCL_SUPPLIER and R5COMPANIES.COM_ORG = R5WARCLAIMS.WCL_SUPPLIER_ORG |
R5COMPANIES full outer join R5WARCLAIMS |
|
R5CONCLAUSES <--> R5BLANKETORDCLAUSES |
R5CONCLAUSES.CCL_CODE = R5BLANKETORDCLAUSES.BLC_CLAUSE |
R5CONCLAUSES left outer join R5BLANKETORDCLAUSES |
|
R5CONCLAUSES <--> R5CONCLAUSES |
R5CONCLAUSES.CCL_CODE = R5CONCLAUSES.CCL_PARENT |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5CONCLAUSES <--> R5CONTYPECLAUSES |
R5CONCLAUSES.CCL_CODE = R5CONTYPECLAUSES.CCY_CLAUS |
R5CONCLAUSES full outer join R5CONTYPECLAUSES |
|
R5CONCLAUSES <--> R5ORDCLAUSES |
R5CONCLAUSES.CCL_CODE = R5ORDCLAUSES.ORC_CLAUSE |
R5CONCLAUSES left outer join R5ORDCLAUSES |
|
R5CONDITIONS <--> R5POINTCONDITIONS |
R5CONDITIONS.CND_CODE = R5POINTCONDITIONS.POC_CONDITION |
R5CONDITIONS full outer join R5POINTCONDITIONS |
|
R5CONTACTINFO <-> R5CONTACTRECORDS |
R5CONTACTINFO.CTI_CODE=R5CONTACTRECORDS.CTR_CONTACTINFOID |
R5CONTACTINFO full outer join R5CONTACTRECORDS |
|
R5CONTRACTS <--> R5CONDISCOUNTS |
R5CONTRACTS.CON_CODE = R5CONDISCOUNTS.CDI_CONTRACT |
R5CONTRACTS full outer join R5CONDISCOUNTS |
|
R5CONTRACTS <--> R5CONPARTS |
R5CONTRACTS.CON_CODE = R5CONPARTS.CPA_CONTRACT |
R5CONTRACTS left outer join R5CONPARTS |
|
R5CONTRACTS <--> R5CONTRACTS |
R5CONTRACTS.CON_CODE = R5CONTRACTS.CON_COPY |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5CONTRACTS <--> R5ORDERLINES |
R5CONTRACTS.CON_CODE = R5ORDERLINES.ORL_CONTRACT |
R5CONTRACTS full outer join R5ORDERLINES |
|
R5CONTRACTS <--> R5ORDERS |
R5CONTRACTS.CON_CODE = R5ORDERS.ORD_CONTRACT |
R5CONTRACTS full outer join R5ORDERS |
|
R5COSTCODES <--> R5DISPATCHES |
R5COSTCODES.CST_CODE = R5DISPATCHES.SWD_COSTCODE |
R5COSTCODES full outer join R5DISPATCHES |
|
R5COSTCODES <--> R5EVENTS |
R5COSTCODES.CST_CODE = R5EVENTS.EVT_COSTCODE |
R5COSTCODES full outer join R5EVENTS |
|
R5COSTCODES <--> R5OBJECTS |
R5COSTCODES.CST_CODE = R5OBJECTS.OBJ_COSTCODE |
R5COSTCODES full outer join R5OBJECTS |
|
R5COSTCODES <--> R5ORDERLINES |
R5COSTCODES.CST_CODE = R5ORDERLINES.ORL_COSTCODE |
R5COSTCODES full outer join R5ORDERLINES |
|
R5COSTCODES <--> R5PPMOBJECTS |
R5COSTCODES.CST_CODE = R5PPMOBJECTS.PPO_COSTCODE |
R5COSTCODES full outer join R5PPMOBJECTS |
|
R5COSTCODES <--> R5REQUISITIONS |
R5COSTCODES.CST_CODE = R5REQUISITIONS.REQ_COSTCODE |
R5COSTCODES full outer join R5REQUISITIONS |
|
R5COSTCODES <--> R5REQUISLINES |
R5COSTCODES.CST_CODE = R5REQUISLINES.RQL_COSTCODE |
R5COSTCODES full outer join R5REQUISLINES |
|
R5COSTCODES <--> R5TRANSLINES |
R5COSTCODES.CST_CODE = R5TRANSLINES.TRL_COSTCODE |
R5COSTCODES full outer join R5TRANSLINES |
|
R5CREDITCARDS <--> R5CREDITCARDUSERS |
R5CREDITCARDS.CRD_CODE = R5CREDITCARDUSERS.CCU_CODE |
R5CREDITCARDS left outer join R5CREDITCARDUSERS |
|
R5CREDITCARDS <--> R5ORDERS |
R5CREDITCARDS.CRD_CODE = R5ORDERS.ORD_CREDITCARD |
R5CREDITCARDS full outer join R5ORDERS |
|
R5CURRENCIES <--> R5ADDITIONALCHARGE |
R5CURRENCIES.CUR_CODE = R5ADDITIONALCHARGE.ADC_CURR |
R5CURRENCIES full outer join R5ADDITIONALCHARGE |
|
R5CURRENCIES <--> R5BLANKETORDERS |
R5CURRENCIES.CUR_CODE = R5BLANKETORDERS.BLO_CURR |
R5CURRENCIES full outer join R5BLANKETORDERS |
|
R5CURRENCIES <--> R5BLANKETORDLINES |
R5CURRENCIES.CUR_CODE = R5BLANKETORDLINES.BLL_CURR |
R5CURRENCIES full outer join R5BLANKETORDLINES |
|
R5CURRENCIES <--> R5BUDGETS |
R5CURRENCIES.CUR_CODE = R5BUDGETS.BUD_CURR |
R5CURRENCIES full outer join R5BUDGETS |
|
R5CURRENCIES <--> R5COMPANIES |
R5CURRENCIES.CUR_CODE = R5COMPANIES.COM_CURR |
R5CURRENCIES full outer join R5COMPANIES |
|
R5CURRENCIES <--> R5CONTRACTS |
R5CURRENCIES.CUR_CODE = R5CONTRACTS.CON_CURR |
R5CURRENCIES full outer join R5CONTRACTS |
|
R5CURRENCIES <--> R5DEBTORS |
R5CURRENCIES.CUR_CODE = R5DEBTORS.DEB_CURR |
R5CURRENCIES full outer join R5DEBTORS |
|
R5CURRENCIES <--> R5EXCHRATES |
R5CURRENCIES.CUR_CODE = R5EXCHRATES.CRR_CURR |
R5CURRENCIES full outer join R5EXCHRATES |
|
R5CURRENCIES <--> R5INVOICELINES |
R5CURRENCIES.CUR_CODE = R5INVOICELINES.IVL_CURR |
where (R5CURRENCIES.CUR_CODE = R5INVOICELINES.IVL_CURR) |
|
R5CURRENCIES <--> R5INVOICES |
R5CURRENCIES.CUR_CODE = R5INVOICES.INV_CURR |
R5CURRENCIES full outer join R5INVOICES |
|
R5CURRENCIES <--> R5IPVENDORS |
R5CURRENCIES.CUR_CODE = R5IPVENDORS.IPV_CURR |
R5CURRENCIES full outer join R5IPVENDORS |
|
R5CURRENCIES <--> R5ORDERS |
R5CURRENCIES.CUR_CODE = R5ORDERS.ORD_CURR |
R5CURRENCIES full outer join R5ORDERS |
|
R5CURRENCIES <--> R5QUOTLINES |
R5CURRENCIES.CUR_CODE = R5QUOTLINES.QUL_CURR |
R5CURRENCIES full outer join R5QUOTLINES |
|
R5CURRENCIES <--> R5REQUISLINES |
R5CURRENCIES.CUR_CODE = R5REQUISLINES.RQL_CURR |
R5CURRENCIES full outer join R5REQUISLINES |
|
R5CURRENCIES <--> R5SERVICECATALOGUE |
R5CURRENCIES.CUR_CODE = R5SERVICECATALOGUE.SCA_CURR |
R5CURRENCIES full outer join R5SERVICECATALOGU E |
|
R5CURRENCIES <--> R5SERVICEREQUESTS |
R5CURRENCIES.CUR_CODE = R5SERVICEREQUESTS.SRQ_CURRENCY |
R5CURRENCIES full outer join R5SERVICEREQUESTS |
|
R5DDDATASPY <--> R5HOME |
R5DDDATASPY.DDS_DDSPYID = R5HOME.HOM_EWSDATASPYID |
R5DDDATASPY full outer join R5HOME |
|
R5DDDATASPY <--> R5OPVARDESC |
R5DDDATASPY.DDS_DDSPYID = R5OPVARDESC.OVD_DDSPYID |
R5DDDATASPY full outer join R5OPVARDESC |
|
R5DDDATASPY <--> R5PERMISSIONS |
R5DDDATASPY.DDS_DDSPYID = R5PERMISSIONS.PRM_SECURITYDDSPYID |
R5DDDATASPY full outer join R5PERMISSIONS |
|
R5DDDATASPY <--> R5QUERYFIELD |
R5DDDATASPY.DDS_DDSPYID = R5QUERYFIELD.DQF_DDSPYID |
R5DDDATASPY left outer join R5QUERYFIELD |
|
R5DDDATASPY <--> R5TABPERMISSIONS |
R5DDDATASPY.DDS_DDSPYID = R5TABPERMISSIONS.TRP_SECURITYDDSPYID |
R5DDDATASPY full outer join R5TABPERMISSIONS |
|
R5DDDATASPY <--> R5USEGRIDGISDEFAULT |
R5DDDATASPY.DDS_DDSPYID = R5USEGRIDGISDEFAULT.UGD_DATASPYID |
R5DDDATASPY full outer join R5USEGRIDGISDEFAULT |
|
R5DDDATASPY <--> R5USEGRIDSYSDEFAULT |
R5DDDATASPY.DDS_DDSPYID = R5USEGRIDSYSDEFAULT.USD_DATASPYID |
R5DDDATASPY full outer join R5USEGRIDSYSDEFAULT |
|
R5DDFIELD <--> R5GRIDFIELD |
R5DDFIELD.DDF_FIELDID = R5GRIDFIELD.GFD_FIELDID |
R5DDFIELD left outer join R5GRIDFIELD |
|
R5DDFIELD <--> R5QUERYFIELD |
R5DDFIELD.DDF_FIELDID = R5QUERYFIELD.DQF_FIELDID |
R5DDFIELD left outer join R5QUERYFIELD |
|
R5DEBTORS <--> R5AGREEMENTS |
R5DEBTORS.DEB_CODE = R5AGREEMENTS.AGR_DEBTOR |
R5DEBTORS full outer join R5AGREEMENTS |
|
R5DEBTORS <--> R5CALCEVENTS |
R5DEBTORS.DEB_CODE = R5CALCEVENTS.CEV_DEBTOR |
R5DEBTORS full outer join R5CALCEVENTS |
|
R5DEBTORS <--> R5CALLERS |
R5DEBTORS.DEB_CODE = R5CALLERS.CLL_CUSTOMER |
R5DEBTORS full outer join R5CALLERS |
|
R5DEBTORS <--> R5DEBCODESTRUCT |
R5DEBTORS.DEB_CODE = R5DEBCODESTRUCT.DCS_CUSTOMER |
R5DEBTORS left outer join R5DEBCODESTRUCT |
|
R5DEBTORS <--> R5EXTINVOICES |
R5DEBTORS.DEB_CODE = R5EXTINVOICES.EIV_DEBTOR |
R5DEBTORS full outer join R5EXTINVOICES |
|
R5DEBTORS <--> R5SERVICEREQUEST S |
R5DEBTORS.DEB_CODE = R5SERVICEREQUESTS.SRQ_CU |
R5DEBTORS full outer join R5SERVICEREQUESTS |
|
R5DELADDRESSES <--> R5ORDERLINES |
R5DELADDRESSES.DAD_CODE = R5ORDERLINES.ORL_DELADDRESS |
R5DELADDRESSES full outer join R5ORDERLINES |
|
R5DELADDRESSES <--> R5ORDERS |
R5DELADDRESSES.DAD_CODE = R5ORDERS.ORD_DELADDRESS |
R5DELADDRESSES full outer join R5ORDERS |
|
R5DELADDRESSES <--> R5PICKLISTS |
R5DELADDRESSES.DAD_CODE = R5PICKLISTS.PIC_DELADDRESS |
R5DELADDRESSES full outer join R5PICKLISTS |
|
R5DELADDRESSES <--> R5QUOTATIONS |
R5DELADDRESSES.DAD_CODE = R5QUOTATIONS.QUO_DELADDRESS |
R5DELADDRESSES full outer join R5QUOTATIONS |
|
R5DELADDRESSES <--> R5QUOTLINES |
R5DELADDRESSES.DAD_CODE = R5QUOTLINES.QUL_DELADDRESS |
R5DELADDRESSES full outer join R5QUOTLINES |
|
R5DELADDRESSES <--> R5REQUISITIONS |
R5DELADDRESSES.DAD_CODE = R5REQUISITIONS.REQ_DELADDRESS |
where (R5DELADDRESSES.DAD_CODE = R5REQUISITIONS.REQ_DELADDRESS) |
|
R5DELADDRESSES <--> R5REQUISLINES |
R5DELADDRESSES.DAD_CODE = R5REQUISLINES.RQL_DELADDRESS |
R5DELADDRESSES full outer join R5REQUISLINES |
|
R5DEVICES <--> R5DEVICES |
R5DEVICES.DEV_CODE = R5DEVICES.DEV_CATEGORY |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5DEVICES <--> R5FUNCTIONS |
R5DEVICES.DEV_CODE = R5FUNCTIONS.FUN_DEVICE |
R5DEVICES full outer join R5FUNCTIONS |
|
R5DEVICES <--> R5GROUPS |
R5DEVICES.DEV_CODE = R5GROUPS.UGR_PRINTER |
R5DEVICES full outer join R5GROUPS |
|
R5DEVICES <--> R5USERS |
R5DEVICES.DEV_CODE = R5USERS.USR_PRINTER |
R5DEVICES full outer join R5USERS |
|
R5DIAGNOSTICS <--> R5DIAGUSAGES |
R5DIAGNOSTICS.DIA_CODE = R5DIAGUSAGES.DIU_DIAG |
R5DIAGNOSTICS left outer join R5DIAGUSAGES |
|
R5DOCKLINES <--> R5TRANSACTIONS |
R5DOCKLINES.DKL_DCKCODE = R5TRANSACTIONS.TRA_DCKCODE and R5DOCKLINES.DKL_LINE = R5TRANSACTIONS.TRA_DCKLINE |
R5DOCKLINES full outer join R5TRANSACTIONS |
|
R5DOCKLINES <--> R5TRANSLINES |
R5DOCKLINES.DKL_DCKCODE = R5TRANSLINES.TRL_DCKCODE and R5DOCKLINES.DKL_LINE = R5TRANSLINES.TRL_DCKLINE |
R5DOCKLINES full outer join R5TRANSLINES |
|
R5DOCKRECEIPTS <--> R5DOCKLINES |
R5DOCKRECEIPTS.DCK_CODE = R5DOCKLINES.DKL_DCKCODE |
R5DOCKRECEIPTS left outer join R5DOCKLINES |
|
R5DOCKRECEIPTS <--> R5PACKINGSLIP |
R5DOCKRECEIPTS.DCK_CODE = R5PACKINGSLIP.PSL_DOCK |
R5DOCKRECEIPTS left outer join R5PACKINGSLIP |
|
R5DOCKRECEIPTS <--> R5TRANSACTIONS |
R5DOCKRECEIPTS.DCK_CODE = R5TRANSACTIONS.TRA_DCKCODE |
R5DOCKRECEIPTS full outer join R5TRANSACTIONS |
|
R5DOCSIZES <--> R5DOCUMENTS |
R5DOCSIZES.DSZ_CODE = R5DOCUMENTS.DOC_SIZE |
R5DOCSIZES full outer join R5DOCUMENTS |
|
R5DOCUMENTS <--> R5DOCBODY |
R5DOCUMENTS.DOC_CODE = R5DOCBODY.DOB_CODE |
R5DOCUMENTS full outer join R5DOCBODY |
|
R5DOCUMENTS <--> R5DOCENTITIES |
R5DOCUMENTS.DOC_CODE = R5DOCENTITIES.DAE_DOCUMENT |
R5DOCUMENTS left outer join R5DOCENTITIES |
|
R5DOCUMENTS <--> R5DOCMATRIX |
R5DOCUMENTS.DOC_CODE = R5DOCMATRIX.DMX_WARRANTY |
R5DOCUMENTS left outer join R5DOCMATRIX |
|
R5DOCUMENTS <--> R5DOCUMENTS |
R5DOCUMENTS.DOC_CODE = R5DOCUMENTS.DOC_PARENT |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5DOCUMENTS <--> R5WARCLAIMS |
R5DOCUMENTS.DOC_CODE = R5WARCLAIMS.WCL_WARRANTY |
R5DOCUMENTS full outer join R5WARCLAIMS |
|
R5DOCUMENTS <--> R5WARCOMPONENTS |
R5DOCUMENTS.DOC_CODE = R5WARCOMPONENTS.WCM_WARRANTY |
R5DOCUMENTS full outer join R5WARCOMPONENTS |
|
R5DOCUMENTS <--> R5WARCOVERAGES |
R5DOCUMENTS.DOC_CODE = R5WARCOVERAGES.WCV_WARRANTY |
R5DOCUMENTS full outer join R5WARCOVERAGES |
|
R5DUALCONVHEADER <--> R5DUALCONVLINES |
R5DUALCONVHEADER.DCH_BATCH= R5DUALCONVLINES.DCL_BATCH |
R5DUALCONVHEADER full outer join R5DUALCONVLINES |
|
R5DWACTUALCOMPDATES <--> R5DWWOACCUMSNAP |
R5DWACTUALCOMPDATES.ZVF_ACTCOMPKEY = R5DWWOACCUMSNAP.ZWS_ACTUALCOMPDATEKEY |
where (R5DWACTUALCOMPDATES.ZVF_ACTC OMPKEY = R5DWWOACCUMSNAPZWS_ACTUALCOMPDATEKEY) |
|
R5DWACTUALSTARTDATES <--> R5DWWOACCUMSNAP |
R5DWACTUALSTARTDATES.ZVE_ACTSTRTKEY = R5DWWOACCUMSNAP.ZWS_ACTUALSTARTDATEKEY |
where (R5DWACTUALSTARTDATES.ZVE_ACTSTRTKEY = R5DWWOACCUMSNAPZWS_ACTUALSTARTDATEKEY) |
|
R5DWAPPROVEDDATES <--> R5DWPOACCUMSNAP |
R5DWAPPROVEDDATES.ZVJ_APPROVDKEY = R5DWPOACCUMSNAP.ZPS_DATEAPPROVEDKEY |
where (R5DWAPPROVEDDATES.ZVJ_APPROVDKEY = R5DWPOACCUMSNAPZPS_DATEAPPROVEDKEY) |
|
R5DWBUDGETS <--> R5DWWOCOSTDAILYSNAP |
R5DWBUDGETS.ZBU_KEY = R5DWWOCOSTDAILYSNAP.ZWT_BUDGETKEY |
where (R5DWBUDGETS.ZBU_KEY = R5DWWOCOSTDAILYSNAP.ZWT_BUDGETKE) |
|
R5DWCREATEDDATES <--> R5DWWOACCUMSNAP |
R5DWCREATEDDATES.ZVA_CREATEDKEY = R5DWWOACCUMSNAP.ZWS_WODATECREATEDKEY |
where (R5DWCREATEDDATES.ZVA_CREATEDKEY = R5DWWOACCUMSNAP.ZWS_WODATECREATEDKEY) |
|
R5DWDATAMARTS <--> R5DWDATAMARTDIMENSIONS |
R5DWDATAMARTS.DMT_TABLE = R5DWDATAMARTDIMENSIONS.DMD_DMTTABLE |
where (R5DWDATAMARTS.DMT_TABLE = R5DWDATAMARTDIMENSIONS.DMD_DMTTABLE) |
|
R5DWDATAMARTS <--> R5DWFACTFIELDS |
R5DWDATAMARTS.DMT_TABLE = R5DWFACTFIELDS.FFL_DMTTABLE |
where (R5DWDATAMARTS.DMT_TABLE = R5DWFACTFIELDS.FFL_DMTTABLE) |
|
R5DWDATE <--> R5DWORGFACT |
R5DWDATE.DWD_DATEKEY = R5DWORGFACT.DWF_DATEKEY |
R5DWDATE full outer join R5DWORGFACT |
|
R5DWDATES <--> R5DWAVAILLABORDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWAVAILLABORDAILYSNAP.ZLA_DATEKEY |
where (R5DWDATES.Z DT_KEY = R5DWAVAILLABORDAIL YSNAP.ZLA_DATEKEY) |
|
R5DWDATES <--> R5DWLABORDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWLABORDAILYSNAP.ZLB_DATEKEY |
where (R5DWDATES.ZDT_KEY = R5DWLABORDAILYSNAP.ZLB_DATEKEY) |
|
R5DWDATES <--> R5DWMATLTRANSDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWMATLTRANSDAILYSNAP.ZMS_DATEKEY |
where (R5DWDATES.ZDT_KEY = R5DWMATLTRANSDAILYSNAP.ZMS_DATEKEY) |
|
R5DWDATES <--> R5DWOBJECTROLLUPDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWOBJECTROLLUPDAILYSNAP.ZVT_DATEKEY |
where (R5DWDATES.ZDT_KEY = R5DWOBJECTROLLUPDAILYSNAP.ZVT_DATEKEY) |
|
R5DWDATES <--> R5DWPARTSDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWPARTSDAILYSNAP.ZAS_DATEKEY |
where (R5DWDATES.ZDT_KEY = R5DWPARTSDAILYSNAP.ZAS_DATEKEY) |
|
R5DWDATES <--> R5DWPARTSTRANSDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_DATEKEY |
where (R5DWDATES.ZDT_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_DATEKEY) |
|
R5DWDATES <--> R5DWPOACCUMSNAP |
R5DWDATES.ZDT_KEY = R5DWPOACCUMSNAP.ZPS_DATECREATEDKEY |
where (R5DWDATES.ZDT_KEY = R5DWPOACCUMSNAP.ZPS_DATECREATEDKEY) |
|
R5DWDATES <--> R5DWSTATUSDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWSTATUSDAILYSNAP.ZSC_DATEKEY |
where (R5DWDATES.ZDT_KEY = R5DWSTATUSDAILYSNAP.ZSC_DATEKEY) |
|
R5DWDATES <--> R5DWSTORESDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWSTORESDAILYSNAP.ZSS_DATEKEY |
where (R5DWDATES.ZDT_KEY = R5DWSTORESDAILYSNAP.ZSS_DATEKEY) |
|
R5DWDATES <--> R5DWWOCOSTDAILYSNAP |
R5DWDATES.ZDT_KEY = R5DWWOCOSTDAILYSNAP.ZWT_DATEKEY |
where (R5DWDATES.ZDT_KEY = R5DWWOCOSTDAILYSNAP.ZWT_DATEKEY) |
|
R5DWDIMENSIONS <--> R5DWDATAMARTDIMENSIONS |
R5DWDIMENSIONS.DIM_TABLE = R5DWDATAMARTDIMENSIONS.DMD_DIMTABLE |
where (R5DWDIMENSIONS.DIM_TABLE = R5DWDATAMARTDIMENSIONS.DMD_DIMTABLE) |
|
R5DWDIMENSIONS <--> R5DWDIMENSIONFIELDS |
R5DWDIMENSIONS.DIM_TABLE = R5DWDIMENSIONFIELDS.DMF_DIMTABLE |
where (R5DWDIMENSIONS.DIM_TABLE = R5DWDIMENSIONFIELDS.DMF_DIMTABLE) |
|
R5DWDUEDATES <--> R5DWPOACCUMSNAP |
R5DWDUEDATES.ZVK_DUEKEY = R5DWPOACCUMSNAP.ZPS_DATEDUEKEY |
where (R5DWDUEDATES.ZVK_DUEKEY= R5DWPOACCUMSNAP.ZPS_DATEDUEKEY) |
|
R5DWENTITIES <--> R5DWSTATUSDAILYSNAP |
R5DWENTITIES.ZEN_KEY = R5DWSTATUSDAILYSNAP.ZSC_ENTITYKEY |
where (R5DWETLRUNLOG.RLG_RUNNUMBER = R5DWETLRUNERRORLOG.ELG_RUNNUMBER) |
|
R5DWETLRUNLOG <--> R5DWETLRUNERRORLOG |
R5DWETLRUNLOG.RLG_RUNNUMBER = R5DWETLRUNERRORLOG.ELG_RUNNUMBER |
where (R5DWETLRUNLOG.RLG_RUNNUMBER = R5DWETLRUNLOGDETAIL.LGD_LOGRUNNUMBER) |
|
R5DWETLRUNLOG <--> R5DWETLRUNLOGDETAIL |
R5DWETLRUNLOG.RLG_RUNNUMBER = R5DWETLRUNLOGDETAIL.LGD_LOGRUNNUMBER |
where (R5DWFILEDDATES.ZVH_FILEDKEY = R5DWWARCLAIMSACCUMSNAP.ZCS_DATEFILEDKEY) |
|
R5DWFILEDDATES <--> R5DWWARCLAIMSACCUMSNAP |
R5DWFILEDDATES.ZVH_FILEDKEY = R5DWWARCLAIMSACCUMSNAP.ZCS_DATEFILEDKEY |
where (R5DWFROMSTATUSES.ZVU_FROMSTATUSKEY = R5DWSTATUSDAILYSNAP.ZSC_FROMSTATUSKEY) |
|
R5DWFROMSTATUSES <--> R5DWSTATUSDAILYSNAP |
R5DWFROMSTATUSES.ZVU_FROMSTATUSKEY = R5DWSTATUSDAILYSNAP.ZSC_FROMSTATUSKEY |
where (R5DWFROMSTORES.ZVL_FROMSTOREKEY = R5DWMATLTRANSDAILYSNAP.ZMS_FROMSTOREKEY) |
|
R5DWFROMSTORES<--> R5DWMATLTRANSDAILYSNAP |
R5DWFROMSUPPLIERS.ZVN_FROMSUPPLIERKEY = R5DWMATLTRANSDAILYSNAP.ZMS_FROMSUPPLIERKEY |
where (R5DWFROMSUPPLIERS.ZVN_FROMSUPPLIERKEY = R5DWMATLTRANSDAILYSNAP.ZMS_FROMSUPPLIERKEY) |
|
R5DWFROMWORKORDERS <--> R5DWMATLTRANSDAILYSNAP |
R5DWFROMWORKORDERS.ZVP_FROMWOKEY = R5DWMATLTRANSDAILYSNAP.ZMS_FROMWOKEY |
where (R5DWFROMWORKORDERS.ZVP_FROM WOKEY = R5DWMATLTRANSDAILYSNAP.ZMS_FROMWO KEY) |
|
R5DWMATLTRANSTYPES <--> R5DWMATLTRANSDAILYSNAP |
R5DWMATLTRANSTYPES.ZMT_KEY= R5DWMATLTRANSDAILYSNAP.ZMS_MATLTRANSTYPEKEY |
where (R5DWMATLTRANSTYPES.ZMT_KEY = R5DWMATLTRANSDAILYSNAP.ZMS_MATLTRANSTYPEKEY) |
|
R5DWMRCS <--> R5DWAVAILLABORDAILYSNAP |
R5DWMRCS.ZMR_KEY = R5DWAVAILLABORDAILYSNAP.ZLA_MRCKEY |
where(R5DWMRCS.ZMR_KEY = R5DWAVAILLABORDAILYSNAP.ZLA_MRCKEY) |
|
R5DWMRCS <--> R5DWLABORDAILYSNAP |
R5DWMRCS.ZMR_KEY = R5DWLABORDAILYSNAP.ZLB_MRCKEY |
where (R5DWMRCS.ZMR_KEY = R5DWMATLTRANSDAILYSNAP.ZMS_MRCKEY) |
|
R5DWMRCS <--> R5DWMATLTRANSDAILYSNAP |
R5DWMRCS.ZMR_KEY = R5DWMATLTRANSDAILYSNAP.ZMS_MRCKEY |
where (R5DWMRCS.ZMR_KEY = R5DWSTATUSDAILYSNAP.ZSC_MRCKEY) |
|
R5DWMRCS <--> R5DWSTATUSDAILYSNAP |
R5DWMRCS.ZMR_KEY = R5DWSTATUSDAILYSNAP.ZSC_MRCKEY |
where (R5DWMRCS.ZMR_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_MRCKEY) |
|
R5DWMRCS <--> R5DWWARCLAIMSACCUMSNAP |
R5DWMRCS.ZMR_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_MRCKEY |
where (R5DWMRCS.ZM R_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_MRCKEY) |
|
R5DWMRCS <--> R5DWWOACCUMSNAP |
R5DWMRCS.ZMR_KEY = R5DWWOACCUMSNAP.ZWS_MRCKEY |
where (R5DWMRCS.ZMR_KEY = R5DWWOACCUMSNAP.ZWS_MRCKEY) |
|
R5DWMRCS <--> R5DWWOCOSTDAILYSNAP |
R5DWMRCS.ZMR_KEY = R5DWWOCOSTDAILYSNAP.ZWT_MRCKEY |
where (R5DWMRCS.ZMR_KEY = R5DWWOCOSTDAILYSNAP.ZWT_MRCKEY) |
|
R5DWOBJECTS <--> R5DWOBJECTROLLUPDAILYSNAP |
R5DWOBJECTS.ZOB_KEY = R5DWOBJECTROLLUPDAILYSNAP.ZVT_OBJECTKEY |
where (R5DWOBJECTS.ZOB_KEY = R5DWOBJECTROLLUPDAILYSNAP.ZVT_OBJECTKEY) |
|
R5DWOBJECTS <--> R5DWWARCLAIMSACCUMSNAP |
R5DWOBJECTS.ZOB_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_OBJECTKEY |
where (R5DWOBJECTS.ZOB_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_OBJECTKEY) |
|
R5DWOBJECTS <--> R5DWWOACCUMSNAP |
R5DWOBJECTS.ZOB_KEY = R5DWWOACCUMSNAP.ZWS_OBJECTKEY |
where (R5DWOBJECTS.ZOB_KEY = R5DWWOACCUMSNAP.ZWS_OBJECTKEY) |
|
R5DWOBJECTS <--> R5DWWOCOSTDAILYSNAP |
R5DWOBJECTS.ZOB_KEY = R5DWWOCOSTDAILYSNAP.ZWT_OBJECTKEY |
where (R5DWOBJECTS.ZOB_KE Y = R5DWWOCOSTDAILYSNAP.ZWT_OBJECTKEY) |
|
R5DWOCCUPATION TYPES <--> R5DWLABORDAILYSNAP |
R5DWOCCUPATIONTYPES.ZOT_KEY = R5DWLABORDAILYSNAP.ZLB_OCTYPEKEY |
where (R5DWOCCUPATIONTYPES.ZOT_KEY = R5DWLABORDAILYSNAP.ZLB_OCTYPEKEY) |
|
R5DWORDERLINET YPES <--> R5DWPARTSTRANSDAILYSNAP |
R5DWORDERLINETYPES.ZOL_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_ORDERLINETYPEKEY |
where (R5DWORDERLINETYPES.ZOL_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_ORDERLINETYPEKEY) |
|
R5DWORG <--> R5DWORGFACT |
R5DWORG.DWO_ORGKEY = R5DWORGFACT.DWF_ORGKEY |
R5DWORG full outer join R5DWORGFACT |
|
R5DWORGANIZATIONS <--> R5DWAVAILLABORDAILYSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWAVAILLABORDAILYSNAP.ZLA_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWAVAILLABORDAILYSNAP.ZLA_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWLABORDAILYSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWLABORDAILYSNAP.ZLB_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWLABORDAILYSNAP.ZLB_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWMATLTRANSDAILYSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWMATLTRANSDAILYSNAP.ZMS_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWMATLTRANSDAILYSNAP.ZMS_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWPARTSTRANSDAILYSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWPOACCUMSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWPOACCUMSNAP.ZPS_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWPOACCUMSNAP.ZPS_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWSTATUSDAILYSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWSTATUSDAILYSNAP.ZSC_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWSTATUSDAILYSNAP.ZSC_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWSTORESDAILYSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWSTORESDAILYSNAP.ZSS_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWSTORESDAILYSNAP.ZSS_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWWARCLAIMSACCUMSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWWARCLAIMSACC UMSNAP.ZCS_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWWOACCUMSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWWOACCUMSNAP.ZWS_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWWOACCUMSNAP.ZWS_ORGKEY) |
|
R5DWORGANIZATIONS <--> R5DWWOCOSTDAIL YSNAP |
R5DWORGANIZATIONS.ZOR_KEY = R5DWWOCOSTDAILYSNAP.ZWT_ORGKEY |
where (R5DWORGANIZATIONS.ZOR_KEY = R5DWWOCOSTDAILYSNAP.ZWT_ORGKEY) |
|
R5DWPARTCLASSE S<--> R5DWSTORESDAILYSNAP |
R5DWPARTCLASSES.ZPC_KEY= R5DWSTORESDAILYSNAP.ZSS_PARTCLASSKEY |
where (R5DWPARTCLASSES.ZPC_KEY = R5DWSTORESDAILYSNAP.ZSS_PARTCLASSKEY) |
|
R5DWPARTS <--> R5DWPARTSDAILYSNAP |
R5DWPARTS.ZPA_KEY = R5DWPARTSDAILYSNAP.ZAS_PARTKEY |
where (R5DWPARTS.ZPA_KEY = R5DWPARTSDAILYSNAP.ZAS_PARTKEY) |
|
R5DWPARTS <--> R5DWPARTSTRANSDAILYSNAP |
R5DWPARTS.ZPA_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_PARTKEY |
where (R5DWPARTS.ZPA_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_PARTKEY) |
|
R5DWPERSONNEL <--> R5DWLABORDAILYSNAP |
R5DWPERSONNEL.ZPE_KEY = R5DWLABORDAILYSNAP.ZLB_PERSONNELKEY |
where (R5DWPERSONNEL.ZPE_KEY = R5DWLABORDAILYSNAP.ZLB_PERSONNELKEY) |
|
5DWPURCHASEORDERS <--> R5DWPARTSTRANSDAILYSNAP |
R5DWPURCHASEORDERS.ZPO_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_POKEY |
where (R5DWPURCHASEORDERS.ZPO_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_POKEY) |
|
R5DWPURCHASEORDERS <--> R5DWPOACCUMSNAP |
R5DWPURCHASEORDERS.ZPO_KEY = R5DWPOACCUMSNAP.ZPS_POKEY |
where (R5DWPURCHASEORDERS.ZPO_KEY = R5DWPOACCUMSNAP.ZPS_POKEY) |
|
R5DWREPORTEDDATES <--> R5DWWARCLAIMSACCUMSNAP |
R5DWREPORTEDDATES.ZVG_RPTDKEY = R5DWWARCLAIMSACCUMSNAP.ZCS_DATEREPORTEDKEY |
where (R5DWREPORTEDDATES.ZVG_RPTDKEY = R5DWWARCLAIMSACCUMSNAP.ZCS_DATEREPORTEDKEY) |
|
R5DWREQUESTDATES <--> R5DWWOACCUMSNAP |
R5DWREQUESTDATES.ZVB_REQUESTKEY = R5DWWOACCUMSNAP.ZWS_SRDATEREQUESTEDKEY |
where (R5DWREQUESTDATES.ZVB_REQUESTKEY = R5DWWOACCUMSNAP.ZWS_SRDATEREQUESTEDKEY) |
|
R5DWRESOLVEDDATES <--> R5DWWARCLAIMSACCUMSNAP |
R5DWRESOLVEDDATES.ZVI_RSOLVDKEY = R5DWWARCLAIMSACCUMSNAP.ZCS_DATERESOLVEDKEY |
where (R5DWRESOLVEDDATES.ZVI_RSOLVDKEY = R5DWWARCLAIMSACCUMSNAP.ZCS_DATERESOLVEDKEY) |
|
R5DWSCHEDCOMPDATES <--> R5DWWOACCUMSNAP |
R5DWSCHEDCOMPDATES.ZVD_SCHCOMPKEY = R5DWWOACCUMSNAP.ZWS_SCHEDCOMPDATEKEY |
where (R5DWSCHEDCOMPDATES.ZVD_SCHCOMPKEY = R5DWWOACCUMSNAP.ZWS_SCHEDCOMPDATEKEY) |
|
R5DWSCHEDSTARTDATES <--> R5DWWOACCUMSNAP |
R5DWSCHEDSTARTDATES.ZVC_SCHSTRTKEY = R5DWWOACCUMSNAP.ZWS_SCHEDSTARTDATEKEY |
where (R5DWSCHEDSTARTDATES.ZVC_SCHSTRTKEY = R5DWWOACCUMSNAP.ZWS_SCHEDSTARTDATEKEY) |
|
R5DWSERVICEREQUESTS <--> R5DWWOACCUMSNAP |
R5DWSERVICEREQUESTS.ZSR_KEY = R5DWWOACCUMSNAP.ZWS_SRKEY |
where (R5DWSERVICEREQUESTS.ZSR_KEY = R5DWWOACCUMSNAP.ZWS_SRKEY) |
|
R5DWSTATUSES <--> R5DWSTATUSDAILYSNAP |
R5DWSTATUSES.ZST_KEY = R5DWSTATUSDAILYSNAP.ZSC_FROMSTATUSKEY |
where (R5DWSTATUSES.ZST_KEY = R5DWSTATUSDAILYSNAP.ZSC_FROMSTATUSKEY) |
|
R5DWSTORES <--> R5DWPOACCUMSNAP |
R5DWSTORES.ZSO_KEY = R5DWPOACCUMSNAP.ZPS_STOREKEY |
where (R5DWSTORES.ZSO_KEY = R5DWPOACCUMSNAP.ZPS_STOREKEY) |
|
R5DWSTORES <--> R5DWSTORESDAILYSNAP |
R5DWSTORES.ZSO_KEY = R5DWSTORESDAILYSNAP.ZSS_STOREKEY |
where (R5DWSTORES.ZSO_KEY = R5DWSTORESDAILYSNAP.ZSS_STOREKEY) |
|
R5DWSUPPLIERS <--> R5DWPARTSTRANSDAILYSNAP |
R5DWSUPPLIERS.ZSU_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_SUPPLIERKEY |
where (R5DWSUPPLIERS.ZSU_KEY = R5DWPARTSTRANSDAILYSNAP.ZPT_SUPPLIERKEY) |
|
R5DWSUPPLIERS <--> R5DWPOACCUMSNAP |
R5DWSUPPLIERS.ZSU_KEY = R5DWPOACCUMSNAP.ZPS_SUPPLIERKEY |
where (R5DWSUPPLIERS.ZSU_KEY = R5DWPOACCUMSNAP.ZPS_SUPPLIERKEY) |
|
R5DWSUPPLIERS <--> R5DWWARCLAIMSACCUMSNAP |
R5DWSUPPLIERS.ZSU_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_SUPPLIERKEY |
where (R5DWSUPPLIERS.ZSU_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_SUPPLIERKEY) |
|
R5DWTOSTATUSES <--> R5DWSTATUSDAILYSNAP |
R5DWTOSTATUSES.ZVV_TOSTATUSKEY = R5DWSTATUSDAILYSNAP.ZSC_TOSTATUSKEY |
where (R5DWTOSTATUSES.ZVV_TOSTATUSKEY = R5DWSTATUSDAILYSNAP.ZSC_TOSTATUSKEY) |
|
R5DWTOSTORES <--> R5DWMATLTRANSDAILYSNAP |
R5DWTOSTORES.ZVM_TOSTOREKEY = R5DWMATLTRANSDAILYSNAP.ZMS_TOSTOREKEY |
where (R5DWTOSTORES.ZVM_TOSTOREKEY = R5DWMATLTRANSDAILYSNAP.ZMS_TOSTOREKEY) |
|
R5DWTOSUPPLIERS <--> R5DWMATLTRANSDAILYSNAP |
R5DWTOSUPPLIERS.ZVO_TOSUPPLIERKEY = R5DWMATLTRANSDAILYSNAP.ZMS_TOSUPPLIERKEY |
where (R5DWTOSUPPLIERS.ZVO_TOSUPPLIERKEY = R5DWMATLTRANSDAILYSNAP.ZMS_TOSUPPLIERKEY) |
|
R5DWTOWORKORD ERS <--> R5DWMATLTRANSDAILYSNAP |
R5DWTOWORKORDERS.ZVQ_TOWOKEY = R5DWMATLTRANSDAILYSNAP.ZMS_TOWOKEY |
where (R5DWTOWORKORDERS.ZVQ_TOWOKEY = R5DWMATLTRANSDAILYSNAP.ZMS_TOWOKEY) |
|
R5DWTRADES <--> R5DWAVAILLABORDAILYSNAP |
R5DWTRADES.ZTR_KEY = R5DWAVAILLABORDAILYSNAP.ZLA_TRADEKEY |
where (R5DWTRADES.ZTR_KEY = R5DWAVAILLABORDAILYSNAP.ZLA_TRADEKEY) |
|
R5DWTRADES <--> R5DWLABORDAILYSNAP |
R5DWTRADES.ZTR_KEY = R5DWLABORDAILYSNAP.ZLB_TRADEKEY |
where (R5DWTRADESZTR_KEY = R5DWLABORDAILYSNAP.ZLB_TRADEKEY) |
|
R5DWWARRANTYCLAIMS <--> R5DWWARCLAIMSACCUMSNAP |
R5DWWARRANTYCLAIMS.ZWC_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_CLAIMKEY |
where (R5DWWARRANTYCLAIMS.ZWC_KEY = R5DWWARCLAIMSACCUMSNAP.ZCS_CLAIMKEY) |
|
R5DWWORKORDERS <--> R5DWLABORDAILYSNAP |
R5DWWORKORDERS.ZWO_KEY = R5DWLABORDAILYSNAP.ZLB_WOKEY |
where (R5DWWORKORDERS.ZWO_KEY = R5DWLABORDAILYSNAP.ZLB_WOKEY) |
|
R5DWWORKORDERS <--> R5DWWOACCUMSN AP |
R5DWWORKORDERS.ZWO_KEY = R5DWWOACCUMSNAP.ZWS_WOKEY |
where (R5DWWORKORDERS.ZWO_KEY = R5DWWOACCUMSNAP.ZWS_WOKEY) |
|
R5DWWORKORDERS <--> R5DWWOCOSTDAILYSNAP |
R5DWWORKORDERS.ZWO_KEY = R5DWWOCOSTDAILYSNAP.ZWT_WOKEY |
where (R5DWWORKORDERS.ZWO_KEY = R5DWWOCOSTDAILYSNAP.ZWT_WOKEY) |
|
R5ENTAPPHEADER <--> R5ENTAPPLISTS |
R5ENTAPPHEADER.EAH_PK = R5ENTAPPLISTS.EAL_PK |
R5ENTAPPHEADER full outer join R5ENTAPPLISTS |
|
R5ENTITIES <--> R5ADDETAILS |
R5ENTITIES.ENT_RENTITY = R5ADDETAILS.ADD_RENTITY |
R5ENTITIES left outer join R5ADDETAILS |
|
R5ENTITIES <--> R5ADDRESS |
R5ENTITIES.ENT_RENTITY = R5ADDRESS.ADR_RENTITY |
R5ENTITIES left outer join R5ADDRESS |
|
R5ENTITIES <--> R5AUTH |
R5ENTITIES.ENT_ENTITY = R5AUTH.AUT_ENTITY |
R5ENTITIES full outer join R5AUTH |
|
R5ENTITIES <--> R5CLASSES |
R5ENTITIES.ENT_ENTITY = R5CLASSES.CLS_ENTITY |
R5ENTITIES left outer join R5CLASSES |
|
R5ENTITIES <--> R5DESCRIPTIONS |
R5ENTITIES.ENT_RENTITY = R5DESCRIPTIONS.DES_RENTITY |
R5ENTITIES left outer join R5DESCRIPTIONS |
|
R5ENTITIES <--> R5DETAILAUDIT |
R5ENTITIES.ENT_RENTITY = R5DETAILAUDIT.DTA_RENTITY |
R5ENTITIES full outer join R5DETAILAUDIT |
|
R5ENTITIES <--> R5DOCENTITIES |
R5ENTITIES.ENT_RENTITY = R5DOCENTITIES.DAE_RENTITY |
R5ENTITIES left outer join R5DOCENTITIES |
|
R5ENTITIES <--> R5ENTITIES |
R5ENTITIES.ENT_RENTITY = R5ENTITIES.ENT_TYPENT |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5ENTITIES <--> R5ENTITYINDICATORS |
R5ENTITIES.ENT_RENTITY = R5ENTITYINDICATORS.EIN_RENTITY |
R5ENTITIES full outer join R5ENTITYINDICATORS |
|
R5ENTITIES <--> R5ENTITYPARTS |
R5ENTITIES.ENT_RENTITY = R5ENTITYPARTS.EPA_RENTITY |
R5ENTITIES left outer join R5ENTITYPARTS |
|
R5ENTITIES <--> R5ENTITYTABLES |
R5ENTITIES.ENT_RENTITY = R5ENTITYTABLES.ETT_RENTITY |
R5ENTITIES left outer join R5ENTITYTABLES |
|
R5ENTITIES <--> R5FUNCTIONTABS |
R5ENTITIES.ENT_RENTITY = R5FUNCTIONTABS.FTB_RENTITY |
R5ENTITIES full outer join R5FUNCTIONTABS |
|
R5ENTITIES <--> R5INDICATORVALU ES |
R5ENTITIES.ENT_RENTITY = R5INDICATORVALUES.IDV_RENTITY |
R5ENTITIES full outer join R5INDICATORVALUES |
|
R5ENTITIES <--> R5PERMENTITIES |
R5ENTITIES.ENT_RENTITY = R5PERMENTITIES.PRE_RENTITY |
R5ENTITIES left outer join R5PERMENTITIES |
|
R5ENTITIES <--> R5PROPERTIES |
R5ENTITIES.ENT_RENTITY = R5PROPERTIES.PRO_RENTITY |
R5ENTITIES full outer join R5PROPERTIES |
|
R5ENTITIES <--> R5PROPERTYVALU ES |
R5ENTITIES.ENT_RENTITY = R5PROPERTYVALUES.PRV_RENTITY |
R5ENTITIES full outer join R5PROPERTYVALUES |
|
R5ENTITIES <--> R5RCODES |
R5ENTITIES.ENT_RENTITY = R5RCODES.RCO_RENTITY |
R5ENTITIES left outer join R5RCODES |
|
R5ENTITIES <--> R5SERVICELOGS |
R5ENTITIES.ENT_RENTITY = R5SERVICELOGS.LOG_RENTITY |
R5ENTITIES left outer join R5SERVICELOGS |
|
R5EVENTS <--> R5ACTIVITIES |
R5EVENTS.EVT_CODE = R5ACTIVITIES.ACT_EVENT |
R5EVENTS left outer join R5ACTIVITIES |
|
R5EVENTS <--> R5AGREEMENTS |
R5EVENTS.EVT_CODE = R5AGREEMENTS.AGR_EVENT |
R5EVENTS full outer join R5AGREEMENTS |
|
R5EVENTS <--> R5CALCEVENTS |
R5EVENTS.EVT_CODE = R5CALCEVENTS.CEV_EVENT |
R5EVENTS left outer join R5CALCEVENTS |
|
R5EVENTS <--> R5DISPATCHES |
R5EVENTS.EVT_CODE = R5DISPATCHES.SWD_EVENT |
R5EVENTS full outer join R5DISPATCHES |
|
R5EVENTS <--> R5EVENTOBJECTS |
R5EVENTS.EVT_CODE = R5EVENTOBJECTS.EOB_EVENT |
R5EVENTS left outer join R5EVENTOBJECTS |
|
R5EVENTS <--> R5EVENTPOINTS |
R5EVENTS.EVT_CODE = R5EVENTPOINTS.EPO_JOB |
R5EVENTS full outer join R5EVENTPOINTS |
|
R5EVENTS <--> R5EVENTS |
R5EVENTS.EVT_CODE = R5EVENTS.EVT_PARENT |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5EVENTS <--> R5EVTINSTRUMENT S |
R5EVENTS.EVT_CODE = R5EVTINSTRUMENTS.EIS_EVENT |
R5EVENTS left outer join R5EVTINSTRUMENTS |
|
R5EVENTS <--> R5EVTSTANDARDS |
R5EVENTS.EVT_CODE = R5EVTSTANDARDS.EST_EVENT |
R5EVENTS full outer join R5EVTSTANDARDS |
|
R5EVENTS <--> R5EVTSYSTEMS |
R5EVENTS.EVT_CODE = R5EVTSYSTEMS.ESY_EVENT |
R5EVENTS left outer join R5EVTSYSTEMS |
|
R5EVENTS <--> R5EVTTESTPOINTS |
R5EVENTS.EVT_CODE = R5EVTTESTPOINTS.ETP_EVENT |
R5EVENTS left outer join R5EVTTESTPOINTS |
|
R5EVENTS <--> R5ISSUES |
R5EVENTS.EVT_CODE = R5ISSUES.ISS_EVENT |
R5EVENTS full outer join R5ISSUES |
|
R5EVENTS <--> R5JOBLINES |
R5EVENTS.EVT_CODE = R5JOBLINES.JBL_EVENT |
R5EVENTS left outer join R5JOBLINES |
|
R5EVENTS <--> R5REPAIRBINS |
R5EVENTS.EVT_CODE = R5REPAIRBINS.RPB_EVENT |
R5EVENTS full outer join R5REPAIRBINS |
|
R5EVENTS <--> R5WARCLAIMS |
R5EVENTS.EVT_CODE = R5WARCLAIMS.WCL_EVTCOMMISS |
R5EVENTS full outer join R5WARCLAIMS |
|
R5EXTINVOICES <--> R5EXTINVLINES |
R5EXTINVOICES.EIV_CODE = R5EXTINVLINES.EIL_INVOICE and R5EXTINVOICES.EIV_ORG = R5EXTINVLINES.EIL_INVOICE_ORG |
R5EXTINVOICES left outer join R5EXTINVLINES |
|
R5EXTMENUS <--> R5EXTMENULANG |
R5EXTMENUS.EMN_CODE = R5EXTMENULANG.EML_EXTMENU |
R5EXTMENUS left outer join R5EXTMENULANG |
|
R5FACILITIES <--> R5PARTMFGS |
R5FACILITIES.FAC_CODE = R5PARTMFGS.MFP_FACILITY |
R5FACILITIES full outer join R5PARTMFGS |
|
R5FACILITIES <--> R5STORES |
R5FACILITIES.FAC_CODE = R5STORES.STR_FACILITY |
R5FACILITIES full outer join R5STORES |
|
R5FACILITIES <--> R5USERS |
R5FACILITIES.FAC_CODE = R5USERS.USR_FACILITY |
R5FACILITIES full outer join R5USERS |
|
R5FAILURES <--> R5FAILURECLASSES |
R5FAILURES.FAL_CODE = R5FAILURECLASSES.FCA_FAILURE |
R5FAILURES left outer join R5FAILURECLASSES |
|
R5FINDINGS <--> R5FINCLASSES |
R5FINDINGS.FND_CODE = R5FINCLASSES.FCL_FIND |
R5FINDINGS left outer join R5FINCLASSES |
|
R5FLEETBILLINGCODES <--> R5FLEETBILLINGRATES |
R5FLEETBILLINGCODES.FBC_CODE = R5FLEETBILLINGRATES.FBR_BILLINGCODE and R5FLEETBILLINGCODES.FBC_ORG = R5FLEETBILLINGRATES.FBR_BILLINGCODE_ORG |
R5FLEETBILLINGCODES left outer join R5FLEETBILLINGRATES |
|
R5FLEETBILLINGCODES <--> R5FLEETBILLSUBLINES |
R5FLEETBILLINGCODES.FBC_CODE = R5FLEETBILLSUBLINES.FBS_BILLINGCODE and R5FLEETBILLINGCODES.FBC_ORG = R5FLEETBILLSUBLINES.FBS_BILLINGCODE_ORG |
R5FLEETBILLINGCODES full outer join R5FLEETBILLSUBLINES |
|
R5FLEETBILLINGCODES <--> R5FLEETCUSTOMERCODES |
R5FLEETBILLINGCODES.FBC_CODE = R5FLEETCUSTOMERCODES.FCD_BILLINGCODE and R5FLEETBILLINGCODES.FBC_ORG = R5FLEETCUSTOMERCODES.FCD_BILLINGCODE_ORG |
R5FLEETBILLINGCODES full outer join R5FLEETCUSTOMERC ODES |
|
R5FLEETBILLINGCODES <--> R5FLEETTICKETS |
R5FLEETBILLINGCODES.FBC_CODE = R5FLEETTICKETS.FTI_BILLINGCODE and R5FLEETBILLINGCODES.FBC_ORG = R5FLEETTICKETS.FTI_BILLINGCODE_ORG |
R5FLEETBILLINGCODES full outer join R5FLEETTICKETS |
|
R5FLEETBILLINGSCHEDULES <--> R5FLEETBILLS |
R5FLEETBILLINGSCHEDULES.FSC_PERIODENDDATE = R5FLEETBILLS.FBI_PERIODEND DATE |
R5FLEETBILLINGSCHEDULES full outer join R5FLEETBILLS |
|
R5FLEETBILLLINES<--> R5FLEETBILLSUBLINES |
R5FLEETBILLLINES.FBL_COSTCODE = R5FLEETBILLSUBLINES.FBS_COSTCODE AND R5FLEETBILLLINES.FBL_OBJECT = R5FLEETBILLSUBLINES.FBS_OBJECT AND R5FLEETBILLLINES.FBL_OBJECT_ORG = R5FLEETBILLSUBLINES.FBS_OBJECT_ORG AND R5FLEETBILLLINES.FBL_ADJUSTMENT = R5FLEETBILLSUBLINES.FBS_ADJUSTMENT AND R5FLEETBILLLINES.FBL_BILL = R5FLEETBILLSUBLINES.FBS_BILL |
R5FLEETBILLLINES full outer join R5FLEETBILLSUBLINES |
|
R5FLEETBILLS <--> R5BILLINGADJUSTMENTS |
R5FLEETBILLS.FBI_CODE = R5BILLINGADJUSTMENTS.FBA_ORIGINALBILL |
R5FLEETBILLS full outer join R5BILLINGADJUSTMENTS |
|
R5FLEETBILLS <--> R5FLEETBILLLINES |
R5FLEETBILLS.FBI_CODE = R5FLEETBILLLINES.FBL_BILL |
R5FLEETBILLS left outer join R5FLEETBILLLINES |
|
R5FLEETBILLSUBLI NES <--> R5BILLINGADJUSTMENTS |
R5FLEETBILLSUBLINES.FBS_PK = R5BILLINGADJUSTMENTS.FBA_BILLSUBLINE |
R5FLEETBILLSUBLINES full outer join R5BILLINGADJUSTMENTS |
|
R5FLEETBILLSUBLINES <--> R5FLEETTICKETEX CEPTIONS |
R5FLEETBILLSUBLINES.FBS_PK= R5FLEETTICKETEXCEPTIONS.FTE_BILLSUBLINE |
R5FLEETBILLSUBLINES full outer join R5BILLINGADJUSTMENTS |
|
R5FLEETBILLSUBLINES <--> R5FLEETTICKETS |
R5FLEETBILLSUBLINES.FBS_PK = R5FLEETTICKETS.FTI_BILLSUBLINE |
R5FLEETBILLSUBLINES full outer join R5FLEETTICKETS |
|
R5FLEETCUSTOMERS <--> R5FLEETBILLS |
R5FLEETCUSTOMERS.FCU_CODE = R5FLEETBILLS.FBI_FLEETCUSTOMER and R5FLEETCUSTOMERS.FCU_ORG = R5FLEETBILLS.FBI_FLEETCUSTOMER_ORG |
R5FLEETCUSTOMERS full outer join R5FLEETBILLS |
|
R5FLEETCUSTOMERS <--> R5FLEETCUSTOME RCODES |
R5FLEETCUSTOMERS.FCU_CODE = R5FLEETCUSTOMERCODES.FC D_FLEETCUSTOMER and R5FLEETCUSTOMERS.FCU_ORG = R5FLEETCUSTOMERCODES.FC D_FLEETCUSTOMER_ORG |
R5FLEETCUSTOMERS full outer join R5FLEETCUSTOMERCODES |
|
R5FLEETCUSTOMERS <--> R5FLEETTICKETS |
R5FLEETCUSTOMERS.FCU_ORG = R5FLEETTICKETS.FTI_FLEETCUSTOMER_ORG AND R5FLEETCUSTOMERS.FCU_CODE = R5FLEETTICKETS.FTI_FLEETCUSTOMER |
R5FLEETCUSTOMERS full outer join R5FLEETTICKETS |
|
R5FLEETEXCEPTIONS <--> R5BILLINGADJUSTMENTS |
R5FLEETEXCEPTIONS.FEX_ORG = R5BILLINGADJUSTMENTS.FBA_ EXCEPTION_ORG AND R5FLEETEXCEPTIONS.FEX_CODE = R5BILLINGADJUSTMENTS.FBA_EXCEPTION |
R5FLEETEXCEPTIONS full outer join R5BILLINGADJUSTMENTS |
|
R5FLEETEXCEPTIONS <--> R5FLEETTICKETEX CEPTIONS |
R5FLEETEXCEPTIONS.FEX_ORG = R5FLEETTICKETEXCEPTIONS.FTE_EXCEPTION_ORG AND R5FLEETEXCEPTIONS.FEX_CODE = R5FLEETTICKETEXCEPTIONS.FTE_EXCEPTION |
R5FLEETEXCEPTIONS full outer join R5FLEETTICKETEXCEPTIONS |
|
R5FLEETMARKUPCODES <--> R5FLEETCUSTOMERCODES |
R5FLEETMARKUPCODES.FMC_ORG = R5FLEETCUSTOMERCODES.FCD_MARKUPCODE_ORG AND R5FLEETMARKUPCODES.FMC_CODE = R5FLEETCUSTOMERCODES.FCD_MARKUPCODE |
R5FLEETMARKUPCODES full outer join R5FLEETCUSTOMERCODES |
|
R5FLEETMARKUPCODES <--> R5FLEETMARKUPRATES |
R5FLEETMARKUPCODES.FMC_ORG = R5FLEETMARKUPRATES.FMR_MARKUPCODE_ORG AND R5FLEETMARKUPCODES.FMC_CODE = R5FLEETMARKUPRATES.FMR_MARKUPCODE |
R5FLEETMARKUPCODES left outer join R5FLEETMARKUPRATES |
|
R5FLEETMARKUPCODES <--> R5FLEETTICKETS |
R5FLEETMARKUPCODES.FMC_ORG = R5FLEETTICKETS.FTI_MARKUPCODE_ORG AND R5FLEETMARKUPCODES.FMC_CODE = R5FLEETTICKETS.FTI_MARKUPCODE |
R5FLEETMARKUPCODES full outer join R5FLEETTICKETS |
|
R5FLEETTICKETS <--> R5BILLINGADJUSTMENTS |
R5FLEETTICKETS.FTI_CODE = R5BILLINGADJUSTMENTS.FBA_TICKET |
R5FLEETTICKETS full outer join R5BILLINGADJUSTMENTS |
|
R5FLEETTICKETS <--> R5FLEETBILLSUBLINES |
R5FLEETTICKETS.FTI_CODE = R5FLEETBILLSUBLINES.FBS_TICKET |
R5FLEETTICKETS full outer join R5FLEETBILLSUBLINES |
|
R5FLEETTICKETS <--> R5FLEETTICKETEXCEPTIONS |
R5FLEETTICKETS.FTI_CODE = R5FLEETTICKETEXCEPTIONS.FTE_TICKET |
R5FLEETTICKETS full outer join R5FLEETTICKETEXCEPTIONS |
|
R5FUNCTIONS <--> R5BOILERTEXTS |
R5FUNCTIONS.FUN_CODE = R5BOILERTEXTS.BOT_FUNCTION |
R5FUNCTIONS left outer join R5BOILERTEXTS |
|
R5FUNCTIONS <--> R5EXTMENUS |
R5FUNCTIONS.FUN_CODE = R5EXTMENUS.EMN_FUNCTION |
R5FUNCTIONS full outer join R5EXTMENUS |
|
R5FUNCTIONS <--> R5FUNCTIONS |
R5FUNCTIONS.FUN_CODE = R5FUNCTIONS.FUN_APPLICATION |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5FUNCTIONS <--> R5FUNCTIONTABS |
R5FUNCTIONS.FUN_CODE = R5FUNCTIONTABS.FTB_FUNCTION |
R5FUNCTIONS left outer join R5FUNCTIONTABS |
|
R5FUNCTIONS <--> R5FUNNOPERM |
R5FUNCTIONS.FUN_CODE = R5FUNNOPERM.FPN_FUNCTION |
R5FUNCTIONS left outer join R5FUNNOPERM |
|
R5FUNCTIONS <--> R5GRAPHPARMS |
R5FUNCTIONS.FUN_CODE = R5GRAPHPARMS.GPM_FUNCTION |
R5FUNCTIONS left outer join R5GRAPHPARMS |
|
R5FUNCTIONS <--> R5HOME |
R5FUNCTIONS.FUN_CODE = R5HOME.HOM_FUNCTION |
R5FUNCTIONS full outer join R5HOME |
|
R5FUNCTIONS <--> R5IPPERMISSIONS |
R5FUNCTIONS.FUN_CODE = R5IPPERMISSIONS.IPP_MNEMONIC |
R5FUNCTIONS full outer join R5IPPERMISSIONS |
|
R5FUNCTIONS <--> R5MENUS |
R5FUNCTIONS.FUN_CODE = R5MENUS.MEN_CALLING |
R5FUNCTIONS left outer join R5MENUS |
|
R5FUNCTIONS <--> R5PERMISSIONS |
R5FUNCTIONS.FUN_CODE = R5PERMISSIONS.PRM_FUNCTION |
R5FUNCTIONS left outer join R5PERMISSIONS |
|
R5FUNCTIONS <--> R5PULLDOWNMENU |
R5FUNCTIONS.FUN_CODE = R5PULLDOWNMENU.PDM_FUNCTION |
R5FUNCTIONS full outer join R5PULLDOWNMENU |
|
R5FUNCTIONS <--> R5REPORTFILTERS |
R5FUNCTIONS.FUN_CODE = R5REPORTFILTERS.RFI_FUNC |
R5FUNCTIONS left outer join R5REPORTFILTERS |
|
R5FUNCTIONS <--> R5REPPARMS |
R5FUNCTIONS.FUN_CODE = R5REPPARMS.PMT_LOVFUNCTION |
R5FUNCTIONS full outer join R5REPPARMS |
|
R5FUNCTIONS <--> R5SCREENFLOWS |
R5FUNCTIONS.FUN_CODE = R5SCREENFLOWS.SFL_SCREENFLOWCODE |
R5FUNCTIONS full outer join R5SCREENFLOWS |
|
R5FUNCTIONS <--> R5STOREDORDERING |
R5FUNCTIONS.FUN_CODE = R5STOREDORDERING.SOR_FUNC |
R5FUNCTIONS left outer join R5STOREDORDERING |
|
R5FUNCTIONS <--> R5STOREDQUERIE S |
R5FUNCTIONS.FUN_CODE = R5STOREDQUERIES.SQU_FUNC |
R5FUNCTIONS left outer join R5STOREDQUERIES |
|
R5FUNCTIONS <--> R5USERQAB |
R5FUNCTIONS.FUN_CODE = R5USERQAB.UQA_FUNCTION |
R5FUNCTIONS left outer join R5USERQAB |
|
R5FUNCTIONS <--> R5USERS |
R5FUNCTIONS.FUN_CODE = R5USERS.USR_LASTFUNC |
R5FUNCTIONS full outer join R5USERS |
|
R5FUNCTIONS <--> R5WIZARD |
R5FUNCTIONS.FUN_CODE = R5WIZARD.WIZ_FUNCTION |
R5FUNCTIONS left outer join R5WIZARD |
|
R5FUNCTIONTABS <--> R5TABNOPERM |
R5FUNCTIONTABS.FTB_TAB = R5TABNOPERM.TPN_TAB AND R5FUNCTIONTABS.FTB_FUNCTION = R5TABNOPERM.TPN_FUNCTION |
R5FUNCTIONTABS left outer join R5TABNOPERM |
|
R5FUNCTIONTABS <--> R5TABPERMISSIONS |
R5FUNCTIONTABS.FTB_TAB = R5TABPERMISSIONS.TRP_TAB AND R5FUNCTIONTABS.FTB_FUNCTION = R5TABPERMISSIONS.TRP_FUNCTION |
R5FUNCTIONTABS left outer join R5TABPERMISSIONS |
|
R5GLPROCESSDEF <--> R5GLREFERENCES |
R5GLPROCESSDEF.GPD_CODE = R5GLREFERENCES.GLF_PROCESS |
R5GLPROCESSDEF left outer join R5GLREFERENCES |
|
R5GRID <--> R5DDDATASPY |
R5GRID.GRD_GRIDID = R5DDDATASPY.DDS_GRIDID |
R5GRID full outer join R5DDDATASPY |
|
R5GRID <--> R5GRIDFIELD |
R5GRID.GRD_GRIDID = R5GRIDFIELD.GFD_GRIDID |
R5GRID left outer join R5GRIDFIELD |
|
R5GRID <--> R5USEGRIDGISDEFAULT |
R5GRID.GRD_GRIDID = R5USEGRIDGISDEFAULT.UGD_GRIDID |
R5GRID left outer join R5USEGRIDGISDEFAULT |
|
R5GRID <--> R5USEGRIDSYSDEFAULT |
R5GRID.GRD_GRIDID = R5USEGRIDSYSDEFAULT.USD_GRIDID |
R5GRID left outer join R5USEGRIDSYSDEFAULT |
|
R5GROUPS <--> R5AUTH |
R5GROUPS.UGR_CODE = R5AUTH.AUT_GROUP |
R5GROUPS full outer join R5AUTH |
|
R5GROUPS <--> R5EXTMENUS |
R5GROUPS.UGR_CODE = R5EXTMENUS.EMN_GROUP |
R5GROUPS full outer join R5EXTMENUS |
|
R5GROUPS <--> R5GISUGPREFERENCES |
R5GROUPS.UGR_CODE = R5GISUGPREFERENCES.GUP_UGRCODE |
where (R5GROUPS.UGR_CODE = R5GISUGPREFERENCES.GUP_UGRCODE) |
|
R5GROUPS <--> R5GROUPSEVALCODES |
R5GROUPS.UGR_CODE = R5GROUPSEVALCODES.GSE_UGRCODE |
R5GROUPS left outer join R5GROUPSEVALCODES |
|
R5GROUPS <--> R5HOMEGROUPS |
R5GROUPS.UGR_CODE = R5HOMEGROUPS.HMG_GROUP |
R5GROUPS left outer join R5HOMEGROUPS |
|
R5GROUPS <--> R5IPGROUPPERMISSIONS |
R5GROUPS.UGR_CODE = R5IPGROUPPERMISSIONS.IPG_GROUP |
where (R5GROUPS.UGR_CODE = R5IPGROUPPERMISSIONS.IPG_GROUP) |
|
R5GROUPS <--> R5JOBTYPEAUTH |
R5GROUPS.UGR_CODE = R5JOBTYPEAUTH.JTA_GROUP |
R5GROUPS left outer join R5JOBTYPEAUTH |
|
R5GROUPS <--> R5MENUS |
R5GROUPS <--> R5MENUS |
R5GROUPS left outer join R5MENUS |
|
R5GROUPS <--> R5OBJECTS |
R5GROUPS.UGR_CODE = R5OBJECTS.OBJ_GROUP |
R5GROUPS full outer join R5OBJECTS |
|
R5GROUPS <--> R5PERMISSIONS |
R5GROUPS.UGR_CODE = R5PERMISSIONS.PRM_GROUP |
R5GROUPS left outer join R5PERMISSIONS |
|
R5GROUPS <--> R5PULLDOWNMENU |
R5GROUPS.UGR_CODE = R5PULLDOWNMENU.PDM_GROUP |
R5GROUPS left outer join R5PULLDOWNMENU |
|
R5GROUPS <--> R5SCREENFLOWGROUPS |
R5GROUPS.UGR_CODE = R5SCREENFLOWGROUPS.SFG_USERGROUP |
R5GROUPS left outer join R5SCREENFLOWGROUPS |
|
R5GROUPS <--> R5SUPPEVALUATION |
R5GROUPS.UGR_CODE = R5SUPPEVALUATION.EVA_USERGROUP |
R5GROUPS full outer join R5SUPPEVALUATION |
|
R5GROUPS <--> R5TABPERMISSIONS |
R5GROUPS.UGR_CODE = R5TABPERMISSIONS.TRP_GROUP |
R5GROUPS left outer join R5TABPERMISSIONS |
|
R5GROUPS <--> R5USERORGANIZATION |
R5GROUPS.UGR_CODE = R5USERORGANIZATION.UOG_GROUP |
R5GROUPS full outer join R5USERORGANIZATION |
|
R5GROUPS <--> R5USERS |
R5GROUPS.UGR_CODE = R5USERS.USR_GROUP |
R5GROUPS full outer join R5USERS |
|
R5HOME <--> R5HOMEGROUPS |
R5HOME.HOM_CODE = R5HOMEGROUPS.HMG_HOMCODE and R5HOME.HOM_TYPE = R5HOMEGROUPS.HMG_HOMTYPE |
R5HOME left outer join R5HOMEGROUPS |
|
R5HOME <--> R5HOMEUSERS |
R5HOME.HOM_CODE = R5HOMEUSERS.HMU_HOMCODE and R5HOME.HOM_TYPE = R5HOMEUSERS.HMU_HOMTYPE |
R5HOME left outer join R5HOMEUSERS |
|
R5HOME <--> R5KPIHISTORY |
R5HOME.HOM_CODE = R5KPIHISTORY.KPH_HOMCODE and R5HOME.HOM_TYPE = R5KPIHISTORY.KPH_HOMTYPE |
R5HOME left outer join R5KPIHISTORY |
|
R5HOME <--> R5KPISCORES |
R5HOME.HOM_CODE = R5KPISCORES.KPS_HOMCODE and R5HOME.HOM_TYPE = R5KPISCORES.KPS_HOMTYPE |
R5HOME full outer join R5KPISCORES |
|
R5HOME <--> R5KPISTRUCTURE |
R5HOME.HOM_TYPE = R5KPISTRUCTURE.KPT_PARENTTYPE AND R5HOME.HOM_CODE = R5KPISTRUCTURE.KPT_PARENT |
R5HOME left outer join R5KPISTRUCTURE |
|
R5INDICATORS <--> R5ENTITYINDICATORS |
R5INDICATORS.IND_CODE = R5ENTITYINDICATORS.EIN_INDICATOR |
R5INDICATORS left outer join R5ENTITYINDICATORS |
|
R5INDICATORS <--> R5INDICATORVALUES |
R5INDICATORS.IND_CODE = R5INDICATORVALUES.IDV_INDICATOR |
R5INDICATORS full outer join R5INDICATORVALUES |
|
R5INTERFACE <--> R5INTERFACEERRORS |
R5INTERFACE.INT_TRANSID = R5INTERFACEERRORS.INE_TRANSID |
R5INTERFACE full outer join R5INTERFACEERRORS |
|
R5INVOICES <--> R5INVOICES |
R5INVOICES.INV_CODE = R5INVOICES.INV_PARENT and R5INVOICES.INV_ORG = R5INVOICES.INV_ORG |
RELATIONSHIP SQL DOES NOT EXIST |
|
R5IPFUNCTIONS <--> R5IPPERMISSIONS |
R5IPFUNCTIONS.IPF_CODE = R5IPPERMISSIONS.IPP_FUNCTION |
R5IPFUNCTIONS full outer join R5IPPERMISSIONS |
|
R5IPVENDORS <--> R5COMPANIES |
R5IPVENDORS.IPV_CODE = R5COMPANIES.COM_IPVENDOR |
R5IPVENDORS full outer join R5COMPANIES |
|
R5IPVENDORS <--> R5IPVENDORORDERTERMS |
R5IPVENDORS.IPV_CODE = R5IPVENDORORDERTERMS.IPT_CODE |
R5IPVENDORS left outer join R5IPVENDORORDERTERMS |
|
R5JOBS <--> R5SCHEDULEDJOBS |
R5JOBS.JOB_NAME = R5SCHEDULEDJOBS.SCJ_JOBNAME |
R5JOBS full outer join R5SCHEDULEDJOBS |
|
R5KBARTICLES <--> R5BBNOTICES |
R5KBARTICLES.KBA_CODE = R5BBNOTICES.BBN_KBARTICLE and R5KBARTICLES.KBA_ORG = R5BBNOTICES.BBN_KBARTICLE_ORG |
R5KBARTICLES full outer join R5BBNOTICES |
|
R5KBARTICLES <--> R5CONTACTRECORDS |
R5KBARTICLES.KBA_CODE = R5CONTACTRECORDS.CTR_KBARTICLE and R5KBARTICLES.KBA_ORG = R5CONTACTRECORDS.CTR_KBARTICLE_ORG |
R5KBARTICLES full outer join R5CONTACTRECORDS |
|
R5KBARTICLES <--> R5KBARTICLEDETAILS |
R5KBARTICLES.KBA_CODE = R5KBARTICLEDETAILS.KBD_KBARTICLE and R5KBARTICLES.KBA_ORG = R5KBARTICLEDETAILS.KBD_KBARTICLE_ORG |
R5KBARTICLES left outer join R5KBARTICLEDETAILS |
|
R5KBARTICLES <--> R5USERFAVORITEKBARTICLES |
R5KBARTICLES.KBA_CODE = R5USERFAVORITEKBARTICLES.UFK_KBARTICLE and R5KBARTICLES.KBA_ORG = R5USERFAVORITEKBARTICLES.UFK_KBARTICLE_ORG |
R5KBARTICLES left outer join R5USERFAVORITEKBARTICLES |
|
R5LANGINST <--> R5BOILERTEXTS |
R5LANGINST.LIN_CODE = R5BOILERTEXTS.BOT_LANG |
R5LANGINST left outer join R5BOILERTEXTS |
|
R5LANGINST <--> R5DESCRIPTIONS |
R5LANGINST.LIN_CODE = R5DESCRIPTIONS.DES_LANG |
R5LANGINST left outer join R5DESCRIPTIONS |
|
R5LANGINST <--> R5ERRTEXTS |
R5LANGINST.LIN_CODE = R5ERRTEXTS.ERT_LANG |
R5LANGINST left outer join R5ERRTEXTS |
|
R5LANGINST <--> R5EXTMENULANG |
R5LANGINST.LIN_CODE = R5EXTMENULANG.EML_LANG |
R5LANGINST left outer join R5EXTMENULANG |
|
R5LANGINST <--> R5HELPTEXTS |
R5LANGINST.LIN_CODE = R5HELPTEXTS.HEL_LANG |
R5LANGINST left outer join R5HELPTEXTS |
|
R5LANGINST <--> R5PDMLANG |
R5LANGINST.LIN_CODE = R5PDMLANG.PDL_LANG |
R5LANGINST left outer join R5PDMLANG |
|
R5LANGINST <--> R5USERS |
R5LANGINST.LIN_CODE = R5USERS.USR_LANG |
R5LANGINST full outer join R5USERS |
|
R5LANGUAGES <--> R5ADDETAILS |
R5LANGUAGES.LAN_CODE = R5ADDETAILS.ADD_LANG |
R5LANGUAGES left outer join R5ADDETAILS |
|
R5LANGUAGES <--> R5COMPANIES |
R5LANGUAGES.LAN_CODE = R5COMPANIES.COM_LANG |
R5LANGUAGES full outer join R5COMPANIES |
|
R5LANGUAGES <--> R5DETAILAUDIT |
R5LANGUAGES.LAN_CODE = R5DETAILAUDIT.DTA_LANG |
R5LANGUAGES full outer join R5DETAILAUDIT |
|
R5LANGUAGES <--> R5IPVENDORS |
R5LANGUAGES.LAN_CODE = R5IPVENDORS.IPV_LANG |
R5LANGUAGES full outer join R5IPVENDORS |
|
R5LANGUAGES <--> R5QUOTATIONS |
R5LANGUAGES.LAN_CODE = R5QUOTATIONS.QUO_LANG |
R5LANGUAGES full outer join R5QUOTATIONS |
|
R5LANGUAGES <--> R5QUOTTASKS |
R5LANGUAGES.LAN_CODE = R5QUOTTASKS.QUT_LANG |
R5LANGUAGES full outer join R5QUOTTASKS |
|
R5LOCALE <--> R5ORGANIZATION |
R5LOCALE.LOC_CODE = R5ORGANIZATION.ORG_LOCAL E |
R5LOCALE full outer join R5ORGANIZATION |
|
R5LOCALE <--> R5USERS |
R5LOCALE.LOC_CODE = R5USERS.USR_LOCALE |
R5LOCALE full outer join R5USERS |
|
R5LOTS <--> R5BINSTOCK |
R5LOTS.LOT_CODE = R5BINSTOCK.BIS_LOT |
R5LOTS left outer join R5BINSTOCK |
|
R5LOTS <--> R5EVTSTANDARDS |
R5LOTS.LOT_CODE = R5EVTSTANDARDS.EST_LOT |
R5LOTS full outer join R5EVTSTANDARDS |
|
R5LOTS <--> R5OBJECTS |
R5LOTS.LOT_CODE = R5OBJECTS.OBJ_LOT |
R5LOTS full outer join R5OBJECTS |
|
R5LOTS <--> R5TRANSTOCK |
R5LOTS.LOT_CODE = R5TRANSTOCK.TST_LOT |
R5LOTS full outer join R5TRANSTOCK |
|
R5MAILATTRIBS <--> R5MAILCONDITIONS |
R5MAILATTRIBS.MAA_TEMPLATE = R5MAILCONDITIONS.MAC_TEMPLATE AND R5MAILATTRIBS.MAA_TABLE = R5MAILCONDITIONS.MAC_TABLE |
R5MAILATTRIBS full outer join R5MAILCONDITIONS |
|
R5MAILATTRIBS <--> R5MAILPARAMETERS |
R5MAILATTRIBS.MAA_TEMPLATE = R5MAILPARAMETERS.MAP_TEMPLATE AND R5MAILATTRIBS.MAA_TABLE = R5MAILPARAMETERS.MAP_TABLE |
R5MAILATTRIBS left outer join R5MAILPARAMETERS |
|
R5MAILTEMPLATE <--> R5MAILEVENTS |
R5MAILTEMPLATE.MAT_CODE = R5MAILEVENTS.MAE_TEMPLATE |
R5MAILTEMPLATE full outer join R5MAILEVENTS |
|
R5MANUFACTURERS <--> R5ACTIVITIES |
R5MANUFACTURERS.MFG_CODE = R5ACTIVITIES.ACT_MANUFACT |
R5MANUFACTURERS full outer join R5ACTIVITIES |
|
R5MANUFACTURERS <--> R5DOCUMENTS |
R5MANUFACTURERS.MFG_CODE = R5DOCUMENTS.DOC_MANUFACTURER |
R5MANUFACTURERS fullouter join R5DOCUMENTS |
|
R5MANUFACTURERS <-->R5PARTMFGS |
R5MANUFACTURERS.MFG_CODE = R5PARTMFGS.MFP_MANUFACTURER |
R5MANUFACTURERS full outer join R5PARTMFGS |
|
R5MANUFACTURERS <--> R5PPMACTS |
R5MANUFACTURERS.MFG_CODE = R5PPMACTS.PPA_MANUFACT |
R5MANUFACTURERS full outer join R5PPMACTS |
|
R5MANUFACTURERS <--> R5REQUISLINES |
R5MANUFACTURERS.MFG_CODE = R5REQUISLINES.RQL_MANUFACTURER |
R5MANUFACTURERS full outer join R5REQUISLINES |
|
R5MANUFACTURERS<--> R5STANDWACTS |
R5MANUFACTURERS.MFG_CODE = R5STANDWACTS.WAC_MANUFACT |
R5MANUFACTURERS full outer join R5STANDWACTS |
|
R5MANUFACTURERS<--> R5TASKS |
R5MANUFACTURERS.MFG_CODE = R5TASKS.TSK_MANUFACT |
R5MANUFACTURERS full outer join R5TASKS |
|
R5MATERIALSTANDARDS <--> R5INSPECTEQUIPDATA |
R5MATERIALSTANDARDS.MST_CODE = R5INSPECTEQUIPDATA.IED_MATERIAL and R5MATERIALSTANDARDS.MST_REVISION = R5INSPECTEQUIPDATA.IED_MATERIALREV |
R5MATERIALSTANDARDS full outer join R5INSPECTEQUIPDATA |
|
R5MATERIALSTANDARDS <--> R5PIPINGCLASS |
R5MATERIALSTANDARDS.MST_CODE = R5PIPINGCLASS.PCS_MATERIAL and R5MATERIALSTANDARDS.MST_REVISION = R5PIPINGCLASS.PCS_MATERIALREV |
R5MATERIALSTANDARDS full outer join R5PIPINGCLASS |
|
R5MATLISTS <--> R5ACTIVITIES |
R5MATLISTS.MTL_CODE = R5ACTIVITIES.ACT_MATLIST and R5MATLISTS.MTL_REVISION = R5ACTIVITIES.ACT_MATLREV |
R5MATLISTS full outer join R5ACTIVITIES |
|
R5MATLISTS <--> R5MATLPARTS |
R5MATLISTS.MTL_CODE = R5MATLPARTS.MLP_MATLIST and R5MATLISTS.MTL_REVISION = R5MATLPARTS.MLP_MATLREV |
R5MATLISTS left outer join R5MATLPARTS |
|
R5METERS <--> R5OBJUSAGEDEFS |
R5METERS.MET_CODE = R5OBJUSAGEDEFSOUD_METER |
R5METERS full outer join R5OBJUSAGEDEFS |
|
R5METERS <--> R5READINGS |
R5METERS.MET_CODE = R5READINGS.REA_METER |
R5METERS full outer join R5READINGS |
|
R5METHODS <--> R5ASPECTPOINTS |
R5METHODS.MTH_CODE = R5ASPECTPOINTS.APO_METHOD |
R5METHODS full outer join R5ASPECTPOINTS |
|
R5METHODS <--> R5EVENTPOINTS |
R5METHODS.MTH_CODE = R5EVENTPOINTS.EPO_METHOD |
R5METHODS full outer join R5EVENTPOINTS |
|
R5METHODS <--> R5OBJECTASPECT S |
R5METHODS.MTH_CODE = R5OBJECTASPECTS.OBA_METHOD |
R5METHODS full outer join R5OBJECTASPECTS |
|
R5METHODS <--> R5PARTS |
R5METHODS.MTH_CODE = R5PARTS.PAR_INSMETHOD |
R5METHODS full outer join R5PARTS |
|
R5MINMAXFORMULAS <--> R5MINMAXFORMPA RAM |
R5MINMAXFORMULAS.MMF_CODE = R5MINMAXFORMPARAM.FOP_FORMULA |
R5MINMAXFORMULAS left outer join R5MINMAXFORMPARAM |
|
R5MINMAXPARAMETERS <--> R5MINMAXFORMPARAM |
R5MINMAXPARAMETERS.MMP_CODE = R5MINMAXFORMPARAM.FOP_PARAMETER |
R5MINMAXPARAMETERS left outer join R5MINMAXFORMPARAM |
|
R5MINORITYGROUPS <--> R5COMPANIES |
R5MINORITYGROUPS.MNG_CODE = R5COMPANIES.COM_MINORITY GROUP |
R5MINORITYGROUPS full outer join R5COMPANIES |
|
R5MINORITYGROUPS <--> R5COMPANIES1 |
R5MINORITYGROUPS.MNG_CODE = R5COMPANIES.COM_MINORITYGROUP |
where (R5MINORITYGROUPS.MNG_CODE = R5COMPANIES.COM_MINORITYGROUP) |
|
R5MPACTIVITIES <--> R5MPTOOLACTIVITIES |
R5MPACTIVITIES.MPA_EVENT = R5MPTOOLACTIVITIES.TOA_EVENT AND R5MPACTIVITIES.MPA_ACT = R5MPTOOLACTIVITIES.TOA_ACTAND R5MPACTIVITIES.MPA_MPPROJ = R5MPTOOLACTIVITIES.TOA_MPPROJ |
R5MPACTIVITIES left outer join R5MPTOOLACTIVITIES |
|
R5MPEVENTS <--> R5MPACTIVITIES |
R5MPEVENTS.MPE_EVENT = R5MPACTIVITIES.MPA_EVENT AND R5MPEVENTS.MPE_MPPROJ = R5MPACTIVITIES.MPA_MPPROJ |
R5MPEVENTS left outer join R5MPACTIVITIES |
|
R5MPPROJECTS <--> R5MPEVENTS |
R5MPPROJECTS.MPJ_CODE = R5MPEVENTS.MPE_MPPROJ |
R5MPPROJECTS left outer join R5MPEVENTS |
|
R5MPPROJECTS <--> R5MPOBJECTS |
R5MPPROJECTS.MPJ_CODE = R5MPOBJECTS.MPO_MPPROJ |
R5MPPROJECTS left outer join R5MPOBJECTS |
|
R5MPPROJECTS <--> R5MPTOOLS |
R5MPPROJECTS.MPJ_CODE = R5MPTOOLS.MPT_MPPROJ |
R5MPPROJECTS full outer join R5MPTOOLS |
|
R5MRCS <--> R5ACTIVITIES |
R5MRCS.MRC_CODE = R5ACTIVITIES.ACT_MRC |
R5MRCS full outer join R5ACTIVITIES |
|
R5MRCS <--> R5ACTSCHEDULES |
R5MRCS.MRC_CODE = R5ACTSCHEDULES.ACS_MRC |
R5MRCS full outer join R5ACTSCHEDULES |
|
R5MRCS <--> R5AVAILABILITY |
R5MRCS.MRC_CODE = R5AVAILABILITY.AVL_MRC |
R5MRCS left outer join R5AVAILABILITY |
|
R5MRCS <--> R5BOOKEDHOURS |
R5MRCS.MRC_CODE = R5BOOKEDHOURS.BOO_MRC |
R5MRCS full outer join R5BOOKEDHOURS |
|
R5MRCS <--> R5BUDGETDETAILS |
R5MRCS.MRC_CODE = R5BUDGETDETAILS.BDT_MRC |
R5MRCS full outer join R5BUDGETDETAILS |
|
R5MRCS <--> R5DOCKLINES |
R5MRCS.MRC_CODE = R5DOCKLINES.DKL_MRC |
R5MRCS full outer join R5DOCKLINES |
|
R5MRCS <--> R5DOCKRECEIPTS |
R5MRCS.MRC_CODE = R5DOCKRECEIPTS.DCK_MRC |
R5MRCS full outer join R5DOCKRECEIPTS |
|
R5MRCS <--> R5DSCHAVAIL |
R5MRCS.MRC_CODE = R5DSCHAVAIL.SHA_MRC |
R5MRCS full outer join R5DSCHAVAIL |
|
R5MRCS <--> R5EVENTS |
R5MRCS.MRC_CODE = R5EVENTS.EVT_MRC |
R5MRCS full outer join R5EVENTS |
|
R5MRCS <--> R5GROUPS |
R5MRCS.MRC_CODE = R5GROUPS.UGR_MRC |
R5MRCS full outer join R5GROUPS |
|
R5MRCS <--> R5MRCTOOLS |
R5MRCS.MRC_CODE = R5MRCTOOLS.MRT_MRC |
R5MRCS left outer join R5MRCTOOLS |
|
R5MRCS <--> R5OBJECTS |
R5MRCS.MRC_CODE = R5OBJECTS.OBJ_MRC |
R5MRCS full outer join R5OBJECTS |
|
R5MRCS <--> R5PERSONNEL |
R5MRCS.MRC_CODE = R5PERSONNEL.PER_MRC |
R5MRCS full outer join R5PERSONNEL |
|
R5MRCS <--> R5PPMOBJECTS |
R5MRCS.MRC_CODE = R5PPMOBJECTS.PPO_MRC |
R5MRCS full outer join R5PPMOBJECTS |
|
R5MRCS <--> R5STOCK |
R5MRCS.MRC_CODE = R5STOCK.STO_REPMRC |
R5MRCS full outer join R5STOCK |
|
R5MRCS <--> R5TOOLREQ |
R5MRCS.MRC_CODE = R5TOOLREQ.TOR_MRC |
R5MRCS left outer join R5TOOLREQ |
|
R5MRCS <--> R5TOOLUSAGE |
R5MRCS.MRC_CODE = R5TOOLUSAGE.TOU_MRC |
R5MRCS left outer join R5TOOLUSAGE |
|
R5MRCS <--> R5TRADERATES |
R5MRCS.MRC_CODE = R5TRADERATES.TRR_MRC |
R5MRCS left outer join R5TRADERATES |
|
R5MRCS <--> R5USERS |
R5MRCS.MRC_CODE = R5USERS.USR_MRC |
R5MRCS full outer join R5USERS |
|
R5MRCS <--> R5WORKPACKAGE S |
R5MRCS.MRC_CODE = R5WORKPACKAGES.WPK_MRC |
R5MRCS full outer join R5WORKPACKAGES |
|
R5OBJECTAUDITS <--> R5OBJECTAUDITERRORS |
R5OBJECTAUDITS.OAD_BATCHNAME = R5OBJECTAUDITERRORS.OAE_BATCHNAME |
R5OBJECTAUDITS full outer join R5OBJECTAUDITERRORS |
|
R5OBJECTAUDITS <--> R5OBJECTAUDITLINES |
R5OBJECTAUDITS.OAD_BATCHNAME = R5OBJECTAUDITLINES.OAL_BATCHNAME |
R5OBJECTAUDITS full outer join R5OBJECTAUDITLINES |
|
R5OBJECTS <--> R5ACTSCHEDULES |
R5OBJECTS.OBJ_ORG = R5ACTSCHEDULES.ACS_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5ACTSCHEDULES.ACS_OBJECT |
R5OBJECTS full outer join R5ACTSCHEDULES |
|
R5OBJECTS <--> R5AGREEMENTS |
R5OBJECTS.OBJ_ORG = R5AGREEMENTS.AGR_OBJECT_ ORG AND R5OBJECTS.OBJ_CODE = R5AGREEMENTS.AGR_OBJECT |
R5OBJECTS full outer join R5AGREEMENTS |
|
R5OBJECTS <--> R5BUDGETDETAILS |
R5OBJECTS.OBJ_ORG = R5BUDGETDETAILS.BDT_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5BUDGETDETAILS.BDT_OBJECT |
R5OBJECTS full outer join R5BUDGETDETAILS |
|
R5OBJECTS <--> R5CNLOCATIONS |
R5OBJECTS.OBJ_ORG = R5CNLOCATIONS.CNC_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5CNLOCATIONS.CNC_OBJECT |
R5OBJECTS left outer join R5CNLOCATIONS |
|
R5OBJECTS <--> R5CNLOCATIONS |
R5OBJECTS.OBJ_ORG = R5CNLOCATIONS.CNC_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5CNLOCATIONS.CNC_OBJECT |
where ((R5OBJECTS.OBJ_ORG = R5CNLOCATIONS.CNC_OBJECT_ORG) and (R5OBJECTS.OBJ_CODE = R5CNLOCATIONS.CNC_OBJECT)) |
|
R5OBJECTS <--> R5DIAGUSAGES |
R5OBJECTS.OBJ_ORG = R5DIAGUSAGES.DIU_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5DIAGUSAGES.DIU_OBJECT |
R5OBJECTS left outer join R5DIAGUSAGES |
|
R5OBJECTS <--> R5ENTITYINDICATORS |
R5OBJECTS.OBJ_CODE = R5ENTITYINDICATORS.EIN_CODE and R5OBJECTS.OBJ_ORG = R5ENTITYINDICATORS.EIN_CODE_ORG |
R5OBJECTS left outer join R5ENTITYINDICATORS |
|
R5OBJECTS <--> R5EVENTOBJECTS |
R5OBJECTS.OBJ_CODE = R5EVENTOBJECTS.EOB_OBJECT and R5OBJECTS.OBJ_ORG = R5EVENTOBJECTS.EOB_OBJECT_ORG |
R5OBJECTS left outer join R5EVENTOBJECTS |
|
R5OBJECTS <--> R5EVENTS |
R5OBJECTS.OBJ_CODE = R5EVENTS.EVT_OBJECT and R5OBJECTS.OBJ_ORG = R5EVENTS.EVT_OBJECT_ORG |
R5OBJECTS full outer join R5EVENTS |
|
R5OBJECTS <--> R5EVTINSTRUMENTS |
R5OBJECTS.OBJ_CODE = R5EVTINSTRUMENTS.EIS_OBJECT and R5OBJECTS.OBJ_ORG = R5EVTINSTRUMENTS.EIS_OBJECT_ORG |
R5OBJECTS left outer join R5EVTINSTRUMENTS |
|
R5OBJECTS <--> R5EVTSTANDARDS |
R5OBJECTS.OBJ_CODE = R5EVTSTANDARDS.EST_OBJECT and R5OBJECTS.OBJ_ORG = R5EVTSTANDARDS.EST_OBJECT_ORG |
R5OBJECTS full outer join R5EVTSTANDARDS |
|
R5OBJECTS <--> R5EVTSYSTEMS |
R5OBJECTS.OBJ_CODE = R5EVTSYSTEMS.ESY_SYSTEM and R5OBJECTS.OBJ_ORG = R5EVTSYSTEMS.ESY_SYSTEM_ORG |
R5OBJECTS left outer join R5EVTSYSTEMS |
|
R5OBJECTS <--> R5EVTTESTPOINTS |
R5OBJECTS.OBJ_CODE = R5EVTTESTPOINTS.ETP_OBJECT and R5OBJECTS.OBJ_ORG = R5EVTTESTPOINTS.ETP_OBJECT_ORG |
where ((R5OBJECTS.OBJ_ORG = R5EVTTSTPOINTS.ETP_OBJECT_ORG) and (R5OBJECTS.OBJ_CODE = R5EVTTESTPOINTS.ETP_OBJECT)) |
|
R5OBJECTS <--> R5EVTTESTPOINTS |
R5OBJECTS.OBJ_CODE = R5EVTTESTPOINTS.ETP_OBJECT and R5OBJECTS.OBJ_ORG = R5EVTTESTPOINTS.ETP_OBJECT_ORG |
R5OBJECTS left outer join R5EVTTESTPOINTS |
|
R5OBJECTS <--> R5GISUGPREFERENCES |
R5OBJECTS.OBJ_CODE = R5GISUGPREFERENCES.GUP_PROFILE and R5OBJECTS.OBJ_ORG = R5GISUGPREFERENCES.GUP_PROFILE_ORG |
where ((R5OBJECTS.OBJ_ORG = R5GISUGPREFERENCES.GUP_PROFILE_ORG) and (R5OBJECTS.OBJ_CODE = R5GISUGPREFERENCES.GUP_PROFILE)) |
|
R5OBJECTS <--> R5GISUGPREFERENCES |
R5OBJECTS.OBJ_CODE = R5GISUGPREFERENCES.GUP_PROFILE and R5OBJECTS.OBJ_ORG = R5GISUGPREFERENCES.GUP_PROFILE_ORG |
R5OBJECTS left outer join R5GISUGPREFERENCES |
|
R5OBJECTS <--> R5INSPECTEQUIPDATA |
R5OBJECTS.OBJ_CODE = R5INSPECTEQUIPDATA.IED_OBJECT and R5OBJECTS.OBJ_ORG = R5INSPECTEQUIPDATA.IED_OBJECT_ORG |
R5OBJECTS left outer join R5INSPECTEQUIPDATA |
|
R5OBJECTS <--> R5MATLPARTS |
R5OBJECTS.OBJ_CODE = R5MATLPARTS.MLP_CODE and R5OBJECTS.OBJ_ORG = R5MATLPARTS.MLP_CODE_ORG |
R5OBJECTS full outer join R5MATLPARTS |
|
R5OBJECTS <--> R5OBJDEPRECIATION |
R5OBJECTS.OBJ_CODE = R5OBJDEPRECIATION.ODP_OBJECT and R5OBJECTS.OBJ_ORG = R5OBJDEPRECIATION.ODP_OBJECT_ORG |
where ((R5OBJECTS.OBJ_ORG = R5OBJDPRECIATION.ODP_OBJECT_ORG) and (R5OBJECTS.OBJ_CODE = R5OBJDEPRECIATION.ODP_OBJECT)) |
|
R5OBJECTS <--> R5OBJDEPRECIATION |
R5OBJECTS.OBJ_CODE = R5OBJDEPRECIATION.ODP_OBJECT and R5OBJECTS.OBJ_ORG = R5OBJDEPRECIATION.ODP_OBJECT_ORG |
R5OBJECTS left outer join R5OBJDEPRECIATION |
|
R5OBJECTS <--> R5OBJDEPTYPES |
R5OBJECTS.OBJ_CODE = R5OBJDEPTYPES.OBD_OBJECT and R5OBJECTS.OBJ_ORG = R5OBJDEPTYPES.OBD_OBJECT_ORG |
R5OBJECTS left outer join R5OBJDEPTYPES |
|
R5OBJECTS <--> R5OBJDEPTYPES |
R5OBJECTS.OBJ_CODE = R5OBJDEPTYPES.OBD_OBJECT and R5OBJECTS.OBJ_ORG = R5OBJDEPTYPES.OBD_OBJECT_ORG |
NO JOINS EXIST |
|
R5OBJECTS <--> R5OBJECTASPECT S |
R5OBJECTS.OBJ_CODE = R5OBJECTASPECTS.OBA_OBJECT and R5OBJECTS.OBJ_ORG = R5OBJECTASPECTS.OBA_OBJECT_ORG |
R5OBJECTS left outer join R5OBJECTASPECTS |
|
R5OBJECTS <--> R5OBJECTRISK |
R5OBJECTS.OBJ_CODE = R5OBJECTRISK.OBR_OBJECT and R5OBJECTS.OBJ_ORG = R5OBJECTRISK.OBR_OBJECT_ORG |
R5OBJECTS full outer join R5OBJECTRISK |
|
R5OBJECTS <--> R5OBJECTRISK |
R5OBJECTS.OBJ_CODE = R5OBJECTRISK.OBR_OBJECT and R5OBJECTS.OBJ_ORG = R5OBJECTRISK.OBR_OBJECT_ORG |
where ((R5OBJECTS.O BJ_CODE = R5OBJECTRISK.OBR_OBJECT) and (R5OBJECTS.OBJ_ORG = R5OBJECTRISK.OBR_OBJECT_ORG)) |
|
R5OBJECTS <--> R5OBJLINEARREF |
R5OBJECTS.OBJ_ORG = R5OBJLINEARREF.LRF_OBJORG AND R5OBJECTS.OBJ_CODE = R5OBJLINEARREF.LRF_OBJCODE |
R5OBJECTS full outer join R5OBJLINEARREF |
|
R5OBJECTS <--> R5OBJTESTPOINTS |
R5OBJECTS.OBJ_ORG = R5OBJTESTPOINTS.OTP_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5OBJTESTPOINTS.OTP_OBJECT |
R5OBJECTS left outer join R5OBJTESTPOINTS |
|
R5OBJECTS <--> R5OBJUNITS |
R5OBJECTS.OBJ_ORG = R5OBJUNITS.OBU_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5OBJUNITS.OBU_OBJECT |
R5OBJECTS left outer join R5OBJUNITS |
|
R5OBJECTS <--> R5OBJUSAGEDEFS |
R5OBJECTS.OBJ_ORG = R5OBJUSAGEDEFS.OUD_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5OBJUSAGEDEFS.OUD_OBJECT |
where ((R5OBJECTS.OBJ_ORG = R5OBJUSAGEDEFS.OUD_OBJECT_ORG) and (R5OBJECTS.OBJ_CODE = R5OBJUSAGEDEFS.OUD_OBJECT)) |
|
R5OBJECTS <--> R5OBJUSAGEDEFS |
R5OBJECTS.OBJ_CODE = R5OBJUSAGEDEFS.OUD_OBJECT and R5OBJECTS.OBJ_ORG = R5OBJUSAGEDEFS.OUD_OBJECT_ORG |
R5OBJECTS left outer join R5OBJUSAGEDEFS |
|
R5OBJECTS <--> R5PICKLISTS |
R5OBJECTS.OBJ_CODE = R5PICKLISTS.PIC_OBJECT and R5OBJECTS.OBJ_ORG = R5PICKLISTS.PIC_OBJECT_ORG |
R5OBJECTS full outer join R5PICKLISTS |
|
R5OBJECTS <--> R5POINTS |
R5OBJECTS.OBJ_CODE = R5POINTS.POI_OBJECT and R5OBJECTS.OBJ_ORG = R5POINTS.POI_OBJECT_ORG |
R5OBJECTS left outer join R5POINTS |
|
R5OBJECTS <--> R5PPMCALENDARS |
R5OBJECTS.OBJ_CODE = R5PPMCALENDARS.PPC_OBJECT and R5OBJECTS.OBJ_ORG = R5PPMCALENDARS.PPC_OBJECT_ORG |
R5OBJECTS left outer join R5PPMCALENDARS |
|
R5OBJECTS <--> R5PPMOBJECTS |
R5OBJECTS.OBJ_CODE = R5PPMOBJECTS.PPO_OBJECT and R5OBJECTS.OBJ_ORG = R5PPMOBJECTS.PPO_OBJECT_ORG |
R5OBJECTS full outer join R5PPMOBJECTS |
|
R5OBJECTS <--> R5READINGS |
R5OBJECTS.OBJ_CODE = R5READINGS.REA_OBJECT and R5OBJECTS.OBJ_ORG = R5READINGS.REA_OBJECT_ORG |
R5OBJECTS full outer join R5READINGS |
|
R5OBJECTS <--> R5READINGS |
R5OBJECTS.OBJ_CODE = R5READINGS.REA_OBJECT and R5OBJECTS.OBJ_ORG = R5READINGS.REA_OBJECT_ORG |
where ((R5OBJECTS.OBJ_CODE = R5READINGS.REA_OBJECT) and (R5OBJECTS.OBJ_ORG = R5READINGS.REA_OBJECT_ORG)) |
|
R5OBJECTS <--> R5ROUTEPOINTS |
R5OBJECTS.OBJ_CODE = R5ROUTEPOINTS.ROP_OBJECT and R5OBJECTS.OBJ_ORG = R5ROUTEPOINTS.ROP_OBJECT_ORG |
R5OBJECTS full outer join R5ROUTEPOINTS |
|
R5OBJECTS <--> R5ROUTEPOINTS |
R5OBJECTS.OBJ_ORG = R5ROUTEPOINTS.ROP_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5ROUTEPOINTS.ROP_OBJECT |
where ((R5OBJECTS.OBJ_ORG = R5ROUTPOINTS.ROP_OBJECT_ORG) and (R5OBJECTS.OBJ_CODE = R5ROUTEPOINTS.ROP_OBJECT)) |
|
R5OBJECTS <--> R5ROUTOBJECTS |
R5OBJECTS.OBJ_ORG = R5ROUTOBJECTS.ROB_OBJECT_ORG AND R5OBJECTS.OBJ_CODE= R5ROUTOBJECTS.ROB_OBJECT |
R5OBJECTS full outer join R5ROUTOBJECTS |
|
R5OBJECTS <--> R5SERVICECODES |
R5OBJECTS.OBJ_CODE = R5SERVICECODES.SRV_OBJECT and R5OBJECTS.OBJ_ORG = R5SERVICECODES.SRV_OBJECT_ORG |
R5OBJECTS full outer join R5SERVICECODES |
|
R5OBJECTS <--> R5SERVICEREQUEST |
R5OBJECTS.OBJ_CODE = R5SERVICEREQUESTS.SRQ_OBJECT and R5OBJECTS.OBJ_ORG = R5SERVICEREQUESTS.SRQ_OBJECT_ORG |
R5OBJECTS full outer join R5SERVICEREQUESTS |
|
R5OBJECTS <--> R5SHUTDOWNOBJECTS |
R5OBJECTS.OBJ_ORG = R5SHUTDOWNOBJECTS.SOB_OBJECT_ORG AND R5OBJECTS.OBJ_CODE = R5SHUTDOWNOBJECTS.SOB_OBJECT |
R5OBJECTS full outer join R5SHUTDOWNOBJECTS |
|
R5OBJECTS <--> R5STOCK |
R5OBJECTS.OBJ_CODE = R5STOCK.STO_REPOBJECT and R5OBJECTS.OBJ_ORG = R5STOCK.STO_REPOBJECT_ORG |
R5OBJECTS full outer join R5STOCK |
|
R5OBJECTS <--> R5STORES |
R5OBJECTS.OBJ_CODE = R5STORES.STR_LOCATION and R5OBJECTS.OBJ_ORG = R5STORES.STR_LOCATION_ORG |
R5OBJECTS full outer join R5STORES |
|
R5OBJECTS <--> R5WARCLAIMS |
R5OBJECTS.OBJ_CODE = R5WARCLAIMS.WCL_TOPPARENT and R5OBJECTS.OBJ_ORG = R5WARCLAIMS.WCL_TOPPARENT_ORG |
R5OBJECTS full outer join R5WARCLAIMS |
|
R5OBJECTS <--> R5WARCOVERAGES |
R5OBJECTS.OBJ_CODE = R5WARCOVERAGES.WCV_OBJECT and R5OBJECTS.OBJ_ORG = R5WARCOVERAGES.WCV_OBJECT_ORG |
R5OBJECTS full outer join R5WARCOVERAGES |
|
R5OBJECTS <--> R5WORKPACKAGES |
R5OBJECTS.OBJ_CODE = R5WORKPACKAGES.WPK_OBJECT and R5OBJECTS.OBJ_ORG = R5WORKPACKAGES.WPK_OBJECT_ORG |
R5OBJECTS full outer join R5WORKPACKAGES |
|
R5OBJUSAGEDEFS <--> R5WARCOVERAGES |
R5OBJUSAGEDEFS.OUD_OBJECT = R5WARCOVERAGES.WCV_OBJECT and R5OBJUSAGEDEFS.OUD_OBJECT_ORG = R5WARCOVERAGES.WCV_OBJECT_ORG and R5OBJUSAGEDEFS.OUD_UOM = R5WARCOVERAGES.WCV_UOM |
where (((R5OBJUSAGEDEFS.OUD_OBJECT = R5WARCOVERAGES.WCV_OBJECT) and (R5OBJUSAGEDEFS.OUD_OBJECT_ORG = R5WARCOVERAGES.WCV_OBJECT_ORG)) and (R5OBJUSAGEDEFS.OUD_UOM = R5WARCOVERAGES.WCV_UOM)) |
|
R5OPREPORTS <--> R5OPCHARTS |
R5OPREPORTS.ORP_ID = R5OPCHARTS.OCH_REPORTID |
R5OPREPORTS full outer join R5OPCHARTS |
|
R5OPSYMBOLS <--> R5OPVARSYMBOL |
R5OPSYMBOLS.OSY_ID = R5OPVARSYMBOL.OVS_SYMBOLID |
R5OPSYMBOLS full outer join R5OPVARSYMBOL |
|
R5OPVARATTRIBUTES <--> R5OPVARIABLES |
R5OPVARATTRIBUTES.OAT_ID = R5OPVARIABLES.OVD_ATTR1ID |
R5OPVARATTRIBUTES full outer join R5OPVARIABLES |
|
R5OPVARDESC <--> R5OPCOMMENTS |
R5OPVARDESC.OVD_VARID = R5OPCOMMENTS.OCM_VARID |
R5OPVARDESC left outer join R5OPCOMMENTS |
|
R5OPVARDESC <--> R5OPDATATBL |
R5OPVARDESC.OVD_VARID = R5OPDATATBL.ODT_VARID |
R5OPVARDESC left outer join R5OPDATATBL |
|
R5OPVARDESC <--> R5OPLIMITS |
R5OPVARDESC.OVD_VARID = R5OPLIMITS.OPL_VARID |
R5OPVARDESC left outer join R5OPLIMITS |
|
R5OPVARDESC <--> R5OPVAREQ |
R5OPVARDESC.OVD_VARID = R5OPVAREQ.OEQ_VARID |
R5OPVARDESC left outer join R5OPVAREQ |
|
R5OPVARIABLES <--> R5OPVARDATA |
R5OPVARIABLES.OVD_ID = R5OPVARDATA.ODT_VARID |
R5OPVARIABLES full outer join R5OPVARDATA |
|
R5OPVARIABLES <--> R5OPVARSYMBOL |
R5OPVARIABLES.OVD_ID = R5OPVARSYMBOL.OVS_VARID |
R5OPVARIABLES full outer join R5OPVARSYMBOL |
|
R5ORDERLINES <--> R5BOOKEDHOURS |
R5ORDERLINES.ORL_ORDER_ORG = R5BOOKEDHOURS.BOO_ORDER_ORG AND R5ORDERLINES.ORL_ORDLINE = R5BOOKEDHOURS.BOO_ORDLINE AND R5ORDERLINES.ORL_ORDER = R5BOOKEDHOURS.BOO_ORDER |
R5ORDERLINES full outer join R5BOOKEDHOURS |
|
R5ORDERLINES <--> R5DOCKLINES |
R5ORDERLINES.ORL_ORDER = R5DOCKLINES.DKL_ORDER and R5ORDERLINES.ORL_ORDER_ORG = R5DOCKLINES.DKL_ORDER_ORG and R5ORDERLINES.ORL_ORDLINE = R5DOCKLINES.DKL_ORDLINE |
R5ORDERLINES full outer join R5DOCKLINES |
|
R5ORDERLINES <--> R5FIFO |
R5ORDERLINES.ORL_ORDER = R5FIFO.FIF_ORDER and R5ORDERLINES.ORL_ORDER_ORG = R5FIFO.FIF_ORDER_ORG and R5ORDERLINES.ORL_ORDLINE = R5FIFO.FIF_ORDLINE |
R5ORDERLINES full outer join R5FIFO |
|
R5ORDERLINES <--> R5PACKINGSLIP |
R5ORDERLINES.ORL_ORDER = R5PACKINGSLIP.PSL_ORDER and R5ORDERLINES.ORL_ORDER_ORG = R5PACKINGSLIP.PSL_ORDER_ORG and R5ORDERLINES.ORL_ORDLINE = R5PACKINGSLIP.PSL_ORDLINE |
R5ORDERLINES full outer join R5PACKINGSLIP |
|
R5ORDERLINES <--> R5TRANSLINES |
R5ORDERLINES.ORL_ORDER = R5TRANSLINES.TRL_ORDER and R5ORDERLINES.ORL_ORDER_ORG = R5TRANSLINES.TRL_ORDER_ORG and R5ORDERLINES.ORL_ORDLINE = R5TRANSLINES.TRL_ORDLINE |
R5ORDERLINES full outer join R5TRANSLINES |
|
R5ORDERLINES <--> R5TRANSTOCK |
R5ORDERLINES.ORL_ORDER = R5TRANSTOCK.TST_ORDER and R5ORDERLINES.ORL_ORDER_ORG = R5TRANSTOCK.TST_ORDER_ORG and R5ORDERLINES.ORL_ORDLINE = R5TRANSTOCK.TST_ORDLINE |
R5ORDERLINES full outer join R5TRANSTOCK |
|
R5ORDERS <--> R5ACTIVITIES |
R5ORDERS.ORD_CODE = R5ACTIVITIES.ACT_ORDER and R5ORDERS.ORD_ORG = R5ACTIVITIES.ACT_ORDER_ORG |
R5ORDERS full outer join R5ACTIVITIES |
|
R5ORDERS <--> R5BLANKETORDERS |
R5ORDERS.ORD_CODE = R5BLANKETORDERS.BLO_LASTORD and R5ORDERS.ORD_ORG = R5BLANKETORDERS.BLO_LASTORD_ORG |
R5ORDERS full outer join R5BLANKETORDERS |
|
R5ORDERS <--> R5BLANKETORDLINES |
R5ORDERS.ORD_CODE = R5BLANKETORDLINES.BLL_LASTORD and R5ORDERS.ORD_ORG = R5BLANKETORDLINES.BLL_LASTORD_ORG |
R5ORDERS full outer join R5BLANKETORDLINES |
|
R5ORDERS <--> R5DOCKRECEIPTS |
R5ORDERS.ORD_CODE = R5DOCKRECEIPTS.DCK_ORDER and R5ORDERS.ORD_ORG = R5DOCKRECEIPTS.DCK_ORDER_ORG |
R5ORDERS full outer join R5DOCKRECEIPTS |
|
R5ORDERS <--> R5ORDCLAUSES |
R5ORDERS.ORD_CODE = R5ORDCLAUSES.ORC_ORDER and R5ORDERS.ORD_ORG = R5ORDCLAUSES.ORC_ORDER_ ORG |
R5ORDERS left outer join R5ORDCLAUSES |
|
R5ORDERS <--> R5ORDERLINES |
R5ORDERS.ORD_CODE = R5ORDERLINES.ORL_ORDER and R5ORDERS.ORD_ORG = R5ORDERLINES.ORL_ORDER_ORG |
R5ORDERS left outer join R5ORDERLINES |
|
R5ORDERS <--> R5ORDERLINES |
R5ORDERS.ORD_CODE = R5ORDERLINES.ORL_ORDER and R5ORDERS.ORD_ORG = R5ORDERLINES.ORL_ORDER_ORG |
R5ORDERS left outer join R5ORDERLINES |
|
R5ORDERS <--> R5QUOTATIONS |
R5ORDERS.ORD_CODE = R5QUOTATIONS.QUO_ORDER and R5ORDERS.ORD_ORG = R5QUOTATIONS.QUO_ORDER_ORG |
R5ORDERS full outer join R5QUOTATIONS |
|
R5ORDERS <--> R5SUPPEVALUATION |
R5ORDERS.ORD_CODE = R5SUPPEVALUATION.EVA_ORDER and R5ORDERS.ORD_ORG = R5SUPPEVALUATION.EVA_ORDER_ORG |
R5ORDERS full outer join R5SUPPEVALUATION |
|
R5ORDERS <--> R5TRANSACTIONS |
R5ORDERS.ORD_CODE = R5TRANSACTIONS.TRA_ORDER and R5ORDERS.ORD_ORG = R5TRANSACTIONS.TRA_ORDER_ORG |
R5ORDERS full outer join R5TRANSACTIONS |
|
R5ORDERTERMS <--> R5COMPANIES |
R5ORDERTERMS.ORT_CODE = R5COMPANIES.COM_PAYBYMETHOD |
R5ORDERTERMS full outer join R5COMPANIES |
|
R5ORDERTERMS <--> R5IPVENDORORDERTERMS |
R5ORDERTERMS.ORT_CODE = R5IPVENDORORDERTERMS.IPT_TERM |
R5ORDERTERMS left outer join R5IPVENDORORDERTERMS |
|
R5ORGANIZATION <--> R5AGREEMENTS |
R5ORGANIZATION.ORG_CODE = R5AGREEMENTS.AGR_ORG |
R5ORGANIZATION full outer join R5AGREEMENTS |
|
R5ORGANIZATION <--> R5APPROVELISTS |
R5ORGANIZATION.ORG_CODE = R5APPROVELISTS.APL_ORG |
R5ORGANIZATION full outer join R5APPROVELISTS |
|
R5ORGANIZATION <--> R5ARRANGEMENTS |
R5ORGANIZATION.ORG_CODE = R5ARRANGEMENTS.ARR_ORG |
R5ORGANIZATION full outer join R5ARRANGEMENTS |
|
R5ORGANIZATION <--> R5ARRPRICES |
R5ORGANIZATION.ORG_CODE = R5ARRPRICES.ARP_ORG |
(R5ORGANIZATION.ORG_ CODE = R5ARRPRICES.ARP_ORG) |
|
R5ORGANIZATION <--> R5BLANKETORDERS |
R5ORGANIZATION.ORG_CODE = R5BLANKETORDERS.BLO_ORG |
R5ORGANIZATION full outer join R5BLANKETORDERS |
|
R5ORGANIZATION <--> R5BUDGETGROUPS |
R5ORGANIZATION.ORG_CODE = R5BUDGETGROUPS.BGR_ORG |
R5ORGANIZATION full outer join R5BUDGETGROUPS |
|
R5ORGANIZATION <--> R5BUDGETSTRUCTURE |
R5ORGANIZATION.ORG_CODE = R5BUDGETSTRUCTURE.BUS_ORG |
R5ORGANIZATION full outer join R5BUDGETSTRUCTURE |
|
R5ORGANIZATION <--> R5CALLERS |
R5ORGANIZATION.ORG_CODE = R5CALLERS.CLL_ORG |
R5ORGANIZATION full outer join R5CALLERS |
|
R5ORGANIZATION <--> R5COMMODITIES |
R5ORGANIZATION.ORG_CODE = R5COMMODITIES.CMD_ORG |
R5ORGANIZATION full outer join R5COMMODITIES |
|
R5ORGANIZATION <--> R5CONCLAUSES |
R5ORGANIZATION.ORG_CODE = R5CONCLAUSES.CCL_ORG |
R5ORGANIZATION full outer join R5CONCLAUSES |
|
R5ORGANIZATION <--> R5CONTRACTS |
R5ORGANIZATION.ORG_CODE = R5CONTRACTS.CON_ORG |
R5ORGANIZATION full outer join R5CONTRACTS |
|
R5ORGANIZATION <--> R5COSTCODES |
R5ORGANIZATION.ORG_CODE = R5COSTCODES.CST_ORG |
R5ORGANIZATION full outer join R5COSTCODES |
|
R5ORGANIZATION <--> R5CREDITCARDS |
R5ORGANIZATION.ORG_CODE = R5CREDITCARDS.CRD_ORG |
R5ORGANIZATION full outer join R5CREDITCARDS |
|
R5ORGANIZATION <--> R5DDVALUE |
R5ORGANIZATION.ORG_CODE = R5DDVALUE.DDV_ORG |
R5ORGANIZATION full outer join R5DDVALUE |
|
R5ORGANIZATION <--> R5DEBTORS |
R5ORGANIZATION.ORG_CODE = R5DEBTORS.DEB_ORG |
R5ORGANIZATION full outer join R5DEBTORS |
|
R5ORGANIZATION <--> R5DEVICES |
R5ORGANIZATION.ORG_CODE = R5DEVICES.DEV_ORG |
R5ORGANIZATION full outer join R5DEVICES |
|
R5ORGANIZATION <--> R5DISPATCHES |
R5ORGANIZATION.ORG_CODE = R5DISPATCHES.SWD_ORG |
R5ORGANIZATION full outer join R5DISPATCHES |
|
R5ORGANIZATION <--> R5DOCKRECEIPTS |
R5ORGANIZATION.ORG_CODE = R5DOCKRECEIPTS.DCK_ORG |
R5ORGANIZATION full outer join R5DOCKRECEIPTS |
|
R5ORGANIZATION <--> R5DOCUMENTS |
R5ORGANIZATION.ORG_CODE = R5DOCUMENTS.DOC_ORG |
R5ORGANIZATION full outer join R5DOCUMENTS |
|
R5ORGANIZATION <--> R5ELECARCHIVE |
R5ORGANIZATION.ORG_CODE = R5ELECARCHIVE.ELA_ENTORG |
R5ORGANIZATION full outer join R5ELECARCHIVE |
|
R5ORGANIZATION <--> R5EVENTS |
R5ORGANIZATION.ORG_CODE = R5EVENTS.EVT_ORG |
R5ORGANIZATION full outer join R5EVENTS |
|
R5ORGANIZATION <--> R5FACILITIES |
R5ORGANIZATION.ORG_CODE = R5FACILITIES.FAC_ORG |
R5ORGANIZATION full outer join R5FACILITIES |
|
R5ORGANIZATION <--> R5IPVENDORS |
R5ORGANIZATION.ORG_CODE = R5IPVENDORS.IPV_ORG |
R5ORGANIZATION full outer join R5IPVENDORS |
|
R5ORGANIZATION <--> R5LOTS |
R5ORGANIZATION.ORG_CODE = R5LOTS.LOT_ORG |
R5ORGANIZATION full outer join R5LOTS |
|
R5ORGANIZATION <--> R5MANUFACTURERS |
R5ORGANIZATION.ORG_CODE = R5MANUFACTURERS.MFG_ORG |
R5ORGANIZATION full outer join R5MANUFACTURERS |
|
R5ORGANIZATION <--> R5MATLISTS |
R5ORGANIZATION.ORG_CODE = R5MATLISTS.MTL_ORG |
R5ORGANIZATION full outer join R5MATLISTS |
|
R5ORGANIZATION <--> R5MRCS |
R5ORGANIZATION.ORG_CODE = R5MRCS.MRC_ORG |
R5ORGANIZATION full outer join R5MRCS |
|
R5ORGANIZATION <--> R5MRCTOOLS |
R5ORGANIZATION.ORG_CODE = R5MRCTOOLS.MRT_ORG |
R5ORGANIZATION left outer join R5MRCTOOLS |
|
R5ORGANIZATION <--> R5OPVARDESC |
R5ORGANIZATION.ORG_CODE = R5OPVARDESC.OVD_ORG |
R5ORGANIZATION full outer join R5OPVARDESC |
|
R5ORGANIZATION <--> R5ORDERTERMS |
R5ORGANIZATION.ORG_CODE = R5ORDERTERMS.ORT_ORG |
R5ORGANIZATION full outer join R5ORDERTERMS |
|
R5ORGANIZATION <--> R5ORGANIZATIONAPPPARMS |
R5ORGANIZATION.ORG_CODE = R5ORGANIZATIONAPPPARMS.OAP_ORG |
R5ORGANIZATION left outer join R5ORGANIZATIONAPPPARMS |
|
R5ORGANIZATION <--> R5ORGYEARS |
R5ORGANIZATION.ORG_CODE = R5ORGYEARS.OYE_ORG |
R5ORGANIZATION full outer join R5ORGYEARS |
|
R5ORGANIZATION <--> R5PARTPRICES |
R5ORGANIZATION.ORG_CODE = R5PARTPRICES.PPR_ORG |
R5ORGANIZATION left outer join R5PARTPRICES |
|
R5ORGANIZATION <--> R5PERMITS |
R5ORGANIZATION.ORG_CODE = R5PERMITS.PRT_ORG |
R5ORGANIZATION full outer join R5PERMITS |
|
R5ORGANIZATION <--> R5PERSONNEL |
R5ORGANIZATION.ORG_CODE = R5PERSONNEL.PER_ORG |
R5ORGANIZATION full outer join R5PERSONNEL |
|
R5ORGANIZATION <--> R5PPMOBJECTS |
R5ORGANIZATION.ORG_CODE = R5PPMOBJECTS.PPO_ORG |
R5ORGANIZATION full outer join R5PPMOBJECTS |
|
R5ORGANIZATION <--> R5PPMPLAN |
R5ORGANIZATION.ORG_CODE = R5PPMPLAN.PMP_ORG |
R5ORGANIZATION full outer join R5PPMPLAN |
|
R5ORGANIZATION <--> R5PPMS |
R5ORGANIZATION.ORG_CODE = R5PPMS.PPM_ORG |
R5ORGANIZATION full outer join R5PPMS |
|
R5ORGANIZATION <--> R5PROJECTS |
R5ORGANIZATION.ORG_CODE = R5PROJECTS.PRJ_ORG |
R5ORGANIZATION full outer join R5PROJECTS |
|
R5ORGANIZATION <--> R5QUALIFICATIONS |
R5ORGANIZATION.ORG_CODE = R5QUALIFICATIONS.QUA_ORG |
R5ORGANIZATION full outer join R5QUALIFICATIONS |
|
R5ORGANIZATION <--> R5QUOTATIONS |
R5ORGANIZATION.ORG_CODE = R5QUOTATIONS.QUO_ORG |
R5ORGANIZATION full outer join R5QUOTATIONS |
|
R5ORGANIZATION <--> R5REQUISITIONS |
R5ORGANIZATION.ORG_CODE = R5REQUISITIONS.REQ_ORG |
R5ORGANIZATION full outer join R5REQUISITIONS |
|
R5ORGANIZATION <--> R5ROUTES |
R5ORGANIZATION.ORG_CODE = R5ROUTES.ROU_ORG |
R5ORGANIZATION full outer join R5ROUTES |
|
R5ORGANIZATION <--> R5SCHEDGROUPS |
R5ORGANIZATION.ORG_CODE = R5SCHEDGROUPS.SCG_ORG |
R5ORGANIZATION full outer join R5SCHEDGROUPS |
|
R5ORGANIZATION <--> R5SERVICECODES |
R5ORGANIZATION.ORG_CODE = R5SERVICECODES.SRV_ORG |
R5ORGANIZATION full outer join R5SERVICECODES |
|
R5ORGANIZATION <--> R5SERVICEREQUESTS |
R5ORGANIZATION.ORG_CODE = R5SERVICEREQUESTS.SRQ_ORG |
R5ORGANIZATION full outer join R5SERVICEREQUESTS |
|
R5ORGANIZATION <--> R5SHIFTS |
R5ORGANIZATION.ORG_CODE = R5SHIFTS.SHF_ORG |
R5ORGANIZATION full outer join R5SHIFTS |
|
R5ORGANIZATION <--> R5SHUTDOWNS |
R5ORGANIZATION.ORG_CODE = R5SHUTDOWNS.SDS_ORG |
R5ORGANIZATION full outer join R5SHUTDOWNS |
|
R5ORGANIZATION <--> R5STANDWORKS |
R5ORGANIZATION.ORG_CODE = R5STANDWORKS.STW_ORG |
R5ORGANIZATION full outer join R5STANDWORKS |
|
R5ORGANIZATION <--> R5STORES |
R5ORGANIZATION.ORG_CODE = R5STORES.STR_ORG |
R5ORGANIZATION full outer join R5STORES |
|
R5ORGANIZATION <--> R5TASKPRICES |
R5ORGANIZATION.ORG_CODE = R5TASKPRICES.TPR_ORG |
R5ORGANIZATION left outer join R5TASKPRICES |
|
R5ORGANIZATION <--> R5TASKS |
R5ORGANIZATION.ORG_CODE = R5TASKS.TSK_ORG |
R5ORGANIZATION full outer join R5TASKS |
|
R5ORGANIZATION <--> R5TAXES |
R5ORGANIZATION.ORG_CODE = R5TAXES.TAX_ORG |
R5ORGANIZATION full outer join R5TAXES |
|
R5ORGANIZATION <--> R5TOOLS |
R5ORGANIZATION.ORG_CODE = R5TOOLS.TOO_ORG |
R5ORGANIZATION full outer join R5TOOLS |
|
R5ORGANIZATION <--> R5TRADERATES |
R5ORGANIZATION.ORG_CODE = R5TRADERATES.TRR_ORG |
R5ORGANIZATION left outer join R5TRADERATES |
|
R5ORGANIZATION <--> R5TRADES |
R5ORGANIZATION.ORG_CODE = R5TRADES.TRD_ORG |
R5ORGANIZATION full outer join R5TRADES |
|
R5ORGANIZATION <--> R5TRANSACTIONS |
R5ORGANIZATION.ORG_CODE = R5TRANSACTIONS.TRA_ORG |
R5ORGANIZATION full outer join R5TRANSACTIONS |
|
R5ORGANIZATION <--> R5USERORGANIZATION |
R5ORGANIZATION.ORG_CODE = R5USERORGANIZATION.UOG_ORG |
R5ORGANIZATION left outer join R5USERORGANIZATION |
|
R5ORGANIZATION <--> R5WARCLAIMS |
R5ORGANIZATION.ORG_CODE = R5WARCLAIMS.WCL_ORG |
R5ORGANIZATION full outer join R5WARCLAIMS |
|
R5ORGANIZATION <--> R5WORKPACKAGES |
R5ORGANIZATION.ORG_CODE = R5WORKPACKAGES.WPK_ORG |
R5ORGANIZATION full outer join R5WORKPACKAGES |
|
R5ORGANIZATION <--> R5YEARS |
R5ORGANIZATION.ORG_CODE = R5YEARS.ACY_ORG |
R5ORGANIZATION full outer join R5YEARS |
|
R5ORGYEARS <--> R5OBJUNITS |
R5ORGYEARS.OYE_PK = R5OBJUNITS.OBU_YEARPK |
R5ORGYEARS left outer join R5OBJUNITS |
|
R5PARTS <--> R5BLANKETORDLINES |
R5PARTS.PAR_ORG = R5BLANKETORDLINES.BLL_PART_ORG AND R5PARTS.PAR_CODE = R5BLANKETORDLINES.BLL_PART |
R5PARTS full outer join R5BLANKETORDLINES |
|
R5PARTS <--> R5CATALOGUE |
R5PARTS.PAR_CODE = R5CATALOGUE.CAT_PART and R5PARTS.PAR_ORG = R5CATALOGUE.CAT_PART_ORG |
R5PARTS left outer join R5CATALOGUE |
|
R5PARTS <--> R5CONDISCOUNTS |
R5PARTS.PAR_CODE = R5CONDISCOUNTS.CDI_PART and R5PARTS.PAR_ORG = R5CONDISCOUNTS.CDI_PART_ORG |
R5PARTS full outer join R5CONDISCOUNTS |
|
R5PARTS <--> R5CONPARTS |
R5PARTS.PAR_CODE = R5CONPARTS.CPA_PART and R5PARTS.PAR_ORG = R5CONPARTS.CPA_PART_ORG |
R5PARTS left outer join R5CONPARTS |
|
R5PARTS <--> R5CONVUOM |
R5PARTS.PAR_CODE = R5CONVUOM.CNV_PART and R5PARTS.PAR_ORG = R5CONVUOM.CNV_PART_ORG |
R5PARTS left outer join R5CONVUOM |
|
R5PARTS <--> R5DOCKLINES |
R5PARTS.PAR_CODE = R5DOCKLINES.DKL_PART and R5PARTS.PAR_ORG = R5DOCKLINES.DKL_PART_ORG |
R5PARTS full outer join R5DOCKLINES |
|
R5PARTS <--> R5ENTITYPARTS |
R5PARTS.PAR_CODE = R5ENTITYPARTS.EPA_PART and R5PARTS.PAR_ORG = R5ENTITYPARTS.EPA_PART_ORG |
R5PARTS left outer join R5ENTITYPARTS |
|
R5PARTS <--> R5EVTSTANDARDS |
R5PARTS.PAR_CODE = R5EVTSTANDARDS.EST_PART and R5PARTS.PAR_ORG = R5EVTSTANDARDS.EST_PART_ORG |
R5PARTS full outer join R5EVTSTANDARDS |
|
R5PARTS <--> R5JOBLINES |
R5PARTS.PAR_ORG = R5JOBLINES.JBL_PART_ORG AND R5PARTS.PAR_CODE = R5JOBLINES.JBL_PART |
R5PARTS left outer join R5JOBLINES |
|
R5PARTS <--> R5MATLPARTS |
R5PARTS.PAR_ORG = R5MATLPARTS.MLP_PART_ORG AND R5PARTS.PAR_CODE = R5MATLPARTS.MLP_PART |
R5PARTS full outer join R5MATLPARTS |
|
R5PARTS <--> R5OBJECTS |
R5PARTS.PAR_ORG = R5OBJECTS.OBJ_PART_ORG AND R5PARTS.PAR_CODE = R5OBJECTS.OBJ_PART |
R5PARTS full outer join R5OBJECTS |
|
R5PARTS <--> R5PACKINGSLIP |
R5PARTS.PAR_ORG = R5PACKINGSLIP.PSL_PART_ORG AND R5PARTS.PAR_CODE = R5PACKINGSLIP.PSL_PART |
R5PARTS full outer join R5PACKINGSLIP |
|
R5PARTS <--> R5PARTMFGS |
R5PARTS.PAR_CODE = R5PARTMFGS.MFP_PART and R5PARTS.PAR_ORG = R5PARTMFGS.MFP_PART_ORG |
R5PARTS full outer join R5PARTMFGS |
|
R5PARTS <--> R5PARTPRICES |
R5PARTS.PAR_CODE = R5PARTPRICES.PPR_PART and R5PARTS.PAR_ORG = R5PARTPRICES.PPR_PART_ORG |
R5PARTS left outer join R5PARTPRICES |
|
R5PARTS <--> R5PICKLISTPARTS |
R5PARTS.PAR_CODE = R5PICKLISTPARTS.PIP_PART and R5PARTS.PAR_ORG = R5PICKLISTPARTS.PIP_PART_ORG |
R5PARTS left outer join R5PICKLISTPARTS |
|
R5PARTS <--> R5QUOTLINES |
R5PARTS.PAR_CODE = R5QUOTLINES.QUL_PART and R5PARTS.PAR_ORG = R5QUOTLINES.QUL_PART_ORG |
R5PARTS full outer join R5QUOTLINES |
|
R5PARTS <--> R5REQUISLINES |
R5PARTS.PAR_CODE = R5REQUISLINES.RQL_PART and R5PARTS.PAR_ORG = R5REQUISLINES.RQL_PART_ORG |
R5PARTS full outer join R5REQUISLINES |
|
R5PARTS <--> R5STOCK |
R5PARTS.PAR_CODE = R5STOCK.STO_PART and R5PARTS.PAR_ORG = R5STOCK.STO_PART_ORG |
R5PARTS left outer join R5STOCK |
|
R5PARTS <--> R5STOCKOUTS |
R5PARTS.PAR_CODE = R5STOCKOUTS.SOU_PART and R5PARTS.PAR_ORG = R5STOCKOUTS.SOU_PART_ORG |
R5PARTS full outer join R5STOCKOUTS |
|
R5PARTS <--> R5SUMUSAGE |
R5PARTS.PAR_ORG = R5SUMUSAGE.USG_PART_ORG AND R5PARTS.PAR_CODE = R5SUMUSAGE.USG_PART |
R5PARTS left outer join R5SUMUSAGE |
|
R5PARTS <--> R5TRANSLINES |
R5PARTS.PAR_ORG = R5TRANSLINES.TRL_PART_ORG AND R5PARTS.PAR_CODE = R5TRANSLINES.TRL_PART |
R5PARTS full outer join R5TRANSLINES |
|
R5PARTS <--> R5TRANSTOCK |
R5PARTS.PAR_ORG = R5TRANSTOCK.TST_PART_ORG AND R5PARTS.PAR_CODE = R5TRANSTOCK.TST_PART |
R5PARTS full outer join R5TRANSTOCK |
|
R5PERIODS <--> R5BUDGETDETAILS |
R5PERIODS.ACP_PERIOD = R5BUDGETDETAILS.BDT_PERIOD AND R5PERIODS.ACP_YEAR = R5BUDGETDETAILS.BDT_YEAR |
R5PERIODS full outer join R5BUDGETDETAILS |
|
R5PERMISSIONS <--> R5TABPERMISSIONS |
R5PERMISSIONS.PRM_FUNCTION = R5TABPERMISSIONS.TRP_FUNCTION and R5PERMISSIONS.PRM_GROUP = R5TABPERMISSIONS.TRP_GROUP |
R5PERMISSIONS left outer join R5TABPERMISSIONS |
|
R5PERMITS <--> R5PERMENTITIES |
R5PERMITS.PRT_CODE = R5PERMENTITIES.PRE_PERMIT |
R5PERMITS left outer join R5PERMENTITIES |
|
R5PERMITS <--> R5PERMEVENTS |
R5PERMITS.PRT_CODE = R5PERMEVENTS.PEV_PERMIT |
R5PERMITS full outer join R5PERMEVENTS |
|
R5PERSONNEL <--> R5ACTSCHEDULES |
R5PERSONNEL.PER_CODE = R5ACTSCHEDULES.ACS_RESPONSIBLE |
R5PERSONNEL full outer join R5ACTSCHEDULES |
|
R5PERSONNEL <--> R5BOOKEDHOURS |
R5PERSONNEL.PER_CODE = R5BOOKEDHOURS.BOO_PERSON |
R5PERSONNEL full outer join R5BOOKEDHOURS |
|
R5PERSONNEL <--> R5BUDGETS |
R5PERSONNEL.PER_CODE = R5BUDGETS.BUD_KEEPER |
R5PERSONNEL full outer join R5BUDGETS |
|
R5PERSONNEL <--> R5CONTRACTS |
R5PERSONNEL.PER_CODE = R5CONTRACTS.CON_OWNCONTACT |
R5PERSONNEL full outer join R5CONTRACTS |
|
R5PERSONNEL <--> R5DISPATCHES |
R5PERSONNEL.PER_CODE = R5DISPATCHES.SWD_ORIGIN |
R5PERSONNEL full outer join R5DISPATCHES |
|
R5PERSONNEL <--> R5DOCKLINES |
R5PERSONNEL.PER_CODE = R5DOCKLINES.DKL_INSPECTOR |
R5PERSONNEL full outer join R5DOCKLINES |
|
R5PERSONNEL <--> R5DOCKRECEIPTS |
R5PERSONNEL.PER_CODE = R5DOCKRECEIPTS.DCK_RECEIVER |
R5PERSONNEL full outer join R5DOCKRECEIPTS |
|
R5PERSONNEL <--> R5DSCHAVAIL |
R5PERSONNEL.PER_CODE = R5DSCHAVAIL.SHA_PERSON |
R5PERSONNEL full outer join R5DSCHAVAIL |
|
R5PERSONNEL <--> R5EVENTPOINTS |
R5PERSONNEL.PER_CODE = R5EVENTPOINTS.EPO_INSPECTOR |
R5PERSONNEL full outer join R5EVENTPOINTS |
|
R5PERSONNEL <--> R5EVENTS |
R5PERSONNEL.PER_CODE = R5EVENTS.EVT_ORIGIN |
R5PERSONNEL full outer join R5EVENTS |
|
R5PERSONNEL <--> R5EXCEPTIONS |
R5PERSONNEL.PER_CODE = R5EXCEPTIONS.EXC_PERSON |
R5PERSONNEL left outer join R5EXCEPTIONS |
|
R5PERSONNEL <--> R5OBJECTS |
R5PERSONNEL.PER_CODE = R5OBJECTS.OBJ_PERSON |
R5PERSONNEL full outer join R5OBJECTS |
|
R5PERSONNEL <--> R5ORDERS |
R5PERSONNEL.PER_CODE = R5ORDERS.ORD_ORIGIN |
R5PERSONNEL full outer join R5ORDERS |
|
R5PERSONNEL <--> R5PERSCODESTRUCT |
R5PERSONNEL.PER_CODE = R5PERSCODESTRUCT.PRL_CODE |
R5PERSONNEL left outer join R5PERSCODESTRUCT |
|
R5PERSONNEL <--> R5PERSONNELQUALIFICATIONS |
R5PERSONNEL.PER_CODE = R5PERSONNELQUALIFICATIONS.PQU_PERSON |
R5PERSONNEL left outer join R5PERSONNELQUALIFICATIONS |
|
R5PERSONNEL <--> R5PERTYPES |
R5PERSONNEL.PER_CODE = R5PERTYPES.PET_PERSON |
R5PERSONNEL left outer join R5PERTYPES |
|
R5PERSONNEL <--> R5PICKLISTS |
R5PERSONNEL.PER_CODE = R5PICKLISTS.PIC_PERSON |
R5PERSONNEL full outer join R5PICKLISTS |
|
R5PERSONNEL <--> R5PPMOBJECTS |
R5PERSONNEL.PER_CODE = R5PPMOBJECTS.PPO_PERSON |
R5PERSONNEL full outer join R5PPMOBJECTS |
|
R5PERSONNEL <--> R5PROJECTS |
R5PERSONNEL.PER_CODE = R5PROJECTS.PRJ_COORDIN |
R5PERSONNEL full outer join R5PROJECTS |
|
R5PERSONNEL <--> R5QUOTATIONS |
R5PERSONNEL.PER_CODE = R5QUOTATIONS.QUO_ORIGIN |
R5PERSONNEL full outer join R5QUOTATIONS |
|
R5PERSONNEL <--> R5REQUISITIONS |
R5PERSONNEL.PER_CODE = R5REQUISITIONS.REQ_ORIGIN |
R5PERSONNEL full outer join R5REQUISITIONS |
|
R5PERSONNEL <--> R5SERVICEREQUESTS |
R5PERSONNEL.PER_CODE = R5SERVICEREQUESTS.SRQ_ASSIGNEDTO |
R5PERSONNEL full outer join R5SERVICEREQUESTS |
|
R5PERSONNEL <--> R5SHFPERS |
R5PERSONNEL.PER_CODE = R5SHFPERS.SHP_PERSON |
R5PERSONNEL left outer join R5SHFPERS |
|
R5PERSONNEL <--> R5TRANSACTIONS |
R5PERSONNEL.PER_CODE = R5TRANSACTIONS.TRA_PERS |
R5PERSONNEL full outer join R5TRANSACTIONS |
|
R5PERSONNEL <--> R5WPPERSONS |
R5PERSONNEL.PER_CODE = R5WPPERSONS.WPP_PERSON |
R5PERSONNEL left outer join R5WPPERSONS |
|
R5PICKLISTS <--> R5PICKLISTPARTS |
R5PICKLISTS.PIC_CODE = R5PICKLISTPARTS.PIP_PICKLIST |
R5PICKLISTS left outer join R5PICKLISTPARTS |
|
R5PICKLISTS <--> R5TRANSLINES |
R5PICKLISTS.PIC_CODE = R5TRANSLINES.TRL_PICKLIST |
R5PICKLISTS full outer join R5TRANSLINES |
|
R5PIPINGCLASS <--> R5DIACONVERSION |
R5PIPINGCLASS.PCS_CODE = R5DIACONVERSION.DCO_PIPING and R5PIPINGCLASS.PCS_REVISION=R5DIACONVERSION.DCO_PIPINGREV |
R5PIPINGCLASS left outer join R5DIACONVERSION |
|
R5PIPINGCLASS <--> R5INSPECTEQUIPDATA |
R5PIPINGCLASS.PCS_CODE = R5INSPECTEQUIPDATA.IED_PIPING and R5PIPINGCLASS.PCS_REVISION =R5INSPECTEQUIPDATA.IED_PIPINGREV |
R5PIPINGCLASS full outer join R5INSPECTEQUIPDATA |
|
R5PIPINGCLASS <--> R5JOINTEFFICIENCY |
R5PIPINGCLASS.PCS_CODE = R5JOINTEFFICIENCY.JEF_PIPING and R5PIPINGCLASS.PCS_REVISION = R5JOINTEFFICIENCY.JEF_PIPINGREV |
R5PIPINGCLASS left outer join R5JOINTEFFICIENCY |
|
R5PIPINGCLASS <--> R5WALLTHICKNESS |
R5PIPINGCLASS.PCS_CODE = R5WALLTHICKNESS.WTH_PIPING and R5PIPINGCLASS.PCS_REVISION = R5WALLTHICKNESS.WTH_PIPINGREV |
R5PIPINGCLASS left outer join R5WALLTHICKNESS |
|
R5POINTS <--> R5ASPECTPOINTS |
R5POINTS.POI_OBJECT = R5ASPECTPOINTS.APO_OBJECT and R5POINTS.POI_OBJECT_ORG = R5ASPECTPOINTS.APO_OBJECT_ORG and R5POINTS.POI_OBTYPE = R5ASPECTPOINTS.APO_OBTYPE and R5POINTS.POI_POINT = R5ASPECTPOINTS.APO_POINT and R5POINTS.POI_POINTTYPE = R5ASPECTPOINTS.APO_POINTTYPE |
R5POINTS left outer join R5ASPECTPOINTS |
|
R5POINTS <--> R5POINTCONDITIONS |
R5POINTS.POI_OBJECT = R5POINTCONDITIONS.POC_OBJECT and R5POINTS.POI_OBJECT_ORG = R5POINTCONDITIONS.POC_OBJECT_ORG and R5POINTS.POI_OBTYPE = R5POINTCONDITIONS.POC_OBTYPE and R5POINTS.POI_POINT = R5POINTCONDITIONS.POC_POINT and R5POINTS.POI_POINTTYPE = R5POINTCONDITIONS.POC_POINTTYPE |
R5POINTS full outer join R5POINTCONDITIONS |
|
R5POINTTYPES <--> R5POINTS |
R5POINTTYPES.PTP_CODE = R5POINTS.POI_POINTTYPE |
R5POINTTYPES left outer join R5POINTS |
|
R5PPMACTS <--> R5PPMTOOLS |
R5PPMACTS.PPA_PPM = R5PPMTOOLS.PPT_PPM and R5PPMACTS.PPA_REVISION = R5PPMTOOLS.PPT_REVISION and R5PPMACTS.PPA_ACT = R5PPMTOOLS.PPT_ACT |
R5PPMACTS left outer join R5PPMTOOLS |
|
R5PPMPLAN <--> R5PPMS |
R5PPMPLAN.PMP_CODE = R5PPMS.PPM_PLAN |
R5PPMPLAN full outer join R5PPMS |
|
R5PPMS <--> R5EVENTS |
R5PPMS.PPM_CODE = R5EVENTS.EVT_PPM and R5PPMS.PPM_REVISION = R5EVENTS.EVT_PPMREV |
R5PPMS full outer join R5EVENTS |
|
R5PPMS <--> R5PPMACTS |
R5PPMS.PPM_CODE = R5PPMACTS.PPA_PPM and R5PPMS.PPM_REVISION = R5PPMACTS.PPA_REVISION |
R5PPMS left outer join R5PPMACTS |
|
R5PPMS <--> R5PPMCALENDARS |
R5PPMS.PPM_CODE = R5PPMCALENDARS.PPC_PPM and R5PPMS.PPM_REVISION = R5PPMCALENDARS.PPC_REVISION |
R5PPMS left outer join R5PPMCALENDARS |
|
R5PPMS <--> R5PPMOBJECTS |
R5PPMS.PPM_CODE = R5PPMOBJECTS.PPO_PPM and R5PPMS.PPM_REVISION = R5PPMOBJECTS.PPO_REVISION |
R5PPMS full outer join R5PPMOBJECTS |
|
R5PREFERENCES <--> R5USERPREFS |
R5PREFERENCES.PRF_CODE = R5USERPREFS.UPF_PREF |
R5PREFERENCES left outer join R5USERPREFS |
|
R5PRICECODES <--> R5PRICING |
R5PRICECODES.PRI_CODE = R5PRICING.PRC_ORIG |
R5PRICECODES left outer join R5PRICING |
|
R5PRICECODES <--> R5STORES |
R5PRICECODES.PRI_CODE = R5STORES.STR_PRICECODE |
R5PRICECODES full outer join R5STORES |
|
R5PRINTERS <--> R5PRINTERUSERS |
R5PRINTERS.PRN_CODE = R5PRINTERUSERS.PNU_CODE |
R5PRINTERS left outer join R5PRINTERUSERS |
|
R5PRINTERS <--> R5RPTSERVERREQ UEST |
R5PRINTERS.PRN_CODE = R5RPTSERVERREQUEST.RSR_PRINTERID |
R5PRINTERS full outer join R5RPTSERVERREQUEST |
|
R5PRINTERTYPES <--> R5LABELFORMATS |
R5PRINTERTYPES.PNT_CODE = R5LABELFORMATS.LBL_PRINTERTYPE |
R5PRINTERTYPES fullouter join R5LABELFORMATS |
|
R5PRINTERTYPES <--> R5PRINTERS |
R5PRINTERTYPES.PNT_CODE = R5PRINTERS.PRN_PRINTERTYPE |
R5PRINTERTYPES full outer join R5PRINTERS |
|
R5PROJBUDCLASSES <--> R5EVENTS |
R5PROJBUDCLASSES.PCL_PROJECT = R5EVENTS.EVT_PROJECT and R5PROJBUDCLASSES.PCL_PROJBUD = R5EVENTS.EVT_PROJBUD |
R5PROJBUDCLASSES full outer join R5EVENTS |
|
R5PROJBUDCLASSES <--> R5ORDERLINES |
R5PROJBUDCLASSES.PCL_PROJECT = R5ORDERLINES.ORL_PROJECT and R5PROJBUDCLASSES.PCL_PROJBUD = R5ORDERLINES.ORL_PROJBUD |
R5PROJBUDCLASSES full outer join R5ORDERLINES |
|
R5PROJBUDCLASSES <--> R5REQUISLINES |
R5PROJBUDCLASSES.PCL_PROJECT = R5REQUISLINES.RQL_PROJECT and R5PROJBUDCLASSES.PCL_PROJBUD = R5REQUISLINES.RQL_PROJBUD |
R5PROJBUDCLASSES full outer join R5REQUISLINES |
|
R5PROJBUDCLASSES <--> R5RESERVATIONS |
R5PROJBUDCLASSES.PCL_PROJECT = R5RESERVATIONS.RES_PROJECT and R5PROJBUDCLASSES.PCL_PROJBUD = R5RESERVATIONS.RES_PROJBUD |
R5PROJBUDCLASSES full outer join R5RESERVATIONS |
|
R5PROJBUDCLASSES <--> R5TRANSLINES |
R5PROJBUDCLASSES.PCL_PROJECT = R5TRANSLINES.TRL_PROJECT and R5PROJBUDCLASSES.PCL_PROJBUD = R5TRANSLINES.TRL_PROJBUD |
R5PROJBUDCLASSES full outer join R5TRANSLINES |
|
R5PROJBUDCODES <--> R5PROJBUDCLASSES |
R5PROJBUDCODES.PBC_CODE = R5PROJBUDCLASSES.PCL_PROJBUD |
R5PROJBUDCODES left outer join R5PROJBUDCLASSES |
|
R5PROJBUDCODES <--> R5PROJBUDCLASSES |
R5PROJBUDCODES.PBC_CODE = R5PROJBUDCLASSES.PCL_PROJBUD |
R5PROJBUDCODES left outer join R5PROJBUDCLASSES |
|
R5PROJBUDCODES <--> R5SHUTDOWNOBJECTS |
R5PROJBUDCODES.PBC_CODE = R5SHUTDOWNOBJECTS.SOB_PROJBUD |
R5PROJBUDCODES full outer join R5SHUTDOWNOBJECTS |
|
R5PROJECTS <--> R5AGREEMENTS |
R5PROJECTS.PRJ_CODE = R5AGREEMENTS.AGR_PROJECT |
R5PROJECTS full outer join R5AGREEMENTS |
|
R5PROJECTS <--> R5PROJBUDCLASSES |
R5PROJECTS.PRJ_CODE = R5PROJBUDCLASSES.PCL_PROJECT |
R5PROJECTS left outer join R5PROJBUDCLASSES |
|
R5PROJECTS <--> R5PROJBUDCLASSES |
R5PROJECTS.PRJ_CODE = R5PROJBUDCLASSES.PCL_PROJECT |
R5PROJECTS left outer join R5PROJBUDCLASSES |
|
R5PROJECTS <--> R5PROJECTS |
R5PROJECTS.PRJ_CODE = R5PROJECTS.PRJ_PARENT |
No joins exist |
|
R5PROJECTS <--> R5PROJECTS |
R5PROJECTS.PRJ_CODE = R5PROJECTS.PRJ_PARENTs |
No joins exist |
|
R5PROPERTIES <--> R5ADDPROPERTIES |
R5PROPERTIES.PRO_CODE = R5ADDPROPERTIES.APR_PROPERTY |
R5PROPERTIES left outer join R5ADDPROPERTIES |
|
R5PROPERTIES <--> R5ASPECTPROMPTS |
R5PROPERTIES.PRO_CODE = R5ASPECTPROMPTS.APM_PROMPT |
R5PROPERTIES full outer join R5ASPECTPROMPTS |
|
R5PROPERTIES <--> R5PROPERTYVALUES |
R5PROPERTIES.PRO_CODE = R5PROPERTYVALUES.PRV_PROPERTY |
R5PROPERTIES full outer join R5PROPERTYVALUES |
|
R5PSCATEGORIES <--> R5CONTACTRECORDS |
R5PSCATEGORIES.PSC_CODE = R5CONTACTRECORDS.CTR_PROVIDER and R5PSCATEGORIES.PSC_ORG = R5CONTACTRECORDS.CTR_PROVIDER_ORG |
R5PSCATEGORIES full outer join R5CONTACTRECORDS |
|
R5PSCATEGORIES <--> R5DEPARTMENTSTRUCTURE |
R5PSCATEGORIES.PSC_CODE = R5DEPARTMENTSTRUCTURE.DPS_PROVIDER and R5PSCATEGORIES.PSC_ORG = R5DEPARTMENTSTRUCTURE.DPS_PROVIDER_ORG |
R5PSCATEGORIES full outer join R5DEPARTMENTSTRUCTURE |
|
R5PSCATEGORIES <--> R5KBARTICLES |
R5PSCATEGORIES.PSC_CODE = R5KBARTICLES.KBA_PROVIDER and R5PSCATEGORIES.PSC_ORG = R5KBARTICLES.KBA_PROVIDER_ORG |
R5PSCATEGORIES full outer join R5KBARTICLES |
|
R5QUALIFICATIONS <--> R5ACTQUALIFICATIONS |
R5QUALIFICATIONS.QUA_CODE = R5ACTQUALIFICATIONS.AQU_QUALIFICATION |
R5QUALIFICATIONS left outer join R5ACTQUALIFICATIONS |
|
R5QUALIFICATIONS <--> R5PERSONNELQUALIFICATIONS |
R5QUALIFICATIONS.QUA_CODE = R5PERSONNELQUALIFICATIONS.PQU_QUALIFICATION |
R5QUALIFICATIONS left outer join R5PERSONNELQUALIFICATIONS |
|
R5QUALIFICATIONS <--> R5TASKQUALIFICATIONS |
R5QUALIFICATIONS.QUA_CODE = R5TASKQUALIFICATIONS.TQU_QUALIFICATION |
R5QUALIFICATIONS left outer join R5TASKQUALIFICATIONS |
|
R5QUALIFICATIONS <--> R5TRADEQUALIFICATIONS |
R5QUALIFICATIONS.QUA_CODE = R5TRADEQUALIFICATIONS.TRQ_QUALIFICATION |
R5QUALIFICATIONS left outer join R5TRADEQUALIFICATIONS |
|
R5QUERIES <--> R5HOME |
R5QUERIES.QUE_CODE = R5HOME.HOM_SQLCODE |
R5QUERIES full outer join R5HOME |
|
R5QUERIES <--> R5REPPARMS |
R5QUERIES.QUE_CODE = R5REPPARMS.PMT_QUERY |
R5QUERIES full outer join R5REPPARMS |
|
R5QUOTATIONS <--> R5QUOTLINES |
R5QUOTATIONS.QUO_SEQNO = R5QUOTLINES.QUL_SEQNO AND R5QUOTATIONS.QUO_CODE = R5QUOTLINES.QUL_QUOTATION |
R5QUOTATIONS left outer join R5QUOTLINES |
|
R5QUOTLINES <--> R5BLANKETORDLINES |
R5QUOTLINES.QUL_SEQNO = R5BLANKETORDLINES.BLL_SEQNO AND R5QUOTLINES.QUL_LINE = R5BLANKETORDLINES.BLL_QUOTELINE AND R5QUOTLINES.QUL_QUOTATION = R5BLANKETORDLINES.BLL_QUOTATION |
R5QUOTLINES full outer join R5BLANKETORDLINES |
|
R5RCODES <--> R5UCODES |
R5RCODES.RCO_RCODE = R5UCODES.UCO_RCODE AND R5RCODES.RCO_RENTITY = R5UCODES.UCO_RENTITY |
R5RCODES full outer join R5UCODES |
|
R5REJECTREASONS <--> R5DOCKLINES |
R5REJECTREASONS.RJR_CODE = R5DOCKLINES.DKL_REJREASON |
R5REJECTREASONS full outer join R5DOCKLINES |
|
R5REJECTREASONS <--> R5TRANSLINES |
R5REJECTREASONS.RJR_CODE = R5TRANSLINES.TRL_REJECTREASON |
R5REJECTREASONS full outer join R5TRANSLINES |
|
R5REPPARMS <--> R5REPOPTIONS |
R5REPPARMS.PMT_FUNCTION = R5REPOPTIONS.ROP_FUNCTION and R5REPPARMS.PMT_PARAMETER = R5REPOPTIONS.ROP_PARAMETER |
R5REPPARMS left outer join R5REPOPTIONS |
|
R5REQUIRCODES <--> R5REQCLASSES |
R5REQUIRCODES.RQM_CODE = R5REQCLASSES.RCL_REQM |
R5REQUIRCODES left outer join R5REQCLASSES |
|
R5REQUISITIONS <--> R5REQUISLINES |
R5REQUISITIONS.REQ_CODE = R5REQUISLINES.RQL_REQ |
R5REQUISITIONS left outer join R5REQUISLINES |
|
R5REQUISITIONS <--> R5TRANSACTIONS |
R5REQUISITIONS.REQ_CODE = R5TRANSACTIONS.TRA_REQ |
R5REQUISITIONS full outer join R5TRANSACTIONS |
|
R5REQUISLINES <--> R5JOBLINES |
R5REQUISLINES.RQL_REQ = R5JOBLINES.JBL_REQ and R5REQUISLINES.RQL_REQLINE = R5JOBLINES.JBL_REQLINE |
R5REQUISLINES full outer join R5JOBLINES |
|
R5REQUISLINES <--> R5ORDERLINES |
R5REQUISLINES.RQL_REQ = R5ORDERLINES.ORL_REQ and R5REQUISLINES.RQL_REQLINE =R5O RDERLINES.ORL_REQLINE |
R5REQUISLINES full outer join R5ORDERLINES |
|
R5REQUISLINES <--> R5QUOTLINES |
R5REQUISLINES.RQL_REQ = R5QUOTLINES.QUL_REQ and R5REQUISLINES.RQL_REQLINE = R5QUOTLINES.QUL_REQLINE |
R5REQUISLINES full outer join R5QUOTLINES |
|
R5REQUISLINES <--> R5REPAIRBINS |
R5REQUISLINES.RQL_REQLINE = R5REPAIRBINS.RPB_REQLINE AND R5REQUISLINES.RQL_REQ = R5REPAIRBINS.RPB_REQ |
R5REQUISLINES full outer join R5REPAIRBINS |
|
R5REQUISLINES <--> R5TRANSLINES |
R5REQUISLINES.RQL_REQLINE = R5TRANSLINES.TRL_REQLINE AND R5REQUISLINES.RQL_REQ = R5TRANSLINES.TRL_REQ |
R5REQUISLINES full outer join R5TRANSLINES |
|
R5REQUISLINES <--> R5TRANSTOCK |
R5REQUISLINES.RQL_REQLINE = R5TRANSTOCK.TST_REQLINE AND R5REQUISLINES.RQL_REQ = R5TRANSTOCK.TST_REQ |
R5REQUISLINES full outer join R5TRANSTOCK |
|
R5RISK <--> R5RISK |
R5RISK.RIS_PK = R5RISK.RIS_PARENT |
No joins exist |
|
R5RISK <--> R5RISKNORM |
R5RISK.RIS_PK = R5RISKNORM.RNO_PK |
R5RISK left outer join R5RISKNORM |
|
R5ROUTES <--> R5EVENTS |
R5ROUTES.ROU_CODE = R5EVENTS.EVT_ROUTE and R5ROUTES.ROU_REVISION = R5EVENTS.EVT_ROUTEREV |
R5ROUTES full outer join R5EVENTS |
|
R5ROUTES <--> R5ROUTOBJECTS |
R5ROUTES.ROU_CODE = R5ROUTOBJECTS.ROB_ROUTE and R5ROUTES.ROU_REVISION = R5ROUTOBJECTS.ROB_REVISION |
R5ROUTES left outer join R5ROUTOBJECTS |
|
R5SCHEDGROUPS <--> R5EVENTS |
R5SCHEDGROUPS.SCG_CODE = R5EVENTS.EVT_SCHEDGRP |
R5SCHEDGROUPS full outer join R5EVENTS |
|
R5SCHEDGROUPS <--> R5MRCS |
R5SCHEDGROUPS.SCG_CODE = R5MRCS.MRC_SCHEDGROUP |
R5SCHEDGROUPS full outer join R5MRCS |
|
R5SCHEDULES <--> R5SCHEDULEDJOBS |
R5SCHEDULES.SCH_CODE = R5SCHEDULEDJOBS.SCJ_SCHCODE |
R5SCHEDULES full outer join R5SCHEDULEDJOBS |
|
R5SCHEDULES <--> R5SCHEDULEDJOBS |
R5SCHEDULES.SCH_CODE = R5SCHEDULEDJOBS.SCJ_SCHCODE |
R5SCHEDULES full outer join R5SCHEDULEDJOBS |
|
R5SERVICEREQUESTS <--> R5EVENTS |
R5SERVICEREQUESTS.SRQ_CODE = R5EVENTS.EVT_SERVICEREQUEST |
R5SERVICEREQUESTS full outer join R5EVENTS |
|
R5SERVICEREQUESTS <--> R5SERVICEREQUESTS |
R5SERVICEREQUESTS.SRQ_CODE = R5SERVICEREQUESTS.SRQ_DUPLICATEPARENT |
No joins exist |
|
R5SHIFTS <--> R5ACTSCHEDULES |
R5SHIFTS.SHF_CODE = R5ACTSCHEDULES.ACS_SHIFT |
R5SHIFTS full outer join R5ACTSCHEDULES |
|
R5SHIFTS <--> R5DSCHAVAIL |
R5SHIFTS.SHF_CODE = R5DSCHAVAIL.SHA_SHIFT |
R5SHIFTS full outer join R5DSCHAVAIL |
|
R5SHIFTS <--> R5EVENTS |
R5SHIFTS.SHF_CODE = R5EVENTS.EVT_SHIFT |
R5SHIFTS full outer join R5EVENTS |
|
R5SHIFTS <--> R5SHFDAYS |
R5SHIFTS.SHF_CODE = R5SHFDAYS.SHD_SHIFT |
R5SHIFTS left outer join R5SHFDAYS |
|
R5SHIFTS <--> R5SHFPERS |
R5SHIFTS.SHF_CODE = R5SHFPERS.SHP_SHIFT |
R5SHIFTS left outer join R5SHFPERS |
|
R5SHUTDOWNS <--> R5PROJECTS |
R5SHUTDOWNS.SDS_CODE = R5PROJECTS.PRJ_SHUTDOWN |
R5SHUTDOWNS full outer join R5PROJECTS |
|
R5SHUTDOWNS <--> R5SHUTDOWNOBJECTS |
R5SHUTDOWNS.SDS_CODE = R5SHUTDOWNOBJECTS.SOB_SHUTDOWN |
R5SHUTDOWNS full outer joins R5SHUTDOWNOBJECTS |
|
R5STANDWORKS <--> R5ASPECTPOINTS |
R5STANDWORKS.STW_CODE = R5ASPECTPOINTS.APO_MAXSTWO |
R5STANDWORKS full outer join R5ASPECTPOINTS |
|
R5STANDWORKS <--> R5CHILDWORKS |
R5STANDWORKS.STW_CODE = R5CHILDWORKS.CHW_PARENTSTWO |
R5STANDWORKS left outer join R5CHILDWORKS |
|
R5STANDWORKS <--> R5EVENTPOINTS |
R5STANDWORKS.STW_CODE = R5EVENTPOINTS.EPO_MINSTWO |
R5STANDWORKS full outer join R5EVENTPOINTS |
|
R5STANDWORKS <--> R5EVENTS |
R5STANDWORKS.STW_CODE = R5EVENTS.EVT_STANDWORK |
R5STANDWORKS full outer join R5EVENTS |
|
R5STANDWORKS <--> R5OBJECTASPECTS |
R5STANDWORKS.STW_CODE = R5OBJECTASPECTS.OBA_MAXSTWO |
R5STANDWORKS full outer join R5OBJECTASPECTS |
|
R5STANDWORKS <--> R5SERVICECODES |
R5STANDWORKS.STW_CODE = R5SERVICECODES.SRV_STANDWORK |
R5STANDWORKS full outer join R5SERVICECODES |
|
R5STANDWORKS <--> R5SHUTDOWNOBJECTS |
R5STANDWORKS.STW_CODE = R5SHUTDOWNOBJECTS.SOB_STANDWORK |
R5STANDWORKS full outer join R5SHUTDOWNOBJECTS |
|
R5STANDWORKS <--> R5STANDWACTS |
R5STANDWORKS.STW_CODE = R5STANDWACTS.WAC_STANDWORK |
R5STANDWORKS left outer join R5STANDWACTS |
|
R5STANDWORKS <--> R5STOCK |
R5STANDWORKS.STW_CODE = R5STOCK.STO_REPSTANDWORK |
R5STANDWORKS full outer join R5STOCK |
|
R5STOCK <--> R5BINSTOCK |
R5STOCK.STO_PART_ORG = R5BINSTOCK.BIS_PART_ORG AND R5STOCK.STO_STORE = R5BINSTOCK.BIS_STORE AND R5STOCK.STO_PART = R5BINSTOCK.BIS_PART |
R5STOCK left outer join R5BINSTOCK |
|
R5STOCK <--> R5FIFO |
R5STOCK.STO_PART = R5FIFO.FIF_PART and R5STOCK.STO_PART_ORG = R5FIFO.FIF_PART_ORG and R5STOCK.STO_STORE = R5FIFO.FIF_STORE |
R5STOCK full outer join R5FIFO |
|
R5STOCK <--> R5ISSUES |
R5STOCK.STO_PART = R5ISSUES.ISS_PART and R5STOCK.STO_PART_ORG = R5ISSUES.ISS_PART_ORG and R5STOCK.STO_STORE = R5ISSUES.ISS_STORE |
R5STOCK full outer join R5ISSUES |
|
R5STORES <--> R5BINS |
R5STORES.STR_CODE = R5BINS.BIN_STORE |
R5STORES left outer join R5BINS |
|
R5STORES <--> R5BLANKETORDERS |
R5STORES.STR_CODE = R5BLANKETORDERS.BLO_STORE |
R5STORES full outer join R5BLANKETORDERS |
|
R5STORES <--> R5CONTRACTS |
R5STORES.STR_CODE = R5CONTRACTS.CON_STORE |
R5STORES full outer join R5CONTRACTS |
|
R5STORES <--> R5DOCKRECEIPTS |
R5STORES.STR_CODE = R5DOCKRECEIPTS.DCK_DOCKID |
R5STORES full outer join R5DOCKRECEIPTS |
|
R5STORES <--> R5MRCS |
R5STORES.STR_CODE = R5MRCS.MRC_STORE |
R5STORES full outer join R5MRCS |
|
R5STORES <--> R5OBJECTS |
R5STORES.STR_CODE = R5OBJECTS.OBJ_STORE |
R5STORES full outer join R5OBJECTS |
|
R5STORES <--> R5ORDERLINES |
R5STORES.STR_CODE = R5ORDERLINES.ORL_STORE |
R5STORES full outer join R5ORDERLINES |
|
R5STORES <--> R5ORDERS |
R5STORES.STR_CODE = R5ORDERS.ORD_STORE |
R5STORES full outer join R5ORDERS |
|
R5STORES <--> R5PICKLISTS |
R5STORES.STR_CODE = R5PICKLISTS.PIC_STORE |
R5STORES full outer join R5PICKLISTS |
|
R5STORES <--> R5QUOTATIONS |
R5STORES.STR_CODE = R5QUOTATIONS.QUO_STORE |
R5STORES full outer join R5QUOTATIONS |
|
R5STORES <--> R5STOCK |
R5STORES.STR_CODE = R5STOCK.STO_STORE |
R5STORES left outer join R5STOCK |
|
R5STORES <--> R5STOCKOUTS |
R5STORES.STR_CODE = R5STOCKOUTS.SOU_STORE |
R5STORES full outer join R5STOCKOUTS |
|
R5STORES <--> R5STORES |
R5STORES.STR_CODE = R5STORES.STR_PARENT |
No joins exist |
|
R5STORES <--> R5SUMUSAGE |
R5STORES.STR_CODE = R5SUMUSAGE.USG_STORE |
R5STORES left outer join R5SUMUSAGE |
|
R5STORES <--> R5TRANSTOCK |
R5STORES.STR_CODE = R5TRANSTOCK.TST_STORE |
R5STORES full outer join R5TRANSTOCK |
|
R5SUPPEVALCODES <--> R5GROUPSEVALCODES |
R5SUPPEVALCODES.EVD_CODE = R5GROUPSEVALCODES.GSE_EVDCODE |
R5SUPPEVALCODES left outer join R5GROUPSEVALCODES |
|
R5SUPPEVALCODES <--> R5SUPPEVALUATION |
R5SUPPEVALCODES.EVD_CODE = R5SUPPEVALUATION.EVA_CODE |
R5SUPPEVALCODES full outer join R5SUPPEVALUATION |
|
R5SUPPEVALUATION <--> R5SUPPEVALINES |
R5SUPPEVALUATION.EVA_NO = R5SUPPEVALINES.EVL_EVALUATION |
R5SUPPEVALUATION left outer join R5SUPPEVALINES |
|
R5TASKS <--> R5ACTIVITIES |
R5TASKS.TSK_CODE = R5ACTIVITIES.ACT_TASK and R5TASKS.TSK_REVISION = R5ACTIVITIES.ACT_TASKREV |
R5TASKS full outer join R5ACTIVITIES |
|
R5TASKS <--> R5CALGROUPS |
R5TASKS.TSK_CODE = R5CALGROUPS.CLG_TASK and R5TASKS.TSK_REVISION = R5CALGROUPS.CLG_TASKREV |
R5TASKS full outer join R5CALGROUPS |
|
R5TASKS <--> R5ORDERLINES |
R5TASKS.TSK_CODE = R5ORDERLINES.ORL_TASK and R5TASKS.TSK_REVISION = R5ORDERLINES.ORL_TASKREV |
R5TASKS full outer join R5ORDERLINES |
|
R5TASKS <--> R5REQUISLINES |
R5TASKS.TSK_CODE = R5REQUISLINES.RQL_TASK and R5TASKS.TSK_REVISION = R5REQUISLINES.RQL_TASKREV |
R5TASKS full outer join R5REQUISLINES |
|
R5TASKS <--> R5TASKPRICES |
R5TASKS.TSK_REVISION = R5TASKPRICES.TPR_REVISION AND R5TASKS.TSK_CODE = R5TASKPRICES.TPR_TASK |
R5TASKS left outer join R5TASKPRICE |
|
R5TASKS <--> R5TASKQUALIFICATIONS |
R5TASKS.TSK_REVISION = R5TASKQUALIFICATIONS.TQU_REVISION AND R5TASKS.TSK_CODE = R5TASKQUALIFICATIONS.TQU_TASK |
R5TASKS left outer join R5TASKQUALIFICATIONS |
|
R5TAXES <--> R5CATALOGUE |
R5TAXES.TAX_CODE = R5CATALOGUE.CAT_TAX |
R5TAXES full outer join R5CATALOGUE |
|
R5TAXES <--> R5DEBTORS |
R5TAXES.TAX_CODE = R5DEBTORS.DEB_TAX |
R5TAXES full outer join R5DEBTORS |
|
R5TAXES <--> R5PARTS |
R5TAXES.TAX_CODE = R5PARTS.PAR_TAX |
R5TAXES full outer join R5PARTS |
|
R5TAXES <--> R5SERVICECATALOG UE |
R5TAXES.TAX_CODE = R5SERVICECATALOGUE.SCA_TAX |
R5TAXES full outer join R5SERVICECATALOGUE |
|
R5TAXES <--> R5TAXCODERATES |
R5TAXES.TAX_CODE = R5TAXCODERATES.TCR_TAX |
R5TAXES left outer join R5TAXCODERATES |
|
R5TAXRATES <--> R5TAXCODERATES |
R5TAXRATES.TXR_CODE = R5TAXCODERATES.TCR_RATE |
R5TAXRATES left outer join R5TAXCODERATES |
|
R5TAXRATES <--> R5TAXRATEVALUES |
R5TAXRATES.TXR_CODE = R5TAXRATEVALUES.TXV_RATE |
R5TAXRATES left outer join R5TAXRATEVALUES |
|
R5TAXRATETYPES <--> R5TAXRATES |
R5TAXRATETYPES.TXT_CODE = R5TAXRATES.TXR_RATETYPE |
R5TAXRATETYPES full outer join R5TAXRATES |
|
R5TOOLS <--> R5MRCTOOLS |
R5TOOLS.TOO_CODE = R5MRCTOOLS.MRT_TOOL |
R5TOOLS left outer join R5MRCTOOLS |
|
R5TOOLS <--> R5PARTS |
R5TOOLS.TOO_CODE = R5PARTS.PAR_TOOL |
R5TOOLS full outer join R5PARTS |
|
R5TOOLS <--> R5PPMTOOLS |
R5TOOLS.TOO_CODE = R5PPMTOOLS.PPT_TOOL |
R5TOOLS left outer join R5PPMTOOLS |
|
R5TOOLS <--> R5STANDTOOLS |
R5TOOLS.TOO_CODE = R5STANDTOOLS.WTD_TOOL |
R5TOOLS left outer join R5STANDTOOLS |
|
R5TOOLS <--> R5TOOLREQ |
R5TOOLS.TOO_CODE = R5TOOLREQ.TOR_TOOL |
R5TOOLS left outer join R5TOOLREQ |
|
R5TOOLS <--> R5TOOLUSAGE |
R5TOOLS.TOO_CODE = R5TOOLUSAGE.TOU_TOOL |
R5TOOLS left outer join R5TOOLUSAGE |
|
R5TRACKINGPROMPTSSQL <--> R5TRACKINGPROMPTS |
R5TRACKINGPROMPTSSQL.TKL_SQLCODE = R5TRACKINGPROMPTS.TKP_SQLCO DE |
R5TRACKINGPROMPTSSQL full outer join R5TRACKINGPROMPTS |
|
R5TRADES <--> R5ACTIVITIES |
R5TRADES.TRD_CODE = R5ACTIVITIES.ACT_TRADE |
R5TRADES full outer join R5ACTIVITIES |
|
R5TRADES <--> R5ACTSCHEDULES |
R5TRADES.TRD_CODE = R5ACTSCHEDULES.ACS_TRADE |
R5TRADES full outer join R5ACTSCHEDULES |
|
R5TRADES <--> R5ADDITIONALCHARGE |
R5TRADES.TRD_CODE = R5ADDITIONALCHARGE.ADC_TRADE |
R5TRADES full outer join R5ADDITIONALCHARGE |
|
R5TRADES <--> R5AVAILABILITY |
R5TRADES.TRD_CODE = R5AVAILABILITY.AVL_TRADE |
R5TRADES left outer join R5AVAILABILITY |
|
R5TRADES <--> R5BOOKEDHOURS |
R5TRADES.TRD_CODE = R5BOOKEDHOURS.BOO_TRADE |
R5TRADES full outer join R5BOOKEDHOURS |
|
R5TRADES <--> R5DSCHAVAIL |
R5TRADES.TRD_CODE = R5DSCHAVAIL.SHA_TRADE |
R5TRADES full outer join R5DSCHAVAIL |
|
R5TRADES <--> R5EXTTARIFFS |
R5TRADES.TRD_CODE = R5EXTTARIFFS.ETA_TRADE |
R5TRADES left outer join R5EXTTARIFFS |
|
R5TRADES <--> R5ORDERLINES |
R5TRADES.TRD_CODE = R5ORDERLINES.ORL_TRADE |
R5TRADES full outer join R5ORDERLINES |
|
R5TRADES <--> R5PERSONNEL |
R5TRADES.TRD_CODE = R5PERSONNEL.PER_TRADE |
R5TRADES full outer join R5PERSONNEL |
|
R5TRADES <--> R5PPMACTS |
R5TRADES.TRD_CODE = R5PPMACTS.PPA_TRADE |
R5TRADES full outer join R5PPMACTS |
|
R5TRADES <--> R5QUOTLINES |
R5TRADES.TRD_CODE = R5QUOTLINES.QUL_TRADE |
R5TRADES full outer join R5QUOTLINES |
|
R5TRADES <--> R5REQUISLINES |
R5TRADES.TRD_CODE = R5REQUISLINES.RQL_TRADE |
R5TRADES full outer join R5REQUISLINES |
|
R5TRADES <--> R5STANDWACTS |
R5TRADES.TRD_CODE = R5STANDWACTS.WAC_TRADE |
R5TRADES full outer join R5STANDWACTS |
|
R5TRADES <--> R5TASKS |
R5TRADES.TRD_CODE = R5TASKS.TSK_TRADE |
R5TRADES full outer join R5TASKS |
|
R5TRADES <--> R5TRADEQUALIFICATIONS |
R5TRADES.TRD_CODE = R5TRADEQUALIFICATIONS.TRQ_TRADE |
R5TRADES left outer join R5TRADEQUALIFICATIONS |
|
R5TRADES <--> R5TRADERATES |
R5TRADES.TRD_CODE = R5TRADERATES.TRR_TRADE |
R5TRADES left outer join R5TRADERATES |
|
R5TRADES <--> R5WORKPACKAGES |
R5TRADES.TRD_CODE = R5WORKPACKAGES.WPK_TRADE |
R5TRADES full outer join R5WORKPACKAGES |
|
R5TRANSACTIONS <--> R5SUPPEVALUATION |
R5TRANSACTIONS.TRA_CODE = R5SUPPEVALUATION.EVA_RECEIPT |
R5TRANSACTIONS full outer join R5SUPPEVALUATION |
|
R5TRANSACTIONS <--> R5TRANSLINES |
R5TRANSACTIONS.TRA_CODE = R5TRANSLINES.TRL_TRANS |
R5TRANSACTIONS left outer join R5TRANSLINES |
|
R5UOMS <--> R5ACTIVITIES |
R5UOMS.UOM_CODE = R5ACTIVITIES.ACT_UOM |
R5UOMS full outer join R5ACTIVITIES |
|
R5UOMS <--> R5ADDPROPERTIES |
R5UOMS.UOM_CODE = R5ADDPROPERTIES.APR_UOM |
R5UOMS full outer join R5ADDPROPERTIES |
|
R5UOMS <--> R5ASPECTPOINTS |
R5UOMS.UOM_CODE = R5ASPECTPOINTS.APO_UOM |
R5UOMS full outer join R5ASPECTPOINTS |
|
R5UOMS <--> R5BLANKETORDLINES |
R5UOMS.UOM_CODE = R5BLANKETORDLINES.BLL_UOM |
R5UOMS full outer join R5BLANKETORDLINES |
|
R5UOMS <--> R5CATALOGUE |
R5UOMS.UOM_CODE = R5CATALOGUE.CAT_PURUOM |
R5UOMS full outer join R5CATALOGUE |
|
R5UOMS <--> R5CONPARTS |
R5UOMS.UOM_CODE = R5CONPARTS.CPA_PURUOM |
R5UOMS full outer join R5CONPARTS |
|
R5UOMS <--> R5CONVUOM |
R5UOMS.UOM_CODE = R5CONVUOM.CNV_UOMFROM |
R5UOMS left outer join R5CONVUOM |
|
R5UOMS <--> R5ENTITYPARTS |
R5UOMS.UOM_CODE = R5ENTITYPARTS.EPA_UOM |
R5UOMS full outer join R5ENTITYPARTS |
|
R5UOMS <--> R5EVENTPOINTS |
R5UOMS.UOM_CODE = R5EVENTPOINTS.EPO_UOM |
R5UOMS full outer join R5EVENTPOINTS |
|
R5UOMS <--> R5EVENTS |
R5UOMS.UOM_CODE = R5EVENTS.EVT_METUOM |
R5UOMS full outer join R5EVENTS |
|
R5UOMS <--> R5EVTTESTPOINTS |
R5UOMS.UOM_CODE = R5EVTTESTPOINTS.ETP_TESTPOINTUOM |
R5UOMS full outer join R5EVTTESTPOINTS |
|
R5UOMS <--> R5EVTTESTPOINTS5 |
R5UOMS.UOM_CODE = R5EVTTESTPOINTS.ETP_TESTPOINTUOM |
(R5UOMS.UOM_CODE = R5EVTTESTPOINTS.ETP_TESTPOINTUOM) |
|
R5UOMS <--> R5HOME |
R5UOMS.UOM_CODE = R5HOME.HOM_UOM |
R5UOMS full outer join R5HOME |
|
R5UOMS <--> R5INDICATORS |
R5UOMS.UOM_CODE = R5INDICATORS.IND_UOM |
R5UOMS full outer join R5INDICATORS |
|
R5UOMS <--> R5MATERIALSTANDARDS |
R5UOMS.UOM_CODE = R5MATERIALSTANDARDS.MST_TEMPUOM |
R5UOMS full outer join R5MATERIALSTANDARDS |
|
R5UOMS <--> R5MATLPARTS |
R5UOMS.UOM_CODE = R5MATLPARTS.MLP_UOM |
R5UOMS full outer join R5MATLPARTS |
|
R5UOMS <--> R5OBJECTASPECTS |
R5UOMS.UOM_CODE = R5OBJECTASPECTS.OBA_UOM |
R5UOMS full outer join R5OBJECTASPECTS |
|
R5UOMS <--> R5OBJECTS |
R5UOMS.UOM_CODE = R5OBJECTS.OBJ_PRIMARYUOM |
(R5UOMS.UOM_CODE = R5OBJECTS.OBJ_PRIMARYUOM) |
|
R5UOMS <--> R5OBJTESTPOINTS |
R5UOMS.UOM_CODE = R5OBJTESTPOINTS.OTP_TESTPOINTUOM |
R5UOMS full outer join R5OBJTESTPOINTS |
|
R5UOMS <--> R5ORDERLINES |
R5UOMS.UOM_CODE = R5ORDERLINES.ORL_PURUOM |
R5UOMS full outer join R5ORDERLINES |
|
R5UOMS <--> R5PACKINGSLIP |
R5UOMS.UOM_CODE = R5PACKINGSLIP.PSL_DELUOM |
R5UOMS full outer join R5PACKINGSLIP |
|
R5UOMS <--> R5PARTS |
R5UOMS.UOM_CODE = R5PARTS.PAR_UOM |
R5UOMS full outer join R5PARTS |
|
R5UOMS <--> R5PPMACTS |
R5UOMS.UOM_CODE = R5PPMACTS.PPA_UOM |
R5UOMS full outer join R5PPMACTS |
|
R5UOMS <--> R5PPMOBJECTS |
R5UOMS.UOM_CODE = R5PPMOBJECTS.PPO_METUOM |
R5UOMS full outer join R5PPMOBJECTS |
|
R5UOMS <--> R5PPMS |
R5UOMS.UOM_CODE = R5PPMS.PPM_METUOM2 |
R5UOMS full outer join R5PPMS |
|
R5UOMS <--> R5QUOTLINES |
R5UOMS.UOM_CODE = R5QUOTLINES.QUL_PURUOM |
R5UOMS full outer join R5QUOTLINES |
|
R5UOMS <--> R5READINGS |
R5UOMS.UOM_CODE = R5READINGS.REA_UOM |
(R5UOMS.UOM_CODE = R5READINGS.REA_UOM) |
|
R5UOMS <--> R5REQUISLINES |
R5UOMS.UOM_CODE = R5REQUISLINES.RQL_UOM |
R5UOMS full outer join R5REQUISLINES |
|
R5UOMS <--> R5SERVICECATALOGUE |
R5UOMS.UOM_CODE = R5SERVICECATALOGUE.SCA_UOM |
R5UOMS full outer join R5SERVICECATALOGUE |
|
R5UOMS <--> R5STANDWACTS |
R5UOMS.UOM_CODE = R5STANDWACTS.WAC_UOM |
R5UOMS full outer join R5STANDWACTS |
|
R5UOMS <--> R5STOCK |
R5UOMS.UOM_CODE = R5STOCK.STO_PREFUOM |
R5UOMS full outer join R5STOCK |
|
R5UOMS <--> R5TASKS |
R5UOMS.UOM_CODE = R5TASKS.TSK_UOM |
R5UOMS full outer join R5TASKS |
|
R5UOMS <--> R5UOMCONVERSION |
R5UOMS.UOM_CODE = R5UOMCONVERSION.UOC_SITEUOM |
R5UOMS left outer join R5UOMCONVERSION |
|
R5UOMS <--> R5WARCLAIMS |
R5UOMS.UOM_CODE = R5WARCLAIMS.WCL_UOM |
R5UOMS full outer join R5WARCLAIMS |
|
R5UOMS <--> R5WARCOVERAGE S |
R5UOMS.UOM_CODE = R5WARCOVERAGES.WCV_UOM |
R5UOMS full outer join R5WARCOVERAGES |
|
R5USERS <--> R5ADDETAILS |
R5USERS.USR_CODE = R5ADDETAILS.ADD_USER |
R5USERS full outer join R5ADDETAILS |
|
R5USERS <--> R5APPROVEUSERS |
R5USERS.USR_CODE = R5APPROVEUSERS.APU_USER |
R5USERS left outer join R5APPROVEUSERS |
|
R5USERS <--> R5AUTH |
R5USERS.USR_CODE = R5AUTH.AUT_USER |
R5USERS full outer join R5AUTH |
|
R5USERS <--> R5BLANKETORDERS |
R5USERS.USR_CODE = R5BLANKETORDERS.BLO_BUYER |
R5USERS full outer join R5BLANKETORDERS |
|
R5USERS <--> R5BLANKETORDUSERS |
R5USERS.USR_CODE = R5BLANKETORDUSERS.BLU_USER |
R5USERS left outer join R5BLANKETORDUSERS |
|
R5USERS <--> R5BUDGETS |
R5USERS.USR_CODE = R5BUDGETS.BUD_AUTH |
R5USERS full outer join R5BUDGETS |
|
R5USERS <--> R5CALCEVENTS |
R5USERS.USR_CODE = R5CALCEVENTS.CEV_ORIGIN |
R5USERS full outer join R5CALCEVENTS |
|
R5USERS <--> R5COMPANIES |
R5USERS.USR_CODE = R5COMPANIES.COM_BUYER |
R5USERS full outer join R5COMPANIES |
|
R5USERS <--> R5CREDITCARDUSERS |
R5USERS.USR_CODE = R5CREDITCARDUSERS.CCU_USER |
R5USERS left outer join R5CREDITCARDUSERS |
|
R5USERS <--> R5CRITINDEX |
R5USERS.USR_CODE = R5CRITINDEX.CRX_USER |
R5USERS full outer join R5CRITINDEX |
|
R5USERS <--> R5DDDATASPY |
R5USERS.USR_CODE = R5DDDATASPY.DDS_OWNER |
R5USERS full outer join R5DDDATASPY |
|
R5USERS <--> R5DETAILAUDIT |
R5USERS.USR_CODE = R5DETAILAUDIT.DTA_DELUSER |
R5USERS full outer join R5DETAILAUDIT |
|
R5USERS <--> R5DOCKLINES |
R5USERS.USR_CODE = R5DOCKLINES.DKL_UPDUSER |
R5USERS full outer join R5DOCKLINES |
|
R5USERS <--> R5DOCKRECEIPTS |
R5USERS.USR_CODE = R5DOCKRECEIPTS.DCK_USER |
R5USERS full outer join R5DOCKRECEIPTS |
|
R5USERS <--> R5DOCUMENTS |
R5USERS.USR_CODE = R5DOCUMENTS.DOC_LOCKUSER |
R5USERS full outer join R5DOCUMENTS |
|
R5USERS <--> R5ELECARCHIVE |
R5USERS.USR_CODE = R5ELECARCHIVE.ELA_USER |
R5USERS full outer join R5ELECARCHIVE |
|
R5USERS <--> R5ENTAPPHEADER |
R5USERS.USR_CODE = R5ENTAPPHEADER.EAH_USER |
R5USERS full outer join R5ENTAPPHEADER |
|
R5USERS <--> R5ENTAPPLISTS |
R5USERS.USR_CODE = R5ENTAPPLISTS.EAL_USER |
R5USERS full outer join R5ENTAPPLISTS |
|
R5USERS <--> R5EVENTS |
R5USERS.USR_CODE = R5EVENTS.EVT_ENTEREDBY |
R5USERS full outer join R5EVENTS |
|
R5USERS <--> R5EXTINVOICES |
R5USERS.USR_CODE = R5EXTINVOICES.EIV_ORIGIN |
R5USERS full outer join R5EXTINVOICES |
|
R5USERS <--> R5HOMEUSERS |
R5USERS.USR_CODE = R5HOMEUSERS.HMU_USER |
R5USERS left outer join R5HOMEUSERS |
|
R5USERS <--> R5INVOICES |
R5USERS.USR_CODE = R5INVOICES.INV_AUTH |
R5USERS full outer join R5INVOICES |
|
R5USERS <--> R5MATERIALSTAND ARDS |
R5USERS.USR_CODE = R5MATERIALSTANDARDS.MST_USER |
R5USERS full outer join R5MATERIALSTANDARDS |
|
R5USERS <--> R5OBJECTRISK |
R5USERS.USR_CODE = R5OBJECTRISK.OBR_USER |
(R5USERS.USR_CODE = R5OBJECTRISK.OBR_USER) |
|
R5USERS <--> R5OBJECTS |
R5USERS.USR_CODE = R5OBJECTS.OBJ_USER |
R5USERS full outer join R5OBJECTS |
|
R5USERS <--> R5ORDERS |
R5USERS.USR_CODE = R5ORDERS.ORD_BUYER |
R5USERS full outer join R5ORDERS |
|
R5USERS <--> R5PARTS |
R5USERS.USR_CODE = R5PARTS.PAR_BUYER |
R5USERS full outer join R5PARTS |
|
R5USERS <--> R5PASSWORDS |
R5USERS.USR_CODE = R5PASSWORDS.PWD_USER |
R5USERS left outer join R5PASSWORDS |
|
R5USERS <--> R5PERSONNEL |
R5USERS.USR_CODE = R5PERSONNEL.PER_USER |
R5USERS full outer join R5PERSONNEL |
|
R5USERS <--> R5PICKLISTS |
R5USERS.USR_CODE = R5PICKLISTS.PIC_AUTH |
R5USERS full outer join R5PICKLISTS |
|
R5USERS <--> R5PIPINGCLASS |
R5USERS.USR_CODE = R5PIPINGCLASS.PCS_USER |
R5USERS full outer join R5PIPINGCLASS |
|
R5USERS <--> R5PRINTERUSERS |
R5USERS.USR_CODE = R5PRINTERUSERS.PNU_USER |
R5USERS left outer join R5PRINTERUSERS |
|
R5USERS <--> R5QUOTATIONS |
R5USERS.USR_CODE = R5QUOTATIONS.QUO_AUTH |
R5USERS full outer join R5QUOTATIONS |
|
R5USERS <--> R5REPORTFILTERS |
R5USERS.USR_CODE = R5REPORTFILTERS.RFI_USER |
R5USERS left outer join R5REPORTFILTERS |
|
R5USERS <--> R5REQUISITIONS |
R5USERS.USR_CODE = R5REQUISITIONS.REQ_AUTH |
R5USERS full outer join R5REQUISITIONS |
|
R5USERS <--> R5REQUISLINES |
R5USERS.USR_CODE = R5REQUISLINES.RQL_BUYER |
R5USERS full outer join R5REQUISLINES |
|
R5USERS <--> R5RISK |
R5USERS.USR_CODE = R5RISK.RIS_USER |
R5USERS full outer join R5RISK |
|
R5USERS <--> R5SERVICELOGS |
R5USERS.USR_CODE = R5SERVICELOGS.LOG_ENTEREDBY |
R5USERS full outer join R5SERVICELOGS |
|
R5USERS <--> R5SERVICEREQUE STS |
R5USERS.USR_CODE = R5SERVICEREQUESTS.SRQ_ENTEREDBY |
R5USERS full outer join R5SERVICEREQUESTS |
|
R5USERS <--> R5STOREDORDERING |
R5USERS.USR_CODE = R5STOREDORDERING.SOR_USER |
R5USERS left outer join R5STOREDORDERING |
|
R5USERS <--> R5STOREDQUERIES |
R5USERS.USR_CODE = R5STOREDQUERIES.SQU_USER |
R5USERS left outer join R5STOREDQUERIES |
|
R5USERS <--> R5SUPPEVALUATION |
R5USERS.USR_CODE = R5SUPPEVALUATION.EVA_ENTERED BY |
R5USERS full outer join R5SUPPEVALUATION |
|
R5USERS <--> R5TASKS |
R5USERS.USR_CODE = R5TASKS.TSK_BUYER |
R5USERS full outer join R5TASKS |
|
R5USERS <--> R5TRANSACTIONS |
R5USERS.USR_CODE = R5TRANSACTIONS.TRA_AUTH |
R5USERS full outer join R5TRANSACTIONS |
|
R5USERS <--> R5USEGRIDGISDEFAULT |
R5USERS.USR_CODE = R5USEGRIDGISDEFAULT.UGD_USERID |
R5USERS left outer join R5USEGRIDGISDEFAULT |
|
R5USERS <--> R5USEGRIDSYSDEFAULT |
R5USERS.USR_CODE = R5USEGRIDSYSDEFAULT.USD_USERID |
R5USERS left outer join R5USEGRIDSYSDEFAULT |
|
R5USERS <--> R5USERORGANIZATION |
R5USERS.USR_CODE = R5USERORGANIZATION.UOG_USER |
R5USERS left outer join R5USERORGANIZATION |
|
R5USERS <--> R5USERPORTLET |
R5USERS.USR_CODE = R5USERPORTLET.UPT_USER |
R5USERS left outer join R5USERPORTLET |
|
R5USERS <--> R5USERPREFERENCES |
R5USERS.USR_CODE = R5USERPREFERENCES.USP_USER |
R5USERS left outer join R5USERPREFERENCES |
|
R5USERS <--> R5USERPREFS |
R5USERS.USR_CODE = R5USERPREFS.UPF_USER |
R5USERS left outer join R5USERPREFS |
|
R5USERS <--> R5USERQAB |
R5USERS.USR_CODE = R5USERQAB.UQA_USER |
R5USERS left outer join R5USERQAB |
|
R5USERS <--> R5WARCOVERAGES |
R5USERS.USR_CODE = R5WARCOVERAGES.WCV_USER |
R5USERS full outer join R5WARCOVERAGES |
|
R5WORKPACKAGES <--> R5EVENTS |
R5WORKPACKAGES.WPK_CODE = R5EVENTS.EVT_PACKAGE |
R5WORKPACKAGES full outer join R5EVENTS |
|
R5WORKPACKAGES <--> R5PPMOBJECTS |
R5WORKPACKAGES.WPK_CODE = R5PPMOBJECTS.PPO_PACKAGE |
R5WORKPACKAGES full outer join R5PPMOBJECTS |
|
R5WORKPACKAGES <--> R5WPPERSONS |
R5WORKPACKAGES.WPK_CODE = R5WPPERSONS.WPP_PACKAGE |
R5WORKPACKAGES left outer join R5WPPERSONS |
|
R5YEARS <--> R5BUDGETS |
R5YEARS.ACY_YEAR = R5BUDGETS.BUD_YEAR |
R5YEARS left outer join R5BUDGETS |
|
R5YEARS <--> R5PERIODS |
R5YEARS.ACY_YEAR = R5PERIODS.ACP_YEAR |
R5YEARS left outer join R5PERIODS |