Dafater

Repository

  1. Dafater

Dafater – Data Dictionary

Host engineering-samir.dafater.biz
Database BI
DBMS MySQL

Database objects

  1. Views (202)

Views

  1. Account
  2. Address
  3. Appraisal
  4. Appraisal Goal
  5. Appraisal Template
  6. Appraisal Template Goal
  7. Attendance
  8. Authorization Rule
  9. Bank
  10. Bank Reconciliation Detail
  11. Batch
  12. Bin
  13. BOM
  14. BOM Explosion Item
  15. BOM Item
  16. BOM Operation
  17. Branch
  18. Brand
  19. Budget Detail
  20. Budget Distribution
  21. Budget Distribution Detail
  22. Business Trip Request
  23. Business Trip Request Workflow History
  24. Campaign
  25. Company
  26. Company History
  27. Contact
  28. Cost Center
  29. Country
  30. Currency
  31. Currency Exchange
  32. Custody
  33. Custody Assignment
  34. Custody Assignment Workflow History
  35. Customer
  36. Customer Discount
  37. Customer Group
  38. Customer Issue
  39. Deduction Type
  40. Delivery Note
  41. Delivery Note Item
  42. Delivery Note Packing Item
  43. Department
  44. Designation
  45. Earning Type
  46. Employee
  47. Employee Dependant
  48. Employee Education
  49. Employee External Work History
  50. Employee Internal Work History
  51. Employee Leave Approver
  52. Employment Type
  53. Event
  54. Event Role
  55. Event User
  56. Expense Claim
  57. Expense Claim Detail
  58. Expense Claim Type
  59. Fiscal Year
  60. For Territory
  61. GL Entry
  62. Grade
  63. Holiday
  64. Holiday List
  65. Industry Type
  66. Installation Note
  67. Installation Note Item
  68. Item
  69. Item Customer Detail
  70. Item Group
  71. Item Price
  72. Item Quality Inspection Parameter
  73. Item Reorder
  74. Item Supplier
  75. Item Tax
  76. Item Website Specification
  77. Job Applicant
  78. Job Opening
  79. Journal Voucher
  80. Journal Voucher Detail
  81. Landed Cost Item
  82. Landed Cost Purchase Receipt
  83. Lead
  84. Leave Allocation
  85. Leave Application
  86. Leave Block List
  87. Leave Block List Allow
  88. Leave Block List Date
  89. Leave Type
  90. Legal Document
  91. Legal Document Type
  92. Maintenance Request
  93. Maintenance Request Workflow History
  94. Maintenance Schedule
  95. Maintenance Schedule Detail
  96. Maintenance Schedule Item
  97. Maintenance Visit
  98. Maintenance Visit Purpose
  99. Material Request
  100. Material Request Item
  101. Mode of Payment
  102. Office Supply Request
  103. Office Supply Request Workflow History
  104. Opportunity
  105. Opportunity Item
  106. Packing Slip
  107. Packing Slip Item
  108. Payment to Invoice Matching Tool Detail
  109. Payment Voucher
  110. Payment Voucher Detail
  111. Period Closing Voucher
  112. POS Setting
  113. POS Standalone
  114. POS Standalone Users
  115. Price List
  116. Production Order
  117. Production Plan Item
  118. Production Plan Sales Order
  119. Profile
  120. Project
  121. Project Milestone
  122. Purchase Invoice
  123. Purchase Invoice Advance
  124. Purchase Invoice Item
  125. Purchase Order
  126. Purchase Order Item
  127. Purchase Order Item Supplied
  128. Purchase Receipt
  129. Purchase Receipt Item
  130. Purchase Receipt Item Supplied
  131. Purchase Taxes and Charges
  132. Purchase Taxes and Charges Master
  133. Quality Inspection
  134. Quality Inspection Reading
  135. Quotation
  136. Quotation Item
  137. Quotation Lost Reason
  138. Receipt Voucher
  139. Receipt Voucher Detail
  140. Salary Slip
  141. Salary Slip Deduction
  142. Salary Slip Earning
  143. Salary Structure
  144. Salary Structure Deduction
  145. Salary Structure Earning
  146. Sales BOM
  147. Sales BOM Item
  148. Sales Invoice
  149. Sales Invoice Advance
  150. Sales Invoice Item
  151. Sales Order
  152. Sales Order Item
  153. Sales Partner
  154. Sales Person
  155. Sales Taxes and Charges
  156. Sales Taxes and Charges Master
  157. Sales Team
  158. Serial No
  159. Shipping Rule
  160. Shipping Rule Condition
  161. Shopping Cart Price List
  162. Shopping Cart Shipping Rule
  163. Shopping Cart Taxes and Charges Master
  164. Stationary Tool
  165. Stock Entry
  166. Stock Entry Detail
  167. Stock Ledger Entry
  168. Stock Reconciliation
  169. Supplier
  170. Supplier Quotation
  171. Supplier Quotation Item
  172. Supplier Type
  173. Support Ticket
  174. Target Detail
  175. Task
  176. Terms and Conditions
  177. Territory
  178. Time Log
  179. Time Log Batch
  180. Time Log Batch Detail
  181. ToDo
  182. Top Bar Item
  183. Training Request
  184. Training Request Workflow History
  185. Travel Ticket Request
  186. Travel Ticket Request Dependent
  187. Travel Ticket Request Workflow History
  188. UOM
  189. UOM Conversion Detail
  190. UserRole
  191. Visit Visa Request
  192. Visit Visa Request Workflow History
  193. Warehouse
  194. Warehouse User
  195. Web Page
  196. Website Item Group
  197. Website Slideshow
  198. Website Slideshow Item
  199. Within-Day Leave Request
  200. Within-Day Leave Request Workflow History
  201. Work Schedule
  202. Workstation

Account

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 allow_negative_balance int Default: 1
Default: 1
12 master_type string Options: Supplier, Customer, Employee
13 parent_account string
Refrence Document Type:
Account, Field: name
14 credit_limit decimal
15 account_type string Options: Fixed Asset Account, Expense Account, Tax, Income Account, Chargeable, Bank, Cash
16 debit_or_credit string
17 level int
18 company string
Refrence Document Type:
Company, Field: name
19 master_name string
Refrence Document Type:
[Select], Field: name
20 group_or_ledger string Default: Ledger Options: Ledger, Group
Default: Ledger
21 old_parent string
22 lft int
23 is_pl_account string Options: Yes, No
24 tax_rate decimal
25 rgt int
26 credit_days int
27 freeze_account string Options: No, Yes
28 account_name string

Address

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 email_id string
12 pincode string
13 lead_name string
14 customer_name string
15 address_line2 string
16 city string
17 address_line1 string
18 lead string
Refrence Document Type:
Lead, Field: name
19 is_primary_address int Default: 0
Default: 0
20 state string
21 supplier string
Refrence Document Type:
Supplier, Field: name
22 address_type string Options: Billing, Shipping, Office, Personal, Plant, Postal, Shop, Subsidiary, Warehouse, Other
23 sales_partner string
Refrence Document Type:
Sales Partner, Field: name
24 fax string
25 address_title string
26 phone string
27 supplier_name string
28 customer string
Refrence Document Type:
Customer, Field: name
29 country string
Refrence Document Type:
Country, Field: name
30 is_shipping_address int Default: 0
Default: 0
31 open_cart_id string

Appraisal

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Default: Draft Options: Draft, Submitted, Completed, Cancelled
Default: Draft
12 kra_template string
Refrence Document Type:
Appraisal Template, Field: name
13 end_date date
14 amended_from string
15 total_score decimal
16 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
17 comments text
18 employee_name string
19 employee string
Refrence Document Type:
Employee, Field: name
20 company string
Refrence Document Type:
Company, Field: name
21 start_date date
24 appraisal_goal Array Array of: Appraisal Goal

Appraisal Goal

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Appraisal field: name
8 parentfield string
9 parenttype string Options: Appraisal
10 idx int
11 score_earned decimal
12 kra text
13 per_weightage decimal
14 score decimal
15 goal_comments text

Appraisal Template

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 total_points int
12 kra_title string
13 description text
15 appraisal_template_goal Array Array of: Appraisal Template Goal

Appraisal Template Goal

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Appraisal Template field: name
8 parentfield string
9 parenttype string Options: Appraisal Template
10 idx int
11 kra text
12 per_weightage decimal

Attendance

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Default: Present Options: Present, Absent, Half Day, Holiday
Default: Present
12 att_date date
13 naming_series string Options: ATT
14 company string
Refrence Document Type:
Company, Field: name
15 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
16 amended_from string
Refrence Document Type:
Attendance, Field: name
17 leave_type string
Refrence Document Type:
Leave Type, Field: name
18 employee_name string
19 employee string
Refrence Document Type:
Employee, Field: name
20 _user_tags string

Authorization Rule

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 value decimal
12 approving_user string
Refrence Document Type:
Profile, Field: name
13 transaction string Options: Delivery Note, Purchase Invoice, Purchase Order, Purchase Receipt, Quotation, Sales Invoice, Sales Order, Appraisal
14 system_user string
Refrence Document Type:
Profile, Field: name
15 trash_reason text
16 company string
Refrence Document Type:
Company, Field: name
17 master_name string
Refrence Document Type:
[Select], Field: name
18 to_emp string
Refrence Document Type:
Employee, Field: name
19 system_role string
Refrence Document Type:
Role, Field: name
20 based_on string Options: Grand Total, Average Discount, Customerwise Discount, Itemwise Discount, Not Applicable
21 approving_role string
Refrence Document Type:
Role, Field: name
22 to_designation string
Refrence Document Type:
Designation, Field: name

Bank

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 bank_name string
12 cbid_code string
13 swift_code string
14 wps_export_type text

Bank Reconciliation Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Bank Reconciliation field: name
8 parentfield string
9 parenttype string Options: Bank Reconciliation
10 idx int
11 cheque_date date
12 clearance_date date
13 credit decimal
14 debit decimal
15 voucher_id string
16 posting_date date
17 cheque_number string
18 against_account string

Batch

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 finished_date date
12 description text
13 item string
Refrence Document Type:
Item, Field: name
14 expiry_date date
15 batch_id string
16 start_date date

Bin

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 fcfs_rate decimal
12 indented_qty decimal Default: 0.000000
Default: 0.000000
13 reserved_qty decimal Default: 0.000000
Default: 0.000000
14 planned_qty decimal
15 valuation_rate decimal
16 item_code string
Refrence Document Type:
Item, Field: name
17 projected_qty decimal
18 ma_rate decimal
19 stock_uom string
Refrence Document Type:
UOM, Field: name
20 ordered_qty decimal Default: 0.000000
Default: 0.000000
21 warehouse string
Refrence Document Type:
Warehouse, Field: name
22 stock_value decimal
23 actual_qty decimal Default: 0.000000
Default: 0.000000

BOM

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 operating_cost decimal
12 total_cost decimal
13 amended_from string
Refrence Document Type:
BOM, Field: name
14 buying_price_list string
Refrence Document Type:
Price List, Field: name
15 uom string
Refrence Document Type:
UOM, Field: name
16 project_name string
Refrence Document Type:
Project, Field: name
17 description text
18 with_operations int
19 raw_material_cost decimal
20 is_active int Default: 1
Default: 1
21 is_default int Default: 1
Default: 1
22 rm_cost_as_per string Options: Valuation Rate, Last Purchase Rate, Price List
23 item string
Refrence Document Type:
Item, Field: name
24 quantity decimal Default: 1.000000
Default: 1.000000
29 bom_explosion_item Array Array of: BOM Explosion Item
30 bom_item Array Array of: BOM Item
31 bom_operation Array Array of: BOM Operation

BOM Explosion Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: BOM field: name
8 parentfield string
9 parenttype string Options: BOM
10 idx int
11 description text
12 qty_consumed_per_unit decimal
13 rate decimal
14 item_code string
Refrence Document Type:
Item, Field: name
15 qty decimal
16 amount decimal
17 stock_uom string
Refrence Document Type:
UOM, Field: name

BOM Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: BOM field: name
8 parentfield string
9 parenttype string Options: BOM
10 idx int
11 bom_no string
Refrence Document Type:
BOM, Field: name
12 description text
13 scrap decimal
14 qty_consumed_per_unit decimal
15 amount decimal
16 item_code string
Refrence Document Type:
Item, Field: name
17 qty decimal
18 rate decimal
19 stock_uom string
Refrence Document Type:
UOM, Field: name
20 operation_no string Options: NULL

BOM Operation

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: BOM field: name
8 parentfield string
9 parenttype string Options: BOM
10 idx int
11 operating_cost decimal
12 workstation string
Refrence Document Type:
Workstation, Field: name
13 opn_description text
14 hour_rate decimal
15 operation_no string
16 time_in_mins decimal

Branch

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 trash_reason text
12 branch string

Brand

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 brand string
12 description text

Budget Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Cost Center field: name
8 parentfield string
9 parenttype string Options: Cost Center
10 idx int
11 account string
Refrence Document Type:
Account, Field: name
12 actual decimal
13 budget_allocated decimal
14 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name

Budget Distribution

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 distribution_id string
12 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
13 trash_reason text
15 budget_distribution_detail Array Array of: Budget Distribution Detail

Budget Distribution Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Budget Distribution field: name
8 parentfield string
9 parenttype string Options: Budget Distribution
10 idx int
11 percentage_allocation decimal
12 month string

Business Trip Request

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 daily_business_trip decimal Default: 0.000000
Default: 0.000000
12 end_date date
13 amended_from string
Refrence Document Type:
Business Trip Request, Field: name
14 reason text
15 department string
16 employee_name string
17 employee string
Refrence Document Type:
Employee, Field: name
18 type string Options: Internal Business Trip, External Business Trip, Extension of Business Trip
19 start_date date
20 another_expenses decimal Default: 0.000000
Default: 0.000000
21 workflow_state string

Business Trip Request Workflow History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 update_field string Options: NULL
12 state string
Refrence Document Type:
Workflow State, Field: name
13 update_value string
14 reason string
15 user string
Refrence Document Type:
Profile, Field: name
16 doc_status int

Campaign

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 campaign_name string
12 trash_reason text
13 description text

Company

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 website string
12 domain string Options: Distribution, Manufacturing, Retail, Services
13 default_income_account string
Refrence Document Type:
Account, Field: name
14 receivables_group string
Refrence Document Type:
Account, Field: name
15 cost_center string
Refrence Document Type:
Cost Center, Field: name
16 registration_details text
17 default_currency string
Refrence Document Type:
Currency, Field: name
18 stock_in_hand_account string
Refrence Document Type:
Account, Field: name
19 trash_reason text
20 yearly_bgt_flag string Options: Warn, Ignore, Stop
21 default_expense_account string
Refrence Document Type:
Account, Field: name
22 payables_group string
Refrence Document Type:
Account, Field: name
23 credit_days int
24 company_name string
25 expenses_included_in_valuation string
Refrence Document Type:
Account, Field: name
26 default_bank_account string
Refrence Document Type:
Account, Field: name
27 email string
28 fax string
29 stock_adjustment_account string
Refrence Document Type:
Account, Field: name
30 abbr string
31 monthly_bgt_flag string Options: Warn, Ignore, Stop
32 address text
33 stock_adjustment_cost_center string
Refrence Document Type:
Cost Center, Field: name
34 credit_limit decimal
35 stock_received_but_not_billed string
Refrence Document Type:
Account, Field: name
36 phone_no string
37 default_cash_account string
Refrence Document Type:
Account, Field: name
38 mol_establishment_id int
39 company_cr int
40 bank_name string
Refrence Document Type:
Bank, Field: name
41 wps_company_name string
42 debit_account_number string
43 connect_id string Default: ABC25768001
Default: ABC25768001
44 customer_id string Default: SASABBGSA020313888
Default: SASABBGSA020313888
45 company_profile int
46 tax_number string
50 legal_document Array Array of: Legal Document

Company History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: About Us Settings field: name
8 parentfield string
9 parenttype string Options: About Us Settings
10 idx int
11 highlight text
12 year string

Contact

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 last_name string
12 email_id string
13 mobile_no string
14 supplier string
Refrence Document Type:
Supplier, Field: name
15 customer_name string
16 first_name string
17 trash_reason text
18 unsubscribed int
19 department string
20 sales_partner string
Refrence Document Type:
Sales Partner, Field: name
21 status string Options: Open, Replied
22 phone string
23 supplier_name string
24 customer string
Refrence Document Type:
Customer, Field: name
25 designation string
26 is_primary_contact int Default: 0
Default: 0

Cost Center

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 rgt int
12 trash_reason text
13 company string
Refrence Document Type:
Company, Field: name
14 group_or_ledger string Options: Group, Ledger
15 old_parent string
Refrence Document Type:
Cost Center, Field: name
16 distribution_id string
Refrence Document Type:
Budget Distribution, Field: name
17 parent_cost_center string
Refrence Document Type:
Cost Center, Field: name
18 lft int
19 cost_center_name string
21 budget_detail Array Array of: Budget Detail

Country

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 country_name string
12 date_format string
13 time_zones text

Currency

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 fraction_units int
12 symbol string
13 enabled int
14 currency_name string
15 fraction string
16 number_format string

Currency Exchange

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 to_currency string
Refrence Document Type:
Currency, Field: name
12 exchange_rate decimal
13 from_currency string
Refrence Document Type:
Currency, Field: name

Custody

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Custody Assignment field: name
8 parentfield string
9 parenttype string Options: Custody Assignment
10 idx int
11 employee string
12 amended_from string
13 workflow_state string
14 received_date date
15 model string
16 type string
17 custody string
18 quantity int Default: 1
Default: 1

Custody Assignment

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 amended_from string
Refrence Document Type:
Custody Assignment, Field: name
12 department string
13 employee_name string
14 employee string
Refrence Document Type:
Employee, Field: name
15 workflow_state string
17 custody Array Array of: Custody

Custody Assignment Workflow History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 update_field string Options: NULL
12 state string
Refrence Document Type:
Workflow State, Field: name
13 update_value string
14 reason string
15 user string
Refrence Document Type:
Profile, Field: name
16 doc_status int

Customer

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 customer_details text
12 naming_series string Options: CUST, CUSTMUM
13 lead_name string
Refrence Document Type:
Lead, Field: name
14 default_currency string
Refrence Document Type:
Currency, Field: name
15 customer_type string Options: Company, Individual
16 customer_name string
17 credit_days int
18 default_commission_rate decimal
19 territory string
Refrence Document Type:
Territory, Field: name
20 website string
21 default_sales_partner string
Refrence Document Type:
Sales Partner, Field: name
22 company string
Refrence Document Type:
Company, Field: name
23 credit_limit decimal
24 customer_group string
Refrence Document Type:
Customer Group, Field: name
25 default_price_list string
Refrence Document Type:
Price List, Field: name
26 _user_tags string
27 open_cart_id string
28 tax_number string
30 customer_discount Array Array of: Customer Discount
31 sales_team Array Array of: Sales Team

Customer Discount

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Customer field: name
8 parentfield string
9 parenttype string Options: Customer
10 idx int
11 discount decimal
12 item_group string
Refrence Document Type:
Item Group, Field: name

Customer Group

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 rgt int
12 trash_reason text
13 parent_customer_group string
Refrence Document Type:
Customer Group, Field: name
14 is_group string Options: Yes, No
15 default_price_list string
Refrence Document Type:
Price List, Field: name
16 old_parent string
Refrence Document Type:
Customer Group, Field: name
17 lft int
18 customer_group_name string

Customer Issue

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 address_display text
12 contact_email string
13 naming_series string Options: CI/2010-2011/
14 serial_no string
Refrence Document Type:
Serial No, Field: name
15 service_address text
16 resolved_by string
Refrence Document Type:
Profile, Field: name
17 warranty_amc_status string Options: Under Warranty, Out of Warranty, Under AMC, Out of AMC
18 customer_name string
19 amc_expiry_date date
20 complaint_date date
21 item_name string
22 from_company string
23 amended_from string
24 contact_display text
25 territory string
Refrence Document Type:
Territory, Field: name
26 status string Default: Open Options: Open, Closed, Work In Progress, Cancelled
Default: Open
27 complaint text
28 description text
29 complaint_raised_by string
30 company string
Refrence Document Type:
Company, Field: name
31 item_code string
Refrence Document Type:
Item, Field: name
32 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
33 customer_address string
Refrence Document Type:
Address, Field: name
34 resolution_details text
35 resolution_date datetime
36 customer string
Refrence Document Type:
Customer, Field: name
37 contact_mobile string
38 customer_group string
Refrence Document Type:
Customer Group, Field: name
39 warranty_expiry_date date
40 contact_person string
Refrence Document Type:
Contact, Field: name

Deduction Type

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 deduction_name string
12 trash_reason text
13 description text

Delivery Note

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 rounded_total_export decimal
12 lr_date date
13 excise_page string
14 selling_price_list string
Refrence Document Type:
Price List, Field: name
15 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
16 source string Options: Existing Customer, Reference, Advertisement, Cold Calling, Exhibition, Supplier Reference, Mass Mailing, Customer's Vendor, Campaign
17 charge string
Refrence Document Type:
Sales Taxes and Charges Master, Field: name
18 address_display text
19 instructions text
20 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
21 net_total_export decimal
22 po_date string
23 price_list_currency string
Refrence Document Type:
Currency, Field: name
24 contact_display text
25 terms text
26 other_charges_total_export decimal
27 shipping_address text
28 customer_address string
Refrence Document Type:
Address, Field: name
29 total_commission decimal
30 contact_mobile text
31 rounded_total decimal
32 shipping_address_name string
Refrence Document Type:
Address, Field: name
33 po_no string
34 contact_person string
Refrence Document Type:
Contact, Field: name
35 print_without_amount int Default: 1
Default: 1
36 campaign string
Refrence Document Type:
Campaign, Field: name
37 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
38 conversion_rate decimal Default: 1.000000
Default: 1.000000
39 per_installed decimal
40 posting_time time
41 customer_name string
42 commission_rate decimal
43 territory string
Refrence Document Type:
Territory, Field: name
44 sales_partner string
Refrence Document Type:
Sales Partner, Field: name
45 project_name string
Refrence Document Type:
Project, Field: name
46 company string
Refrence Document Type:
Company, Field: name
47 lr_no string
48 contact_email text
49 customer string
Refrence Document Type:
Customer, Field: name
50 grand_total decimal
51 posting_date date
52 customer_group string
Refrence Document Type:
Customer Group, Field: name
53 naming_series string Options: DN
54 other_charges_total decimal
55 currency string
Refrence Document Type:
Currency, Field: name
56 letter_head string
Refrence Document Type:
Letter Head, Field: name
57 installation_status string Options: NULL
58 shipping_rule string
Refrence Document Type:
Shipping Rule, Field: name
59 amended_from string
60 to_warehouse string
Refrence Document Type:
Warehouse, Field: name
61 grand_total_export decimal
62 status string Default: Draft Options: Draft, Submitted, Cancelled
Default: Draft
63 in_words_export string
64 transporter_name string
65 in_words string
66 plc_conversion_rate decimal
67 net_total decimal
68 apply_additional_discount_on string Default: Net Total Options: Net Total
Default: Net Total
69 additional_discount_amount decimal Default: 0.000000
Default: 0.000000
70 additional_discount_percentage decimal Default: 0.000000
Default: 0.000000
78 delivery_note_item Array Array of: Delivery Note Item
79 delivery_note_packing_item Array Array of: Delivery Note Packing Item
80 sales_taxes_and_charges Array Array of: Sales Taxes and Charges
81 sales_team Array Array of: Sales Team

Delivery Note Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Delivery Note field: name
8 parentfield string
9 parenttype string Options: Delivery Note
10 idx int
11 serial_no text
12 expense_account string
Refrence Document Type:
Account, Field: name
13 item_tax_rate text
14 installed_qty decimal
15 adj_rate decimal
16 cost_center string
Refrence Document Type:
Cost Center, Field: name
17 actual_qty decimal
18 page_break int
19 item_name string
20 prevdoc_detail_docname string
21 stock_uom string
Refrence Document Type:
UOM, Field: name
22 warehouse string
Refrence Document Type:
Warehouse, Field: name
23 basic_rate decimal
24 ref_rate decimal
25 description text
26 prevdoc_docname string
27 brand string
Refrence Document Type:
Brand, Field: name
28 barcode string
29 item_code string
Refrence Document Type:
Item, Field: name
30 buying_amount decimal
31 prevdoc_date date
32 qty decimal
33 export_rate decimal
34 item_group string
Refrence Document Type:
Item Group, Field: name
35 export_amount decimal
36 amount decimal
37 customer_item_code string
38 batch_no string
Refrence Document Type:
Batch, Field: name
39 base_ref_rate decimal
40 prevdoc_doctype string
41 net_amount_export decimal
42 net_amount decimal

Delivery Note Packing Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Sales Order field: name
Refrence Document Type: Delivery Note field: name
Refrence Document Type: Sales Invoice field: name
Refrence Document Type: Return Note field: name
8 parentfield string
9 parenttype string Options: Sales Order, Delivery Note, Sales Invoice, Return Note,
10 idx int
11 serial_no text
12 description text
13 item_name string
14 parent_detail_docname string
15 item_code string
Refrence Document Type:
Item, Field: name
16 qty decimal
17 projected_qty decimal
18 parent_item string
Refrence Document Type:
Item, Field: name
19 page_break int
20 batch_no string
21 warehouse string
Refrence Document Type:
Warehouse, Field: name
22 actual_qty decimal
23 uom string
Refrence Document Type:
UOM, Field: name
24 prevdoc_doctype string

Department

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 leave_block_list string
Refrence Document Type:
Leave Block List, Field: name
12 trash_reason text
13 department_name string

Designation

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 designation_name string
12 trash_reason text

Earning Type

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 taxable string Options: Yes, No
12 earning_name string
13 trash_reason text
14 exemption_limit decimal
15 description text

Employee

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 feedback text
12 holiday_list string
Refrence Document Type:
Holiday List, Field: name
13 relation string
14 company_email string
15 resignation_letter_date date
16 personal_email string
17 date_of_birth date
18 employee string
19 current_address text
20 scheduled_confirmation_date date
21 family_background text
22 designation string
Refrence Document Type:
Designation, Field: name
23 gender string Options: Male, Female
24 marital_status string Options: Single, Married, Divorced, Widowed
25 health_details text
26 status string Default: Active Options: Active, Left
Default: Active
27 held_on date
28 permanent_accommodation_type string Options: Rented, Owned
29 pf_number string
30 salutation string Options: Mr, Ms
31 pan_number string
32 trash_reason text
33 employee_number string
34 employee_name string
35 date_of_retirement date
36 grade string
Refrence Document Type:
Grade, Field: name
37 image string Options: attach_files:
38 user_id string
Refrence Document Type:
Profile, Field: name
39 encashment_date date
40 blood_group string Options: A+, A-, B+, B-, AB+, AB-, O+, O-
41 date_of_issue date
42 reason_for_resignation string
43 new_workplace string
44 bank_name string
Refrence Document Type:
Bank, Field: name
45 company string
Refrence Document Type:
Company, Field: name
46 leave_encashed string Options: Yes, No
47 bank_ac_no string
48 reason_for_leaving string
49 final_confirmation_date date
50 cell_number string
51 contract_end_date date
52 gratuity_lic_id string
53 esic_card_no string
54 bio text
55 naming_series string Options: EMP/
56 permanent_address text
57 passport_number string
58 emergency_phone_number string
59 employment_type string
Refrence Document Type:
Employment Type, Field: name
60 salary_mode string Options: Bank, Cash, Cheque
61 reports_to string
Refrence Document Type:
Employee, Field: name
62 branch string
Refrence Document Type:
Branch, Field: name
63 current_accommodation_type string Options: Rented, Owned
64 department string
Refrence Document Type:
Department, Field: name
65 person_to_be_contacted string
66 date_of_joining date
67 place_of_issue string
68 valid_upto date
69 notice_number_of_days int
70 relieving_date date
71 national_id_or_iqama_no string
72 national_id_or_iqama_number_issuance_date date
73 arabic_full_name string
74 national_id_or_iqama_number_expiration_date date
75 place_of_birth string
Refrence Document Type:
Country, Field: name
76 gosi string
77 work_permit_id string
78 work_permit_expiration_date date
79 religion string Options: Muslim, Christian, Jewish, Buddhist, Sikh, Other
80 with_disabilities int
81 nationality string
Refrence Document Type:
Country, Field: name
82 end_of_service_type string Options: Resignation, End of Contract, Contract Termination with End of Service Award, Contract Termination without End of Service Award
83 exit_interview_date date
84 notice_date date
85 notice_method string Options: Official Letter, Official Email
86 reasons_for_end_of_service string
87 _user_tags string
90 employee_dependant Array Array of: Employee Dependant
91 employee_education Array Array of: Employee Education
92 employee_external_work_history Array Array of: Employee External Work History
93 employee_internal_work_history Array Array of: Employee Internal Work History
94 employee_leave_approver Array Array of: Employee Leave Approver

