Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
AccountBillItem
Table Definition  Parent Tables  Child Tables
Table DefinitionField | 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 Table | Join Phrase | When deleting parent record... |
---|---|---|
AccountBill | AccountBillItem.AccountSID = AccountBill.AccountSID | CASCADE if AccountBillItem exists |
Child Table | Join Phrase | When deleting AccountBillItem record... |
---|