New Record Defaults – Textdata record format

Default information for each type of master record is stored in one or more records in the TextData file.  Multiple copies of these TEXTDATA records may exist for each master record to allow different default files to be used for different users or groups of users.

Each Textdata record contains some fields that are used to identify the record type and which users or groups it should apply to, and one large text field that contains the actual default informaton. Each of the Textdata records that are used for defaulting information into Master records is:formated as follows.

Textdata Type:NRD (this stands for new record default)

Textdata Code:  The actual data filename (dataflex name) of the master file. Valid filenames include.

      COMPANY

      VENDOR

      CATALOG

      INVENTRY

      CONTACT

Textdata Ident: DFL

Textdata User:  This field is loaded with the user, group or branch that the record should be used for.  If the field is left blank, the default file will be used by all operators who do not have a user, group, or branch specific copy of the record that applies to them.

Textdata Comment Field

The format of the comment field in the default data record is very similar to that of a DataFlex TAG file (the tag file lists the field names of all of the data fields in a given file in field number order with each field name on a single line).  The entire contents of the tag file are loaded into the comment field of the TEXTDATA record and then the default information is added to the fields which you would like to load default values for.  Default data may not contain any field terminating punctuation such as commas, quotes, etc   A comma is normally added after the field name, regardless of whether the field will have a default value or not.  The default information is then entered after the comma and followed by a carriage return. ...What punctuation is used for field termination varies with the operating system you are using (a carriage return is used inside of the comment field).  The default values for each field must conform with the defined field type, and defined system behavior.  For example, you may only default numeric information into numeric data fields, dates, into date fields, ascii or numeric information into ascii fields.  If the field values should be Y or N, only one of those values should be used.  Some sample field values for the CATALOG data file are shown below.  You would typically never load fields that are designed to be updated by system processes, such as inventory quantities or costs, or that are unique by nature (inventory item number, customer, name, account).

LEAD,30

CLASS,A

TAX,Y

STK,Y

SERIAL,N

TYPE,

ASSEMBLY_CODE,F

WARRANTY,

CARTONS,

BUYER,JCS

PRODMANAGER,

LAST_SALE,

BOCODE,Y

VERSION,

SALES_CAT,

SPECIAL,

SHIPCODE,

AUTHORIZED,