{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_profile_fields.position",
"table": {
"table_name": "cscart_profile_fields",
"access_type": "ALL",
"possible_keys": ["profile_show"],
"rows": 61,
"filtered": 77.04917908,
"attached_condition": "cscart_profile_fields.profile_type = 'S' and cscart_profile_fields.profile_show = 'Y'"
}
}
},
"table": {
"table_name": "cscart_profile_field_descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "12",
"used_key_parts": ["object_id", "object_type", "lang_code"],
"ref": ["ymonline_livedata.cscart_profile_fields.field_id", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_profile_field_descriptions.object_type = 'F' and cscart_profile_field_descriptions.lang_code = 'en')"
}
}
}
field_id | field_name | profile_show | profile_required | checkout_show | checkout_required | partner_show | partner_required | storefront_show | field_type | profile_type | position | is_default | section | matching_id | class | wrapper_class | autocomplete_type | description | required |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36 | company | Y | Y | N | N | N | N | Y | I | S | 10 | Y | C | 0 | company | organization | Company | Y | |
64 | tax_number | Y | Y | N | N | N | N | N | I | S | 14 | Y | C | 0 | tax_number | Tax number | Y | ||
50 | plan_id | Y | N | N | N | N | N | N | V | S | 15 | Y | C | 0 | plan-id | Plan | N | ||
37 | admin_firstname | Y | Y | N | N | N | N | N | I | S | 20 | N | C | 0 | first-name | given-name | First name | Y | |
38 | admin_lastname | Y | Y | N | N | N | N | N | I | S | 30 | N | C | 0 | last-name | surname | Last name | Y | |
39 | Y | Y | N | N | N | N | N | E | S | 40 | Y | C | 0 | Y | |||||
40 | company_description | Y | Y | N | N | N | N | Y | T | S | 50 | Y | C | 0 | company-description | Description | Y | ||
41 | address | Y | Y | N | N | N | N | Y | I | S | 60 | Y | C | 0 | shipping-address | street-address | Address | Y | |
42 | city | Y | Y | N | N | N | N | Y | I | S | 80 | Y | C | 0 | shipping-city | city | City | Y | |
43 | country | Y | Y | N | N | N | N | Y | O | S | 90 | Y | C | 0 | shipping-country | country | Country | Y | |
44 | state | Y | Y | N | N | N | N | Y | A | S | 100 | Y | C | 0 | shipping-state | state | State/Province | Y | |
46 | phone | Y | Y | N | N | N | N | N | I | S | 120 | Y | C | 0 | shipping-phone | phone-full | Phone | Y | |
48 | url | Y | Y | N | N | N | N | N | I | S | 140 | Y | C | 0 | url | url | URL | Y | |
72 | CIPACERTIFICATE | Y | Y | N | N | N | N | N | F | S | 150 | N | C | 0 | ty-company-upload-button-data | Company Certificate | Y | ||
71 | CIPAEXTRACT | Y | Y | N | N | N | N | N | F | S | 160 | N | C | 0 | ty-company-upload-button-data | Company Extract | Y | ||
77 | SHARECERTIFICATES | Y | Y | N | N | N | N | N | F | S | 170 | N | C | 0 | ty-company-upload-button-data | Share Certificates | Y | ||
76 | SHAREHOLDERSID | Y | Y | N | N | N | N | N | F | S | 180 | N | C | 0 | ty-company-upload-button-data | Share Holders ID's | Y | ||
75 | TRADE LICENCE | Y | Y | N | N | N | N | N | F | S | 190 | N | C | 0 | ty-company-upload-button-data | Trading licences | Y | ||
74 | BANKLETTER | Y | Y | N | N | N | N | N | F | S | 200 | N | C | 0 | ty-company-upload-button-data | Bank Confirmation Letter | Y | ||
73 | BURSTC | Y | Y | N | N | N | N | N | F | S | 210 | N | C | 0 | ty-company-upload-button-data | Company Tax Clearance Certificate | Y | ||
49 | accept_terms | Y | Y | N | N | N | N | N | B | S | 300 | Y | C | 0 | cm-agreement checkbox | I accept the Terms and Conditions | Y |