Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
AccountStatement
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| AccountSID | INTEGER | ? | MANDATORY | System generated unique id using the Account sequence. |
| StmntNumber | INTEGER | 0 | MANDATORY | System generated id to tie the records for a single report together. |
| Trial | CHARACTER(1) | MANDATORY | Flag to indicate if the run was a trial run. Possible values are Y or N. | |
| PracticeID | INTEGER | ? | MANDATORY | Practice ID that owns the account. |
| BatchCode | CHARACTER(6) | MANDATORY | User defined batch code. | |
| RunNumber | INTEGER | 0 | MANDATORY | Next sequential run number for the batch. |
| StatementFormCode | CHARACTER(8) | MANDATORY | User entered statement form code. | |
| AccountNumber | CHARACTER(14) | MANDATORY | Account number. | |
| GuarantorLastName | CHARACTER(50) | OPTIONAL | Stores the sortname from the entity table. | |
| GuarantorName | CHAR(200) | OPTIONAL | Guarantor's full name. | |
| GuarLine1 | CHARACTER(40) | OPTIONAL | Line 1 of guarantor address. | |
| GuarLine2 | CHARACTER(40) | OPTIONAL | Line 2 of guarantor address. | |
| GuarCity | CHARACTER(20) | OPTIONAL | City of guarantor address. | |
| GuarState | CHARACTER(2) | OPTIONAL | State of guarantor address. | |
| GuarZip | CHARACTER(10) | OPTIONAL | Zip code of guarantor address. | |
| PracticeName | CHARACTER(50) | OPTIONAL | Practice name. | |
| PracLine1 | CHARACTER(40) | OPTIONAL | Line 1 of practice address. | |
| PracLine2 | CHARACTER(40) | OPTIONAL | Line 2 of practice address. | |
| PracCity | CHARACTER(20) | OPTIONAL | City of practice address. | |
| PracState | CHARACTER(2) | OPTIONAL | State of practice address. | |
| PracZip | CHARACTER(10) | OPTIONAL | Zip code of practice address. | |
| PracPhone | CHARACTER(20) | OPTIONAL | Practice phone number. | |
| BalanceForward | DECIMAL(10,2) | 0 | OPTIONAL | Account balance brought forward from previous statement. |
| CurrentBalance | DECIMAL(10,2) | 0 | OPTIONAL | Account current balance. |
| GuarantorDue | DECIMAL(10,2) | 0 | OPTIONAL | Guarantor portion due of account balance. |
| InsuranceDue | DECIMAL(10,2) | 0 | OPTIONAL | Insurance portion due of account balance. |
| TwoMonthBalance | DECIMAL(10,2) | 0 | OPTIONAL | Account balance aged 2 months. |
| ThreeMonthBalance | DECIMAL(10,2) | 0 | OPTIONAL | Account balance aged 3 months. |
| FourMonthBalance | DECIMAL(10,2) | 0 | OPTIONAL | Account balance aged 4 months. |
| FiveMonthBalance | DECIMAL(10,2) | 0 | OPTIONAL | Account balance aged 5 months. |
| StartDate | DATE | OPTIONAL | Start date of statement. | |
| EndDate | DATE | OPTIONAL | End date of statement. | |
| ReportSID | INTEGER | ? | MANDATORY | Unique report run identifier. |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| AgingNote | CHARACTER(300) | OPTIONAL | Aging note. | |
| Comment | CHARACTER(60) | OPTIONAL | Store comments associated with the account statement. | |
| TotalCharges | DECIMAL(10,2) | 0 | OPTIONAL | Total of all charges on a statement. |
| TotalAdjustments | DECIMAL(10,2) | 0 | OPTIONAL | Total of all adjustments on a statement. |
| TotalReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Total of all receipts on a statement. |
| TotalUC | DECIMAL(10,2) | 0 | OPTIONAL | Total of all unapplied credit on a statement. |
| PrimaryInsuranceID | INTEGER | ? | OPTIONAL | |
| SecondaryInsuranceID | INTEGER | ? | OPTIONAL | |
| Suppressed | CHARACTER(1) | OPTIONAL | This flag is used to indicate whether or not the statement is to be printed and or transmitted. Possible values are (Y)es - statement was suppressed and is not to be sent or (N)o or null. | |
| GuarantorFirstName | CHAR(35) | OPTIONAL | Guarantor first name. | |
| GuarantorMiddleName | CHAR(35) | OPTIONAL | Guarantor middle name. | |
| GuarantorSortName | CHAR(200) | OPTIONAL | System formatted guarantor name. | |
| LastPaymentDate | DATE | OPTIONAL | Date of last payment. | |
| SortField | CHARACTER(30) | OPTIONAL | System set to selected statement sort. Example: Provider Name, Zip Code, etc. | |
| LastPaymentAmount | DECIMAL(10,2) | 0 | OPTIONAL | Amount of last payment. |
| DNSortAccountNumber | CHARACTER(10) | OPTIONAL | This is a denormalized field maintained by write triggers whose source is the account number field. It is used for ease of sorting. | |
| RemitToLine1 | CHARACTER(40) | OPTIONAL | Line 1 of remit to address. | |
| RemitToLine2 | CHARACTER(40) | OPTIONAL | Line 2 of remit to address. | |
| RemitToCity | CHARACTER(20) | OPTIONAL | City of remit to address. | |
| RemitToState | CHARACTER(2) | OPTIONAL | Two letter code of the state of remit to address. | |
| RemitToZip | CHARACTER(10) | OPTIONAL | Zip code of remit to address. | |
| PracPhoneExt | CHARACTER(6) | OPTIONAL | Extension to the practice phone number. User entered. | |
| GuarPhone | CHAR(20) | OPTIONAL | Guarantor Phone # | |
| GuarPhoneExt | CHAR(8) | OPTIONAL | Guarantor Phone Extension |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Account | AccountStatement.AccountSID = Account.AccountSID | CASCADE if AccountStatement exists |
| Child Table | Join Phrase | When deleting AccountStatement record... |
|---|---|---|
| AccountStatementItem | AccountStatementItem.AccountSID = AccountStatement.AccountSID and AccountStatementItem.StmntNumber = AccountStatement.StmntNumber |
CASCADE if AccountStatementItem exists |