dataset BYearClosing

class dataset

object identification

primary key
YearClosing_ID
object identity
YearClosing_ID

table tYearClosing

field name	data type	mnd.	description
YearClosing_ID	integer	yes	Record ID
Company_ID	integer	yes	Link to Company
Layer_ID	integer	yes	Link to Layer
ClosingPLGL_ID	integer	no	Profit/Loss Closing Account
ClosingBalanceGL_ID	integer	no	Balance Sheet Closing Account
ClosingPLDivGL_ID	integer	no	Profit/Loss Closing Sub-Account
ClosingBalanceDivGL_ID	integer	no	Balance Sheet Closing Sub-Account
ClosingTransferJournal_ID	integer	no	Automated Profit/Loss Transfer Daybook
ClosingPLJournal_ID	integer	yes	Closing Profit/Loss Daybook
ClosingBalanceJournal_ID	integer	yes	Closing Balance Daybook
YearClosingAccountingYear	integer	yes	GL Calendar Year
YearClosingIsTransPLToBal	logical	yes	Auto-Transfer Profit/Loss to BS
YearClosingIsInclDivision	logical	yes	Include Sub-Accounts
YearClosingDefTaxCode	character(8)	yes	Default Tax Code
YearClosingCloAddGLNbrDate	date	no	Closing Numbering Date
YearClosingTrnAddGLNbrDate	date	no	Transfer Numbering Date
YearClosingReoAddGLNbrDate	date	no	Reopen Numbering Date
tcClosingPLGLCode	character(8)	no	Profit/Loss Closing Account
tcClosingBalanceGLCode	character(8)	no	Balance Sheet Closing Account
tcClosingPLDivGLCode	character(8)	no	Profit/Loss Closing Sub-Account
tcClosingBalanceDivGLCode	character(8)	no	Balance Sheet Closing Sub-Account
tcClosingTransferJournalCode	character(8)	no	Automated Profit/Loss Transfer Daybook
tcClosingPLJournalCode	character(8)	yes	Closing Profit/Loss Daybook
tcClosingBalanceJournalCode	character(8)	yes	Closing Balance Daybook
tcLayerCode	character(20)	yes
tcLayerDescription	character(40)	yes
tlYearClosingIsDivAccounts	logical	no	true = only Division accounts exist false = no Division accounts exist ? = both Division and non-division accounts exist.
tlCompanyPropertyIsAddGLNbr	logical	no
tlLayerIsAddGLNbr	logical	no	Does selected layer requires additional numbering
tcLayerTypeCode	character(20)	no
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 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