Store all the detailed payment information here. The primary key for these objects are account_no and id. The id is calculated from billing_account.last_payment_id
the values for the overloaded fields for the payment types supplied out-of-the-box. Users can created there own payment plugins and override the meanings of these fields.
When type_1=CreditCard " type_2: 0=VISA, 1=MasterCard, 2=AMEX " text_1: issued by, ex: Citibank " text_2: card number " date_1: expiration date
When type_1=Check " text_1: check number " text_2: routing number " text_3: account_number " date_1: check date
When type_1=Cash no fields overloaded for cash
When type_1=Direct " text_1: institution number " text_2: routing number
When type_1=PrePay " numeric_1: deposited amount " numeric_2: applied amount " date_1: prepayment date
When type_1=Coupon " text_1: coupon number " date_1: expiration date
When type_1=Tip " type_2: tip type, ex: normal, holiday, etc. " text_1: tip to who
| Column Name | Column Datatype | Column Null Option | Column Comment |
| account_no | varchar(50) | not null | The account to which payment has been made. |
| id | integer | not null | Incremented integer associated to each payment. |
| domain | varchar(50) | not null | This is the tenant ID of the account |
| parent_domain | varchar(50) | not null | This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider. |
| status | integer | not null | 1=deleted, 0=inactive, 1=active, 2=opened, 3=closed |
| type_1 | varchar(50) | not null | Payment plugin id, ex: Check, CreditCard, etc. |
| type_2 | integer | with null | Additionaly distiguishes between payment types, ex: when type_1=CreditCard then type_2 could be AMEX, VISA, etc. In other words, this value is overloaded depending on the value of type_1. |
| p_name | nvarchar(50) | with null | Payer's name. |
| p_title | nvarchar(50) | with null | Payer's title. |
| p_address1 | nvarchar(50) | with null | Payer's address 1. |
| p_address2 | nvarchar(50) | with null | Payer's address 2. |
| p_city | nvarchar(50) | with null | Payer's city. |
| p_state | nvarchar(50) | with null | Payer's state. |
| p_zip | nvarchar(50) | with null | Payer's zip. |
| p_country | nvarchar(50) | with null | Payer's country. |
| p_tel | nvarchar(50) | with null | Payer's telephone number. |
| p_fax | nvarchar(50) | with null | Payer's fax number. |
| p_email | nvarchar(50) | with null | Payer's email address. |
| opened_date | date | not null | Date of payment. |
| closed_date | date | with null | Date of completed payment. |
| active_date | date | with null | Currently not used. |
| inactive_date | date | with null | Currently not used. |
| enum_1 | integer | with null | Overloaded depending on the value of type_1. Currenly no payment plugins provided out of the box uses this field, but exists for user plugins. |
| text_1 | nvarchar(50) | with null | Overloaded depending on the value of type_1. ex: when type_1=Check then text_1 is check number |
| text_2 | nvarchar(50) | with null | Overloaded depending on the value of type_1. ex: when type_1=Check then text_2 is the routing number |
| text_3 | nvarchar(50) | with null | Overloaded depending on the value of type_1. ex: when type_1=Check then text_3 is the account number |
| numeric_1 | float | with null | Overloaded depending on the value of type_1. ex: when type_1=PrePay then numeric_1 is the deposited amount |
| numeric_2 | float | with null | Overloaded depending on the value of type_1. ex: when type_1=PrePay then numeric_2 is the applied amount |
| date_1 | date | with null | Overloaded depending on the value of type_1. ex: when type_1=Check then date_1 is the date on the check |
Product Name: Unicenter Service Management
Table Type: Table