View Name:po_curr_contr_v
View Number:5842
Group:Morder
Description:Provides purchase order details of contract. Used in immediate payment.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpurchase_ordobjidInternal record number of purchase_ord 3 (UNIQUE)
paymeans_objidpay_meansobjidInternal record number of pay_means 
cntr_objidcontractobjidInternal record number of contract 
currency_objidcurrencyobjidCurrency internal record number 
currency_symbolcurrencysymbolCurrency symbol 
po_idpurchase_ordpo_idThe unique purchase order ID 
po_datepurchase_ordpo_dateThe date identified on the payment method 
statuspurchase_ordstatusThe payment status 
pay_optionpurchase_ordpay_optionThe payment option for this line item; e.g., purchase order, credit card, etc. This is from a user-defined popup with default name PAY_METHOD 
po_amtpurchase_ordpo_amtTotal currency amount of the purchase order 
card_numpurchase_ordcard_numFor credit cards, the credit card number 
cc_namepurchase_ordcc_nameComplete name of the credit card owner as it appears on the card 
cc_typepurchase_ordcc_type The credit card type populated from a user defined pop-up with the title 'cctype' 
cc_exp_mopurchase_ordcc_exp_mo2-digit number of the month when the card expires 
cc_exp_yrpurchase_ordcc_exp_yr2- or 4-digit number of the year in which the credit card expires 

Joins:

Join FromJoin To
(purchase_ord).payment2pay_meansOUTER (pay_means).pay_means2purchase_ord
(purchase_ord).purchase_ord2contract(contract).contract2purchase_ord
(contract).contract2currency(currency).currency2contract
My Recent Objects
po_curr_contr_v