Skip to content

Suggested Text File Schema Definition Tutorial

This tutorial will show you how to build a Text File Schema Definition that, in addition to the Minimal Text Fille Schema Definition previously completed, will also contain the suggested information used to define and validate the Tutorial Text File successfully.

Tutorial Text File

last_name,first_name,state,zip_code,price,date,notes
Craig,Kai,OK,73755,15499,12/26/2019,"friendly, prompt and good tipper"
Wilcox,Jack,,,12458,7/14/2017,very nice
O'Neil,Kasper,WY,82937,15499,3/7/2011,paid by certified check
Marks,Sopoline,CT,06778,4859,8/21/2014,"never paid, do not do any further business"
Kelly,Colorado,,,9899,6/3/2018,

Built Minimal Text File Schema Definition

Type=CONTROL,ID=1,SchemaEnclosureCharacter=22,Version=1.0.1.22,,,,,,,,,,,,,,,,,
Type=META,ID=2,Name=,Annotation=,Version=,FileType=DELIMITED,DelimiterCharacter=2C,EnclosureCharacter=22,EncloseWhen=NEEDED,CharacterEncoding=UTF-8,EndOfLine=NEWLINE,FieldIDByHeaderOrPosition=HEADER,SchemaURL=,OwnerName=,OwnerEmail=,OwnerPhone=,,,,,
Type=RECORD,ID=3,Name=,Annotation=,Position=1,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=1,Width=,IsHeader=YES,TrailingDelimiter=NO,,,
Type=RECORD,ID=4,Name=,Annotation=,Position=2,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=,Width=,IsHeader=NO,TrailingDelimiter=NO,,,
Type=FIELD,ID=5,Name=,Annotation=,Position=1,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=6,Name=,Annotation=,Position=2,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=7,Name=,Annotation=,Position=3,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=8,Name=,Annotation=,Position=4,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=9,Name=,Annotation=,Position=5,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=10,Name=,Annotation=,Position=6,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=11,Name=,Annotation=,Position=7,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=12,Name=,Annotation=,Position=1,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=13,Name=,Annotation=,Position=2,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=14,Name=,Annotation=,Position=3,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=15,Name=,Annotation=,Position=4,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=16,Name=,Annotation=,Position=5,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=NUMBER,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=17,Name=,Annotation=,Position=6,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=DATE TIME,DateTimeFormat=M/d/yyyy,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=18,Name=,Annotation=,Position=7,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=SUMMARY,ID=19,ControlCount=1,MetaCount=1,RecordCount=2,FieldCount=14,ListCount=0,ValueCount=0,ConditionCount=0,RuleCount=0,SummaryCount=1,TotalCount=19,,,,,,,,,

