Delivery_Challan table

Column Type

Deliverychallan_Id

String

Last_Modified_Time

Timestamp

Total

Number

Customer_Name

String

Date

String

Zcrm_Potential_Id

String

Status

String

Bcy_Total

Number

Zcrm_Potential_Name

String

Customer_Id

String

Company_Name

String

Challan_Status

String

Currency_Code

String

Deliverychallan_Number

String

Reference_Number

String

Currency_Id

String

Created_Time

Timestamp

Has_Attachment

Boolean

Tax_Rounding

String

Tax_Total

Number

Created_By_Id

String

Currency_Symbol

String

Has_Qty_Returned

Boolean

Tax_Treatment

String

Sub_Total

Number

Tax_Reg_No

String

Challan_Type

String

Place_Of_Supply

String

Discount_Applied_On_Amount

Number

Is_Inclusive_Tax

Boolean

Discount

Number

Discount_Type

String

Page_Height

String

Is_Taxable

String

Exchange_Rate

Number

Page_Width

String

Is_Discount_Before_Tax

Boolean

Source

String

Sub_Total_Inclusive_Of_Tax

Number

Adjustment

Number

Adjustment_Description

String

Transaction_Rounding_Type

String

Price_Precision

Number

Template_Id

String

Shipping_Address_Address

String

Shipping_Address_Zip

String

Shipping_Address_City

String

Shipping_Address_Street2

String

Shipping_Address_State

String

Shipping_Address_Country

String

Shipping_Address_Fax

String

Shipping_Address_Attention

String

Shipping_Address_Phone

String

Notes

String

Template_Type

String

Terms

String

Template_Name

String

Orientation

String

Attachment_Name

String

Discount_Amount

String

Is_Pre_Gst

String

Invoice_Conversion_Type

String

Gst_No

String

Gst_Treatment

String

Tax_Specification

String

Is_Eway_Bill_Required

String

Line_Items

Array

Taxes

Array

Documents

Array

Contact_Persons

Array

Ewaybills

String

Examples

INSERT INTO
    Delivery_Challan (
        [date],
        challan_type,
        reference_number,
        currency_code,
        customer_id,
        tax_treatment,
        place_of_supply,
        line_items
    )
VALUES
    (
        '2024-09-01',
        'job work',
        'DelChallan2',
        'BHD',
        '633066000000053001',
        'vat_registered',
        'BH',
        '{"description":"A5 Notepad","rate":9.99,"quantity":3}'
    )
DELETE FROM Delivery_Challan
WHERE
    deliverychallan_id = '633066000000051395'