# PurchaseEntryLines: Exact Online Purchase Entry Lines - Catalog: `ExactOnlineREST` - Schema: `PurchaseEntry` - Primary Keys: `ID` - Label: Purchase Entry Lines 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 `PurchaseEntryLines` 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 | |---|:---:|---|:---:|---| | `AmountDC` | `double` | Amount Division Currency | ☑ | Amount in the default currency of the company. | | `AmountFC` | `double` | Amount Foreign Currency | ☑ | Amount in the currency of the transaction. | | `Asset` | `guid` | Asset | ☐ | Reference to asset. | | `AssetDescription` | `varchar2` | Asset Description | ☐ | Asset description. | | `CostCenter` | `varchar2`(8) | Cost Centre | ☐ | Reference to cost center. | | `CostCenterDescription` | `varchar2`(60) | Cost Centre Description | ☐ | Description of CostCenter. | | `CostUnit` | `varchar2`(8) | Cost Unit | ☐ | Reference to cost unit. | | `CostUnitDescription` | `varchar2`(60) | Cost Unit Description | ☐ | Description of CostUnit. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `Description` | `varchar2` | Description | ☐ | Description. | | `Division` | `int32` | Division | ☑ | Division code. | | `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. | | `EntryID` | `guid` | Entry ID | ☐ | Reference to header of the purchase entry. | | `Expense` | `guid` | Expense | ☐ | | | `ExpenseDescription` | `varchar2` | Expense Description | ☐ | | | `From` | `datetime` | From | ☐ | From date for deferred revenue. | | `GLAccount` | `guid` | General Ledger Account | ☐ | General ledger account. | | `GLAccountCode` | `varchar2`(30) | GL Account Code | ☐ | Code of the G/L account. | | `GLAccountDescription` | `varchar2`(60) | GL Account Description | ☐ | Description of the G/L account. | | `ID` | `guid` | ID | ☑ | Primary key. | | `IntraStatArea` | `varchar2` | Intrastat Area | ☐ | IntraStat area. | | `IntraStatCountry` | `varchar2` | Intrastat Country | ☐ | IntraStatCountry. | | `IntraStatDeliveryTerm` | `varchar2` | Intrastat Delivery Term | ☐ | IntraStat delivery term. | | `IntraStatTransactionA` | `varchar2`(1) | Intrastat Transaction A | ☐ | IntraStat transaction a. | | `IntraStatTransactionB` | `varchar2` | Intrastat Transaction B | ☐ | | | `IntraStatTransportMethod` | `varchar2`(1) | Intrastat Transport Method | ☐ | IntraStat transport method. | | `LineNumber` | `int32` | Line Number | ☐ | Line number. | | `NetAmountDC` | `double` | Net Amount Division Currency | ☐ | Net amount in division currency of purchase entry line. | | `NetAmountFC` | `double` | Net Amount Foreign Currency | ☐ | Net amount in foreign currency of purchase entry line. | | `Notes` | `varchar2` | Notes | ☐ | Extra remarks. | | `PrivateUsePercentage` | `double` | | ☐ | Percentage of re-invoice part of a cost to the GlobalState of the company. | | `Project` | `guid` | Project | ☐ | Reference to project. | | `ProjectDescription` | `varchar2`(60) | Project Description | ☐ | Description of Project. | | `Quantity` | `double` | Quantity | ☐ | Quantity. | | `SerialNumber` | `varchar2`(30) | Serial Number | ☐ | Serial number. | | `StatisticalNetWeight` | `double` | Statistical Net Weight | ☐ | Statistical NetWeight. | | `StatisticalNumber` | `varchar2` | Statistical Number | ☐ | Statistical Number (also known as 'Goederencode'). | | `StatisticalQuantity` | `double` | Statistical Quantity | ☐ | Statistical Quantity. | | `StatisticalValue` | `double` | Statistical Value | ☐ | Statistical Value. | | `Subscription` | `guid` | Subscription | ☐ | Reference to subscription. | | `SubscriptionDescription` | `varchar2`(60) | Subscription Description | ☐ | Description of Subscription. | | `To` | `datetime` | To | ☐ | To date for deferred revenue. | | `TrackingNumber` | `guid` | Tracking Number | ☐ | Reference to tracking number. | | `TrackingNumberDescription` | `varchar2`(240) | Tracking Number Description | ☐ | Description of TrackingNumber. | | `Type` | `int32` | Type | ☐ | Type: 30 = Purchase entry, 31 = Purchase credit note. | | `VATAmountDC` | `double` | VAT Amount Division Currency | ☐ | VAT amount in the default currency of the company. | | `VATAmountFC` | `double` | VAT Amount Foreign Currency | ☐ | VAT amount in the currency of the transaction. Use this property to specify a VAT amount that differs from the VAT amount that is automatically calculated. | | `VATBaseAmountDC` | `double` | VAT Base Amount Division Currency | ☐ | VAT base amount in the default currency of the company. | | `VATBaseAmountFC` | `double` | VAT Base Amount Foreign Currency | ☐ | VAT base amount in the currency of the transaction. | | `VATCode` | `varchar2`(3) | VAT Code | ☐ | VAT code. | | `VATCodeDescription` | `varchar2`(60) | VAT Code Description | ☐ | Description of VAT code. | | `VATNonDeductiblePercentage` | `double` | | ☐ | If not the full amount of the VAT is deductible, you can indicate a percentage for the non decuctible part. This is used during the entry of purchase invoices. | | `VATPercentage` | `double` | VAT Percentage | ☐ | VAT percentage. | | `WithholdingAmountDC` | `double` | Withholding Amount Division Curency | ☐ | Withholding tax amount for spanish legislation. | | `WithholdingTax` | `varchar2` | Withholding Tax | ☐ | Withholding tax key for spanish legislation. |