table 50126 "CDS cr95d_Prospects"
{
ExternalName = 'cr95d_prospects';
TableType = CDS;
Description = '';
fields
{
field(1;cr95d_ProspectsId;GUID)
{
ExternalName = 'cr95d_prospectsid';
ExternalType = 'Uniqueidentifier';
ExternalAccess = Insert;
Description = 'Unique identifier for entity instances';
Caption = 'Prospects';
}
field(2;CreatedOn;Datetime)
{
ExternalName = 'createdon';
ExternalType = 'DateTime';
ExternalAccess = Read;
Description = 'Date and time when the record was created.';
Caption = 'Created On';
}
field(4;ModifiedOn;Datetime)
{
ExternalName = 'modifiedon';
ExternalType = 'DateTime';
ExternalAccess = Read;
Description = 'Date and time when the record was modified.';
Caption = 'Modified On';
}
field(24;statecode;Option)
{
ExternalName = 'statecode';
ExternalType = 'State';
ExternalAccess = Modify;
Description = 'Status of the Prospects';
Caption = 'Status';
InitValue = " ";
OptionMembers = " ", Active, Inactive;
OptionOrdinalValues = -1, 0, 1;
}
field(26;statuscode;Option)
{
ExternalName = 'statuscode';
ExternalType = 'Status';
Description = 'Reason for the status of the Prospects';
Caption = 'Status Reason';
InitValue = " ";
OptionMembers = " ", Active, Inactive;
OptionOrdinalValues = -1, 1, 2;
}
field(28;VersionNumber;BigInteger)
{
ExternalName = 'versionnumber';
ExternalType = 'BigInt';
ExternalAccess = Read;
Description = 'Version Number';
Caption = 'Version Number';
}
field(29;ImportSequenceNumber;Integer)
{
ExternalName = 'importsequencenumber';
ExternalType = 'Integer';
ExternalAccess = Insert;
Description = 'Sequence number of the import that created this record.';
Caption = 'Import Sequence Number';
}
field(30;OverriddenCreatedOn;Date)
{
ExternalName = 'overriddencreatedon';
ExternalType = 'DateTime';
ExternalAccess = Insert;
Description = 'Date and time that the record was migrated.';
Caption = 'Record Created On';
}
field(31;TimeZoneRuleVersionNumber;Integer)
{
ExternalName = 'timezoneruleversionnumber';
ExternalType = 'Integer';
Description = 'For internal use only.';
Caption = 'Time Zone Rule Version Number';
}
field(32;UTCConversionTimeZoneCode;Integer)
{
ExternalName = 'utcconversiontimezonecode';
ExternalType = 'Integer';
Description = 'Time zone code that was in use when the record was created.';
Caption = 'UTC Conversion Time Zone Code';
}
field(33;cr95d_ProspectName;Text[100])
{
ExternalName = 'cr95d_prospectname';
ExternalType = 'String';
Description = 'Required name field';
Caption = 'Prospect Name';
}
field(34;cr95d_ContractAmount;Decimal)
{
ExternalName = 'cr95d_contractamount';
ExternalType = 'Money';
Description = '';
Caption = 'Contract Amount';
}
field(37;ExchangeRate;Decimal)
{
ExternalName = 'exchangerate';
ExternalType = 'Decimal';
ExternalAccess = Read;
Description = 'Exchange rate for the currency associated with the entity with respect to the base currency.';
Caption = 'Exchange Rate';
}
field(38;cr95d_contractamount_Base;Decimal)
{
ExternalName = 'cr95d_contractamount_base';
ExternalType = 'Money';
ExternalAccess = Read;
Description = 'Value of the Contract Amount in base currency.';
Caption = 'Contract Amount (Base)';
}
field(39;cr95d_Probability;Integer)
{
ExternalName = 'cr95d_probability';
ExternalType = 'Integer';
Description = '';
Caption = 'Probability';
}
field(40;cr95d_Stage;Option)
{
ExternalName = 'cr95d_stage';
ExternalType = 'Picklist';
Description = '';
Caption = 'Stage';
InitValue = Lead;
OptionMembers = Lead, Opportunity, Won, Lost;
OptionOrdinalValues = 256080000, 256080001, 256080002, 256080003;
}
field(42;cr95d_ForcastedRevenue;Decimal)
{
ExternalName = 'cr95d_forcastedrevenue';
ExternalType = 'Money';
Description = '';
Caption = 'Forcasted Revenue';
}
field(43;cr95d_forcastedrevenue_Base;Decimal)
{
ExternalName = 'cr95d_forcastedrevenue_base';
ExternalType = 'Money';
ExternalAccess = Read;
Description = 'Value of the Forcasted Revenue in base currency.';
Caption = 'Forcasted Revenue (Base)';
}
}
keys
{
key(PK;cr95d_ProspectsId)
{
Clustered = true;
}
key(Name;cr95d_ProspectName)
{
}
}
fieldgroups
{
fieldgroup(DropDown;cr95d_ProspectName)
{
}
}
}
You must be logged in to post a comment.