dotConnect for QuickBooks Online Documentation
In This Topic
    SYS_COLUMNS
    In This Topic

    The SYS_COLUMNS table lists available tables and their parameters. It has the following columns:

    Column Name

    Data Type

    Description

    TABLE_CATALOG VARCHAR(128) Top-level container for tables. Not used in dotConnect for QuickBooks Online. Always NULL.
    TABLE_SCHEMA VARCHAR(128) Second-level container for tables. Not used in dotConnect for QuickBooks Online. Always NULL.
    TABLE_NAME VARCHAR(128) The name of the QuickBooks Online object which the field belongs to.
    COLUMN_NAME VARCHAR(128) The name of a QuickBooks Online object field.
    ORDINAL_POSITION INT The position of the field in the object.
    COLUMN_DEFAULT TEXT Default value for the field.
    IS_NULLABLE VARCHAR(3) Indicates whether this field can be NULL ("YES" or "NO").
    DATA_TYPE VARCHAR(128)

    The data type of the field.

    CHARACTER_MAXIMUM_LENGTH INT The maximum length of the character or binary data that the field can contain in characters.
    CHARACTER_OCTET_LENGTH INT The maximum length of the character or binary data that the field can contain in bytes.
    NUMERIC_PRECISION INT The precision of numeric data.
    NUMERIC_PRECISION_RADIX INT The precision radix of numeric data.
    NUMERIC_SCALE INT The scale of numeric data.
    DATETIME_PRECISION INT Not used in dotConnect for QuickBooks Online. Always NULL.
    CHARACTER_SET_CATALOG VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    CHARACTER_SET_SCHEMA VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    CHARACTER_SET_NAME VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    COLLATION_CATALOG VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    COLLATION_SCHEMA VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    COLLATION_NAME VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    DOMAIN_CATALOG VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    DOMAIN_SCHEMA VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    DOMAIN_NAME VARCHAR(128) Not used in dotConnect for QuickBooks Online. Always NULL.
    ALLOWED_OPERATIONS INT

    Contains flag value that indicates which DML operations are allowed on this object and is the sum of the following flags

    • 1 - INSERT operations are allowed
    • 2 - UPDATE operations are allowed

    Zero value means none of the DML operations are allowed.

    HAS_DEFAULT BIT Indicates whether the field has the default value.
    IS_COMPUTED BIT Indicates whether the field is computed.
    IS_UNIQUE BIT Indicates whether the field must have unique values.
    DB_TYPE INT Numeric representation of the DbType value.
    NATIVE_TYPE INT For internal usage.
    API_NAME VARCHAR(128) The original name of the column, generated by QuickBooks Online.