This table contains the payment details.
|21.4.0||Float||The amount of the payment. Required.|
Unique sequential number generated by the application. Indexed. Required.
|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.|
The payment identifier identifies the specific payment in the payment processor's system. Indexed. Required.
|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.|
The internal number and DCID of the associated Students record. Indexed. Required.
The date and time the record was created. Defaults to system date.
The date and time the record was modified. Defaults to system date.
The user login that created the record. Defaults to the database user. Required.
The user login that modified the record. Defaults to the database user. Required.