| tcBusinessFieldName | tcDataType | tcOperator |
|---|---|---|
| iiCompanyId | i | |
| iiDocumentYear | i | = |
| iiFromDocumentNumber | i | >= |
| iiToDocumentNumber | i | <= |
| icDocumentType | c | = |
| icDocumentStatus | c | = |
| icDebtorCode | c | = |
| icDocumentReference | c | begins |
| ilDocumentIsOpen | l | = |
| itFromDueDate | t | >= |
| itToDueDate | t | <= |
| icCollectionNumber | c | = |
| icCurrencyCode | c | = |
| icDocumentSubType | c | = |
| iiTimesPrinted | i | < |
| itFromCreationDate | t | >= |
| itTillCreationDate | t | <= |
| iiFromCreationTime | i | >= |
| iiTillCreationTime | i | <= |
| icUserName | c | = |
| icIncSelCode | c | = |
| tBusinessRelation.BusinessRelationName1 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tBusinessRelation.BusinessRelationName2 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tCurrency.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tDCollection.DCollectionName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tDDocument.DDocumentCreationDate | t | =,>=,>,<>,<=,< |
| tDDocument.DDocumentDueDate | t | =,>=,>,<>,<=,< |
| tDDocument.DDocumentIsOpen | l | =,<> |
| tDDocument.DDocumentLastPrintDate | t | =,>=,>,<>,<=,< |
| tDDocument.DDocumentNumber | i | =,>=,>,<>,<=,< |
| tDDocument.DDocumentOriginalCreditCC | d | =,>=,>,<>,<=,< |
| tDDocument.DDocumentOriginalCreditLC | d | =,>=,>,<>,<=,< |
| tDDocument.DDocumentOriginalCreditTC | d | =,>=,>,<>,<=,< |
| tDDocument.DDocumentOriginalDebitCC | d | =,>=,>,<>,<=,< |
| tDDocument.DDocumentOriginalDebitLC | d | =,>=,>,<>,<=,< |
| tDDocument.DDocumentOriginalDebitTC | d | =,>=,>,<>,<=,< |
| tDDocument.DDocumentReference | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tDDocument.DDocumentStatus | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tDDocument.DDocumentSubType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tDDocument.DDocumentTimesPrinted | i | =,>=,>,<>,<=,< |
| tDDocument.DDocumentType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tDDocument.DDocumentValueDays | i | =,>=,>,<>,<=,< |
| tDDocument.DDocumentYear | i | =,>=,>,<>,<=,< |
| tLng.LngCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tLng.LngDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tUsr.UsrName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| iiCompanyId | integer | Company id |
| iiDocumentYear | integer | |
| iiFromDocumentNumber | integer | |
| iiToDocumentNumber | integer | |
| icDocumentType | character | |
| icDocumentStatus | character | |
| icDebtorCode | character | |
| icDocumentReference | character | |
| ilDocumentIsOpen | logical | |
| itFromDueDate | date | |
| itToDueDate | date | |
| icCollectionNumber | character | |
| icCurrencyCode | character | |
| icDocumentSubType | character | |
| iiTimesPrinted | integer | |
| itFromCreationDate | date | |
| itTillCreationDate | date | |
| iiFromCreationTime | integer | |
| iiTillCreationTime | integer | |
| icUserName | character | |
| icIncSelCode | character |
each DDocument where
first Currency (inner-join) where
first DCollection (conditional-join) where
first Debtor (inner-join) where
first BusinessRelation (inner-join) where
first Lng (inner-join) where
first Usr (conditional-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiBankNumber_ID | integer | DDocument.BankNumber_ID | Link to BankNumber |
| tiBusinessRelation_ID | integer | Debtor.BusinessRelation_ID | Business Relation |
| 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. |
| tiCompany_ID | integer | DDocument.Company_ID | Link to Company |
| tiCurrency_ID | integer | DDocument.Currency_ID | Currency Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDCollection_ID | integer | DDocument.DCollection_ID | Link to DCollection |
| tcDCollectionName | character | DCollection.DCollectionName | Name |
| tiDDocument_ID | integer | DDocument.DDocument_ID | Record ID |
| ttDDocumentCreationDate | date | DDocument.DDocumentCreationDate | Creation Date.This field indicate the payment creation date. This field is read-only. |
| ttDDocumentDueDate | date | DDocument.DDocumentDueDate | Due Date. The date on which the payment is receivable. |
| tlDDocumentIsOpen | logical | DDocument.DDocumentIsOpen | Open. This field indicates if the payment is completely paid already. |
| ttDDocumentLastPrintDate | date | DDocument.DDocumentLastPrintDate | Last Printed Date. This field indicates the most recent printing date. |
| tiDDocumentNumber | integer | DDocument.DDocumentNumber | Document Number. This field hold a unified number for report use. |
| tdDDocumentOriginalCreditCC | decimal | DDocument.DDocumentOriginalCreditCC | SC Original Credit. This field hold the amount of the payment in management currency. |
| tdDDocumentOriginalCreditLC | decimal | DDocument.DDocumentOriginalCreditLC | BC Original Credit.This field holds the amount of the Payment in baisc currency. |
| tdDDocumentOriginalCreditTC | decimal | DDocument.DDocumentOriginalCreditTC | TC Original Credit. This field holds the debit value of the payment in transaction currency. |
| tdDDocumentOriginalDebitCC | decimal | DDocument.DDocumentOriginalDebitCC | TC Original Debit. This field holds the debit value of the payment in management currency. |
| tdDDocumentOriginalDebitLC | decimal | DDocument.DDocumentOriginalDebitLC | TC Original Debit. This field holds the debit value of the payment in base currency. |
| tdDDocumentOriginalDebitTC | decimal | DDocument.DDocumentOriginalDebitTC | 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. |
| tcDDocumentReference | character | DDocument.DDocumentReference | Reference. Reference text for the payment. |
| tcDDocumentStatus | character | DDocument.DDocumentStatus | Status. The payment status. The default value for a new record is Initial. |
| tcDDocumentSubType | character | DDocument.DDocumentSubType | Subtype. This read-only field indicates that the payment is manual or automatic. You create manual customer payments through the Customer Payment activities, and automatic payments through the Customer Payment Selections. |
| tiDDocumentTimesPrinted | integer | DDocument.DDocumentTimesPrinted | Times Printed.This field indicates the number of times the payment has been printed. This field is read-only. |
| tcDDocumentType | character | DDocument.DDocumentType | Payment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank. |
| tiDDocumentValueDays | integer | DDocument.DDocumentValueDays | Value Days. A value for the number of days required by the bank to process the transaction. The default is based on the payment status entered. |
| tiDDocumentYear | integer | DDocument.DDocumentYear | Year/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year. |
| tiDebtor_ID | integer | DDocument.Debtor_ID | Customer |
| tiGL_ID | integer | DDocument.GL_ID | Bank Account |
| tiLng_ID | integer | Lng.Lng_ID | Record ID |
| tcLngCode | character | Lng.LngCode | Language Code |
| tcLngDescription | character | Lng.LngDescription | Description |
| tcUsrName | character | Usr.UsrName | User Name |
| DDocumentCustom | character | calculated | custom fields |
| CurrencyCustom | character | calculated | custom fields |
| DCollectionCustom | character | calculated | custom fields |
| DebtorCustom | character | calculated | custom fields |
| BusinessRelationCustom | character | calculated | custom fields |
| LngCustom | character | calculated | custom fields |
| UsrCustom | character | calculated | custom fields |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DDocument),rowid(Currency),rowid(DCollection),rowid(Debtor),rowid(BusinessRelation),rowid(Lng),rowid(Usr) |
QadFinancials