| field name | data type | description |
|---|---|---|
| DebtorShipTo_ID | integer | |
| Address_ID | integer | |
| Debtor_ID | integer | |
| SharedSet_ID | integer | |
| DebtorEndUser_ID | integer | |
| DebtorShipToCode | character | 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 | 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 | The code that identifies the customer this shipto record is associated with. |
| DebtorShipToName | character | |
| tiDebtorBusinessRelation_ID | integer | |
| tcAddress_rowid | character | |
| tcAddressCity | character | 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 | The e-mail address associated with the used business relation. |
| api annotation: | Value for this field defaults to null. | |
| tcAddressFax | character | 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 | 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 | 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 | 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 | |
| tcAddressTelephone | character | The telephone number (maximum 40 characters) for calling this used business relation address. |
| api annotation: | Value for this field defaults to null. | |
| tcAddressTypeCode | character | 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 | Specify the Web site of this used business relation. |
| api annotation: | Value for this field defaults to null. | |
| tcAddressZip | character | 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 | Code of the business relation which associated with the used customer. |
| api annotation: | The field can't be blank. | |
| tcCountryCode | character | 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 | The description of the country where this address is located. |
| api annotation: | Value for this field defaults to null. | |
| tcCountyCode | character | 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 | The description of the county for this address. |
| api annotation: | Value for this field defaults to null. | |
| tcStateDescription | character | The description of the state or province for this address. |
| api annotation: | Value for this field defaults to null. | |
| tcAddressStreet3 | character | |
| tiBusinessRelation_ID | integer | |
| tcStateCode | character | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | |
| tlAddressIsTaxIncluded | logical | 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 | |
| tcAddressTaxIDFederal | character | The tax ID assigned to this address by the federal or national government. |
| api annotation: | Value for this field defaults to null. | |
| tcAddressTaxIDMisc1 | character | 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 | |
| tcAddressTaxIDMisc3 | character | |
| tcTxclTaxCls | character | 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 | 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 | This field is used indicate if the address assoicated with this shipto is also used by other shiptos |
| tlUpdateAllSharedAddRecords | logical | 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 | |
| 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) | |
| 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 |
QadFinancials