| field name | data type | mnd. | description |
|---|---|---|---|
| DebtorShipTo_ID | integer | yes | Record ID |
| Address_ID | integer | yes | City |
| Debtor_ID | integer | yes | Customer Code |
| SharedSet_ID | integer | yes | Link to SharedSet |
| DebtorEndUser_ID | integer | no | End User Code |
| DebtorShipToCode | character(8) | yes | Ship-To Code. If you are not linking to another customer or to an end user, specify a new code. This code is automatically created with an address type of ship-to. If you leave Ship-To Code blank, the system Setting Up Business Relations automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. |
| api annotation: | If you select Link to Another Customer or Link to End User, the Ship-To Code field is filled with the value you specify for the customer or end user. These addresses are added as ship-tos for the customer specified in Customer Code. | ||
| DebtorShipToIsDebtor | logical | yes | Select this field if you want to specify another customer as the ship-to of this customer. |
| api annotation: | Value for this field defaults to false. If it is true, the related customer code selected is used to fill the ship-to code field. | ||
| tcDebtorCode | character(8) | yes | The code that identifies the customer this shipto record is associated with. |
| DebtorShipToName | character(36) | no | Ship-To Name |
| tiDebtorBusinessRelation_ID | integer | no | |
| tcAddress_rowid | character | no | |
| tcAddressCity | character(30) | yes | City (maximum 20 characters) for the address associated with this ship-to record. |
| api annotation: | City can be used to select a tax zone. | ||
| tcAddressEMail | character(40) | yes | The e-mail address associated with the used business relation. |
| api annotation: | Value for this field defaults to null. | ||
| tcAddressFax | character(40) | yes | The fax or telex number (maximum 40 characters) to use when sending documents to this address. |
| api annotation: | Value for this field defaults to null. | ||
| tlAddressIsTemporary | logical | yes | Indicate if this address is temporary. |
| api annotation: | Value for this field defaults to false. This field is for reference and can be useful for sorting and filtering records. | ||
| tcAddressName | character(36) | yes | Specify the full name (maximum 36 characters) of this particular address. |
| api annotation: | Name defaults from the value specified for the used business relation. It cannot be modified for the headoffice type. | ||
| tcAddressStreet1 | character(36) | yes | Enter up to three lines of address details. Each line can be up to 36 characters. You must enter data in Address Line 1 at a minimum. |
| tcAddressStreet2 | character(36) | yes | Address |
| tcAddressTelephone | character(40) | yes | The telephone number (maximum 40 characters) for calling this used business relation address. |
| api annotation: | Value for this field defaults to null. | ||
| tcAddressTypeCode | character(20) | yes | A code which identifies the type of address related with the ship-to record. |
| api annotation: | If you're linking this ship-to record to an existing customer address, then enter "HEADOFFICE" in this field. If linking this ship-to record to an existing end user address, then enter "ENDUSER" in this field. If it is creating a new ship-to record or linking to an existing ship-to record, then enter "SHIP-TO" in this field. | ||
| tcAddressWebSite | character(60) | yes | Specify the Web site of this used business relation. |
| api annotation: | Value for this field defaults to null. | ||
| tcAddressZip | character(10) | yes | The postal code or US zip code (maximum 10 characters) associated with this address. |
| api annotation: | Value for this field defaults to null. | ||
| tcBusinessRelationCode | character(20) | yes | Code of the business relation which associated with the used customer. |
| api annotation: | The field can't be blank. | ||
| tcCountryCode | character(3) | yes | A valid country code that identifies the country where this address is located. |
| api annotation: | This field is used to determine tax defaults. | ||
| tcCountryDescription | character(28) | yes | The description of the country where this address is located. |
| api annotation: | Value for this field defaults to null. | ||
| tcCountyCode | character(20) | yes | A valid county code that identifies the county for this address. |
| api annotation: | Value for this field defaults to null. The county is used to select a tax zone. | ||
| tcCountyDescription | character(40) | yes | The description of the county for this address. |
| api annotation: | Value for this field defaults to null. | ||
| tcStateDescription | character(40) | yes | The description of the state or province for this address. |
| api annotation: | Value for this field defaults to null. | ||
| tcAddressStreet3 | character(36) | yes | Address |
| tiBusinessRelation_ID | integer | yes | |
| tcStateCode | character(4) | yes | A valid state or province code for this address. |
| api annotation: | Value for this field defaults to null. The state is used to select a tax zone. | ||
| tcDebtorEndUserCode | character(8) | no | Customer End User Code. If you select Link to End User, the Ship-To Code field is filled with the value you specify for the end user. |
| api annotation: | If you're not linking to an end user, value for this field defaults to null. | ||
| tcTxzTaxZone | character(16) | yes | Specify the tax zone for this address. |
| api annotation: | The system searches for a default based on the country, state or province, county, city, and postal code of the current address. | ||
| tiAddressFormat | integer | yes | This field determines where postal codes display on printed addresses.Valid values are: After: Postal code prints after the city and state. Before: Postal code prints before the city and state. |
| api annotation: | It defaults to the value for the same field defined for the country. (0 represents "after") | ||
| tlAddressIsTaxable | logical | yes | Indicate if business activities for this address are normally subject to tax. |
| api annotation: | The taxable status of the address defaults to transactions where the address is used. | ||
| tlAddressIsTaxInCity | logical | yes | Indicate whether the address is in the city limits for taxation purposes. It is used only with the Sales and Use Tax Interface for US and Canadian tax processing. |
| api annotation: | Value for this field defaults to false. | ||
| tcAddressSearchName | character(28) | yes | Specify an alternate name (maximum 28 characters) for finding this address. It cannot be modified for the headoffice type. |
| api annotation: | Search Name defaults from the value specified for the business relation. | ||
| tcAddressTaxIDState | character(18) | yes | For reference and documentation purposes, enter either a state or provincial tax identification number or a VAT registration number. |
| api annotation: | Value for this field defaults to null. | ||
| tcLngCode | character(2) | yes | |
| tlAddressIsTaxIncluded | logical | yes | Indicate if line item prices for this address normally include tax. |
| api annotation: | The value defaults to the header of transactions created for this address. | ||
| tiAddressTaxDeclaration | integer | yes | |
| tcAddressTaxIDFederal | character(18) | yes | The tax ID assigned to this address by the federal or national government. |
| api annotation: | Value for this field defaults to null. | ||
| tcAddressTaxIDMisc1 | character(18) | yes | Miscellaneous tax 1, 2, 3 are for reference and documentation purposes, enter any other tax identification numbers that are useful. |
| api annotation: | Value for these fields defaults to null. | ||
| tcAddressTaxIDMisc2 | character(18) | yes | |
| tcAddressTaxIDMisc3 | character(18) | yes | |
| tcTxclTaxCls | character(3) | yes | A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions. |
| api annotation: | The value defaults to the header of transactions created for this address. | ||
| tcTxuTaxUsage | character(8) | yes | A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address.Common tax usages are retail, manufacturing, and industrialization. |
| api annotation: | The value defaults to the header of transactions created for this address. | ||
| tlAddressIsShared | logical | no | This field is used indicate if the address assoicated with this shipto is also used by other shiptos |
| tlUpdateAllSharedAddRecords | logical | no | This field is only used when modifying an addres associated with a shipto. If this field is set to true then it indicates that the user wishes to update all shiptos that share the address being updated. |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| Contact_ID | integer | |
| Lng_ID | integer | |
| Address_ID | integer | |
| BusinessRelation_ID | integer | |
| ContactFunction | character | Function. The function of the contact to the address. This field can be blank. |
| ContactName | character | Name. The full name of the contact. This field is mandatory. |
| ContactInitials | character | Initials. The initials of the contact. This field can be blank. |
| ContactGender | character | Gender. indicates whether the contact is male or femail. This field is mandatory |
| ContactTitle | character | Title. Title of the contact. This field can be blank. |
| ContactTelephone | character | Telephone. The telephone number of the contact. This field can be blank. |
| ContactMobilePhone | character | Mobile. The mobile phone number of the contact. This field can be blank. |
| ContactEmail | character | E-mail. The E-Mail address of the contact. This field can be blank. |
| ContactFax | character | Fax. The fax or telex number to use when sending documents to the contact. This field can be blank. |
| ContactIsPrimary | logical | Primary Contact. This field indicates if the contact is the primary contact of the address. Only one primary contact per address type is allowed. |
| api annotation: | PartialUpdate = yes - defaults to false | |
| ContactIsSecondary | logical | Secondary Contact. This field indicates if the contact is the primary contact of the address. Only one secondary contact per address type is allowed. |
| api annotation: | PartialUpdate = yes - defaults to false | |
| tcLngCode | character | Language Code. A code identifying the language used by this contact. |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |