Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Payment
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PaymentSID | INTEGER | ? | MANDATORY | Possible values are (I)nsurance, (G)uarantor |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| JournalSID | INTEGER | ? | MANDATORY | FK |
| PostDate | DATE | MANDATORY | FK | |
| Source | CHARACTER(1) | MANDATORY | User set source of payment. Possible values are (I)nsurance (G)uarantor Input is validated by the lookup type PaySource. | |
| PayorID | INTEGER | ? | MANDATORY | FK |
| Class | CHARACTER(6) | OPTIONAL | User selects payment class code. Payment class codes are defined in the LookupCode table for the lookup type 'PayClass'. Codes for lookup type 'PayClass' are user definable and are intended to facilitate the issues such as payment type (i.e. cross-allocated payment, copay , etc.). | |
| Amount | DECIMAL(10,2) | 0 | MANDATORY | Payment amount. |
| Method | CHARACTER(1) | OPTIONAL | User selects payment method code. Payment method codes are defined in the LookupCode table for the lookup type 'PayMethod'. Codes for lookup type 'PayMethod' are not user definable. Acceptable values are (C)ash Chec(K) Cha(R)ge (E)lectronic funds transfer (O)ther. | |
| FullyApplied | CHARACTER(1) | OPTIONAL | Fully applied flag is set to (Y)es when all the total payment amount has been applied to charges, transfered, or applied to unapplied credit. | |
| CreditCard | CHARACTER(2) | OPTIONAL | User entered credit card type. The value will be validated by the lookup type CreditCard. | |
| AuthorizationCode | CHARACTER(14) | OPTIONAL | User entered authorization code as provided. | |
| PreCollected | CHARACTER(1) | OPTIONAL | Flag to indicate if the amount collected was collected prior to the charge being posted. Possible values are (Y)es or (N)o. | |
| RestrictUser | CHARACTER(1) | MANDATORY | Flag to indicate if payments made from the check must be made by the user who created the check record. The values for the flag are (Y)es or (N)o and are provided by the Confirmation lookup type. | |
| ReferenceDate | DATE | OPTIONAL | User entered reference date for a payment as provided. | |
| Voucher | CHARACTER(16) | OPTIONAL | Any voucher number which will help identify the payment received. | |
| RecordStatus | CHARACTER(1) | MANDATORY | Programmatically set record status for the payment. Valid codes are: (O)pen , (A)pplied and (V)oided. | |
| 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. |
| CreateMethod | CHARACTER(1) | M | MANDATORY | System set field which indicates the method by which the activity record was created. Possible values are: (M)anual (E)RS - ERA - Electronic Remittance Advice A - ESR - Electronic Statement Remittance |
| CBOPaymentSID | INTEGER | ? | OPTIONAL | FK - From CBOPayment |
| TraceNumber | CHARACTER(20) | OPTIONAL | Trace Number/String from ESR Payment. | |
| CCReceiptInfo | CHARACTER(1024) | OPTIONAL | Credit Card Receipt Information | |
| ReportStorageSID | INTEGER | ? | OPTIONAL | Pointer to set of ReportStorage records. No RFI to ReportStorage. |
| ReportStorageParams | CHAR(28000) | OPTIONAL | Parameters required to render the report (listed on ReportStorageSID) using Report Builder | |
| SPSReferenceID | CHAR(16) | OPTIONAL | This is a unique identifier, called VANReference, for Sage Payment Services used to void a Credit Card Transaction. | |
| PatientBilled | LOGICAL | Logical_False | OPTIONAL | Indicates if Payment appeared on a receipt. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Practice | Payment.PracticeID = Practice.PracticeID | CASCADE if Payment exists |
| Entity | Payment.PayorID = Entity.EntitySID | RESTRICT if Payment exists |
| Child Table | Join Phrase | When deleting Payment record... |
|---|---|---|
| PlanClaimRemit | PlanClaimRemit.PaymentSID = Payment.PaymentSID | CASCADE if PlanClaimRemit exists |
| PaymentAssignment | PaymentAssignment.PaymentSID = Payment.PaymentSID | RESTRICT if PaymentAssignment exists |
| PaymentNote | PaymentNote.PaymentSID = Payment.PaymentSID | CASCADE if PaymentNote exists |
| PaymentVoid | PaymentVoid.PaymentSID = Payment.PaymentSID | RESTRICT if PaymentVoid exists |