1. Invoicing
  2. Orders

Orders

orders
copy
Click to Copy

Related Tables

Tables referencing orders.id
resent_orders order_linked_credit_notes order_line_item_discounts order_line_items order_line_item_taxes

Columns

No match found
id string, not null
Primary Key
subscription_id string, null
Foreign Key subscriptions.id
invoice_id string, null
Foreign Key invoices.id
customer_id string, null
Foreign Key customers.id
business_entity_id string, null
Foreign Key business_entities.id
amount_adjusted long, null
amount_paid long, null
batch_id string, null
billing_address_city string, null
billing_address_company string, null
billing_address_country string, null
billing_address_email string, null
billing_address_first_name string, null
billing_address_last_name string, null
billing_address_line1 string, null
billing_address_line2 string, null
billing_address_line3 string, null
billing_address_phone string, null
billing_address_state string, null
billing_address_state_code string, null
billing_address_validation_status string, null, default=not_validated
billing_address_zip string, null
cancellation_reason string, null
cancelled_at timestamp, null
created_at timestamp, not null
created_by string, null
currency_code string, null
delivered_at timestamp, null
discount long, null
document_number string, null
fulfillment_status string, null
gift_id string, null
gift_note string, null
invoice_round_off_amount long, null
is_gifted boolean, null, default=false
is_resent boolean, not null, default=false
note string, null
order_date timestamp, null
order_type string, null
original_order_id string, null
payment_status string, null
price_type string, not null, default=tax_exclusive
reference_id string, null
refundable_credits long, null
refundable_credits_issued long, null
resend_reason string, null
resent_status string, null
resource_version long, null
rounding_adjustement long, null
shipment_carrier string, null
shipped_at timestamp, null
shipping_address_city string, null
shipping_address_company string, null
shipping_address_country string, null
shipping_address_email string, null
shipping_address_first_name string, null
shipping_address_index null
shipping_address_last_name string, null
shipping_address_line1 string, null
shipping_address_line2 string, null
shipping_address_line3 string, null
shipping_address_phone string, null
shipping_address_state string, null
shipping_address_state_code string, null
shipping_address_validation_status string, null, default=not_validated
shipping_address_zip string, null
shipping_cut_off_date timestamp, null
shipping_date timestamp, null
status string, null, default=new
status_update_at timestamp, null
sub_total long, null
tax long, null
total long, null
tracking_id string, null
tracking_url string, null
updated_at timestamp, null