Snowflake VC Object: Service Locations

Last updated
Save as PDF

► Service Locations

Field	Datatype	Description
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.