| field name | data type | mnd. | description |
|---|---|---|---|
| vd_addr | character(80) | no | Supplier |
| vd_cr_terms | character(80) | no | Cr Terms |
| vd_buyer | character(80) | no | Buyer |
| vd_disc_pct | decimal(10) | no | Disc % |
| vd_shipvia | character(30) | no | Ship Via |
| vd_partial | logical | no | Partial OK |
| vd_rmks | character(80) | no | Remarks |
| vd_ap_acct | character(80) | no | AP Account |
| vd_ap_cc | character(30) | no | AP Cost Ctr |
| vd_pur_acct | character(80) | no | Pur Acct |
| vd_pur_cc | character(30) | no | Pur Cost Ctr |
| vd_pur_cntct | character(30) | no | Purchase Contact |
| vd_ap_cntct | character(30) | no | AP Contact |
| vd_1099 | logical | no | Tax Report |
| vd_sort | character(30) | no | Sort Name |
| vd_last_ck | date | no | Last Check |
| vd_balance | decimal(10) | no | Balance |
| vd_hold | logical | no | Payment Hold |
| vd_tax_id | character(30) | no | Tax ID |
| vd_taxable | logical | no | Taxable |
| vd_user1 | character(80) | no | Ufld1 |
| vd_user2 | character(80) | no | Ufld2 |
| vd_curr | character(30) | no | Currency |
| vd_lang | character(30) | no | Language |
| vd_vt_id | character(30) | no | VAT ID |
| vd__chr01 | character(80) | no | |
| vd__chr02 | character(80) | no | |
| vd__chr03 | character(80) | no | |
| vd__chr04 | character(80) | no | |
| vd__chr05 | character(80) | no | |
| vd__chr06 | character(80) | no | |
| vd__chr07 | character(80) | no | |
| vd__chr08 | character(80) | no | |
| vd__chr09 | character(80) | no | |
| vd__chr10 | character(80) | no | |
| vd__dte01 | date | no | |
| vd__dte02 | date | no | |
| vd__dec01 | decimal(10) | no | |
| vd__dec02 | decimal(10) | no | |
| vd__log01 | logical | no | |
| vd_fob | character(30) | no | FOB |
| vd_debtor | character(30) | no | Debtor Number |
| vd_bank | character(30) | no | Bank |
| vd_ckfrm | character(30) | no | Check Form |
| vd_pay_spec | logical | no | Pay Specification |
| vd_remit | character(80) | no | Remit-to |
| vd_type | character(30) | no | Type |
| vd_mod_date | date | no | Modified Date |
| vd_userid | character(80) | no | User ID |
| vd_prepay | decimal(10) | no | Prepayment Balance |
| vd_conrep_logic | character(30) | no | Consume/Replace Logic |
| vd_pr_list | character(80) | no | Disc Tbl |
| vd_fr_list | character(80) | no | Freight List |
| vd_fr_terms | character(80) | no | Freight Terms |
| vd_fr_min_wt | decimal(0) | no | Min Frt Wt |
| vd_drft_bal | decimal(10) | no | Draft Balance |
| vd_lc_bal | decimal(10) | no | LC Balance |
| vd_pr_list2 | character(80) | no | Price Tbl |
| vd_fix_pr | logical | no | Fixed Price |
| vd_tid_notice | character(30) | no | TID Notice |
| vd_promo | character(80) | no | Promotion Group |
| vd_misc_cr | logical | no | Miscellaneous Creditor |
| vd_rcv_so_price | logical | no | Send SO Price |
| vd_rcv_held_so | logical | no | Send Credit Held SO |
| vd_tp_use_pct | logical | no | Use SO Reduction Price |
| vd_tp_pct | decimal(10) | no | SO Price Reduction |
| vd_ex_ratetype | character(80) | no | Rate Type |
| vd_db | character(30) | no | DB Number |
| vd__qadc01 | character(80) | no | QAD Field |
| vd__qadc02 | character(80) | no | QAD Field |
| vd__qadc03 | character(80) | no | QAD Field |
| vd__qadc04 | character(80) | no | QAD Field |
| vd__qadd01 | decimal(10) | no | |
| vd__qadd02 | decimal(10) | no | |
| vd__qadl01 | logical | no | |
| vd__qadl02 | logical | no | |
| vd__qadt01 | date | no | |
| vd__qadt02 | date | no | |
| vd__qadi01 | integer | no | |
| vd__qadi02 | integer | no | |
| vd__qadl03 | logical | no | |
| vd__qadl04 | logical | no | |
| vd_ap_sub | character(80) | no | AP Sub-Account |
| vd_pur_sub | character(80) | no | Pur Sub-Acct |
| vd_tot_terms_code | character(80) | no | Terms of Trade |
| vd_domain | character(8) | yes | Domain |
| oid_vd_mstr | decimal(10) | no | |
| vd_carrier_id | character(8) | no | Carrier |
| vd_kanban_supplier | logical | no | Kanban Supplier |
| oid_btr_mstr | decimal(10) | no | |
| vd_active | logical | no | Indicates if this supplier is currently active |
| vd_data_complete | logical | no | Indicates if the data for this supplier is currentlt complete |
| vd_tax_zone | character(16) | no | Tax Zone |
| vd_taxc | character(30) | no | Tax Class |
| vd_tax_usage | character(8) | no | Tax Usage |
| vd_gst_id | character(18) | no | Tax ID - Federal |
| vd_pst_id | character(18) | no | Tax ID - State |
| vd_misc1_id | character(18) | no | Tax ID - Misc 1 |
| vd_misc2_id | character(18) | no | Tax ID - Misc 2 |
| vd_misc3_id | character(18) | no | Tax ID - Misc 3 |
| vd_tax_in | logical | no | Tax In |
| vd_tax_in_city | logical | no | In City |
| vd_daybookset | character(8) | no | Daybook Set |
| vd_site | character(8) | no | Site |
| 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 |