Aggregation specific fields - Entitlement Modes - Product related fields - Facility related fields Excel spreadsheet fieldsĬlick any link below to view or save the Excel spreadsheet field-level help file: You can view this Level usage in the sample spreadsheets above. Adding a new row and populating the required Level 1 cells creates a new aggregation event. Create another row and populate the Level 2 cells for the third trade item.To populate the second trade item, create a new row, do NOT populate the Level 1 cells, and populate the Level 2 trade item description, quantity, and quantity UoM cells.The first trade item description, quantity, and quantity UoM (unit of measure) cells (all Level 2) will be populated in the first row. First, populate all required Level 1 cells in the first row. To populate an Aggregation template workbook with one aggregation event, and three trade items, for example: For example, the Aggregation description workbook contains both Level 1 and Level 2 groupings. Anything above Level 1 represents an array. Level 1 represents a new event or transaction. Note: Many of the spreadsheets contain a Level column, which represents groupings. Each table entry contains the collection of documentation files for each IBM Food Trust message type. The Excel spreadsheets below (.xlsx files) provide field-by-field details for each spreadsheet, including detailed field descriptions, required formats, examples, and requirements. Sample spreadsheetsĬlick any link to view or save the sample spreadsheet (.xlsx) file:Ĭlick any link to save the blank spreadsheet template file select Excel Workbook (.xslx) as the extension: The worksheets contain drop-down lists to select values that the Converter API requires. The products and facilities worksheets describe your Master data, and provide a single source of attributes and values for reuse. Your input file to the Converter API may contain multiple worksheets-including one for facilities (locations) and one for products. Download a sample Excel spreadsheet (or a blank template) below, and review the worksheets and the required formats.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |