User Guide : Map Connectors : Source and Target Map Connectors : SBT Acct (FoxPro)
 
Share this page             
SBT Acct (FoxPro)
SBT Accounting is an accounting application that uses an xBASE format. If the data file references a memo field file, the memo file must exist for the connection to occur. The primary data file usually has a .DBF extension and the memo file usually has a .FPT extension. SBT Acct (FoxPro) files are structured. For example, both the data and the file structure are stored inside the primary data file. With this connector, the integration platform uses FoxPro to connect to SBT Acct files.
Connector-Specific Notes
Field Names: Each field name must be unique. Field names must be all uppercase characters with an underscore between two words. Field names may contain up to 10 characters, but the first character must be a letter. Examples: ACCOUNT, LAST_NAME, FIRST_NAME, PHONE_NO
Size of Fields: Character fields can be no longer than 254 characters. If a field is longer than 254 characters, it must be defined as a Memo field.
Number of Fields: A maximum of 255 fields are allowed.
Record Width: The maximum combined width of all fields in one record is 4000 bytes, excluding memo fields.
Property Options
You can set the following source (S) and target (T) properties.
Property
S/T
Description
IgnoreMemoErr
ST
This option determines how memo files are handled. The following options are available:
Never - This is the default. The integration platform look for and includes any memo file fields when the source data file is read.
Errors - The integration platform looks for and includes any memo file fields when a memo file is present. If present, the memo fields are included with the transformed data.If the memo file (.FPT) is not in the same directory as the data file (.DBF), the memo file is ignored. This means that the memo fields are not included with the transformed data.
Always - The integration platform ignores the memo file completely. This means that the memo fields are not included with the transformed data.
CodePage
ST
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
Data Types
The following data types are available:
Character – may contain alpha or numeric information and may have a field width of 1 to 254 bytes. Use a character field to store numbers that are not used in calculations, such as phone numbers, check numbers, account numbers and zip codes (number fields delete the leading zeros in some zip codes).
Date – may contain only a date and the date is formatted as yyyymmdd, for a four-digit year, a two-digit month and a two-digit day. For example, the date January 1, 1999, would read 1999101.
Float – may contain only positive or negative numbers and may have a field width of 1 to 20 bytes, including the decimal point, minus sign (-), or plus sign (+). Float fields are used to store small and large numbers needed in scientific calculations, such as 9.1234e 12 or 9,123,400,000,000.
Logical – may contain only one byte and is formatted to contain t, f, T, or F, for true or false.
Memo – may contain alpha or numeric information and may have a field width of 1 to 16,000 bytes.
Numeric – may contain only positive or negative numbers and may have a field width of 1 to 20 bytes, including the decimal point, minus sign (-), or plus sign (+). A numeric field may contain decimal places up to 19, but the number of decimal places must be set at one byte less than the total width of the field. Numeric fields are used to store the exact value of a number with a fixed number of digits.