This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
urapidflow:fixed_row_format [2020/06/23 06:17] wtsergo [Multi Source Inventory Types] |
urapidflow:fixed_row_format [2020/09/10 07:20] wtsergo [CPSAP: Catalog Product Super Configurable Attribute Pricing] |
||
---|---|---|---|
Line 582: | Line 582: | ||
^ 4 | label | | | | | ^ 4 | label | | | | | ||
==== CPSAP: Catalog Product Super Configurable Attribute Pricing ==== | ==== CPSAP: Catalog Product Super Configurable Attribute Pricing ==== | ||
+ | Magento 1 only | ||
=== Create/ | === Create/ | ||
^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
Line 822: | Line 823: | ||
< | < | ||
-MSIC, | -MSIC, | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== B2B Data Row Types ===== | ||
+ | |||
+ | ==== Allowed actions ==== | ||
+ | ^ Row Type ^ Create | ||
+ | ^ B2BC | X | X | X | ||
+ | ^ B2BCACE | ||
+ | ^ B2BCC | X | X | X | ||
+ | ^ B2BCCH | ||
+ | ^ B2BCOE | ||
+ | ^ B2BCPM | ||
+ | ^ B2BCR | X | X | X | ||
+ | ^ B2BCPR | ||
+ | ^ B2BCT | X | X | X | ||
+ | ^ B2BCS | X | X | X | ||
+ | ^ B2BCUR | ||
+ | ^ B2BSC | X | X | X | ||
+ | ^ B2BSCPI | ||
+ | ^ B2BRQL | ||
+ | ^ B2BRQLI | ||
+ | |||
+ | ==== B2BC: B2B Company ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | company_status | X | X | | | ||
+ | ^ 3 | email | X | X | | | ||
+ | ^ 4 | street | X | X | | | ||
+ | ^ 5 | city | X | X | | | ||
+ | ^ 6 | country_id | X | X | | | ||
+ | ^ 7 | region | X | X | | | ||
+ | ^ 8 | region_id | X | X | | | ||
+ | ^ 9 | postcode | X | X | | | ||
+ | ^ 10 | telephone | X | X | | | ||
+ | ^ 11 | customer_group | X | X | | | ||
+ | ^ 12 | admin_customer | X | X | | | ||
+ | ^ 13 | admin_customer_website | X | | | | ||
+ | ^ 14 | sales_representative | X | | | | ||
+ | ^ 15 | legal_name | X | | | | ||
+ | ^ 16 | vat_id | X | | | | ||
+ | ^ 17 | reseller_id | X | | | | ||
+ | ^ 17 | comment | X | | | | ||
+ | ^ 17 | reject_reason | X | | | | ||
+ | ^ 17 | rejected_at | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BC, | ||
+ | B2BC, | ||
+ | </ | ||
+ | |||
+ | == Delete company == | ||
+ | < | ||
+ | -B2BC, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCACE: B2B Company Advanced Customer Entity ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | customer | X | X | | | ||
+ | ^ 3 | ace_status | X | X | | | ||
+ | ^ 4 | job_title | X | | | | ||
+ | ^ 5 | telephone | X | | | | ||
+ | ^ 6 | customer_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCACE, | ||
+ | B2BCACE, | ||
+ | </ | ||
+ | |||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCACE, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCC: B2B Company Credit ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | credit_limit | X | | | | ||
+ | ^ 3 | balance | X | | | | ||
+ | ^ 4 | currency_code | X | | | | ||
+ | ^ 5 | exceed_limit | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCC, | ||
+ | B2BCC, | ||
+ | </ | ||
+ | |||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCC, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCCH: B2B Company Credit History ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | datetime | X | X | | | ||
+ | ^ 3 | amount | X | X | | | ||
+ | ^ 4 | balance | X | X | | | ||
+ | ^ 5 | credit_limit | X | X | | | ||
+ | ^ 6 | available_credit | X | X | | | ||
+ | ^ 7 | credit_history_type | X | X | | | ||
+ | ^ 8 | user | X | X | | | ||
+ | ^ 9 | user_type | X | X | | | ||
+ | ^ 10 | currency_credit | X | | | | ||
+ | ^ 11 | currency_operation | X | | | | ||
+ | ^ 12 | rate | X | | | | ||
+ | ^ 13 | rate_credit | X | | | | ||
+ | ^ 14 | purchase_order | X | | | | ||
+ | ^ 15 | comment | X | | | | ||
+ | ^ 16 | user_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCCH, | ||
+ | B2BCCH, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCCH, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCOE: B2B Company Order Entity ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | order_id | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCOE, | ||
+ | B2BCOE, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCOE, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCPM: B2B Company Payment ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | use_config_settings | X | X | | | ||
+ | ^ 3 | applicable_payment_method | X | | | | ||
+ | ^ 4 | available_payment_methods | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCPM, | ||
+ | B2BCPM, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCPM, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCR: B2B Company Roles ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | role_name | X | X | | | ||
+ | ^ 3 | sort_order | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCR, | ||
+ | B2BCR, | ||
+ | B2BCR, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCR, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCPR: B2B Company Permissions ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | role_name | X | X | | | ||
+ | ^ 3 | resource_id | X | X | | | ||
+ | ^ 4 | permission | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCPR, | ||
+ | B2BCPR, | ||
+ | B2BCPR, | ||
+ | B2BCPR, | ||
+ | B2BCPR, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCPR, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCT: B2B Company Team ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | team_name | X | X | | | ||
+ | ^ 3 | description | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCT, | ||
+ | B2BCT, | ||
+ | B2BCT, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCT, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCS: B2B Company Structure ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | entity_type | X | X | | | ||
+ | ^ 3 | entity | X | X | | | ||
+ | ^ 4 | parent_type | X | X | | | ||
+ | ^ 5 | parent_entity | X | X | | | ||
+ | ^ 6 | position | X | | | | ||
+ | ^ 7 | entity_website | X | | | | ||
+ | ^ 8 | parent_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCS, | ||
+ | B2BCS, | ||
+ | B2BCS, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCS, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCUR: B2B Company User Roles ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | role_name | X | X | | | ||
+ | ^ 3 | customer | X | X | | | ||
+ | ^ 4 | customer_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCUR, | ||
+ | B2BCUR, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCS, | ||
+ | </ | ||
+ | |||
+ | ==== B2BSC: B2B Shared Catalog ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | name | X | X | | | ||
+ | ^ 2 | tax_class | X | X | | | ||
+ | ^ 3 | created_by | X | | | | ||
+ | ^ 4 | created_at | X | | | | ||
+ | ^ 5 | description | X | | | | ||
+ | ^ 6 | store | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BSC," | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BSC," | ||
+ | </ | ||
+ | |||
+ | ==== B2BSCPI: B2B Shared Catalog Product Item ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | customer_group | X | X | | | ||
+ | ^ 2 | sku | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BSCPI," | ||
+ | B2BSCPI, | ||
+ | B2BSCPI," | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BSCPI," | ||
+ | </ | ||
+ | |||
+ | ==== B2BRQL: B2B Requisition List ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | name | X | X | | | ||
+ | ^ 2 | customer | X | X | | | ||
+ | ^ 3 | description | X | | | | ||
+ | ^ 4 | updated_at | X | | | | ||
+ | ^ 5 | customer_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BRQL," | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BRQL," | ||
+ | </ | ||
+ | |||
+ | ==== B2BRQLI: B2B Requisition List Item ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | name | X | X | | | ||
+ | ^ 2 | customer | X | X | | | ||
+ | ^ 3 | sku | X | X | | | ||
+ | ^ 4 | qty | X | | | | ||
+ | ^ 5 | added_at | X | | | | ||
+ | ^ 6 | store | X | | | | ||
+ | ^ 7 | options | X | | | | ||
+ | ^ 8 | customer_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BRQLI," | ||
+ | B2BRQLI," | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BRQLI," | ||
</ | </ | ||
Line 862: | Line 1198: | ||
| 4 | active | | | | | | 4 | active | | | | | ||
| 5 | created_at | | | | | | 5 | created_at | | | | | ||
+ | |||