View Name:req_to_extern_view
View Number:5838
Group:Billing Manager
Description:The view is for the External Request Overview page and it is needed in order to load data into this page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
re_objidreq_to_externobjidReq_to_extern internal record number 
re_req_typereq_to_externreq_typeType of request 
re_descriptionreq_to_externdescriptionDescription of activity that created the request 
re_statusreq_to_externstatusStatus of request, 0=Hold, 1=Ready for send, 2=Waiting for approval,3=Sent, 4=Done, 5=Failed, 6=Rejected; Default - 1 
re_creation_timereq_to_externcreation_timeCreation date and time 
re_addnl_inforeq_to_externaddnl_infoXML string that captures additional information needed for the request to be sent 
re_is_readyreq_to_externis_ready1=Ready to be send, 0=Not read, Default=0 
pm_objidpay_meansobjidPay_means internal record number 
pm_bank_namepay_meansbank_nameName of the bank 
pm_cc_typepay_meanscc_typeFor credit cards, the credit card type populated from a user defined pop-up with the title 'cctype' 
pm_last_fourpay_meanslast_fourLast four digits of the pay_means id_number 
bus_objidbus_orgobjidBus_org internal record number 
bus_namebus_orgnameName of the organization 
bus_org_idbus_orgorg_idUser-specified ID number of the organization 
fa_objidfin_accntobjidFin_accnt internal record number 
fa_namefin_accntnameA name for the financial account, e.g., Monthly charges of sales division 
ppb_objidpp_bucketobjidPp_bucket internal record number 
ppb_namepp_bucketnameA name for the pre paid bucket 
ri_objidrechrg_instrnobjidRechrg_instrn internal record number 
ba_objidblg_argmntobjidblg_argmnt internal record number 
ba_nameblg_argmntnameName of billing arrangement 

Joins:

Join FromJoin To
(req_to_extern).req_to_extern2fin_accntOUTER (fin_accnt).fin_accnt2req_to_extern
(req_to_extern).req_to_extern2blg_argmntOUTER (blg_argmnt).blg_argmnt2req_to_extern
(req_to_extern).req_to_extern2pp_bucketOUTER (pp_bucket).pp_bucket2req_to_extern
(req_to_extern).req_to_extern2bus_orgOUTER (bus_org).bus_org2req_to_extern
(req_to_extern).req_to_extern2pay_meansOUTER (pay_means).pay_means2req_to_extern
(req_to_extern).req_to_extern2rechrg_instrnOUTER (rechrg_instrn).rechrg_instrn2req_to_extern
My Recent Objects
req_to_extern_view