| field name | data type | mnd. | description |
|---|---|---|---|
| ad_addr | character(80) | yes | Address |
| ad_name | character(80) | no | Name |
| ad_line1 | character(36) | no | Address |
| ad_line2 | character(36) | no | Address |
| ad_city | character(30) | no | City |
| ad_state | character(30) | no | State |
| ad_zip | character(30) | no | Post |
| ad_type | character(80) | no | List Type |
| ad_attn | character(30) | no | Attention |
| ad_phone | character(30) | no | Telephone |
| ad_ext | character(30) | no | Ext |
| ad_ref | character(80) | no | Reference |
| ad_sort | character(80) | no | Sort Name |
| ad_country | character(30) | no | Country |
| ad_attn2 | character(30) | no | Attention |
| ad_phone2 | character(30) | no | Telephone |
| ad_ext2 | character(30) | no | Ext |
| ad_fax | character(30) | no | Fax/Telex |
| ad_fax2 | character(30) | no | Fax/Telex |
| ad_line3 | character(36) | no | Address |
| ad_user1 | character(80) | no | Ufld1 |
| ad_user2 | character(80) | no | Ufld2 |
| ad_lang | character(30) | no | Language |
| ad_pst_id | character(30) | no | Tax ID - State |
| ad_date | date | no | Added |
| ad_county | character(30) | no | County |
| ad_temp | logical | no | Temporary |
| ad_bk_acct1 | character(30) | no | Bank Acct 1 |
| ad_bk_acct2 | character(30) | no | Bank Acct 2 |
| ad_format | integer | no | Format |
| ad_vat_reg | character(30) | no | VAT Registration |
| ad_coc_reg | character(80) | no | CoC Number |
| ad_gst_id | character(30) | no | Tax ID - Federal |
| ad_tax_type | character(30) | no | Tax Type |
| ad_taxc | character(30) | no | Tax Class |
| ad_taxable | logical | no | Taxable |
| ad_tax_in | logical | no | Tax In |
| ad_edi_tpid | character(30) | no | Trading Prtnr Interface ID |
| ad_timezone | character(80) | no | Time Zone |
| ad_mod_date | date | no | Modified Date |
| ad_userid | character(80) | no | User ID |
| ad_edi_id | character(30) | no | Trading Prtnr EDI ID |
| ad_conrep | character(30) | no | Netting Logic |
| ad_barlbl_prt | character(380) | no | Barcode Label Print Program |
| ad_barlbl_val | character(30) | no | Barcode Validation Program |
| ad_calendar | character(80) | no | Calendar |
| ad_edi_std | character(80) | no | EDI Standard |
| ad_edi_level | character(80) | no | EDI Standard Level |
| ad__qad01 | character(80) | no | |
| ad__qad02 | character(80) | no | |
| ad__qad03 | character(80) | no | |
| ad__qad04 | character(80) | no | |
| ad__qad05 | character(80) | no | |
| ad__chr01 | character(80) | no | |
| ad__chr02 | character(80) | no | |
| ad__chr03 | character(80) | no | |
| ad__chr04 | character(80) | no | |
| ad__chr05 | character(80) | no | |
| ad_tp_loc_code | character(30) | no | Trd Partner Location Code |
| ad_ctry | character(30) | no | Country Code |
| ad_tax_zone | character(30) | no | Tax Zone |
| ad_tax_usage | character(80) | no | Tax Usage |
| ad_misc1_id | character(30) | no | Tax ID - Misc 1 |
| ad_misc2_id | character(30) | no | Tax ID - Misc 2 |
| ad_misc3_id | character(30) | no | Tax ID - Misc 3 |
| ad_wk_offset | integer | no | Week Offset |
| ad_inv_mthd | character(30) | no | Invoices Via |
| ad_sch_mthd | character(30) | no | Schedules Via |
| ad_po_mthd | character(30) | no | Purchase Orders Via |
| ad_asn_data | character(256) | no | ASN Default Data |
| ad_intr_division | character(30) | no | IntraStat Division |
| ad_tax_report | logical | no | Tax Report |
| ad_name_control | character(30) | no | Name Control |
| ad_last_file | logical | no | Last Filing |
| ad_domain | character(8) | yes | Domain |
| oid_ad_mstr | decimal(10) | no | |
| ad_email | character(48) | no | |
| ad_email2 | character(48) | no | |
| ad_bus_relation | character(20) | no | Business Relation Code |
| ad_priority | character(16) | no | Priority |
| ad_route | character(16) | no | Route |
| ad_loadseq | character(16) | no | Load Sequence |
| ad_pick_by_date | logical | no | Pick By Date |
| ad_profile | character(16) | no | Profile |
| ad_address_id | integer | no | Address ID |
| ad_tax_in_city | logical | no | In City |
| ad_ns_pr_list | character(16) | no | Non-Sales Price List |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| 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 |