SSIS Components for QuickBooks

Build 24.0.9175

VendorTypes

Handles QuickBooks Vendor Types, allowing creation, updates, deletion, and queries for categorizing vendors.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier for the vendor type record in QuickBooks.

Name String False 31

The name of the vendor type, used to categorize vendors for reporting and organization purposes.

FullName String False 159

The full name of the vendor type, including its hierarchy if it is a sublevel of another vendor type.

IsActive Boolean False

Indicates whether the vendor type is active. Set to true for active vendor types or false for inactive ones.

ParentRef_FullName String False

The full name of the parent vendor type, if applicable. You may specify either ParentRef_FullName or ParentRef_ListId when inserting or updating, but not both.

ParentRef_ListId String False

VendorTypes.ID

255

The unique identifier of the parent vendor type, if applicable. You may specify either ParentRef_FullName or ParentRef_ListId when inserting or updating, but not both.

Sublevel Integer True

Indicates the depth of the vendor type in the hierarchy, where 0 represents a top-level vendor type and higher numbers indicate sublevels.

EditSequence String True 16

A string used for versioning to indicate the revision of this vendor type record.

TimeCreated Datetime True

The date and time when the vendor type record was created, formatted as YYYY-MM-DD HH:MM:SS.

TimeModified Datetime True

The date and time when the vendor type record was last modified, formatted as YYYY-MM-DD HH:MM:SS.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175