Employee Dependant

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Employee field: name
8 parentfield string
9 parenttype string Options: Employee
10 idx int
11 saudi_or_iqama_id int
12 expiration_date date
13 relationship string Options: Husband, Wife, Son, Daughter, Father, Mother, Other
14 dependant_name string

Employee Education

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Employee field: name
8 parentfield string
9 parenttype string Options: Employee
10 idx int
11 maj_opt_subj text
12 level string Options: Illiterate, Elementary School, Intermediate School, High School, Under Graduate, Graduate, Post Graduate
13 class_per string
14 qualification string
15 school_univ text
16 year_of_passing int

Employee External Work History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Employee field: name
8 parentfield string
9 parenttype string Options: Employee
10 idx int
11 salary decimal
12 designation string
13 contact string
14 company_name string
15 address text
16 total_experience string

Employee Internal Work History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Employee field: name
8 parentfield string
9 parenttype string Options: Employee
10 idx int
11 designation string
Refrence Document Type:
Designation, Field: name
12 grade string
Refrence Document Type:
Grade, Field: name
13 from_date date
14 to_date date
15 branch string
Refrence Document Type:
Branch, Field: name
16 department string
Refrence Document Type:
Department, Field: name

Employee Leave Approver

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Employee field: name
8 parentfield string
9 parenttype string Options: Employee
10 idx int
11 leave_approver string Options: NULL

Employment Type

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 employee_type_name string
12 trash_reason text
13 contract_type string Options: Fixed Term, Indefinite

Event

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 event_type string Options: Private, Public, Cancel
12 tuesday int
13 all_day int
14 repeat_till date
15 saturday int
16 subject string
17 repeat_this_event int
18 thursday int
19 sunday int
20 send_reminder int Default: 1
Default: 1
21 ref_type string
22 ref_name string
23 description text
24 monday int
25 friday int
26 wednesday int
27 starts_on datetime
28 ends_on datetime
29 repeat_on string Options: Every Day, Every Week, Every Month, Every Year
30 notification_field string
31 is_notification_reminder int
34 event_role Array Array of: Event Role
35 event_user Array Array of: Event User

Event Role

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Event field: name
8 parentfield string
9 parenttype string Options: Event
10 idx int
11 role string
Refrence Document Type:
Role, Field: name

Event User

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Event field: name
8 parentfield string
9 parenttype string Options: Event
10 idx int
11 person string
Refrence Document Type:
Profile, Field: name

Expense Claim

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 remark text
12 approval_status string Default: Draft Options: Draft, Approved, Rejected
Default: Draft
13 total_claimed_amount decimal
14 email_id string
15 company string
Refrence Document Type:
Company, Field: name
16 employee_name string
17 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
18 exp_approver string Options: NULL
19 amended_from string
20 total_sanctioned_amount decimal
21 employee string
Refrence Document Type:
Employee, Field: name
22 posting_date date
25 expense_claim_detail Array Array of: Expense Claim Detail

Expense Claim Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Expense Claim field: name
8 parentfield string
9 parenttype string Options: Expense Claim
10 idx int
11 claim_amount decimal
12 expense_date date
13 description text
14 sanctioned_amount decimal
15 expense_type string
Refrence Document Type:
Expense Claim Type, Field: name

Expense Claim Type

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 description text
12 expense_type string

Fiscal Year

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 is_fiscal_year_closed string Default: No Options: No, Yes
Default: No
12 year_start_date date
13 year string

For Territory

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Shipping Rule field: name
Refrence Document Type: Price List field: name
Refrence Document Type: Sales Taxes and Charges Master field: name
8 parentfield string
9 parenttype string Options: Shipping Rule, Price List, Sales Taxes and Charges Master,
10 idx int
11 territory string
Refrence Document Type:
Territory, Field: name

GL Entry

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 account string
Refrence Document Type:
Account, Field: name
12 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
13 against_voucher string
14 is_cancelled string Options: No, Yes
15 against_voucher_type string
16 company string
Refrence Document Type:
Company, Field: name
17 is_opening string Options: No, Yes
18 aging_date date
19 against text
20 voucher_type string Options: Journal Voucher, Sales Invoice, Purchase Invoice
21 credit decimal
22 transaction_date date
23 is_advance string Options: No, Yes
24 debit decimal
25 remarks text
26 posting_date date
27 cost_center string
Refrence Document Type:
Cost Center, Field: name
28 voucher_no string
29 project_name string

Grade

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 grade_name string

Holiday

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Holiday List field: name
8 parentfield string
9 parenttype string Options: Holiday List
10 idx int
11 holiday_date date
12 description text

Holiday List

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 trash_reason text
12 holiday_list_name string
13 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
14 is_default int
15 weekly_off string Options: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
17 holiday Array Array of: Holiday

Industry Type

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 industry string

Installation Note

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Default: Draft Options: Draft, Submitted, Cancelled
Default: Draft
12 inst_date date
13 naming_series string Options: IN
14 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
15 customer_name string
16 amended_from string
17 contact_display text
18 territory string
Refrence Document Type:
Territory, Field: name
19 address_display text
20 company string
Refrence Document Type:
Company, Field: name
21 customer_address string
Refrence Document Type:
Address, Field: name
22 contact_email text
23 contact_mobile text
24 remarks text
25 customer string
Refrence Document Type:
Customer, Field: name
26 customer_group string
Refrence Document Type:
Customer Group, Field: name
27 inst_time time
28 contact_person string
Refrence Document Type:
Contact, Field: name
31 installation_note_item Array Array of: Installation Note Item

Installation Note Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Installation Note field: name
8 parentfield string
9 parenttype string Options: Installation Note
10 idx int
11 description string
12 prevdoc_docname string
13 serial_no text
14 item_code string
Refrence Document Type:
Item, Field: name
15 qty decimal
16 prevdoc_detail_docname string
17 prevdoc_date date
18 prevdoc_doctype string

Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 is_service_item string Default: No Options: Yes, No
Default: No
12 default_sales_cost_center string
Refrence Document Type:
Cost Center, Field: name
13 default_bom string
Refrence Document Type:
BOM, Field: name
14 naming_series string Options: ITEM
15 image string Options: attach_files:
16 valuation_method string Options: FIFO, Moving Average
17 website_image string Options: attach_files:
18 weightage int
19 net_weight decimal
20 max_discount decimal
21 warranty_period string
22 serial_no_series string
23 cost_center string
Refrence Document Type:
Cost Center, Field: name
24 re_order_level decimal
25 is_asset_item string Default: No Options: Yes, No
Default: No
26 last_purchase_rate decimal
27 purchase_account string
Refrence Document Type:
Account, Field: name
28 description_html text
29 item_name string
30 show_in_website int
31 default_income_account string
Refrence Document Type:
Account, Field: name
32 end_of_life date
33 website_warehouse string
Refrence Document Type:
Warehouse, Field: name
34 is_sales_item string Default: Yes Options: Yes, No
Default: Yes
35 is_sub_contracted_item string Default: No Options: Yes, No
Default: No
36 manufacturer_part_no string
37 stock_uom string
Refrence Document Type:
UOM, Field: name
38 page_name string
39 manufacturer string
40 tolerance decimal
41 default_supplier string
Refrence Document Type:
Supplier, Field: name
42 is_pro_applicable string Default: No Options: Yes, No
Default: No
43 is_purchase_item string Default: Yes Options: Yes, No
Default: Yes
44 is_manufactured_item string Default: No Options: Yes, No
Default: No
45 description text
46 brand string
Refrence Document Type:
Brand, Field: name
47 barcode string
48 slideshow string
Refrence Document Type:
Website Slideshow, Field: name
49 item_code string
50 is_stock_item string Default: Yes Options: Yes, No
Default: Yes
51 inspection_required string Default: No Options: Yes, No
Default: No
52 re_order_qty decimal
53 weight_uom string
Refrence Document Type:
UOM, Field: name
54 default_warehouse string
Refrence Document Type:
Warehouse, Field: name
55 customer_code string
56 item_group string
Refrence Document Type:
Item Group, Field: name
57 min_order_qty decimal Default: 0.000000
Default: 0.000000
58 lead_time_days int
59 web_long_description text
60 has_batch_no string Default: No Options: Yes, No
Default: No
61 has_serial_no string Default: No Options: Yes, No
Default: No
62 standard_rate decimal
63 item_name_in_arabic string
64 description_in_arabic text
65 default_expense_account string
Refrence Document Type:
Account, Field: name
66 open_cart_id string
80 item_customer_detail Array Array of: Item Customer Detail
81 item_quality_inspection_parameter Array Array of: Item Quality Inspection Parameter
82 item_reorder Array Array of: Item Reorder
83 item_supplier Array Array of: Item Supplier
84 item_tax Array Array of: Item Tax
85 item_website_specification Array Array of: Item Website Specification
86 uom_conversion_detail Array Array of: UOM Conversion Detail
87 website_item_group Array Array of: Website Item Group

Item Customer Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Item field: name
8 parentfield string
9 parenttype string Options: Item
10 idx int
11 ref_code string
12 customer_name string
Refrence Document Type:
Customer, Field: name

Item Group

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 rgt int
12 description text
13 item_group_name string
14 is_group string Options: Yes, No
15 slideshow string
Refrence Document Type:
Website Slideshow, Field: name
16 parent_item_group string
Refrence Document Type:
Item Group, Field: name
17 old_parent string
Refrence Document Type:
Item Group, Field: name
18 lft int
19 page_name string
20 show_in_website int
21 open_cart_id string
23 item_website_specification Array Array of: Item Website Specification

Item Price

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Price List field: name
8 parentfield string
9 parenttype string Options: Price List
10 idx int
11 ref_rate decimal
12 item_code string
Refrence Document Type:
Item, Field: name

Item Quality Inspection Parameter

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Item field: name
8 parentfield string
9 parenttype string Options: Item
10 idx int
11 specification string
12 value string

Item Reorder

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Item field: name
8 parentfield string
9 parenttype string Options: Item
10 idx int
11 warehouse string
Refrence Document Type:
Warehouse, Field: name
12 warehouse_reorder_qty decimal
13 warehouse_reorder_level decimal
14 material_request_type string Options: Purchase, Transfer

Item Supplier

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Item field: name
8 parentfield string
9 parenttype string Options: Item
10 idx int
11 supplier string
Refrence Document Type:
Supplier, Field: name
12 supplier_part_no string

Item Tax

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Item field: name
8 parentfield string
9 parenttype string Options: Item
10 idx int
11 tax_type string
Refrence Document Type:
Account, Field: name
12 tax_rate decimal

Item Website Specification

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Item Group field: name
Refrence Document Type: Item field: name
8 parentfield string
9 parenttype string Options: Item Group, Item,
10 idx int
11 description text
12 label string

Job Applicant

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Options: Open, Replied, Rejected, Hold
12 email_id string
13 job_opening string
Refrence Document Type:
Job Opening, Field: name
14 applicant_name string

Job Opening

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Options: Open, Closed
12 description text
13 job_title string

Journal Voucher

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 naming_series string Options: JV
12 clearance_date date
13 voucher_type string Options: Journal Entry, Bank Voucher, Cash Voucher, Credit Card Voucher, Debit Note, Credit Note, Contra Voucher, Excise Voucher, Write Off Voucher, Opening Entry, Salary Voucher
14 letter_head string
Refrence Document Type:
Letter Head, Field: name
15 cheque_no string
16 bill_no string
17 difference decimal
18 write_off_amount decimal
19 amended_from string
Refrence Document Type:
Journal Voucher, Field: name
20 company string
Refrence Document Type:
Company, Field: name
21 due_date date
22 cheque_date date
23 total_amount_in_words string
24 aging_date date
25 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
26 total_credit decimal
27 user_remark text
28 pay_to_recd_from string
29 remark text
30 total_amount string
31 write_off_based_on string Default: Accounts Receivable Options: Accounts Receivable, Accounts Payable
Default: Accounts Receivable
32 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
33 total_debit decimal
34 is_opening string Default: No Options: No, Yes
Default: No
35 posting_date date
36 bill_date date
37 _user_tags string
41 journal_voucher_detail Array Array of: Journal Voucher Detail

Journal Voucher Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Journal Voucher field: name
8 parentfield string
9 parenttype string Options: Journal Voucher
10 idx int
11 account string
Refrence Document Type:
Account, Field: name
12 against_voucher string
Refrence Document Type:
Purchase Invoice, Field: name
13 against_jv string
Refrence Document Type:
Journal Voucher, Field: name
14 credit decimal
15 against_invoice string
Refrence Document Type:
Sales Invoice, Field: name
16 is_advance int
17 debit decimal
18 cost_center string
Refrence Document Type:
Cost Center, Field: name
19 balance decimal
20 against_account text
21 against_salary_slip string
Refrence Document Type:
Salary Slip, Field: name
22 remark string
23 project_name string

Landed Cost Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Landed Cost Wizard field: name
8 parentfield string
9 parenttype string Options: Landed Cost Wizard
10 idx int
11 amount decimal
12 account_head string
Refrence Document Type:
Account, Field: name
13 description string

Landed Cost Purchase Receipt

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Landed Cost Wizard field: name
8 parentfield string
9 parenttype string Options: Landed Cost Wizard
10 idx int
11 purchase_receipt string
Refrence Document Type:
Purchase Receipt, Field: name
12 select_pr int

Lead

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 website string
12 email_id string
13 naming_series string Options: LEAD
14 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
15 mobile_no string
16 lead_name string
17 campaign_name string
Refrence Document Type:
Campaign, Field: name
18 source string Options: Advertisement, Blog Post, Campaign, Call, Customer, Exhibition, Supplier, Website, Email
19 contact_by string
Refrence Document Type:
Profile, Field: name
20 company_name string
21 territory string
Refrence Document Type:
Territory, Field: name
22 type string Options: Client, Channel Partner, Consultant
23 status string Default: Open Options: Open, Replied, Attempted to Contact, Contact in Future, Contacted, Interested, Not interested, Lead Lost, Converted, Passive
Default: Open
24 fax string
25 unsubscribed int
26 company string
Refrence Document Type:
Company, Field: name
27 market_segment string Options: Lower Income, Middle Income, Upper Income
28 blog_subscriber int
29 lead_owner string
Refrence Document Type:
Profile, Field: name
30 phone string
31 request_type string Options: Product Enquiry, Request for Information, Suggestions, Other
32 customer string
Refrence Document Type:
Customer, Field: name
33 order_lost_reason string
Refrence Document Type:
Quotation Lost Reason, Field: name
34 remark text
35 last_contact_date date
36 industry string
Refrence Document Type:
Industry Type, Field: name
37 contact_date date
38 _user_tags string

