Invoices_Credit_Notes
The table below describes the Invoices_Credit_Notes 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:
- Invoice_ID
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_Credit_Notes_Index Primary Key |
SQL_INTEGER(unsigned) | False |
|
Credit_Note_ID Foreign Key linked to column Credit_Note_ID in Credit_Notes table |
SQL_VARCHAR(8192) | True |
|
Credit_Notes_Applied_Amount |
SQL_NUMERIC(38,2) | True |
|
Credit_Notes_ID |
SQL_VARCHAR(8192) | True |