| iiCompanyId | integer | Company id |
| icFromDebtorCode | character | FromDebtorCode |
| icToDebtorCode | character | ToDebtorCode |
| icCandoDebtorCode | character | CandoDebtorCode |
| icFromBRCode | character | FromBRCode |
| icToBRCode | character | ToBRCode |
| icCandoBRCode | character | CandoBRCode |
| icCurrencyCode | character | |
| itAgeingDate | date | Ageing Date |
| icCanDoGLCode | character | |
| icFromGLCode | character | |
| icToGLCode | character | |
| icDDocumentDraftType | character | |
| icDebtorTypeCode | character | |
| icPaymentGroup | character |
each Debtor where
first BusinessRelation (inner-join) where
each DDocument (inner-join) where
first BankNumber (inner-join) where
first BankPayFormat (inner-join) where
first PayFormatType (inner-join) where
first Company (inner-join) where
first Currency1 (inner-join) where
each DDocumentPostingLine (inner-join) where
first PostingLine (inner-join) where
first GL (inner-join) where
first DebtorType (conditional-join) where
first PaymentGroup (conditional-join) where
first Currency2 (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiBusinessRelation_ID | integer | Debtor.BusinessRelation_ID | Business Relation |
| 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. |
| 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. | ||
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiCurrency_ID | integer | Currency1.Currency_ID | Record ID |
| tcCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
| tcCurrencyDescription | character | Currency1.CurrencyDescription | Currency Description |
| tiCurrencyNumberOfDecimals | integer | Currency1.CurrencyNumberOfDecimals | Number of Decimals |
| 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. |
| 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. |
| 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. | ||
| tcDebtorCurrency | character | Currency2.CurrencyCode | Currency Code |
| tdDebtorFixedCredLimTC | decimal | Debtor.DebtorFixedCredLimTC | When Apply Fixed Ceiling is selected, specify the currency amount that determines the maximum credit extended to this customer. |
| api annotation: | Value for this field defaults to 0.0000 . | ||
| tdDebtorPercTurnOverCredLim | decimal | Debtor.DebtorPercTurnOverCredLim | When Apply % of Turnover is selected,specify a percentage value. The system applies this percentage to the last year turnover and displays the result in the Credit on Turnover field. The amount is recalculated when you change the percentage. |
| api annotation: | Value for this field defaults to 0.00 . | ||
| tiDebtorType_ID | integer | DebtorType.DebtorType_ID | Record ID |
| tcDebtorTypeCode | character | DebtorType.DebtorTypeCode | A code (maximum four characters) that identifies a customer type. |
| tcDebtorTypeDescription | character | DebtorType.DebtorTypeDescription | A brief description (maximum 40 characters) of the customer type. |
| tiGL_ID | integer | GL.GL_ID | Record ID |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
| tcGLDescription | character | GL.GLDescription | A description of the GL account. |
| tcPayFormatTypeCode | character | PayFormatType.PayFormatTypeCode | Format Name |
| tiPaymentGroup_ID | integer | PaymentGroup.PaymentGroup_ID | Record ID |
| tcPaymentGroupCode | character | PaymentGroup.PaymentGroupCode | Payment Group |
| tcPaymentGroupDescription | character | PaymentGroup.PaymentGroupDescription | Description |
| ttPostingDate | date | PostingLine.PostingDate | Posting Date. |
| api annotation: | If this field is blank, it gets a default value equal to the value of PostingDate in tPosting. | ||
| tdPostingLineCreditCC | decimal | PostingLine.PostingLineCreditCC | SC Credit |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field | ||
| tdPostingLineCreditLC | decimal | PostingLine.PostingLineCreditLC | BC Credit |
| api annotation: | Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field. | ||
| tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
| tdPostingLineDebitCC | decimal | PostingLine.PostingLineDebitCC | SC Debit |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field. | ||
| tdPostingLineDebitLC | decimal | PostingLine.PostingLineDebitLC | BC Debit |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field. | ||
| tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
| tiPostingYearPeriod | integer | PostingLine.PostingYearPeriod | The GL calendar year/period for the journal entry. |
| api annotation: | In Create mode, it will get be defaulted to the value for the field PostingYearPeriod of tPosting. | ||
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Debtor),rowid(BusinessRelation),rowid(DDocument),rowid(BankNumber),rowid(BankPayFormat),rowid(PayFormatType),rowid(Company),rowid(Currency1),rowid(DDocumentPostingLine),rowid(PostingLine),rowid(GL),rowid(DebtorType),rowid(PaymentGroup),rowid(Currency2) |
QadFinancials