order_item_id | Primary key. Unique order line identifier. |
distributor_ahn | Vetcove distributor AHN (constant NPWP4FGSA). |
warehouse_ahn | Fulfillment warehouse AHN for the line. |
manufacturer_ahn | AHN for the item’s manufacturer. Prefers product line override when set. |
invoice_date | Reporting invoice date: ship/tracker date when available, else first sent-to-vendor time. |
invoice_number | Line-level invoice identifier (order_item_id). |
bill_to_ahn | Bill-to AHN: clinic billing address, else group billing via primary tag, else primary ship-to. |
ship_to_ahn | Ship-to AHN on the clinic’s primary address. |
order_number | Parent order id. |
ship_to_zip | Postal code for the primary ship-to address. |
bill_to_zip | Postal code for the bill-to address. |
product_id | Catalog product SKU (vetcove_sku). |
quantity | Quantity ordered on the line. |
unit_price | Vendor unit cost per ordered unit in dollars. |
monetary_amount | Line total in dollars: unit_price x quantity. |
promotional_code | AUTOSHIP for subscription-created orders; otherwise empty. |
order_id | Parent checkout order id. |
order_placed_date | Calendar date the parent order was placed. |
clinic_id | Clinic that owns the order. |
clinic_name | Clinic display name. |
corporate_group_name | Corporate group label for the clinic. |
manufacturer_name | Manufacturer name on the catalog item. |
manufacturer_id | Catalog manufacturer id. |
manufacturer_no | Manufacturer or vendor-specific item identifier. |
full_item_name | Long concatenated item label (product line, product, item). |
vendor_name | Name of the vendor fulfilling this HD line. |
vendor_id | Fulfilling vendor id. |
shipment_delivered_date | When the shipment was marked delivered, from tracking. |
is_autoship | True if this line is tied to a subscription order. |
autoship_number | Human-readable autoship subscription number. |
first_or_subsequent_autoship | Whether this is the first or a later autoship cycle. |
item_cost_to_clinic | Total vendor cost for this line in dollars. |
vetcove_buyer_id | Clinic’s Vetcove buyer identifier. |
clinic_address_one | First line of the clinic’s primary mailing address. |
clinic_city | City on the clinic primary address. |
clinic_state | State on the clinic primary address. |
clinic_postal_code | Postal code on the clinic primary address. |
clinic_region | Region on the clinic primary address. |
clinic_phone_number | Primary phone on the clinic record. |
shipment_date | Operational ship date: first tracker timestamp on the line. |
ndc | National Drug Code for the catalog item. |
primary_category_name | Primary product category. |
secondary_category_name | Secondary product category. |
vendor_sku | Vendor-specific SKU for the item. |
all_species | Species the item is approved for. |
upc | Universal Product Code for the catalog item. |
product_line_name | Product line name from the catalog. |
