| iiCompanyId | integer | Company id |
| icReference | character | |
| iiOwnBankNumberId | integer | |
| idAmountTC | decimal | |
| icIncassoSelectCode | character | |
| iiDebtorId | integer | |
| icDebtorCode | character | |
| iiDDocumentId | integer | |
| iiCurrencyID | integer | |
| icExcludeDDocStatusList | character |
each DDocument where
first DCollection (inner-join) where
first Debtor (inner-join) where
first BusinessRelation (inner-join) where
first GL (inner-join) where
each BankNumber (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| 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. | ||
| tcBusinessRelationSearchName | character | BusinessRelation.BusinessRelationSearchName | Search Name: An alternate name for finding the business relation. This field can be useful for sorting and filtering. |
| api annotation: | PartialUpdate = yes - defaults to the BusinessRelationCode. | ||
| tiDCollection_ID | integer | DCollection.DCollection_ID | Record ID |
| tdDCollectionBalanceTC | decimal | DCollection.DCollectionBalanceTC | TC Balance |
| tcDCollectionName | character | DCollection.DCollectionName | Name |
| tiDCollectionNumber | integer | DCollection.DCollectionNumber | Number |
| tcDCollectionReference | character | DCollection.DCollectionReference | 1099 Box Reference |
| tiDDocument_ID | integer | DDocument.DDocument_ID | Record ID |
| tcDDocumentIncassoSelectCode | character | DDocument.DDocumentIncassoSelectCode | Customer Payment Selection Code. This field displays the customer payment selection code. This field is read-only. |
| tlDDocumentIsOpen | logical | DDocument.DDocumentIsOpen | Open. This field indicates if the payment is completely paid already. |
| tiDDocumentNumber | integer | DDocument.DDocumentNumber | Document Number. This field hold a unified number for report use. |
| tcDDocumentReference | character | DDocument.DDocumentReference | Reference. Reference text for the payment. |
| tcDDocumentType | character | DDocument.DDocumentType | Payment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank. |
| 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 | Debtor.Debtor_ID | Record ID |
| tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
| api annotation: | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. |
QadFinancials