project QadFinancials > class BJournal > business logic query JournalForSharedSetMergeVal


Parameters


iiCompanyIdintegerCompany id
iiSharedSetIdinteger


query condition


  each Journal where
Journal.SharedSet_Id = iiSharedSetId

      first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND


query sort order


Journal.JournalCode (ascending)


query resultset tqJournalForSharedSetMergeVal


field namedata typedb fielddescription
tcCustomCombo0characterJournal.CustomCombo0Custom Combo Field
tcCustomCombo1characterJournal.CustomCombo1Custom Combo Field
tcCustomCombo2characterJournal.CustomCombo2Custom Combo Field
tcCustomCombo3characterJournal.CustomCombo3Custom Combo Field
tcCustomCombo4characterJournal.CustomCombo4Custom Combo Field
tcCustomCombo5characterJournal.CustomCombo5Custom Combo Field
tcCustomCombo6characterJournal.CustomCombo6Custom Combo Field
tcCustomCombo7characterJournal.CustomCombo7Custom Combo Field
tcCustomCombo8characterJournal.CustomCombo8Custom Combo Field
tcCustomCombo9characterJournal.CustomCombo9Custom Combo Field
ttCustomDate0dateJournal.CustomDate0Custom Date Field
ttCustomDate1dateJournal.CustomDate1Custom Date Field
ttCustomDate2dateJournal.CustomDate2Custom Date Field
ttCustomDate3dateJournal.CustomDate3Custom Date Field
ttCustomDate4dateJournal.CustomDate4Custom Date Field
tdCustomDecimal0decimalJournal.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalJournal.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalJournal.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalJournal.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalJournal.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerJournal.CustomInteger0Custom Integer Field
tiCustomInteger1integerJournal.CustomInteger1Custom Integer Field
tiCustomInteger2integerJournal.CustomInteger2Custom Integer Field
tiCustomInteger3integerJournal.CustomInteger3Custom Integer Field
tiCustomInteger4integerJournal.CustomInteger4Custom Integer Field
tcCustomLong0characterJournal.CustomLong0Custom Long Field
tcCustomLong1characterJournal.CustomLong1Custom Long Field
tcCustomNotecharacterJournal.CustomNoteCustom Note Field
tcCustomShort0characterJournal.CustomShort0Custom Short Field
tcCustomShort1characterJournal.CustomShort1Custom Short Field
tcCustomShort2characterJournal.CustomShort2Custom Short Field
tcCustomShort3characterJournal.CustomShort3Custom Short Field
tcCustomShort4characterJournal.CustomShort4Custom Short Field
tcCustomShort5characterJournal.CustomShort5Custom Short Field
tcCustomShort6characterJournal.CustomShort6Custom Short Field
tcCustomShort7characterJournal.CustomShort7Custom Short Field
tcCustomShort8characterJournal.CustomShort8Custom Short Field
tcCustomShort9characterJournal.CustomShort9Custom Short Field
tiJournal_IDintegerJournal.Journal_IDRecord ID
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcJournalControlcharacterJournal.JournalControlA type of daybook control: Financial/Operational/External-used to clearly separate postings based on their source.
tlJournalIsActivelogicalJournal.JournalIsActiveIndicate if this is an active daybook.
api annotation:Value for this field defaults to false.
tlJournalIsProjectProvisionlogicalJournal.JournalIsProjectProvisionProject Provision
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tcLayerCodecharacterLayer.LayerCodeLayer Code
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BSharedSetMerge.MergeValidateLoadSharedSetData