| tcBusinessFieldName | tcDataType | tcOperator |
|---|---|---|
| iiCompanyId | i | |
| icDebtorCode | c | can-do |
| tDebtor.DebtorCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| iiCompanyId | integer | Company id |
| icDebtorCode | character |
each Debtor where
| field name | data type | db field | description |
|---|---|---|---|
| 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. | ||
| DebtorCustom | character | calculated | custom fields |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Debtor) |
QadFinancials