# TransactionLinesBulk: Exact Online Transaction Lines (Bulk) - Catalog: `ExactOnlineREST` - Schema: `FinancialTransaction` - Primary Keys: `ID` - Label: Transaction Lines (Bulk) The data in this table is partitioned per value of the `Division` column. This is a read-only table. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## Table Columns The columns of the table `TransactionLinesBulk` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Account` | `guid` | Account | ☐ | Reference to account. | | `AccountCode` | `varchar2`(18) | Account Code | ☐ | Code of the Account. | | `AccountName` | `varchar2`(50) | Account Name | ☐ | Name of account. | | `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. | | `AmountVATBaseFC` | `double` | Amount VAT Base Foreign Currency | ☐ | Vat base amount in the currency of the transaction. | | `AmountVATFC` | `double` | Amount VAT Foreign Currency | ☐ | Vat amount in the currency of the transaction. | | `Asset` | `guid` | Asset | ☐ | Reference to asset. | | `AssetCode` | `varchar2`(30) | Asset Code | ☐ | Code of Asset. | | `AssetDescription` | `varchar2`(60) | Asset Description | ☐ | Description of Asset. | | `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. | | `Created` | `datetime` | Created | ☑ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `Currency` | `varchar2`(30) | Currency | ☐ | Currency. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `Date` | `datetime` | Date | ☐ | Date. | | `Description` | `varchar2`(60) | Description | ☐ | Description. | | `DisplayDocumentsUrl` | `varchar2` | Display Documents (URL) | ☐ | URL to display documents attached to this transaction using Get My Report. | | `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. | | `Document` | `guid` | Document | ☐ | Reference to document. | | `DocumentNumber` | `int32` | Document Number | ☐ | Number of the document. | | `DocumentSubject` | `varchar2`(256) | Document Subject | ☐ | Subject of the document. | | `DueDate` | `datetime` | Due Date | ☐ | Date that payment should be done. | | `EntryID` | `guid` | Entry ID | ☐ | The transaction lines that make up a financial entry share the same EntryID. | | `EntryNumber` | `int32` | Entry Number | ☐ | Entry number of the header. | | `ExchangeRate` | `double` | Exchange Rate | ☐ | Exchange rate. | | `ExternalLinkDescription` | `varchar2` | External Link Description | ☐ | | | `ExternalLinkReference` | `varchar2` | External Link Reference | ☐ | | | `ExtraDutyAmountFC` | `double` | Extra Duty Amount Foreign Currency | ☐ | Extra duty amount. | | `ExtraDutyPercentage` | `double` | Extra Duty (%) | ☐ | Extra duty percentage. | | `FinancialPeriod` | `int16` | Financial Period | ☐ | Financial period. | | `FinancialYear` | `int16` | Financial Year | ☐ | Financial year. | | `GLAccount` | `guid` | General Ledger Account | ☐ | General ledger account. | | `GLAccountBalanceSide` | `varchar2`(1) | GL Account Balance Side | ☑ | Balance side of transactions on this GL account. | | `GLAccountBalanceType` | `varchar2`(1) | GL Account Balance Type | ☑ | Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss. | | `GLAccountCode` | `varchar2`(30) | GL Account Code | ☐ | Code of the G/L account. | | `GLAccountDescription` | `varchar2`(60) | GL Account Description | ☐ | Description of the G/L account. | | `GLAccountRevalueCurrency` | `char` | GL Account Revalue Currency | ☑ | Whether to revalue amounts posted on this GL account. | | `GLAccountSearchCode` | `varchar2`(9) | GL Account Search Code | ☐ | User-friendly search code for the GL account. | | `GLAccountType` | `int32` | GL Account Type | ☑ | Type of GL account. See view GLAccountTypes. | | `GLAccountTypeDescription` | `varchar2` | GL Account Type Description | ☑ | Description of the GL account type. | | `GLAccountUseCostCenter` | `char` | Use Cost Centre | ☑ | Indicator whether to use cost centers for transaction lines on the GL account. | | `GLAccountUseCostUnit` | `char` | Use Cost Unit | ☑ | Indicator whether to use cost units for transaction lines on the GL account. | | `GLAccountVatCode` | `varchar2`(3) | VAT Code of GL Account | ☐ | Associated VAT code of the GL account. | | `ID` | `guid` | ID | ☑ | Primary key. | | `InvoiceNumber` | `int32` | Invoice Number | ☐ | Invoice number. | | `Item` | `guid` | Item | ☐ | Reference to item. | | `ItemCode` | `varchar2`(30) | Item Code | ☐ | Code of Item. | | `ItemDescription` | `varchar2`(255) | Item Description | ☐ | Description of Item. | | `JournalCode` | `varchar2`(20) | Journal Code | ☐ | The journal code. | | `JournalDescription` | `varchar2`(60) | Journal Description | ☐ | The journal description. | | `LineNumber` | `int32` | Line Number | ☐ | Line number. | | `LineType` | `int16` | Line Type | ☑ | Line type. | | `Modified` | `datetime` | Modified | ☑ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `Notes` | `varchar2` | Notes | ☐ | Extra remarks. | | `OffsetID` | `guid` | Offset GL Account ID | ☐ | OffsetID. | | `OrderNumber` | `int32` | Order Number | ☐ | Order number. | | `PaymentDiscountAmount` | `double` | Payment Discount Amount | ☐ | Discount amount when paid in time. | | `PaymentReference` | `varchar2`(60) | Payment Reference | ☐ | Payment reference. | | `Project` | `guid` | Project | ☐ | Reference to project. | | `ProjectCode` | `varchar2`(20) | Project Code | ☐ | Code of Project. | | `ProjectDescription` | `varchar2`(60) | Project Description | ☐ | Description of Project. | | `ProjectWBS` | `guid` | Project WBS | ☐ | Project WBS ID. | | `ProjectWBSDescription` | `varchar2` | Project WBS Description | ☐ | Project WBS description. | | `Quantity` | `double` | Quantity | ☐ | Quantity. | | `SerialNumber` | `varchar2`(30) | Serial Number | ☐ | Serial number of item. | | `ShopOrder` | `guid` | Shop Order | ☐ | Reference to shop order. | | `Status` | `int16` | Status | ☐ | 20 = Open, 50 = Processed. | | `Subscription` | `guid` | Subscription | ☐ | Reference to subscription line. | | `SubscriptionDescription` | `varchar2`(60) | Subscription Description | ☐ | Description of subscription line. | | `TrackingNumber` | `varchar2`(100) | Tracking Number | ☐ | Tracking number of item. | | `TrackingNumberDescription` | `varchar2`(240) | Tracking Number Description | ☐ | Tracking number description. | | `Type` | `int32` | Type | ☑ | The transaction type. Possible values: see TransactionLineTypes. | | `VATCode` | `varchar2`(3) | VAT Code | ☐ | VAT code. | | `VATCodeDescription` | `varchar2`(60) | VAT Code Description | ☐ | Description of VAT code. | | `VATPercentage` | `double` | VAT Percentage | ☐ | Vat percentage. | | `VATType` | `varchar2`(1) | VAT Type | ☐ | VAT type. | | `YourRef` | `varchar2`(30) | Your Reference | ☐ | Your reference (of customer). |