Fee_Payment_Item (ver21.4.0)

This table contains the payment invoice item details.

Column Name

Initial Version

Data Type

Description

Description

21.4.0Varchar2(255)The short description of the invoice item
Extended_Price21.4.0FloatThe total unit cost of the item multiplied by the quantity. It does not include tax. Required.
Extended_Tax21.4.0FloatThe total amount of tax charged on the extended price. Required.

Fee_Payment_ID

21.4.0

Number(19,0)

The internal number and ID of the associated Fee_Payment record. Indexed. Required.

ID

21.4.0

Number(19,0)

Unique sequential number generated by the application. Indexed. Required.

Is_Integrated_Fee

21.4.0

Number(1,0)

1 indicates the invoice item is an integrated fee and tagged to the fee record. Required.

Order_Reference_ID21.4.0Varchar2(100)The invoice item reference identifier. Required.
Payer_ID21.4.0Varchar2(50)The payer information for this invoice item. Required.

Product_Code

21.4.0Varchar2(50)
This is usually a code or SKU that identifies the product. Required.

Quantity

21.4.0Number(19,0)The customer invoice number to identify the order. 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