Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
AccountBill
Table Definition  Parent Tables  Child Tables
Table DefinitionField | Datatype | Default | Null Option | Comment |
---|---|---|---|---|
AccountSID | INTEGER | ?   | MANDATORY | System generated account sid. |
BillFormCode | CHARACTER(8) |   | MANDATORY | User entered bill form code. |
PracticeID | INTEGER | ?   | OPTIONAL | Practice ID of practice owning account. |
StartDate | DATE |   | OPTIONAL | Start date of statement. |
EndDate | DATE |   | OPTIONAL | End date of statement. |
AccountNumber | CHARACTER(14) |   | MANDATORY | Account number. |
GuarantorLastName | CHAR(35) |   | OPTIONAL | Guarantor's last name. |
GuarantorName | CHAR(200) |   | OPTIONAL | |
GuarLine1 | CHARACTER(20) |   | OPTIONAL | Line 1 of guarantor address. |
GuarLine2 | CHARACTER(20) |   | 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(20) |   | OPTIONAL | Line 1 of practice address. |
PracLine2 | CHARACTER(20) |   | 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(14) |   | OPTIONAL | Practice phone number. |
BalanceForward | DECIMAL(10,2) | 0   | OPTIONAL | |
CurrentBalance | DECIMAL(10,2) | 0   | OPTIONAL | |
GuarantorDue | DECIMAL(10,2) | 0   | OPTIONAL | |
InsuranceDue | DECIMAL(10,2) | 0   | OPTIONAL | |
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. |
ReportSID | INTEGER | ?   | MANDATORY | System generated unique id used by the report driver. |
TotalGuarantorBalance | DECIMAL(10,2) |   | OPTIONAL | Total guarantor balance as of the end-date. |
NewUnpaidCopay | DECIMAL(10,2) |   | OPTIONAL | Unpaid Copay for the current date range. |
TotalUnpaidCopay | DECIMAL(10,2) |   | OPTIONAL | Total Unpaid Copay as of the end date range. |
Parent Table | Join Phrase | When deleting parent record... |
---|---|---|
Account | AccountBill.AccountSID = Account.AccountSID | CASCADE if AccountBill exists |
Child Table | Join Phrase | When deleting AccountBill record... |
---|---|---|
AccountBillItem | AccountBillItem.AccountSID = AccountBill.AccountSID | CASCADE if AccountBillItem exists |