File Definition Rule for converting EDi Order to Sales Order

{

 “resourcePath”: “”,

 “fileDefinition”: {

  “_id”: “66e01a66e98dc5437ecc38fe”,

  “lastModified”: “2024-09-25T09:01:04.872Z”,

  “name”: “Samios EDIFACT ORDERS”,

  “sandbox”: true,

  “description”: “Samios Purchase Order”,

  “version”: “1”,

  “format”: “delimited/edifact”,

  “delimited”: {

   “rowSuffix”: “‘”,

   “rowDelimiter”: “n”,

   “colDelimiter”: “+”

  },

  “rules”: [

   {

    “maxOccurrence”: 1,

    “required”: true,

    “skipRowSuffix”: true,

    “elements”: [

     {

      “name”: “UNA”,

      “value”: “UNA:”

     }

    ]

   },

   {

    “maxOccurrence”: 1,

    “required”: true,

    “skipRowSuffix”: true,

    “elements”: [

     {

      “name”: “UNB”,

      “value”: “UNB”

     },

     {

      “name”: “SYNTAX IDENTIFIER”,

      “value”: {

       “delimiter”: “:”,

       “elements”: [

        {

         “name”: “Syntax identifier”,

         “value”: “UNOC”

        },

        {

         “name”: “Syntax version number”,

         “value”: “3”

        }

       ]

      }

     },

     {

      “name”: “INTERCHANGE SENDER”,

      “value”: {

       “delimiter”: “:”,

       “elements”: [

        {

         “name”: “Sender identification”,

         “value”: “SAM”

        },

        {

         “name”: “Partner identification code qualifier”,

         “value”: “ZZZ”

        }

       ]

      }

     },

     {

      “name”: “INTERCHANGE RECIPIENT”,

      “value”: {

       “delimiter”: “:”,

       “elements”: [

        {

         “name”: “Recipient identification”,

         “value”: “OXTOOLS”

        },

        {

         “name”: “Partner identification code qualifier”,

         “value”: “ZZZ”

        }

       ]

      }

     },

     {

      “name”: “DATE/TIME OF PREPARATION”,

      “value”: {

       “delimiter”: “:”,

       “elements”: [

        {

         “name”: “Date of preparation”,

         “value”: “240904”

        },

        {

         “name”: “Time of preparation”,

         “value”: “1004”

        }

       ]

      }

     },

     {

      “name”: “Interchange control reference”,

      “value”: “2839”

     }

    ],

    “children”: [

     {

      “maxOccurrence”: 1,

      “required”: true,

      “skipRowSuffix”: true,

      “elements”: [

       {

        “name”: “UNH”,

        “value”: “UNH”

       },

       {

        “name”: “Message reference number”,

        “value”: “42285”

       },

       {

        “name”: “MESSAGE IDENTIFIER”,

        “value”: {

         “delimiter”: “:”,

         “elements”: [

          {

           “name”: “Message type identifier”,

           “value”: “ORDERS”

          },

          {

           “name”: “Message type version number”,

           “value”: “D”

          },

          {

           “name”: “Message type release number”,

           “value”: “96A”

          },

          {

           “name”: “Controlling agency”,

           “value”: “UN”

          }

         ]

        }

       }

      ],

      “children”: [

       {

        “maxOccurrence”: 1,

        “required”: true,

        “skipRowSuffix”: true,

        “elements”: [

         {

          “name”: “BGM”,

          “value”: “BGM”

         },

         {

          “name”: “DOCUMENT/MESSAGE NAME”,

          “value”: {

           “delimiter”: “:”,

           “elements”: [

            {

             “name”: “Document/message name, coded”,

             “value”: “105”

            }

           ]

          }

         },

         {

          “name”: “Document/message number”,

          “value”: “50878216”

         },

         {

          “name”: “Message function, coded”,

          “value”: “9”

         }

        ],

        “children”: [

         {

          “required”: true,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “DTM”,

            “value”: “DTM”

           },

           {

            “name”: “DATE/TIME/PERIOD”,

            “value”: {

             “delimiter”: “:”,

             “elements”: [

              {

               “name”: “Date/time/period qualifier”,

               “value”: “137”

              },

              {

               “name”: “Date/time/period”,

               “value”: “20240618”

              },

              {

               “name”: “Date/time/period format qualifier”,

               “value”: “102”

              }

             ]

            }

           }

          ]

         },

         {

          “required”: true,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “DTM”,

            “value”: “DTM”

           },

           {

            “name”: “DATE/TIME/PERIOD”,

            “value”: {

             “delimiter”: “:”,

             “elements”: [

              {

               “name”: “Date/time/period qualifier”,

               “value”: “10”

              },

              {

               “name”: “Date/time/period”,

               “value”: “20240618”

              },

              {

               “name”: “Date/time/period format qualifier”,

               “value”: “102”

              }

             ]

            }

           }

          ]

         },

         {

          “name”: “Segment Group FTX”,

          “maxOccurrence”: 3,

          “container”: true,

          “children”: [

           {

            “required”: false,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “FTX”,

              “value”: “FTX”

             },

             {

              “name”: “Text subject code qualifier”,

              “value”: “GEN”

             },

             {

              “name”: “Text function, coded”,

              “value”: “S”

             },

             {

              “name”: “Text reference”,

              “value”: “SAMPLE_HEADER_COMMENT”

             },

             {

              “name”: “TEXT literal”,

              “value”: {

               “delimiter”: “:”,

               “elements”: [

                {

                 “name”: “Free text value(FTX040-010)”,

                 “value”: “Sample free text value 1”

                },

                {

                 “name”: “Free text value(FTX040-020)”,

                 “value”: “Sample free text value 2”

                },

                {

                 “name”: “Free text value(FTX040-030)”,

                 “value”: “Sample free text value 3”

                },

                {

                 “name”: “Free text value(FTX040-040)”,

                 “value”: “Sample free text value 4”

                }

               ]

              }

             }

            ]

           }

          ]

         },

         {

          “required”: false,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “RFF”,

            “value”: “RFF”

           },

           {

            “name”: “REFERENCE”,

            “value”: {

             “delimiter”: “:”,

             “elements”: [

              {

               “name”: “Reference function code qualifier”,

               “value”: “RFF010-010”

              },

              {

               “name”: “Reference number”,

               “value”: “RFF010-020”

              }

             ]

            }

           }

          ]

         },

         {

          “name”: “Segment Group 2”,

          “maxOccurrence”: 4,

          “container”: true,

          “children”: [

           {

            “required”: true,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “NAD”,

              “value”: “NAD”

             },

             {

              “name”: “Party qualifier”,

              “value”: “BY”

             },

             {

              “name”: “PARTY IDENTIFICATION DETAILS”,

              “value”: {

               “delimiter”: “:”,

               “elements”: [

                {

                 “name”: “Party id. identification”,

                 “value”: “NAD020-010”

                },

                {

                 “name”: “NAD020-020”,

                 “value”: “NAD020-020”

                },

                {

                 “name”: “Code list responsible agency, coded”,

                 “value”: “160”

                }

               ]

              }

             },

             {

              “name”: “NAD030”,

              “value”: “NAD030”

             },

             {

              “name”: “PARTY NAME”,

              “value”: {

               “delimiter”: “:”,

               “elements”: [

                {

                 “name”: “Party name”,

                 “value”: “SAMIOS PLUMBING EAGLE FARM”

                },

                {

                 “name”: “Party name(NAD040-020)”,

                 “value”: “NAD040-020”

                }

               ]

              }

             },

             {

              “name”: “STREET”,

              “value”: {

               “delimiter”: “:”,

               “elements”: [

                {

                 “name”: “Street and number/p.o. box”,

                 “value”: “181 – 189 FISON AVENUE”

                },

                {

                 “name”: “Street and number/p.o. box(NAD050-020)”,

                 “value”: “NAD050-020”

                }

               ]

              }

             },

             {

              “name”: “City name”,

              “value”: “EAGLE FARM”

             },

             {

              “name”: “Country sub-entity identification”,

              “value”: “QLD”

             },

             {

              “name”: “Postcode identification”,

              “value”: “4009”

             },

             {

              “name”: “Country, coded”,

              “value”: “AU”

             }

            ]

           },

           {

            “required”: false,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “RFF”,

              “value”: “RFF”

             },

             {

              “name”: “Reference qualifier”,

              “value”: “AHP”

             },

             {

              “name”: “Reference number”,

              “value”: “41151919569”

             }

            ]

           },

           {

            “required”: false,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “CTA”,

              “value”: “CTA”

             },

             {

              “name”: “Contact function, coded”,

              “value”: “PD”

             },

             {

              “name”: “Contact identifier”,

              “value”: “JEREMY MCWHIRTER”

             }

            ]

           },

           {

            “name”: “Segment Group 2”,

            “maxOccurrence”: 4,

            “container”: true,

            “children”: [

             {

              “required”: false,

              “skipRowSuffix”: true,

              “elements”: [

               {

                “name”: “COM”,

                “value”: “COM”

               },

               {

                “name”: “Communication channel qualifier”,

                “value”: “TE”

               },

               {

                “name”: “Communication channel identifier”,

                “value”: “08 9242 8110”

               }

              ]

             }

            ]

           }

          ]

         },

         {

          “maxOccurrence”: 1,

          “required”: false,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “NAD”,

            “value”: “NAD”

           },

           {

            “name”: “Party qualifier”,

            “value”: “ST”

           },

           {

            “name”: “PARTY IDENTIFICATION DETAILS”,

            “value”: {

             “delimiter”: “:”,

             “elements”: [

              {

               “name”: “Party id. identification”,

               “value”: “BGW”

              },

              {

               “name”: “Code list responsible agency, coded”,

               “value”: “160”

              },

              {

               “name”: “Party id. code”,

               “value”: “92”

              }

             ]

            }

           },

           {

            “name”: “Party name”,

            “value”: “BGW GROUP”

           },

           {

            “name”: “Street”,

            “value”: “675 MACARTHUR AVE”

           },

           {

            “name”: “City”,

            “value”: “PINKENBA”

           },

           {

            “name”: “State”,

            “value”: “QLD”

           },

           {

            “name”: “Postal code”,

            “value”: “4008”

           }

          ]

         },

         {

          “maxOccurrence”: 1,

          “required”: false,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “CTA”,

            “value”: “CTA”

           },

           {

            “name”: “Contact function, coded”,

            “value”: “GR”

           },

           {

            “name”: “Contact name”,

            “value”: “JOHN KENYON”

           }

          ]

         },

         {

          “maxOccurrence”: 1,

          “required”: false,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “TOD”,

            “value”: “TOD”

           },

           {

            “name”: “Terms of delivery or transport function, coded”,

            “value”: “TOD010”

           },

           {

            “name”: “Transport charges method of payment”,

            “value”: “TOD020”

           },

           {

            “name”: “Terms of delivery or transport”,

            “value”: {

             “delimiter”: “:”,

             “elements”: [

              {

               “name”: “Delivery or transport”,

               “value”: “TAD030-010”

              }

             ]

            }

           }

          ]

         },

         {

          “maxOccurrence”: 1,

          “required”: false,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “TDT”,

            “value”: “TDT”

           },

           {

            “name”: “Transport stage qualifier”,

            “value”: “25”

           },

           {

            “name”: “Mode of transport”,

            “value”: “ROAD”

           },

           {

            “name”: “Transport charges method of payment”,

            “value”: “TDT030”

           },

           {

            “name”: “Transport service provider”,

            “value”: {

             “delimiter”: “:”,

             “elements”: [

              {

               “name”: “Service provider name”,

               “value”: “STARTRACK”

              }

             ]

            }

           }

          ]

         },

         {

          “name”: “Segment Group 25”,

          “maxOccurrence”: 200000,

          “container”: true,

          “children”: [

           {

            “required”: true,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “LIN”,

              “value”: “LIN”

             },

             {

              “name”: “Line item number”,

              “value”: “LIN010”

             },

             {

              “name”: “LIN020”,

              “value”: “LIN020”

             },

             {

              “name”: “ITEM NUMBER IDENTIFICATION”,

              “value”: {

               “delimiter”: “:”,

               “elements”: [

                {

                 “name”: “Item number”,

                 “value”: “LIN030-010”

                },

                {

                 “name”: “Item number type, coded”,

                 “value”: “LIN030-020”

                }

               ]

              }

             }

            ]

           },

           {

            “name”: “Segment Group 26”,

            “maxOccurrence”: 200000,

            “container”: true,

            “children”: [

             {

              “required”: false,

              “skipRowSuffix”: true,

              “elements”: [

               {

                “name”: “PIA”,

                “value”: “PIA”

               },

               {

                “name”: “Product id. function qualifier”,

                “value”: “1”

               },

               {

                “name”: “ITEM NUMBER IDENTIFICATION(PIA020)”,

                “value”: {

                 “delimiter”: “:”,

                 “elements”: [

                  {

                   “name”: “Item number”,

                   “value”: “TOX-P224301”

                  },

                  {

                   “name”: “Item number type, coded”,

                   “value”: “VP”

                  }

                 ]

                }

               }

              ]

             }

            ]

           },

           {

            “required”: true,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “IMD”,

              “value”: “IMD”

             },

             {

              “name”: “Item description”,

              “value”: “PRO HD FIXED BLADE FOLDING KNIFE 3:X BLD”

             }

            ]

           },

           {

            “required”: true,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “QTY”,

              “value”: “QTY”

             },

             {

              “name”: “QUANTITY DETAILS”,

              “value”: {

               “delimiter”: “:”,

               “elements”: [

                {

                 “name”: “Quantity qualifier”,

                 “value”: “21”

                },

                {

                 “name”: “Quantity”,

                 “value”: “2.00”

                },

                {

                 “name”: “Measurement unit code”,

                 “value”: “EA”

                }

               ]

              }

             }

            ]

           },

           {

            “required”: true,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “DTM”,

              “value”: “DTM”

             },

             {

              “name”: “DATE/TIME/PERIOD”,

              “value”: {

               “delimiter”: “:”,

               “elements”: [

                {

                 “name”: “Date/time/period qualifier”,

                 “value”: “10”

                },

                {

                 “name”: “Date/time/period”,

                 “value”: “20240618”

                },

                {

                 “name”: “Date/time/period format qualifier”,

                 “value”: “102”

                }

               ]

              }

             }

            ]

           },

           {

            “maxOccurrence”: 1,

            “required”: false,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “FTX”,

              “value”: “FTX”

             },

             {

              “name”: “TEXT SUBJECT QUALIFIER”,

              “value”: “LIN”

             },

             {

              “name”: “TEXT FUNCTION, CODED”,

              “value”: “”

             },

             {

              “name”: “TEXT REFERENCE”,

              “value”: “”

             },

             {

              “name”: “FREE TEXT”,

              “value”: “{{freeText}}”

             }

            ]

           },

           {

            “required”: true,

            “skipRowSuffix”: true,

            “elements”: [

             {

              “name”: “PRI”,

              “value”: “PRI”

             },

             {

              “name”: “PRICE INFORMATION”,

              “value”: {

               “delimiter”: “:”,

               “elements”: [

                {

                 “name”: “Price qualifier”,

                 “value”: “AAA”

                },

                {

                 “name”: “Price”,

                 “value”: “9.8820”

                }

               ]

              }

             }

            ]

           }

          ]

         },

         {

          “required”: true,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “UNS”,

            “value”: “UNS”

           },

           {

            “name”: “Section identification”,

            “value”: “S”

           }

          ]

         },

         {

          “required”: true,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “MOA”,

            “value”: “MOA”

           },

           {

            “name”: “Monetary amount”,

            “value”: “45.02”

           }

          ]

         },

         {

          “required”: true,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “CNT”,

            “value”: “CNT”

           },

           {

            “name”: “Control qualifier”,

            “value”: “2”

           },

           {

            “name”: “Control value”,

            “value”: “2”

           }

          ]

         },

         {

          “required”: true,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “UNT”,

            “value”: “UNT”

           },

           {

            “name”: “Number of segments in a message”,

            “value”: “33”

           },

           {

            “name”: “Message reference number(UNT020)”,

            “value”: “42285”

           }

          ]

         },

         {

          “required”: true,

          “skipRowSuffix”: true,

          “elements”: [

           {

            “name”: “UNZ”,

            “value”: “UNZ”

           },

           {

            “name”: “Interchange control count”,

            “value”: “1”

           },

           {

            “name”: “Interchange control reference(UNZ020)”,

            “value”: “2839”

           }

          ]

         }

        ]

       }

      ]

     }

    ]

   }

  ]

 }

}

Leave a comment

Your email address will not be published. Required fields are marked *