The Product suppliers query is used to export product suppliers, showing each supplier for a product per row.
Contents
Filters
Filter |
Description |
Mandatory |
---|---|---|
Fbo location |
Filters on FBO location where the product is available. A single FBO location can be chosen only. |
YES |
Data provider settings
There are no data provider settings for this query.
Columns
Name |
Description |
Example |
---|---|---|
Product data description |
The product’s specific description for the FBO location. If not defined, the standard product description is shown. See 'Specific description for this FBO location’ field in product. |
Hangar Rental Bombardier Hangar 4 |
Product data ID |
Product’s unique ID in GUID format. |
892466ee-7677-44e7-bdf2-de8e610256f0 |
Product data name |
Product code and FBO location in brackets. See ‘Product code' field in product, and 'Short name’ in FBO locations (Administration). |
BOMBARDIER-Hangarage (SPLO) |
Product data supplier ID |
Product supplier’s unique ID in GUID format. |
cf85a535-a506-43c2-946c-6459c641bdfb |
Sub admin code |
The sub administration code used for suppliers. See ‘Sub administration’ field in 'Suppliers’ tab in the product, and 'SubAdminCode’ field in Sub administrations (Administration). |
80025 |
Sub admin description |
The sub administration description used for suppliers. See ‘Sub administration’ field in ‘Suppliers’ tab in the product, and 'Description’ field in Sub administrations (Administration). |
RES Bombardier | EHAM |
Sub admin ID |
Sub admin’s unique ID in GUID format. |
dfbb8f15-4b17-46b4-9483-190f04bd6700 |
Supplier contact display name |
Supplier contact’s display name ‘Name (Contact number)’. See ‘Name’ and 'Contact number' in supplier contact. |
Bombardier Aerospace Nederland B.V. (613061) |
Supplier contact email 1 |
Supplier contact’s Email 1. See ‘Email 1 (Operations)’ in supplier contact. |
orders@fboone.com |
Supplier contact email 2 |
Supplier contact’s Email 2. See ‘Email 2 (Back office)’ in supplier contact. |
accountorders@fboone.com |
Supplier contact ID |
Supplier contact’s unique ID in GUID format. |
86a31c60-7da7-45ca-a0d5-583e584a2b1a |
Supplier contact name |
Supplier contact’s name. See 'Organization name' in supplier contact. |
Bombardier Aerospace Nederland B.V. |
Supplier contact no. |
Supplier contact’s contact number. See 'Contact number' in supplier contact. |
613061 |
Supplier contact phone 1 |
Supplier contact’s Phone 1. See 'Phone 1' in supplier contact. |
020-7544200 |
Supplier contact phone 2 |
Supplier contact’s Phone 2. See 'Phone 2' in supplier contact. |
+31 6 5475 6687 |
Supplier contact short name |
Supplier contact’s short name. See 'Short name' in supplier contact. |
Bombardier NL |
Supplier product code |
Supplier’s product code in product. See 'Supplier product code' field in 'Suppliers’ tab in the product. |
Hangarspace Hangar 4 |
Related pages:
- Product Tree query
- Product data summary query — The Product data summary query is used to export all product data, showing a line per product, per FBO location.
Comments
0 comments
Please sign in to leave a comment.