# PaymentsBulk: Exact Online Payments - Catalog: `ExactOnlineREST` - Schema: `Cashflow` - Primary Keys: `ID` - Label: Payments 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 `PaymentsBulk` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Account` | `guid` | Account | ☐ | The supplier to which the payment has to be done. | | `AccountBankAccountID` | `guid` | | ☐ | The bank account of the supplier, to which the payment has to be done. | | `AccountBankAccountNumber` | `varchar2` | | ☐ | The bank account number of the supplier, to which the payment has to be done. | | `AccountCode` | `varchar2` | Account Code | ☐ | The code of the supplier to which the payment has to be done. | | `AccountContact` | `guid` | Account Contact | ☐ | Contact person copied from the purchase invoice linked to the related purchase entry. Used as prefered contact when sending reminders. | | `AccountContactName` | `varchar2` | Account Contact Name | ☐ | Name of the contact person of the supplier. | | `AccountName` | `varchar2` | Account Name | ☐ | Name of the supplier. | | `AmountDC` | `double` | Amount Division Currency | ☑ | The amount in default currency (division currency). Payments are matched on this amount. | | `AmountDiscountDC` | `double` | Discount Amount (division currency) | ☑ | The amount of the discount in the default currency. | | `AmountDiscountFC` | `double` | Discount Amount (foreign currency) | ☑ | The amount of the discount. This is in the amount of the selected currency. | | `AmountFC` | `double` | Amount Foreign Currency | ☑ | The amount of the payment. This is in the amount of the selected currency. | | `BankAccountID` | `guid` | Bank Account ID | ☐ | Own bank account from which the payment must be done. | | `BankAccountNumber` | `varchar2` | Bank Account Number | ☐ | Own bank account number from which the payment must be done. | | `CashflowTransactionBatchCode` | `varchar2` | Cashflow Transaction Batch Code | ☐ | When processing payments, all payments with the same processing data are put in a batch. This field contains the code of that batch. | | `Created` | `datetime` | Created | ☑ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of the creator. | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | Name of the creator. | | `Currency` | `varchar2` | Currency | ☐ | The currency of the payment. This currency can only deviate from the division currency if the module Currency is in the license. | | `Description` | `varchar2` | Description | ☐ | Extra description for the payment that may be included in the bank export file. | | `DiscountDueDate` | `datetime` | Discount Due Date | ☐ | Date before which the payment must be done to be eligible for 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 | ☐ | Document that is created when processing payments. The bank export file is attached to the document. | | `DocumentNumber` | `int32` | Document Number | ☐ | Number of the document. | | `DocumentSubject` | `varchar2` | Document Subject | ☐ | Subject of the document. | | `DueDate` | `datetime` | Due Date | ☐ | Date before which the payment must be done. | | `EndDate` | `datetime` | End Date | ☐ | Date since when the payment is no longer an outstanding item. This is the highest invoice date of all matched payments. | | `EndPeriod` | `int16` | End Period | ☐ | Period since when the payment is no longer an outstanding item. This is the highest period of all matched payments. | | `EndYear` | `int16` | End Year | ☐ | Year (of period) since when the payment is no longer an outstanding item. This is the highest year of all matched payments. Used in combination with EndPeriod. | | `EntryDate` | `datetime` | Entry Date | ☐ | Processing date of the payment. | | `EntryID` | `guid` | Entry ID | ☐ | The unique identifier for a set of payments. A payment can be split so that one part is paid on a different date. In that case the two records get a different EntryID. | | `EntryNumber` | `int32` | Entry Number | ☐ | Entry number of the linked transaction. | | `GLAccount` | `guid` | General Ledger Account | ☐ | G/L account of the payment. Must be of type 22 (Accounts payable). | | `GLAccountCode` | `varchar2` | GL Account Code | ☐ | Code of the G/L account. | | `GLAccountDescription` | `varchar2` | GL Account Description | ☐ | Description of the G/L account. | | `ID` | `guid` | ID | ☑ | Identifier of the payment. | | `InvoiceDate` | `datetime` | Invoice Date | ☐ | Invoice date of the linked transaction. | | `InvoiceNumber` | `int32` | Invoice Number | ☐ | Invoice number of the linked transaction. | | `IsBatchBooking` | `int16` | Is Batch Booking | ☐ | Boolean indicating whether the payment is part of a batch booking. | | `Journal` | `varchar2` | Journal | ☐ | Journal of the linked transaction. | | `JournalDescription` | `varchar2` | Journal Description | ☐ | Description of the journal. | | `Modified` | `datetime` | Modified | ☑ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | Name of modifier. | | `PaymentBatchNumber` | `int32` | Payment Batch Number | ☐ | Number assigned during the of processing payments. When payments are processed a bank export file is created. This file contains one or more batches that contain one or more payments. Each batch gets a sequence number that is stored for each payment in that batch. | | `PaymentCondition` | `varchar2` | Payment Condition | ☐ | Payment condition of the linked transaction. | | `PaymentConditionDescription` | `varchar2` | Payment Condition Description | ☐ | Description of the payment condition. | | `PaymentDays` | `int32` | Payment Days | ☐ | Number of days between invoice date and due date. | | `PaymentDaysDiscount` | `int32` | Payment Days Discount | ☐ | Number of days between invoice date and due date of the discount. | | `PaymentDiscountPercentage` | `double` | | ☐ | Payment discount percentage. | | `PaymentMethod` | `varchar2` | Payment Method | ☐ | Method of payment. B = On credit (default) I = Collection K = Cash V = Credit card. | | `PaymentReference` | `varchar2` | Payment Reference | ☐ | Payment reference for the payment that may be included in the bank export file. | | `PaymentSelected` | `datetime` | Payment Selected | ☐ | Date and time since when the payment is selected to be paid. | | `PaymentSelector` | `guid` | Payment Selector | ☐ | User who selected the payment to be paid. | | `PaymentSelectorFullName` | `varchar2` | | ☐ | Name of the payment selector. | | `RateFC` | `double` | Rate Foreign Currency | ☐ | Exchange rate from payment currency to division currency. AmountFC * RateFC = AmountDC. | | `Source` | `int32` | Source | ☑ | The source of the payment. 1 = manual 2 = reconcile 3 = match 4 = import 5 = process. | | `Status` | `int16` | Status | ☐ | The status of the payment. 20 = open 30 = selected - payment is selected to be paid 40 = processed - payment has been done 50 = matched - payment is matched with one or more other outstanding items or financial statement lines. | | `TransactionAmountDC` | `double` | Transaction Amount Division Currency | ☑ | Total amount of the linked transaction in default currency (division currency). | | `TransactionAmountFC` | `double` | Transaction Amount Foreign Currency | ☑ | Total amount of the linked transaction in the selected currency. | | `TransactionDueDate` | `datetime` | Transaction Due Date | ☐ | Due date of the linked transaction. | | `TransactionEntryID` | `guid` | Transaction Entry ID | ☐ | Linked transaction. Use this as reference to PurchaseEntries. | | `TransactionID` | `guid` | Transaction ID | ☐ | Linked transaction line. Use this as reference to BankEntryLines and CashEntryLines. | | `TransactionIsReversal` | `char` | | ☑ | Indicates if the linked transaction is a reversal entry. | | `TransactionReportingPeriod` | `int16` | | ☐ | Period of the linked transaction. | | `TransactionReportingYear` | `int16` | | ☐ | Year of the linked transaction. | | `TransactionStatus` | `int16` | Transaction Status | ☐ | Status of the linked transaction. | | `TransactionType` | `int32` | Transaction Type | ☐ | Type of the linked transaction. | | `YourRef` | `varchar2` | Your Reference | ☐ | Invoice number of the supplier. In case the payment belongs to a bank entry line and is matched with one invoice, YourRef is filled with the YourRef of this invoice. |