Class FL_FALink

Properties

LOCAL cAPPTYPEdepreciation$="3"  
LOCAL cAPPTYPElite$="1"  
LOCAL cUSCompanyAppId=3  
PROPERTY SFAApplicationPath$   * Read Only *

Methods

FUNCTION ClearCompany()  

Drops the currently opened SFA company object and releases its resources.

FUNCTION ClearDatabase()  

Drops the currently opened SFA database object and releases its resources.

FUNCTION CompleteConfiguration()  

Complete the configuration of the system

Returns [boolean] Success or failure.
FUNCTION CreateAsset(templateName$, templateDesc$, acquisitionDate$, acquisitionValue, systemNo$)  
FUNCTION GetApplicationType$()  

Returns the current Sage Fixed Assets application type.

Returns [string] Returns "3" for standard depreciation, or "1" for lite.
FUNCTION GetBookStatus(bookStatus$)  

Iterates all the books of the current SFA company and returns the status of all the books.

ParameterDescription
x$ [output, string] An un-delimited string of book statuses; "Y" for open, "N" for closed.
Returns [boolean] Success or failure.
FUNCTION GetCompanyList$()  

Returns a SEP separated list of SFA company names and Id's found in the currently set SFA database.

Returns [string] SEP separated list of ids + $0A$ + SEP separated list of company names
FUNCTION GetCompanyName$()  

Returns the name of the currently set SFA company.

Returns [string] The SFA company name.
FUNCTION GetDatabaseList(databaseList$)  

Returns a SEP separated list of SFA database names.

ParameterDescription
databaseList$ [output,string] List of database names
Returns [boolean] Success or failure.
FUNCTION IsLiteDepreciation()  

Returns a boolean to indicate of the installed version of SFA is LiteDepreciation

Returns [boolean] True if installed SFA is LiteDepreciation; otherwise False
FUNCTION PopulateAssetTemplate(useProgress)  
FUNCTION PopulateAssetTemplates()  

Populates the FL_AssetTemplates table with all the templates found in the SFA company database.

ParameterDescription
useProgress [optional] indicate if progress bar should display
Returns [boolean] Success or failure.
FUNCTION PopulateFAAssetTemplate()  
FUNCTION ReadBooks(sfaCompanyID$, postingBookList$)  

Creates a list of open Posting Books

ParameterDescription
sfaCompanyID$ [input, string] SFA Company
postingBookList$ [output, string] List of open Posting Books for the SFA Company
Returns [boolean] Always returns success
FUNCTION ReadBooksAll(sfaCompanyID$, books)  

Returns a collection of all Posting Books for an SFA Company

ParameterDescription
sfaCompanyID$ [input, string] SFA Company
books [input/output, object] (Required) An instance of a SY_KeyedCollection class to return the posting books with their status in.
Returns [numeric] Number of books returned
FUNCTION ReadLabels(sfaCompanyID$, bookDefinitionFieldList$)  

Creates a list of Book Definition Fields

ParameterDescription
sfaCompanyID$ [input, string] SFA Company
bookDefinitionFieldList$ [output, string] List of Book Definition Fields
Returns [boolean] Always returns success
FUNCTION SetCompany()  
FUNCTION SetCompany(sfaCompanyID$)  

Instantiates an SFA company object for the given company Id and opens a connection.

ParameterDescription
sfaCompanyID$ [input, string] The SFA company Id.
Returns [boolean] Success or failure.
FUNCTION SetDatabase()  
FUNCTION SetDatabase(databaseName$)  

Instantiates an SFA database object for the given database name and opens a connection.

ParameterDescription
databaseName$ [input, string] The SFA database name.
Returns [boolean] Success or failure.

Properties inherited from: SY_OpenObject

cLockInfoNOKEY$

Methods inherited from: SY_Common

FormatAddress(), ParseCityStateZip(), ClassValidateDirectory(), DirectoryCheck(), GetNextSequence(), GetUNCNamedDrive(), IsInstalled(), LocalizeFileIOList(), LocalizeIOList(), PackSequence$(), UnpackSequence(), UseChildKeyColl()

Methods inherited from: SY_OpenObject

CheckWhoHasLock(), CreateLockInfo(), RemoveLockInfo(), OpenTable(), OpenTempFile()