| field name | data type | mnd. | description |
|---|---|---|---|
| po_nbr | character(80) | yes | Purchase Order |
| po_vend | character(80) | no | Supplier |
| po_ship | character(80) | no | Ship-To |
| po_ord_date | date | no | Order Date |
| po_rmks | character(80) | no | Remarks |
| po_cr_terms | character(80) | no | Credit Terms |
| po_buyer | character(80) | no | Buyer |
| po_shipvia | character(30) | no | Ship Via |
| po_fob | character(30) | no | FOB |
| po_bill | character(80) | no | Bill-To |
| po__qad04 | logical | no | |
| po_partial | logical | no | Partial OK |
| po_rev | decimal(10) | no | Order Revision |
| po_stat | character(30) | no | Status |
| po_ap_acct | character(80) | no | AP Acct |
| po_ap_cc | character(30) | no | Cost Ctr |
| po_frt | decimal(10) | no | Freight |
| po_serv_chg | decimal(10) | no | Service Charge |
| po_spec_chg | decimal(10) | no | Special Charge |
| po_disc_pct | decimal(10) | no | Disc % |
| po_prepaid | decimal(10) | no | Amount Prepaid |
| po_contact | character(30) | no | Contact |
| po_confirm | logical | no | Confirming |
| po_cmtindx | integer | no | Comment Index |
| po_print | logical | no | Print PO |
| po_cls_date | date | no | Close Date |
| po_taxable | logical | no | Taxable |
| po_user1 | character(80) | no | Ufld1 |
| po_user2 | character(80) | no | Ufld2 |
| po_curr | character(30) | no | Currency |
| po_ex_rate | decimal(10) | no | Exch Rate |
| po_lang | character(30) | no | Language |
| po_fst_id | character(30) | no | FST ID |
| po_pst_id | character(30) | no | PST ID |
| po_pst | logical | no | PST |
| po_duty_type | character(30) | no | Duty Type |
| po__qad05 | decimal(10) | no | |
| po__qad07 | character(80) | no | |
| po__qad08 | character(30) | no | |
| po_site | character(80) | no | Site |
| po_blanket | character(80) | no | Blanket Order |
| po_rev_date | date | no | Order Revision Date |
| po__qad02 | integer | no | |
| po__qad03 | character(80) | no | |
| po_contract | character(30) | no | Contract |
| po_del_to | character(30) | no | Deliver To |
| po_due_date | date | no | Due Date |
| po_eff_strt | date | no | Start Effective |
| po_eff_to | date | no | End Effective |
| po_est_value | decimal(10) | no | Est Value |
| po__qad06 | logical | no | |
| po_project | character(80) | no | Project |
| po_rel_nbr | integer | no | Rel |
| po_req_id | character(80) | no | Req By |
| po_type | character(30) | no | Type |
| po_user_id | character(80) | no | Entered By |
| po__qad09 | decimal(10) | no | |
| po_release | logical | no | Release |
| po_recurr | logical | no | Recurr |
| po_cycl | character(30) | no | Cycle Code |
| po__chr01 | character(80) | no | |
| po__chr02 | character(80) | no | |
| po__chr03 | character(80) | no | |
| po__chr04 | character(80) | no | |
| po__chr05 | character(80) | no | |
| po__chr06 | character(80) | no | |
| po__chr07 | character(80) | no | |
| po__chr08 | character(80) | no | |
| po__chr09 | character(80) | no | |
| po__chr10 | character(80) | no | |
| po__dte01 | date | no | |
| po__dte02 | date | no | |
| po__dec01 | decimal(10) | no | |
| po__dec02 | decimal(10) | no | |
| po__log01 | logical | no | |
| po_inv_mthd | character(80) | no | Invoices Via |
| po_fix_rate | logical | no | Fixed Rate |
| po_ent_ex | decimal(10) | no | Exch Rate |
| po_tax_date | date | no | Tax Date |
| po_fsm_type | character(80) | no | FSM Type |
| po_bank | character(30) | no | Bank |
| po_pr_list | character(80) | no | Disc Tbl |
| po_tax_env | character(30) | no | Tax Environment |
| po_sched | logical | no | Scheduled |
| po_pr_list2 | character(80) | no | Price Tbl |
| po_tax_usage | character(80) | no | Tax Usage |
| po_fix_pr | logical | no | Fixed Price |
| po_sch_mthd | character(30) | no | Schedules Via |
| po_taxc | character(30) | no | Tax Class |
| po_priced_dt | date | no | Last Price Dt |
| po_pricing_dt | date | no | Pricing Date |
| po_ers_opt | character(30) | no | ERS Option |
| po_pr_lst_tp | integer | no | ERS Price List Option |
| po_consign_cost_point | character(80) | no | PO Cost Point |
| po__qadc02 | character(80) | no | QAD Field |
| po__qadd01 | decimal(10) | no | QAD Field |
| po__qadd02 | decimal(10) | no | QAD Field |
| po_zero_sched | integer | no | Zero Schedules |
| po__qadi02 | integer | no | QAD Field |
| po_so_nbr | character(80) | no | Primary SO |
| po_is_btb | logical | no | EMT PO |
| po_so_hold | logical | no | Secondary SO Cr Hold |
| po_xmit | character(30) | no | Transm |
| po_ex_rate2 | decimal(10) | no | Exch Rate 2 |
| po_ex_ratetype | character(80) | no | Rate Type |
| po_exru_seq | integer | no | Sequence |
| po_ap_sub | character(80) | no | AP Sub-Acct |
| po_crt_int | decimal(10) | no | Credit Terms Int |
| po_consignment | logical | no | Consignment |
| po_max_aging_days | integer | no | Maximum Aging Days |
| po_app_owner | character(30) | no | Owner Application |
| po_tot_terms_code | character(80) | no | Terms of Trade |
| po_translt_days | decimal(10) | no | Transport Days |
| po_domain | character(8) | yes | Domain |
| oid_po_mstr | decimal(10) | no | |
| po_trade_sale | logical | no | Trade Sales Contract |
| po_trade_sale_so | character(16) | no | Trade Sales SO |
| po_incl_iss | logical | no | Include Saturday/Sunday |
| po__qadc03 | character(24) | no | |
| po__qadi03 | integer | no | QAD Field |
| po__qadt01 | date | no | |
| po_daybookset | character(8) | no | Daybook Set |
| po_nrm | character(8) | no | Sequence ID |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| pod_nbr | character(80) | yes | Purchase Order |
| pod_due_date | date | no | Due Date |
| pod_line | integer | no | Line |
| pod_part | character(30) | no | Item Number |
| pod_qty_ord | decimal(10) | no | Qty Ordered |
| pod_qty_rcvd | decimal(10) | no | Qty Received |
| pod_pur_cost | decimal(10) | no | Purchase Cost |
| pod_std_cost | decimal(10) | no | Std Cost |
| pod_so_job | character(80) | no | Sales/Job |
| pod_qty_chg | decimal(10) | no | Receipt Qty |
| pod_cost_chg | decimal(10) | no | Receipt Cost |
| pod_bo_chg | decimal(10) | no | Qty B/O |
| pod_acct | character(80) | no | Pur Acct |
| pod_per_date | date | no | Perform Date |
| pod_type | character(30) | no | Type |
| pod_insp_rqd | logical | no | Inspect Req |
| pod_wo_lot | character(80) | no | Work Order ID |
| pod_vpart | character(80) | no | Supplier Item |
| pod_need | date | no | Need Date |
| pod_taxable | logical | no | Taxable |
| pod_desc | character(80) | no | Description |
| pod_cc | character(30) | no | Cost Ctr |
| pod_um | character(30) | no | UM |
| pod_disc_pct | decimal(10) | no | Disc% |
| pod_req_nbr | character(80) | no | Req |
| pod__qad10 | character(80) | no | |
| pod_um_conv | decimal(10) | no | UM Conversion |
| pod_loc | character(80) | no | Location |
| pod_serial | character(50) | no | Lot/Serial |
| pod_op | integer | no | Operation |
| pod_contract | character(80) | no | Contract |
| pod_status | character(30) | no | Status |
| pod_rev | character(30) | no | Item Revision |
| pod_cmtindx | integer | no | Comment Index |
| pod_req_line | integer | no | Req Line |
| pod_project | character(80) | no | Project |
| pod_ps_chg | decimal(10) | no | Packing Slip Qty |
| pod_cst_up | logical | no | Update Current Cost |
| pod_rum | character(30) | no | UM |
| pod_user1 | character(80) | no | Ufld1 |
| pod_user2 | character(80) | no | Ufld2 |
| pod_vat | logical | no | VAT |
| pod__qad16 | character(80) | no | |
| pod__qad06 | character(30) | no | |
| pod_pst | logical | no | PST |
| pod__qad13 | logical | no | |
| pod__qad07 | character(30) | no | |
| pod_pay_um | character(30) | no | Pay UM |
| pod_pum_conv | decimal(10) | no | Pay UM Conv |
| pod__qad15 | logical | no | |
| pod_site | character(80) | no | Site |
| pod_rum_conv | decimal(10) | no | UM Conversion |
| pod_qty_rtnd | decimal(10) | no | Qty Returned |
| pod_blanket | character(80) | no | Blanket |
| pod_blnkt_ln | integer | no | Blanket Line |
| pod_item_rev_date | date | no | Item Revision Date |
| pod__qad02 | integer | no | |
| pod__qad03 | character(80) | no | |
| pod__qad05 | logical | no | |
| pod__qad08 | date | no | |
| pod__qad09 | integer | no | |
| pod__qad11 | character(80) | no | |
| pod__qad12 | logical | no | |
| pod__qad14 | date | no | |
| pod_rel_nbr | integer | no | Rel |
| pod_rel_qty | decimal(10) | no | Qty Released |
| pod_reason | character(80) | no | Reason |
| pod_request | character(80) | no | Requested By |
| pod_approve | character(80) | no | Approved By |
| pod__chr01 | character(80) | no | |
| pod__chr02 | character(80) | no | |
| pod__chr03 | character(80) | no | |
| pod__chr04 | character(80) | no | |
| pod__chr05 | character(80) | no | |
| pod__chr06 | character(80) | no | |
| pod__chr07 | character(80) | no | |
| pod__chr08 | character(80) | no | |
| pod__chr09 | character(80) | no | |
| pod__chr10 | character(80) | no | |
| pod__dte01 | date | no | |
| pod__dte02 | date | no | |
| pod__dec01 | decimal(10) | no | |
| pod__dec02 | decimal(10) | no | |
| pod__log01 | logical | no | |
| pod_rma_type | character(30) | no | RMA Type |
| pod_tax_max | decimal(10) | no | Max Taxable Amount |
| pod_contr_id | character(80) | no | Contract ID |
| pod_apr_code | character(80) | no | Approval Code |
| pod_taxc | character(30) | no | Tax Class |
| pod_po_site | character(80) | no | PO Site |
| pod_po_db | character(80) | no | PO Database |
| pod_firm_weeks | integer | no | Firm Weeks |
| pod_mrp_pct | decimal(10) | no | Supply Percent |
| pod_raw_weeks | integer | no | Raw Auth Weeks |
| pod_fab_weeks | integer | no | Fab Auth Weeks |
| pod_plan_weeks | integer | no | Plan Sched Weeks |
| pod_sched | logical | no | Scheduled |
| pod_ord_mult | decimal(0) | no | Std Pack Qty |
| pod_pkg_code | character(30) | no | Pkg Code |
| pod_sch_mrp | logical | no | Sched MRP Req |
| pod_sch_data | character(80) | no | Schedule Data |
| pod_rlse_nbr | integer | no | Next Release ID |
| pod_ship_weeks | integer | no | Ship Sched Weeks |
| pod_translt_days | decimal(10) | no | Transport Days |
| pod_fsm_type | character(80) | no | FSM Type |
| pod_sd_pat | character(30) | no | Ship/Dlvy Pattern |
| pod_sd_time | character(30) | no | Ship/Dlvy Time |
| pod_plan_days | integer | no | Plan Sched Days |
| pod_plan_mths | integer | no | Plan Sched Months |
| pod_firm_days | integer | no | Firm Days |
| pod_raw_days | integer | no | Raw Auth Days |
| pod_fab_days | integer | no | Fab Auth Days |
| pod_tax_usage | character(80) | no | Tax Usage |
| pod_tax_in | logical | no | Tax In |
| pod_sched_chgd | logical | no | Scheduled |
| pod_pr_list | character(80) | no | Price List |
| pod_dock | character(80) | no | Dock |
| pod_pastdue | character(30) | no | Past Due Logic |
| pod_drp_ref | character(80) | no | DRP Ref |
| pod_tax_env | character(30) | no | Tax Environment |
| pod_crt_int | decimal(10) | no | Credit Terms Int |
| pod_translt_hrs | decimal(10) | no | Transport Hours |
| pod_sftylt_days | decimal(10) | no | Safety Days |
| pod_sftylt_hrs | decimal(10) | no | Safety Hours |
| pod_fix_pr | logical | no | Fixed Price |
| pod_fr_list | character(80) | no | Freight List |
| pod_lot_next | character(30) | no | Next Lot/Serial |
| pod_lot_rcpt | logical | no | Single Lot |
| pod_grade | character(30) | no | Grade |
| pod_expire | date | no | Expire Date |
| pod_rctstat | character(80) | no | Receipt Status |
| pod_assay | decimal(10) | no | Assay % |
| pod_rctstat_active | logical | no | Active |
| pod_pricing_dt | date | no | Pricing Date |
| pod_pr_lst_tp | integer | no | ERS Price List Option |
| pod_ers_opt | integer | no | ERS Option |
| pod_zero_sched_count | decimal(10) | no | Zero Schedule Counter |
| pod__qadd02 | decimal(10) | no | QAD Field |
| pod__qadd03 | decimal(10) | no | QAD Field |
| pod_sod_line | integer | no | Primary SO Line |
| pod_so_status | character(30) | no | Secondary SO Status |
| pod_sub_ship_date | date | no | Subcontract Ship |
| pod_sub_type | character(80) | no | Subcontract Type |
| pod_sub | character(80) | no | Pur Sub-Acct |
| pod_wip_lotser | character(30) | no | Lot/Serial |
| pod_pjs_line | integer | no | Project Line |
| pod_consignment | logical | no | Consignment |
| pod_max_aging_days | integer | no | Maximum Aging Days |
| pod_multi_due_dates | logical | no | Multi Due Dates |
| pod_domain | character(8) | yes | Domain |
| oid_pod_det | decimal(10) | no | |
| pod__qadd04 | decimal(10) | no | QAD Field |
| pod__qadt01 | date | no | |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tpo_mstr.tc_Rowid |
| 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 |