Steps To Build The Suggested Text File Schema Definition

  1. Open the Minimal Text File Schema Definition file in a text editor
    1. https://textfileschema.omegatower.net/schemas/tutorial_minimal.tfsd
    2. Save it with a new file name
    3. Don't forget to save it frequently and often as you build the Text File Schema Definition
  2. Update the Meta Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Smythee Estuary Importers - Sales Summary Text File Schema Definition"
      Giving a name to the Schema Definition ia always a good idea to help users understand what it is.
    2. Set Annotation to "This file had been prepared by Doug Jones to match the records given 12/30/2019"
      Putting some information here about who prepared the Schema Definition and what they based it on is always helpful in the future when questions about the Schema Definition inevitably arise.
    3. Set Version to "1.0.0.1"
      Telling users the version of this Schema Definition is very important so it can be known when changes have been made. The value chosen here is based on the "major.minor[.maintenance[.build]] (example: 1.4.3.5249)" methodology.
    4. Set SchemaURL to "https://www.smytheeestuaryimporters.com/schemas.html"
      Tell users where more information can be found about the schema and any updated versions.
    5. Set OwnerName to "James Smythee"
      It's always best to let users know who to contact if there any questions.
    6. Set OwnerEmail to "james.smythee@smytheeestuaryimporters.com"
      Users should know how to reach the Owner of the Schema Definition by email.
    7. Set OwnerPhone to "123-555-1234"
      Users should know how to reach the Owner of the Schema Definition by phone.
  3. Update the first Record Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Header Record"
      Naming the record will facilitate any discussions or other documentation.
    2. Set Annotation to "This defines the header record"
      Describing the purpose of the record will help users undertand the Schema Definition.
  4. Update the second Record Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Data Record"
      Naming the record will facilitate any discussions or other documentation.
    2. Set Annotation to "This defines the data records"
      Describing the purpose of the record will help users undertand the Schema Definition.
  5. Update the first Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Last Name Header"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "9"
      Since this is a field in the Header Record, the minimum value is equal to the length of the tutorial header text.
    3. Set MaximumLength to "9"
      Since this is a field in the Header Record, the maximum value is equal to the length of the tutorial header text.
    4. Set StringRegex to "^last_name$"
      Since this is a field in the Header Record, the regular expression is set to only allow the text found in the tutorial header text.
    5. Set Sample to "last_name"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  6. Update the second Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "First Name Header"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "10"
      Since this is a field in the Header Record, the minimum value is equal to the length of the tutorial header text.
    3. Set MaximumLength to "10"
      Since this is a field in the Header Record, the maximum value is equal to the length of the tutorial header text.
    4. Set StringRegex to "^first_name$"
      Since this is a field in the Header Record, the regular expression is set to only allow the text found in the tutorial header text.
    5. Set Sample to "first_name"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  7. Update the third Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "State Header"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "5"
      Since this is a field in the Header Record, the minimum value is equal to the length of the tutorial header text.
    3. Set MaximumLength to "5"
      Since this is a field in the Header Record, the maximum value is equal to the length of the tutorial header text.
    4. Set StringRegex to "^state$"
      Since this is a field in the Header Record, the regular expression is set to only allow the text found in the tutorial header text.
    5. Set Sample to "state"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  8. Update the fourth Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "ZIP Code Header"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "8"
      Since this is a field in the Header Record, the minimum value is equal to the length of the tutorial header text.
    3. Set MaximumLength to "8"
      Since this is a field in the Header Record, the maximum value is equal to the length of the tutorial header text.
    4. Set StringRegex to "^zip_code$"
      Since this is a field in the Header Record, the regular expression is set to only allow the text found in the tutorial header text.
    5. Set Sample to "zip_code"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  9. Update the fifth Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Price Header"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "5"
      Since this is a field in the Header Record, the minimum value is equal to the length of the tutorial header text.
    3. Set MaximumLength to "5"
      Since this is a field in the Header Record, the maximum value is equal to the length of the tutorial header text.
    4. Set StringRegex to "^price$"
      Since this is a field in the Header Record, the regular expression is set to only allow the text found in the tutorial header text.
    5. Set Sample to "price"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  10. Update the sixth Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Date Header"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "4"
      Since this is a field in the Header Record, the minimum value is equal to the length of the tutorial header text.
    3. Set MaximumLength to "4"
      Since this is a field in the Header Record, the maximum value is equal to the length of the tutorial header text.
    4. Set StringRegex to "^date$"
      Since this is a field in the Header Record, the regular expression is set to only allow the text found in the tutorial header text.
    5. Set Sample to "date"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  11. Update the seventh Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Notes Header"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "5"
      Since this is a field in the Header Record, the minimum value is equal to the length of the tutorial header text.
    3. Set MaximumLength to "5"
      Since this is a field in the Header Record, the maximum value is equal to the length of the tutorial header text.
    4. Set StringRegex to "^notes$"
      Since this is a field in the Header Record, the regular expression is set to only allow the text found in the tutorial header text.
    5. Set Sample to "notes"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  12. Update the eighth Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Last Name"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "1"
      Since this is a field in the Data Record, the minimum value is equal to the expected minimum length of the data in the tutorial.
    3. Set MaximumLength to "50"
      Since this is a field in the Data Record, the maximum value is equal to the expected maximum length of the data in the tutorial.
    4. Set Sample to "O'Neil"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  13. Update the ninth Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "First Name"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "1"
      Since this is a field in the Data Record, the minimum value is equal to the expected minimum length of the data in the tutorial.
    3. Set MaximumLength to "50"
      Since this is a field in the Data Record, the maximum value is equal to the expected maximum length of the data in the tutorial.
    4. Set Sample to "Kasper"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  14. Update the tenth Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "State"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "2"
      Since this is a field in the Data Record, the minimum value is equal to the expected minimum length of the data in the tutorial.
    3. Set MaximumLength to "2"
      Since this is a field in the Data Record, the maximum value is equal to the expected maximum length of the data in the tutorial.
    4. Set Sample to "WY"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  15. Update the 11th Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "ZIP Code"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "5"
      Since this is a field in the Data Record, the minimum value is equal to the expected minimum length of the data in the tutorial.
    3. Set MaximumLength to "5"
      Since this is a field in the Data Record, the maximum value is equal to the expected maximum length of the data in the tutorial.
    4. Set StringRegex to "^[0-9]{5}$"
    5. Set Sample to "82937"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  16. Update the 12th Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Price"
      Naming the field will facilitate any discussions or other documentation.
    2. Set Annotation to "This value is rounded to whole dollars"
    3. Set NumericMinimumValue to "1"
      Since this is a field in the Data Record, the minimum value is equal to the expected minimum value of the data in the tutorial.
    4. Set NumericMaximumValue to "999999999"
      Since this is a field in the Data Record, the maximum value is equal to the expected maximum value of the data in the tutorial.
    5. Set Sample to "15499"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  17. Update the 13th Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Date"
      Naming the field will facilitate any discussions or other documentation.
    2. Set Sample to "3/7/2011"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.
  18. Update the 14th Field Record, using its definition as a guide, to add more information to assist other users
    1. Set Name to "Notes"
      Naming the field will facilitate any discussions or other documentation.
    2. Set MinimumLength to "1"
      Since this is a field in the Data Record, the minimum value is equal to the expected minimum length of the data in the tutorial.
    3. Set MaximumLength to "255"
      Since this is a field in the Data Record, the maximum value is equal to the expected maximum length of the data in the tutorial.
    4. Set Sample to "paid by certified check"
      Providing a sample of the expected data here will assist users when they are trying to understand the Schema Definition, but do not have a sample Text File to look at.

