The Vendor Credit Log dataset provides a log of all the events that impact vendor credit balances, such as Vendor Credits Applied to Invoice Payments, Destroying and Returning of Product to Vendors, and the manual creation of Vendor Credit memos.
Primary Key: org_id
, store_id
, log_date
, log_action
, payment_id
store_id | The unique identifier for each store. Each store is tied to exactly one org_id |
org_id | The unique identifier for each retail organization consisting of one or more stores operating with Treez |
org_name | The name of the organization |
store_name | The name of the store where the sale was made |
selltreez_url | The URL of the SellTreez Point of Sale where the sale was made |
store_state | The US state where the store is located, abbreviated (e.g., CA, CO) |
store_timezone | The timezone in which the store operates. This is returned in the Olson format (i.e., America/Los_Angeles) |
datalake_store_id | The store identifier used in a legacy Treez data system |
log_date | The timestamp of the vendor credit log event |
store_tz_offset | This column represents the timezone offset of the store for the given log date |
log_action | The action that occurred in the vendor credit log. Examples include "Vendor Credit Applied", "Product Destroyed", "Manual Credit Created", "Vendor Credit Reversed", "Product Returned To Vendor", "Manual Credit Reverted" |
payment_amount | The amount of currency involved in the vendor credit log event. This can be a positive or negative value |
credit_balance | The balance of the vendor credit account after the vendor credit log event |
distributor_id | The unique identifier for the distributor associated with the vendor credit log event |
distributor_name | The name of the distributor associated with the vendor credit log event |
distributor_license | The license number of the distributor associated with the vendor credit log event |
payment_id | The unique identifier for each payment associated with the vendor credit log event. This ID is used to track individual payments. This correlates with the credit_note_id found in the inventory log dataset |
user_id | The store-level unique identifier of the user who conducted the vendor credit event |
user_mso_id | The organization-level unique identifier of the user who conducted the vendor credit event |
user_employee_number | The employee number on the employee profile of the user who conducted the vendor credit event |
user_name | The username on the employee profile of the user who conducted the vendor credit event |
invoice_id | The unique identifier for the invoice associated with the vendor credit log event. This ID is used to track the invoice associated with the event |
invoice_number | The human-readable invoice number associated with the vendor credit log event |
invoice_external_id | The external identifier for the invoice associated with the vendor credit log event |
invoice_line_id | The unique identifier of a given invoice line item associated with a vendor credit event. Not all credit events are tied to a specific invoice line id |
last_sync | A timestamp field that records the last time the data was synchronized into the Treez Data Warehouse. This is useful for tracking data changes and updates. To check for new or changed records, query for records where the last_sync timestamp is greater than the greatest timestamp in your data store |
record_loaded_at | This column represents the timestamp when the record in the database was last updated, encoded in the store's local time zone |