Asset/Liability - SPA

Assets and liabilities held by a client.

Field Label	API Name	Type	Notes
Account Number	cloupra__Account_Number__c	Text (50)	The account number that the provider associates with this holding.
Acquisition Date	cloupra__Acquisition_Date__c	Date	The date the asset or liability was acquired by the client
Address	cloupra__Address__c	Text (255)
Advice	cloupra__Advice__c	Lookup (Cloupra__Advice__C)
Asset/Liability Current Value	cloupra__Asset_Liability_Current_Value__c	Formula (Currency)	IF(AND ( cloupra__Portfolio_Holding_Type_Code__c  = 'PFLOLIABILIT',  cloupra__Current_Value__c > 0) , cloupra__Current_Value__c * -1, cloupra__Current_Value__c)
Asset/Liability Initial Value	cloupra__Asset_Liability_Initial_Value__c	Formula (Currency)	IF(AND ( cloupra__Portfolio_Holding_Type_Code__c = 'PFLOLIABILIT', cloupra__Initial_Value__c > 0) , cloupra__Initial_Value__c * -1, cloupra__Initial_Value__c)
Batch	cloupra__Batch__c	Lookup (Cloupra__Batch__C)
Client	cloupra__Client__c	Lookup (Account)	The client to whom the asset or liability belongs.
Created By ID	CreatedById	Lookup (User)	Required
Created Date	CreatedDate	Datetime	Required
Current Value	cloupra__Current_Value__c	Currency (12, 2)	The current value of an asset, or the current balance of a liability.
Current Value (Thousands)	cloupra__Current_Value_Thousands__c	Formula (Currency)	cloupra__Current_Value__c / 1000
Data Feed	cloupra__Data_Feed__c	Lookup (Cloupra__Data_Feed__C)	The data feed that this record was sourced from.
Data Feed Latest Sync	cloupra__Data_Feed_Latest_Sync__c	Datetime
Data Feed Resource	cloupra__Data_Feed_Resource__c	Textarea (255)
Deleted	IsDeleted	Checkbox	Required
Description	cloupra__Description__c	Text (255)	A short description of the asset or liability.
Documentation	cloupra__Documentation__c	Picklist (Full Doc; Lo Doc; No Doc)
External Id	cloupra__ExternalId__c	Text (100)	Unique, External ID
External Number	cloupra__External_Number__c	Text (255)	Help text: A unique identifier for the asset or liability. Used for matching when uploading commission files or integrating systems. Attribute: Unique, External ID
External Number 2	cloupra__External_Number_2__c	Text (255)	Help text: A unique identifier for the asset or liability. Used for matching when uploading commission files or integrating systems. Populate this field if there are variations on a single number from external sources (e.g. commission files). Attribute: External ID
External Number 3	cloupra__External_Number_3__c	Text (255)	Help text: A unique identifier for the asset or liability. Used for matching when uploading commission files or integrating systems. Populate this field if there are variations on a single number from external sources (e.g. commission files). Attribute: External ID
External Number 4	cloupra__External_Number_4__c	Text (255)	Help text: A unique identifier for the asset or liability. Used for matching when uploading commission files or integrating systems. Populate this field if there are variations on a single number from external sources (e.g. commission files). Attribute: External ID
External Number 5	cloupra__External_Number_5__c	Text (255)	Help text: A unique identifier for the asset or liability. Used for matching when uploading commission files or integrating systems. Populate this field if there are variations on a single number from external sources (e.g. commission files). Attribute: External ID
Fixed Rate Period Expiry	cloupra__Fixed_Rate_Period_Expiry__c	Date
Holding Number	Name	Text (80)	Required
Initial Value	cloupra__Initial_Value__c	Currency (12, 2)	The purchase price of an asset, or the original amount of a liability.
Interest Rate	cloupra__Interest_Rate__c	Percent (16, 2)	The interest rate that applies to this holding.
Interest Type	cloupra__Interest_Type__c	Lookup (Cloupra__Category__C)	The basis upon which interest is calculated for this holding.
Last Activity Date	LastActivityDate	Date
Last Modified By ID	LastModifiedById	Lookup (User)	Required
Last Modified Date	LastModifiedDate	Datetime	Required
Last Referenced Date	LastReferencedDate	Datetime
Last Viewed Date	LastViewedDate	Datetime
Loan Features	cloupra__Loan_Features__c	Multipicklist (Master Limit; Cheque book; Introductory rate; Redraw Facility; Secure rate lock; Offset; Internet banking; Additional payments; Card access)
Loan Period	cloupra__Loan_Period__c	Number (16, 2)	The length of the loan, expressed in units that are separately specified.
Loan Period Units	cloupra__Loan_Period_Units__c	Lookup (Cloupra__Category__C)	The units that apply to the loan period for this liability.
Loan Purpose	cloupra__Loan_Purpose__c	Picklist (Purchase; Refinance; Home Improvements; Construction; Debt Consolidation; Business Use; Other)
Member Account	cloupra__Member_Account__c	Lookup (Cloupra__Service__C)
New/Existing?	cloupra__New_Existing__c	Picklist (Add to Existing; New Split)
Notes	cloupra__Notes__c	Textarea (32768)
Occupancy Type	cloupra__Occupancy_Type__c	Picklist (Owner occupied; Investment)
Offset Amount	cloupra__Offset_Amount__c	Currency (16, 2)
Owner ID	OwnerId	Lookup (Group, User)	Required
Person	cloupra__Person__c	Lookup (Contact)
Policy	cloupra__Policy__c	Lookup (Cloupra__Policy__C)	The insurance policy that covers this asset.
Portfolio Holding Category	cloupra__Portfolio_Holding_Category__c	Lookup (Cloupra__Category__C)
Portfolio Holding Stage	cloupra__Portfolio_Holding_Stage__c	Lookup (Cloupra__Category__C)
Portfolio Holding Type	cloupra__Portfolio_Holding_Type__c	Lookup (Cloupra__Category__C)
Portfolio Holding Type Code	cloupra__Portfolio_Holding_Type_Code__c	Formula (Text)	cloupra__Portfolio_Holding_Type__r. cloupra__Code__c
Portfolio Holding Value	cloupra__Portfolio_Holding_Value__c	Formula (Currency)	IF(cloupra__Member_Account__c <> null, cloupra__Member_Account__r. cloupra__Account_Balance__c, cloupra__Asset_Liability_Current_Value__c)
Primary Division	cloupra__Primary_Division__c	Lookup (Account)
Property Type	cloupra__Property_Type__c	Picklist (House/Villa; Unit; Townhouse; Vacant land; Other)
Provider	cloupra__Provider__c	Lookup (Account)	The provider related to this holding.
Recommendation	cloupra__Recommendation__c	Lookup (Cloupra__ Recommendation__C)	The recommendation supporting the implementation of this asset or liability.
Record ID	Id	Id (18)	Required
Related Client	cloupra__Related_Client__c	Formula (Text)	Help text: Returns the related client Id, either through the related recommendation and then service (if there is one), or direct. Used in system logic. Formula: IF(NOT(ISBLANK( cloupra__Service__c)),    CASESAFEID(cloupra__Service__r. cloupra__Client__c),    CASESAFEID(cloupra__Client__c) )
Related Client Name	cloupra__Related_Client_Name__c	Formula (Text)	Help text: Returns the related client name, either through the related recommendation and then service (if there is one), or direct. Used in system logic. Formula: IF(NOT(ISBLANK( cloupra__Service__c)),    (cloupra__Service__r. cloupra__Client__r.Name),    (cloupra__Client__r.Name) )
Related To	cloupra__Related_To__c	Lookup (Cloupra__Portfolio _Holding__C)	The asset that relates to this liability.
Repayment Frequency	cloupra__Repayment_Frequency__c	Picklist (Weekly; Fortnightly; Monthly; Yearly)
Repayment Type	cloupra__Repayment_Type__c	Lookup (Cloupra__Category__C)	Interest only repayments, or principle and interest.
Service	cloupra__Service__c	Lookup (Cloupra__Service__C)
Source	cloupra__Source__c	Text (255)
Stage	cloupra__Stage__c	Lookup (Cloupra__Category__C)
System Modstamp	SystemModstamp	Datetime	Required
Under Advice	cloupra__Under_Advice__c	Checkbox	Help text: Is the asset or liability under advice from our practice? Attribute: Required
Units	cloupra__Units__c	Number (10, 0)
Updated by Tamarac Integration	cloupra__Updated_by_Tamarac_Integration__c	Checkbox	Required
Valuation Date	cloupra__Valuation_Date__c	Date	The date on which the current balance or value was updated.