Built Suggested Text File Schema Definition

Type=CONTROL,ID=1,SchemaEnclosureCharacter=22,Version=1.0.1.22,,,,,,,,,,,,,,,,,
Type=META,ID=2,Name=Smythee Estuary Importers - Sales Summary Text File Schema Definition,Annotation=This file had been prepared by Doug Jones to match the records given 12/30/2019,Version=1.0.0.1,FileType=DELIMITED,DelimiterCharacter=2C,EnclosureCharacter=22,EncloseWhen=NEEDED,CharacterEncoding=UTF-8,EndOfLine=NEWLINE,FieldIDByHeaderOrPosition=HEADER,SchemaURL=https://www.smytheeestuaryimporters.com/schemas.html,OwnerName=James Smythee,OwnerEmail=james.smythee@smytheeestuaryimporters.com,OwnerPhone=123-555-1234,,,,,
Type=RECORD,ID=3,Name=Header Record,Annotation=This defines the header record,Position=1,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=1,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=1,Width=,IsHeader=YES,TrailingDelimiter=NO,,,
Type=RECORD,ID=4,Name=Data Record,Annotation=This defines the data records,Position=2,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=,Width=,IsHeader=NO,TrailingDelimiter=NO,,,
Type=FIELD,ID=5,Name=Last Name Header,Annotation=,Position=1,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=9,MaximumLength=9,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^last_name$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=last_name
Type=FIELD,ID=6,Name=First Name Header,Annotation=,Position=2,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=10,MaximumLength=10,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^first_name$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=first_name
Type=FIELD,ID=7,Name=State Header,Annotation=,Position=3,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=5,MaximumLength=5,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^state$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=state
Type=FIELD,ID=8,Name=ZIP Code Header,Annotation=,Position=4,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=8,MaximumLength=8,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^zip_code$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=zip_code
Type=FIELD,ID=9,Name=Price Header,Annotation=,Position=5,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=5,MaximumLength=5,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^price$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=price
Type=FIELD,ID=10,Name=Date Header,Annotation=,Position=6,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=4,MaximumLength=4,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^date$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=date
Type=FIELD,ID=11,Name=Notes Header,Annotation=,Position=7,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=5,MaximumLength=5,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^notes$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=notes
Type=FIELD,ID=12,Name=Last Name,Annotation=,Position=1,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=1,MaximumLength=50,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=O'Neil
Type=FIELD,ID=13,Name=First Name,Annotation=,Position=2,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=1,MaximumLength=50,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=Kasper
Type=FIELD,ID=14,Name=State,Annotation=,Position=3,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=2,MaximumLength=2,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=WY
Type=FIELD,ID=15,Name=ZIP Code,Annotation=,Position=4,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=5,MaximumLength=5,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^[0-9]{5}$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=82937
Type=FIELD,ID=16,Name=Price,Annotation=,Position=5,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=NUMBER,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=1,NumericMaximumValue=99999999,Start=,Width=,Alignment=,FillCharacter=,Sample=15499
Type=FIELD,ID=17,Name=Date,Annotation=,Position=6,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=DATE TIME,DateTimeFormat=M/d/yyyy,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=3/7/2011
Type=FIELD,ID=18,Name=Notes,Annotation=,Position=7,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=1,MaximumLength=255,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=paid by certified check
Type=SUMMARY,ID=19,ControlCount=1,MetaCount=1,RecordCount=2,FieldCount=14,ListCount=0,ValueCount=0,ConditionCount=0,RuleCount=0,SummaryCount=1,TotalCount=19,,,,,,,,,
Back to top