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

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

AF_PURCHASE_ORDER_ITEM

ACTIVITY_DATE

 
FPRPODT_ADDL_CHRG_AMT FPAPURR       NA
FPRPODT_AGRE_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

VENDOR_AGREEMENT

 
FPRPODT_BO_REMAIN_BAL NA COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

BLANKET_ORDER_REMAINING_BAL

NA
FPRPODT_CANCEL_DATE NA COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

CANCEL_DATE

NA
FPRPODT_CANCEL_IND NA COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

CANCEL_IND

NA
FPRPODT_CLOSED_IND NA COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

CLOSED_IND

NA
FPRPODT_COMM_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

COMMODITY

NA
FPRPODT_COMM_DESC FPAPURR       NA
FPRPODT_CONVERT_ADDL_CHRG_AMT FPAPURR       NA
FPRPODT_CONVERT_DISC_AMT FPAPURR       NA
FPRPODT_CONVERT_TAX_AMT FPAPURR       NA
FPRPODT_CONVERT_UNIT_PRICE FPAPURR       NA
FPRPODT_DISC_AMT FPAPURR       NA
FPRPODT_EXT_AMT FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

CHANGE_ORDER_AMOUNT

 
FPRPODT_ITEM FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

ITEM

NA
FPRPODT_LIQ_AMT NA       NA
FPRPODT_POHD_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

PURCHASE_ORDER

NA
FPRPODT_QTY FPAPURR       NA
FPRPODT_REQD_DATE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

ITEM_DELIVERY_DATE

 
FPRPODT_SHIP_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

SHIPMENT_TO_ADDRESS

NA
FPRPODT_SUSP_IND FPIPORS COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

SUSPENSE_IND

NA
FPRPODT_TAX_AMT FPAPURR       NA
FPRPODT_TEXT_USAGE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

TEXT_USAGE

 
FPRPODT_TGRP_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

TAX_GROUP

NA
FPRPODT_UNIT_PRICE FPAPURR       NA
FPRPODT_UOMS_CODE FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

UNIT_OF_MEASURE

NA
FPRPODT_USER_ID FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

USER_ID

 
FPRPODT_VEND_REF_NUM FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

VENDOR_REFERENCE_NUMBER

NA


Ver: 8.1