Leave Allocation

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 description text
12 new_leaves_allocated decimal
13 carry_forwarded_leaves decimal
14 carry_forward int
15 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
16 total_leaves_allocated decimal
17 amended_from string
18 leave_type string
Refrence Document Type:
Leave Type, Field: name
19 employee_name string
20 employee string
Refrence Document Type:
Employee, Field: name
21 posting_date date

Leave Application

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Default: Open Options: Open, Approved, Rejected
Default: Open
12 letter_head string
Refrence Document Type:
Letter Head, Field: name
13 amended_from string
Refrence Document Type:
Leave Application, Field: name
14 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
15 description text
16 leave_balance decimal
17 follow_via_email int Default: 1
Default: 1
18 from_date date
19 leave_approver string
Refrence Document Type:
Profile, Field: name
20 employee string
Refrence Document Type:
Employee, Field: name
21 leave_type string
Refrence Document Type:
Leave Type, Field: name
22 to_date date
23 employee_name string
24 half_day int
25 posting_date date
26 total_leave_days decimal
27 company string
Refrence Document Type:
Company, Field: name

Leave Block List

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 applies_to_all_departments int
12 leave_block_list_name string
13 year string
Refrence Document Type:
Fiscal Year, Field: name
14 company string
Refrence Document Type:
Company, Field: name
16 leave_block_list_allow Array Array of: Leave Block List Allow
17 leave_block_list_date Array Array of: Leave Block List Date

Leave Block List Allow

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Leave Block List field: name
8 parentfield string
9 parenttype string Options: Leave Block List
10 idx int
11 allow_user string
Refrence Document Type:
Profile, Field: name

Leave Block List Date

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Leave Block List field: name
8 parentfield string
9 parenttype string Options: Leave Block List
10 idx int
11 block_date date
12 reason text

Leave Type

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 is_lwp int
12 trash_reason text
13 is_encash int
14 allow_negative int
15 max_days_allowed string
16 is_carry_forward int
17 leave_type_name string

Legal Document

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Company field: name
8 parentfield string
9 parenttype string Options: Company
10 idx int
11 expiration_date date
12 issue_date date
13 legal_document_type string
Refrence Document Type:
Legal Document Type, Field: name

Legal Document Type

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 legal_document_type string

Maintenance Request

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 technical_report text
12 date_of_maintenance date
13 description_of_service text
14 maintenance_required_type string Options: Desktop Device, Laptop, Printer, Fax, Internet, Other
15 amended_from string
Refrence Document Type:
Maintenance Request, Field: name
16 department string
17 employee_name string
18 employee string
Refrence Document Type:
Employee, Field: name
19 other longtext
20 workflow_state string

Maintenance Request Workflow History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 update_field string Options: NULL
12 state string
Refrence Document Type:
Workflow State, Field: name
13 update_value string
14 reason string
15 user string
Refrence Document Type:
Profile, Field: name
16 doc_status int

Maintenance Schedule

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Default: Draft Options: Draft, Submitted, Cancelled
Default: Draft
12 customer_name string
13 amended_from string
14 transaction_date date
15 contact_display text
16 territory string
Refrence Document Type:
Territory, Field: name
17 address_display text
18 company string
Refrence Document Type:
Company, Field: name
19 customer_address string
Refrence Document Type:
Address, Field: name
20 contact_email string
21 contact_mobile string
22 customer string
Refrence Document Type:
Customer, Field: name
23 customer_group string
Refrence Document Type:
Customer Group, Field: name
24 contact_person string
Refrence Document Type:
Contact, Field: name
27 maintenance_schedule_detail Array Array of: Maintenance Schedule Detail
28 maintenance_schedule_item Array Array of: Maintenance Schedule Item

Maintenance Schedule Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Maintenance Schedule field: name
8 parentfield string
9 parenttype string Options: Maintenance Schedule
10 idx int
11 item_name string
12 serial_no text
13 item_code string
Refrence Document Type:
Item, Field: name
14 scheduled_date date
15 incharge_name string
Refrence Document Type:
Sales Person, Field: name
16 actual_date date

Maintenance Schedule Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Maintenance Schedule field: name
8 parentfield string
9 parenttype string Options: Maintenance Schedule
10 idx int
11 description string
12 end_date date
13 item_name string
14 serial_no text
15 prevdoc_docname string
16 item_code string
Refrence Document Type:
Item, Field: name
17 no_of_visits int
18 incharge_name string
Refrence Document Type:
Sales Person, Field: name
19 start_date date
20 periodicity string Options: Weekly, Monthly, Quarterly, Half Yearly, Yearly, Random

Maintenance Visit

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 maintenance_type string Default: Unscheduled Options: Scheduled, Unscheduled, Breakdown
Default: Unscheduled
12 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
13 customer_name string
14 completion_status string Options: Partially Completed, Fully Completed
15 amended_from string
16 contact_display text
17 territory string
Refrence Document Type:
Territory, Field: name
18 address_display text
19 mntc_date date
20 customer_feedback text
21 company string
Refrence Document Type:
Company, Field: name
22 customer_address string
Refrence Document Type:
Address, Field: name
23 mntc_time time
24 contact_email string
25 contact_mobile string
26 customer string
Refrence Document Type:
Customer, Field: name
27 customer_group string
Refrence Document Type:
Customer Group, Field: name
28 status string Default: Draft
Default: Draft
29 contact_person string
Refrence Document Type:
Contact, Field: name
33 maintenance_visit_purpose Array Array of: Maintenance Visit Purpose

Maintenance Visit Purpose

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Maintenance Visit field: name
8 parentfield string
9 parenttype string Options: Maintenance Visit
10 idx int
11 work_done text
12 description text
13 prevdoc_docname string
14 prevdoc_detail_docname string
15 item_name string
16 serial_no text
17 item_code string
Refrence Document Type:
Item, Field: name
18 prevdoc_doctype string
19 service_person string
Refrence Document Type:
Sales Person, Field: name

Material Request

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 naming_series string Options: MREQ-, IDT
12 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
13 requested_by string
14 letter_head string
Refrence Document Type:
Letter Head, Field: name
15 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
16 amended_from string
17 transaction_date date
18 status string Options: Draft, Submitted, Stopped, Cancelled
19 terms text
20 company string
Refrence Document Type:
Company, Field: name
21 per_ordered decimal
22 remark text
23 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
24 material_request_type string Options: Purchase, Transfer
25 _user_tags string
26 workflow_state string
28 material_request_item Array Array of: Material Request Item

Material Request Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Material Request field: name
8 parentfield string
9 parenttype string Options: Material Request
10 idx int
11 page_break int
12 description text
13 item_name string
14 brand string
Refrence Document Type:
Brand, Field: name
15 item_group string
Refrence Document Type:
Item Group, Field: name
16 min_order_qty decimal
17 item_code string
Refrence Document Type:
Item, Field: name
18 qty decimal
19 projected_qty decimal
20 sales_order_no string
Refrence Document Type:
Sales Order, Field: name
21 ordered_qty decimal
22 warehouse string
Refrence Document Type:
Warehouse, Field: name
23 schedule_date date
24 uom string
Refrence Document Type:
UOM, Field: name
25 lead_time_date date

Mode of Payment

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 company string
12 mode_of_payment string
13 default_account string

Office Supply Request

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 amended_from string
Refrence Document Type:
Office Supply Request, Field: name
12 department string
13 employee_name string
14 employee string
Refrence Document Type:
Employee, Field: name
15 workflow_state string
17 stationary_tool Array Array of: Stationary Tool

Office Supply Request Workflow History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 update_field string Options: NULL
12 state string
Refrence Document Type:
Workflow State, Field: name
13 update_value string
14 reason string
15 user string
Refrence Document Type:
Profile, Field: name
16 doc_status int

Opportunity

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 address_display text
12 campaign string
Refrence Document Type:
Campaign, Field: name
13 naming_series string Options: OPPT
14 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
15 enquiry_type string Options: Sales, Maintenance
16 enquiry_from string Options: Lead, Customer
17 customer_name string
18 lead string
Refrence Document Type:
Lead, Field: name
19 amended_from string
20 source string Options: Existing Customer, Reference, Advertisement, Cold Calling, Exhibition, Supplier Reference, Mass Mailing, Customer's Vendor, Campaign, Walk In
21 contact_by string
Refrence Document Type:
Profile, Field: name
22 transaction_date date
23 contact_display text
24 territory string
Refrence Document Type:
Territory, Field: name
25 company string
Refrence Document Type:
Company, Field: name
26 customer_address string
Refrence Document Type:
Address, Field: name
27 contact_email text
28 contact_mobile text
29 customer string
Refrence Document Type:
Customer, Field: name
30 order_lost_reason text
31 contact_date date
32 customer_group string
Refrence Document Type:
Customer Group, Field: name
33 status string Default: Draft Options: Draft, Submitted, Quotation Sent, Order Confirmed, Opportunity Lost, Cancelled
Default: Draft
34 to_discuss text
35 last_contact_date date
36 contact_person string
Refrence Document Type:
Contact, Field: name
39 opportunity_item Array Array of: Opportunity Item

Opportunity Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Opportunity field: name
8 parentfield string
9 parenttype string Options: Opportunity
10 idx int
11 basic_rate decimal
12 description text
13 item_name string
14 brand string
Refrence Document Type:
Brand, Field: name
15 item_group string
Refrence Document Type:
Item Group, Field: name
16 item_code string
Refrence Document Type:
Item, Field: name
17 qty decimal
18 uom string
Refrence Document Type:
UOM, Field: name

Packing Slip

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 gross_weight_pkg decimal
12 to_case_no string
13 from_case_no string
14 naming_series string Options: PS
15 net_weight_uom string
Refrence Document Type:
UOM, Field: name
16 gross_weight_uom string
Refrence Document Type:
UOM, Field: name
17 amended_from string
Refrence Document Type:
Packing Slip, Field: name
18 delivery_note string
Refrence Document Type:
Delivery Note, Field: name
19 net_weight_pkg decimal
21 packing_slip_item Array Array of: Packing Slip Item

Packing Slip Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Packing Slip field: name
8 parentfield string
9 parenttype string Options: Packing Slip
10 idx int
11 weight_uom string
Refrence Document Type:
UOM, Field: name
12 page_break int
13 item_name string
14 net_weight decimal
15 qty decimal
16 stock_uom string
Refrence Document Type:
UOM, Field: name
17 item_code string
Refrence Document Type:
Item, Field: name
18 dn_detail string

Payment to Invoice Matching Tool Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Payment to Invoice Matching Tool field: name
8 parentfield string
9 parenttype string Options: Payment to Invoice Matching Tool
10 idx int
11 total_amt decimal
12 voucher_detail_no string
13 amt_due decimal
14 remarks text
15 posting_date date
16 voucher_no string
Refrence Document Type:
Journal Voucher, Field: name
17 amt_to_be_reconciled decimal
18 against_account string

Payment Voucher

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 payment_for string Default: Supplier Options: Supplier, Customer
Default: Supplier
12 customer1 string
Refrence Document Type:
Supplier, Field: name
13 naming_series string
14 cheque_date date
15 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
16 cheque_no string
17 amended_from string
Refrence Document Type:
Payment Voucher, Field: name
18 collection_date date
19 transfer_no string
20 select_invoice1 string
Refrence Document Type:
Purchase Invoice, Field: name
21 advance_amount decimal
22 against_sales_invoice string
23 supplier string
Refrence Document Type:
Supplier, Field: name
24 type string Default: Cash Options: Cash, Cheque, Wire Transfer
Default: Cash
25 company string
Refrence Document Type:
Company, Field: name
26 customer_to_pay_to string
Refrence Document Type:
Account, Field: name
27 user_remark text
28 bank string
Refrence Document Type:
Bank, Field: name
29 total_amount decimal
30 account string
Refrence Document Type:
Account, Field: name
31 in_words string
32 net_total decimal
33 posting_date date
34 balance decimal
35 transfer_date date
39 payment_voucher_detail Array Array of: Payment Voucher Detail

Payment Voucher Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Payment Voucher field: name
8 parentfield string
9 parenttype string Options: Payment Voucher
10 idx int
11 due_amount decimal
12 amount_to_be_paid decimal
13 select_invoice string Options: NULL

Period Closing Voucher

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 company string
Refrence Document Type:
Company, Field: name
12 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
13 amended_from string
14 transaction_date date
15 remarks text
16 posting_date date
17 closing_account_head string
Refrence Document Type:
Account, Field: name

POS Setting

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 customer string
Refrence Document Type:
Customer, Field: name
12 cash_bank_account string
Refrence Document Type:
Account, Field: name
13 update_stock int Default: 1
Default: 1
14 naming_series string Options: NULL
15 company string
Refrence Document Type:
Company, Field: name
16 selling_price_list string
Refrence Document Type:
Price List, Field: name
17 charge string
Refrence Document Type:
Sales Taxes and Charges Master, Field: name
18 expense_account string
Refrence Document Type:
Account, Field: name
19 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
20 currency string
Refrence Document Type:
Currency, Field: name
21 conversion_rate decimal
22 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
23 user string
Refrence Document Type:
Profile, Field: name
24 warehouse string
Refrence Document Type:
Warehouse, Field: name
25 cost_center string
Refrence Document Type:
Cost Center, Field: name
26 territory string
Refrence Document Type:
Territory, Field: name
27 income_account string
Refrence Document Type:
Account, Field: name
28 letter_head string
Refrence Document Type:
Letter Head, Field: name

POS Standalone

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 connection_status string Default: Disconnected Options: Connected, Disconnected
Default: Disconnected
12 company string
Refrence Document Type:
Company, Field: name
13 pos_setting string
Refrence Document Type:
POS Setting, Field: name
14 branch string
Refrence Document Type:
Branch, Field: name
15 pos_name string
18 pos_standalone_users Array Array of: POS Standalone Users

POS Standalone Users

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: POS Standalone field: name
8 parentfield string
9 parenttype string Options: POS Standalone
10 idx int
11 first_name string
12 Last_name string
13 pos_user string
Refrence Document Type:
Profile, Field: name

Price List

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 price_list_name string
12 currency string
Refrence Document Type:
Currency, Field: name
13 buying_or_selling string Default: Selling Options: Buying, Selling
Default: Selling
16 for_territory Array Array of: For Territory
17 item_price Array Array of: Item Price

