Understanding Formatting of the CNAO XML Files

When you generate the XML files, the system determines whether data exists in the JD Edwards EnterpriseOne table for each field in each XML file. If no data exists, or the value is null, the system prints the element tags under certain conditions and does not print the element tags under other conditions.

The system prints the data element tag but does not print a value for the tag for blank or null values when one of these conditions exists:

  • The field is a variable- length character string with an optional value.

  • The field is a variable- length character string with a required value.

The system does not print the data element tag for blank or null values when one of these conditions exists:

  • If the field is a fixed-length mandatory character string, the system prints 00000000 if the field length is 8, and prints 0 if the field length is 1.

  • If the field is a mandatory numeric field, the system prints 0.