Creating Source Fields

Note:

To access the LATAM File Builder SuiteApp documentation in Brazilian Portuguese (Português do Brasil), see LATAM File Builder.

In the electronic data file structure, the source field is the child record of the section source. Source fields contain the information that will be displayed on electronic data files.

The record also has fields where you set length limits, positions, and the order for information in the generated file.

On file imports, NetSuite uses your source field settings to navigate the file and parse the rows.

To create a source field:

  1. Go to Setup > Latam File Builder > File Layout.

  2. Click View next to the layout you want.

  3. Click the Sections subtab.

  4. Click the name of the section you want.

  5. Click the Sources subtab.

  6. Click the name of the source you want.

  7. Click the Fields subtab.

  8. Click New Source Field.

  9. In the Name field, enter a name for the field.

  10. In the Sequence Number field, enter the number for where in the building sequence you want to place this field.

    The sequence starts at 1.

  11. If you want the source field to always display the same information, in the Default Value field, enter the information.

  12. In the Dataset or Saved Search field, enter the column from the dataset or saved search from which NetSuite must retrieve the information for the source field.

  13. In the Field Data Source field, select the source of the information you want to populate in the field.

  14. In the Default Value for Unused Positions field, select the value you want to add to positions that the source field doesn't fill.

    This setting takes precedence over the value for unused positions defined in the file layout.

  15. In the Field Length field, enter the maximum amount of characters the field should contain.

  16. In the Initial Position field, enter the number of the initial position for the field.

  17. In the Final Position field, enter the number of the final position for the field.

  18. In the Decimal Separator field, select the character you want to use as decimal separator in numbers.

  19. In the Date Format field, select the format you want to use for dates.

  20. To remove special characters from the information in the source field, check the Remove Special Characters box.

    Special characters include punctuation marks, ampersands, backslashes, pipes, and other symbols.

  21. To make this source field an identifier for its parent source section, check the Source Import Identifier box.

    When importing a text file, NetSuite tries to match each of the file's rows with the appropriate section sources. The source identifier enables NetSuite to find the first field in a given section. The field's information, such as its positions, default value and dataset, or saved search column, is used as a reference to import the data from all the fields from the same row.

  22. In the Description field, enter a summary about the source field.

  23. To keep the content in the source field unformatted when it’s empty, check the Keep Null Values Unformatted box.

  24. To remove line breaks from the information in the source field, check the Remove Line Breaks box.

  25. To remove accent marks from alphabetical characters in the source field, check the Remove Accent Marks box.

    Accent marks include acute accents, circumflexes, and tildes.

  26. Click Save.

  27. (Optional) If you want to associate this source field with another field, do the following:

    1. Click the Related Fields subtab.

    2. Click New Related Source Field.

    3. In the Name field, enter the name of the related source field.

    4. In the Related Source Field field, select the source field with which you want to associate the parent source field.

      The related source field can either serve as a basis for the output of the parent source field or receive information from it.

    5. (Optional) In the SuiteQL Query field, enter the field from the SuiteQL query that has the unique information to be included in the parent source field.

      Only enter a SuiteQL query if the parent source field is a text field and provides information to the related source field. If the parent source field is an ID field or receives information from the related source field, leave this field blank.

    6. Click Save.

Related Topics

General Notices