Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FPBPOHD Finance
SGHE Banner Operational Data Store Composite View Source: FPBPOHD - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
FPBPOHD_ACTIVITY_DATE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

ACTIVITY_DATE

 
FPBPOHD_ADDL_CHRG_AMT FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

ADDITIONAL_AMOUNT

 
FPBPOHD_APPR_IND FPIPOHD COMPOSITE VIEW

AF_PURCHASE_ORDER

APPROVAL_IND

NA
FPBPOHD_ATYP_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

ORDER_FROM_ADDRESS_TYPE

NA
FPBPOHD_ATYP_SEQ_NUM FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

ORDER_FROM_ADDRESS_TYPE_NUMBER

NA
FPBPOHD_BLANKET_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

BLANKET_ORDER

 
FPBPOHD_BLANKET_IND FPAPURR       NA
FPBPOHD_BUYR_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

BUYER

NA
FPBPOHD_CANCEL_DATE FPAPDEL COMPOSITE VIEW

AF_PURCHASE_ORDER

CANCEL_DATE

NA
FPBPOHD_CANCEL_IND FPAPURR       NA
FPBPOHD_CARRIER_PIDM FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

CARRIER_UID

 
FPBPOHD_CHANGE_SEQ_NUM FPACHAR       NA
FPBPOHD_CLOSED_DATE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

CLOSED_DATE

 
FPBPOHD_CLOSED_IND NA       NA
FPBPOHD_COAS_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

CHART_OF_ACCOUNTS

NA
FPBPOHD_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

PURCHASE_ORDER

NA
FPBPOHD_COMPLETE_IND FPIPOHD COMPOSITE VIEW

AF_PURCHASE_ORDER

COMPLETE_IND

NA
FPBPOHD_COPIED_FROM FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

COPIED_PURCHASE_ORDER

 
FPBPOHD_CRSN_CODE FPAPDEL COMPOSITE VIEW

AF_PURCHASE_ORDER

CANCEL_REASON

NA
FPBPOHD_DISC_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

DISCOUNT

 
FPBPOHD_DOC_REF_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

THIRD_PARTY_DOCUMENT

 
FPBPOHD_EDI_IND NA       NA
FPBPOHD_EMAIL_ADDR FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUESTOR_EMAIL_ADDRESS

 
FPBPOHD_FAX_AREA FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUESTOR_FAX_AREA

 
FPBPOHD_FAX_EXT FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUESTOR_FAX_EXT

 
FPBPOHD_FAX_NUMBER FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUESTOR_FAX_NUMBER

 
FPBPOHD_FTRM_CODE NA COMPOSITE VIEW

AF_PURCHASE_ORDER

FREIGHT_TERMS

NA
FPBPOHD_MATCH_REQUIRED FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

RECEIVING_REQUIRED

 
FPBPOHD_NAME FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

AF_PURCHASE_ORDER_ITEM

REQUESTOR_NAME

REQUESTOR_NAME

 
FPBPOHD_ORGN_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

ORGANIZATION_CODE

NA
FPBPOHD_ORIGIN_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

DOCUMENT_SOURCE

 
FPBPOHD_PCLS_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

PURCHASE_ORDER_CLASS

 
FPBPOHD_PHONE_AREA FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUESTOR_PHONE_AREA

 
FPBPOHD_PHONE_EXT FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUESTOR_PHONE_EXT

 
FPBPOHD_PHONE_NUM FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUESTOR_PHONE_NUMBER

 
FPBPOHD_PO_DATE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

PURCHASE_ORDER_DATE

NA
FPBPOHD_PO_PRINTED_DATE FPIPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

PRINTED_DATE

NA
FPBPOHD_PO_TYPE_IND FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

PURCHASE_ORDER_TYPE

NA
FPBPOHD_PRINT_IND NA       NA
FPBPOHD_REQD_DATE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUIRED_DATE

NA
FPBPOHD_REQ_BID_IND FPAPOAS COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUISITION_OR_BID_SOURCE

 
FPBPOHD_RUSH_AMT FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

RUSH_AMOUNT

 
FPBPOHD_RUSH_IND FPARORD COMPOSITE VIEW

AF_PURCHASE_ORDER

RUSH_ORDER_IND

 
FPBPOHD_SHIP_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

SHIPPING_ADDRESS

NA
FPBPOHD_TEXT_IND FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUISITION_TEXT

 
FPBPOHD_TRANS_DATE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

TRANSACTION_DATE

NA
FPBPOHD_USER_ID FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

PURCHASE_ORDER_USER_ID

NA
FPBPOHD_VENDOR_CONTACT FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

VENDOR_CONTACT

 
FPBPOHD_VEND_EMAIL_ADDR FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

VENDOR_EMAIL_ADDRESS

 
FPBPOHD_VEND_PIDM NA COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

AF_PURCHASE_ORDER

VENDOR_UID

VENDOR_UID

NA


Ver: 8.0