Fee_Payment (ver21.4.0)

This table contains the payment details.

Column Name

Initial Version

Data Type

Description

Amount

21.4.0FloatThe 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.0Varchar2(100)The customer invoice number to identify the order. Required.
Origin21.4.0Varchar2(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.0Number(10,0)The School_Number of the associated Schools record. Required.
Service_Fee21.4.0FloatA 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.

Copyright © 2021 PowerSchool Group LLC