Windsor brings all your ShipHero data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

ShipHero Field Reference

Sample

https://connectors.windsor.ai/shiphero?api_key=[your API key]&date_preset=last_7d&fields=date,bill_id,bill_status,bill_customer_name,bill_profile_name,bill_created_at,bill_due_date,bill_amount,bill_billing_period_start,bill_billing_period_end,bill_billing_frequency

Fields

ID	Type	Name	Description	Report
account_id	TEXT	Account ID	The Account ID
account_name	TEXT	Account Name	The Account Name
bill_amount	TEXT	Bill Amount	Bill Amount	bills
bill_billing_frequency	TEXT	Billing Frequency	Billing Frequency	bills
bill_billing_period_end	TEXT	Billing Period End	Billing Period End	bills
bill_billing_period_start	TEXT	Billing Period Start	Billing Period Start	bills
bill_created_at	DATE	Bill Created Date	Bill Created At	bills
bill_customer_name	TEXT	Bill Customer Name	Bill Customer Name	bills
bill_due_date	DATE	Bill Due Date	Bill Due Date	bills
bill_id	TEXT	Bill ID	Bill ID	bills
bill_profile_name	TEXT	Bill Profile Name	Bill Profile Name	bills
bill_status	TEXT	Bill Status	Bill Status	bills
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	Created Date
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
order_account_id	TEXT	Order Account ID	Order Account ID	orders
order_adult_signature_required	BOOLEAN	Order Adult Signature Required	Order Adult Signature Required	orders
order_alcohol	BOOLEAN	Order Alcohol	Order Alcohol	orders
order_allocation_priority	NUMERIC	Order Allocation Priority	Order Allocation Priority	orders
order_allow_partial	BOOLEAN	Order Allow Partial	Order Allow Partial	orders
order_allow_split	BOOLEAN	Order Allow Split	Order Allow Split	orders
order_auto_print_return_label	BOOLEAN	Order Auto Print Return Label	Order Auto Print Return Label	orders
order_billing_address_address1	TEXT	Order Billing Address Address1	Order Billing Address Address1	orders
order_billing_address_address2	TEXT	Order Billing Address Address2	Order Billing Address Address2	orders
order_billing_address_city	CITY	Order Billing Address City	Order Billing Address City	orders
order_billing_address_company	TEXT	Order Billing Address Company	Order Billing Address Company	orders
order_billing_address_country	COUNTRY	Order Billing Address Country	Order Billing Address Country	orders
order_billing_address_country_code	COUNTRY	Order Billing Address Country Code	Order Billing Address Country Code	orders
order_billing_address_email	TEXT	Order Billing Address Email	Order Billing Address Email	orders
order_billing_address_first_name	TEXT	Order Billing Address First Name	Order Billing Address First Name	orders
order_billing_address_last_name	TEXT	Order Billing Address Last Name	Order Billing Address Last Name	orders
order_billing_address_phone	TEXT	Order Billing Address Phone	Order Billing Address Phone	orders
order_billing_address_state	TEXT	Order Billing Address State	Order Billing Address State	orders
order_billing_address_state_code	TEXT	Order Billing Address State Code	Order Billing Address State Code	orders
order_billing_address_zip	TEXT	Order Billing Address Zip	Order Billing Address Zip	orders
order_box_name	TEXT	Order Box Name	Order Box Name	orders
order_currency	TEXT	Order Currency	Order Currency	orders
order_custom_invoice_url	TEXT	Order Custom Invoice Url	Order Custom Invoice Url	orders
order_date	DATE	Order Date	Order Date	orders
order_dry_ice_weight_in_lbs	TEXT	Order Dry Ice Weight In Lbs	Order Dry Ice Weight In Lbs	orders
order_email	TEXT	Order Email	Order Email	orders
order_expected_weight_in_oz	TEXT	Order Expected Weight In Oz	Order Expected Weight In Oz	orders
order_flagged	BOOLEAN	Order Flagged	Order Flagged	orders
order_ftr_exemption	NUMERIC	Order Ftr Exemption	Order Ftr Exemption	orders
order_fulfillment_status	TEXT	Order Fulfillment Status	Status of the order (pending, fulfilled, cancelled, etc)	orders
order_gift_invoice	BOOLEAN	Order Gift Invoice	Order Gift Invoice	orders
order_gift_note	TEXT	Order Gift Note	Order Gift Note	orders
order_has_dry_ice	BOOLEAN	Order Has Dry Ice	Order Has Dry Ice	orders
order_hold_until_date	DATE	Order Hold Until Date	Order Hold Until Date	orders
order_holds_address_hold	BOOLEAN	Order Address Hold	Order Address Hold	orders
order_holds_client_hold	BOOLEAN	Order Client Hold	Order Client Hold	orders
order_holds_fraud_hold	BOOLEAN	Order Fraud Hold	Order Fraud Hold	orders
order_holds_operator_hold	BOOLEAN	Order Operator Hold	Order Operator Hold	orders
order_holds_payment_hold	BOOLEAN	Order Payment Hold	Order Payment Hold	orders
order_holds_shipping_method_hold	BOOLEAN	Order Shipping Method Hold	Order Shipping Method Hold	orders
order_id	TEXT	Order ID	Order ID	orders
order_ignore_address_validation_errors	BOOLEAN	Order Ignore Address Validation Errors	Order Ignore Address Validation Errors	orders
order_incoterms	TEXT	Order Incoterms	Order Incoterms	orders
order_insurance	BOOLEAN	Order Insurance	Order Insurance	orders
order_insurance_amount	TEXT	Order Insurance Amount	Order Insurance Amount	orders
order_legacy_id	NUMERIC	Order Legacy ID	Order Legacy ID	orders
order_number	TEXT	Order Number	The store's internal order number	orders
order_packing_note	TEXT	Order Packing Note	Order Packing Note	orders
order_partner_order_id	TEXT	Order Partner Order ID	The order ID assigned by the storefront	orders
order_priority_flag	BOOLEAN	Order Priority Flag	Order Priority Flag	orders
order_profile	TEXT	Order Profile	Order Profile	orders
order_require_signature	BOOLEAN	Order Require Signature	Order Require Signature	orders
order_required_ship_date	DATE	Order Required Ship Date	Order Required Ship Date	orders
order_saturday_delivery	BOOLEAN	Order Saturday Delivery	Order Saturday Delivery	orders
order_shipping_address_address1	TEXT	Order Shipping Address Address1	Order Shipping Address Address1	orders
order_shipping_address_address2	TEXT	Order Shipping Address Address2	Order Shipping Address Address2	orders
order_shipping_address_city	CITY	Order Shipping Address City	Order Shipping Address City	orders
order_shipping_address_company	TEXT	Order Shipping Address Company	Order Shipping Address Company	orders
order_shipping_address_country	COUNTRY	Order Shipping Address Country	Order Shipping Address Country	orders
order_shipping_address_country_code	COUNTRY	Order Shipping Address Country Code	Order Shipping Address Country Code	orders
order_shipping_address_email	TEXT	Order Shipping Address Email	Order Shipping Address Email	orders
order_shipping_address_first_name	TEXT	Order Shipping Address First Name	Order Shipping Address First Name	orders
order_shipping_address_last_name	TEXT	Order Shipping Address Last Name	Order Shipping Address Last Name	orders
order_shipping_address_phone	TEXT	Order Shipping Address Phone	Order Shipping Address Phone	orders
order_shipping_address_state	TEXT	Order Shipping Address State	Order Shipping Address State	orders
order_shipping_address_state_code	TEXT	Order Shipping Address State Code	Order Shipping Address State Code	orders
order_shipping_address_zip	TEXT	Order Shipping Address Zip	Order Shipping Address Zip	orders
order_shipping_lines_carrier	TEXT	Order Shipping Lines Carrier	Order Shipping Lines Carrier	orders
order_shipping_lines_method	TEXT	Order Shipping Lines Method	Order Shipping Lines Method	orders
order_shipping_lines_price	TEXT	Order Shipping Lines Price	Order Shipping Lines Price	orders
order_shipping_lines_title	TEXT	Order Shipping Lines Title	Order Shipping Lines Title	orders
order_shop_name	TEXT	Order Shop Name	Order Shop Name	orders
order_skip_address_validation	BOOLEAN	Order Skip Address Validation	Order Skip Address Validation	orders
order_source	TEXT	Order Source	Order Source	orders
order_subtotal	NUMERIC	Order Subtotal	Order Subtotal	orders
order_tax_id	TEXT	Order Tax ID	Order Tax ID	orders
order_tax_type	TEXT	Order Tax Type	Order Tax Type	orders
order_third_party_shipper_account_number	TEXT	Order Third Party Shipper Account Number	Order Third Party Shipper Account Number	orders
order_third_party_shipper_country	COUNTRY	Order Third Party Shipper Country	Order Third Party Shipper Country	orders
order_third_party_shipper_zip	TEXT	Order Third Party Shipper Zip	Order Third Party Shipper Zip	orders
order_total_discounts	NUMERIC	Order Total Discounts	Order Total Discounts	orders
order_total_price	NUMERIC	Order Total Price	Order Total Price	orders
order_total_tax	TEXT	Order Total Tax	Order Total Tax	orders
order_updated_date	DATE	Order Updated Date	Order Updated Date	orders
product_account_id	TEXT	Product Account ID	Product Account ID	products
product_barcode	TEXT	Product Barcode	Product Barcode	products
product_country_of_manufacture	COUNTRY	Product Country Of Manufacture	Product Country Of Manufacture	products
product_created_at	DATE	Product Created At	Product Created At	products
product_customs_description	TEXT	Product Customs Description	Product Customs Description	products
product_customs_value	TEXT	Product Customs Value	Product Customs Value	products
product_dimensions_height	TEXT	Product Height	Height in unit configured in the account (In by default)	products
product_dimensions_length	TEXT	Product Length	Lenght in unit configured in the account (In by default)	products
product_dimensions_weight	TEXT	Product Weight	Weight in unit configured in the account (Oz by default)	products
product_dimensions_width	TEXT	Product Width	Width in unit configured in the account (In by default)	products
product_dropship	BOOLEAN	Product Dropship	Product Dropship	products
product_final_sale	BOOLEAN	Product Final Sale	Product Final Sale	products
product_id	TEXT	Product ID	Product ID	products
product_ignore_on_customs	BOOLEAN	Product Ignore On Customs	Product Ignore On Customs	products
product_ignore_on_invoice	BOOLEAN	Product Ignore On Invoice	Product Ignore On Invoice	products
product_kit	BOOLEAN	Product Kit	Product Kit	products
product_kit_build	BOOLEAN	Product Kit Build	Product Kit Build	products
product_large_thumbnail	TEXT	Product Large Thumbnail	Product Large Thumbnail	products
product_legacy_id	NUMERIC	Product Legacy ID	Product Legacy ID	products
product_name	TEXT	Product Name	Name of the product	products
product_needs_lot_tracking	BOOLEAN	Product Needs Lot Tracking	Product Needs Lot Tracking	products
product_needs_serial_number	BOOLEAN	Product Needs Serial Number	Product Needs Serial Number	products
product_no_air	BOOLEAN	Product No Air	Product No Air	products
product_not_owned	BOOLEAN	Product Not Owned	Product Not Owned	products
product_packer_note	TEXT	Product Packer Note	Product Packer Note	products
product_product_note	TEXT	Product Product Note	Product Product Note	products
product_sku	TEXT	Product Sku	Stock Keeping Unit	products
product_tariff_code	TEXT	Product Tariff Code	Product Tariff Code	products
product_thumbnail	TEXT	Product Thumbnail	Product Thumbnail	products
product_updated_at	DATE	Product Updated At	Product Updated At	products
product_virtual	BOOLEAN	Product Virtual	Product Virtual	products
purchase_order_account_id	TEXT	Purchase Order Account ID	Purchase Order Account ID	purchase_orders
purchase_order_arrived_at	DATE	Purchase Order Arrived At	Purchase Order Arrived At	purchase_orders
purchase_order_created_at	DATE	Purchase Order Created At	Purchase Order Created At	purchase_orders
purchase_order_date_closed	DATE	Purchase Order Date Closed	Purchase Order Date Closed	purchase_orders
purchase_order_description	TEXT	Purchase Order Description	Purchase Order Description	purchase_orders
purchase_order_discount	TEXT	Purchase Order Discount	Purchase Order Discount	purchase_orders
purchase_order_fulfillment_status	TEXT	Purchase Order Fulfillment Status	Purchase Order Fulfillment Status	purchase_orders
purchase_order_id	TEXT	Purchase Order ID	Purchase Order ID	purchase_orders
purchase_order_images	TEXT	Purchase Order Images	Purchase Order Images	purchase_orders
purchase_order_legacy_id	TEXT	Purchase Order Legacy ID	Purchase Order Legacy ID	purchase_orders
purchase_order_locked_by_user_id	TEXT	Purchase Order Locked By User ID	Purchase Order Locked By User ID	purchase_orders
purchase_order_locking	TEXT	Purchase Order Locking	Purchase Order Locking	purchase_orders
purchase_order_origin_of_shipment	TEXT	Purchase Order Origin Of Shipment	Purchase Order Origin Of Shipment	purchase_orders
purchase_order_packing_note	TEXT	Purchase Order Packing Note	Purchase Order Packing Note	purchase_orders
purchase_order_partner_order_number	TEXT	Purchase Order Partner Order Number	Purchase Order Partner Order Number	purchase_orders
purchase_order_payment_due_by	TEXT	Purchase Order Payment Due By	Purchase Order Payment Due By	purchase_orders
purchase_order_payment_method	TEXT	Purchase Order Payment Method	Purchase Order Payment Method	purchase_orders
purchase_order_payment_note	TEXT	Purchase Order Payment Note	Purchase Order Payment Note	purchase_orders
purchase_order_pdf	TEXT	Purchase Order Pdf	Purchase Order Pdf	purchase_orders
purchase_order_po_date	DATE	Purchase Order Po Date	Purchase Order Po Date	purchase_orders
purchase_order_po_note	TEXT	Purchase Order Po Note	Purchase Order Po Note	purchase_orders
purchase_order_po_number	TEXT	Purchase Order Po Number	Purchase Order Po Number	purchase_orders
purchase_order_ship_date	DATE	Purchase Order Ship Date	Purchase Order Ship Date	purchase_orders
purchase_order_shipping_carrier	TEXT	Purchase Order Shipping Carrier	Purchase Order Shipping Carrier	purchase_orders
purchase_order_shipping_method	TEXT	Purchase Order Shipping Method	Purchase Order Shipping Method	purchase_orders
purchase_order_shipping_name	TEXT	Purchase Order Shipping Name	Purchase Order Shipping Name	purchase_orders
purchase_order_shipping_price	TEXT	Purchase Order Shipping Price	Purchase Order Shipping Price	purchase_orders
purchase_order_subtotal	TEXT	Purchase Order Subtotal	Purchase Order Subtotal	purchase_orders
purchase_order_tax	TEXT	Purchase Order Tax	Purchase Order Tax	purchase_orders
purchase_order_total_price	TEXT	Purchase Order Total Price	Purchase Order Total Price	purchase_orders
purchase_order_tracking_number	TEXT	Purchase Order Tracking Number	Purchase Order Tracking Number	purchase_orders
purchase_order_vendor_id	TEXT	Purchase Order Vendor ID	Purchase Order Vendor ID	purchase_orders
purchase_order_warehouse_id	TEXT	Purchase Order Warehouse ID	Purchase Order Warehouse ID	purchase_orders
return_account_id	TEXT	Return Account ID	Return Account ID	returns
return_address_address1	TEXT	Return Address Address1	Address line 1	returns
return_address_address2	TEXT	Return Address Address2	Address line 2	returns
return_address_city	CITY	Return Address City	Address's City	returns
return_address_country	COUNTRY	Return Address Country	Address's Country	returns
return_address_name	TEXT	Return Address Name	The address's name or name of the person assigned to the address	returns
return_address_phone	TEXT	Return Address Phone	Return Address Phone	returns
return_address_state	TEXT	Return Address State	Address's State	returns
return_address_zip	TEXT	Return Address Zip	Address's Postal Code	returns
return_cost_to_customer	TEXT	Return Cost To Customer	Return Cost To Customer	returns
return_created_at	DATE	Return Created At	Return Created At	returns
return_dimensions_height	TEXT	Return Dimensions Height	Height in unit configured in the account (In by default)	returns
return_dimensions_length	TEXT	Return Dimensions Length	Lenght in unit configured in the account (In by default)	returns
return_dimensions_weight	TEXT	Return Dimensions Weight	Weight in unit configured in the account (Oz by default)	returns
return_dimensions_width	TEXT	Return Dimensions Width	Width in unit configured in the account (In by default)	returns
return_display_issue_refund	BOOLEAN	Return Display Issue Refund	Return Display Issue Refund	returns
return_id	TEXT	Return ID	Return ID	returns
return_label_cost	TEXT	Return Label Cost	Return Label Cost	returns
return_label_type	TEXT	Return Label Type	Return Label Type	returns
return_legacy_id	NUMERIC	Return Legacy ID	Return Legacy ID	returns
return_order_id	TEXT	Return Order ID	Return Order ID	returns
return_partner_id	TEXT	Return Partner ID	Return Partner ID	returns
return_reason	TEXT	Return Reason	Return Reason	returns
return_shipping_carrier	TEXT	Return Shipping Carrier	Return Shipping Carrier	returns
return_shipping_method	TEXT	Return Shipping Method	Return Shipping Method	returns
return_status	TEXT	Return Status	Return Status	returns
return_total_items_expected	NUMERIC	Return Total Items Expected	Return Total Items Expected	returns
return_total_items_received	NUMERIC	Return Total Items Received	Return Total Items Received	returns
return_total_items_restocked	NUMERIC	Return Total Items Restocked	Return Total Items Restocked	returns
shipment_address_address1	TEXT	Shipment Address Address1	Address line 1	shipments
shipment_address_address2	TEXT	Shipment Address Address2	Address line 2	shipments
shipment_address_city	CITY	Shipment Address City	Address's City	shipments
shipment_address_country	COUNTRY	Shipment Address Country	Address's Country	shipments
shipment_address_name	TEXT	Shipment Address Name	The address's name or name of the person assigned to the address	shipments
shipment_address_phone	TEXT	Shipment Address Phone	Shipment Address Phone	shipments
shipment_address_state	TEXT	Shipment Address State	Address's State	shipments
shipment_address_zip	TEXT	Shipment Address Zip	Address's Postal Code	shipments
shipment_completed	BOOLEAN	Shipment Completed	This field indicates if store was notified about the shipment. It should be 'true' by default and 'false' when using the Bulk Ship UI.	shipments
shipment_created_date	DATE	Shipment Created Date	Shipment Created Date	shipments
shipment_delivered	BOOLEAN	Shipment Delivered	Shipment Delivered	shipments
shipment_dropshipment	BOOLEAN	Shipment Dropshipment	Shipment Dropshipment	shipments
shipment_id	TEXT	Shipment ID	Shipment ID	shipments
shipment_legacy_id	NUMERIC	Shipment Legacy ID	Shipment Legacy ID	shipments
shipment_needs_refund	BOOLEAN	Shipment Needs Refund	Shipment Needs Refund	shipments
shipment_order_id	TEXT	Shipment Order ID	Shipment Order ID	shipments
shipment_pending_shipment_id	TEXT	Shipment Pending Shipment ID	Shipment Pending Shipment ID	shipments
shipment_picked_up	BOOLEAN	Shipment Picked Up	Shipment Picked Up	shipments
shipment_profile	TEXT	Shipment Profile	Shipment Profile	shipments
shipment_refunded	BOOLEAN	Shipment Refunded	Shipment Refunded	shipments
shipment_shipped_off_shiphero	BOOLEAN	Shipment Shipped Off Shiphero	Shipment Shipped Off Shiphero	shipments
shipment_total_packages	NUMERIC	Shipment Total Packages	Shipment Total Packages	shipments
shipment_user_id	TEXT	Shipment User ID	Shipment User ID	shipments
shipment_warehouse_id	TEXT	Shipment Warehouse ID	Shipment Warehouse ID	shipments
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
warehouse_product_account_id	TEXT	Warehouse Product Account ID	Warehouse Product Account ID	warehouse_products
warehouse_product_active	BOOLEAN	Warehouse Product Active	Warehouse Product Active	warehouse_products
warehouse_product_allocated	NUMERIC	Warehouse Product Allocated	Count of how many units you have in stock and owe to customers for open orders	warehouse_products
warehouse_product_available	NUMERIC	Warehouse Product Available	The number of available stock for any given SKU that is pushed to any connected sales channel. This is On Hand minus any allocations to open orders.	warehouse_products
warehouse_product_backorder	NUMERIC	Warehouse Product Backorder	Count of how many units you owe to customers for open orders and don’t have stock for in the warehouse	warehouse_products
warehouse_product_created_at	DATE	Warehouse Product Created At	Warehouse Product Created At	warehouse_products
warehouse_product_custom	BOOLEAN	Warehouse Product Custom	Warehouse Product Custom	warehouse_products
warehouse_product_customs_value	TEXT	Warehouse Product Customs Value	Warehouse Product Customs Value	warehouse_products
warehouse_product_id	TEXT	Warehouse Product ID	Warehouse Product ID	warehouse_products
warehouse_product_inventory_bin	TEXT	Warehouse Product Inventory Bin	The name of the bin where the product is stored	warehouse_products
warehouse_product_inventory_overstock_bin	TEXT	Warehouse Product Inventory Overstock Bin	The name of the bin where overstock is stored	warehouse_products
warehouse_product_legacy_id	NUMERIC	Warehouse Product Legacy ID	Warehouse Product Legacy ID	warehouse_products
warehouse_product_non_sellable_quantity	NUMERIC	Warehouse Product Non Sellable Quantity	Count of non sellable units of a SKU in the warehouse.	warehouse_products
warehouse_product_on_hand	NUMERIC	Warehouse Product On Hand	The total count of a SKU physically in the warehouse. (Note, Available is the count indicated in your sales channels)	warehouse_products
warehouse_product_price	TEXT	Warehouse Product Price	Price of the product	warehouse_products
warehouse_product_reorder_amount	NUMERIC	Warehouse Product Reorder Amount	The number that should be reordered when a SKU reaches the Reorder Level	warehouse_products
warehouse_product_reorder_level	NUMERIC	Warehouse Product Reorder Level	The Available value a SKU must reach to trigger a Reorder. (See Reorder Amount). Setting this to 0 will prevent a SKU from automatically being added to a PO	warehouse_products
warehouse_product_replenishment_level	NUMERIC	Warehouse Product Replenishment Level	Available only for accounts that use Dynamic Slotting and used specifically for replenishment reports. SKUs will appear on the replenishment report if inventory allocated and not enough in pickable bins, or if the pickable bin inventory is less than the replenishment level	warehouse_products
warehouse_product_reserve_inventory	NUMERIC	Warehouse Product Reserve Inventory	Count of a SKU that is not to be sold in your sales channel.For example, if you’re running a flash sale and want to hold some stock for returns or exchanges, you would enter your full inventory of say 100 units as the On Hand and a Reserve of 5 units. We’ll then tell the platform that you have 95 available for sale (On Hand minus Reserve). The Available count will remain 100	warehouse_products
warehouse_product_sell_ahead	NUMERIC	Warehouse Product Sell Ahead	Warehouse Product Sell Ahead	warehouse_products
warehouse_product_sku	TEXT	Warehouse Product Sku	Stock Keeping Unit	warehouse_products
warehouse_product_updated_at	DATE	Warehouse Product Updated At	Warehouse Product Updated At	warehouse_products
warehouse_product_value	TEXT	Warehouse Product Value	Price paid for the product	warehouse_products
warehouse_product_value_currency	TEXT	Warehouse Product Value Currency	Warehouse Product Value Currency	warehouse_products
warehouse_product_warehouse_id	TEXT	Warehouse Product Warehouse ID	Warehouse Product Warehouse ID	warehouse_products
warehouse_product_warehouse_identifier	TEXT	Warehouse Product Warehouse IDentifier	The warehouse identifier, usually Primary/Secondary	warehouse_products
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20