{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Object References","type":"text","marks":[{"type":"em"}]},{"text":" table keeps data which are important for lookups of Promotions, Rebates and Compensations documents.","type":"text"}]},{"type":"paragraph","content":[{"text":"Those documents generally relate to many customers and many products. Often a single document applies to a group/category of customers and products. Such a group is commonly defined by a value of some attribute (e.g. customer region, product business unit, etc.).","type":"text"}]},{"type":"paragraph","content":[{"text":"When you need to look up a document, which includes a specific SKU and a specific customer, you would need to make a very complicated filtering to get the proper list of documents because you would need to consider many scenarios, how the customer group and product group was defined on those documents.","type":"text"}]},{"type":"paragraph","content":[{"text":"To be able to provide you with simple filtering methods, Pricefx needs to store special metadata, called ","type":"text"},{"text":"Object References","type":"text","marks":[{"type":"em"}]},{"text":" to solve the issue.","type":"text"}]},{"type":"paragraph","content":[{"text":"Pricefx Groovy API has special methods, which help you do the filtering, for example:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"customerToRelatedObjectsFilter()","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.pricefx.eu/pricefx-api/groovy/master/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#customerToRelatedObjectsFilter(java.lang.String,java.lang.String)"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"productToRelatedObjectsFilter()","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.pricefx.eu/pricefx-api/groovy/master/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#productToRelatedObjectsFilter(java.lang.String,java.lang.String)"}}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Updating Object Reference Table","type":"text"}]},{"type":"paragraph","content":[{"text":"The metadata about a document are normally updated only when the document data itself are updated – saved, or submitted.","type":"text"}]},{"type":"paragraph","content":[{"text":"When there is a change in customer and product attributes master data (e.g. a new customer is added to a product group), the Object References table needs to be updated, so that the lookups of already submitted and approved Contracts, Rebates Agreements, and Compensation Plans work correctly.","type":"text"}]},{"type":"paragraph","content":[{"text":"The update can be done either from a logic or by the server itself.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Trigger Update from Scheduled Task","type":"text"}]},{"type":"paragraph","content":[{"text":"The update can be triggered from a Calculation Flow task.","type":"text"}]},{"type":"paragraph","content":[{"text":"Example of triggering update of Object References from logic:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"groovy"},"content":[{"text":"actionBuilder\n .addObjRefAction() //❶\n .setFilter(filter)\n .setPartition(partition)\n .setTypeCode('typeCode')","type":"text"}]},{"type":"paragraph","content":[{"text":"❶ See more about the ","type":"text"},{"text":"addObjRefAction()","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.pricefx.eu/pricefx-api/groovy/master/net/pricefx/common/apibuilder/calculationflowaction/CalculationFlowActionBuilder.html#addObjRefAction()"}}]},{"text":" method.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Trigger Update as Daily Housekeeping Job","type":"text"}]},{"type":"paragraph","content":[{"text":"You can set this update to run automatically as a daily job on the server as part of housekeeping jobs.","type":"text"}]},{"type":"paragraph","content":[{"text":"Configuration is done in the server’s ","type":"text"},{"text":"pricefx-config","type":"text","marks":[{"type":"code"}]},{"text":" file.","type":"text"}]},{"type":"paragraph","content":[{"text":"Example of Object Reference table update in the ","type":"text"},{"text":"pricefx-config ","type":"text","marks":[{"type":"em"}]},{"text":"server file:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\n\ttrue\n\tfalse\n\tfalse\n\t50 \n","type":"text"}]},{"type":"paragraph","content":[{"text":"❶ After processing this number of records (i.e. CT, RBA, CO) transaction will be committed.","type":"text"}]}],"version":1}

Browser not supported