Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PaymentVoid
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PaymentSID | INTEGER | ? | MANDATORY | FK |
| JournalSID | INTEGER | ? | MANDATORY | FK |
| PostDate | DATE | MANDATORY | FK | |
| Class | CHARACTER(6) | OPTIONAL | User selects payment void class code. Payment void class codes are defined in the LookupCode table for the lookup type 'PayVoidClass'. Codes for lookup type 'PayVoidClass' are user definable and are intended to facilitate voids such as insufficient funds, etc. | |
| 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 Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Payment | PaymentVoid.PaymentSID = Payment.PaymentSID | RESTRICT if PaymentVoid exists |
| Child Table | Join Phrase | When deleting PaymentVoid record... |
|---|---|---|
| PaymentVoidNote | PaymentVoidNote.PaymentSID = PaymentVoid.PaymentSID | CASCADE if PaymentVoidNote exists |