CB Statement Import Designer

CB Statement Import Designer - Line Type tabs

Navigator > Setup > Cash Book > Statement Import Designer > Line Type [Number] tab

You can have one or many line type tabs depending on the structure of the import file. Additional line type tabs are inserted from the Definition tab. Line Type tabs must be numbered sequentially, starting with Line Type 1.

Define the fields in the import file for this line type as variables that can be used in the Import Line code below.


Name		The variable name given to the field in the import file record. This can be referenced in the Import Data code below.
Offset		Determine the position of the field within the import file record. For CSV and Tab delimited files, this is the field number (or field) in the file (starting from 1 as the first field). For ASCII files this is the starting character position (starting from 1).
Width		Only used for ASCII file format, this is the width of the field in characters.
Comment		Has no effect on the import, allows for documentation attached to the field.
Grid Toolbar
	Expand Toolbar `(Ctrl+F9)`	Expand the toolbar to give access to all toolbar options. Press `Esc` to close the expanded toolbar.
	Insert `(F4)`	Insert a line.
	Move up `(Shift+Up)` Move down `(Shift+Down)`	Move a line up or down the grid.
	Delete `(F3)`	Delete a line.
	Export Fields	Open Export Line Type to create a file in a selected format containing the headers from the field list.
Import Line		Code you can call from the For Each Line code on the Definition tab, to process this type of line in the import file.

See Code Editor for options available.