1. Tables and Views
  2. PSC_LNP_CUST_XREF

PSC_LNP_CUST_XREF

Stores billing addresses provided during application intake.

Details

  • Schema: FUSION

  • Object owner: PSC_PER

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PSC_LNP_CUST_XREF_PK

TRXN_CUST_XREF_KEY

Columns

Name Datatype Length Precision Not-null Comments
TRXN_CUST_XREF_KEY NUMBER 18 Yes Unique numeric key for the record.
TRXN_CUST_XREF_ID VARCHAR2 50 Yes Unique alpha numeric reference for the record.
AGENCY_ID NUMBER 8 Yes Unique Identifier of the agency.
CLASSIFICATION VARCHAR2 3 Yes Type of offering.
RECORD_TYPE_ID VARCHAR2 50 Yes Type of application.
LNP_RECORD_KEY NUMBER 18 Yes Numeric identifier of the record.
LNP_RECORD_ID VARCHAR2 50 Yes Alpha numeric identifier of the record.
ESTABLISHED_DATE DATE Yes Date when the customer account was originally established.
TERMINATION_DATE DATE Date when the customer account was originally terminated.
STATUS_FLAG VARCHAR2 1 Yes Customer status flag.
PARTY_NAME VARCHAR2 360 The name of the party.
PARTY_FIRST_NAME VARCHAR2 150 First name of the person.
PARTY_MIDDLE_NAME VARCHAR2 60 Middle name of the person.
PARTY_LAST_NAME VARCHAR2 150 Last name of the person.
NAME_SUFFIX VARCHAR2 30 Additional information about the person.
PERSON_TITLE VARCHAR2 60 Professional or family title.
JGZZ_FISCAL_CODE VARCHAR2 20 Taxpayer identification number.
DUNS_NUMBER_C VARCHAR2 30 Duns Number.
ADDRESS1 VARCHAR2 240 First line of the Customer Account address.
ADDRESS2 VARCHAR2 240 Second line of the Customer Account address.
ADDRESS3 VARCHAR2 240 Third line of the Customer Account address.
ADDRESS4 VARCHAR2 240 Fourth line of the Customer Account address.
CITY VARCHAR2 60 City of the Customer Account address.
STATE VARCHAR2 60 State of the Customer Account address.
PROVINCE VARCHAR2 60 Province of the Customer Account address.
COUNTRY VARCHAR2 3 Country of the Customer Account address.
COUNTY VARCHAR2 60 County of the Customer Account address.
POSTAL_CODE VARCHAR2 60 Postal code of the Customer Account address.
POSTAL_PLUS4_CODE VARCHAR2 10 Postal code extension of the Customer Account address.
CONTACT_TYPE_CD VARCHAR2 30 Party's primary contact type.
CONTACT_FIRST_NAME VARCHAR2 150 First name of the contact.
CONTACT_MIDDLE_NAME VARCHAR2 60 Middle name of the contact.
CONTACT_LAST_NAME VARCHAR2 150 Last name of the contact.
CONTACT_NAME_SUFFIX VARCHAR2 30 Additional information about the contact.
CONTACT_PERSON_TITLE VARCHAR2 60 Professional or family title of contact.
CONTACT_COUNTRY VARCHAR2 3 Country of the Contact address.
CONTACT_ADDRESS1 VARCHAR2 240 First line of the Contact address.
CONTACT_ADDRESS2 VARCHAR2 240 Second line of the Contact address.
CONTACT_ADDRESS3 VARCHAR2 240 Third line of the Contact address.
CONTACT_ADDRESS4 VARCHAR2 240 Fourth line of the Contact address.
CONTACT_CITY VARCHAR2 60 City of the Contact address.
CONTACT_STATE VARCHAR2 60 State of the Contact address.
CONTACT_PROVINCE VARCHAR2 60 Province of the Contact address.
CONTACT_COUNTY VARCHAR2 60 County of the Contact address.
CONTACT_POSTAL_CODE VARCHAR2 60 Postal code of the Contact address.
CONTACT_POSTAL_PLUS4_CODE VARCHAR2 10 Postal code extension of the Contact address.
CONTACT_EMAIL_ADDRESS VARCHAR2 150 Email address of the party's primary contact.
CONTACT_PHONE_TYPE VARCHAR2 30 Phone type.
CONTACT_PHONE_COUNTRY_CODE VARCHAR2 10 Country code of the party's primary contact phone.
CONTACT_PHONE_AREA_CODE VARCHAR2 10 Area code of the party's primary contact phone.
CONTACT_PHONE_NUMBER VARCHAR2 40 Phone number of the party's primary contact phone.
CONTACT_PHONE_EXTENSION VARCHAR2 20 Extension of the party's primary contact phone.
CONTACT_RAW_PHONE_NUMBER VARCHAR2 60 Raw phone number.
BILL_TO_FLAG VARCHAR2 1 Yes Indicates if this is a Bill-To address. Y for a Bill-To address and N for a site that is not a Bill-To address.
CUST_ACCT_VERIFICATION_STATUS VARCHAR2 30 Yes Indicates whether a customer account is verified.
CUST_ACCT_CHOICE VARCHAR2 30 Yes Indicates whether user chose to use existing customer account or not.
DUPLICATE_CHECK_OPTION VARCHAR2 30 Yes Find potential matches for customer when agency staff submit new billing information.
DUPLICATE_CHECK_DONE_FLAG VARCHAR2 1 Yes Indicates whether duplicate check has been done for the record.
MATCH_FOUND_FLAG VARCHAR2 1 Yes Indicates whether potential matches were found.
INVOICE_SYSTEM_CD VARCHAR2 30 Invoice System Code.
CUST_PARTY_ID NUMBER 18 Party Identifier of the customer.
CUST_PARTY_NUMBER VARCHAR2 30 Unique alternate identifier for the party.
CUST_PARTY_TYPE_CD VARCHAR2 30 The party type can only be Person, Organization
CUST_ACCOUNT_ID NUMBER 18 Unique identifier for the account created for a Party.
CUST_ACCOUNT_NUMBER VARCHAR2 30 Number assigned to account created for a Party.
CUST_ACCOUNT_NAME VARCHAR2 240 Description chosen by customer (but can be entered internally on behalf on the customer).
LOCATION_ID NUMBER 18 Unique identifier for this location.
PARTY_SITE_ID NUMBER 18 Identifier for Party Site
PARTY_SITE_NAME VARCHAR2 240 User-defined name for the site.
CUST_ACCT_SITE_ID NUMBER 18 Identifier for the customer account site.
CUST_SITE_USE_ID NUMBER 18 Identifier of the site usage.
CONTACT_PARTY_ID NUMBER 18 Party Identifier of the Contact
CONTACT_ID NUMBER 18 Primary Contact Identifier.
SET_NAME VARCHAR2 80 Identifies a set name of reference data shared across business units and other entities.
MIGRATED_DATA_FLAG VARCHAR2 3 Yes Indicates whether the customer account was migrated from an external application or entered by a user.
TRXN_CUST_XREF_PUID VARCHAR2 480 Yes The unique alphanumeric identifier of the billing address association.
PROFILE_CLASS_NAME VARCHAR2 30 Name of profile that stores default values about characteristics of a customer, customer account or site.
SAME_BUS_ENTITY_FLAG VARCHAR2 1 Indicates the billing party is same as the business entity.
SAME_MAIL_ADDRESS_FLAG VARCHAR2 1 Indicates the billing address is same as the business location address.
RECORD_NUMBER VARCHAR2 64 PUID key of Records table
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of 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.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_LNP_CUST_XREF psc_lnp_record LNP_RECORD_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_LNP_CUST_XREF_FK1 Non Unique Default LNP_RECORD_KEY
PSC_LNP_CUST_XREF_N1 Non Unique Default TRXN_CUST_XREF_ID
PSC_LNP_CUST_XREF_PK Unique Default TRXN_CUST_XREF_KEY