Data Model
You can use the adapter to work with all of the tables in your account. The adapter connects to FinancialForce with SSO and gets the list of tables and the metadata for the tables by calling the appropriate web services. Any changes you make to your FinancialForce with SSO account, such as adding a new table, adding new columns, or changing the data type of a column, are immediately reflected when you connect using the adapter.
Tables
The adapter models the FinancialForce with SSO API as relational Tables. The table definitions are dynamically retrieved; here, we show the sample table definitions that are included in the FinancialForce.com development environment.
In addition to the tables, the adapter also offers stored procedures and views, enabling you to work with other aspects of the FinancialForce with SSO API, like bulk jobs, custom reports, and so on.
Stored Procedures
Stored Procedures are function-like interfaces to FinancialForce with SSO. They can be used to search, update, and modify information in FinancialForce with SSO.
Views
Views offer additional metadata information from FinancialForce with SSO.