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 | |