Snowflake VC Object: Service Locations
- ► 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. Child Views Variant
Source Table
Child View Name
STREET SERVICE_LOCATIONS