24.Bank Statement 

Interface

It allows you:

• to view Bank Statement (master&details)

• to insert new Bank Statement (master&details)

• to update Bank Statement (master&details) - only for Document in Draft

• to delete Bank Statement (master&details) - only for Document in Draft

• to process Bank Statement (master)

Prerequisites:

In order to use this API Method for inserting or updating data there must be accomplished the following requirements in SocrateCloud:

• to have an active Organization

• to have an Account at the Bank

Actions that can be done:

• list (master&details)

• full list (master)

• create (master&details)

• full create (master)

• update (master&details) - only for Document in Draft

• delete (master&details) - only for Document in Draft

• process (master)

Bank Statement fields (Master&Details)

In SocrateCloud, a Bank Statement has the following structure:

• Master document (see Bank Statement Master) which contains data about the header document:

  • Organization ID

  • Organization Value

  • Organization Name

  • Created

  • Created By

  • Updated

  • Updated By

  • Bank Account ID

  • IBAN

  • Account No

  • Bank Name

  • Statement Date

  • Bank Statement ID

  • Bank Statement Name

  • Bank Statement Description

  • Is Manual

  • Beginning Balance

  • Statement Difference

  • Ending Balance

  • Doc Status

• Document details (see Bank Statement Details):

  • Organization ID

  • Organization Value

  • Organization Name

  • Created

  • CreatedBy ID

  • CreatedBy

  • Updated

  • UpdatedBy ID

  • UpdatedBy

  • Line

  • Description

  • Statement Line Date

  • DateAcct

  • ValutaDate

  • StmtAmt

  • TrxAmt

  • InterestAmt

  • BPartner ID

  • BPartner Value

  • BPartner Name

  • Currency ID

  • ConversionType ID

  • ConversionType Value

  • ConversionType Name

  • Invoice ID

  • Invoice Number

  • Order ID

  • Order Number

  • Payment ID

  • Payment Number

  • ChargeAmt

  • Charge ID

  • Charge Name

  • SAFT_TaxType ID

  • SAFT_TaxType Value

  • SAFT_TaxType Name

  • SAFT_Tax ID

  • SAFT_Tax Value

  • SAFT_Tax Name

  • SAFT_TaxPercentage

  • SAFT_TaxBaseAmt

  • TrxOrganization ID

  • TrxOrganization Value

  • TrxOrganization Name

  • Project ID

  • Project Value

  • Project Name

  • Project Phase ID

  • Project Phase Name

  • Activity ID

  • Activity Value

  • Activity Name

  • Campaign ID

  • Campaign Value

  • Campaign Name

  • Asset ID

  • Asset Value

  • Asset Name