| field name | data type | db field | description |
|---|
| tcad__chr01 | character | ad_mstr.ad__chr01 | |
| tcad__chr02 | character | ad_mstr.ad__chr02 | |
| tcad__chr03 | character | ad_mstr.ad__chr03 | |
| tcad__chr04 | character | ad_mstr.ad__chr04 | |
| tcad__chr05 | character | ad_mstr.ad__chr05 | |
| tcad__qad01 | character | ad_mstr.ad__qad01 | |
| tcad__qad02 | character | ad_mstr.ad__qad02 | |
| tcad__qad03 | character | ad_mstr.ad__qad03 | |
| tcad__qad04 | character | ad_mstr.ad__qad04 | |
| tcad__qad05 | character | ad_mstr.ad__qad05 | |
| tcad_addr | character | ad_mstr.ad_addr | Address |
| tiad_address_id | integer | ad_mstr.ad_address_id | Address ID |
| tcad_asn_data | character | ad_mstr.ad_asn_data | ASN Default Data |
| tcad_attn | character | ad_mstr.ad_attn | Attention |
| tcad_attn2 | character | ad_mstr.ad_attn2 | Attention |
| tcad_barlbl_prt | character | ad_mstr.ad_barlbl_prt | Barcode Label Print Program |
| tcad_barlbl_val | character | ad_mstr.ad_barlbl_val | Barcode Validation Program |
| tcad_bk_acct1 | character | ad_mstr.ad_bk_acct1 | Bank Acct 1 |
| tcad_bk_acct2 | character | ad_mstr.ad_bk_acct2 | Bank Acct 2 |
| tcad_bus_relation | character | ad_mstr.ad_bus_relation | Business Relation Code |
| tcad_calendar | character | ad_mstr.ad_calendar | Calendar |
| tcad_city | character | ad_mstr.ad_city | City |
| tcad_coc_reg | character | ad_mstr.ad_coc_reg | CoC Number |
| tcad_conrep | character | ad_mstr.ad_conrep | Netting Logic |
| tcad_country | character | ad_mstr.ad_country | Country |
| tcad_county | character | ad_mstr.ad_county | County |
| tcad_ctry | character | ad_mstr.ad_ctry | Country Code |
| ttad_date | date | ad_mstr.ad_date | Added |
| tcad_domain | character | ad_mstr.ad_domain | Domain |
| tcad_edi_id | character | ad_mstr.ad_edi_id | Trading Prtnr EDI ID |
| tcad_edi_level | character | ad_mstr.ad_edi_level | EDI Standard Level |
| tcad_edi_std | character | ad_mstr.ad_edi_std | EDI Standard |
| tcad_edi_tpid | character | ad_mstr.ad_edi_tpid | Trading Prtnr Interface ID |
| tcad_email | character | ad_mstr.ad_email | Email |
| tcad_email2 | character | ad_mstr.ad_email2 | Email |
| tcad_ext | character | ad_mstr.ad_ext | Ext |
| tcad_ext2 | character | ad_mstr.ad_ext2 | Ext |
| tcad_fax | character | ad_mstr.ad_fax | Fax/Telex |
| tcad_fax2 | character | ad_mstr.ad_fax2 | Fax/Telex |
| tiad_format | integer | ad_mstr.ad_format | Format |
| tcad_gst_id | character | ad_mstr.ad_gst_id | Tax ID - Federal |
| tcad_intr_division | character | ad_mstr.ad_intr_division | IntraStat Division |
| tcad_inv_mthd | character | ad_mstr.ad_inv_mthd | Invoices Via |
| tcad_lang | character | ad_mstr.ad_lang | Language |
| tlad_last_file | logical | ad_mstr.ad_last_file | Last Filing |
| tcad_line1 | character | ad_mstr.ad_line1 | Address |
| tcad_line2 | character | ad_mstr.ad_line2 | Address |
| tcad_line3 | character | ad_mstr.ad_line3 | Address |
| tcad_loadseq | character | ad_mstr.ad_loadseq | Load Sequence |
| tcad_misc1_id | character | ad_mstr.ad_misc1_id | Tax ID - Misc 1 |
| tcad_misc2_id | character | ad_mstr.ad_misc2_id | Tax ID - Misc 2 |
| tcad_misc3_id | character | ad_mstr.ad_misc3_id | Tax ID - Misc 3 |
| ttad_mod_date | date | ad_mstr.ad_mod_date | Modified Date |
| tcad_name | character | ad_mstr.ad_name | Name |
| tcad_name_control | character | ad_mstr.ad_name_control | Name Control |
| tcad_phone | character | ad_mstr.ad_phone | Telephone |
| tcad_phone2 | character | ad_mstr.ad_phone2 | Telephone |
| tlad_pick_by_date | logical | ad_mstr.ad_pick_by_date | Pick By Date |
| tcad_po_mthd | character | ad_mstr.ad_po_mthd | Purchase Orders Via |
| tcad_priority | character | ad_mstr.ad_priority | Priority |
| tcad_profile | character | ad_mstr.ad_profile | Profile |
| tcad_pst_id | character | ad_mstr.ad_pst_id | Tax ID - State |
| tcad_ref | character | ad_mstr.ad_ref | Reference |
| tcad_route | character | ad_mstr.ad_route | Route |
| tcad_sch_mthd | character | ad_mstr.ad_sch_mthd | Schedules Via |
| tcad_sort | character | ad_mstr.ad_sort | Sort Name |
| tcad_state | character | ad_mstr.ad_state | State |
| tlad_tax_in | logical | ad_mstr.ad_tax_in | Tax In |
| tlad_tax_in_city | logical | ad_mstr.ad_tax_in_city | In City |
| tlad_tax_report | logical | ad_mstr.ad_tax_report | Tax Report |
| tcad_tax_type | character | ad_mstr.ad_tax_type | Tax Type |
| tcad_tax_usage | character | ad_mstr.ad_tax_usage | Tax Usage |
| tcad_tax_zone | character | ad_mstr.ad_tax_zone | Tax Zone |
| tlad_taxable | logical | ad_mstr.ad_taxable | Taxable |
| tcad_taxc | character | ad_mstr.ad_taxc | Tax Class |
| tlad_temp | logical | ad_mstr.ad_temp | Temporary |
| tcad_timezone | character | ad_mstr.ad_timezone | Time Zone |
| tcad_tp_loc_code | character | ad_mstr.ad_tp_loc_code | Trd Partner Location Code |
| tcad_type | character | ad_mstr.ad_type | List Type |
| tcad_user1 | character | ad_mstr.ad_user1 | Ufld1 |
| tcad_user2 | character | ad_mstr.ad_user2 | Ufld2 |
| tcad_userid | character | ad_mstr.ad_userid | User ID |
| tcad_vat_reg | character | ad_mstr.ad_vat_reg | VAT Registration |
| tiad_wk_offset | integer | ad_mstr.ad_wk_offset | Week Offset |
| tcad_zip | character | ad_mstr.ad_zip | Post |
| tdoid_ad_mstr | decimal | ad_mstr.oid_ad_mstr | |
each ad_mstr where