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

Intergy Version: 22.00.00.00

ChargeAuxData

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to record the auxillary data required by a charge. This is dependent on the charge posting method.

Field Datatype Default Null Option Comment
ChargeSID INTEGER ?   MANDATORY FK
ADCode CHARACTER(8)   MANDATORY FK
DataValue CHARACTER(20)   OPTIONAL User entered value.
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.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
Charge ChargeAuxData.ChargeSID = Charge.ChargeSID CASCADE if ChargeAuxData exists

Child Tables
Child TableJoin PhraseWhen deleting ChargeAuxData record...