UnirgyWiki

User Tools

Site Tools

You are here: start » urapidflow » fixed_row_format
Trace:
urapidflow:fixed_row_format

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous 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/07/10 16:31]
wtsergo
Line 822: Line 822:
 <file> <file>
 -MSIC,europe,"Europe Stock" -MSIC,europe,"Europe Stock"
 +</file>
 +
 +
 +===== B2B Data Row Types =====
 +
 +==== Allowed actions ====
 +^ Row Type  ^ Create  ^ Update  ^ Delete  ^ Rename (*)  ^ Description                                                                                                                        ^
 +^ B2BC      | X       | X       | X       |             | [[#b2bcb2b_company|B2B Company]]                                                                 |
 +^ B2BCACE   | X       | X       | X       |             | [[#b2bcaceb2b_company_advanced_customer_entity|B2B Company Advanced Customer Entity]]                  |
 +^ B2BCC     | X       | X       | X       |             | [[#b2bccb2b_company_credit|B2B Company Credit]]                                                                 |
 +^ B2BCCH    | X       | X       | X       |             | [[#b2bcchb2b_company_credit_history|B2B Company Credit History]]                                                                 |
 +^ B2BCOE    | X       | X       | X       |             | [[#b2bcoeb2b_company_order_entity|B2B Company Order Entity]]                                                                 |
 +^ B2BCPM    | X       | X       | X       |             | [[#b2bcpmb2b_company_payment|B2B Company Payment]]                                                                 |
 +^ B2BCR     | X       | X       | X       |             | [[#b2bcrb2b_company_roles|B2B Company Roles]]                                                                 |
 +^ B2BCPR    | X       | X       | X       |             | [[#b2bcprb2b_company_permissions|B2B Company Permissions]]                                                                 |
 +^ B2BCT     | X       | X       | X       |             | [[#b2bctb2b_company_team|B2B Company Team]]                                                                 |
 +^ B2BCS     | X       | X       | X       |             | [[#b2bcsb2b_company_structure|B2B Company Structure]]                                                                 |
 +^ B2BCUR    | X       | X       | X       |             | [[#b2bcurb2b_company_user_roles|B2B Company User Roles]]                                                                 |
 +^ B2BSC     | X       | X       | X       |             | [[#B2BSCB2B_shared_catalog|B2B Shared Catalog]]                                                                 |
 +^ B2BSCPI   | X       | X       | X       |             | [[#b2bscpib2b_shared_catalog_product_item|B2B Shared Catalog Product Item]]                           |
 +^ B2BRQL    | X       | X       | X       |             | [[#b2brqlb2b_requisition_list_item|B2B Requisition List]]                                                                 |
 +^ B2BRQLI   | X       | X       | X       |             | [[#b2brqlib2b_requisition_list_item|B2B Requisition List Item]]                                                                 |
 +
 +==== 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 ===
 +<file>
 +B2BC,company1,Approved,company1@example.com,"Foam Road","Foam Lak",US,,23,60360,3235553232,"Wholesale SC",company1admin@example.com,base,admin,,,,,,
 +B2BC,company2,Approved,company2@example.com,"Grove Crossing",Noseville,US,,61,23860,911,"Wholesale SC",company2admin@example.com,base,admin,,,,,,
 +</file>
 +
 +== Delete company ==
 +<file>
 +-B2BC,company1,Approved,company1@example.com,"Foam Road","Foam Lak",US,,23,60360,3235553232,"Wholesale SC",company1admin@example.com,base,admin,,,,,,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCACE,company1,company1admin@example.com,Active,,,base
 +B2BCACE,company2,company2admin@example.com,Active,CEO,,base
 +</file>
 +
 +== Delete ==
 +<file>
 +-B2BCACE,company2,company2admin@example.com,Active,CEO,,base
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCC,company1,1500.0000,100.0000,USD,0
 +B2BCC,company2,1000.0000,0.0000,USD,1
 +</file>
 +
 +== Delete ==
 +<file>
 +-B2BCC,company2,1000.0000,0.0000,USD,1
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCCH,company1,"2020-06-24 18:43:21",0.0000,0.0000,1000.0000,1000.0000,Allocated,adminuser,Admin,USD,USD,1.000000000000,0.000000000000,,,
 +B2BCCH,company2,"2020-06-30 07:57:59",0.0000,0.0000,1000.0000,1000.0000,Allocated,adminuser,Admin,USD,USD,1.000000000000,0.000000000000,,,
 +</file>
 +== Delete ==
 +<file>
 +-B2BCCH,company2,"2020-06-30 07:57:59",0.0000,0.0000,1000.0000,1000.0000,Allocated,adminuser,Admin,USD,USD,1.000000000000,0.000000000000,,,
 +</file>
 +
 +==== B2BCOE: B2B Company Order Entity ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | company_name | X | X | |
 +^ 2 | order_id | X | X | |
 +
 +=== Examples ===
 +<file>
 +B2BCOE,company1,000000001
 +B2BCOE,company2,000000002
 +</file>
 +== Delete ==
 +<file>
 +-B2BCOE,company2,000000002
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCPM,company1,0,B2B,"amazonlogin,amazon_payment,banktransfer,cashondelivery,checkmo,payflow_advanced,payflowpro,payflow_link,authorizenet_acceptjs,braintree,cybersource,eway,authorizenet_directpost,klarna_kp,free,braintree_paypal,paypal_billing_agreement,payflow_express_bml,paypal_express_bml,paypal_express,payflow_express,hosted_pro,worldpay,companycredit,purchaseorder,braintree_paypal_vault,braintree_cc_vault,payflowpro_cc_vault"
 +B2BCPM,company2,1,B2B,"amazonlogin,amazon_payment,banktransfer,cashondelivery,checkmo,payflow_advanced,payflowpro,payflow_link,authorizenet_acceptjs,braintree,cybersource,eway,authorizenet_directpost,klarna_kp,free,braintree_paypal,paypal_billing_agreement,payflow_express_bml,paypal_express_bml,paypal_express,payflow_express,hosted_pro,worldpay,companycredit,purchaseorder,braintree_paypal_vault,braintree_cc_vault,payflowpro_cc_vault"
 +</file>
 +== Delete ==
 +<file>
 +-B2BCPM,company2,1,B2B,"amazonlogin,amazon_payment,banktransfer,cashondelivery,checkmo,payflow_advanced,payflowpro,payflow_link,authorizenet_acceptjs,braintree,cybersource,eway,authorizenet_directpost,klarna_kp,free,braintree_paypal,paypal_billing_agreement,payflow_express_bml,paypal_express_bml,paypal_express,payflow_express,hosted_pro,worldpay,companycredit,purchaseorder,braintree_paypal_vault,braintree_cc_vault,payflowpro_cc_vault"
 +</file>
 +
 +==== B2BCR: B2B Company Roles ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | company_name | X | X | |
 +^ 2 | role_name | X | X | |
 +^ 3 | sort_order | X |  | |
 +
 +=== Examples ===
 +<file>
 +B2BCR,company1,"Default User",0
 +B2BCR,company1,"Warehouse Role",0
 +B2BCR,company2,"Default User",0
 +</file>
 +== Delete ==
 +<file>
 +-B2BCR,company2,"Default User",0
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCPR,company1,"Default User",Magento_Company::index,allow
 +B2BCPR,company1,"Default User",Magento_Sales::all,allow
 +B2BCPR,company1,"Default User",Magento_Sales::place_order,allow
 +B2BCPR,company1,"Warehouse Role",Magento_Company::roles_view,deny
 +B2BCPR,company1,"Warehouse Role",Magento_Company::roles_edit,deny
 +</file>
 +== Delete ==
 +<file>
 +-B2BCPR,company1,"Warehouse Role",Magento_Company::roles_edit,deny
 +</file>
 +
 +==== B2BCT: B2B Company Team ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | company_name | X | X | |
 +^ 2 | team_name | X | X | |
 +^ 3 | description | X |  | |
 +
 +=== Examples ===
 +<file>
 +B2BCT,company1,Sales,
 +B2BCT,company1,Warehouse,
 +B2BCT,company2,Sales,
 +</file>
 +== Delete ==
 +<file>
 +-B2BCT,company2,Sales,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCS,company1,Customer,company1admin@example.com,,,0,base,
 +B2BCS,company1,Team,Sales,Customer,company1admin@example.com,0,,base
 +B2BCS,company1,Team,Warehouse,Team,Sales,0,,
 +</file>
 +== Delete ==
 +<file>
 +-B2BCS,company1,Team,Warehouse,Team,Sales,0,,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCUR,company1,"Default User",company1user@example.com,1
 +B2BCUR,company2,"Default User",company2user@example.com,1
 +</file>
 +== Delete ==
 +<file>
 +-B2BCS,company1,Team,Warehouse,Team,Sales,0,,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BSC,"Wholesale SC",adminuser,"2020-07-08 06:02:50",,
 +</file>
 +== Delete ==
 +<file>
 +-B2BSC,"Wholesale SC",adminuser,"2020-07-08 06:02:50",,
 +</file>
 +
 +==== B2BSCPI: B2B Shared Catalog Product Item ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | customer_group | X | X | |
 +^ 2 | sku | X | X | |
 +
 +=== Examples ===
 +<file>
 +B2BSCPI,"NOT LOGGED IN",24-MB01
 +B2BSCPI,General,24-MB01
 +B2BSCPI,"Wholesale SC",24-MB01
 +</file>
 +== Delete ==
 +<file>
 +-B2BSCPI,"Wholesale SC",24-MB01
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BRQL,"company1 Req List",company1admin@example.com,,"2020-07-08 06:49:44",1
 +</file>
 +== Delete ==
 +<file>
 +-B2BRQL,"company1 Req List",company1admin@example.com,,"2020-07-08 06:49:44",1
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BRQLI,"company1 Req List",company1admin@example.com,24-MB01,1.0000,,,"{""info_buyRequest"":{""product"":""1"",""uenc"":""aHR0cDovL21hZ2VudG8yMzJiMmIubG9jL2NoZWNrb3V0L2NhcnQvYWRkL3VlbmMvYUhSMGNEb3ZMMjFoWjJWdWRHOHlNekppTW1JdWJHOWpMMmRsWVhJdlltRm5jeTVvZEcxcy9wcm9kdWN0LzEv"",""form_key"":""rspW4yqaVs3ZrNdQ""}}",1
 +B2BRQLI,"company1 Req List",company1admin@example.com,24-MB04,1.0000,,,,
 +</file>
 +== Delete ==
 +<file>
 +-B2BRQLI,"company1 Req List",company1admin@example.com,24-MB04,1.0000,,,,
 </file> </file>
  
Line 862: Line 1197:
 | 4 | active |  |  | | | 4 | active |  |  | |
 | 5 | created_at |  |  | | | 5 | created_at |  |  | |
 +
  
  
  
urapidflow/fixed_row_format.txt · by wtsergo

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
CC Attribution-Noncommercial-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki