table tShiptoAddressMaster
| field name | data type | description |
|---|
| ad_addr | character | |
| ad_name | character | |
| ad_line1 | character | |
| ad_line2 | character | |
| ad_city | character | |
| ad_state | character | |
| ad_zip | character | |
| ad_type | character | |
| ad_attn | character | |
| ad_phone | character | |
| ad_ext | character | |
| ad_ref | character | |
| ad_sort | character | |
| ad_country | character | |
| ad_attn2 | character | |
| ad_phone2 | character | |
| ad_ext2 | character | |
| ad_fax | character | |
| ad_fax2 | character | |
| ad_line3 | character | |
| ad_user1 | character | |
| ad_user2 | character | |
| ad_lang | character | |
| ad_pst_id | character | |
| ad_date | date | |
| ad_county | character | |
| ad_temp | logical | |
| ad_bk_acct1 | character | |
| ad_bk_acct2 | character | |
| ad_format | integer | |
| ad_vat_reg | character | |
| ad_coc_reg | character | |
| ad_gst_id | character | |
| ad_tax_type | character | |
| ad_taxc | character | |
| ad_taxable | logical | |
| ad_tax_in | logical | |
| ad_edi_tpid | character | |
| ad_timezone | character | |
| ad_mod_date | date | |
| ad_userid | character | |
| ad_edi_id | character | |
| ad_conrep | character | |
| ad_barlbl_prt | character | |
| ad_barlbl_val | character | |
| ad_calendar | character | |
| ad_edi_std | character | |
| ad_edi_level | character | |
| ad__qad01 | character | |
| ad__qad02 | character | |
| ad__qad03 | character | |
| ad__qad04 | character | |
| ad__qad05 | character | |
| ad__chr01 | character | |
| ad__chr02 | character | |
| ad__chr03 | character | |
| ad__chr04 | character | |
| ad__chr05 | character | |
| ad_tp_loc_code | character | |
| ad_ctry | character | |
| ad_tax_zone | character | |
| ad_tax_usage | character | |
| ad_misc1_id | character | |
| ad_misc2_id | character | |
| ad_misc3_id | character | |
| ad_wk_offset | integer | |
| ad_inv_mthd | character | |
| ad_sch_mthd | character | |
| ad_po_mthd | character | |
| ad_asn_data | character | |
| ad_intr_division | character | |
| ad_tax_report | logical | |
| ad_name_control | character | |
| ad_last_file | logical | |
| ad_domain | character | |
| oid_ad_mstr | decimal(10) | |
| ad_email | character | |
| ad_email2 | character | |
| ad_bus_relation | character | Business Relation Code |
| ad_priority | character | |
| ad_route | character | |
| ad_loadseq | character | |
| ad_pick_by_date | logical | |
| ad_profile | character | |
| ad_address_id | integer | Address ID |
| ad_tax_in_city | logical | |
| ad_ns_pr_list | character | |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character | |
Internal usage
QadFinancials