eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: HZ_CUST_SITE_USES_ALL

Product:	AR - Receivables
Description:	Stores business purposes assigned to customer account sites.
Implementation/DBA Data:	AR.HZ_CUST_SITE_USES_ALL

Primary Key: HZ_CUST_SITE_USES_ALL_PK

SITE_USE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
HZ_CUST_SITE_USES_ALL	HZ_CUST_ACCT_SITES_ALL	HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID
HZ_CUST_SITE_USES_ALL	RA_TERRITORIES	HZ_CUST_SITE_USES_ALL.TERRITORY_ID
HZ_CUST_SITE_USES_ALL	HZ_CUST_ACCOUNT_ROLES	HZ_CUST_SITE_USES_ALL.CONTACT_ID
AP_BANK_ACCOUNT_USES_ALL	HZ_CUST_SITE_USES_ALL	AP_BANK_ACCOUNT_USES_ALL.CUSTOMER_SITE_USE_ID
AR_AUTOREC_EXCEPTIONS	HZ_CUST_SITE_USES_ALL	AR_AUTOREC_EXCEPTIONS.PAYING_SITE_USE_ID
AR_BR_TRX_BATCH_RPT	HZ_CUST_SITE_USES_ALL	AR_BR_TRX_BATCH_RPT.DRAWEE_SITE_USE_ID
AR_CASH_RECEIPTS_ALL	HZ_CUST_SITE_USES_ALL	AR_CASH_RECEIPTS_ALL.CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_ALL	HZ_CUST_SITE_USES_ALL	AR_CASH_RECEIPTS_ALL.PREV_CUSTOMER_SITE_USE_ID
AR_CMGT_CASE_FOLDERS	HZ_CUST_SITE_USES_ALL	AR_CMGT_CASE_FOLDERS.SITE_USE_ID
AR_CMGT_CREDIT_REQUESTS	HZ_CUST_SITE_USES_ALL	AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID
AR_CONS_INV_ALL	HZ_CUST_SITE_USES_ALL	AR_CONS_INV_ALL.SITE_USE_ID
AR_CORRESPONDENCES_ALL	HZ_CUST_SITE_USES_ALL	AR_CORRESPONDENCES_ALL.SITE_USE_ID
AR_CORRESPONDENCES_ALL	HZ_CUST_SITE_USES_ALL	AR_CORRESPONDENCES_ALL.SITE_USE_ID
AR_CREDIT_HISTORIES	HZ_CUST_SITE_USES_ALL	AR_CREDIT_HISTORIES.SITE_USE_ID
AR_CREDIT_HISTORIES	HZ_CUST_SITE_USES_ALL	AR_CREDIT_HISTORIES.SITE_USE_ID
AR_CUSTOMER_ALT_NAMES	HZ_CUST_SITE_USES_ALL	AR_CUSTOMER_ALT_NAMES.SITE_USE_ID
AR_CUSTOMER_CALLS_ALL	HZ_CUST_SITE_USES_ALL	AR_CUSTOMER_CALLS_ALL.SITE_USE_ID
AR_CUSTOMER_CALL_TOPICS_ALL	HZ_CUST_SITE_USES_ALL	AR_CUSTOMER_CALL_TOPICS_ALL.SITE_USE_ID
AR_DISTRIBUTIONS_ALL	HZ_CUST_SITE_USES_ALL	AR_DISTRIBUTIONS_ALL.THIRD_PARTY_SUB_ID
AR_INTERIM_CASH_RECEIPTS_ALL	HZ_CUST_SITE_USES_ALL	AR_INTERIM_CASH_RECEIPTS_ALL.SITE_USE_ID
AR_PAYMENTS_INTERFACE_ALL	HZ_CUST_SITE_USES_ALL	AR_PAYMENTS_INTERFACE_ALL.CUSTOMER_SITE_USE_ID
AR_PAYMENT_SCHEDULES_ALL	HZ_CUST_SITE_USES_ALL	AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID
AR_RAMC_AUDIT_TRAIL	HZ_CUST_SITE_USES_ALL	AR_RAMC_AUDIT_TRAIL.BILL_TO_SITE_USE_ID
AR_SELECTION_CRITERIA	HZ_CUST_SITE_USES_ALL	AR_SELECTION_CRITERIA.SITE_USE_ID
AR_STATEMENTS_HISTORY_ALL	HZ_CUST_SITE_USES_ALL	AR_STATEMENTS_HISTORY_ALL.SITE_USE_ID
AR_STATEMENT_HEADERS	HZ_CUST_SITE_USES_ALL	AR_STATEMENT_HEADERS.SITE_USE_ID
AR_STATEMENT_LINE_CLUSTERS	HZ_CUST_SITE_USES_ALL	AR_STATEMENT_LINE_CLUSTERS.SITE_USE_ID
AR_TA_CR_AGEN_INF_ALL	HZ_CUST_SITE_USES_ALL	AR_TA_CR_AGEN_INF_ALL.CUSTOMER_SITE_USE_ID
AR_TA_CUST_INT_ALL	HZ_CUST_SITE_USES_ALL	AR_TA_CUST_INT_ALL.SITE_USE_ID
AR_TA_DEDN_INT_ALL	HZ_CUST_SITE_USES_ALL	AR_TA_DEDN_INT_ALL.CUSTOMER_SITE_USE_ID
AR_TA_DEDN_RELATE_ALL	HZ_CUST_SITE_USES_ALL	AR_TA_DEDN_RELATE_ALL.CUSTOMER_SITE_USE_ID
AR_TA_PAYMNT_HIST_ALL	HZ_CUST_SITE_USES_ALL	AR_TA_PAYMNT_HIST_ALL.BILL_TO_SITE_USE_ID
AR_TA_PROM_CUST_ALL	HZ_CUST_SITE_USES_ALL	AR_TA_PROM_CUST_ALL.SITE_USE_ID
AR_TA_PROM_CUST_MAP	HZ_CUST_SITE_USES_ALL	AR_TA_PROM_CUST_MAP.SITE_USE_ID
AR_TA_RISK_COMENT_ALL	HZ_CUST_SITE_USES_ALL	AR_TA_RISK_COMENT_ALL.CUSTOMER_SITE_USE_ID
AR_TRANSACTIONS_REP_ITF	HZ_CUST_SITE_USES_ALL	AR_TRANSACTIONS_REP_ITF.SHIP_TO_SITE_USE_ID
AR_TRANSACTIONS_REP_ITF	HZ_CUST_SITE_USES_ALL	AR_TRANSACTIONS_REP_ITF.BILL_TO_SITE_USE_ID
AR_TRX_BAL_SUMMARY	HZ_CUST_SITE_USES_ALL	AR_TRX_BAL_SUMMARY.SITE_USE_ID
AR_TRX_SUMMARY	HZ_CUST_SITE_USES_ALL	AR_TRX_SUMMARY.SITE_USE_ID
AR_TRX_SUMMARY_HIST	HZ_CUST_SITE_USES_ALL	AR_TRX_SUMMARY_HIST.SITE_USE_ID
CSI_IP_ACCOUNTS	HZ_CUST_SITE_USES_ALL	CSI_IP_ACCOUNTS.BILL_TO_ADDRESS
CSI_IP_ACCOUNTS	HZ_CUST_SITE_USES_ALL	CSI_IP_ACCOUNTS.SHIP_TO_ADDRESS
CSI_SYSTEMS_B	HZ_CUST_SITE_USES_ALL	CSI_SYSTEMS_B.SHIP_TO_SITE_USE_ID
CSI_SYSTEMS_B	HZ_CUST_SITE_USES_ALL	CSI_SYSTEMS_B.BILL_TO_SITE_USE_ID
CSI_T_TXN_SYSTEMS	HZ_CUST_SITE_USES_ALL	CSI_T_TXN_SYSTEMS.SHIP_TO_SITE_USE_ID
CSI_T_TXN_SYSTEMS	HZ_CUST_SITE_USES_ALL	CSI_T_TXN_SYSTEMS.BILL_TO_SITE_USE_ID
CS_INCIDENTS_ALL_B	HZ_CUST_SITE_USES_ALL	CS_INCIDENTS_ALL_B.SHIP_TO_SITE_USE_ID
CS_INCIDENTS_ALL_B	HZ_CUST_SITE_USES_ALL	CS_INCIDENTS_ALL_B.INSTALL_SITE_USE_ID
CS_INCIDENTS_ALL_B	HZ_CUST_SITE_USES_ALL	CS_INCIDENTS_ALL_B.BILL_TO_SITE_USE_ID
HZ_BILLING_PREFERENCES	HZ_CUST_SITE_USES_ALL	HZ_BILLING_PREFERENCES.SITE_USE_ID
HZ_CUSTOMER_PROFILES	HZ_CUST_SITE_USES_ALL	HZ_CUSTOMER_PROFILES.SITE_USE_ID
HZ_CUST_PROFILE_AMTS	HZ_CUST_SITE_USES_ALL	HZ_CUST_PROFILE_AMTS.SITE_USE_ID
PN_SPACE_ASSIGN_CUST_ALL	HZ_CUST_SITE_USES_ALL	PN_SPACE_ASSIGN_CUST_ALL.SITE_USE_ID
PN_PAYMENT_ITEMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
HZ_SUSPENSION_ACTIVITY	HZ_CUST_SITE_USES_ALL	HZ_SUSPENSION_ACTIVITY.SITE_USE_ID
IBY_EXTERNAL_PAYERS_ALL	HZ_CUST_SITE_USES_ALL	IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID
JAI_AR_TDS_CERTIFICATES	HZ_CUST_SITE_USES_ALL	JAI_AR_TDS_CERTIFICATES.SITE_USE_ID
JAI_AR_TRX_INS_HDRS_T	HZ_CUST_SITE_USES_ALL	JAI_AR_TRX_INS_HDRS_T.BILL_TO_SITE_USE_ID
JAI_AR_TRX_INS_HDRS_T	HZ_CUST_SITE_USES_ALL	JAI_AR_TRX_INS_HDRS_T.SHIP_TO_SITE_USE_ID
JAI_OM_OE_GEN_TAXINV_T	HZ_CUST_SITE_USES_ALL	JAI_OM_OE_GEN_TAXINV_T.SHIP_TO_SITE_USE_ID
JL_BR_AR_OCCURRENCE_DOCS_ALL	HZ_CUST_SITE_USES_ALL	JL_BR_AR_OCCURRENCE_DOCS_ALL.SITE_USE_ID
JL_BR_AR_PAY_SCHED_AUX	HZ_CUST_SITE_USES_ALL	JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_SITE_USE_ID
OE_BLANKET_HEADERS_ALL	HZ_CUST_SITE_USES_ALL	OE_BLANKET_HEADERS_ALL.SOLD_TO_SITE_USE_ID
OE_BLANKET_HEADERS_HIST	HZ_CUST_SITE_USES_ALL	OE_BLANKET_HEADERS_HIST.SOLD_TO_SITE_USE_ID
OE_HEADERS_IFACE_ALL	HZ_CUST_SITE_USES_ALL	OE_HEADERS_IFACE_ALL.SOLD_TO_SITE_USE_ID
OE_HEADERS_IFACE_ALL	HZ_CUST_SITE_USES_ALL	OE_HEADERS_IFACE_ALL.END_CUSTOMER_SITE_USE_ID
OE_HEADER_ACKS	HZ_CUST_SITE_USES_ALL	OE_HEADER_ACKS.END_CUSTOMER_SITE_USE_ID
OE_HEADER_ACKS	HZ_CUST_SITE_USES_ALL	OE_HEADER_ACKS.SOLD_TO_SITE_USE_ID
OE_LINES_IFACE_ALL	HZ_CUST_SITE_USES_ALL	OE_LINES_IFACE_ALL.END_CUSTOMER_SITE_USE_ID
OE_LINE_ACKS	HZ_CUST_SITE_USES_ALL	OE_LINE_ACKS.END_CUSTOMER_SITE_USE_ID
OE_ORDER_HEADERS_ALL	HZ_CUST_SITE_USES_ALL	OE_ORDER_HEADERS_ALL.END_CUSTOMER_SITE_USE_ID
OE_ORDER_HEADER_HISTORY	HZ_CUST_SITE_USES_ALL	OE_ORDER_HEADER_HISTORY.SOLD_TO_SITE_USE_ID
OE_ORDER_HEADER_HISTORY	HZ_CUST_SITE_USES_ALL	OE_ORDER_HEADER_HISTORY.END_CUSTOMER_SITE_USE_ID
OE_ORDER_LINES_ALL	HZ_CUST_SITE_USES_ALL	OE_ORDER_LINES_ALL.END_CUSTOMER_SITE_USE_ID
OE_ORDER_LINES_HISTORY	HZ_CUST_SITE_USES_ALL	OE_ORDER_LINES_HISTORY.END_CUSTOMER_SITE_USE_ID
OKL_TAX_SOURCES	HZ_CUST_SITE_USES_ALL	OKL_TAX_SOURCES.BILL_TO_CUST_ACCT_SITE_USE_ID
OKL_TAX_SOURCES	HZ_CUST_SITE_USES_ALL	OKL_TAX_SOURCES.SHIP_TO_CUST_ACCT_SITE_USE_ID
OKL_TAX_SOURCES_T	HZ_CUST_SITE_USES_ALL	OKL_TAX_SOURCES_T.BILL_TO_CUST_ACCT_SITE_USE_ID
OKL_TAX_SOURCES_T	HZ_CUST_SITE_USES_ALL	OKL_TAX_SOURCES_T.SHIP_TO_CUST_ACCT_SITE_USE_ID
OKL_TRX_EXTENSION_B	HZ_CUST_SITE_USES_ALL	OKL_TRX_EXTENSION_B.CUST_SITE_USE_ID
OZF_CHARGEBACK_HEADERS_ALL	HZ_CUST_SITE_USES_ALL	OZF_CHARGEBACK_HEADERS_ALL.BILL_TO_SITE_USE_ID
OZF_CHARGEBACK_HEADERS_ALL	HZ_CUST_SITE_USES_ALL	OZF_CHARGEBACK_HEADERS_ALL.SHIP_TO_SITE_USE_ID
OZF_CHARGEBACK_INT_ALL	HZ_CUST_SITE_USES_ALL	OZF_CHARGEBACK_INT_ALL.BILL_TO_SITE_USE_ID
OZF_CHARGEBACK_INT_ALL	HZ_CUST_SITE_USES_ALL	OZF_CHARGEBACK_INT_ALL.SHIP_TO_SITE_USE_ID
OZF_CHARGEBACK_LINES_ALL	HZ_CUST_SITE_USES_ALL	OZF_CHARGEBACK_LINES_ALL.BILL_TO_SITE_USE_ID
OZF_CHARGEBACK_LINES_ALL	HZ_CUST_SITE_USES_ALL	OZF_CHARGEBACK_LINES_ALL.SHIP_TO_SITE_USE_ID
OZF_CLAIMS_ALL	HZ_CUST_SITE_USES_ALL	OZF_CLAIMS_ALL.CUST_BILLTO_ACCT_SITE_ID
OZF_CLAIMS_ALL	HZ_CUST_SITE_USES_ALL	OZF_CLAIMS_ALL.CUST_SHIPTO_ACCT_SITE_ID
OZF_CLAIMS_ALL	HZ_CUST_SITE_USES_ALL	OZF_CLAIMS_ALL.RELATED_SITE_USE_ID
OZF_CLAIM_THRESHOLD_ALL	HZ_CUST_SITE_USES_ALL	OZF_CLAIM_THRESHOLD_ALL.SITE_USE_ID
OZF_CUST_TRD_PRFLS_ALL	HZ_CUST_SITE_USES_ALL	OZF_CUST_TRD_PRFLS_ALL.SITE_USE_ID
OZF_RESALE_HEADERS_ALL	HZ_CUST_SITE_USES_ALL	OZF_RESALE_HEADERS_ALL.BILL_TO_SITE_USE_ID
OZF_RESALE_HEADERS_ALL	HZ_CUST_SITE_USES_ALL	OZF_RESALE_HEADERS_ALL.SHIP_TO_SITE_USE_ID
OZF_RESALE_LINES_ALL	HZ_CUST_SITE_USES_ALL	OZF_RESALE_LINES_ALL.BILL_TO_SITE_USE_ID
OZF_RESALE_LINES_ALL	HZ_CUST_SITE_USES_ALL	OZF_RESALE_LINES_ALL.SHIP_TO_SITE_USE_ID
OZF_RESALE_LINES_INT_ALL	HZ_CUST_SITE_USES_ALL	OZF_RESALE_LINES_INT_ALL.BILL_TO_SITE_USE_ID
OZF_RESALE_LINES_INT_ALL	HZ_CUST_SITE_USES_ALL	OZF_RESALE_LINES_INT_ALL.SHIP_TO_SITE_USE_ID
IGS_FI_P_CUST_ACCT	HZ_CUST_SITE_USES_ALL	IGS_FI_P_CUST_ACCT.SITE_USE_ID
PN_PAYMENT_ITEMS_EFC	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_ITEMS_EFC.CUSTOMER_SITE_USE_ID
PN_PAYMENT_ITEMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_ITEMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_ITEMS_ALL.CUST_SHIP_SITE_ID
PN_PAYMENT_TERMS_EFC	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_TERMS_EFC.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_TERMS_ALL.CUST_SHIP_SITE_ID
PN_REC_AGREEMENTS_ALL	HZ_CUST_SITE_USES_ALL	PN_REC_AGREEMENTS_ALL.CUST_SITE_ID
PN_SPACE_ASSIGN_CUST_ALL	HZ_CUST_SITE_USES_ALL	PN_SPACE_ASSIGN_CUST_ALL.SITE_USE_ID
PN_TENANCIES_ALL	HZ_CUST_SITE_USES_ALL	PN_TENANCIES_ALL.CUSTOMER_SITE_USE_ID
PN_TENANCIES_HISTORY	HZ_CUST_SITE_USES_ALL	PN_TENANCIES_HISTORY.CUSTOMER_SITE_USE_ID
PN_TERM_TEMPLATES_ALL	HZ_CUST_SITE_USES_ALL	PN_TERM_TEMPLATES_ALL.CUSTOMER_SITE_USE_ID
PN_TERM_TEMPLATES_ALL	HZ_CUST_SITE_USES_ALL	PN_TERM_TEMPLATES_ALL.CUST_SHIP_SITE_ID
RA_CUSTOMER_MERGES	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_MERGES.CUSTOMER_SITE_ID
RA_CUSTOMER_MERGES	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_MERGES.DUPLICATE_SITE_ID
RA_CUSTOMER_MERGES	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_MERGES.CUSTOMER_SITE_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_TRX_ALL.BILL_TO_SITE_USE_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_TRX_ALL.SHIP_TO_SITE_USE_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_TRX_ALL.PAYING_SITE_USE_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_TRX_ALL.BILL_TO_SITE_USE_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_TRX_ALL.SOLD_TO_SITE_USE_ID
RA_CUSTOMER_TRX_LINES_ALL	HZ_CUST_SITE_USES_ALL	RA_CUSTOMER_TRX_LINES_ALL.SHIP_TO_SITE_USE_ID
RA_CUST_RECEIPT_METHODS	HZ_CUST_SITE_USES_ALL	RA_CUST_RECEIPT_METHODS.SITE_USE_ID
RA_INTERFACE_LINES_ALL	HZ_CUST_SITE_USES_ALL	RA_INTERFACE_LINES_ALL.PAYING_SITE_USE_ID
RA_TAX_EXEMPTIONS_ALL	HZ_CUST_SITE_USES_ALL	RA_TAX_EXEMPTIONS_ALL.SITE_USE_ID
RA_TAX_EXEMPTIONS_ALL	HZ_CUST_SITE_USES_ALL	RA_TAX_EXEMPTIONS_ALL.SITE_USE_ID
XDP_ORDER_LINE_ITEMS	HZ_CUST_SITE_USES_ALL	XDP_ORDER_LINE_ITEMS.SITE_USE_ID
ZX_LINES_DET_FACTORS	HZ_CUST_SITE_USES_ALL	ZX_LINES_DET_FACTORS.SHIP_TO_CUST_ACCT_SITE_USE_ID
ZX_LINES_DET_FACTORS	HZ_CUST_SITE_USES_ALL	ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID