project QadFinancials > class BExpenseNote > dataset tExpNoteLineRef


copy of class table tExpNoteLine

table tExpNoteLineRef


field namedata typedescription
ExpNoteLine_IDinteger
ExpNote_IDinteger
Currency_IDinteger
Unit_IDinteger
Project_IDinteger
BudgetWBS_IDinteger
CostCentre_IDinteger
GL_IDinteger
Division_IDinteger
ExpNoteLineSequenceinteger
ExpNoteLineDatedate
ExpNoteLineDescriptioncharacter
ExpNoteLineTypecharacter
ExpNoteLineLCRatedecimal(10)
ExpNoteLineLCScaledecimal(10)
ExpNoteLineCCRatedecimal(10)
ExpNoteLineCCScaledecimal(10)
ExpNoteLineAmountTCdecimal(4)
ExpNoteLineAmountLCdecimal(4)
ExpNoteLineAmountCCdecimal(4)
ExpNoteLineAmountXCdecimal(4)
ExpNoteLineUnitPricedecimal(10)
ExpNoteLineQTYdecimal(10)
ExpNoteLineBaseQTYdecimal(10)
ExpNoteLineIsProvenRatelogical
ObsoleteItem_IDinteger
ExpNoteLineClaimedLCdecimal(4)
ExpNoteLineClaimedXCdecimal(4)
ExpNoteLineToPayLCdecimal(4)
ExpNoteLineToPayTCdecimal(4)
ExpNoteLineToPayXCdecimal(4)
tcGLCodecharacter
tcUnitCodecharacter
tcDivisionCodecharacter
tcProjectCodecharacter
tcCurrencyCodecharacter
tcBudgetWBSCodecharacter
tcCostCentreCodecharacter
tcSAFConcept1character
tcSAFConcept2character
tcSAFConcept3character
tcSAFConcept4character
tcSAFConcept5character
tcSAFCode1character
tcSAFCode2character
tcSAFCode3character
tcSAFCode4character
tcSAFCode5character
tcItemDescriptioncharacter
tlItemIsUnitBasedEntrylogicalItemIsUnitBasedEntry
tcSafStructureCodecharacter
tlGLIsDivisionAccountlogical
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BExpenseNote.GetProposedAdvanceLink