| iiCompanyId | integer | Company id |
| icDebtorCode | character | Customer Code |
| iiDebtor_ID | integer | Customer ID |
each Debtor where
first BusinessRelation (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. | ||
| 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. | ||
| 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. | ||
| tdDebtorHighCredit | decimal | Debtor.DebtorHighCredit | The highest amount of credit you have ever extended to this customer. This is the largest AR balance they have had open at one time. |
| tdDebtorSalesOrderBalance | decimal | Debtor.DebtorSalesOrderBalance | Current balance of all sales order related to this customer. |
| api annotation: | Value for this field defaults to 0.0000 . |
QadFinancials