# PurchaseInvoices: Exact Online Purchase Invoices - Catalog: `ExactOnlineREST` - Schema: `Purchase` - Primary Keys: `ID` - Label: Purchase Invoices The data in this table is partitioned per value of the `Division` column. Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `PurchaseInvoices` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Amount` | `double` | Amount | ☑ | The amount including VAT in the currency of the invoice. | | `AmountDC` | `double` | Amount Division Currency | ☐ | | | `AmountDiscount` | `double` | Amount Discount | ☐ | | | `AmountDiscountExclVat` | `double` | Amount Discount excluding VAT | ☐ | | | `AmountFCExclVat` | `double` | Amount Foreign Currency excluding VAT | ☐ | | | `ContactPerson` | `guid` | Contact Person | ☐ | Guid identifying the contact person of the supplier. | | `Currency` | `varchar2`(30) | Currency | ☐ | The code of the currency of the invoiced amount. | | `Description` | `varchar2` | Description | ☐ | The description of the invoice. | | `Discount` | `double` | Discount | ☐ | | | `Division` | `int32` | Division ID | ☑ | Unique number of the Exact Online division. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `Document` | `guid` | Document | ☐ | Guid identifying a document that is attached to the invoice. | | `DueDate` | `datetime` | Due Date | ☐ | The date before which the invoice has to be paid. | | `EntryNumber` | `int32` | Entry Number | ☐ | The unique number of the purchase invoice. The entry number is based on a setting in the purchase journal and incremented for each new purchase invoice. | | `ExchangeRate` | `double` | Exchange Rate | ☐ | The exchange rate between the invoice currency and the default currency of the division. | | `FinancialPeriod` | `int16` | Financial Period | ☐ | Financial period. | | `FinancialYear` | `int16` | Financial Year | ☐ | The financial year in which the invoice is entered. | | `ID` | `guid` | ID | ☑ | A GUID that is the unique identifier of the purchase invoice. | | `InvoiceDate` | `datetime` | Invoice Date | ☐ | The date on which the supplier entered the invoice. | | `Journal` | `varchar2`(20) | Journal | ☐ | The code of the purchase journal in which the invoice is entered. | | `Modified` | `datetime` | Modified | ☑ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `PaymentCondition` | `varchar2`(2) | Payment Condition | ☐ | The code of the payment condition that is used to calculate the due date and discount. | | `PaymentReference` | `varchar2`(60) | Payment Reference | ☐ | Unique reference to match payments and invoices. | | `Remarks` | `varchar2` | Remarks | ☐ | The user can enter remarks related to the invoice here. | | `Source` | `int16` | Source | ☑ | Indicates the origin of the invoice. 1 Manual entry, 3 Purchase invoice, 4 Purchase order, 5 Web service. | | `Status` | `int16` | Status | ☑ | The status of the invoice. 10 Draft, 20 Open, 50 Processed. | | `Supplier` | `guid` | Supplier | ☐ | Guid that identifies the supplier. | | `Type` | `int16` | Type | ☑ | Indicates the type of the purchase invoice. 8030 Direct purchase invoice, 8031 Direct purchase invoice (Credit), 8033 Purchase invoice, 8034 Purchase invoice (Credit). | | `VATAmount` | `double` | VAT Amount | ☐ | The total VAT amount of the purchase invoice. | | `Warehouse` | `guid` | Warehouse | ☐ | Guid that identifies the warehouse that will receive the purchased goods. This is mandatory for creating a direct purchase invoice. | | `YourRef` | `varchar2`(30) | Your Reference | ☐ | The invoice number provided by the supplier. |