LoanStatement Class
Properties Methods Events Configuration Settings Errors
The LoanStatement component is a single component that supports the SignOn and Loan Statement Download functions of Open Financial eXchange, as described by the OFX Specification version 2.1.
Class Name
InEBank_LoanStatement
Procedural Interface
inebank_loanstatement_open(); inebank_loanstatement_close($res); inebank_loanstatement_register_callback($res, $id, $function); inebank_loanstatement_get_last_error($res); inebank_loanstatement_get_last_error_code($res); inebank_loanstatement_set($res, $id, $index, $value); inebank_loanstatement_get($res, $id, $index); inebank_loanstatement_do_config($res, $configurationstring); inebank_loanstatement_do_getclosinginfo($res); inebank_loanstatement_do_getimage($res, $imageref, $imagereftype); inebank_loanstatement_do_getstatement($res); inebank_loanstatement_do_readofxdatafile($res, $filename); inebank_loanstatement_do_reset($res); inebank_loanstatement_do_writeofxdatafile($res, $filename);
Remarks
The LoanStatement class adds loan statement download functionality to your desktop application, or allows your web application to fetch a user's loan statement without having to redirect to another website. All downloads are done using a secure HTTPS Post to send account sign-on information to a financial institution. The class receives the secure response and parses the response into its properties.
To use the LoanStatement class first identify the financial institution by setting the FIId, FIOrganization and FIUrl, properties. Next, identify the OFX user and application by setting the OFXUser, OFXPassword, OFXAppId and OFXAppVersion properties. Next, set the AccountId and AccountType properties to the appropriate values to identify the account for which you wish to download a loan statement. You may also set StartDate and EndDate properties to constrain the transaction list.
Once you have finished setting the properties that describe the statement you wish to download, use the GetStatement method to build and transmit the request automatically. When the response returns, the transaction properties will be populated automatically, as well as the StartDate, EndDate, AvailableBalance, PrincipalBalance, and any other data the loan statement includes.
The transaction properties (TxAmount, TxCheckNumber TxDatePosted, TxFITID, TxMemo, TxPayeeName, and TxType, etc.) may be imagined as arrays, so that the getter function for each property takes as its argument the index of a transaction in the list.
For example, TxAmount(0) gives the amount of the first transaction for the last statement downloaded.
Note: the financial institution usually returns amounts as a string that includes the sign (+/-) of the amount. However, the server may sometimes leave out a particular field if it is not required by the OFX specification. To avoid confusion that can be caused by returning integers, the class will return all amount types as a string, with the empty string ("") for fields not returned by the server.
Where there is a value returned by the server, the class will attempt to convert the string into a format that can be easily parsed into an integer value. This behavior can be controlled by the CurrencyFormat config setting.
Note: Loan Statement Download is supported only in OFX Versions 2.1.0 and 2.1.1. If your FI does not support this OFX version, then you will not be able to use this class.
Property List
The following is the full list of the properties of the class with short descriptions. Click on the links for further details.
AccountId | The account number used for the next statement download. |
AccountType | Indicates the type of the loan account. |
AvailableBalance | Amount of the available balance. |
AvailableBalanceDate | Date of the available balance. |
ClosingDetailCount | The number of records in the ClosingDetail arrays. |
ClosingDetailAggregate | Aggregates are pieces of XML taken from the financial institution's original response. |
ClosingDetailBalanceOpening | Opening statement balance. |
ClosingDetailDateClose | Closing statement date. |
ClosingDetailDateDue | Next payment due date. |
ClosingDetailDateEnd | End date of transaction data for this statement. |
ClosingDetailDateOpen | Opening statement date. |
ClosingDetailDateStart | Start date of transaction data for this statement. |
ClosingDetailFITID | Unique identifier assigned by financial institution to identify this particular statement closing information. |
ClosingDetailImageRef | Server specified unique identifier for the statement closing image. |
ClosingDetailImageRefType | Type of retrieval method for actual statement closing image. |
ClosingDetailMinimumPayment | Next minimum amount due. |
ClosingDetailTotalInterest | Total interest. |
CurrencyCode | Default currency code for this statement. |
EndDate | End date of statement requested. |
FIId | Financial institution identifier. |
FIOrganization | Financial institution organization name. |
FirewallAutoDetect | This property tells the component whether or not to automatically detect and use firewall system settings, if available. |
FirewallType | This property determines the type of firewall to connect through. |
FirewallHost | This property contains the name or IP address of firewall (optional). |
FirewallPassword | This property contains a password if authentication is to be used when connecting through the firewall. |
FirewallPort | This property contains the TCP port for the firewall Host . |
FirewallUser | This property contains a user name if authentication is to be used connecting through a firewall. |
FIUrl | Financial institution URL. |
ImageFileName | Filename and location to save the image content of a transaction or statement. |
IncludeImages | Whether the server has to return data for bank transactions or closing statements images. |
OFXAccessKey | Access key value received after a MFA authentication in a previous signon. |
OFXAppId | OFX application identifier. |
OFXAppVersion | OFX application version. |
OFXPassword | User's password. |
OFXRequest | The current OFX request aggregate. |
OFXResponse | The current OFX response aggregate. |
OFXUser | User's id. |
OFXVersion | OFX API version. |
PrincipalBalance | Amount of the loan principal balance for the current statement. |
PrincipalBalanceDate | Date and time of the current loan principal balance. |
SSLAcceptServerCertEncoded | The certificate (PEM/base64 encoded). |
SSLCertEncoded | The certificate (PEM/base64 encoded). |
SSLCertStore | The name of the certificate store for the client certificate. |
SSLCertStorePassword | If the certificate store is of a type that requires a password, this property is used to specify that password in order to open the certificate store. |
SSLCertStoreType | The type of certificate store for this certificate. |
SSLCertSubject | The subject of the certificate used for client authentication. |
SSLServerCertEncoded | The certificate (PEM/base64 encoded). |
StartDate | Start date of requested transaction list. |
Timeout | A timeout for the component. |
TotalPrincipalLTD | Total principal paid loan to date. |
TotalPrincipalYTD | Total principal paid year to date. |
TxCount | The number of records in the Tx arrays. |
TxAggregate | Wrapper for a bank transaction. |
TxAmount | This is the amount of money exchanged during a given transaction. |
TxCheckNumber | The check number as found on the original check. |
TxDatePosted | This is the date the transaction was posted to the financial institution, stored as a string. |
TxEscrow | This is the total amount of payment applied to Escrow. |
TxFITID | Transaction Id assigned by the financial institution. |
TxImageRef | Server specified unique identifier for the transaction image. |
TxImageRefType | Type of retrieval method for actual transaction image. |
TxInterest | This is the amount of payment applied to Interest. |
TxMemo | The memo property stores a notice from the payee to the customer as a string. |
TxPayeeName | If this property has a value, the NAME element replaces the entire PAYEE aggregate in the request XML. |
TxPrincipal | This is the amount of payment applied to Principal. |
TxType | This is the type of transaction that was made on the account. |
TxTypeDescription | A description of the transaction type. |
Method List
The following is the full list of the methods of the class with short descriptions. Click on the links for further details.
Config | Sets or retrieves a configuration setting . |
GetClosingInfo | Download a statement closing information for a bank account. |
GetImage | Request and retrieve a check or statement image (if available). |
GetStatement | Download a loan statement. |
ReadOFXDataFile | Reads an OFX response from a file. |
Reset | Reset the internal state of the component and all properties to their default values. |
WriteOFXDataFile | Writes the OFX response sent by the server to a file. |
Event List
The following is the full list of the events fired by the class with short descriptions. Click on the links for further details.
ConnectionStatus | Fired to indicate changes in connection state. |
Error | Information about errors during data delivery. |
SSLServerAuthentication | Fired after the server presents its certificate to the client. |
SSLStatus | Shows the progress of the secure connection. |
Configuration Settings
The following is a list of configuration settings for the class with short descriptions. Click on the links for further details.
Overwrite | Determines whether image files will be overwritten. |
MarketingInfo | Marketing information regarding the current loan. |
CurrencyFormat | The format to be used for returning currency values. |
OFXDateFormat | The date format as required by OFX FI server. |
DateFormat | The format to be used for input and output dates. |
GetResponseVar | Parses additional information out of the response. |
NewPassword | New password for the current OFX user. |
OFXLog | Log file for the OFX transaction. |
ServerMessage | Server message if a warning or other information returned. |
ClientUId | Unique ID identifying OFX Client. |
UserCred1A | Additional user credential required by server. |
UserCred2A | Additional user credential required by server. |
AuthToken | Authentication token required for this signon session only. |
CorrectFITID[i] | The FITID of a previously sent transaction corrected by the current one. |
CorrectAction[i] | The action taken to a previously sent transaction corrected by the current one. |
AcceptEncoding | Used to tell the server which types of content encodings the client supports. |
AllowHTTPCompression | This property enables HTTP compression for receiving data. |
AllowIdenticalRedirectURL | Allow redirects to the same URL. |
Append | Whether to append data to LocalFile. |
Authorization | The Authorization string to be sent to the server. |
BytesTransferred | Contains the number of bytes transferred in the response data. |
EncodeURL | If set to true the URL will be encoded by the component. |
FollowRedirects | Determines what happens when the server issues a redirect. |
GetOn302Redirect | If set to true the component will perform a GET on the new location. |
HTTPVersion | The version of HTTP used by the component. |
IfModifiedSince | A date determining the maximum age of the desired document. |
KeepAlive | Determines whether the HTTP connection is closed after completion of the request. |
MaxRedirectAttempts | Limits the number of redirects that are followed in a request. |
OtherHeaders | Other headers as determined by the user (optional). |
ProxyAuthorization | The authorization string to be sent to the proxy server. |
ProxyAuthScheme | The authorization scheme to be used for the proxy. |
ProxyPassword | A password if authentication is to be used for the proxy. |
ProxyPort | Port for the proxy server (default 80). |
ProxyServer | Name or IP address of a proxy server (optional). |
ProxyUser | A user name if authentication is to be used for the proxy. |
TransferredDataLimit | The maximum number of incoming bytes to be stored by the component. |
TransferredHeaders | The full set of headers as received from the server. |
UseChunkedEncoding | Enables or Disables HTTP chunked encoding for transfers. |
ChunkSize | Specifies the chunk size in bytes when using chunked encoding. |
UserAgent | Information about the user agent (browser). |
KerberosSPN | The Service Principal Name for the Kerberos Domain Controller. |
ConnectionTimeout | Sets a separate timeout value for establishing a connection. |
FirewallAutoDetect | Tells the component whether or not to automatically detect and use firewall system settings, if available. |
FirewallHost | Name or IP address of firewall (optional). |
FirewallPassword | Password to be used if authentication is to be used when connecting through the firewall. |
FirewallPort | The TCP port for the FirewallHost;. |
FirewallType | Determines the type of firewall to connect through. |
FirewallUser | A user name if authentication is to be used connecting through a firewall. |
KeepAliveTime | The inactivity time in milliseconds before a TCP keep-alive packet is sent. |
KeepAliveInterval | The retry interval, in milliseconds, to be used when a TCP keep-alive packet is sent and no response is received. |
Linger | When set to True, connections are terminated gracefully. |
LingerTime | Time in seconds to have the connection linger. |
LocalHost | The name of the local host through which connections are initiated or accepted. |
LocalPort | The TCP port in the local host where the component binds. |
MaxLineLength | The maximum amount of data to accumulate when no EOL is found. |
MaxTransferRate | The transfer rate limit in bytes per second. |
RecordLength | The length of received data records. |
TCPKeepAlive | Determines whether or not the keep alive socket option is enabled. |
UseIPv6 | Whether to use IPv6. |
TcpNoDelay | Whether or not to delay when sending packets. |
ReuseSSLSession | Determines if the SSL session is reused. |
SSLCipherStrength | The minimum cipher strength used for bulk encryption. |
SSLEnabledProtocols | Used to enable/disable the supported security protocols. |
SSLProvider | The name of the security provider to use. |
SSLSecurityFlags | Flags that control certificate verification. |
OpenSSLCADir | The path to a directory containing CA certificates. |
OpenSSLCAFile | Name of the file containing the list of CA's trusted by your application. |
OpenSSLCipherList | A string that controls the ciphers to be used by SSL. |
OpenSSLPrngSeedData | The data to seed the pseudo random number generator (PRNG). |
AbsoluteTimeout | Determines whether timeouts are inactivity timeouts or absolute timeouts. |
FirewallData | Used to send extra data to the firewall. |
InBufferSize | The size in bytes of the incoming queue of the socket. |
OutBufferSize | The size in bytes of the outgoing queue of the socket. |
CodePage | The system code page used for Unicode to Multibyte translations. |