Fee_Payment (ver21.4.0)
This table contains the payment details.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Amount | 21.4.0 | Float | The amount of the payment. Required. |
ID | 21.4.0 | Number(19,0) | Unique sequential number generated by the application. Indexed. Required. |
Invoice_Reference | 21.4.0 | Varchar2(100) | The customer invoice number to identify the order. Required. |
| Origin | 21.4.0 | Varchar2(100) | Identifies the specific payment at the payment processor's system. Required. |
Payment_ID | 21.4.0 | Varchar2(50) | The payment identifier identifies the specific payment in the payment processor's system. Indexed. Required. |
School_Number | 21.4.0 | Number(10,0) | The School_Number of the associated Schools record. Required. |
| Service_Fee | 21.4.0 | Float | A positive decimal representing how much service fee to charge for this payment. Required. |
Student_DCID | 21.4.0 | Number(19,0) | The internal number and DCID of the associated Students record. Indexed. Required. |
WhenCreated | 21.4.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 21.4.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 21.4.0 | Varchar2(100) | The user login that created the record. Defaults to the database user. Required. |
WhoModified | 21.4.0 | Varchar2(100) | The user login that modified the record. Defaults to the database user. Required. |