Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
AccountBillItem
Table Definition Parent Tables Child Tables
Table Definition| 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 Table | Join Phrase | When deleting parent record... |
|---|---|---|
| AccountBill | AccountBillItem.AccountSID = AccountBill.AccountSID | CASCADE if AccountBillItem exists |
| Child Table | Join Phrase | When deleting AccountBillItem record... |
|---|