Invoices_Overpayments

The table below describes the Invoices_Overpayments table in the Global database schema.

This is a virtual table, and is linked to the Invoices table in the Global database schema (see Invoices).

None of the columns in this table are updatable.

This table contains the following foldable column:

This table does not contain Return Primary Key columns.

Column Name	SQL Type	Nullable
Invoice_ID Primary Key Foreign Key linked to column Invoice_ID in Invoices table	SQL_VARCHAR(8192)	False
Invoices_Overpayments_Index Primary Key	SQL_INTEGER(unsigned)	False
Overpayment_ID Foreign Key linked to column Overpayment_ID in Overpayments table	SQL_VARCHAR(8192)	True

Column Name

SQL Type

Nullable

Invoice_ID

Primary Key

Foreign Key linked to column Invoice_ID in Invoices table

SQL_VARCHAR(8192)

False

Invoices_Overpayments_Index

Primary Key

SQL_INTEGER(unsigned)

False

Overpayment_ID

Foreign Key linked to column Overpayment_ID in Overpayments table

SQL_VARCHAR(8192)

True