Production Order

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 use_multi_level_bom int Default: 1
Default: 1
12 status string Options: Draft, Submitted, Stopped, In Process, Completed, Cancelled
13 bom_no string
Refrence Document Type:
BOM, Field: name
14 project_name string
Refrence Document Type:
Project, Field: name
15 wip_warehouse string
Refrence Document Type:
Warehouse, Field: name
16 sales_order string
Refrence Document Type:
Sales Order, Field: name
17 amended_from string
18 naming_series string Default: PRO Options: PRO
Default: PRO
19 description text
20 produced_qty decimal
21 production_item string
Refrence Document Type:
Item, Field: name
22 qty decimal
23 stock_uom string
Refrence Document Type:
UOM, Field: name
24 company string
Refrence Document Type:
Company, Field: name
25 fg_warehouse string
Refrence Document Type:
Warehouse, Field: name

Production Plan Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Production Planning Tool field: name
8 parentfield string
9 parenttype string Options: Production Planning Tool
10 idx int
11 bom_no string
Refrence Document Type:
BOM, Field: name
12 description text
13 sales_order string
Refrence Document Type:
Sales Order, Field: name
14 planned_qty decimal
15 item_code string
Refrence Document Type:
Item, Field: name
16 stock_uom string
Refrence Document Type:
UOM, Field: name
17 warehouse string
Refrence Document Type:
Warehouse, Field: name
18 so_pending_qty decimal

Production Plan Sales Order

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Production Planning Tool field: name
8 parentfield string
9 parenttype string Options: Production Planning Tool
10 idx int
11 customer string
Refrence Document Type:
Customer, Field: name
12 grand_total decimal
13 sales_order_date date
14 sales_order string
Refrence Document Type:
Sales Order, Field: name

Profile

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 user_image string Options: attach_files:
12 last_name string
13 email_password string
14 last_ip string
15 user_type string Default: System User Options: System User, Website User, Self Service Employee
Default: System User
16 reset_password_key string
17 sync_inbox int
18 email_use_ssl int
19 restrict_ip string
20 first_name string
21 middle_name string
22 new_password string
23 email_login string
24 unsubscribed int
25 last_login string
26 email string
27 bio text
28 background_image string Options: attach_files:
29 login_after int
30 email_signature text
31 language string Options: Loading...
32 login_before int
33 gender string Options: Male, Female
34 send_invite_email int Default: 1
Default: 1
35 enabled int Default: 1
Default: 1
36 birth_date date
37 email_host string
38 is_release_notes_viewed int
39 is_password_changed int
40 use_two_factor_authentication int
41 mobile_number string
42 two_factor_key string
47 userrole Array Array of: UserRole

Project

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 completion_date date
12 per_gross_margin decimal
13 project_type string Options: Internal, External, Other
14 est_material_cost decimal
15 priority string Options: Medium, Low, High
16 status string Default: Open Options: Open, Completed, Cancelled
Default: Open
17 project_name string
18 company string
Refrence Document Type:
Company, Field: name
19 is_active string Options: Yes, No
20 percent_complete decimal
21 customer string
Refrence Document Type:
Customer, Field: name
22 gross_margin_value decimal
23 act_completion_date date
24 notes text
25 project_start_date date
26 project_value decimal
27 _user_tags string
30 project_milestone Array Array of: Project Milestone

Project Milestone

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Project field: name
8 parentfield string
9 parenttype string Options: Project
10 idx int
11 status string Options: Pending, Completed
12 milestone text
13 milestone_date date

Purchase Invoice

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 against_expense_account text
12 write_off_amount decimal
13 due_date date
14 supplier_address string
Refrence Document Type:
Address, Field: name
15 naming_series string Options: BILL, BILLJ
16 in_words_import string
17 supplier_name text
18 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
19 currency string
Refrence Document Type:
Currency, Field: name
20 conversion_rate decimal
21 total_advance decimal
22 grand_total decimal
23 bill_no string
24 aging_date date
25 mode_of_payment string
Refrence Document Type:
Mode of Payment, Field: name
26 write_off_cost_center string
Refrence Document Type:
Cost Center, Field: name
27 price_list_currency string
Refrence Document Type:
Currency, Field: name
28 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
29 amended_from string
Refrence Document Type:
Purchase Invoice, Field: name
30 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
31 contact_display text
32 other_charges_added_import decimal
33 supplier string
Refrence Document Type:
Supplier, Field: name
34 grand_total_import decimal
35 buying_price_list string
Refrence Document Type:
Price List, Field: name
36 bill_date date
37 address_display text
38 total_tax decimal
39 total_amount_to_pay decimal
40 terms text
41 company string
Refrence Document Type:
Company, Field: name
42 outstanding_amount decimal
43 is_opening string Default: No Options: No, Yes
Default: No
44 write_off_account string
Refrence Document Type:
Account, Field: name
45 other_charges_added decimal
46 contact_email text
47 purchase_other_charges string
Refrence Document Type:
Purchase Taxes and Charges Master, Field: name
48 contact_mobile text
49 contact_person string
Refrence Document Type:
Contact, Field: name
50 net_total_import decimal
51 other_charges_deducted_import decimal
52 other_charges_deducted decimal
53 remarks text
54 in_words string
55 plc_conversion_rate decimal
56 credit_to string
Refrence Document Type:
Account, Field: name
57 net_total decimal
58 posting_date date
61 purchase_invoice_advance Array Array of: Purchase Invoice Advance
62 purchase_invoice_item Array Array of: Purchase Invoice Item
63 purchase_taxes_and_charges Array Array of: Purchase Taxes and Charges

Purchase Invoice Advance

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Purchase Invoice field: name
8 parentfield string
9 parenttype string Options: Purchase Invoice
10 idx int
11 remarks text
12 allocated_amount decimal
13 journal_voucher string
Refrence Document Type:
Journal Voucher, Field: name
14 jv_detail_no string
15 advance_amount decimal
16 pv_detail_no string
17 payment_voucher string
Refrence Document Type:
Payment Voucher, Field: name

Purchase Invoice Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Purchase Invoice field: name
8 parentfield string
9 parenttype string Options: Purchase Invoice
10 idx int
11 purchase_receipt string
Refrence Document Type:
Purchase Receipt, Field: name
12 po_detail string
13 qty decimal
14 item_tax_rate text
15 rate decimal
16 import_amount decimal
17 discount_rate decimal
18 cost_center string
Refrence Document Type:
Cost Center, Field: name
19 rm_supp_cost decimal
20 import_ref_rate decimal
21 page_break int
22 item_name string
23 purchase_order string
Refrence Document Type:
Purchase Order, Field: name
24 conversion_factor decimal
25 pr_detail string
26 uom string
Refrence Document Type:
UOM, Field: name
27 project_name string
Refrence Document Type:
Project, Field: name
28 description text
29 import_rate decimal
30 brand string
31 item_code string
Refrence Document Type:
Item, Field: name
32 purchase_ref_rate decimal
33 expense_head string
Refrence Document Type:
Account, Field: name
34 item_group string
Refrence Document Type:
Item Group, Field: name
35 amount decimal
36 item_tax_amount decimal
37 valuation_rate decimal

Purchase Order

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 purchase_other_charges string
Refrence Document Type:
Purchase Taxes and Charges Master, Field: name
12 supplier_address string
Refrence Document Type:
Address, Field: name
13 naming_series string Options: PO
14 in_words_import string
15 supplier_name string
16 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
17 currency string
Refrence Document Type:
Currency, Field: name
18 conversion_rate decimal
19 payment_terms text
20 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
21 is_subcontracted string Default: No Options: Yes, No
Default: No
22 price_list_currency string
Refrence Document Type:
Currency, Field: name
23 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
24 amended_from string
25 transaction_date date
26 contact_display text
27 other_charges_added_import decimal
28 supplier string
Refrence Document Type:
Supplier, Field: name
29 grand_total_import decimal
30 buying_price_list string
Refrence Document Type:
Price List, Field: name
31 address_display text
32 total_tax decimal
33 terms text
34 company string
Refrence Document Type:
Company, Field: name
35 grand_total decimal
36 per_billed decimal
37 other_charges_added decimal
38 contact_email text
39 contact_mobile text
40 remarks text
41 net_total_import decimal
42 instructions text
43 other_charges_deducted_import decimal
44 other_charges_deducted decimal
45 ref_sq string
46 per_received decimal
47 letter_head string
Refrence Document Type:
Letter Head, Field: name
48 plc_conversion_rate decimal
49 net_total decimal
50 status string Options: Draft, Submitted, Stopped, Cancelled
51 rounded_total decimal
52 contact_person string
Refrence Document Type:
Contact, Field: name
53 in_words string
56 purchase_order_item Array Array of: Purchase Order Item
57 purchase_order_item_supplied Array Array of: Purchase Order Item Supplied
58 purchase_taxes_and_charges Array Array of: Purchase Taxes and Charges

Purchase Order Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Purchase Order field: name
8 parentfield string
9 parenttype string Options: Purchase Order
10 idx int
11 stock_qty decimal
12 qty decimal
13 item_tax_rate text
14 import_amount decimal
15 discount_rate decimal
16 received_qty decimal
17 stock_uom string
Refrence Document Type:
UOM, Field: name
18 import_ref_rate decimal
19 page_break int
20 purchase_rate decimal
21 item_name string
22 supplier_quotation string
Refrence Document Type:
Supplier Quotation, Field: name
23 supplier_quotation_item string
Refrence Document Type:
Supplier Quotation Item, Field: name
24 prevdoc_detail_docname string
25 conversion_factor decimal
26 warehouse string
Refrence Document Type:
Warehouse, Field: name
27 billed_amt decimal
28 supplier_part_no string
29 uom string
Refrence Document Type:
UOM, Field: name
30 project_name string
Refrence Document Type:
Project, Field: name
31 description text
32 prevdoc_docname string
Refrence Document Type:
Material Request, Field: name
33 import_rate decimal
34 brand string
Refrence Document Type:
Brand, Field: name
35 item_code string
Refrence Document Type:
Item, Field: name
36 purchase_ref_rate decimal
37 prevdoc_date date
38 schedule_date date
39 item_group string
Refrence Document Type:
Item Group, Field: name
40 amount decimal
41 prevdoc_doctype string

Purchase Order Item Supplied

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Purchase Order field: name
8 parentfield string
9 parenttype string Options: Purchase Order
10 idx int
11 rm_item_code string
12 stock_uom string
Refrence Document Type:
UOM, Field: name
13 reference_name string
14 rate decimal
15 main_item_code string
16 required_qty decimal
17 conversion_factor decimal
18 amount decimal
19 bom_detail_no string

Purchase Receipt

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Options: Draft, Submitted, Cancelled
12 lr_date date
13 supplier_address string
Refrence Document Type:
Address, Field: name
14 naming_series string Options: GRN
15 in_words_import string
16 supplier_name string
17 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
18 currency string
Refrence Document Type:
Currency, Field: name
19 conversion_rate decimal Default: 1.000000
Default: 1.000000
20 bill_date date
21 challan_no string
22 posting_time time
23 bill_no string
24 lr_no string
25 rejected_warehouse string
Refrence Document Type:
Warehouse, Field: name
26 supplier_warehouse string
Refrence Document Type:
Warehouse, Field: name
27 is_subcontracted string Default: No Options: Yes, No
Default: No
28 price_list_currency string
Refrence Document Type:
Currency, Field: name
29 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
30 amended_from string
31 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
32 contact_display text
33 other_charges_added_import decimal
34 supplier string
Refrence Document Type:
Supplier, Field: name
35 grand_total_import decimal
36 rounded_total decimal
37 buying_price_list string
Refrence Document Type:
Price List, Field: name
38 address_display text
39 total_tax decimal
40 terms text
41 company string
Refrence Document Type:
Company, Field: name
42 grand_total decimal
43 transporter_name string
44 other_charges_added decimal
45 contact_email text
46 purchase_other_charges string
Refrence Document Type:
Purchase Taxes and Charges Master, Field: name
47 contact_mobile text
48 remarks text
49 net_total_import decimal
50 instructions text
51 other_charges_deducted_import decimal
52 other_charges_deducted decimal
53 challan_date date
54 plc_conversion_rate decimal
55 range string
56 net_total decimal
57 posting_date date
58 contact_person string
Refrence Document Type:
Contact, Field: name
59 in_words string
63 purchase_receipt_item Array Array of: Purchase Receipt Item
64 purchase_receipt_item_supplied Array Array of: Purchase Receipt Item Supplied
65 purchase_taxes_and_charges Array Array of: Purchase Taxes and Charges

Purchase Receipt Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Purchase Receipt field: name
8 parentfield string
9 parenttype string Options: Purchase Receipt
10 idx int
11 stock_qty decimal
12 rm_supp_cost decimal
13 serial_no text
14 qty decimal
15 item_tax_rate text
16 import_amount decimal
17 discount_rate decimal
18 received_qty decimal
19 stock_uom string
Refrence Document Type:
UOM, Field: name
20 import_ref_rate decimal
21 page_break int
22 rejected_warehouse string
Refrence Document Type:
Warehouse, Field: name
23 purchase_rate decimal
24 item_name string
25 prevdoc_detail_docname string
26 conversion_factor decimal
27 qa_no string
Refrence Document Type:
Quality Inspection, Field: name
28 warehouse string
Refrence Document Type:
Warehouse, Field: name
29 uom string
Refrence Document Type:
UOM, Field: name
30 project_name string
Refrence Document Type:
Project, Field: name
31 description text
32 prevdoc_docname string
Refrence Document Type:
Purchase Order, Field: name
33 import_rate decimal
34 brand string
Refrence Document Type:
Brand, Field: name
35 rejected_serial_no text
36 item_code string
Refrence Document Type:
Item, Field: name
37 rejected_qty decimal
38 purchase_ref_rate decimal
39 prevdoc_date date
40 schedule_date date
41 item_group string
Refrence Document Type:
Item Group, Field: name
42 amount decimal
43 item_tax_amount decimal
44 batch_no string
Refrence Document Type:
Batch, Field: name
45 valuation_rate decimal
46 prevdoc_doctype string

Purchase Receipt Item Supplied

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Purchase Receipt field: name
8 parentfield string
9 parenttype string Options: Purchase Receipt
10 idx int
11 rm_item_code string
12 stock_uom string
Refrence Document Type:
UOM, Field: name
13 description string
14 reference_name string
15 rate decimal
16 main_item_code string
17 required_qty decimal
18 conversion_factor decimal
19 current_stock decimal
20 amount decimal
21 consumed_qty decimal
22 bom_detail_no string

