Skip to main content
Aria Knowledge Central

Snowflake VC Object: Service Locations

► Service Locations




CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID TEXT EVENT_ID for the change JSON record
CREATETIME NUMBER CREATETIME createtime of the changed JSON record
ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record.
SERVICE_LOCATION_NO NUMBER The unique identifier for the service location.
CLIENT_SERVICE_LOCATION_ID TEXT The client_service_location_id for the referenced record.
NAME TEXT The service location name.
IS_ACTIVE BOOLEAN Is the refernced data active?
TAX_ENGINE_SPECIFIC_LOCATION_ID TEXT Denotes a unique tax engine specific identifier.
COMPANY_NAME TEXT The legal company name of the entity referenced in the data.
STREET VARIANT The street address of the referenced data.
CITY TEXT The city address of the referenced data.
COUNTY TEXT The county of the referenced data.
LOCALITY TEXT The locality for the referenced record. 
STATE_PROV TEXT The state or province address of the referenced data.
COUNTRY_CD TEXT The ISO country code of the address of the referenced data.
POSTAL_CODE TEXT The postal code of the address of the referenced data.
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data.
  • Was this article helpful?