SSIS Components for Sage Business Cloud Accounting

Build 24.0.9062

MigrationTaxReturns

Query MigrationTaxReturns in Sage Business Cloud Accounting.

Table Specific Information

Query the available MigrationTaxReturns

Select

The driver processes all filters client-side within the driver.

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

CreatedAt Datetime True

The datetime when the item was created

IeBoxT4 String False

The value of box T4

IeBoxT3 String False

The value of box T3

IeBoxT2 String False

The value of box T2

IeBoxT1 String False

The value of box T1

IeBoxES2 String False

The value of box ES2

IeBoxES1 String False

The value of box ES1

IeBoxE2 String False

The value of box E2

IeBoxE1 String False

The value of box E1

DisplayedAs String False

The name of the resource

FromDate Datetime True

The start date of the tax return

LegacyId Int False

The legacy ID for the item

TaxReturnFrequencyId String False

TaxReturnFrequencies.Id

The unique identifier for the item

UpdatedAt Datetime True

The datetime when the item was last updated

GbBox9 String False

The value of box 9

GbBox8 String False

The value of box 8

GbBox7 String False

The value of box 7

GbBox6 String False

The value of box 6

GbBox5 String False

The value of box 5

GbBox4 String False

The value of box 4

GbBox3 String False

The value of box 3

GbBox2 String False

The value of box 2

GbBox1 String False

The value of box 1

TotalAmount String False

The total of the tax return

ToDate Datetime True

The end date of the tax return

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062