Hello all,

We're working on OOTB(Out of the box) data type (Account) over our development. When ever we try to save a new record manually we were able to save the data, but were unable to save a new records to the OOTB Account data type. Can anyone suggest us a process/ document to save automatically new records to the OOTB data Type.

Kind regards, Harshit Kumar 

(Error:

Batch entry 0 INSERT INTO dataschema.pa_account ("accountnumber" , "accountbalance" , "accountclosedate" , "accountopendate" , "accountpackage" , "accounttype" , "active" , "addedby" , "addressfromdate" , "addresslastchangedate" , "addressline1" , "addressline2" , "addressline3" , "addressline4" , "addressline5" , "addresstodate" , "addressupdatecounter" , "applicationtype" , "availablebalance" , "averagemonthlybalance" , "businessphone" , "businessunitid" , "cellphone" , "city" , "contactid" , "contactintell" , "countrycode" , "customervalue" , "dateadded" , "datedeleted" , "dateupdated" , "deletedby" , "email" , "fax" , "firstlook" , "firstname" , "fullname" , "homephone" , "lastname" , "lastpaymentamount" , "lastpaymentdate" , "laststatementdate" , "middlename" , "minimumdue" , "nextduedate" , "nextstatementdate" , "phonenumber" , "productid" , "profile" , "province" , "region" , "roledescription" , "securityanswer" , "securityquestion" , "specialinstructions" , "state" , "statecode" , "statementcutdate" , "updatedby" , "ytdpayments" , "zipcode" , "contactinfo" , "mobilephone") VALUES ('SL123456789'::varchar , NULL::numeric , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::numeric , NULL::varchar , NULL::numeric , NULL::numeric , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::numeric , NULL::varchar , NULL::varchar , NULL::varchar , NULL::numeric , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::varchar , NULL::numeric , NULL::varchar , NULL::varchar , NULL::varchar) ON CONFLICT ("accountnumber") DO UPDATE SET "accountnumber" = excluded."accountnumber" , "accountbalance" = excluded."accountbalance" , "accountclosedate" = excluded."accountclosedate" , "accountopendate" = excluded."accountopendate" , "accountpackage" = excluded."accountpackage" , "accounttype" = excluded."accounttype" , "active" = excluded."active" , "addedby" = excluded."addedby" , "addressfromdate" = excluded."addressfromdate" , "addresslastchangedate" = excluded."addresslastchangedate" , "addressline1" = excluded."addressline1" , "addressline2" = excluded."addressline2" , "addressline3" = excluded."addressline3" , "addressline4" = excluded."addressline4" , "addressline5" = excluded."addressline5" , "addresstodate" = excluded."addresstodate" , "addressupdatecounter" = excluded."addressupdatecounter" , "applicationtype" = excluded."applicationtype" , "availablebalance" = excluded."availablebalance" , "averagemonthlybalance" = excluded."averagemonthlybalance" , "businessphone" = excluded."businessphone" , "businessunitid" = excluded."businessunitid" , "cellphone" = excluded."cellphone" , "city" = excluded."city" , "contactid" = excluded."contactid" , "contactintell" = excluded."contactintell" , "countrycode" = excluded."countrycode" , "customervalue" = excluded."customervalue" , "dateadded" = excluded."dateadded" , "datedeleted" = excluded."datedeleted" , "dateupdated" = excluded."dateupdated" , "deletedby" = excluded."deletedby" , "email" = excluded."email" , "fax" = excluded."fax" , "firstlook" = excluded."firstlook" , "firstname" = excluded."firstname" , "fullname" = excluded."fullname" , "homephone" = excluded."homephone" , "lastname" = excluded."lastname" , "lastpaymentamount" = excluded."lastpaymentamount" , "lastpaymentdate" = excluded."lastpaymentdate" , "laststatementdate" = excluded."laststatementdate" , "middlename" = excluded."middlename" , "minimumdue" = excluded."minimumdue" , "nextduedate" = excluded."nextduedate" , "nextstatementdate" = excluded."nextstatementdate" , "phonenumber" = excluded."phonenumber" , "productid" = excluded."productid" , "profile" = excluded."profile" , "province" = excluded."province" , "region" = excluded."region" , "roledescription" = excluded."roledescription" , "securityanswer" = excluded."securityanswer" , "securityquestion" = excluded."securityquestion" , "specialinstructions" = excluded."specialinstructions" , "state" = excluded."state" , "statecode" = excluded."statecode" , "statementcutdate" = excluded."statementcutdate" , "updatedby" = excluded."updatedby" , "ytdpayments" = excluded."ytdpayments" , "zipcode" = excluded."zipcode" , "contactinfo" = excluded."contactinfo" , "mobilephone" = excluded."mobilephone" was aborted: ERROR: null value in column "accountopendate" violates not-null constraint

)