Identified data points needed for SAP push (originally in GSheet)
| Field Label | Data Type | Formula | Solution | ||
|---|---|---|---|---|---|
| 1 | Condition Type | Formula (Text) | Solution TBD - pending on data architecture | Condition Type will be a required picklist field on Solvay Sales Organization object - each Sales Org will have its own Condition Type - data defined by Business Based on Sales Org Region | |
| 2 | Table | Formula (Text) | "847" | ||
| 3 | Sales Org. | Based on Shipping Plant x Ship-To Country x Incoterms | Solution TBD - pending on data architecture Data for determination of Sales Org. sits currently on Utility object, specifically RecType = Sales Area Idea: to use 2 new objects that will allow to create a Master List of Sales Organizations - using a | ||
| 4 | Distr. Channel | Based on Quote market + Number mapping - HPC - IPS - Agro - Amines - Coatings For HPC, create 2 lines for upload: (1) Personal Care & (2) Home Care | Solution TBD | ||
| 5 | Incoterms | Already exists - SLV44_Incoterms__c | |||
| 6 | Customer group | Formula (Text) | "" | ||
| 7 | Customer | Customer SAP Code (Ship-To of the QLI); RCS ID | Solution TBD | ||
| 8 | Name | Account Name (Ship-To of the QLI); RCS ID | Solution TBD | ||
| 9 | Sold-To Party | Formula (Text) | "" | ||
| 10 | Sold-to Name | Formula (Text) | "" | ||
| 11 | Ship-To Party | Formula (Text) | "" | ||
| 12 | Ship-to Name | Formula (Text) | "" | ||
| 13 | Price List | Formula (Text) | "" | ||
| 14 | Doc. Currency | Formula (Text) | "" | ||
| 15 | Price group | Formula (Text) | "" | ||
| 16 | Mat.pricing grp | Formula (Text) | "" | ||
| 17 | Material | Formula (Text) | SLV44_Product_Level_5__r.ProductCode | ||
| 18 | Description | Formula (Text) | SLV44_Product_Level_5__r.Name | ||
| 19 | Division | Formula (Text) | "" | ||
| 20 | Plant | Formula (Text) | SLV44_Shipping_Plant__r.Name | ||
| 21 | Sales Office | Formula (Text) | "" | ||
| 22 | Country | Formula (Text) | "" | ||
| 23 | Sales Unit | Formula (Text) | "" | ||
| 24 | Basic material | Formula (Text) | "" | ||
| 25 | Valid From | Valid From Date (internal) in dd.mm.yyyy | Solution TBD | ||
| 26 | Valid To | Valid To Date (internal) in dd.mm.yyyy | Solution TBD | ||
| 27 | Cond. currency | Quote Currency (Triletter code - USD, EUR, CNY) | Solution TBD | ||
| 28 | Pricing unit | Formula (Number) | 1 | ||
| 29 | Unit of measure | Quote UoM - LB - KG - To - G | Solution TBD | ||
| 30 | Scale UoM | Quote UoM - LB - KG - To - G | Solution TBD | ||
| 31 | Scale quantity | Formula (Number) | 1 | ||
| 32 | Amount | QLI Price | Solution TBD | ||
| 33 | Scale quantity | Text(255) | Default value null - field will be re-used once Order Release Pricing (post-MVP) is built | ||
| 34 | Amount | Text(255) | Default value null - field will be re-used once Order Release Pricing (post-MVP) is built | ||
| 35 | Scale quantity | Text(255) | Default value null - field will be re-used once Order Release Pricing (post-MVP) is built | ||
| 36 | Amount | Text(255) | Default value null - field will be re-used once Order Release Pricing (post-MVP) is built | ||
| 37 | Scale quantity | Text(255) | Default value null - field will be re-used once Order Release Pricing (post-MVP) is built | ||
| 38 | Amount | Text(255) | Default value null - field will be re-used once Order Release Pricing (post-MVP) is built | ||
| 39 | Scale quantity | Text(255) | Default value null - field will be re-used once Order Release Pricing (post-MVP) is built | ||
| 40 | Amount | Text(255) | Default value null - field will be re-used once Order Release Pricing (post-MVP) is built | ||
| 41 | Scale quantity | Formula (Text) | "" | ||
| 42 | Amount | Formula (Text) | "" | ||
| 43 | Scale quantity | Formula (Text) | "" | ||
| 44 | Amount | Formula (Text) | "" | ||
| 45 | Scale quantity | Formula (Text) | "" | ||
| 46 | Amount | Formula (Text) | "" | ||
| 47 | Scale quantity | Formula (Text) | "" | ||
| 48 | Amount | Formula (Text) | "" | ||
| 49 | Scale quantity | Formula (Text) | "" | ||
| 50 | Amount | Formula (Text) | "" | ||
| 51 | Name | Formula (Text) | "" | ||
| 52 | Account group | Formula (Text) | "" | ||
| 53 | City | Formula (Text) | "" | ||
| 54 | Region | Formula (Text) | "" | ||
| 55 | Country | Formula (Text) | "" | ||
| 56 | Deletion flag | Formula (Text) | "" | ||
| 57 | Sales block | Formula (Text) | "" | ||
| 58 | Order block | Formula (Text) | "" | ||
| 59 | Del.ID SlsArea | Formula (Text) | "" | ||
| 60 | Sales block | Formula (Text) | "" | ||
| 61 | Ord.blk:sls ar. | Formula (Text) | "" | ||
| 62 | Price List | Formula (Text) | "" | ||
| 63 | Incoterms | Formula (Text) | "" | ||
| 64 | Customer group | Formula (Text) | "" | ||
| 65 | Price group | Formula (Text) | "" | ||
| 66 | Sales Group | Formula (Text) | "" | ||
| 67 | Description | Formula (Text) | "" | ||
| 68 | Letter ? | Formula (Text) | "" | ||
| 69 | Cust/Sales Area | Formula (Text) | "" | ||
| 70 | X-DChain status | Formula (Text) | "" | ||
| 71 | DF client level | Formula (Text) | "" | ||
| 72 | DChain-spec. | Formula (Text) | "" | ||
| 73 | Deletion Ind. | Formula (Text) | "" | ||
| 74 | DF plant level | Formula (Text) | "" | ||
| 75 | Mat/Plant | Formula (Text) | "" | ||
| 76 | Search term | Formula (Text) | "" | ||
| 77 | Scale type | Formula (Text) | "A" | ||
| 78 | Scale basis | Formula (Text) | "C" | ||
| 79 | Proc. status | Formula (Text) | "" | ||
| 80 | SMART Reference# | Formula (Text) | "" | ||
| 81 | Price justification | Formula (Text) | SLV44_ONE_Quote_Line_Item__c.Name + Quote owner | ||
| 82 | Exp. Ann. Volume | Quote Created Date + Quote Auto-Number Name | Solution TBD | ||
| 83 | Cond.record no. | Formula (Text) | "" | ||
| 84 | Created By | Formula (Text) | "" | ||
| 85 | Created On | Formula (Text) | "" | ||
| 86 | Prop.ship.point | Formula (Text) | "" |