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 |