# SubscriptionById: ROBAWS Subscription by ID Find one This is a read-only table function. The ROBAWS API may not support modifying the data, or the Invantive SQL driver for ROBAWS does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the ROBAWS API. - Catalog: `Robaws` - Schema: `Subscriptions` - Label: Subscription by ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | ## Columns The columns of the table `SubscriptionById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active` | `boolean` | Active | ☐ | | | `archivedAt` | `datetime` | Archived at | ☐ | | | `assignedUser__metadata_description` | `string` | | ☐ | | | `assignedUser__metadata_href` | `string` | | ☐ | | | `assignedUser__metadata_resource` | `string` | | ☐ | | | `assignedUser__metadata_resourceTypeId` | `string` | | ☐ | | | `assignedUser_archivedAt` | `datetime` | | ☐ | | | `assignedUser_createdAt` | `datetime` | | ☐ | | | `assignedUser_deletedAt` | `datetime` | | ☐ | | | `assignedUser_email` | `string` | | ☐ | | | `assignedUser_emailAccount_from` | `string` | | ☐ | | | `assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `assignedUser_extraFields` | `string` | | ☐ | | | `assignedUser_fullName` | `string` | | ☐ | | | `assignedUser_id` | `string` | | ☐ | | | `assignedUser_locale` | `string` | | ☐ | | | `assignedUser_locked` | `boolean` | | ☐ | | | `assignedUser_lockedAt` | `datetime` | | ☐ | | | `assignedUser_updatedAt` | `datetime` | | ☐ | | | `assignedUserId` | `string` | Assigned User ID | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `client__metadata_description` | `string` | | ☐ | | | `client__metadata_href` | `string` | | ☐ | | | `client__metadata_resource` | `string` | | ☐ | | | `client__metadata_resourceTypeId` | `string` | | ☐ | | | `client_address_addressLine1` | `string` | | ☐ | | | `client_address_addressLine2` | `string` | | ☐ | | | `client_address_city` | `string` | | ☐ | | | `client_address_country` | `string` | | ☐ | | | `client_address_latitude` | `double` | | ☐ | | | `client_address_longitude` | `double` | | ☐ | | | `client_address_postalCode` | `string` | | ☐ | | | `client_archivedAt` | `datetime` | | ☐ | | | `client_assignedUser_archivedAt` | `datetime` | | ☐ | | | `client_assignedUser_createdAt` | `datetime` | | ☐ | | | `client_assignedUser_deletedAt` | `datetime` | | ☐ | | | `client_assignedUser_email` | `string` | | ☐ | | | `client_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `client_assignedUser_extraFields` | `string` | | ☐ | | | `client_assignedUser_fullName` | `string` | | ☐ | | | `client_assignedUser_id` | `string` | | ☐ | | | `client_assignedUser_locale` | `string` | | ☐ | | | `client_assignedUser_locked` | `boolean` | | ☐ | | | `client_assignedUser_lockedAt` | `datetime` | | ☐ | | | `client_assignedUser_updatedAt` | `datetime` | | ☐ | | | `client_assignedUserId` | `string` | | ☐ | | | `client_createdAt` | `datetime` | | ☐ | | | `client_creditStatus` | `string` | | ☐ | | | `client_deletedAt` | `datetime` | | ☐ | | | `client_email` | `string` | Customer Email | ☐ | | | `client_extraFields` | `string` | | ☐ | | | `client_fax` | `string` | Customer Fax | ☐ | | | `client_followUpDate` | `datetime` | | ☐ | | | `client_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_code` | `string` | | ☐ | | | `client_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `client_generalLedgerAccount_id` | `string` | | ☐ | | | `client_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_name` | `string` | | ☐ | | | `client_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccountId` | `string` | | ☐ | | | `client_gsm` | `string` | Customer Mobile | ☐ | | | `client_id` | `string` | Client ID | ☐ | | | `client_invoiceAddress_addressLine1` | `string` | | ☐ | | | `client_invoiceAddress_addressLine2` | `string` | | ☐ | | | `client_invoiceAddress_city` | `string` | | ☐ | | | `client_invoiceAddress_country` | `string` | | ☐ | | | `client_invoiceAddress_latitude` | `double` | | ☐ | | | `client_invoiceAddress_longitude` | `double` | | ☐ | | | `client_invoiceAddress_postalCode` | `string` | | ☐ | | | `client_invoiceEmail` | `string` | | ☐ | | | `client_language` | `string` | | ☐ | | | `client_legalForm_archivedAt` | `datetime` | | ☐ | | | `client_legalForm_createdAt` | `datetime` | | ☐ | | | `client_legalForm_deletedAt` | `datetime` | | ☐ | | | `client_legalForm_extraFields` | `string` | | ☐ | | | `client_legalForm_id` | `string` | | ☐ | | | `client_legalForm_legalAbbreviation` | `string` | | ☐ | | | `client_legalForm_lockedAt` | `datetime` | | ☐ | | | `client_legalForm_name` | `string` | | ☐ | | | `client_legalForm_updatedAt` | `datetime` | | ☐ | | | `client_legalForm_vatLiable` | `boolean` | | ☐ | | | `client_legalFormId` | `string` | | ☐ | | | `client_lockedAt` | `datetime` | | ☐ | | | `client_name` | `string` | | ☐ | | | `client_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `client_paymentCondition_createdAt` | `datetime` | | ☐ | | | `client_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `client_paymentCondition_extraFields` | `string` | | ☐ | | | `client_paymentCondition_id` | `string` | | ☐ | | | `client_paymentCondition_lockedAt` | `datetime` | | ☐ | | | `client_paymentCondition_name` | `string` | | ☐ | | | `client_paymentCondition_purchase` | `boolean` | | ☐ | | | `client_paymentCondition_sales` | `boolean` | | ☐ | | | `client_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `client_paymentConditionId` | `string` | | ☐ | | | `client_priceGroupId` | `string` | | ☐ | | | `client_status` | `string` | | ☐ | | | `client_statusDetails_color` | `string` | | ☐ | | | `client_statusDetails_name` | `string` | | ☐ | | | `client_tel` | `string` | | ☐ | | | `client_title` | `string` | | ☐ | | | `client_updatedAt` | `datetime` | | ☐ | | | `client_vatIdNumber` | `string` | | ☐ | | | `client_vatTariff_additionalMention` | `string` | | ☐ | | | `client_vatTariff_archivedAt` | `datetime` | | ☐ | | | `client_vatTariff_category` | `string` | | ☐ | | | `client_vatTariff_createdAt` | `datetime` | | ☐ | | | `client_vatTariff_deletedAt` | `datetime` | | ☐ | | | `client_vatTariff_description` | `string` | | ☐ | | | `client_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `client_vatTariff_extraFields` | `string` | | ☐ | | | `client_vatTariff_id` | `string` | | ☐ | | | `client_vatTariff_inclusive` | `boolean` | | ☐ | | | `client_vatTariff_lockedAt` | `datetime` | | ☐ | | | `client_vatTariff_name` | `string` | | ☐ | | | `client_vatTariff_percentage` | `decimal` | | ☐ | | | `client_vatTariff_updatedAt` | `datetime` | | ☐ | | | `client_vatTariffId` | `string` | | ☐ | | | `client_website` | `string` | | ☐ | | | `clientContact__metadata_description` | `string` | | ☐ | | | `clientContact__metadata_href` | `string` | | ☐ | | | `clientContact__metadata_resource` | `string` | | ☐ | | | `clientContact__metadata_resourceTypeId` | `string` | | ☐ | | | `clientContact_archivedAt` | `datetime` | | ☐ | | | `clientContact_createdAt` | `datetime` | | ☐ | | | `clientContact_deletedAt` | `datetime` | | ☐ | | | `clientContact_email` | `string` | | ☐ | | | `clientContact_extraFields` | `string` | | ☐ | | | `clientContact_gsm` | `string` | | ☐ | | | `clientContact_id` | `string` | | ☐ | | | `clientContact_lockedAt` | `datetime` | | ☐ | | | `clientContact_name` | `string` | | ☐ | | | `clientContact_position` | `string` | | ☐ | | | `clientContact_surname` | `string` | | ☐ | | | `clientContact_tel` | `string` | | ☐ | | | `clientContact_title` | `string` | | ☐ | | | `clientContact_updatedAt` | `datetime` | | ☐ | | | `clientContactId` | `string` | Customer Contact ID | ☐ | | | `clientId` | `string` | Customer ID | ☐ | | | `clientReference` | `string` | Customer Reference | ☐ | | | `companyId` | `string` | Company ID | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `id` | `string` | ID | ☐ | | | `interval` | `string` | Interval | ☐ | Deprecated, use recurrenceType instead. | | `journalName` | `string` | Journal name | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `nextExecutionDate` | `datetime` | Next execution date | ☐ | | | `recurrenceRule` | `string` | Recurrence Rule | ☐ | | | `remark` | `string` | Remark | ☐ | | | `startDate` | `datetime` | Start Date | ☐ | | | `status` | `string` | Status | ☐ | | | `totalExclVat` | `decimal` | Total excluding VAT | ☐ | | | `totalInclVat` | `decimal` | Total including VAT | ☐ | | | `type` | `string` | Type | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | | | `validUntil` | `datetime` | Valid until | ☐ | | | `withRespectTo` | `string` | Attn. | ☐ | |