Appendix

Object fields

The following tables list only most important fields of most often used objects. For a full list please refer to the Vine Developer's Guide .

Company vy_company

Field Name

Description

NAME

Object's name used internally

Realname

Official name of the company

Location

Extension to the name.

Phone

Telephone number

Fax

Fax number

Email

Email address

WWWpage

Company's Web site

Address

Mailing address

Zip

Postal code

City

City name

State

State

StreetAddress

Street address if the mailing address is a P.O. box

Country

Country name. parameter field: values in VP_COUNTRY

Description

Description of the object.

Streetcity

 

StreetZIP

 

BUSINESSID

 

CUSTOMERID

 

DATASERVICEID

stores key to external system maintaining the object. Currently used to store the Address Service Ids. For objects loaded or mapped to address service, it's always the key of object in the Address Service system

COMPANYTYPE

parameter field with values stored in the VP_COMPANYTYPE parameter table.

OFFICETYPE

VY_OFFICETYPE

EDI

 

LEADSCORE

 

TURNOVER

 

PROFIT

 

PERSONNEL

 

SALESTHISYEAR

 

SALESLASTYEAR

 

INDUSTRYGROUP

 

INDUSTRYCODE

VP_INDUSTRYGROUP

COMPANYFORM

VP_COMPANYFORM

Person vy_person

Field Name

Description

LastName

Last name

FirstName

First name

Title

Title, e.g. job description

Department

Department, unit in the company/location

Phone

Telephone number of the person

Phone2

Additional phone, e.g. mobile

Fax

Fax number

Email

E-mail address

HomePHONE

Home phone

HomeAddress

Home address

HomeZip

Postal code

HomeCity

City name

HomeState

State

HomeCountry

Country name

Description

Description of the object.

SKYPE

 

ISUSER

 

DECISIONMAKER

VS_PERSONTYPE

COUNTRYNAME

VP_COUNTRY

LEADSCORE

 

LASTMARKETINGOPERATIONTYPE

VP_MARKETINGOP_TYPE

LASTMARKETINGOPERATIONDATE

 

WEBPAGE

 

DATASERVICEID

stores key to external system maintaining the object. Currently used to store the Address Service Ids. For objects loaded or mapped to address service, it's always the key of object in the Address Service system

MAINREPOSPONSIBLITY

VP_MAIN_RESP_TYPE

Event vy_event

Field Name

Description

NAME

Name of the event

StartDate

Event start date or date with time

StartDateGMT

GMT time

EndDate

Event end date or date with time

EndDateGMT

GMT time

EventPhase

Phase of the event: 1 = 'not done', 2 = 'done'

EventType

ID of the event's type: see VY_EVENTTYPE

RemindTime

How many seconds before the event the reminder message is given (0 if no reminder)

RemindType

Remind type popup (0= dialog, 1=gsm)

Description

Description of the object.

Location

To store information about where the event happens

Reported VY_EVENT_REPORTED

Project vy_project

Field Name

Description

NAME

Name of the project

ProjectPhase

ID of the project's phase: see VY_PROJECTPHASE

ProjectType

ID of the project's type: see VY_PROJECTTYPE

StartDate

Project start date (or date with time)

EndDate

Project end date (or date with time)

ProjectSum

Project total (currency and actual meaning are up to customers)

Budget

Budget of the project (currency and actual meaning are up to customers)

Amount

Currency and actual meaning are up to customers

ProjectLength

Duration of the project (units and actual meaning are up to customer)

Description

Description of the object.

Folder vy_collection

Field Name

Description

NAME

Name of the folder

ContentsType

ID of the type of a connection which sets the type of folder members, see VY_CONNECTIONTYPE.ID

Description

Description of the object

Resource vy_resource

Field Name

Description

NAME

Name of the resource

ResourceType

ID of the resource's type, see VY_RESOURCETYPE.ID

Description

Description of the object.

Document vy_document

Field Name

Description

NAME

Name of the document

DOCUMENTTYPE

Type parameter field. VY_DOCUMENTTYPE

DOCUMENTPHASE

Phase parameter field. VY_DOCUMENTPHASE

Description

Description of the object.

DOCUMENTDATE  

Sales Case vy_salescase

Field Name

Description

NAME

Object Name

salesunit

VY_SALESUNIT

salesphase

VY_SALESPHASE

startdate

 

enddate

 

offerdate

 

salestype

VY_SALESTYPE

sales

 

Sales2

 

Sales3

 

salesarea

VY_SALES_AREA

subject

 

decisionphase

VY_SALES_DECIS_PHASE

Financestatus

VY_SALES_FINA_STATUS

Internalcompetition

VY_SALESINTERNCOMPET

Totalprobability

 

salesprobability

VY_SALESPROBABILITY

Description

Description of the object.

Account vs_salesaccount

Field Name

Description

NAME

Object Name

salesarea

VY_SALES_AREA

Businessunit

VY_SALESUNIT

Wellbeing

VS_SALESACC_BEING

accountphase

 

Details

 

Comments

 

Target

 

Challenges

 

Plan

 

Description

Description of the object.

Service Request vs_servicerequest

Field Name

Description

NAME

Object Name

Caseid

 

component

 

startdate

 

enddate

 

note

 

OtherInfo

 

ServReqPhase

VS_SERVREQ_PHASE

PlatformType

VS_PLATFORMTYPE

PlatFormVersion

 

PriorityType

VS_PRIORITYTYPE

ProductType

VS_HDPRODUCTTYPE

ProductVersion

 

Published

VS_SERVREQ_PUBLISHED

Repeating

VS_SERVREQ_REPEATING

ResponsibleType

VS_RESPONSIBLETYPE

Severity

VS_SERVREQ_SEVERITY

Solution

 

SolutionType

VS_SOLUTIONTYPE

ServReqType

VS_SERVREQ_TYPE

Version

 

Description

Description of the object.

Questionnaire vs_questionnaire

Field Name

Description

NAME  
ENDDATE  
PHASE VS_QUESTION_PHASE
DESCRIPTION  
STARTDATE  
COMMON  
DEFAULTQUESTIONNAIRE VS_QUESTIONN_DEFAULT
EVENTTYPE VY_EVENTTYPE

Web Link

Field Name

Description

NAME

URL, e.g. https://vine.eu

Description

Description of the object.

Object Parameters

Vine objects can have parameter fields, i.e. fields whose values can be chosen only from a fixed set of choices. This set of choices is stored in a separate parameter table whose name is given in the Description column for parameter object fields.

For example, this means that the EVENTTYPE field of Events references the VY_EVENTTYPE parameter table.

EVENTTYPE VY_EVENTTYPE

 

You will most likely only use the NAME field which stores the parameter value.

For example, to refer to event's type you can use the following substitution: [[EVENTNAME.EVENTTYPE]]