Strings

This section contains the following topics:

We recommend the following guidelines for using the BigText, Code, and Text data types:

  • Use the BigText data type for large documents.

  • If a text field is part of a primary key, then use the Code data type.

  • If a text field has a TableRelation, then use the Code data type.

  • If the field is assigned values from a Code field, then use the Code data type. For example, if the Document No. field in the G/L Entry table is copied from the primary key field No. in the Sales Header or Purchase Header table, then use the Code data type for the Document No. field.

  • For all other text fields, use the Text data type.

Community Additions

ADD
Show: