API query FAAssetTypeFABookByType (optimised)

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
iiCompanyId	i
iiFAAssetTypeID	i	=
icFAAssetTypeCode	c	=
tFAAssetTypeFABook.FAAssetTypeBookSequence	i	=,>=,>,<>,<=,<
tFAAssetType.FAAssetTypeCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFABook.FABookCalculationType	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFABook.FABookCEEAccelAddition	d	=,>=,>,<>,<=,<
tFABook.FABookCEEAccelFirstYr	d	=,>=,>,<>,<=,<
tFABook.FABookCEEAccelIncrDepr	d	=,>=,>,<>,<=,<
tFABook.FABookCEEAccelNextYr	d	=,>=,>,<>,<=,<
tFABook.FABookCEEEvenAddition	d	=,>=,>,<>,<=,<
tFABook.FABookCEEEvenFirstYr	d	=,>=,>,<>,<=,<
tFABook.FABookCEEEvenNextYr	d	=,>=,>,<>,<=,<
tFABook.FABookCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFABook.FABookDepreciationType	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFABook.FABookDescription	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFABook.FABookIsActive	l	=,<>
tFABook.FABookIsWithDepreciation	l	=,<>
tFABook.FABookLifeCycle	i	=,>=,>,<>,<=,<
tFABookType.FABookTypeCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFABookType.FABookTypeDescription	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFABookType.FABookTypeIsActive	l	=,<>
tFABookType.FABookTypeIsOfficial	l	=,<>
tUnit.UnitCode	c	=,>=,>,<>,<=,<,begins,can-do,matches

Parameters (internal)

iiCompanyId	integer	Company id
iiFAAssetTypeID	integer	FAAssetTypeID
icFAAssetTypeCode	character	FAAssetTypeCode

query condition

each FAAssetType where

FAAssetType.Company_Id = iiCompanyId AND
FAAssetType.FAAssetType_ID = iiFAAssetTypeID AND
FAAssetType.FAAssetTypeCode = icFAAssetTypeCode

each FAAssetTypeFABook (inner-join) where

FAAssetTypeFABook.FAAssetType_ID = FAAssetType.FAAssetType_ID AND

first FABook (inner-join) where

FABook.Company_Id = iiCompanyId AND
FABook.FABook_ID = FAAssetTypeFABook.FABook_ID AND

first Unit (conditional-join) where

Unit.Unit_ID = FABook.Unit_ID AND

first FABookType (inner-join) where

FABookType.Company_Id = iiCompanyId AND
FABookType.FABookType_ID = FABook.FABookType_ID AND

query sort order

FAAssetType.FAAssetTypeCode (ascending)

query resultset tqFAAssetTypeFABookByType

field name	data type	db field	description
tiCompany_ID	integer	FAAssetType.Company_ID	Link to Company
tiDepreciationJournal_ID	integer	FABookType.DepreciationJournal_ID	Depreciation Daybook Code
tiDisposalJournal_ID	integer	FABookType.DisposalJournal_ID	Disposal Daybook Code
tiFAAssetType_ID	integer	FAAssetType.FAAssetType_ID	Record ID
tiFAAssetTypeBookSequence	integer	FAAssetTypeFABook.FAAssetTypeBookSequence	Sequence
tcFAAssetTypeCode	character	FAAssetType.FAAssetTypeCode	Code
tiFAAssetTypeFABook_ID	integer	FAAssetTypeFABook.FAAssetTypeFABook_ID	Record ID
tiFABook_ID	integer	FABook.FABook_ID	Record ID
tcFABookCalculationType	character	FABook.FABookCalculationType	Calculation Type
tdFABookCEEAccelAddition	decimal	FABook.FABookCEEAccelAddition	After Addition [Coef]
tdFABookCEEAccelFirstYr	decimal	FABook.FABookCEEAccelFirstYr	First Year [Coef]
tdFABookCEEAccelIncrDepr	decimal	FABook.FABookCEEAccelIncrDepr	First Year Depreciation Increase [%]
tdFABookCEEAccelNextYr	decimal	FABook.FABookCEEAccelNextYr	Next Years [Coef]
tdFABookCEEEvenAddition	decimal	FABook.FABookCEEEvenAddition	After Addition [%]
tdFABookCEEEvenFirstYr	decimal	FABook.FABookCEEEvenFirstYr	First Year [%]
tdFABookCEEEvenNextYr	decimal	FABook.FABookCEEEvenNextYr	Next Year [%]
tcFABookCode	character	FABook.FABookCode	Code
tcFABookDepreciationType	character	FABook.FABookDepreciationType	Depreciation Type
tcFABookDescription	character	FABook.FABookDescription	Description
tlFABookIsActive	logical	FABook.FABookIsActive	Active
tlFABookIsWithDepreciation	logical	FABook.FABookIsWithDepreciation	With Depreciation
tiFABookLifeCycle	integer	FABook.FABookLifeCycle	Life Cycle
tiFABookType_ID	integer	FABookType.FABookType_ID	Record ID
tcFABookTypeCode	character	FABookType.FABookTypeCode	Code
tcFABookTypeDescription	character	FABookType.FABookTypeDescription	Description
tlFABookTypeIsActive	logical	FABookType.FABookTypeIsActive	Active
tlFABookTypeIsOfficial	logical	FABookType.FABookTypeIsOfficial	Official
tiRevaluationJournal_ID	integer	FABookType.RevaluationJournal_ID	Revaluation Daybook Code
tiUnit_ID	integer	FABook.Unit_ID	GL Account Unit of Measure
tcUnitCode	character	Unit.UnitCode	Unit of Measure
FAAssetTypeCustom	character	calculated	custom fields
FAAssetTypeFABookCustom	character	calculated	custom fields
FABookCustom	character	calculated	custom fields
FABookTypeCustom	character	calculated	custom fields
UnitCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(FAAssetType),rowid(FAAssetTypeFABook),rowid(FABook),rowid(Unit),rowid(FABookType)

