| field name | data type | description |
|---|
| ExpNoteLine_ID | integer | |
| ExpNote_ID | integer | |
| Currency_ID | integer | |
| Unit_ID | integer | |
| Project_ID | integer | |
| BudgetWBS_ID | integer | |
| CostCentre_ID | integer | |
| GL_ID | integer | |
| Division_ID | integer | |
| ExpNoteLineSequence | integer | |
| ExpNoteLineDate | date | |
| ExpNoteLineDescription | character | |
| ExpNoteLineType | character | |
| ExpNoteLineLCRate | decimal(10) | |
| ExpNoteLineLCScale | decimal(10) | |
| ExpNoteLineCCRate | decimal(10) | |
| ExpNoteLineCCScale | decimal(10) | |
| ExpNoteLineAmountTC | decimal(4) | |
| ExpNoteLineAmountLC | decimal(4) | |
| ExpNoteLineAmountCC | decimal(4) | |
| ExpNoteLineAmountXC | decimal(4) | |
| ExpNoteLineUnitPrice | decimal(10) | |
| ExpNoteLineQTY | decimal(10) | |
| ExpNoteLineBaseQTY | decimal(10) | |
| ExpNoteLineIsProvenRate | logical | |
| ObsoleteItem_ID | integer | |
| ExpNoteLineClaimedLC | decimal(4) | |
| ExpNoteLineClaimedXC | decimal(4) | |
| ExpNoteLineToPayLC | decimal(4) | |
| ExpNoteLineToPayTC | decimal(4) | |
| ExpNoteLineToPayXC | decimal(4) | |
| tcGLCode | character | |
| tcUnitCode | character | |
| tcDivisionCode | character | |
| tcProjectCode | character | |
| tcCurrencyCode | character | |
| tcBudgetWBSCode | character | |
| tcCostCentreCode | character | |
| tcSAFConcept1 | character | |
| tcSAFConcept2 | character | |
| tcSAFConcept3 | character | |
| tcSAFConcept4 | character | |
| tcSAFConcept5 | character | |
| tcSAFCode1 | character | |
| tcSAFCode2 | character | |
| tcSAFCode3 | character | |
| tcSAFCode4 | character | |
| tcSAFCode5 | character | |
| tcItemDescription | character | |
| tlItemIsUnitBasedEntry | logical | ItemIsUnitBasedEntry |
| tcSafStructureCode | character | |
| tlGLIsDivisionAccount | logical | |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character | |
QadFinancials