Purchase Taxes and Charges

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Purchase Taxes and Charges Master field: name
Refrence Document Type: Purchase Invoice field: name
Refrence Document Type: Supplier Quotation field: name
Refrence Document Type: Purchase Order field: name
Refrence Document Type: Purchase Receipt field: name
8 parentfield string
9 parenttype string Options: Purchase Taxes and Charges Master, Purchase Invoice, Supplier Quotation, Purchase Order, Purchase Receipt,
10 idx int
11 category string Default: Valuation and Total Options: Valuation and Total, Valuation, Total
Default: Valuation and Total
12 charge_type string Options: Actual, On Net Total, On Previous Row Amount, On Previous Row Total
13 tax_amount decimal
14 description text
15 item_wise_tax_detail text
16 row_id string
17 add_deduct_tax string Default: Add Options: Add, Deduct
Default: Add
18 rate decimal
19 account_head string
Refrence Document Type:
Account, Field: name
20 total decimal
21 cost_center string
Refrence Document Type:
Cost Center, Field: name

Purchase Taxes and Charges Master

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 is_default int
12 company string
Refrence Document Type:
Company, Field: name
13 title string
15 purchase_taxes_and_charges Array Array of: Purchase Taxes and Charges

Quality Inspection

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 inspected_by string
12 amended_from string
13 description text
14 delivery_note_no string
Refrence Document Type:
Delivery Note, Field: name
15 naming_series string Options: QAI/11-12/
16 inspection_type string Options: Incoming, Outgoing, In Process
17 verified_by string
18 item_serial_no string
Refrence Document Type:
Serial No, Field: name
19 report_date date
20 item_code string
Refrence Document Type:
Item, Field: name
21 sample_size decimal
22 purchase_receipt_no string
Refrence Document Type:
Purchase Receipt, Field: name
23 batch_no string
Refrence Document Type:
Batch, Field: name
24 remarks text
26 quality_inspection_reading Array Array of: Quality Inspection Reading

Quality Inspection Reading

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Quality Inspection field: name
8 parentfield string
9 parenttype string Options: Quality Inspection
10 idx int
11 status string Default: Accepted Options: Accepted, Rejected
Default: Accepted
12 specification string
13 value string
14 reading_10 string
15 reading_8 string
16 reading_9 string
17 reading_1 string
18 reading_2 string
19 reading_3 string
20 reading_4 string
21 reading_5 string
22 reading_6 string
23 reading_7 string

Quotation

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 rounded_total_export decimal
12 net_total_export decimal
13 campaign string
Refrence Document Type:
Campaign, Field: name
14 naming_series string Options: QTN
15 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
16 other_charges_total decimal
17 currency string
Refrence Document Type:
Currency, Field: name
18 conversion_rate decimal Default: 1.000000
Default: 1.000000
19 other_charges_total_export decimal
20 shipping_rule string
Refrence Document Type:
Shipping Rule, Field: name
21 customer_name string
22 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
23 order_type string Default: Sales Options: Sales, Maintenance, Shopping Cart
Default: Sales
24 lead string
Refrence Document Type:
Lead, Field: name
25 price_list_currency string
Refrence Document Type:
Currency, Field: name
26 selling_price_list string
Refrence Document Type:
Price List, Field: name
27 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
28 amended_from string
29 charge string
Refrence Document Type:
Sales Taxes and Charges Master, Field: name
30 transaction_date date
31 contact_display text
32 rounded_total decimal
33 company string
Refrence Document Type:
Company, Field: name
34 address_display text
35 terms text
36 enq_det text
37 quotation_to string Options: Lead, Customer
38 shipping_address text
39 status string Default: Draft Options: Draft, Submitted, Order Confirmed, Order Lost, Cancelled
Default: Draft
40 in_words_export string
41 customer_address string
Refrence Document Type:
Address, Field: name
42 contact_email text
43 contact_mobile text
44 shipping_address_name string
Refrence Document Type:
Address, Field: name
45 grand_total_export decimal
46 customer string
Refrence Document Type:
Customer, Field: name
47 order_lost_reason text
48 grand_total decimal
49 in_words string
50 customer_group string
Refrence Document Type:
Customer Group, Field: name
51 territory string
Refrence Document Type:
Territory, Field: name
52 letter_head string
Refrence Document Type:
Letter Head, Field: name
53 plc_conversion_rate decimal
54 net_total decimal
55 source string Options: Existing Customer, Reference, Advertisement, Cold Calling, Exhibition, Supplier Reference, Mass Mailing, Customer's Vendor, Campaign
56 contact_person string
Refrence Document Type:
Contact, Field: name
57 additional_discount_percentage decimal Default: 0.000000
Default: 0.000000
58 apply_additional_discount_on string Default: Net Total Options: Net Total
Default: Net Total
59 additional_discount_amount decimal Default: 0.000000
Default: 0.000000
67 quotation_item Array Array of: Quotation Item
68 sales_taxes_and_charges Array Array of: Sales Taxes and Charges

Quotation Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Quotation field: name
8 parentfield string
9 parenttype string Options: Quotation
10 idx int
11 export_rate decimal
12 basic_rate decimal
13 page_break int
14 ref_rate decimal
15 description text
16 item_tax_rate text
17 item_name string
18 brand string
Refrence Document Type:
Brand, Field: name
19 item_group string
Refrence Document Type:
Item Group, Field: name
20 item_code string
Refrence Document Type:
Item, Field: name
21 qty decimal
22 export_amount decimal
23 amount decimal
24 stock_uom string
Refrence Document Type:
UOM, Field: name
25 customer_item_code string
26 adj_rate decimal
27 base_ref_rate decimal
28 prevdoc_docname string
29 prevdoc_doctype string
30 net_amount_export decimal
31 net_amount decimal

Quotation Lost Reason

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 order_lost_reason string
12 trash_reason text

Receipt Voucher

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 naming_series string
12 cheque_date date
13 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
14 cheque_no string
15 amended_from string
Refrence Document Type:
Receipt Voucher, Field: name
16 collection_date date
17 transfer_no string
18 advance_amount decimal
19 against_sales_invoice string
20 type string Default: Cash Options: Cash, Cheque, Wire Transfer
Default: Cash
21 company string
Refrence Document Type:
Company, Field: name
22 in_words string
23 received_by string Default: Customer Options: Customer
Default: Customer
24 user_remark text
25 total_amount decimal
26 customer string
Refrence Document Type:
Customer, Field: name
27 account string
Refrence Document Type:
Account, Field: name
28 net_total decimal
29 posting_date date
30 balance decimal
31 transfer_date date
32 project_name string
33 open_cart_id string
37 receipt_voucher_detail Array Array of: Receipt Voucher Detail

Receipt Voucher Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Receipt Voucher field: name
8 parentfield string
9 parenttype string Options: Receipt Voucher
10 idx int
11 due_amount decimal
12 amount_to_be_paid decimal
13 select_invoice string Options: NULL
14 open_cart_id string

Salary Slip

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 payment_days string
12 grade string
Refrence Document Type:
Grade, Field: name
13 total_in_words string
14 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
15 month string Options: January, February, March, April, May, June, July, August, September, October, November, December
16 letter_head string
Refrence Document Type:
Letter Head, Field: name
17 total_days_in_month int
18 total_deduction decimal
19 pf_no string
20 leave_encashment_amount decimal
21 email_check int
22 amended_from string
23 leave_without_pay decimal
24 department string
Refrence Document Type:
Department, Field: name
25 esic_no string
26 bank_name string
27 branch string
Refrence Document Type:
Branch, Field: name
28 company string
Refrence Document Type:
Company, Field: name
29 employee string
Refrence Document Type:
Employee, Field: name
30 employee_name string
31 bank_account_no string
32 designation string
Refrence Document Type:
Designation, Field: name
33 net_pay decimal
34 rounded_total decimal
35 gross_pay decimal
36 arrear_amount decimal
37 absent_days int
38 daily_hours string
39 payment_hours string
40 leave_hours_without_pay int
41 absent_hours int
42 leave_days_without_pay int
43 payment_days_hours_text text
44 posting_date date
46 salary_slip_deduction Array Array of: Salary Slip Deduction
47 salary_slip_earning Array Array of: Salary Slip Earning

Salary Slip Deduction

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Salary Slip field: name
8 parentfield string
9 parenttype string Options: Salary Slip
10 idx int
11 d_depends_on_lwp int
12 d_modified_amount decimal
13 d_type string
Refrence Document Type:
Deduction Type, Field: name
14 d_amount decimal
15 reduce_deduction_in_attendance_calculation int
16 accrued_salary_accounts_group string
Refrence Document Type:
Account, Field: name
17 expenses_account string
Refrence Document Type:
Account, Field: name

Salary Slip Earning

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Salary Slip field: name
8 parentfield string
9 parenttype string Options: Salary Slip
10 idx int
11 e_amount decimal
12 e_modified_amount decimal
13 e_type string
Refrence Document Type:
Earning Type, Field: name
14 e_depends_on_lwp int
15 reduce_earning_in_attendance_calculation int
16 accrued_salary_accounts_group string
Refrence Document Type:
Account, Field: name
17 expenses_account string
Refrence Document Type:
Account, Field: name
18 include_in_accrued_vacation int
19 include_in_accrued_end_of_service int

Salary Structure

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 grade string
Refrence Document Type:
Grade, Field: name
12 to_date date
13 total_earning decimal
14 from_date date
15 branch string
Refrence Document Type:
Branch, Field: name
16 department string
Refrence Document Type:
Department, Field: name
17 total_deduction decimal
18 company string
Refrence Document Type:
Company, Field: name
19 is_active string Default: Yes Options: Yes, No
Default: Yes
20 employee string
Refrence Document Type:
Employee, Field: name
21 employee_name string
22 designation string
Refrence Document Type:
Designation, Field: name
23 net_pay decimal
24 has_leaves string Options: Yes, No
25 days int
26 leaves_expenses_account string
Refrence Document Type:
Account, Field: name
27 accrued_leaves_accounts_group string
Refrence Document Type:
Account, Field: name
28 has_tickets string Options: Yes, No
29 quantity int
30 value int
31 tickets_expenses_account string
Refrence Document Type:
Account, Field: name
32 accrued_tickets_accounts_group string
Refrence Document Type:
Account, Field: name
33 has_end_of_service string Options: Yes, No
34 end_of_service_days int
35 end_of_service_expenses_account string
Refrence Document Type:
Account, Field: name
36 accrued_end_of_service_accounts_group string
Refrence Document Type:
Account, Field: name
37 cost_center string
Refrence Document Type:
Cost Center, Field: name
40 salary_structure_deduction Array Array of: Salary Structure Deduction
41 salary_structure_earning Array Array of: Salary Structure Earning

Salary Structure Deduction

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Salary Structure field: name
8 parentfield string
9 parenttype string Options: Salary Structure
10 idx int
11 depend_on_lwp int
12 d_modified_amt decimal
13 d_type string
Refrence Document Type:
Deduction Type, Field: name
14 reduce_deduction_in_attendance_calculation int
15 accrued_salary_accounts_group string
Refrence Document Type:
Account, Field: name
16 expenses_account string
Refrence Document Type:
Account, Field: name

Salary Structure Earning

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Salary Structure field: name
8 parentfield string
9 parenttype string Options: Salary Structure
10 idx int
11 depend_on_lwp int
12 modified_value decimal
13 e_type string
Refrence Document Type:
Earning Type, Field: name
14 reduce_earning_in_attendance_calculation int
15 accrued_salary_accounts_group string
Refrence Document Type:
Account, Field: name
16 expenses_account string
Refrence Document Type:
Account, Field: name
17 include_in_accrued_vacation int
18 include_in_accrued_end_of_service int

Sales BOM

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 new_item_code string
Refrence Document Type:
Item, Field: name
13 sales_bom_item Array Array of: Sales BOM Item

Sales BOM Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Sales BOM field: name
8 parentfield string
9 parenttype string Options: Sales BOM
10 idx int
11 rate decimal
12 uom string
Refrence Document Type:
UOM, Field: name
13 description text
14 item_code string
Refrence Document Type:
Item, Field: name
15 qty decimal

Sales Invoice

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 rounded_total_export decimal
12 cash_bank_account string
Refrence Document Type:
Account, Field: name
13 convert_into_recurring_invoice int
14 selling_price_list string
Refrence Document Type:
Price List, Field: name
15 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
16 source string Options: Existing Customer, Reference, Advertisement, Cold Calling, Exhibition, Supplier Reference, Mass Mailing, Customer's Vendor, Campaign
17 charge string
Refrence Document Type:
Sales Taxes and Charges Master, Field: name
18 notification_email_address text
19 address_display text
20 due_date date
21 write_off_cost_center string
Refrence Document Type:
Cost Center, Field: name
22 invoice_period_to_date date
23 write_off_outstanding_amount_automatically int
24 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
25 is_pos int
26 net_total_export decimal
27 write_off_amount decimal
28 mode_of_payment string
Refrence Document Type:
Mode of Payment, Field: name
29 price_list_currency string
Refrence Document Type:
Currency, Field: name
30 contact_display text
31 next_date date
32 terms text
33 other_charges_total_export decimal
34 aging_date date
35 customer_address string
Refrence Document Type:
Address, Field: name
36 total_commission decimal
37 contact_mobile text
38 c_form_applicable string Options: No, Yes
39 customer_group string
Refrence Document Type:
Customer Group, Field: name
40 gross_profit decimal
41 repeat_on_day_of_month int
42 contact_person string
Refrence Document Type:
Contact, Field: name
43 in_words string
44 campaign string
Refrence Document Type:
Campaign, Field: name
45 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
46 conversion_rate decimal Default: 1.000000
Default: 1.000000
47 against_income_account text
48 total_advance decimal
49 posting_time time
50 customer_name string
51 commission_rate decimal
52 update_stock int
53 gross_profit_percent decimal
54 sales_partner string
Refrence Document Type:
Sales Partner, Field: name
55 project_name string
Refrence Document Type:
Project, Field: name
56 end_date date
57 company string
Refrence Document Type:
Company, Field: name
58 contact_email text
59 customer string
Refrence Document Type:
Customer, Field: name
60 grand_total decimal
61 territory string
Refrence Document Type:
Territory, Field: name
62 is_opening string Default: No Options: No, Yes
Default: No
63 posting_date date
64 debit_to string
Refrence Document Type:
Account, Field: name
65 naming_series string Options: INV, INV/10-11/
66 other_charges_total decimal
67 currency string
Refrence Document Type:
Currency, Field: name
68 letter_head string
Refrence Document Type:
Letter Head, Field: name
69 recurring_id string
70 shipping_rule string
Refrence Document Type:
Shipping Rule, Field: name
71 paid_amount decimal
72 amended_from string
Refrence Document Type:
Sales Invoice, Field: name
73 recurring_type string Options: Monthly, Quarterly, Half-yearly, Yearly
74 rounded_total decimal
75 grand_total_export decimal
76 write_off_account string
Refrence Document Type:
Account, Field: name
77 outstanding_amount decimal
78 in_words_export string
79 remarks text
80 invoice_period_from_date date
81 c_form_no string
Refrence Document Type:
C-Form, Field: name
82 plc_conversion_rate decimal
83 net_total decimal
84 additional_discount_amount decimal Default: 0.000000
Default: 0.000000
85 additional_discount_percentage decimal Default: 0.000000
Default: 0.000000
86 apply_additional_discount_on string Default: Net Total Options: Net Total
Default: Net Total
87 open_cart_id string
88 pos_reference string
95 delivery_note_packing_item Array Array of: Delivery Note Packing Item
96 sales_invoice_advance Array Array of: Sales Invoice Advance
97 sales_invoice_item Array Array of: Sales Invoice Item
98 sales_taxes_and_charges Array Array of: Sales Taxes and Charges
99 sales_team Array Array of: Sales Team

