Table: XNP_SV_AUDITS

Product:	XNP - Number Portability
Description:	Stores all subscription audits issued from a service provider
Implementation/DBA Data:	XNP.XNP_SV_AUDITS

Primary Key: XNP_SV_AUDITS_PK

1. SV_AUDIT_ID

Primary Key: XNP_SV_AUDITS_UK1

1. OBJECT_REFERENCE

Primary Key: XNP_SV_AUDITS_UK2

1. SP_ID
2. STARTING_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
XNP_SV_AUDITS		XNP_SERVICE_PROVIDERS	XNP_SV_AUDITS.FOR_SP_ID
XNP_SV_AUDITS		XNP_SERVICE_PROVIDERS	XNP_SV_AUDITS.SP_ID
XNP_AUDIT_DISCREPANCIES		XNP_SV_AUDITS	XNP_AUDIT_DISCREPANCIES.AUDIT_ID
XNP_AUDIT_SMS_FAILURES		XNP_SV_AUDITS	XNP_AUDIT_SMS_FAILURES.AUDIT_ID