Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

AccountBill

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table records the information for bills for the purpose of reporting.

Field 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 Tables
Parent TableJoin PhraseWhen deleting parent record...
Account AccountBill.AccountSID = Account.AccountSID CASCADE if AccountBill exists

Child Tables
Child TableJoin PhraseWhen deleting AccountBill record...
AccountBillItem AccountBillItem.AccountSID = AccountBill.AccountSID CASCADE if AccountBillItem exists