dataset BDeductionCat

class dataset

object identification

primary key
DeductionCat_ID
alternate key
DeductionCatCode
object identity
DeductionCat_ID

table tDeductionCat

Annotation

<QUERYTYPE=Application Table - Master Data>

Description

field name	data type	mnd.	description
DeductionCat_ID	integer	yes	Record ID
PendingDeductionReason_ID	integer	no	Link to PendingDeductionReason
ApprovedDeductionReason_ID	integer	no	Link to ApprovedDeductionReason
RejectedDeductionReason_ID	integer	no	Link to RejectedDeductionReason
Role_ID	integer	no	Link to Role
DeductionCatCode	character(20)	yes	Deduction Category Code
DeductionCatDescription	character(40)	no	Description
DeductionCatType	character(20)	yes	Type
	value list:		{&DEDUCTIONCATTYPES}
DeductionCatIsActive	logical	yes	Active
DeductionCatIsAllowCredit	logical	yes	Approve Credit
DeductionCatIsAllowWriteOff	logical	yes	Approve Write-off
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
CustomShort0	character(20)	no
CustomShort1	character(20)	no
CustomShort2	character(20)	no
CustomShort3	character(20)	no
CustomShort4	character(20)	no
CustomShort5	character(20)	no
CustomShort6	character(20)	no
CustomShort7	character(20)	no
CustomShort8	character(20)	no
CustomShort9	character(20)	no
CustomCombo0	character(20)	no
CustomCombo1	character(20)	no
CustomCombo2	character(20)	no
CustomCombo3	character(20)	no
CustomCombo4	character(20)	no
CustomCombo5	character(20)	no
CustomCombo6	character(20)	no
CustomCombo7	character(20)	no
CustomCombo8	character(20)	no
CustomCombo9	character(20)	no
CustomLong0	character(255)	no
CustomLong1	character(255)	no
CustomNote	character(2000)	no
CustomDate0	date	no
CustomDate1	date	no
CustomDate2	date	no
CustomDate3	date	no
CustomDate4	date	no
CustomInteger0	integer	no
CustomInteger1	integer	no
CustomInteger2	integer	no
CustomInteger3	integer	no
CustomInteger4	integer	no
CustomDecimal0	decimal(4)	no
CustomDecimal1	decimal(4)	no
CustomDecimal2	decimal(4)	no
CustomDecimal3	decimal(4)	no
CustomDecimal4	decimal(4)	no
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 tDeductionCatLine

Annotation

<QUERYTYPE=Application Table - Master Data>

field name	data type	mnd.	description
DeductionCatLine_ID	integer	yes	Record ID
DeductionCat_ID	integer	yes	Link to DeductionCat
Domain_ID	integer	yes	Link to Doamin
WriteOffCompany_ID	integer	no	Link to WriteOff Company
GL_ID	integer	no	Link to GL
Division_ID	integer	no	Link to Division
CostCentre_ID	integer	no	Link to CostCentre
SafStructure_ID	integer	no	Link to SafStructure
ExpenseJournal_ID	integer	yes	Link to ExpenseJournal
RechargeJournal_ID	integer	no	Link to RechargeJournal
DeductionCatLineIsAutoWOff	logical	yes	Auto Write-off
DeductionCatLineWOffLimit	decimal(4)	yes	Write-off Limit
tcGLCode	character(8)	no
tcCostCentreCode	character(4)	no
tcDivisionCode	character(8)	no
tcRechargeJournalCode	character(8)	no
tcExpenseJournalCode	character(8)	yes
tcBaseCurrencyCode	character	no
tcCalcDomainCode	character(8)	yes
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
CustomShort0	character(20)	no
CustomShort1	character(20)	no
CustomShort2	character(20)	no
CustomShort3	character(20)	no
CustomShort4	character(20)	no
CustomShort5	character(20)	no
CustomShort6	character(20)	no
CustomShort7	character(20)	no
CustomShort8	character(20)	no
CustomShort9	character(20)	no
CustomCombo0	character(20)	no
CustomCombo1	character(20)	no
CustomCombo2	character(20)	no
CustomCombo3	character(20)	no
CustomCombo4	character(20)	no
CustomCombo5	character(20)	no
CustomCombo6	character(20)	no
CustomCombo7	character(20)	no
CustomCombo8	character(20)	no
CustomCombo9	character(20)	no
CustomLong0	character(255)	no
CustomLong1	character(255)	no
CustomNote	character(2000)	no
CustomDate0	date	no
CustomDate1	date	no
CustomDate2	date	no
CustomDate3	date	no
CustomDate4	date	no
CustomInteger0	integer	no
CustomInteger1	integer	no
CustomInteger2	integer	no
CustomInteger3	integer	no
CustomInteger4	integer	no
CustomDecimal0	decimal(4)	no
CustomDecimal1	decimal(4)	no
CustomDecimal2	decimal(4)	no
CustomDecimal3	decimal(4)	no
CustomDecimal4	decimal(4)	no
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	= tDeductionCat.tc_Rowid
tc_Status	character	no	update status

table tDeductionCatLineSaf

Annotation

<QUERYTYPE=Application Table - Master Data>

Description

field name	data type	mnd.	description
DeductionCatLineSaf_ID	integer	yes	Record ID
DeductionCatLine_ID	integer	yes	Link to DeductionCatLine
Saf_ID	integer	yes	Link to Saf
tcSafCode	character(20)	yes
tcSafConceptCode	character(20)	yes
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
CustomShort0	character(20)	no
CustomShort1	character(20)	no
CustomShort2	character(20)	no
CustomShort3	character(20)	no
CustomShort4	character(20)	no
CustomShort5	character(20)	no
CustomShort6	character(20)	no
CustomShort7	character(20)	no
CustomShort8	character(20)	no
CustomShort9	character(20)	no
CustomCombo0	character(20)	no
CustomCombo1	character(20)	no
CustomCombo2	character(20)	no
CustomCombo3	character(20)	no
CustomCombo4	character(20)	no
CustomCombo5	character(20)	no
CustomCombo6	character(20)	no
CustomCombo7	character(20)	no
CustomCombo8	character(20)	no
CustomCombo9	character(20)	no
CustomLong0	character(255)	no
CustomLong1	character(255)	no
CustomNote	character(2000)	no
CustomDate0	date	no
CustomDate1	date	no
CustomDate2	date	no
CustomDate3	date	no
CustomDate4	date	no
CustomInteger0	integer	no
CustomInteger1	integer	no
CustomInteger2	integer	no
CustomInteger3	integer	no
CustomInteger4	integer	no
CustomDecimal0	decimal(4)	no
CustomDecimal1	decimal(4)	no
CustomDecimal2	decimal(4)	no
CustomDecimal3	decimal(4)	no
CustomDecimal4	decimal(4)	no
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	= tDeductionCatLine.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