| iiCompanyId | integer | Company id |
| itFromCreationDate | date | |
| itTillCreationDate | date | |
| iiFromCreationTime | integer | |
| iiTillCreationTime | integer | |
| icUser | character | |
| idFromAmount | decimal | |
| idTillAmount | decimal | |
| icPaySelCodeList | character | |
| ilIsExecuted | logical | |
| ilIsAutomatic | logical | |
| icGLCode | character |
each CCollection where
each CDocument (conditional-join) where
first Creditor (outer-join) where
first BusinessRelation (outer-join) where
first Currency1 (outer-join) where
first GL1 (outer-join) where
first GL2 (inner-join) where
first Currency2 (conditional-join) where
first Usr (conditional-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tcBankCurrency | character | Currency2.CurrencyCode | Currency Code |
| tiBusinessRelation_ID | integer | Creditor.BusinessRelation_ID | Name |
| tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
| tcBusinessRelationName1 | character | BusinessRelation.BusinessRelationName1 | Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers. |
| api annotation: | PartialUpdate = yes - defaults to the BusinessRelationCode. | ||
| tcBusinessRelationName2 | character | BusinessRelation.BusinessRelationName2 | Second Name. An extended name when the Name field is not large enough to contain all information. This fielsd can be blank. |
| tdCCollectionBalanceCreditLC | decimal | CCollection.CCollectionBalanceCreditLC | BC Credit Balance |
| tdCCollectionBalanceDebitLC | decimal | CCollection.CCollectionBalanceDebitLC | BC Debit Balance |
| tdCCollectionBalanceLC | decimal | CCollection.CCollectionBalanceLC | BC Balance |
| tdCCollectionBalanceTC | decimal | CCollection.CCollectionBalanceTC | TC Balance |
| ttCCollectionCreationDate | date | CCollection.CCollectionCreationDate | Creation Date |
| tiCCollectionCreationTime | integer | CCollection.CCollectionCreationTime | Creation Time |
| tiCCollectionGL_ID | integer | GL2.GL_ID | Record ID |
| tlCCollectionIsAutomatic | logical | CCollection.CCollectionIsAutomatic | Automatic |
| tlCCollectionIsExecuted | logical | CCollection.CCollectionIsExecuted | Executed |
| tiCCollectionNumber | integer | CCollection.CCollectionNumber | Number |
| tcCCollectionPaySelCodeList | character | CCollection.CCollectionPaySelCodeList | Payment Selection List |
| tcCCollectionReference | character | CCollection.CCollectionReference | Reference |
| tiCCollectionYear | integer | CCollection.CCollectionYear | Year |
| tcCDocGLCode | character | GL1.GLCode | A code identifying the GL account. |
| tdCDocumentBankChargeAmountCC | decimal | CDocument.CDocumentBankChargeAmountCC | SC Bank Charge Amt |
| tdCDocumentBankChargeAmountLC | decimal | CDocument.CDocumentBankChargeAmountLC | BC Bank Charge Amt |
| tdCDocumentBankChargeAmountTC | decimal | CDocument.CDocumentBankChargeAmountTC | TC Bank Charge Amt |
| tdCDocumentBankChargeTaxAmountCC | decimal | CDocument.CDocumentBankChargeTaxAmountCC | SC Bank Charge Tax |
| tdCDocumentBankChargeTaxAmountLC | decimal | CDocument.CDocumentBankChargeTaxAmountLC | BC Bank Charge Tax |
| tdCDocumentBankChargeTaxAmountTC | decimal | CDocument.CDocumentBankChargeTaxAmountTC | TC Bank Charge Tax |
| ttCDocumentCreationDate | date | CDocument.CDocumentCreationDate | Creation Date.This field indicate the payment creation date. This field is read-only. |
| ttCDocumentDueDate | date | CDocument.CDocumentDueDate | Due Date. The due date for this payment. |
| ttCDocumentLastPrintDate | date | CDocument.CDocumentLastPrintDate | Last Printed Date. This field indicates the most recent printing date. |
| tiCDocumentNumber | integer | CDocument.CDocumentNumber | Document Number. This field hold a unified number for report use. |
| tdCDocumentOriginalCreditLC | decimal | CDocument.CDocumentOriginalCreditLC | BC Original Credit.This field holds the amount of the Payment in baisc currency. |
| tdCDocumentOriginalCreditTC | decimal | CDocument.CDocumentOriginalCreditTC | Amount.This field hold the value of the payment in the transaction currency. This field must be positive and can be entered manually or automatically by linking the payment to an open item. |
| tdCDocumentOriginalDebitLC | decimal | CDocument.CDocumentOriginalDebitLC | TC Original Debit. This field holds the debit value of the payment in base currency. |
| tdCDocumentOriginalDebitTC | decimal | CDocument.CDocumentOriginalDebitTC | TC Original Debit. This field holds the debit value of the payment in transaction currency. |
| tcCDocumentReference | character | CDocument.CDocumentReference | Reference. Reference text for the payment. |
| tcCDocumentStatus | character | CDocument.CDocumentStatus | Status. The payment status. The default value for a new record is Initial. |
| tiCDocumentTimesPrinted | integer | CDocument.CDocumentTimesPrinted | Times Printed.This field indicates the number of times the payment has been printed. This field is read-only. |
| tcCDocumentType | character | CDocument.CDocumentType | Payment Instrument.This field displays the payment instrument associated with the payment format linked to the supplier bank. |
| tiCDocumentValueDays | integer | CDocument.CDocumentValueDays | Value Days. The number of days required by the bank to process the transaction. The default is based on the CDocumentStatus. |
| tiCDocumentYear | integer | CDocument.CDocumentYear | Year/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year. |
| tiCompany_ID | integer | CCollection.Company_ID | Link to Company |
| tiCreationUsr_ID | integer | CCollection.CreationUsr_ID | Link to Usr |
| tiCreditor_ID | integer | CDocument.Creditor_ID | Supplier |
| tiCreditor_ID2 | integer | Creditor.Creditor_ID | Record ID |
| tcCreditorCode | character | Creditor.CreditorCode | Supplier Code |
| tiCurrency_ID | integer | Currency1.Currency_ID | Record ID |
| tiCurrency_ID1 | integer | Currency2.Currency_ID | Record ID |
| tcCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
| tcCurrencyDescription | character | Currency1.CurrencyDescription | Currency Description |
| tcCurrencyDescription2 | character | Currency2.CurrencyDescription | Currency Description |
| tiCurrencyNumberOfDecimals | integer | Currency2.CurrencyNumberOfDecimals | Number of Decimals |
| tiGL_ID | integer | GL1.GL_ID | Record ID |
| tcGLCode | character | GL2.GLCode | A code identifying the GL account. |
| tcGLDescription | character | GL1.GLDescription | A description of the GL account. |
| tcGLDescription2 | character | GL2.GLDescription | A description of the GL account. |
| ttLastModifiedDate | date | CCollection.LastModifiedDate | Last Modified Date |
| tcLastModifiedUser | character | CCollection.LastModifiedUser | Last Modified User |
| tcUsrName | character | Usr.UsrName | User Name |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(CCollection),rowid(CDocument),rowid(Creditor),rowid(BusinessRelation),rowid(Currency1),rowid(GL1),rowid(GL2),rowid(Currency2),rowid(Usr) |
QadFinancials