Sales Invoice Advance

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Sales Invoice field: name
8 parentfield string
9 parenttype string Options: Sales Invoice
10 idx int
11 remarks text
12 allocated_amount decimal
13 journal_voucher string
Refrence Document Type:
Journal Voucher, Field: name
14 jv_detail_no string
15 advance_amount decimal
16 receipt_voucher string
Refrence Document Type:
Receipt Voucher, Field: name
17 rv_detail_no string

Sales Invoice Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Sales Invoice field: name
8 parentfield string
9 parenttype string Options: Sales Invoice
10 idx int
11 serial_no text
12 qty decimal
13 item_tax_rate text
14 delivery_note string
Refrence Document Type:
Delivery Note, Field: name
15 dn_detail string
16 cost_center string
Refrence Document Type:
Cost Center, Field: name
17 so_detail string
18 adj_rate decimal
19 actual_qty decimal
20 page_break int
21 income_account string
Refrence Document Type:
Account, Field: name
22 item_name string
23 stock_uom string
Refrence Document Type:
UOM, Field: name
24 warehouse string
Refrence Document Type:
Warehouse, Field: name
25 basic_rate decimal
26 ref_rate decimal
27 description text
28 brand string
29 barcode string
30 item_code string
Refrence Document Type:
Item, Field: name
31 buying_amount decimal
32 time_log_batch string
Refrence Document Type:
Time Log Batch, Field: name
33 expense_account string
Refrence Document Type:
Account, Field: name
34 delivered_qty decimal
35 export_rate decimal
36 sales_order string
Refrence Document Type:
Sales Order, Field: name
37 item_group string
Refrence Document Type:
Item Group, Field: name
38 export_amount decimal
39 amount decimal
40 customer_item_code string
41 batch_no string
Refrence Document Type:
Batch, Field: name
42 base_ref_rate decimal
43 net_amount_export decimal
44 net_amount decimal
45 open_cart_id string

Sales Order

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 rounded_total_export decimal
12 net_total_export decimal
13 total_commission decimal
14 campaign string
Refrence Document Type:
Campaign, Field: name
15 naming_series string Options: PI/2011/, SO, SO/10-11/, SO1112
16 currency string
Refrence Document Type:
Currency, Field: name
17 conversion_rate decimal Default: 1.000000
Default: 1.000000
18 other_charges_total decimal
19 billing_status string Options: Billed, Not Billed, Partly Billed, Closed
20 other_charges_total_export decimal
21 terms text
22 commission_rate decimal
23 shipping_rule string
Refrence Document Type:
Shipping Rule, Field: name
24 customer_name string
25 po_date date
26 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
27 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
28 order_type string Default: Sales Options: Sales, Maintenance
Default: Sales
29 price_list_currency string
Refrence Document Type:
Currency, Field: name
30 selling_price_list string
Refrence Document Type:
Price List, Field: name
31 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
32 amended_from string
33 charge string
Refrence Document Type:
Sales Taxes and Charges Master, Field: name
34 transaction_date date
35 contact_display text
36 sales_partner string
Refrence Document Type:
Sales Partner, Field: name
37 rounded_total decimal
38 grand_total_export decimal
39 address_display text
40 project_name string
Refrence Document Type:
Project, Field: name
41 company string
Refrence Document Type:
Company, Field: name
42 per_billed decimal
43 in_words_export string
44 customer_address string
Refrence Document Type:
Address, Field: name
45 contact_email text
46 contact_mobile text
47 delivery_status string Options: Delivered, Not Delivered, Partly Delivered, Closed, Not Applicable
48 customer string
Refrence Document Type:
Customer, Field: name
49 grand_total decimal
50 in_words string
51 shipping_address_name string
Refrence Document Type:
Address, Field: name
52 territory string
Refrence Document Type:
Territory, Field: name
53 letter_head string
Refrence Document Type:
Letter Head, Field: name
54 per_delivered decimal
55 plc_conversion_rate decimal
56 po_no string
57 net_total decimal
58 status string Default: Draft Options: Draft, Submitted, Stopped, Cancelled
Default: Draft
59 source string Options: Existing Customer, Reference, Advertisement, Cold Calling, Exhibition, Supplier Reference, Mass Mailing, Customer's Vendor, Campaign
60 shipping_address text
61 contact_person string
Refrence Document Type:
Contact, Field: name
62 customer_group string
Refrence Document Type:
Customer Group, Field: name
63 delivery_date date
64 apply_additional_discount_on string Default: Net Total Options: Net Total
Default: Net Total
65 additional_discount_amount decimal Default: 0.000000
Default: 0.000000
66 additional_discount_percentage decimal Default: 0.000000
Default: 0.000000
67 _user_tags string
75 delivery_note_packing_item Array Array of: Delivery Note Packing Item
76 sales_order_item Array Array of: Sales Order Item
77 sales_taxes_and_charges Array Array of: Sales Taxes and Charges
78 sales_team Array Array of: Sales Team

Sales Order Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Sales Order field: name
8 parentfield string
9 parenttype string Options: Sales Order
10 idx int
11 produced_qty decimal
12 qty decimal
13 item_tax_rate text
14 adj_rate decimal
15 actual_qty decimal
16 page_break int
17 item_name string
18 transaction_date date
19 stock_uom string
Refrence Document Type:
UOM, Field: name
20 billed_amt decimal
21 basic_rate decimal
22 reserved_warehouse string
Refrence Document Type:
Warehouse, Field: name
23 ref_rate decimal
24 description text
25 prevdoc_docname string
Refrence Document Type:
Quotation, Field: name
26 brand string
Refrence Document Type:
Brand, Field: name
27 item_code string
Refrence Document Type:
Item, Field: name
28 projected_qty decimal
29 delivered_qty decimal
30 export_rate decimal
31 item_group string
Refrence Document Type:
Item Group, Field: name
32 planned_qty decimal
33 export_amount decimal
34 amount decimal
35 customer_item_code string
36 base_ref_rate decimal
37 net_amount_export decimal
38 net_amount decimal

Sales Partner

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 partner_website string
12 logo string Options: attach_files:
13 commission_rate decimal
14 partner_name string
15 distribution_id string
Refrence Document Type:
Budget Distribution, Field: name
16 page_name string
17 territory string
Refrence Document Type:
Territory, Field: name
18 description text
19 partner_type string Options: Channel Partner, Distributor, Dealer, Agent, Retailer, Implementation Partner, Reseller
20 show_in_website int
21 introduction text
23 target_detail Array Array of: Target Detail

Sales Person

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 parent_sales_person string
Refrence Document Type:
Sales Person, Field: name
12 distribution_id string
Refrence Document Type:
Budget Distribution, Field: name
13 sales_person_name string
14 is_group string Options: Yes, No
15 old_parent string
16 lft int
17 employee string
Refrence Document Type:
Employee, Field: name
18 rgt int
20 target_detail Array Array of: Target Detail

Sales Taxes and Charges

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Sales Taxes and Charges Master field: name
Refrence Document Type: Quotation field: name
Refrence Document Type: Sales Order field: name
Refrence Document Type: Delivery Note field: name
Refrence Document Type: Sales Invoice field: name
Refrence Document Type: Return Note field: name
8 parentfield string
9 parenttype string Options: Sales Taxes and Charges Master, Quotation, Sales Order, Delivery Note, Sales Invoice, Return Note,
10 idx int
11 charge_type string Options: Actual, On Net Total, On Previous Row Amount, On Previous Row Total
12 tax_amount decimal
13 description text
14 item_wise_tax_detail text
15 row_id string
16 included_in_print_rate int
17 rate decimal
18 account_head string
Refrence Document Type:
Account, Field: name
19 total decimal
20 cost_center string
Refrence Document Type:
Cost Center, Field: name

Sales Taxes and Charges Master

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 title string
12 is_default int
13 company string
Refrence Document Type:
Company, Field: name
15 for_territory Array Array of: For Territory
16 sales_taxes_and_charges Array Array of: Sales Taxes and Charges

Sales Team

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Customer field: name
Refrence Document Type: Sales Order field: name
Refrence Document Type: Delivery Note field: name
Refrence Document Type: Sales Invoice field: name
Refrence Document Type: Return Note field: name
8 parentfield string
9 parenttype string Options: Customer, Sales Order, Delivery Note, Sales Invoice, Return Note,
10 idx int
11 allocated_percentage decimal
12 incentives decimal
13 sales_designation string
14 contact_no string
15 allocated_amount decimal
16 sales_person string
Refrence Document Type:
Sales Person, Field: name

Serial No

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 purchase_time time
12 delivery_document_type string Options: Delivery Note, Sales Invoice, Stock Entry
13 serial_no string
14 purchase_document_no string
15 customer_name string
16 amc_expiry_date date
17 purchase_rate decimal
18 item_name string
19 company string
Refrence Document Type:
Company, Field: name
20 purchase_document_type string Options: Purchase Receipt, Stock Entry
21 purchase_date date
22 supplier string
Refrence Document Type:
Supplier, Field: name
23 status string Default: In Store Options: Available, Not Available, Delivered, Purchase Returned, Sales Returned
Default: In Store
24 description text
25 brand string
Refrence Document Type:
Brand, Field: name
26 item_code string
Refrence Document Type:
Item, Field: name
27 warehouse string
Refrence Document Type:
Warehouse, Field: name
28 supplier_name string
29 is_cancelled string Options: Yes, No
30 maintenance_status string Options: Under Warranty, Out of Warranty, Under AMC, Out of AMC
31 customer string
Refrence Document Type:
Customer, Field: name
32 delivery_time time
33 delivery_document_no string
34 item_group string
Refrence Document Type:
Item Group, Field: name
35 warranty_period int
36 serial_no_details text
37 warranty_expiry_date date
38 delivery_date date

Shipping Rule

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 calculate_based_on string Default: Net Total Options: Net Total, Net Weight
Default: Net Total
12 company string
Refrence Document Type:
Company, Field: name
13 account string
Refrence Document Type:
Account, Field: name
14 label string
15 cost_center string
Refrence Document Type:
Cost Center, Field: name
18 for_territory Array Array of: For Territory
19 shipping_rule_condition Array Array of: Shipping Rule Condition

Shipping Rule Condition

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Shipping Rule field: name
8 parentfield string
9 parenttype string Options: Shipping Rule
10 idx int
11 to_value decimal
12 from_value decimal
13 shipping_amount decimal

Shopping Cart Price List

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Shopping Cart Settings field: name
8 parentfield string
9 parenttype string Options: Shopping Cart Settings
10 idx int
11 selling_price_list string
Refrence Document Type:
Price List, Field: name

Shopping Cart Shipping Rule

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Shopping Cart Settings field: name
8 parentfield string
9 parenttype string Options: Shopping Cart Settings
10 idx int
11 shipping_rule string
Refrence Document Type:
Shipping Rule, Field: name

Shopping Cart Taxes and Charges Master

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Shopping Cart Settings field: name
8 parentfield string
9 parenttype string Options: Shopping Cart Settings
10 idx int
11 sales_taxes_and_charges_master string
Refrence Document Type:
Sales Taxes and Charges Master, Field: name

Stationary Tool

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Office Supply Request field: name
8 parentfield string
9 parenttype string Options: Office Supply Request
10 idx int
11 quantity int Default: 1
Default: 1
12 stationary_tool_item string

Stock Entry

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 use_multi_level_bom int Default: 1
Default: 1
12 delivery_note_no string
Refrence Document Type:
Delivery Note, Field: name
13 supplier_address text
14 naming_series string Options: STE
15 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
16 fg_completed_qty decimal
17 purchase_receipt_no string
Refrence Document Type:
Purchase Receipt, Field: name
18 posting_time time
19 customer_name string
20 from_warehouse string
Refrence Document Type:
Warehouse, Field: name
21 amended_from string
Refrence Document Type:
Stock Entry, Field: name
22 to_warehouse string
Refrence Document Type:
Warehouse, Field: name
23 supplier string
Refrence Document Type:
Supplier, Field: name
24 company string
Refrence Document Type:
Company, Field: name
25 project_name string
Refrence Document Type:
Project, Field: name
26 sales_invoice_no string
Refrence Document Type:
Sales Invoice, Field: name
27 expense_adjustment_account string
Refrence Document Type:
Account, Field: name
28 customer_address text
29 purpose string Default: Material Issue Options: Material Issue, Material Receipt, Material Transfer, Manufacture/Repack, Subcontract, Sales Return, Purchase Return
Default: Material Issue
30 supplier_name string
31 remarks text
32 customer string
Refrence Document Type:
Customer, Field: name
33 bom_no string
Refrence Document Type:
BOM, Field: name
34 total_amount decimal
35 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
36 posting_date date
37 production_order string
Refrence Document Type:
Production Order, Field: name
41 stock_entry_detail Array Array of: Stock Entry Detail

Stock Entry Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Stock Entry field: name
8 parentfield string
9 parenttype string Options: Stock Entry
10 idx int
11 material_request_item string
Refrence Document Type:
Material Request Item, Field: name
12 stock_uom string
Refrence Document Type:
UOM, Field: name
13 t_warehouse string
Refrence Document Type:
Warehouse, Field: name
14 transfer_qty decimal
15 description text
16 serial_no text
17 incoming_rate decimal
18 bom_no string
Refrence Document Type:
BOM, Field: name
19 item_code string
Refrence Document Type:
Item, Field: name
20 qty decimal
21 s_warehouse string
Refrence Document Type:
Warehouse, Field: name
22 amount decimal
23 conversion_factor decimal
24 material_request string
Refrence Document Type:
Material Request, Field: name
25 batch_no string
Refrence Document Type:
Batch, Field: name
26 actual_qty decimal
27 uom string
Refrence Document Type:
UOM, Field: name

