Logs_Haynes_StrB2BGetVehicleByVRM Tables

The logs_haynes_strB2BGetVehicleByVRM_latest and logs_haynes_strB2BGetVehicleByVRM_changelog tables stores the requests and responses of each strB2BGetVehicleByVRM haynes pro API call made, including errors and api timestamps.

---

🔹 Standard Columns

Column Name	Data Type	Nullable	Description
document_name	STRING	YES	Name of the Firestore document
document_event_id	STRING	YES	Unique ID representing the document event (change ID)
document_timestamp	TIMESTAMP	YES	Timestamp when the document event occurred
document_operation	STRING	YES	Type of Firestore operation (e.g., CREATE, UPDATE, DELETE)
document_id	STRING	YES	ID of the Firestore document
apiCallTimeInMilliSeconds	INT64	YES	Time taken to complete the API call in milliseconds
context	STRING	YES	Context of the log (e.g., module or feature name)
level	STRING	YES	Log level
year	STRING	YES	year of the API call
month	STRING	YES	month of the API call
day	STRING	YES	day of the API call
documentId	STRING	YES	unique document id in firebase

---

🔸 Struct Columns

request

Column Name	Data Type	Nullable	Description
message	STRING	YES	Description of the request
payload.strKey1	STRING	YES	Authentication key used in the request
payload.strPassword	STRING	YES	Password associated with the username
payload.strUserName	STRING	YES	Username for authentication
payload.strVRM	STRING	YES	Vehicle Registration Mark (VRM) being looked up
payload.strVersion	STRING	YES	Version of the payload/request format
timestamp	INT64	YES	Timestamp of the request (in Unix time)

response

Column Name	Data Type	Nullable	Description
message	STRING	YES	Response message
timestamp	INT64	YES	Timestamp of the response (in Unix time)
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.BOID	STRING	YES	Business object ID
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.CreationDateTime	STRING	YES	Creation timestamp
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Destination.AreaNumber	STRING	YES	Destination area number
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Destination.DealerCountry	STRING	YES	Destination dealer country
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Destination.DealerNumber	STRING	YES	Destination dealer number
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Destination.DestinationNameCode	STRING	YES	Destination name code
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Destination.DestinationSoftware	STRING	YES	Destination software
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Destination.DestinationSoftwareCode	STRING	YES	Destination software code
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Destination.DestinationURI	STRING	YES	Destination URI
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Destination.StoreNumber	STRING	YES	Destination store number
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.AreaNumber	STRING	YES	Sender area number
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.AuthorizationId	STRING	YES	Authorization ID
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.Component	STRING	YES	Sender component
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.CreatorNameCode	STRING	YES	Sender creator name code
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.DealerCountry	STRING	YES	Sender dealer country
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.DealerNumber	STRING	YES	Sender dealer number
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.DeliverPendingMailInd	STRING	YES	Deliver pending mail indicator
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.Language	STRING	YES	Sender language
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.LogicalId	STRING	YES	Logical ID
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.Password	STRING	YES	Sender password
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.ReferenceId	STRING	YES	Sender reference ID
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.SenderNameCode	STRING	YES	Sender name code
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.SenderURI	STRING	YES	Sender URI
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.StoreNumber	STRING	YES	Sender store number
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.SystemVersion	STRING	YES	System version
data.strB2BGetVehicleByVRMResult.VRRError.ApplicationArea.Sender.Task	STRING	YES	Task name or ID
data.strB2BGetVehicleByVRMResult.VRRError.DataArea.Error.Details.ErrorCode	STRING	YES	Error code
data.strB2BGetVehicleByVRMResult.VRRError.DataArea.Error.Details.ErrorDescription	STRING	YES	Error description
data.strB2BGetVehicleByVRMResult.VRRError.DataArea.Error.Details.ErrorDetails	STRING	YES	Detailed error message
data.strB2BGetVehicleByVRMResult.VRRError.DataArea.Error.Details.ErrorSeverity	STRING	YES	Severity of the error
data.strB2BGetVehicleByVRMResult.VRRError.DataArea.Error.Details.ErrorSource	STRING	YES	Source of the error
data.strB2BGetVehicleByVRMResult.VRRError.DataArea.Error.Header.DocumentDateTime	STRING	YES	Document timestamp in header
data.strB2BGetVehicleByVRMResult.VRRError.attributes.environment	STRING	YES	Environment in which the error occurred
data.strB2BGetVehicleByVRMResult.VRRError.attributes.lang	STRING	YES	Language used
data.strB2BGetVehicleByVRMResult.VRRError.attributes.release	STRING	YES	Release version

timestamp

Column Name	Data Type	Nullable	Description
seconds	INT64	YES	Seconds since Unix epoch
nanoseconds	INT64	YES	Nanoseconds part of the timestamp

error

Column Name	Data Type	Nullable	Description
data	STRING	YES	Additional error data
message	STRING	YES	Error message
name	STRING	YES	Name/type of the error
stack	STRING	YES	Stack trace of the error
timestamp	TIMESTAMP	YES	Timestamp when the error occurred

---