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

Intergy Version: 22.00.00.00

AccountBillItem

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is for reporting the items of a bill.

Field Datatype Default Null Option Comment
AccountSID INTEGER ?   MANDATORY System generated account sid.
ActivityType INTEGER 0   MANDATORY Type of activity. 1 - Charge , 2 - Charge Void, 3 - Copay , 4 - Adjustment , 5 - RISStudy , 8 - Payment Assignment , 12 - Payment Reversal , 14 - Transfer , 16 - UC Assignment , 20 - UC Reversal , 24 - Rolled Up Account , 26 - Payment Void , 28 - Refund , 32 - Account Transfer In , 36 - Account Transfer Out , 40 - Admin Charge , 44 - Interest Charge , 48 - Separator (Used only for Statement/Receipt formatting purposes) , 50 - Payment Header, 52 - Appointment , 54 - Appointment Location Data and 60 - Finance Charge To Be Rolled Up
ActivitySID INTEGER ?   MANDATORY SID of the activity of the current item. The activity SID can be ChargeSID, PaymentSID, AdjustmentSID, UnappliedCreditSID or RefundSID.
ActivityCount INTEGER 0   MANDATORY This field is the number of the activity that has occurred against this statement item.
PatientID INTEGER ?   OPTIONAL FK
StaffCode CHARACTER(6)   OPTIONAL Staff code.
Amount DECIMAL(10,2) 0   OPTIONAL Amount of the charge.
ActivityDescription CHARACTER(60)   OPTIONAL Description of adjustment.
PostDate DATE   OPTIONAL Post date of charge
ChargeType CHARACTER(1)   MANDATORY Charge type indicates if the charge was a procedure charge or admin charge. Possible values are (P)rocedure or (A)dmin.
AdminChargeCode CHARACTER(10)   OPTIONAL Administration charge code.
CurrentStatus CHARACTER(8)   OPTIONAL Current status of charge. User selects charge status.
DiagnosisCode CHARACTER(10)   OPTIONAL Diagnosis codes for this charge (array of 4).
DiagnosisDescription CHARACTER(60)   OPTIONAL Diagnosis descriptions (array of 4).
ProcedureCode CHARACTER(10)   OPTIONAL Procedure code for the charge.
ProcedureDescription CHARACTER(60)   OPTIONAL Description of the procedure for the charge.
TOSCode CHARACTER(3)   OPTIONAL Type of service for the charge.
TOSDescription CHARACTER(60)   OPTIONAL Type of service description.
POSCode CHARACTER(3)   OPTIONAL Place of service for the charge.
POSDescription CHARACTER(60)   OPTIONAL Place of service description.
PatientName CHAR(200)   OPTIONAL Patient's name.
ApptDate DATE   OPTIONAL Date of next appointment.
ApptTime CHARACTER(5)   OPTIONAL Time of next appointment.
ApptReason CHARACTER(60)   OPTIONAL Reason for next appointment.
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.
SubType INTEGER 0   OPTIONAL This field is used to define a sort order.
ApptProviderName CHAR(50)   OPTIONAL Appointment Provider's Name first, last, suffix
ApptLocationName CHARACTER(60)   OPTIONAL Appt Location sort name
ApptLocationLine1 CHAR(20)   OPTIONAL Appt Location address line 1
ApptLocationLine2 CHAR(20)   OPTIONAL Appt Location address line 2
ApptLocationCity CHAR(20)   OPTIONAL Appt Location City
ApptLocationState CHAR(2)   OPTIONAL Appt Location State
ApptLocationZip CHAR(10)   OPTIONAL Appt Location Zip
ApptLocationPhone CHARACTER(14)   OPTIONAL Appt Location Phone
ApptEquipmentDescription CHARACTER(60)   OPTIONAL Appt Equipment's description
ApptRoomDescription CHARACTER(60)   OPTIONAL Appt Room's description

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

Child Tables
Child TableJoin PhraseWhen deleting AccountBillItem record...