Internal usage

QadFinancials

method BCompany.ValidateComponentSSChange
method BFixedAssetAsset.DefaultValuesAssetTypeBook
method BFixedAssetAsset.ValidateComponentAssetBook

Sample code: how to call this query through RPCRequestService (QXtend Inbound)

define temp-table ttContext no-undo
    field propertyQualifier as character
    field propertyName as character
    field propertyValue as character
    index entityContext is primary unique
        propertyQualifier
        propertyName
    index propertyQualifier
        propertyQualifier.

define dataset dsContext for ttContext.

define variable vhContextDS as handle no-undo.
define variable vhExceptionDS as handle no-undo.
define variable vhServer as handle no-undo.
define variable vhInputDS as handle no-undo.
define variable vhInputOutputDS as handle no-undo.
define variable vhOutputDS as handle no-undo.
define variable vhParameter as handle no-undo.

/* Create context */
create ttContext.
assign ttContext.propertyName = "programName"
       ttContext.propertyValue = "BFixedAssetAssetType".
create ttContext.
assign ttContext.propertyName = "methodName"
       ttContext.propertyValue = "FAAssetTypeFABookByType".
create ttContext.
assign ttContext.propertyName = "applicationId"
       ttContext.propertyValue = "fin".
create ttContext.
assign ttContext.propertyName = "entity"
       ttContext.propertyValue = "1000".
create ttContext.
assign ttContext.propertyName = "userName"
       ttContext.propertyValue = "mfg".
create ttContext.
assign ttContext.propertyName = "password"
       ttContext.propertyValue = "".

/* Create input dataset */
create dataset vhInputDS.
vhInputDS:read-xmlschema("file", "xml/bfixedassetassettype.faassettypefabookbytype.i.xsd", ?).
vhParameter = vhInputDS:get-buffer-handle("tParameterI").
vhParameter:buffer-create().

assign vhParameter::icRange = "A"
       vhParameter::icRowid = ""
       vhParameter::iiRownum = 0
       vhParameter::iiNumber = 5 /* Number of records to read */
       vhParameter::icSortColumns = ""
       vhParameter::ilCountOnly = false
       vhParameter::ilForwardRead = true
       vhParameter::iiMaximumBrowseRecordsToCount = 0.

vhParameter = vhInputDS:get-buffer-handle("tFilter").
vhParameter:buffer-create().

assign vhParameter::<field-name-1> = <field-value-1>
       vhParameter::<field-name-2> = <field-value-2>
       ...

/* Connect the AppServer */
create server vhServer.
vhServer:connect("-URL <appserver-url>").

if not vhServer:connected()
then do:
    message "Could not connect AppServer" view-as alert-box error title "Error".
    return.
end.

/* Run */
assign vhContextDS = dataset dsContext:handle.

run program/rpcrequestservice.p on vhServer
    (input-output dataset-handle vhContextDS by-reference,
           output dataset-handle vhExceptionDS,
     input        dataset-handle vhInputDS by-reference,
     input-output dataset-handle vhInputOutputDS by-reference,
           output dataset-handle vhOutputDS).

/* Handle output however you want, in this example, we dump it to xml */
if valid-handle(vhExceptionDS)
then vhExceptionDS:write-xml("file", "Exceptions.xml", true).

if valid-handle(vhOutputDS)
then vhOutputDS:write-xml("file", "Output.xml", true).

/* Cleanup */
vhServer:disconnect().
assign vhServer = ?.

if valid-handle(vhInputDS)
then delete object vhInputDS.

if valid-handle(vhOutputDS)
then delete object vhOutputDS.

if valid-handle(vhExceptionDS)
then delete object vhExceptionDS.