Nexus

Columns

Name Type Length Precision Scale References In Description
country VARCHAR2 100 Country name
date_valid_since TIMESTAMP This field is no longer supported
date_valid_until TIMESTAMP This field is no longer supported
description VARCHAR2 100 Description
hierarchy_level NUMBER 39 0 This field is no longer supported.
is_inactive VARCHAR2 3 Nexus is inactive. This field is available only if the SuiteTax feature is enabled in your account.
is_tax_date_from_fulfillment VARCHAR2 3
nexus_id NUMBER 39 0 Nexus ID
parent_id NUMBER 39 0 Parent ID. This field is available only if the SuiteTax feature is enabled in your account.
state VARCHAR2 20 State
tax_agency_id NUMBER 39 0 First tax agency vendor ID. This field is available only if the SuiteTax feature is enabled in your account.
taxcode_id NUMBER 39 0 Tax code ID. This field is available only if the SuiteTax feature is disabled in your account.
vendtax1_id NUMBER 39 0 First tax agency vendor ID. This field is available only if the SuiteTax feature is disabled in your account.
vendtax2_id NUMBER 39 0 Second tax agency vendor ID. This field is available only if the SuiteTax feature is disabled in your account.

Primary key

PK Column Name
nexus_id