project QadFinancials > class BCOACrossRef > dataset tCOACrossRefResult

table tCOACrossRefResult

Description

temp-table to pass source COA values and retrieve target COA values.

field namedata typedescription
tcGLCodecharacter
tcDivisionCodecharacter
tcCostCentreCodecharacter
tcProjectCodecharacter
tiTargetGL_IDinteger
tcTargetGLCodecharacter
tiTargetDivision_IDinteger
tcTargetDivisionCodecharacter
tiTargetCostCentre_IDinteger
tcTargetCostCentreCodecharacter
tiTargetProject_IDinteger
tcTargetProjectCodecharacter
tiTargetAltCOAStructDet_IDinteger
tcTargetAltCOAStructDetCodecharacter
tlGLIsProjectAccountlogicalProject Analysis: This field will be calculated by the system based on the value of tcAnalysisType.
If the analysis type of the account is Project the value will be true.
api annotation:This field can be left blank as it will be calculated by the system.
tlGLIsDivisionAccountlogicalSet to true if the account has a sub-account.
Its value is calculated by the system and is determined by the value of tcDivisionProfileCode.
api annotation:This field can be left blank as it will be calculated by the system.
tlGLIsCostCentreAccountlogicalThis field will be calculated by the system based on the value of tcAnalysisType.

If the analysis type of the account is Project the value will be true.
api annotation:This field can be left blank as it will be calculated by the system.
tlGLIsSafAccountlogicalSAF Enabled: This field will be calculated by the system based on the value of tcAnalysisType.
If the analysis type of the account is Project the value will be true.
api annotation:This field can be left blank as it will be calculated by the system.
tlCostCentreIsWithSaflogicalSAF Enabled: This field indicates if the SAF analysis is enabled.
api annotation:This field can be left blank as it will be calculated by the system.
PartialUpdate = yes - defaults to false
tlProjectIsWithSaflogical
tcGLExchangeMethodcharacterThis field is filled If this account is used by a domain that is the target of a consolidation.
tcExchangeRateTypeCodecharacterA code identifying an exchange rate type. A number of types are predefined and required by the system.
tcAltCOAStructDetDescriptioncharacter
tcAltCOAStructDetSeqcharacter
tiAltCOAStruct_IDinteger


Internal usage


QadFinancials
method BCOACrossRef.GetCOACrossRef