| field name | data type | mnd. | description |
|---|---|---|---|
| ExpNote_ID | integer | yes | Record ID |
| Employee_ID | integer | yes | Employee Code |
| Company_ID | integer | yes | Link to Company |
| Currency_ID | integer | yes | Currency Code |
| ExpNoteYear | integer | yes | Year |
| ExpNoteNumber | integer | yes | Number |
| ExpNoteStatusCode | character(20) | yes | Status |
| value list: | {&EXPENSENOTESTATUSS} | ||
| ExpNoteConfirmationDate | date | no | Confirmation Date |
| ExpNoteRegistrationDate | date | no | Registration Date |
| ExpNoteDescription | character(40) | no | Description |
| ExpNoteRateLCXC | decimal(10) | no | BC xc Exchange Rate |
| ExpNoteRateScale | decimal(10) | no | Scale Factor |
| ExpNoteCCRate | decimal(10) | no | SC Rate |
| ExpNoteCCScale | decimal(10) | no | SC Rate Scale |
| ConfirmationUsr_ID | integer | no | Link to Usr |
| RegistrationUsr_ID | integer | no | Link to Usr |
| ReportPeriod_ID | integer | no | Link to ReportPeriod |
| tcCurrencyCode | character(3) | yes | Currency Code |
| tcEmployeeCode | character(8) | yes | Employee Code |
| tcConfirmationUsrName | character(40) | no | User Name |
| tcRegistrationUsrName | character(40) | no | User Name |
| tlIsSelected | logical | no | Selected |
| tcCreditorCode | character(20) | no | Supplier Code |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| 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 |
| field name | data type | mnd. | description |
|---|---|---|---|
| ExpNoteCInvoice_ID | integer | yes | Record ID |
| ExpNote_ID | integer | yes | Link to ExpNote |
| CInvoice_ID | integer | yes | Link to CInvoice |
| ExpNoteCInvoiceTypeCode | character(20) | yes | Type Code |
| ExpNoteCInvoiceDeductTC | decimal(4) | no | TC Deductible |
| ExpNoteCInvoiceDeductLC | decimal(4) | no | BC Deductible |
| ExpNoteCInvoiceToReturnTC | decimal(4) | no | TC To Return |
| ExpNoteCInvoiceStatusCode | character(20) | yes | Status Code |
| ExpNoteCInvoiceIsReturned | logical | yes | Is Returned |
| 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 | yes | = tExpNote.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| ExpNoteLine_ID | integer | yes | Record ID |
| ExpNote_ID | integer | yes | Link to ExpNote |
| Currency_ID | integer | yes | Currency Code |
| Unit_ID | integer | yes | GL Account Unit of Measure |
| Project_ID | integer | no | Project |
| BudgetWBS_ID | integer | no | WBS Code |
| CostCentre_ID | integer | no | Cost Center Code |
| GL_ID | integer | yes | GL Account |
| Division_ID | integer | no | Sub-Account Code |
| ExpNoteLineSequence | integer | yes | Sequence |
| ExpNoteLineDate | date | no | Date |
| ExpNoteLineDescription | character(40) | no | Description |
| ExpNoteLineType | character(20) | yes | Type |
| value list: | {&EXPENSENOTELINETYPES} | ||
| ExpNoteLineLCRate | decimal(10) | no | BC Rate |
| ExpNoteLineLCScale | decimal(10) | no | BC Rate Scale |
| ExpNoteLineCCRate | decimal(10) | no | SC Rate |
| ExpNoteLineCCScale | decimal(10) | no | SC Rate Scale |
| ExpNoteLineAmountTC | decimal(4) | no | TC Amount |
| ExpNoteLineAmountLC | decimal(4) | no | BC Amount |
| ExpNoteLineAmountCC | decimal(4) | no | SC Amount |
| ExpNoteLineAmountXC | decimal(4) | no | PC Amount |
| ExpNoteLineUnitPrice | decimal(10) | no | Unit Price |
| ExpNoteLineQTY | decimal(10) | no | Qty |
| ExpNoteLineBaseQTY | decimal(10) | no | Base Qty |
| ExpNoteLineIsProvenRate | logical | no | Proven Rate |
| ObsoleteItem_ID | integer | no | Link to Item |
| ExpNoteLineClaimedLC | decimal(4) | no | BC Claimed Amount |
| ExpNoteLineClaimedXC | decimal(4) | no | PC Claimed Amount |
| ExpNoteLineToPayLC | decimal(4) | no | BC Payment Amount |
| ExpNoteLineToPayTC | decimal(4) | no | TC Payment Amount |
| ExpNoteLineToPayXC | decimal(4) | no | PC Payment Amount |
| tcGLCode | character(8) | yes | GL Account |
| tcUnitCode | character(20) | yes | GL Account Unit of Measure |
| tcDivisionCode | character(8) | no | Sub-Account Code |
| tcProjectCode | character(8) | no | Project |
| tcCurrencyCode | character(3) | yes | Currency Code |
| tcBudgetWBSCode | character(40) | no | WBS Code |
| tcCostCentreCode | character(4) | no | Cost Center Code |
| tcSAFConcept1 | character(20) | no | SAF Concept 1 |
| tcSAFConcept2 | character(20) | no | SAF Concept 2 |
| tcSAFConcept3 | character(20) | no | SAF Concept 3 |
| tcSAFConcept4 | character(20) | no | SAF Concept 4 |
| tcSAFConcept5 | character(20) | no | SAF Concept 5 |
| tcSAFCode1 | character(20) | no | SAF Code 1 |
| tcSAFCode2 | character(20) | no | SAF Code 2 |
| tcSAFCode3 | character(20) | no | SAF Code 3 |
| tcSAFCode4 | character(20) | no | SAF Code 4 |
| tcSAFCode5 | character(20) | no | SAF Code 5 |
| tcItemDescription | character(40) | no | Item Description |
| tlItemIsUnitBasedEntry | logical | no | ItemIsUnitBasedEntry |
| tcSafStructureCode | character(20) | no | SAF Structure Code |
| tlGLIsDivisionAccount | logical | no | GL is a Sub-Account |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| 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 | yes | = tExpNote.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| ExpNoteLineSaf_ID | integer | yes | Record ID |
| Saf_ID | integer | yes | Link to Saf |
| ExpNoteLine_ID | integer | yes | Link to ExpNoteLine |
| SafStructure_ID | integer | yes | Link to SafStructure |
| ExpNoteLineSafParentType | character(20) | yes | Parent Type |
| ExpNoteLineSafInputSeq | integer | yes | Sequence |
| 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 | yes | = tExpNoteLine.tc_Rowid |
| tc_Status | character | no | update status |
| 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 |
| 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 |
| 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 |