dataset BFixedAssetRevaluation

class dataset

object identification

primary key
FAReval_ID
object identity
FAReval_ID

table tFAReval

field name	data type	mnd.	description
FAReval_ID	integer	yes	Record ID
FAAssetBook_ID	integer	yes	Link to FAAssetBook
FARevalSequence	integer	yes	Sequence
FARevalDate	date	yes	Revaluation Date
FARevalType	character(20)	yes	Revaluation Type
	value list:		{&FAREVALTYPES}
FARevalIndexType	character(20)	no	Index Revaluation Type
	value list:		{&FAREVALINDEXTYPES}
FARevalPercentage	decimal(3)	no	Revaluation Percentage
FARevalAmountLC	decimal(4)	yes	BC Revaluated Amount
FARevalAmountCC	decimal(4)	no	SC Revaluated Amount
tdFARevalNetBookLC	decimal(4)	no	BC Net Book
ttFARevalLastDate	date	no	Last Date
tcFAAssetBookCode	character(20)	yes	Asset Book Code
tiCompany_ID	integer	yes
tcFAAssetCode	character(20)	yes	Asset Code
tdFAAssetBookAmountCC	decimal(4)	yes	SC Amount
tdFAAssetBookAmountLC	decimal(4)	yes	BC Amount
tdFAAssetBookDeprAmountCC	decimal(4)	yes	SC Depreciation Amount
tdFAAssetBookDeprAmountLC	decimal(4)	yes	BC Depreciation Amount
tcFAAssetBookDepreciationType	character(20)	yes	Depreciation Type
tdFAAssetBookDisposedDeprLC	decimal(4)	yes	BC Disposed Depr
tdFAAssetBookDisposedLC	decimal(4)	yes	BC Disposed
ttFAAssetBookNextPostingDate	date	yes	Next Posting Date
tiFAAssetBookPeriodsDepr	integer	yes	Periods Depreciated
tdFAAssetBookSalvageAmountCC	decimal(4)	yes	SC Salvage Amount
tdFAAssetBookSalvageAmountLC	decimal(4)	yes	BC Salvage Amount
tcFABookTypeCode	character(20)	yes	Book Type
tcRevaluationJournalCode	character(8)	yes	Daybook Code
tlFABookTypeIsOfficial	logical	yes	Official
tiFAAsset_ID	integer	yes
CustomShort0	character(20)	no	Custom Short Field
CustomShort1	character(20)	no	Custom Short Field
CustomShort2	character(20)	no	Custom Short Field
CustomShort3	character(20)	no	Custom Short Field
CustomShort4	character(20)	no	Custom Short Field
CustomShort5	character(20)	no	Custom Short Field
CustomShort6	character(20)	no	Custom Short Field
CustomShort7	character(20)	no	Custom Short Field
CustomShort8	character(20)	no	Custom Short Field
CustomShort9	character(20)	no	Custom Short Field
CustomCombo0	character(20)	no	Custom Combo Field
CustomCombo1	character(20)	no	Custom Combo Field
CustomCombo2	character(20)	no	Custom Combo Field
CustomCombo3	character(20)	no	Custom Combo Field
CustomCombo4	character(20)	no	Custom Combo Field
CustomCombo5	character(20)	no	Custom Combo Field
CustomCombo6	character(20)	no	Custom Combo Field
CustomCombo7	character(20)	no	Custom Combo Field
CustomCombo8	character(20)	no	Custom Combo Field
CustomCombo9	character(20)	no	Custom Combo Field
CustomLong0	character(255)	no	Custom Long Field
CustomLong1	character(255)	no	Custom Long Field
CustomNote	character(2000)	no	Custom Note Field
CustomDate0	date	no	Custom Date Field
CustomDate1	date	no	Custom Date Field
CustomDate2	date	no	Custom Date Field
CustomDate3	date	no	Custom Date Field
CustomDate4	date	no	Custom Date Field
CustomInteger0	integer	no	Custom Integer Field
CustomInteger1	integer	no	Custom Integer Field
CustomInteger2	integer	no	Custom Integer Field
CustomInteger3	integer	no	Custom Integer Field
CustomInteger4	integer	no	Custom Integer Field
CustomDecimal0	decimal(4)	no	Custom Decimal Field
CustomDecimal1	decimal(4)	no	Custom Decimal Field
CustomDecimal2	decimal(4)	no	Custom Decimal Field
CustomDecimal3	decimal(4)	no	Custom Decimal Field
CustomDecimal4	decimal(4)	no	Custom Decimal Field
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	no	empty string
tc_Status	character	no	update status

table tFARevalDet

field name	data type	mnd.	description
FARevalDet_ID	integer	yes	Record ID
FAReval_ID	integer	yes	Link to FAReval
GL_ID	integer	yes	GL Account
Division_ID	integer	no	Sub-Account Code
CostCentre_ID	integer	no	Cost Center Code
Project_ID	integer	no	Project
FARevalDetAmountLC	decimal(4)	yes	BC Revaluated Amount
FARevalDetAmountCC	decimal(4)	no	SC Revaluated Amount
FARevalDetPostingText	character(40)	yes	Posting Description
tcGLCode	character(8)	yes	GL Account
tcDivisionCode	character(8)	no	Sub-Account Code
tcCostCentreCode	character(4)	no	Cost Center Code
tcProjectCode	character(8)	no	Project
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tFAReval.tc_Rowid
tc_Status	character	no	update status

table tFARevalDetSaf

field name	data type	mnd.	description
FARevalDetSaf_ID	integer	yes	Record ID
Saf_ID	integer	yes	SAF Code
SafStructure_ID	integer	yes	Structure Code
FARevalDet_ID	integer	yes	Link to FARevalDet
FARevalDetSafSequence	integer	yes	Sequence
FARevalDetSafParentType	character(20)	yes	SAF Parent Type
	value list:		{&POSTINGSAFPARENTTYPES}
tcSafCode	character(20)	yes	SAF Code
tcSafConceptCode	character(20)	yes	SAF Concept Code
tcSafStructureCode	character(20)	yes	Structure Code
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tFARevalDet.tc_Rowid
tc_Status	character	no	update status

table tFARevalPosting

field name	data type	mnd.	description
FARevalPosting_ID	integer	yes	Record ID
FAReval_ID	integer	yes	Link to FAReval
Posting_ID	integer	yes	Voucher
FARevalPostingType	character(20)	yes	Posting Type
	value list:		{&FAREVALTYPES}
tiPostingVoucher	integer	yes	Voucher
tcJournalCode	character(8)	yes	Daybook Code
tiPeriodYear	integer	yes	GL Calendar Year
tiPeriodPeriod	integer	yes	GL Period
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tFAReval.tc_Rowid
tc_Status	character	no	update status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character