1. Tables and Views for Sales and Fusion Service
  2. SVC_SR_ADDRESSES_

SVC_SR_ADDRESSES_

This table is used to store the service address of the SR.

Details

  • Schema: FUSION

  • Object owner: SVC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

SVC_SR_ADDRESSES_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, SERVICE_ADDRESS_ID

Columns

Name Datatype Length Precision Not-null Comments
SERVICE_ADDRESS_ID NUMBER 18 Yes Auto-generated number and the primary key for this table.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SR_ID NUMBER 18 Foreign key that references SVC_SERVICE_REQUESTS (SR_ID), the SR_ID that this address belongs to.
ADDRESS_SOURCE_CD VARCHAR2 30 Lookup code that indicates source of address.
LOCATION_ID NUMBER 18 The id of the address, depends on the address source.
PARTY_SITE_ID NUMBER 18 The id of the party site, depends on the address source. This is a foreign key reference to HZ_PARTY_SITES (PARTY_SITE_ID).
ADDRESS1 VARCHAR2 240 The first line of the address where the service will be performed.
ADDRESS2 VARCHAR2 240 The second line of the address where the service will be performed.
ADDRESS3 VARCHAR2 240 The third line of the address where the service will be performed.
ADDRESS4 VARCHAR2 240 The fourth line of the address where the service will be performed.
CITY VARCHAR2 60 The city where the service will be performed.
COUNTY VARCHAR2 60 The county where the service will be performed.
POSTAL_CODE VARCHAR2 60 The postal code where the service will be performed.
STATE VARCHAR2 60 The state where the service will be performed.
PROVINCE VARCHAR2 60 The province where the service will be performed.
COUNTRY VARCHAR2 2 The country where the service will be performed.
TIMEZONE_CODE VARCHAR2 50 The timezone code of the address where the service will be performed.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
SVC_SR_ADDRESSES_PK_ Unique DEFAULT LAST_UPDATE_DATE, LAST_UPDATED_BY, SERVICE_ADDRESS_ID
SVC_SR_ADDRESSES_N1_ Non Unique Default SERVICE_ADDRESS_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY
SVC_SR_ADDRESSES_N2_ Non Unique Default AUDIT_ACTION_TYPE_