| iiCompanyId | integer | Company id |
| icDebtorCode | character | |
| iiDebtorID | integer |
each Debtor where
first BusinessRelation (inner-join) where
first Reason (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tcBusinessRelationICCode | character | BusinessRelation.BusinessRelationICCode | Intercompany Code. When Intercompany is true, this field is mandatory. The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports. The intercompany code must be unique for this business relation. |
| 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. | ||
| tlDebtorIsActive | logical | Debtor.DebtorIsActive | Indicate if this is an active record. |
| api annotation: | Value for this field defaults to false. | ||
| 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. |
| tlBusinessRelationIsActive | logical | BusinessRelation.BusinessRelationIsActive | Active: This field indicates if this is an active record. |
| api annotation: | PartialUpdate = yes - defaults to true. | ||
| tcReasonCode | character | Reason.ReasonCode | Invoice Status Code |
| tlReasonIsActive | logical | Reason.ReasonIsActive | Active |
| tiBusinessRelation_ID | integer | Debtor.BusinessRelation_ID | Business Relation |
| tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
| tiReason_ID | integer | Debtor.Reason_ID | Invoice Status Code |
QadFinancials