Stock Ledger Entry

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 actual_qty decimal
12 stock_value decimal
13 fiscal_year string
14 is_cancelled string Options: Yes, No
15 company string
Refrence Document Type:
Company, Field: name
16 serial_no text
17 incoming_rate decimal
18 voucher_type string
19 item_code string
Refrence Document Type:
Item, Field: name
20 voucher_detail_no string
21 project string
Refrence Document Type:
Project, Field: name
22 valuation_rate decimal
23 stock_uom string
Refrence Document Type:
UOM, Field: name
24 stock_queue text
25 batch_no string
26 warehouse string
Refrence Document Type:
Warehouse, Field: name
27 posting_date date
28 posting_time time
29 qty_after_transaction decimal
30 voucher_no string

Stock Reconciliation

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 company string
Refrence Document Type:
Company, Field: name
12 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
13 expense_account string
Refrence Document Type:
Account, Field: name
14 amended_from string
Refrence Document Type:
Stock Reconciliation, Field: name
15 reconciliation_json longtext
16 stock_value_difference decimal
17 posting_date date
18 posting_time time

Supplier

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 default_currency string
Refrence Document Type:
Currency, Field: name
12 website string
13 credit_days int
14 naming_series string Options: SUPP, SUPP/10-11/
15 company string
Refrence Document Type:
Company, Field: name
16 supplier_details text
17 supplier_name string
18 supplier_type string
Refrence Document Type:
Supplier Type, Field: name
19 _user_tags string
20 tax_number string

Supplier Quotation

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 supplier_address string
Refrence Document Type:
Address, Field: name
12 naming_series string Options: SQTN
13 in_words_import string
14 supplier_name string
15 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
16 currency string
Refrence Document Type:
Currency, Field: name
17 conversion_rate decimal
18 select_print_heading string
Refrence Document Type:
Print Heading, Field: name
19 is_subcontracted string Default: No Options: Yes, No
Default: No
20 price_list_currency string
Refrence Document Type:
Currency, Field: name
21 tc_name string
Refrence Document Type:
Terms and Conditions, Field: name
22 amended_from string
23 transaction_date date
24 contact_display text
25 other_charges_added_import decimal
26 supplier string
Refrence Document Type:
Supplier, Field: name
27 grand_total_import decimal
28 buying_price_list string
Refrence Document Type:
Price List, Field: name
29 address_display text
30 total_tax decimal
31 terms text
32 company string
Refrence Document Type:
Company, Field: name
33 rounded_total decimal
34 grand_total decimal
35 other_charges_added decimal
36 contact_email text
37 purchase_other_charges string
Refrence Document Type:
Purchase Taxes and Charges Master, Field: name
38 contact_mobile text
39 net_total_import decimal
40 other_charges_deducted_import decimal
41 other_charges_deducted decimal
42 letter_head string
Refrence Document Type:
Letter Head, Field: name
43 plc_conversion_rate decimal
44 net_total decimal
45 status string Options: Draft, Submitted, Stopped, Cancelled
46 contact_person string
Refrence Document Type:
Contact, Field: name
47 in_words string
48 supplier_qtn_no string
51 purchase_taxes_and_charges Array Array of: Purchase Taxes and Charges
52 supplier_quotation_item Array Array of: Supplier Quotation Item

Supplier Quotation Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Supplier Quotation field: name
8 parentfield string
9 parenttype string Options: Supplier Quotation
10 idx int
11 qty decimal
12 item_tax_rate text
13 import_amount decimal
14 discount_rate decimal
15 import_ref_rate decimal
16 page_break int
17 purchase_rate decimal
18 item_name string
19 prevdoc_detail_docname string
20 warehouse string
Refrence Document Type:
Warehouse, Field: name
21 supplier_part_no string
22 uom string
Refrence Document Type:
UOM, Field: name
23 project_name string
Refrence Document Type:
Project, Field: name
24 description text
25 prevdoc_docname string
Refrence Document Type:
Material Request, Field: name
26 import_rate decimal
27 brand string
Refrence Document Type:
Brand, Field: name
28 item_code string
Refrence Document Type:
Item, Field: name
29 purchase_ref_rate decimal
30 prevdoc_date date
31 item_group string
Refrence Document Type:
Item Group, Field: name
32 amount decimal
33 prevdoc_doctype string

Supplier Type

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 supplier_type string
12 trash_reason text

Support Ticket

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 naming_series string Options: SUP
12 opening_date date
13 customer_name string
14 raised_by string
15 first_responded_on datetime
16 lead string
Refrence Document Type:
Lead, Field: name
17 opening_time time
18 subject string
19 status string Default: Open Options: Open, To Reply, Waiting for Customer, Hold, Closed
Default: Open
20 description text
21 company string
Refrence Document Type:
Company, Field: name
22 content_type string
23 resolution_details text
24 resolution_date datetime
25 customer string
Refrence Document Type:
Customer, Field: name
26 contact string
Refrence Document Type:
Contact, Field: name

Target Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Sales Partner field: name
Refrence Document Type: Sales Person field: name
Refrence Document Type: Territory field: name
8 parentfield string
9 parenttype string Options: Sales Partner, Sales Person, Territory,
10 idx int
11 item_group string
Refrence Document Type:
Item Group, Field: name
12 target_qty decimal
13 fiscal_year string
Refrence Document Type:
Fiscal Year, Field: name
14 target_amount decimal

Task

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Options: Open, Working, Pending Review, Closed, Cancelled
12 exp_end_date date
13 review_date date
14 subject string
15 allocated_budget decimal
16 exp_total_hrs string
17 priority string Options: Low, Medium, High, Urgent
18 description text
19 act_end_date date
20 company string
Refrence Document Type:
Company, Field: name
21 act_start_date date
22 actual_budget decimal
23 closing_date date
24 project string
Refrence Document Type:
Project, Field: name
25 exp_start_date date

Terms and Conditions

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 terms text
12 trash_reason text
13 title string

Territory

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 rgt int
12 trash_reason text
13 distribution_id string
Refrence Document Type:
Budget Distribution, Field: name
14 is_group string Options: Yes, No
15 territory_name string
16 old_parent string
Refrence Document Type:
Territory, Field: name
17 lft int
18 parent_territory string
Refrence Document Type:
Territory, Field: name
19 territory_manager string
Refrence Document Type:
Sales Person, Field: name
21 target_detail Array Array of: Target Detail

Time Log

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Options: Draft, Submitted, Batched for Billing, Billed, Cancelled
12 task string
Refrence Document Type:
Task, Field: name
13 project string
Refrence Document Type:
Project, Field: name
14 naming_series string Options: TL-
15 time_log_batch string
Refrence Document Type:
Time Log Batch, Field: name
16 sales_invoice string
Refrence Document Type:
Sales Invoice, Field: name
17 hours decimal
18 amended_from string
Refrence Document Type:
Time Log, Field: name
19 note text
20 to_time datetime
21 billable int
22 from_time datetime
23 activity_type string
Refrence Document Type:
Activity Type, Field: name

Time Log Batch

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 status string Default: Draft Options: Draft, Submitted, Billed, Cancelled
Default: Draft
12 amended_from string
Refrence Document Type:
Time Log Batch, Field: name
13 naming_series string Options: TLB-
14 sales_invoice string
Refrence Document Type:
Sales Invoice, Field: name
15 total_hours decimal
16 rate decimal
19 time_log_batch_detail Array Array of: Time Log Batch Detail

Time Log Batch Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Time Log Batch field: name
8 parentfield string
9 parenttype string Options: Time Log Batch
10 idx int
11 time_log string
Refrence Document Type:
Time Log, Field: name
12 hours decimal
13 created_by string
Refrence Document Type:
Profile, Field: name
14 activity_type string

ToDo

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 checked int
12 description text
13 assigned_by string
Refrence Document Type:
Profile, Field: name
14 reference_name string
15 reference_type string
16 priority string
17 role string
Refrence Document Type:
Role, Field: name
18 date date

Top Bar Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Website Settings field: name
Refrence Document Type: Website Settings field: name
8 parentfield string
9 parenttype string Options: Website Settings, Website Settings,
10 idx int
11 url string
12 parent_label string Options: NULL
13 target string Options: target = "_blank"
14 label string

Training Request

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 city string
12 course_title string
13 end_date date
14 country string Default: Saudi Arabia
Refrence Document Type:
Country, Field: name
Default: Saudi Arabia
15 fees decimal Default: 0.000000
Default: 0.000000
16 amended_from string
Refrence Document Type:
Training Request, Field: name
17 department string
18 location string Options: Throughout KSA, Abroad
19 employee_name string
20 employee string
Refrence Document Type:
Employee, Field: name
21 name_of_the_institution string
22 start_date date
23 purpose_of_the_course text
24 workflow_state string

Training Request Workflow History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 update_field string Options: NULL
12 state string
Refrence Document Type:
Workflow State, Field: name
13 update_value string
14 reason string
15 user string
Refrence Document Type:
Profile, Field: name
16 doc_status int

Travel Ticket Request

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 amount_of_compensation int
12 purpose_of_request string Options: Mandate, Annual Vacation, Other
13 amended_from string
Refrence Document Type:
Travel Ticket Request, Field: name
14 required string Options: Ticket Issue, Ticket Compensation
15 other_reason text
16 department string
17 flight_route string
18 status_of_reservation string Options: O.K, Waiting
19 employee_name string
20 employee string
Refrence Document Type:
Employee, Field: name
21 reservation_number string
22 class string Options: First class, Business class, Economy class
23 date_of_dep date
24 workflow_state string
26 travel_ticket_request_dependent Array Array of: Travel Ticket Request Dependent

Travel Ticket Request Dependent

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Travel Ticket Request field: name
8 parentfield string
9 parenttype string Options: Travel Ticket Request
10 idx int
11 date_of_birth date
12 dependent_name string
13 kind_of_relative string

Travel Ticket Request Workflow History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 update_field string Options: NULL
12 state string
Refrence Document Type:
Workflow State, Field: name
13 update_value string
14 reason string
15 user string
Refrence Document Type:
Profile, Field: name
16 doc_status int

UOM

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 must_be_whole_number int
12 trash_reason text
13 uom_name string

UOM Conversion Detail

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Item field: name
8 parentfield string
9 parenttype string Options: Item
10 idx int
11 conversion_factor decimal
12 uom string
Refrence Document Type:
UOM, Field: name

UserRole

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Profile field: name
8 parentfield string
9 parenttype string Options: Profile
10 idx int
11 role string
Refrence Document Type:
Role, Field: name

Visit Visa Request

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 employer_business_activity string
12 full_name_of_visitor string
13 visiting_from string
Refrence Document Type:
Country, Field: name
14 duration_of_stay int Default: 1
Default: 1
15 number_of_entries int Default: 1
Default: 1
16 amended_from string
Refrence Document Type:
Visit Visa Request, Field: name
17 department string
18 employee_name string
19 employee string
Refrence Document Type:
Employee, Field: name
20 nationality string
Refrence Document Type:
Country, Field: name
21 purpose_of_visit text
22 name_of_employer string
23 occupation string
24 workflow_state string

Visit Visa Request Workflow History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 update_field string Options: NULL
12 state string
Refrence Document Type:
Workflow State, Field: name
13 update_value string
14 reason string
15 user string
Refrence Document Type:
Profile, Field: name
16 doc_status int

Warehouse

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 merge_with string
Refrence Document Type:
Warehouse, Field: name
12 pin int
13 city string
14 email_id string
15 address_line_1 string
16 company string
Refrence Document Type:
Company, Field: name
17 phone_no string
18 state string
19 mobile_no string
20 warehouse_name string
21 address_line_2 string
22 is_create_account_under int Default: 0
Default: 0
23 create_account_under string
Refrence Document Type:
Account, Field: name
26 warehouse_user Array Array of: Warehouse User

Warehouse User

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Warehouse field: name
8 parentfield string
9 parenttype string Options: Warehouse
10 idx int
11 user string
Refrence Document Type:
Profile, Field: name

Web Page

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 description text
12 title string
13 insert_style int
14 insert_code int
15 javascript text
16 slideshow string
Refrence Document Type:
Website Slideshow, Field: name
17 text_align string Options: Left, Center, Right
18 page_name string
19 published int
20 css text
21 main_section text

Website Item Group

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Item field: name
8 parentfield string
9 parenttype string Options: Item
10 idx int
11 item_group string
Refrence Document Type:
Item Group, Field: name

Website Slideshow

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 slideshow_name string
12 header text
14 website_slideshow_item Array Array of: Website Slideshow Item

Website Slideshow Item

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: Website Slideshow field: name
8 parentfield string
9 parenttype string Options: Website Slideshow
10 idx int
11 image string Options: attach_files:
12 heading string
13 description text

Within-Day Leave Request

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 to_datetime datetime
12 amended_from string
Refrence Document Type:
Within-Day Leave Request, Field: name
13 reason text
14 department string
15 from_datetime datetime
16 employee_name string
17 employee string
Refrence Document Type:
Employee, Field: name
18 type string Default: During working hours Options: During working hours, Coming Late
Default: During working hours
19 workflow_state string

Within-Day Leave Request Workflow History

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 update_field string Options: NULL
12 state string
Refrence Document Type:
Workflow State, Field: name
13 update_value string
14 reason string
15 user string
Refrence Document Type:
Profile, Field: name
16 doc_status int

Work Schedule

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string Refrence Document Type: HR Settings field: name
8 parentfield string
9 parenttype string Options: HR Settings
10 idx int
11 working_days string Options: 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31
12 company string
Refrence Document Type:
Company, Field: name
13 include_holidays_in_total_working_days int
14 working_hours string Options: 7, 8, 9, 10
15 schedule_type string Options: Actual, Fixed

Workstation

Fields
Key Name Data type Mandatory Remarks
1 name string
2 creation datetime
3 modified datetime
4 modified_by string
5 owner string
6 docstatus int Default: 0
Default: 0
7 parent string
8 parentfield string
9 parenttype string
10 idx int
11 hour_rate_rent decimal
12 capacity string
13 description text
14 hour_rate_labour decimal
15 hour_rate decimal
16 overhead decimal
17 capacity_units string Options: Units/Shifts, Units/Hour
18 hour_rate_consumable decimal
19 warehouse string
Refrence Document Type:
Warehouse, Field: name
20 hour_rate_electricity decimal
21 workstation_name string
22 trash_reason text