Invoices_Prepayments

The table below describes the Invoices_Prepayments 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_Prepayments_Index Primary Key	SQL_INTEGER(unsigned)	False
Prepayment_ID Foreign Key linked to column Prepayment_ID in Prepayments 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_Prepayments_Index

Primary Key

SQL_INTEGER(unsigned)

False

Prepayment_ID

Foreign Key linked to column Prepayment_ID in Prepayments table

SQL_VARCHAR(8192)

True