Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| raappid | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each escrow remittance application |
|
| fkraid | int | 4 | null |
|
|
Remittance reference - Links to main remittance record for this application |
||
| fkclaimid | int | 4 | √ | null |
|
|
Claim reference - Links to Claim table for the claim being processed |
|
| fktransid | int | 4 | √ | null |
|
|
Transaction reference - Links to transaction record for this application |
|
| fkremitstatusid | int | 4 | √ | null |
|
|
Remittance status - Links to RemitStatus table for current processing status |
|
| ruleerrorid | varchar | 10 | √ | null |
|
|
Rule error identifier - Error code if application failed validation rules |
|
| comments | nvarchar | 1000 | √ | null |
|
|
Application comments - Comments and notes about the remittance application |
|
| applicationdate | smalldatetime | 16 | null |
|
|
Application date - Date when the remittance application was submitted |
||
| updatedby | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this record |
|
| dateupdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this record was last updated |
|
| fkinvtransid | int | 4 | √ | null |
|
|
Invoice transaction reference - Links to InvoiceTransaction table for related transaction |
Relationships
Close relationships within degrees of separation
