| iiCompanyId | integer | Company id |
| iiDebtorId | integer |
each DebtorEndUser where
first Address (inner-join) where
first AddressType (inner-join) where
first BusinessRelation (inner-join) where
first Country (inner-join) where
first County (outer-join) where
first State (outer-join) where
first Debtor (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiAddress_ID | integer | DebtorEndUser.Address_ID | City |
| tcAddressCity | character | Address.AddressCity | City. The city for this address. This field can be used to decide the tax zone of the address. |
| tcAddressEMail | character | Address.AddressEMail | E-Mail. This field indicates the e-mail address associated with this business relation. This field can be blank. |
| tcAddressFax | character | Address.AddressFax | Fax. This field indicates the fax or telex number to use when sending documents to this address. This field can be balnk. |
| tlAddressIsTemporary | logical | Address.AddressIsTemporary | Temporary. If the type of this address is ship-to or dock, this field indicates if the address is temporary. This field is for reference and can be useful for sorting and filtering records. |
| api annotation: | PartialUpdate = yes - defaults to false. | ||
| tcAddressName | character | Address.AddressName | Name. The full name of this particular address. The name of a headoffice address is the same as the name of the business relationship and can not be modified. |
| api annotation: | PartialUpdate = yes - defaults to the name of the businessRelation. | ||
| tcAddressStreet1 | character | Address.AddressStreet1 | Address: Line one of address details. This field can be blank. |
| tcAddressStreet2 | character | Address.AddressStreet2 | Address.Line two of address details. This field can be blank. |
| tcAddressStreet3 | character | Address.AddressStreet3 | Address.Line three of address details. This field can be blank. |
| tcAddressTelephone | character | Address.AddressTelephone | Telephone. The telephone number for calling this business relation address. This field can be blank. |
| tcAddressTypeCode | character | AddressType.AddressTypeCode | Address Type |
| tcAddressWebSite | character | Address.AddressWebSite | Internet. This field indicates the Web site of this business relation. This field can be blank. |
| tcAddressZip | character | Address.AddressZip | Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank. |
| tiBusinessRelation_ID | integer | Address.BusinessRelation_ID | Link to BusinessRelation |
| 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. |
| tiCountry_ID | integer | Country.Country_ID | Record ID |
| tcCountryCode | character | Country.CountryCode | Country Code |
| tcCountryDescription | character | Country.CountryDescription | Description |
| tlCountryIsEUCountry | logical | Country.CountryIsEUCountry | EU Member |
| tiCounty_ID | integer | County.County_ID | Record ID |
| tcCountyCode | character | County.CountyCode | County Code |
| tcCountyDescription | character | County.CountyDescription | Description |
| tiDebtor_ID | integer | DebtorEndUser.Debtor_ID | Customer Code |
| 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. | ||
| tiDebtorEndUser_ID | integer | DebtorEndUser.DebtorEndUser_ID | Record ID |
| tcDebtorEndUserCode | character | DebtorEndUser.DebtorEndUserCode | End user code(maximum 8 characters). |
| api annotation: | If you select Link to Customer or Link to Ship-To Address, the End User Code field is filled with the value you specify for the customer or ship-to address./ Otherwise the system automatically generates a number for the record based on the sequence defined in End User Autonumber Create. | ||
| tlDebtorEndUserIsDebtor | logical | DebtorEndUser.DebtorEndUserIsDebtor | Indicate whether you select Link to Customer.Select this field if you want to define the customer entered in the field "tcDebtorCode" as an end user. |
| api annotation: | Value for this field defaults to false. | ||
| tlDebtorEndUserIsShipTo | logical | DebtorEndUser.DebtorEndUserIsShipTo | Indicate whether you select Link to Ship-to Address. Select this field if you want to enter a shipto associated with the customer and define the ship-to as an end user. |
| api annotation: | Value for this field defaults to false. | ||
| tcDebtorEndUserName | character | DebtorEndUser.DebtorEndUserName | End User Name |
| ttLastModifiedDate | date | DebtorEndUser.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | DebtorEndUser.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | DebtorEndUser.LastModifiedUser | Last Modified User |
| tiSharedSet_ID | integer | DebtorEndUser.SharedSet_ID | Link to SharedSet |
| tiState_ID | integer | State.State_ID | Record ID |
| tcStateCode | character | State.StateCode | State |
| tcStateDescription | character | State.StateDescription | Description |
| tcTxzTaxZone | character | Address.TxzTaxZone | Tax Zone. This field indicates the tax zone for this address. This field is mandatory. |
| api annotation: | PartialUpdate = yes - defaults to a value the system searches for based on the country, state or province, county, city, and postal code of the current address. | ||
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DebtorEndUser),rowid(Address),rowid(AddressType),rowid(BusinessRelation),rowid(Country),rowid(County),rowid(State),rowid(Debtor) |
QadFinancials