| iiCompanyId | integer | Company id |
| iiCollectionID | integer | |
| icDocumentStatus | character |
each DDocument where
| field name | data type | db field | description |
|---|---|---|---|
| tiBankNumber_ID | integer | DDocument.BankNumber_ID | Link to BankNumber |
| tiCompany_ID | integer | DDocument.Company_ID | Link to Company |
| tiCreationUsr_ID | integer | DDocument.CreationUsr_ID | Login |
| tiCurrency_ID | integer | DDocument.Currency_ID | Currency Code |
| tcCustomCombo0 | character | DDocument.CustomCombo0 | Custom Combo Field |
| tcCustomCombo1 | character | DDocument.CustomCombo1 | Custom Combo Field |
| tcCustomCombo2 | character | DDocument.CustomCombo2 | Custom Combo Field |
| tcCustomCombo3 | character | DDocument.CustomCombo3 | Custom Combo Field |
| tcCustomCombo4 | character | DDocument.CustomCombo4 | Custom Combo Field |
| tcCustomCombo5 | character | DDocument.CustomCombo5 | Custom Combo Field |
| tcCustomCombo6 | character | DDocument.CustomCombo6 | Custom Combo Field |
| tcCustomCombo7 | character | DDocument.CustomCombo7 | Custom Combo Field |
| tcCustomCombo8 | character | DDocument.CustomCombo8 | Custom Combo Field |
| tcCustomCombo9 | character | DDocument.CustomCombo9 | Custom Combo Field |
| ttCustomDate0 | date | DDocument.CustomDate0 | Custom Date Field |
| ttCustomDate1 | date | DDocument.CustomDate1 | Custom Date Field |
| ttCustomDate2 | date | DDocument.CustomDate2 | Custom Date Field |
| ttCustomDate3 | date | DDocument.CustomDate3 | Custom Date Field |
| ttCustomDate4 | date | DDocument.CustomDate4 | Custom Date Field |
| tdCustomDecimal0 | decimal | DDocument.CustomDecimal0 | Custom Decimal Field |
| tdCustomDecimal1 | decimal | DDocument.CustomDecimal1 | Custom Decimal Field |
| tdCustomDecimal2 | decimal | DDocument.CustomDecimal2 | Custom Decimal Field |
| tdCustomDecimal3 | decimal | DDocument.CustomDecimal3 | Custom Decimal Field |
| tdCustomDecimal4 | decimal | DDocument.CustomDecimal4 | Custom Decimal Field |
| tiCustomInteger0 | integer | DDocument.CustomInteger0 | Custom Integer Field |
| tiCustomInteger1 | integer | DDocument.CustomInteger1 | Custom Integer Field |
| tiCustomInteger2 | integer | DDocument.CustomInteger2 | Custom Integer Field |
| tiCustomInteger3 | integer | DDocument.CustomInteger3 | Custom Integer Field |
| tiCustomInteger4 | integer | DDocument.CustomInteger4 | Custom Integer Field |
| tcCustomLong0 | character | DDocument.CustomLong0 | Custom Long Field |
| tcCustomLong1 | character | DDocument.CustomLong1 | Custom Long Field |
| tcCustomNote | character | DDocument.CustomNote | Custom Note Field |
| tcCustomShort0 | character | DDocument.CustomShort0 | Custom Short Field |
| tcCustomShort1 | character | DDocument.CustomShort1 | Custom Short Field |
| tcCustomShort2 | character | DDocument.CustomShort2 | Custom Short Field |
| tcCustomShort3 | character | DDocument.CustomShort3 | Custom Short Field |
| tcCustomShort4 | character | DDocument.CustomShort4 | Custom Short Field |
| tcCustomShort5 | character | DDocument.CustomShort5 | Custom Short Field |
| tcCustomShort6 | character | DDocument.CustomShort6 | Custom Short Field |
| tcCustomShort7 | character | DDocument.CustomShort7 | Custom Short Field |
| tcCustomShort8 | character | DDocument.CustomShort8 | Custom Short Field |
| tcCustomShort9 | character | DDocument.CustomShort9 | Custom Short Field |
| tiDCollection_ID | integer | DDocument.DCollection_ID | Link to DCollection |
| tiDDocument_ID | integer | DDocument.DDocument_ID | Record ID |
| tdDDocumentCCRate | decimal | DDocument.DDocumentCCRate | SC Rate. The statutory scaling factor applying to the transaction currency. |
| tdDDocumentCCScale | decimal | DDocument.DDocumentCCScale | SC Rate Scale. The statutory exchange rate used by the invoice. |
| ttDDocumentCreationDate | date | DDocument.DDocumentCreationDate | Creation Date.This field indicate the payment creation date. This field is read-only. |
| tiDDocumentCreationTime | integer | DDocument.DDocumentCreationTime | Creation Time. The time payment is created. |
| ttDDocumentDueDate | date | DDocument.DDocumentDueDate | Due Date. The date on which the payment is receivable. |
| tdDDocumentExchangeRate | decimal | DDocument.DDocumentExchangeRate | Exchange Rate. This field holds the exchange rate applying to the transaction currency. |
| 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. |
| 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. |
| tdDDocumentOriginalCreditBC | decimal | DDocument.DDocumentOriginalCreditBC | BC Original Credit |
| 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. |
| tdDDocumentOriginalDebitBC | decimal | DDocument.DDocumentOriginalDebitBC | BC Original Debit |
| 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. |
| tdDDocumentRateScale | decimal | DDocument.DDocumentRateScale | Scale Factor. This field indicates the scaling factor applying to the transaction currency. |
| 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 |
| tiDPaySel_ID | integer | DDocument.DPaySel_ID | Link to DPaySel |
| tiGL_ID | integer | DDocument.GL_ID | Bank Account |
| ttLastModifiedDate | date | DDocument.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | DDocument.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | DDocument.LastModifiedUser | Last Modified User |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DDocument) |
QadFinancials