Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkPaymentInfoID | int identity | 4 | √ | null |
|
|
Primary key - AgencyPaymentInfo unique identifier for each record |
||||
| fkAgencyID | int | 4 | null |
|
|
Agency reference - Reference to the agency (foreign key to Agency.AgencyID) |
|||||
| Active | int | 4 | √ | null |
|
|
Active status - Indicates whether this payment method is currently active and available for use |
||||
| Phone | varchar | 20 | √ | null |
|
|
Contact phone - Phone number associated with the payment method |
||||
| StreetAddress | varchar | 150 | √ | null |
|
|
Street address - Billing address line 1 for the payment method |
||||
| StreetAddress2 | varchar | 50 | √ | null |
|
|
Address line 2 - Additional address information (suite, apartment, etc.) |
||||
| City | varchar | 100 | √ | null |
|
|
City - Billing city for the payment method |
||||
| State | varchar | 2 | √ | null |
|
|
State - Billing state or province for the payment method |
||||
| Zip | varchar | 50 | √ | null |
|
|
Postal code - Billing ZIP or postal code for the payment method |
||||
| PaymentType | varchar | 50 | √ | null |
|
|
Payment type - Type of payment method (Credit Card, ACH, Check, etc.) |
||||
| Name | varchar | 100 | √ | null |
|
|
Account name - Name on the payment account or credit card |
||||
| Number | varchar | 20 | √ | null |
|
|
Account number - Encrypted account or card number for payment processing |
||||
| CCType | varchar | 50 | √ | null |
|
|
Credit card type - Type of credit card (Visa, MasterCard, etc.) if applicable |
||||
| CCExp | smalldatetime | 16 | √ | null |
|
|
Card expiration - Credit card expiration date if applicable |
||||
| DName | varchar | 100 | √ | null |
|
|
Bank name - Name of the bank for ACH transactions |
||||
| DRouting | varchar | 20 | √ | null |
|
|
Routing number - Bank routing number for ACH transactions |
||||
| DFriendlyName | varchar | 100 | √ | null |
|
|
Friendly name - User-friendly name for identifying this payment method |
||||
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation date - Date when this payment method was added to the system |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AgencyPaymentInfo | Primary key | Asc | pkPaymentInfoID |