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 |
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 |
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 |
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 |
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 |
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 |
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 |