POS Invoice
One sale rung up at a till: its lines, payments, customer and store. A till return is a POS Invoice with Is Return ticked.
Area: Till sales · Why it is here: openapi.yaml; contract fiscal_reader; guide chapter 01c; guide chapter 10; recipe customer_history_page; recipe duty_free_allowance; recipe gift_card_on_spend; recipe loyalty_provider; recipe lucky_draw; recipe portal; recipe post_sale_feedback; recipe receipt_format; recipe restaurant_back_office; recipe stock_alerts; recipe system_sync; recipe webhook_receiver; sample S13; sample S2; sample S22; sample S25; sample S3; sample S36; sample S4; sample S41; sample S43; sample S49; sample S52; sample S9; the MCP server; the feed client; the request collection; retail core · Fields: 219 · Submitted (booked) records: send docstatus: 1 to book it as you create it, or submit a draft with submit.
Read and write it
Every call runs as your app's own user, with its key in one header, at the retailer's own address. The user reads and writes only what its role allows: your app's user, and the rights the retailer gives it.
Read a list (only name unless you ask for fields):
curl -s "https://⟨site⟩/api/resource/POS%20Invoice?fields=%5B%22*%22%5D&limit_page_length=20" \
-H "Authorization: token ⟨api key⟩:⟨api secret⟩"
Read one, with its tables:
curl -s "https://⟨site⟩/api/resource/POS%20Invoice/⟨name⟩" -H "Authorization: token ⟨api key⟩:⟨api secret⟩"
Create one (the required fields first), if your app's role may:
curl -s -X POST "https://⟨site⟩/api/resource/POS%20Invoice" -H "Authorization: token ⟨api key⟩:⟨api secret⟩" \
-H "Content-Type: application/json" -d '{"naming_series": …, "company": …, "posting_date": …, "currency": …, "conversion_rate": …, "selling_price_list": …}'
Change one with PUT /api/resource/POS%20Invoice/⟨name⟩ and the fields you change; a table sent there replaces its rows, so send its existing rows too. All the record calls and their answers: the API reference.
Samples that use it
s1_warranty · s2_bins · s3_price_audit · s4_receipt_pack · s7_system_sync · s9_bi_feed · s13_portal · s22_customer_loyalty · s25_gift_on_spend · s27_stock_alerts · s28_merge_and_history · s30_units_as_serials · s32_coupon_rules · s36_duty_free · s39_pharmacy_counter · s40_expiry_recall · s41_regulated_register · s42_optical_prescriptions · s43_third_party_payer · s44_lucky_draw · s45_restaurant_back_office · s49_post_sale_feedback · s52_phone_plans
Fields
Read from the product at POS 2.1.0.667 (till app 60147699c): its own fields, the fields iVendNext adds to it, and iVendNext's changes to any of them. Read-only fields are set by iVendNext; a hidden one is not on the form but can be read. Every record also has name (its id, in the address), owner, creation, modified, modified_by and docstatus (0 a draft, 1 submitted, 2 cancelled), all read-only.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Title | title |
Data | yes | |||
| Series | naming_series |
Select | yes | one of: ACC-PSINV-.YYYY.- | ||
| Customer | customer |
Link | Customer | |||
| Customer Name | customer_name |
Data | yes | |||
| Tax Id | tax_id |
Data | yes | |||
| POS Profile | pos_profile |
Link | POS Profile | |||
| POS Opening Entry (added by iVendNext) | custom_pos_opening_entry |
Link | POS Opening Entry | |||
| POS Terminal (added by iVendNext) | custom_pos_terminal |
Data | yes | |||
| Sold on iVendNext POS (Till, Tablet or Phone) (added by iVendNext) | custom_retail_mpos_source |
Check | yes | |||
| Settle At Till (added by iVendNext) | custom_settle_at_register |
Link | POS Terminal | |||
| Consolidated Sales Invoice | consolidated_invoice |
Link | yes | Sales Invoice | ||
| Consolidated Credit Note (added by iVendNext) | custom_consolidated_credit_note |
Link | yes | Sales Invoice | ||
| Consolidated FulFillment Invoice (added by iVendNext) | custom_consolidated_fulfillment_invoice |
Link | yes | Sales Invoice | ||
| Include Payment (POS) | is_pos |
Check | yes | yes | ||
| Is Return (Credit Note) | is_return |
Check | ||||
| Update Billed Amount in Sales Order | update_billed_amount_in_sales_order |
Check | ||||
| Suspended (added by iVendNext) | custom_suspended |
Check | yes | |||
| Quotation (added by iVendNext) | custom_quotation |
Check | yes | |||
| Disabled (added by iVendNext) | custom_disabled |
Check | yes | |||
| Void Transaction (added by iVendNext) | custom_void_transaction |
Check | yes | |||
| Update Billed Amount in Delivery Note | update_billed_amount_in_delivery_note |
Check | ||||
| Company | company |
Link | yes | Company | ||
| Date | posting_date |
Date | yes | |||
| Posting Time | posting_time |
Time | ||||
| Edit Posting Date and Time | set_posting_time |
Check | ||||
| Payment Due Date | due_date |
Date | ||||
| Email (added by iVendNext) | custom_email |
Data | yes | |||
| Phone Number (added by iVendNext) | custom_phone_no |
Data | yes | |||
| Invoice UUID (added by iVendNext) | custom_invoice_uuid |
Data | yes | yes | ||
| Amended From | amended_from |
Link | yes | POS Invoice | ||
| Return Against | return_against |
Link | yes | POS Invoice | ||
| Deliver Against (added by iVendNext) | custom_deliver_against |
Link | yes | POS Invoice | ||
| Quotation Reference Number (added by iVendNext) | custom_quotation_reference_number |
Link | yes | Quotation | ||
| Is Table Visible (added by iVendNext) | custom_is_table_visible |
Check | ||||
| Project | project |
Link | Project | |||
| Cost Center | cost_center |
Link | Cost Center | |||
| Customer's Purchase Order | po_no |
Data | ||||
| Customer's Purchase Order Date | po_date |
Date | ||||
| Customer Address | customer_address |
Link | Address | |||
| Address | address_display |
Small Text | yes | |||
| Contact Person | contact_person |
Link | Contact | |||
| Contact | contact_display |
Small Text | yes | |||
| Mobile No | contact_mobile |
Data | yes | yes | ||
| Contact Email | contact_email |
Data | yes | |||
| Territory | territory |
Link | Territory | |||
| Shipping Address Name | shipping_address_name |
Link | Address | |||
| Shipping Address | shipping_address |
Small Text | yes | |||
| Company Address Name | company_address |
Link | Address | |||
| Company Address | company_address_display |
Small Text | yes | yes | ||
| Company Contact Person | company_contact_person |
Link | Contact | |||
| Currency | currency |
Link | yes | Currency | ||
| Exchange Rate | conversion_rate |
Float | yes | |||
| Price List | selling_price_list |
Link | yes | Price List | ||
| Price List Currency | price_list_currency |
Link | yes | yes | Currency | |
| Price List Exchange Rate | plc_conversion_rate |
Float | yes | |||
| Ignore Pricing Rule | ignore_pricing_rule |
Check | ||||
| Source Warehouse | set_warehouse |
Link | Warehouse | |||
| Update Stock | update_stock |
Check | ||||
| Scan Barcode | scan_barcode |
Data | ||||
| Transaction Mode (added by iVendNext) | transaction_mode |
Link | yes | POS Transaction Mode | ||
| Items | items |
Table | yes | POS Invoice Item | ||
| Pricing Rule Detail | pricing_rules |
Table | yes | Pricing Rule Detail | ||
| Packed Items | packed_items |
Table | Packed Item | |||
| Time Sheets | timesheets |
Table | Sales Invoice Timesheet | |||
| Total Billing Amount | total_billing_amount |
Currency | yes | |||
| Total Quantity | total_qty |
Float | yes | |||
| Total (Company Currency) | base_total |
Currency | yes | |||
| Net Total (Company Currency) | base_net_total |
Currency | yes | yes | ||
| GC Total (added by iVendNext) | custom_gc_total |
Currency | yes | |||
| Total | total |
Currency | yes | |||
| Net Total | net_total |
Currency | yes | |||
| Total Net Weight | total_net_weight |
Float | yes | |||
| Sales Taxes and Charges Template | taxes_and_charges |
Link | Sales Taxes and Charges Template | |||
| Shipping Rule | shipping_rule |
Link | Shipping Rule | |||
| Tax Category | tax_category |
Link | Tax Category | |||
| Item Surcharges (added by iVendNext) | custom_item_surcharges |
Table | yes | Item Surcharge | ||
| Sales Taxes and Charges | taxes |
Table | Sales Taxes and Charges | |||
| Taxes and Charges Calculation | other_charges_calculation |
Text Editor | yes | |||
| Total Taxes and Charges (Company Currency) | base_total_taxes_and_charges |
Currency | yes | |||
| Total Surcharge (added by iVendNext) | custom_total_surcharge |
Currency | yes | |||
| Head Surcharge (added by iVendNext) | custom_head_surcharge |
Currency | yes | |||
| Total Taxes and Charges | total_taxes_and_charges |
Currency | yes | |||
| Tax before Surcharge (added by iVendNext) | custom_tax_before_surcharge |
Currency | yes | |||
| Loyalty Points | loyalty_points |
Int | ||||
| Loyalty Amount | loyalty_amount |
Currency | yes | |||
| Redeem Loyalty Points | redeem_loyalty_points |
Check | ||||
| Points Available (added by iVendNext) | custom_points_available |
Int | yes | |||
| Points Redeemed (added by iVendNext) | custom_points_redeemed |
Int | ||||
| Amount Redeemed (added by iVendNext) | custom_amount_redeemed |
Currency | yes | |||
| Redeem Loyalty Points (added by iVendNext) | custom_redeem_loyalty |
Check | ||||
| Loyalty Program | loyalty_program |
Link | yes | Loyalty Program | ||
| Redemption Account | loyalty_redemption_account |
Link | Account | |||
| Redemption Cost Center | loyalty_redemption_cost_center |
Link | Cost Center | |||
| Loyalty Program (added by iVendNext) | custom_loyaltyprogram |
Link | yes | Loyalty Setup | ||
| Redemption Account (added by iVendNext) | custom_redemptionaccount |
Link | Account | |||
| Redeption Cost Center (added by iVendNext) | custom_redemptioncostcenter |
Link | Cost Center | |||
| Coupon Code | coupon_code |
Link | Coupon Code | |||
| Apply Additional Discount On | apply_discount_on |
Select | one of: Grand Total, Net Total | |||
| Additional Discount Amount (Company Currency) | base_discount_amount |
Currency | yes | |||
| Additional Discount Percentage | additional_discount_percentage |
Float | ||||
| Additional Discount Amount | discount_amount |
Currency | ||||
| Promotions (added by iVendNext) | custom_promotions |
Table | yes | Transaction Promotion Bonus Buys Detail | ||
| Coupons (added by iVendNext) | custom_coupons |
Table | yes | Transaction Coupon | ||
| Grand Total (Company Currency) | base_grand_total |
Currency | yes | yes | ||
| Rounding Adjustment (Company Currency) | base_rounding_adjustment |
Currency | yes | |||
| Rounded Total (Company Currency) | base_rounded_total |
Currency | yes | |||
| In Words (Company Currency) | base_in_words |
Data | yes | |||
| Grand Total | grand_total |
Currency | yes | yes | ||
| Rounding Adjustment | rounding_adjustment |
Currency | yes | |||
| Rounded Total | rounded_total |
Currency | yes | |||
| Disable Rounded Total (added by iVendNext) | disable_rounded_total |
Check | ||||
| In Words | in_words |
Data | yes | |||
| Total Advance | total_advance |
Currency | yes | |||
| Outstanding Amount | outstanding_amount |
Currency | yes | |||
| Allocate Advances Automatically (FIFO) | allocate_advances_automatically |
Check | ||||
| Advances | advances |
Table | Sales Invoice Advance | |||
| Payment Terms Template | payment_terms_template |
Link | Payment Terms Template | |||
| Payment Schedule | payment_schedule |
Table | Payment Schedule | |||
| AR Payment (added by iVendNext) | custom_ar_payment |
Table | yes | AR Payment | ||
| Coupon Issue (added by iVendNext) | custom_coupon_issue |
Table | yes | Coupon Detail | ||
| AR Payment Total (added by iVendNext) | custom_ar_payment_total |
Currency | yes | |||
| Cash/Bank Account | cash_bank_account |
Link | yes | Account | ||
| Sales Invoice Payment | payments |
Table | Sales Invoice Payment | |||
| Paid Amount (Company Currency) | base_paid_amount |
Currency | yes | |||
| Paid Amount | paid_amount |
Currency | yes | |||
| Base Change Amount (Company Currency) | base_change_amount |
Currency | yes | |||
| Change Amount | change_amount |
Currency | ||||
| Account for Change Amount | account_for_change_amount |
Link | Account | |||
| Write Off Amount | write_off_amount |
Currency | ||||
| Tender Discount Amount (added by iVendNext) | custom_tender_discount_amount |
Currency | yes | |||
| Write Off Amount (Company Currency) | base_write_off_amount |
Currency | yes | |||
| Write Off Outstanding Amount | write_off_outstanding_amount_automatically |
Check | ||||
| Write Off Account | write_off_account |
Link | Account | |||
| Write Off Cost Center | write_off_cost_center |
Link | Cost Center | |||
| Lost Sale (added by iVendNext) | custom_lost_sale |
Table | Lost Sale | |||
| Terms | tc_name |
Link | Terms and Conditions | |||
| Terms and Conditions Details | terms |
Text Editor | ||||
| Letter Head | letter_head |
Link | Letter Head | |||
| Group same items | group_same_items |
Check | ||||
| Print Language | language |
Data | yes | |||
| Print Heading | select_print_heading |
Link | Print Heading | |||
| Inter Company Invoice Reference | inter_company_invoice_reference |
Link | yes | Purchase Invoice | ||
| Customer Group | customer_group |
Link | yes | Customer Group | ||
| Campaign | campaign |
Link | Campaign | |||
| Is Discounted | is_discounted |
Check | yes | |||
| Status | status |
Select | yes | one of: Draft, Return, Credit Note Issued, Consolidated, Submitted, Paid, Unpaid, Unpaid and Discounted, Overdue and Discounted, Overdue, Cancelled, Open … | ||
| Source | source |
Link | Lead Source | |||
| Debit To | debit_to |
Link | yes | Account | ||
| Party Account Currency | party_account_currency |
Link | yes | yes | Currency | |
| Is Opening Entry | is_opening |
Select | one of: No, Yes | |||
| Remarks | remarks |
Small Text | ||||
| Sales Partner | sales_partner |
Link | Sales Partner | |||
| Amount Eligible for Commission | amount_eligible_for_commission |
Currency | yes | |||
| Commission Rate (%) | commission_rate |
Float | ||||
| Total Commission | total_commission |
Currency | ||||
| Sales Team | sales_team |
Table | Sales Team | |||
| From Date | from_date |
Date | ||||
| To Date | to_date |
Date | ||||
| Auto Repeat | auto_repeat |
Link | yes | Auto Repeat | ||
| Against Income Account | against_income_account |
Small Text | yes | |||
| Buyer Tax ID (added by iVendNext) | custom_buyer_tax_id |
Data | ||||
| POS Idempotency Key (added by iVendNext) | custom_mpos_idempotency_key |
Data | yes | yes | ||
| Card Terminal (added by iVendNext) | custom_card_terminal_id |
Data | yes | yes | ||
| Employee Discount Value (added by iVendNext) | custom_mpos_employee_discount_value |
Currency | yes | yes | ||
| Card Terminal Reference (added by iVendNext) | custom_card_txn_ref |
Data | yes | yes | ||
| Fiscal Cancelled At Authority (added by iVendNext) | custom_ivn_fiscal_cancelled |
Check | yes | yes | ||
| POS Hand-off Offered To (added by iVendNext) | custom_mpos_offered_to |
Link | yes | User | ||
| POS Source Device (added by iVendNext) | custom_mpos_source_device |
Data | yes | yes | ||
| Fiscal Invoice Type (added by iVendNext) | custom_ivn_fiscal_invoice_type |
Data | yes | yes | ||
| Fiscal Submission Attempts (added by iVendNext) | custom_ivn_submission_attempts |
Int | yes | yes | ||
| POS Override Approvals Used (added by iVendNext) | custom_mpos_override_requests |
Small Text | yes | yes | ||
| Fiscal Original Reference (added by iVendNext) | custom_ivn_fiscal_original_ref |
Data | yes | yes | ||
| Fiscal QR (added by iVendNext) | custom_ivn_fiscal_qr |
Long Text | yes | yes | ||
| Fiscal Signature (added by iVendNext) | custom_ivn_fiscal_signature |
Code | yes | yes | ||
| Fiscal Reference (added by iVendNext) | custom_ivn_fiscal_ref |
Data | yes | yes | ||
| Fiscal Regime (added by iVendNext) | custom_ivn_fiscal_regime |
Data | yes | yes | ||
| Fiscal Response JSON (added by iVendNext) | custom_ivn_fiscal_response_json |
Long Text | yes | yes | ||
| Fiscal Status (added by iVendNext) | custom_ivn_fiscal_status |
Select | yes | yes | one of: PENDING, CLEARED, FAILED, REPORTED, NOT-FISCAL | |
| Call Number (added by iVendNext) | custom_mpos_call_number |
Data | yes | |||
| Service Mode (added by iVendNext) | custom_mpos_service_mode |
Data | yes | |||
| POS Cancel Reason (added by iVendNext) | custom_mpos_cancel_reason |
Small Text | yes | yes | ||
| Provisional Receipt Reference (added by iVendNext) | custom_mpos_provisional_ref |
Data | yes | |||
| Captured Offline At (added by iVendNext) | custom_mpos_captured_at |
Datetime | yes | |||
| Voucher Promised Offline, Not Issued (added by iVendNext) | custom_mpos_voucher_not_issued |
Small Text | yes | |||
| Open Check (added by iVendNext) | custom_mpos_check |
Link | yes | Retail Open Check | ||
| Coupon Taken Offline, Refused at Sync (added by iVendNext) | custom_mpos_coupon_refused |
Small Text | yes | |||
| POS Sale Discount % (added by iVendNext) | custom_mpos_sale_discount_pct |
Percent | yes | yes | ||
| POS Exchange Replacement (added by iVendNext) | custom_mpos_exchange_key |
Data | yes | yes | ||
| Kitchen Order (added by iVendNext) | custom_mpos_kitchen_ref |
Data | yes | |||
| Paid by Customer (added by iVendNext) | custom_mpos_patient_share |
Currency | yes | |||
| Returned Whole Only (added by iVendNext) | custom_mpos_payer_no_partial_refund |
Check | yes | |||
| Payer Answer (added by iVendNext) | custom_mpos_payer_answer |
Long Text | yes | yes | ||
| Payer Share Given Back (added by iVendNext) | custom_mpos_payer_back |
Currency | yes | |||
| Of It, Billed Back Earlier (added by iVendNext) | custom_mpos_payer_back_billed |
Currency | yes | |||
| Bill-Back Role (added by iVendNext) | custom_mpos_payer_bill_back_role |
Data | yes | |||
| Prescription Reference (added by iVendNext) | custom_mpos_payer_prescription |
Data | yes | |||
| Claim Reference (added by iVendNext) | custom_mpos_payer_claim_ref |
Data | yes | |||
| Billed to Payer (added by iVendNext) | custom_mpos_payer_share |
Currency | yes | |||
| Payer Clearing Account (added by iVendNext) | custom_mpos_payer_clearing_account |
Link | yes | Account | ||
| Payer Code (added by iVendNext) | custom_mpos_payer_code |
Data | yes | |||
| Plan (added by iVendNext) | custom_mpos_payer_plan |
Data | yes | |||
| Payer Journal (added by iVendNext) | custom_mpos_payer_journal |
Link | yes | Journal Entry | ||
| Payer Service (added by iVendNext) | custom_mpos_payer_subscription |
Data | yes | |||
| Payer (added by iVendNext) | custom_mpos_payer_customer |
Link | yes | Customer | ||
| Payer Name (added by iVendNext) | custom_mpos_payer_title |
Data | yes | |||
| Member Reference (added by iVendNext) | custom_mpos_payer_member |
Data | yes | |||
| Member (added by iVendNext) | custom_mpos_payer_member_label |
Data | yes | |||
| Prescriber (added by iVendNext) | custom_mpos_payer_prescriber |
Data | yes | |||
| Prescriber Licence (added by iVendNext) | custom_mpos_payer_prescriber_licence |
Data | yes | |||
| POS Sale Discount Amount (added by iVendNext) | custom_mpos_sale_discount_amt |
Currency | yes | yes | ||
| POS Basket (added by iVendNext) | custom_mpos_sale_ref |
Data | yes | yes | ||
| POS Recall Reference (added by iVendNext) | custom_pos_recall_reference |
Link | yes | POS Invoice | ||
| Printed (added by iVendNext) | custom_printed |
Check | yes | |||
| Reasons Code (added by iVendNext) | custom_reasons |
Table | yes | Item Reason Code | ||
| Sale Order reference number (added by iVendNext) | custom_sale_order_reference_number |
Link | yes | Sales Order | ||
| Valid Till (added by iVendNext) | custom_valid_till |
Date | yes | |||
| Fulfillment Plan Details (added by iVendNext) | custom_fulfillment_plan_details |
Table | Fulfillment Plan Details | |||
| POS Invoice Sale Attribute (added by iVendNext) | custom_pos_invoice_sale_attribute |
Table | POS Invoice Sale Attribute | |||
| POS Invoice Transaction Item Attribute (added by iVendNext) | custom_pos_invoice_transaction_item_attribute |
Table | POS Invoice Transaction Item Attribute |
Table: AR Payment
The rows of custom_ar_payment. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Type | type |
Select | yes | yes | one of: AR Payment, Advance Payment, AR-SO | |
| POS Invoice | pos_invoice |
Link | yes | POS Invoice | ||
| Sales Invoice | sales_invoice |
Link | yes | Sales Invoice | ||
| Selected Row | selected_row |
Check | yes | |||
| Invoice Total | invoice_total |
Currency | yes | |||
| Invoice Balance | invoice_balance |
Currency | yes | |||
| Allocated Amount | allocated_amount |
Currency | yes | yes |
Table: Coupon Detail
The rows of custom_coupon_issue. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Coupon Name | coupon |
Data | ||||
| Coupon Code | coupon_code |
Data | ||||
| Description | description |
Data | ||||
| Serial Number | serial_number |
Data | ||||
| Promotion Name | source_promotion_name |
Data | ||||
| Item Name | source_item_name |
Data |
Table: Fulfillment Plan Details
The rows of custom_fulfillment_plan_details. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| item | item |
Link | Item | |||
| Fulfillment Plan | fulfillment_plan |
Link | Fulfillment Plan | |||
| Qty | qty |
Float | ||||
| Rate | rate |
Currency | ||||
| Delivery Date | delivery_date |
Date | ||||
| Delivery Address | delivery_address |
Small Text | ||||
| Row No | row_no |
Int |
Table: Item Reason Code
The rows of custom_reasons. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Item Row Reference | item_row_reference |
Int | yes | |||
| Reason Code | reason_code |
Link | yes | Reason Code Master | ||
| Reason Type | reason_type |
Data | yes | |||
| Comment | comment |
Small Text | yes |
Table: Item Surcharge
The rows of custom_item_surcharges. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Item Code | sur_item_code |
Link | Item | |||
| For Item Row No. | sur_item_row_no |
Int | ||||
| Surcharge | sur_surcharge |
Link | yes | Surcharge | ||
| Default Surcharge Amount | sur_default_amount |
Float | ||||
| Surcharge Value | sur_surcharge_value |
Float | ||||
| Amount Before Tax | sur_amount_before_tax |
Float | ||||
| Total Tax | sur_total_tax |
Float | ||||
| Amount After Tax | sur_amount_after_tax |
Float | ||||
| Discountable | sur_is_discountable |
Check | ||||
| Refundable | sur_is_refundable |
Check | yes | |||
| Taxable | sur_is_taxable |
Check | ||||
| Load on Item Cost | sur_load_on_item_cost |
Check | ||||
| Is Multitax (added by iVendNext) | custom_is_multitax |
Check | yes | |||
| Amount Type | sur_amount_type |
Select | yes | one of: Flat Amount, Percentage | ||
| DIscount Type | sur_discount_type |
Select | one of: Flat Amount, Percentage | |||
| Flat Discount | sur_flat_discount |
Float | ||||
| Discount % | sur_discount_percent |
Percent | ||||
| Discount Given | sur_discount_given |
Float | ||||
| Tax Template | sur_tax_template |
Link | Item Tax Template | |||
| Tax Rate % | sur_tax_rate |
Percent | ||||
| Account Head | sur_account_head |
Link | Account | |||
| Sur Tax Account Head | sur_tax_account_head |
Link | yes | Account | ||
| Return | is_return |
Check | yes | |||
| Surcharge Total Tax Types (added by iVendNext) | custom_surcharge_total_tax_types |
Text | yes | |||
| Tax Detail | sur_tax_detail |
Long Text |
Table: Lost Sale
The rows of custom_lost_sale. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Item Code | item_code |
Link | Item |
Table: POS Invoice Item
The rows of items. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Barcode | barcode |
Data | ||||
| Has Item Scanned | has_item_scanned |
Check | yes | |||
| Transaction Mode (added by iVendNext) | transaction_mode |
Link | POS Transaction Mode | |||
| Original Transaction Mode (added by iVendNext) | custom_original_transaction_mode |
Link | yes | yes | POS Transaction Mode | |
| Fulfillment Option (added by iVendNext) | custom_fulfillment_option |
Data | yes | |||
| Selected Row (added by iVendNext) | selected_row |
Check | yes | |||
| Open Price (added by iVendNext) | custom_open_price |
Check | yes | |||
| Is weighted item (added by iVendNext) | custom_is_weighted_item |
Check | yes | |||
| Print as Gift Item (added by iVendNext) | custom_print_as_gift_item |
Check | yes | |||
| Item | item_code |
Link | Item | |||
| Item Name | item_name |
Data | yes | |||
| Customer's Item Code | customer_item_code |
Data | yes | yes | ||
| Gift Card Master (added by iVendNext) | custom_gift_card_master |
Link | yes | Gift Card Master | ||
| Gift Card Type (added by iVendNext) | custom_gift_card_type |
Data | yes | |||
| Gift Card Serial No (added by iVendNext) | custom_gift_card_serial_no |
Data | ||||
| Surcharge Amount (added by iVendNext) | custom_surcharge_amount |
Float | ||||
| Description | description |
Text Editor | yes | |||
| Item Group | item_group |
Link | yes | yes | Item Group | |
| Brand Name | brand |
Data | yes | |||
| Image | image |
Attach | yes | |||
| Quantity | qty |
Float | ||||
| Stock UOM | stock_uom |
Link | yes | UOM | ||
| UOM | uom |
Link | yes | UOM | ||
| UOM Conversion Factor | conversion_factor |
Float | yes | |||
| Qty as per Stock UOM | stock_qty |
Float | yes | |||
| Price List Rate | price_list_rate |
Currency | yes | |||
| Price List Rate (Company Currency) | base_price_list_rate |
Currency | yes | |||
| Margin Type | margin_type |
Select | one of: Percentage, Amount | |||
| Margin Rate or Amount | margin_rate_or_amount |
Float | ||||
| Rate With Margin | rate_with_margin |
Currency | yes | |||
| Discount (%) on Price List Rate with Margin | discount_percentage |
Percent | ||||
| Discount Amount | discount_amount |
Currency | ||||
| Total Discount Amount (added by iVendNext) | total_discount_amount |
Currency | yes | |||
| Rate With Margin (Company Currency) | base_rate_with_margin |
Currency | yes | |||
| Rate | rate |
Currency | yes | |||
| Amount | amount |
Currency | yes | yes | ||
| Barcode Masked (added by iVendNext) | custom_barcode_masked |
Check | yes | |||
| Label Total (added by iVendNext) | custom_barcode_mask_amount |
Currency | yes | |||
| Tender Discount Apportioned (added by iVendNext) | custom_tender_discount_apportioned |
Currency | yes | yes | ||
| Item Tax Template | item_tax_template |
Link | Item Tax Template | |||
| Rate (Company Currency) | base_rate |
Currency | yes | yes | ||
| Amount (Company Currency) | base_amount |
Currency | yes | yes | ||
| Pricing Rules | pricing_rules |
Small Text | yes | yes | ||
| Is Free Item | is_free_item |
Check | yes | |||
| Grant Commission | grant_commission |
Check | yes | |||
| Net Rate | net_rate |
Currency | yes | |||
| Net Amount | net_amount |
Currency | yes | |||
| Net Rate (Company Currency) | base_net_rate |
Currency | yes | |||
| Net Amount (Company Currency) | base_net_amount |
Currency | yes | |||
| Delivered By Supplier | delivered_by_supplier |
Check | yes | |||
| Income Account | income_account |
Link | yes | Account | ||
| Is Fixed Asset | is_fixed_asset |
Check | yes | yes | ||
| Asset | asset |
Link | Asset | |||
| Finance Book | finance_book |
Link | Finance Book | |||
| Expense Account | expense_account |
Link | Account | |||
| Deferred Revenue Account | deferred_revenue_account |
Link | Account | |||
| Service Stop Date | service_stop_date |
Date | ||||
| Enable Deferred Revenue | enable_deferred_revenue |
Check | ||||
| Service Start Date | service_start_date |
Date | ||||
| Service End Date | service_end_date |
Date | ||||
| Weight Per Unit | weight_per_unit |
Float | yes | |||
| Total Weight | total_weight |
Float | yes | |||
| Weight UOM | weight_uom |
Link | yes | UOM | ||
| Warehouse | warehouse |
Link | Warehouse | |||
| POS Fulfilment Mode (added by iVendNext) | custom_mpos_fulfilment_mode |
Select | yes | one of: Ship to Home, Collect at Store, Curbside | ||
| POS Fulfilment Store (added by iVendNext) | custom_mpos_fulfilment_store |
Link | yes | Warehouse | ||
| POS Ship-To Address (added by iVendNext) | custom_mpos_ship_to_address |
Small Text | yes | |||
| POS Ship-To Address Record (added by iVendNext) | custom_mpos_ship_to_address_link |
Link | yes | Address | ||
| Customer Warehouse (Optional) | target_warehouse |
Link | yes | Warehouse | ||
| Quality Inspection | quality_inspection |
Link | Quality Inspection | |||
| Serial and Batch Bundle | serial_and_batch_bundle |
Link | Serial and Batch Bundle | |||
| Use Serial No / Batch Fields | use_serial_batch_fields |
Check | ||||
| Allow Zero Valuation Rate | allow_zero_valuation_rate |
Check | ||||
| Item Tax Rate | item_tax_rate |
Small Text | yes | yes | ||
| Available Batch Qty at Warehouse | actual_batch_qty |
Float | yes | |||
| Available Qty at Warehouse | actual_qty |
Float | yes | |||
| Serial No | serial_no |
Text | ||||
| Batch No | batch_no |
Link | Batch | |||
| Sales Order | sales_order |
Link | yes | Sales Order | ||
| Sales Order Item | so_detail |
Data | yes | yes | ||
| POS Invoice Item | pos_invoice_item |
Data | yes | |||
| Cross sell parent line item name (added by iVendNext) | custom_cross_sell_parent_line_item_name |
Data | yes | |||
| Delivery Note | delivery_note |
Link | yes | Delivery Note | ||
| Delivery Note Item | dn_detail |
Data | yes | yes | ||
| Delivered Qty | delivered_qty |
Float | yes | |||
| Is fulfillment delivered (added by iVendNext) | custom_is_fulfillment_delivered |
Check | yes | |||
| Total Tax (added by iVendNext) | custom_total_tax |
Float | yes | |||
| Tax Total Breakup (added by iVendNext) | custom_tax_breakup |
Text | yes | |||
| Promotional Quantity (added by iVendNext) | custom_promotional_quantity |
Float | yes | |||
| Discount Source (added by iVendNext) | custom_discount_source |
Select | one of: System Discount, Manual Discount, Promotion Discount, Coupon Discount | |||
| Is fulfillment returned (added by iVendNext) | custom_is_fulfillment_returned |
Check | yes | |||
| Cost Center | cost_center |
Link | yes | Cost Center | ||
| Project | project |
Link | Project | |||
| Page Break | page_break |
Check | ||||
| Open Check Line (added by iVendNext) | custom_mpos_check_line |
Data | yes | yes | ||
| Supplier Funded Amount (added by iVendNext) | custom_mpos_funded_amount |
Currency | yes | |||
| Promotion Funded By (added by iVendNext) | custom_mpos_funded_by |
Link | yes | Supplier | ||
| Funded Promotion (added by iVendNext) | custom_mpos_funded_promotion |
Link | yes | Promotion Bonus Buys Master | ||
| POS Replaced List Price (added by iVendNext) | custom_mpos_list_rate |
Currency | yes | yes | ||
| Option Group (added by iVendNext) | custom_mpos_option_group |
Link | yes | Retail Option Group | ||
| Billed to Payer (added by iVendNext) | custom_mpos_payer_share |
Currency | yes | |||
| Paid by Customer (added by iVendNext) | custom_mpos_patient_share |
Currency | yes | |||
| Payer Covered Qty (added by iVendNext) | custom_mpos_payer_covered_qty |
Float | yes | |||
| Payer GTIN (added by iVendNext) | custom_mpos_payer_gtin |
Data | yes | |||
| Payer Share Given Back (added by iVendNext) | custom_mpos_payer_back |
Currency | yes | |||
| POS Pickup Handed At (added by iVendNext) | custom_mpos_pickup_handed_at |
Datetime | yes | |||
| POS Price Intent (added by iVendNext) | custom_mpos_price_intent |
Select | yes | one of: Open Price | ||
| POS Typed Price (added by iVendNext) | custom_mpos_typed_rate |
Currency | yes | yes | ||
| POS Partner Price Reason (added by iVendNext) | custom_mpos_price_reason |
Data | yes | |||
| POS Pickup Notified At (added by iVendNext) | custom_mpos_pickup_notified_at |
Datetime | yes | |||
| POS Pickup Status (added by iVendNext) | custom_mpos_pickup_status |
Select | yes | one of: Picking, Ready, Handed Over | ||
| POS Partner Price Percent Before (added by iVendNext) | custom_mpos_price_before_pct |
Percent | yes | |||
| POS Partner Price Cut (added by iVendNext) | custom_mpos_price_cut |
Currency | yes |
Table: POS Invoice Sale Attribute
The rows of custom_pos_invoice_sale_attribute. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Sale Attribute | sale_attribute |
Link | Sale Attribute | |||
| Attribute Value | attribute_value |
Data |
Table: POS Invoice Transaction Item Attribute
The rows of custom_pos_invoice_transaction_item_attribute. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Transaction Item Attribute | transaction_item_attribute |
Link | Transaction Item Attribute | |||
| Item Ref | item_ref |
Link | Item | |||
| Item ID Ref | item_id_ref |
Data | yes | |||
| Attribute Value | attribute_value |
Data | ||||
| Row No Ref | row_no_ref |
Int |
Table: Packed Item
The rows of packed_items. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Parent Item | parent_item |
Link | yes | Item | ||
| Item Code | item_code |
Link | yes | Item | ||
| Item Name | item_name |
Data | yes | |||
| Description | description |
Text Editor | ||||
| From Warehouse | warehouse |
Link | Warehouse | |||
| To Warehouse (Optional) | target_warehouse |
Link | Warehouse | |||
| Conversion Factor | conversion_factor |
Float | ||||
| Qty | qty |
Float | yes | |||
| Rate | rate |
Currency | yes | |||
| UOM | uom |
Link | yes | UOM | ||
| Use Serial No / Batch Fields | use_serial_batch_fields |
Check | ||||
| Serial and Batch Bundle | serial_and_batch_bundle |
Link | Serial and Batch Bundle | |||
| Serial No | serial_no |
Text | ||||
| Batch No | batch_no |
Link | Batch | |||
| Actual Batch Quantity | actual_batch_qty |
Float | yes | |||
| Actual Qty | actual_qty |
Float | yes | |||
| Projected Qty | projected_qty |
Float | yes | |||
| Ordered Qty | ordered_qty |
Float | yes | |||
| Packed Qty | packed_qty |
Float | yes | |||
| Incoming Rate | incoming_rate |
Currency | yes | |||
| Picked Qty | picked_qty |
Float | yes | |||
| Page Break | page_break |
Check | yes | |||
| Prevdoc DocType | prevdoc_doctype |
Data | yes | yes | ||
| Parent Detail docname | parent_detail_docname |
Data | yes | yes |
Table: Payment Schedule
The rows of payment_schedule. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Payment Term | payment_term |
Link | Payment Term | |||
| Description | description |
Small Text | ||||
| Due Date | due_date |
Date | yes | |||
| Mode of Payment | mode_of_payment |
Link | Mode of Payment | |||
| Invoice Portion | invoice_portion |
Percent | ||||
| Discount Type | discount_type |
Select | one of: Percentage, Amount | |||
| Discount Date | discount_date |
Date | ||||
| Discount | discount |
Float | ||||
| Payment Amount | payment_amount |
Currency | yes | |||
| Outstanding | outstanding |
Currency | yes | |||
| Paid Amount | paid_amount |
Currency | ||||
| Discounted Amount | discounted_amount |
Currency | yes | |||
| Payment Amount (Company Currency) | base_payment_amount |
Currency |
Table: Pricing Rule Detail
The rows of pricing_rules. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Pricing Rule | pricing_rule |
Link | yes | Pricing Rule | ||
| Item Code | item_code |
Data | yes | |||
| Margin Type | margin_type |
Data | yes | yes | ||
| Rate or Discount | rate_or_discount |
Data | yes | yes | ||
| Child Docname | child_docname |
Data | yes | yes | ||
| Rule Applied | rule_applied |
Check | yes |
Table: Sales Invoice Advance
The rows of advances. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Reference Type | reference_type |
Link | yes | DocType | ||
| Reference Name | reference_name |
Dynamic Link | yes | |||
| Remarks | remarks |
Text | yes | |||
| Reference Row | reference_row |
Data | yes | yes | ||
| Advance amount | advance_amount |
Currency | yes | |||
| Allocated amount | allocated_amount |
Currency | ||||
| Exchange Gain/Loss | exchange_gain_loss |
Currency | yes | |||
| Reference Exchange Rate | ref_exchange_rate |
Float | yes | |||
| Difference Posting Date | difference_posting_date |
Date |
Table: Sales Invoice Payment
The rows of payments. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Default | default |
Check | yes | yes | ||
| Mode of Payment | mode_of_payment |
Link | yes | Mode of Payment | ||
| Exchange Rate (added by iVendNext) | custom_exchange_rate |
Float | ||||
| Amount | amount |
Currency | yes | |||
| Transaction Amount (added by iVendNext) | custom_transaction_amount |
Currency | yes | |||
| Tender Discount Amount (added by iVendNext) | custom_tender_discount_amount |
Currency | yes | |||
| Reference No | reference_no |
Data | ||||
| Account | account |
Link | yes | Account | ||
| Currency (added by iVendNext) | custom_currency |
Link | yes | Currency | ||
| Type | type |
Read Only | yes | |||
| Base Amount (Company Currency) | base_amount |
Currency | yes | |||
| Clearance Date | clearance_date |
Date | yes | |||
| Credit Card Name (added by iVendNext) | custom_credit_card_name |
Data | yes | |||
| Card Last4 (added by iVendNext) | card_last4 |
Data | yes | |||
| Expiry Date (added by iVendNext) | custom_expiry_date |
Data | ||||
| Authorization Code (added by iVendNext) | card_authorization_code |
Data | yes | |||
| Reference No (added by iVendNext) | custom_reference_no |
Data | ||||
| Voucher No (added by iVendNext) | custom_voucher_no |
Data | ||||
| Cheque No (added by iVendNext) | custom_cheque_no |
Data | ||||
| Gift Certificate Type (added by iVendNext) | custom_gift_certificate_type |
Select | one of: System Generated, User Defined | |||
| Gift Certificate No (added by iVendNext) | custom_gift_certificate_no |
Link | Gift Card | |||
| Store Credit Gift Certificate Type (added by iVendNext) | custom_store_credit_gift_certificate_type |
Select | one of: System Generated, User Defined | |||
| Store Credit Gift Certificate No (added by iVendNext) | custom_store_credit_gift_certificate_no |
Data | ||||
| Remarks (added by iVendNext) | custom_remarks |
Data | yes | |||
| Card Terminal Txn Ref (added by iVendNext) | custom_card_txn_ref |
Data | yes |
Table: Sales Invoice Timesheet
The rows of timesheets. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Activity Type | activity_type |
Link | yes | Activity Type | ||
| Description | description |
Small Text | yes | |||
| From Time | from_time |
Datetime | ||||
| To Time | to_time |
Datetime | ||||
| Billing Hours | billing_hours |
Float | yes | |||
| Billing Amount | billing_amount |
Currency | yes | |||
| Time Sheet | time_sheet |
Link | yes | Timesheet | ||
| Timesheet Detail | timesheet_detail |
Data | yes | yes | ||
| Project Name | project_name |
Data | yes |
Table: Sales Taxes and Charges
The rows of taxes. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Type | charge_type |
Select | yes | one of: Actual, On Net Total, On Previous Row Amount, On Previous Row Total, On Item Quantity | ||
| Reference Row # | row_id |
Data | ||||
| Account Head | account_head |
Link | yes | Account | ||
| Item (added by iVendNext) | custom_item |
Link | Item | |||
| On Item Row (added by iVendNext) | custom_on_item_row |
Int | ||||
| Surcharge (added by iVendNext) | custom_surcharge |
Link | Surcharge | |||
| Surcharge Amount (added by iVendNext) | custom_surcharge_amount |
Float | ||||
| Final Amount (added by iVendNext) | custom_final_amount |
Float | ||||
| Description | description |
Small Text | yes | |||
| Is this Tax included in Basic Rate? | included_in_print_rate |
Check | ||||
| Considered In Paid Amount | included_in_paid_amount |
Check | ||||
| Discount Type (added by iVendNext) | custom_discount_type |
Select | one of: Flat Amount, Percentage | |||
| Discount Amount (added by iVendNext) | custom_discount_amount |
Float | ||||
| Tax Template (added by iVendNext) | custom_tax_template |
Link | Item Tax Template | |||
| Applied Tax Amount (added by iVendNext) | custom_applied_tax_amount |
Float | ||||
| Discountable (added by iVendNext) | custom_discountable |
Check | ||||
| Taxable (added by iVendNext) | custom_taxable |
Check | ||||
| Refundable (added by iVendNext) | custom_refundable |
Check | ||||
| Load on Item Cost (added by iVendNext) | custom_load_on_item_cost |
Check | ||||
| Is return (added by iVendNext) | custom_is_return |
Check | yes | |||
| Tax Rate (added by iVendNext) | custom_tax_rate |
Percent | ||||
| Tax Per Item (added by iVendNext) | custom_tax_per_item |
Float | ||||
| Cost Center | cost_center |
Link | Cost Center | |||
| Tax Rate | rate |
Float | ||||
| Account Currency | account_currency |
Link | yes | Currency | ||
| Amount | tax_amount |
Currency | ||||
| Total | total |
Currency | yes | |||
| Tax Amount After Discount Amount | tax_amount_after_discount_amount |
Currency | yes | |||
| Amount (Company Currency) | base_tax_amount |
Currency | yes | |||
| Total (Company Currency) | base_total |
Currency | yes | |||
| Tax Amount After Discount Amount (Company Currency) | base_tax_amount_after_discount_amount |
Currency | yes | |||
| Item Wise Tax Detail | item_wise_tax_detail |
Code | yes | yes | ||
| Dont Recompute tax | dont_recompute_tax |
Check | yes | yes |
Table: Sales Team
The rows of sales_team. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Sales Person | sales_person |
Link | yes | Sales Person | ||
| Contact No. | contact_no |
Data | yes | |||
| Contribution (%) | allocated_percentage |
Float | ||||
| Contribution to Net Total | allocated_amount |
Currency | yes | |||
| Commission Rate | commission_rate |
Data | yes | |||
| Incentives | incentives |
Currency |
Table: Transaction Coupon
The rows of custom_coupons. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Item Row Reference | item_row_reference |
Int | yes | |||
| Item Code | item_code |
Data | yes | |||
| Coupon Name | coupon_name |
Data | ||||
| Serial Number | serial_number |
Data | ||||
| Discount Amount | discount_amount |
Data | yes | |||
| Store | store |
Link | Warehouse | |||
| Customer | customer |
Link | Customer |
Table: Transaction Promotion Bonus Buys Detail
The rows of custom_promotions. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Item Row Reference | item_row_reference |
Int | yes | |||
| Item Code | item_code |
Data | yes | |||
| Promotion Name | promotion_name |
Data | yes | |||
| Discount Amount | discount_amount |
Data | yes | |||
| Quantity | quantity |
Data | yes | yes | ||
| Store | store |
Link | Warehouse | |||
| Customer | customer |
Link | Customer |