Relationships defined in framework - HxGN EAM - Version 11.07.01 - Help

HxGN EAM Advanced Reporting Author Guide

Language
English
Product
HxGN EAM
Search by Category
Help
HxGN EAM Version
11.7.1

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