| iiCompanyId | integer | Company id |
| iiCDocumentID | integer |
each CDocument where
first Creditor (inner-join) where
first BusinessRelation (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| 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. | ||
| tiCDocument_ID | integer | CDocument.CDocument_ID | Record ID |
| ttCDocumentCreationDate | date | CDocument.CDocumentCreationDate | Creation Date.This field indicate the payment creation date. This field is read-only. |
| tdCDocumentExchangeRate | decimal | CDocument.CDocumentExchangeRate | Exchange Rate. This field holds the exchange rate applying to the transaction currency. |
| tiCDocumentNumber | integer | CDocument.CDocumentNumber | Document Number. This field hold a unified number for report use. |
| tdCDocumentRateScale | decimal | CDocument.CDocumentRateScale | Scale Factor. This field indicates the scaling factor applying to the transaction currency. |
| tcCDocumentSubType | character | CDocument.CDocumentSubType | Subtype.This field indicates whether the payment is manual or automatic. You create manual supplier payments through the Supplier Payment activities, and automatic payments through the Supplier Payment Selection activities. 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. |
| tiCDocumentYear | integer | CDocument.CDocumentYear | Year/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year. |
| tcCreditorCode | character | Creditor.CreditorCode | Supplier Code |
QadFinancials