| field name | data type | description |
|---|
| BankStateAllocColl_ID | integer | |
| Company_ID | integer | |
| BankStateAlloc_ID | integer | |
| CDocument_ID | integer | |
| DDocument_ID | integer | |
| BankState_ID | integer | |
| BankStateAllocCollIsAlloc | logical | |
| BankStateAllocCollBankAmTC | decimal(4) | |
| BankStateAllocCollBankAmLC | decimal(4) | |
| BankStateAllocCollBankRate | decimal(10) | |
| BankStateAllocCollRteScale | decimal(10) | |
| BankStateAllocCollCCRate | decimal(10) | |
| BankStateAllocCollCCScale | decimal(10) | |
| BankStateAllocCollDiffLC | decimal(4) | |
| BankStateAllocCollDiffTC | decimal(4) | |
| BankStateAllocCollDiffCC | decimal(4) | |
| BankStateAllocCollBankDate | date | |
| tcDocCurrencyCode | character | |
| tcDocBusinessRelationCode | character | |
| tcDocNumberReference | character | |
| tcDocType | character | |
| tdDocAmount | decimal(4) | |
| tcDocName | character | Document name |
| tcDocAmountCrDt | character | Sign of new balance nl debit or credit |
| tcCDocumentType | character | |
| tiCDocumentNumber | integer | |
| tcDDocumentType | character | |
| tiDDocumentNumber | integer | |
| tiCDocumentYear | integer | |
| tiDDocumentYear | integer | |
| tdDocExchangeRate | decimal(10) | Document Exchange Rate |
| tcCurrDifferenceCrDt | character | sign of currency difference : debit or credit |
| tcCurrencyDifferenceGLCode | character | Gl code for the currency difference |
| tlDocIsBounced | logical | Is the document bounced or not ? |
| tdDocExchangeRateScale | decimal(10) | |
| tdDocAmountBC | decimal(4) | |
| tiCDocumentPrePrintedNumber | integer | |
| tdRunningAllocBalanceTC | decimal(4) | |
| tdDocCCExchangeRate | decimal(10) | |
| tdDocCCExchangeRateScale | decimal(10) | |
| tcCCCurrencyDifferenceGLCode | character | |
| tcCCCurrDifferenceCrDt | character | |
| 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