Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
This material is the confidential property of Oracle Corporation or its licensors and may be used, reproduced, stored or transmitted only in accordance with a valid Oracle license or sublicense agreement.

Field Index SQL Mapping

Class /nameinfo

Nameinfo object that holds contact information.

Notes

  • This object can be read by anyone.
  • This object can be modified only by the owner.
  • This object can be created by anyone.

Links



Field Index

Type Field Name
poid PIN_FLD_POID
timestamp PIN_FLD_CREATED_T
timestamp PIN_FLD_MOD_T
string PIN_FLD_READ_ACCESS
string PIN_FLD_WRITE_ACCESS
string PIN_FLD_CREATE_ACCESS
poid PIN_FLD_ACCOUNT_OBJ
string PIN_FLD_ADDRESS
string PIN_FLD_CANON_COMPANY
string PIN_FLD_CANON_COUNTRY
string PIN_FLD_CITY
string PIN_FLD_COMPANY
string PIN_FLD_CONTACT_TYPE
string PIN_FLD_COUNTRY
string PIN_FLD_EMAIL_ADDR
string PIN_FLD_FIRST_CANON
string PIN_FLD_FIRST_NAME
string PIN_FLD_LAST_CANON
string PIN_FLD_LAST_NAME
string PIN_FLD_MIDDLE_CANON
string PIN_FLD_MIDDLE_NAME
string PIN_FLD_GEOCODE
enum PIN_FLD_TAXPKG_TYPE
array PIN_FLD_PHONES
string
enum
string PIN_FLD_SALUTATION
poid PIN_FLD_SERVICE_OBJ
string PIN_FLD_STATE
string PIN_FLD_TITLE
string PIN_FLD_ZIP


Field Details

poid PIN_FLD_POID

Object Identifier for an instance of this class. Portal object ids have four pieces of information: database number, class type, sequence id, revision.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_CREATED_T

Time the object was created.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_MOD_T

Time the object was last modified.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

string PIN_FLD_READ_ACCESS

Read Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_WRITE_ACCESS

Write Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_CREATE_ACCESS

Create Access level for object. Valid values are O(BrandOwner), R(Root), N(Any).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

poid PIN_FLD_ACCOUNT_OBJ

Link to the account object of the contact.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_ADDRESS

Street address of the contact. The street address can have multiple lines. The Multiple lines can be stored with newline separator.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_CANON_COMPANY

Canonical version of Company field. This is System controlled, used to improve matching for searches on Company. The locale specified in PIN_FLD_LOCALE is used for canonicalization.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_CANON_COUNTRY

Canonical version of Country field. This is System controlled, used to improve matching for searches on Country. WorldTax package is used for canonicalization.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_CITY

City portion of the contact's address.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_COMPANY

Company represented by the contact.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_CONTACT_TYPE

Description of type of contact. Current system defined - 'delivery'.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_COUNTRY

Country portion of the contact's address.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 60 bytes

Links

string PIN_FLD_EMAIL_ADDR

Email address for the contact.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 1023 bytes

Links

string PIN_FLD_FIRST_CANON

Canonical version of First Name field. This is System controlled, used to improve matching for searches on name. The locale specified in PIN_FLD_LOCALE is used for canonicalization.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_FIRST_NAME

First name of the contact.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_LAST_CANON

Canonical version of Last Name field. This is System controlled, used to improve matching for searches on name. The locale specified in PIN_FLD_LOCALE is used for canonicalization.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_LAST_NAME

Last name of the contact.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_MIDDLE_CANON

Canonical version of Middle Name field. This is System controlled, used to improve matching for searches on name. The locale specified in PIN_FLD_LOCALE is used for canonicalization.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_MIDDLE_NAME

Middle name of the contact.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_GEOCODE

Tax engine specific GeoCode of the address used for taxation

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

enum PIN_FLD_TAXPKG_TYPE

Indicators of the Tax Engine used in the system. For example, value of 0 indicates custom tax, 1 indicates Taxware Sales, 2 indicates Taxware WorldTax, 3 indicates Vertex Quantum, 4 indicates Vertex CommTax .

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_PHONES

Array of phone numbers for this contact. Each number has a type description, and any number of elements can be stored for a contact. Array element-id's are not significant.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_PHONE

Phone number. By default, format is limited to TAPI and validated using the PCM_OP_CUST_POL_VALID_NAMEINFO policy.

Notes

Links

enum PIN_FLD_TYPE

Phone types defined by Infranet are Home (1), Work (2), Fax (3), Pager (3), Portable (4), POP (5), Support (6).

Notes

Links

string PIN_FLD_SALUTATION

Salutation for the contact name.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 75 bytes

Links

poid PIN_FLD_SERVICE_OBJ

Link to the service object.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_STATE

State or Province portion of the contact's address.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_TITLE

Job title of the contact.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_ZIP

Zip code or postal code portion of the contact's address.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 60 bytes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /nameinfo nameinfo_t
poid PIN_FLD_POID poid*
timestamp PIN_FLD_CREATED_T created_t
timestamp PIN_FLD_MOD_T mod_t
string PIN_FLD_READ_ACCESS read_access
string PIN_FLD_WRITE_ACCESS wrtie_access
string PIN_FLD_CREATE_ACCESS create_access
poid PIN_FLD_ACCOUNT_OBJ account_obj*
string PIN_FLD_ADDRESS address
string PIN_FLD_CANON_COMPANY canon_company
string PIN_FLD_CANON_COUNTRY canon_country
string PIN_FLD_CITY city
string PIN_FLD_COMPANY company
string PIN_FLD_CONTACT_TYPE contact_type
string PIN_FLD_COUNTRY country
string PIN_FLD_EMAIL_ADDR email_addr
string PIN_FLD_FIRST_CANON first_canon
string PIN_FLD_FIRST_NAME first_name
string PIN_FLD_LAST_CANON last_canon
string PIN_FLD_LAST_NAME last_name
string PIN_FLD_MIDDLE_CANON middle_canon
string PIN_FLD_MIDDLE_NAME middle_name
string PIN_FLD_GEOCODE geocode
enum PIN_FLD_TAXPKG_TYPE taxpkg_type
array PIN_FLD_PHONES nameinfo_phones_t
string
PIN_FLD_PHONE
 		phone
enum
PIN_FLD_TYPE
 		type
string PIN_FLD_SALUTATION salutation
poid PIN_FLD_SERVICE_OBJ service_obj*
string PIN_FLD_STATE state
string PIN_FLD_TITLE title
string PIN_FLD_ZIP zip
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.

Field Index This Class