Skip to main content

Knowledge Center

Load Opportunities (OPT) - INP/73561

Possible fields to be loaded into RamBase are listed in the Field column in the following table. The other columns in this table provide additional information about each field.

Field

Required

Length

Example

Description

OWNER

Y

1000

PID reference to the owner of the opportunity

TITLE

Y

The title of the opportunity

ASSIGNEE

1010

PID reference to the person this opportunity is assigned to.

CNTEXTID

Contact id in the external system.

CNTNO

100000

Contact id in RamBase.

CONTRACTLENGTH

Number of months with recurring value

CUSEXTID

Customer id in the external system.

CUSNO

100000

Customer id in RamBase.

EXPECTEDCLOSEDATE

20210531

The date when you expect the deal to be closed (YYYYMMDD).

ONETIMEREVENUE

The value of startup/creation of the opportunity.

OPSNAME

Case sensitive - The stage this opportunity is currently in. Reference to OPS archive Name.

OPSNO

The stage this opportunity is currently in. Reference to OPS archive NO.

PROBABILITY

10

The probability of winning this opportunity in percentage.

RECURRINGREVENUE

12000

Monthly recurring value of the opportunity.

SOURCE

The source of this Opportunity/lead. Must be given as the numerical value for option (not as text).

VALUE

120000

The value of this opportunity.