|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_po_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
po__chr01
|
|
|
x(8)
|
|
|
|
po__chr02
|
|
|
x(8)
|
|
|
|
po__chr03
|
|
|
x(8)
|
|
|
|
po__chr04
|
|
|
x(8)
|
|
|
|
po__chr05
|
|
|
x(8)
|
|
|
|
po__chr06
|
|
|
x(8)
|
|
|
|
po__chr07
|
|
|
x(8)
|
|
|
|
po__chr08
|
|
|
x(8)
|
|
|
|
po__chr09
|
|
|
x(8)
|
|
|
|
po__chr10
|
|
|
x(8)
|
|
|
|
po__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
po__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
po__dte01
|
|
|
99/99/99
|
|
|
|
po__dte02
|
|
|
99/99/99
|
|
|
|
po__log01
|
|
|
yes/no
|
|
|
|
po__qad02
|
|
|
>>9
|
|
|
|
po__qad03
|
|
|
99:99:99
|
|
|
|
po__qad04
|
|
|
yes/no
|
|
|
|
po__qad05
|
|
|
->>9.99%
|
10
|
|
|
po__qad06
|
|
|
yes/no
|
|
|
|
po__qad07
|
|
|
x(8)
|
|
|
|
po__qad08
|
|
|
x(4)
|
|
|
|
po__qad09
|
|
|
->>,>>>,>>9.99
|
10
|
|
|
po__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
po__qadc03
|
|
|
x(24)
|
|
|
|
po__qadd01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
po__qadd02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
po__qadi02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
po__qadi03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
po__qadt01
|
|
|
99/99/99
|
|
|
|
po_ap_acct
|
AP Acct
|
|
x(8)
|
|
|
|
po_ap_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
po_ap_sub
|
AP Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
po_app_owner
|
Owner Application
|
|
x(12)
|
|
|
|
po_bank
|
Bank
|
|
x(2)
|
|
|
|
po_bill
|
Bill-To
|
|
x(8)
|
|
|
|
po_blanket
|
Blanket Order
|
Blanket
|
x(8)
|
|
|
|
po_buyer
|
Buyer
|
|
x(8)
|
|
|
|
po_cls_date
|
Close Date
|
Closed
|
99/99/99
|
|
|
|
po_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
po_confirm
|
Confirming
|
Confirm
|
yes/no
|
|
|
|
po_consign_cost_point
|
PO Cost Point
|
|
X(8)
|
0
|
|
|
po_consignment
|
Consignment
|
|
yes/no
|
|
|
|
po_contact
|
Contact
|
|
x(24)
|
|
|
|
po_contract
|
Contract
|
|
x(18)
|
|
|
|
po_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
po_crt_int
|
Credit Terms Int
|
CRT Int
|
->>>9.99
|
10
|
|
|
po_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
po_cycl
|
Cycle Code
|
Cycl
|
x(2)
|
|
|
|
po_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
po_del_to
|
Deliver To
|
Delv To
|
x(4)
|
|
|
|
po_disc_pct
|
Disc %
|
|
->9.99%
|
10
|
|
|
po_domain
|
Domain
|
|
x(8)
|
|
|
|
po_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
po_duty_type
|
Duty Type
|
Dty
|
x(1)
|
|
|
|
po_eff_strt
|
Start Effective
|
Start Eff
|
99/99/99
|
|
|
|
po_eff_to
|
End Effective
|
End Eff
|
99/99/99
|
|
|
|
po_ent_ex
|
Exch Rate
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
po_ers_opt
|
ERS Option
|
ERS!Opt
|
x(2)
|
|
|
|
po_est_value
|
Est Value
|
Est Val
|
->>,>>>,>>9.99
|
10
|
|
|
po_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
po_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
po_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
po_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
po_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
po_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
po_fob
|
FOB
|
|
x(20)
|
|
|
|
po_frt
|
Freight
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
po_fsm_type
|
FSM Type
|
|
x(8)
|
|
|
|
po_fst_id
|
FST ID
|
|
x(18)
|
|
|
|
po_incl_iss
|
Include Saturday/Sunday
|
|
yes/no
|
|
|
|
po_inv_mthd
|
Invoices Via
|
|
x(1)
|
|
|
|
po_is_btb
|
EMT PO
|
|
yes/no
|
|
|
|
po_lang
|
Language
|
|
x(2)
|
|
|
|
po_max_aging_days
|
Maximum Aging Days
|
Maximum!Aging Days
|
>>9
|
|
|
|
po_nbr
|
Purchase Order
|
Order
|
x(8)
|
|
|
|
po_nrm
|
Sequence ID
|
Seq ID
|
x(8)
|
|
|
|
po_ord_date
|
Order Date
|
Date
|
99/99/99
|
|
|
|
po_partial
|
Partial OK
|
Partial
|
yes/no
|
|
|
|
po_pr_list
|
Disc Tbl
|
|
x(8)
|
|
|
|
po_pr_list2
|
Price Tbl
|
Pr Tbl
|
x(8)
|
|
|
|
po_pr_lst_tp
|
ERS Price List Option
|
ERS!PLO
|
>9
|
|
|
|
po_prepaid
|
Amount Prepaid
|
Prepaid
|
->,>>>,>>>,>>9.99
|
10
|
|
|
po_priced_dt
|
Last Price Dt
|
Last Pri
|
99/99/99
|
|
|
|
po_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
po_print
|
Print PO
|
Print
|
yes/no
|
|
|
|
po_project
|
Project
|
|
x(8)
|
|
|
|
po_pst
|
PST
|
|
yes/no
|
|
|
|
po_pst_id
|
PST ID
|
|
x(18)
|
|
|
|
po_recurr
|
Recurr
|
Recu
|
yes/no
|
|
|
|
po_rel_nbr
|
Rel
|
|
>>9
|
|
|
|
po_release
|
Release
|
Rel
|
yes/no
|
|
|
|
po_req_id
|
Req By
|
|
x(8)
|
|
|
|
po_rev
|
Order Revision
|
Order Rev
|
>>9
|
10
|
|
|
po_rev_date
|
Order Revision Date
|
Order Rev Date
|
99/99/99
|
|
|
|
po_rmks
|
Remarks
|
|
x(40)
|
|
|
|
po_sch_mthd
|
Schedules Via
|
|
x(1)
|
|
|
|
po_sched
|
Scheduled
|
|
yes/no
|
|
|
|
po_serv_chg
|
Service Charge
|
Service
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
po_ship
|
Ship-To
|
|
x(8)
|
|
|
|
po_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
po_site
|
Site
|
|
x(8)
|
|
|
|
po_so_hold
|
Secondary SO Cr Hold
|
SO Cr Hd
|
yes/no
|
|
|
|
po_so_nbr
|
Primary SO
|
Pr SO
|
x(8)
|
|
|
|
po_spec_chg
|
Special Charge
|
Special
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
po_stat
|
Status
|
St
|
x(2)
|
|
|
|
po_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
po_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
po_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
po_tax_pct[3]
|
Tax
|
|
->9.99<%
|
10
|
|
|
po_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
po_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
po_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
po_tot_terms_code
|
Terms of Trade
|
|
x(8)
|
|
|
|
po_trade_sale
|
Trade Sales Contract
|
|
yes/no
|
|
|
|
po_trade_sale_so
|
Trade Sales SO
|
TS SO
|
x(8)
|
|
|
|
po_translt_days
|
Transport Days
|
|
>>9.99
|
10
|
|
|
po_type
|
Type
|
Tp
|
x(1)
|
|
|
|
po_user_id
|
Entered By
|
Ent By
|
x(8)
|
|
|
|
po_user1
|
Ufld1
|
|
x(8)
|
|
|
|
po_user2
|
Ufld2
|
|
x(8)
|
|
|
|
po_vend
|
Supplier
|
|
x(8)
|
|
|
|
po_xmit
|
Transm
|
|
X
|
|
|
|
po_zero_sched
|
Zero Schedules
|
Zero Schedules
|
>>9
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_po_mstr
|
yes
|
oid_po_mstr
|
yes
|
no
|
|
|
po_buyer
|
no
|
po_domain
|
yes
|
no
|
|
|
|
|
po_buyer
|
yes
|
no
|
|
|
|
|
po_vend
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
|
po_fsm_type
|
no
|
po_domain
|
yes
|
no
|
|
|
|
|
po_fsm_type
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
∗
|
po_nbr
|
yes
|
po_domain
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
|
po_type
|
yes
|
po_domain
|
yes
|
no
|
|
|
|
|
po_type
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
|
po_vend
|
no
|
po_domain
|
yes
|
no
|
|
|
|
|
po_vend
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|