| field name | data type | mnd. | description |
|---|---|---|---|
| qo_nbr | character(80) | yes | Quote |
| qo_cust | character(80) | no | Sold-To |
| qo_ship | character(80) | no | Ship-To |
| qo_ord_date | date | no | Quote Date |
| qo_req_date | date | no | Required Date |
| qo_due_date | date | no | Due Date |
| qo_rmks | character(80) | no | Remarks |
| qo_cr_terms | character(80) | no | Credit Terms |
| qo_fob | character(30) | no | FOB Point |
| qo_po | character(30) | no | Purchase Order |
| qo_shipvia | character(30) | no | Ship Via |
| qo_partial | logical | no | Partial OK |
| qo_print_qo | logical | no | Print Quote |
| qo_pr_list | character(80) | no | Manual |
| qo_source | character(80) | no | Order Source |
| qo_cr_card | character(30) | no | Credit Card |
| qo_print_pl | logical | no | Print Pack List |
| qo_cr_init | character(30) | no | Cr Initials |
| qo_stat | character(30) | no | Action Status |
| qo__qad01 | decimal(10) | no | |
| qo__qad02 | decimal(10) | no | |
| qo__qad03 | decimal(10) | no | Fixed Price |
| qo_disc_pct | decimal(10) | no | Disc % |
| qo_prepaid | decimal(10) | no | Prepaid Amount |
| qo_ar_acct | character(80) | no | AR Account |
| qo_ar_cc | character(30) | no | Cost Ctr |
| qo_ship_date | date | no | Ship Date |
| qo_taxable | logical | no | Taxable |
| qo_cmtindx | integer | no | Comment Index |
| qo__qad04 | integer | no | |
| qo_user1 | character(80) | no | Ufld1 |
| qo_user2 | character(80) | no | Ufld2 |
| qo_so_nbr | character(80) | no | Last Sales Order |
| qo_confirm | date | no | Confirm Date |
| qo_exp_date | date | no | Expires |
| qo_rel_date | date | no | Release Date |
| qo_release | logical | no | Release |
| qo_recur | logical | no | Recurring |
| qo_cycle | character(30) | no | Cycle Code |
| qo_rel_cnt | integer | no | Release Count |
| qo_flw_date | date | no | Follow-up |
| qo_curr | character(30) | no | Currency |
| qo_ex_rate | decimal(10) | no | Exch Rate |
| qo_lang | character(30) | no | Language |
| qo_pst | logical | no | PST |
| qo_fst_id | character(30) | no | FST ID |
| qo_pst_id | character(30) | no | PST ID |
| qo_trl1_amt | decimal(10) | no | Trailer Amt 1 |
| qo_trl1_cd | character(30) | no | Trailer 1 |
| qo_trl2_amt | decimal(10) | no | Trailer 2 |
| qo_trl2_cd | character(30) | no | Trailer 2 |
| qo_trl3_amt | decimal(10) | no | Trailer 3 |
| qo_trl3_cd | character(30) | no | Trailer 3 |
| qo_weight | decimal(10) | no | Weight |
| qo_weight_um | character(30) | no | Weight UM |
| qo_size | decimal(10) | no | Size |
| qo_size_um | character(30) | no | Size UM |
| qo_cartons | integer | no | Cartons |
| qo_bol | character(30) | no | BOL |
| qo_site | character(80) | no | Site |
| qo_taxc | character(30) | no | Tax Class |
| qo__chr01 | character(80) | no | |
| qo__chr02 | character(80) | no | |
| qo__chr03 | character(80) | no | |
| qo__chr04 | character(80) | no | |
| qo__chr05 | character(80) | no | |
| qo__chr06 | character(80) | no | |
| qo__chr07 | character(80) | no | |
| qo__chr08 | character(80) | no | |
| qo__chr09 | character(80) | no | |
| qo__chr10 | character(80) | no | |
| qo__dte01 | date | no | |
| qo__dte02 | date | no | |
| qo__dec01 | decimal(10) | no | PST |
| qo__dec02 | decimal(10) | no | |
| qo__log01 | logical | no | |
| qo_project | character(80) | no | Project |
| qo_rev | integer | no | Revision |
| qo_pst_pct | decimal(10) | no | PST Pct |
| qo_fr_list | character(80) | no | Freight List |
| qo_fr_terms | character(80) | no | Freight Terms |
| qo_fix_rate | logical | no | Fixed Rate |
| qo_ent_ex | decimal(10) | no | Exch Rate |
| qo_bill | character(80) | no | Bill-To |
| qo_print_bl | logical | no | Print Bill of Lading |
| qo_userid | character(80) | no | User ID |
| qo_tax_date | date | no | Tax Date |
| qo_inv_mthd | character(30) | no | Invoicing Method |
| qo_channel | character(80) | no | Channel |
| qo_bank | character(30) | no | Bank |
| qo_fr_min_wt | decimal(10) | no | Frt Min Wt |
| qo_pr_list2 | character(80) | no | Price Tbl |
| qo_tax_env | character(30) | no | Tax Environment |
| qo_tax_usage | character(80) | no | Tax Usage |
| qo_pricing_dt | date | no | Pricing Date |
| qo_priced_dt | date | no | Last Price Dt |
| qo_ex_rate2 | decimal(10) | no | Exch Rate 2 |
| qo_ex_ratetype | character(80) | no | Rate Type |
| qo_div | character(80) | no | Division |
| qo_exru_seq | integer | no | Sequence |
| qo_ar_sub | character(80) | no | AR Sub-Acct |
| qo_app_owner | character(30) | no | Owner Application |
| qo_manual_fr_terms | logical | no | Manual Fr Terms |
| qo_domain | character(8) | yes | Domain |
| oid_qo_mstr | decimal(10) | no | |
| qo_daybookset | character(8) | no | Daybook Set |
| 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 |