Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_PURCHASE_ORDER_ITEM

Description Source composite view contains the cumulative line item detail for each purchase order.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

FPRPODT

FPRPODT_ACTIVITY_DATE

NO

NO
ADDITIONAL_CHARGES_AMOUNT Amount of additional charges for the commodity record. NUMBER

CALCULATION

NVL(FPRPODT_ADDL_CHRG_AMT,0)

NO

NO
AGREEMENT_MINIMUM_QUANTITY The minimum quanity that can be ordered for the specified commodity and unit of measure. NUMBER

FUNCTION

FOKODSF.F_GET_MIN_QUANTITY

NO

NO
APPROVED_ITEM_AMOUNT Calculation to determine the actual cost of an item. NUMBER

CALCULATION

(NVL(FPRPODT_QTY,0)*NVL(FPRPODT_UNIT_PRICE,0))+NVL(FPRPODT_ADDL_CHRG_AMT,0)+NVL(FPRPODT_TAX_AMT,0)-NVL(FPRPODT_DISC_AMT,0)

NO

NO
BID_NUMBER Bid number. VARCHAR2(8)

FPRBIDD

FPRBIDD_BIDH_CODE

NO

NO
BLANKET_ORDER_REMAINING_BAL Contains the remaining balance of the blanket order. NUMBER

FPRPODT

FPRPODT_BO_REMAIN_BAL

NO

NO
BUILDING Name for the building associated with a specific shipping address. VARCHAR2(15)

FTVSHIP

FTVSHIP_BUILDING

NO

NO
CANCEL_DATE Date the purchase order was cancelled. DATE

FPRPODT

FPRPODT_CANCEL_DATE

NO

NO
CANCEL_IND Indicates if the purchase order was canceled. VARCHAR2(1)

FPRPODT

FPRPODT_CANCEL_IND

NO

NO
CARRIER_ROUTE Address carrier route. VARCHAR2(4)

FTVSHIP

FTVSHIP_CARRIER_ROUTE

NO

NO
CHANGE_ORDER_AMOUNT Gross value of the change order. NUMBER

FPRPODT

FPRPODT_EXT_AMT

NO

NO
CITY Address city, town or municipality. VARCHAR2(50)

FTVSHIP

FTVSHIP_CITY

NO

NO
CLOSED_IND Indicates if the document has been closed from an encumbrance perspective. VARCHAR2(1)

FPRPODT

FPRPODT_CLOSED_IND

NO

NO
COMMODITY User-defined code associated with this commodity. VARCHAR2(10)

FPRPODT

FPRPODT_COMM_CODE

NO

NO
COMMODITY_DESC Commodity description or title. VARCHAR2(50)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COMMODITY_DESC_CHANGE_IND Indicates when the default commodity description has been overwritten in the purchase order. VARCHAR2(1)

CALCULATION

NVL(FPRPODT_DESC_CHGE_IND,'N')

NO

NO
CONTACT_NAME Name or title of the primary contact for the ship-to address. Used as an attention-to field. VARCHAR2(35)

FTVSHIP

FTVSHIP_CONTACT

NO

NO
CONVERTED_ADDITNAL_AMOUNT Base currency additional charges amount calculated for this commodity record. NUMBER

CALCULATION

NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)

NO

NO
CONVERTED_APPROVED_ITEM_AMOUNT Calculation to determine the actual converted cost of an item. NUMBER       NO
CONVERTED_DISCOUNT_AMOUNT Base currency discount amount calculated for this commodity record. NUMBER

CALCULATION

NVL(FPRPODT_CONVERT_DISC_AMT,0)

NO

NO
CONVERTED_TAX_AMOUNT Base currency tax amount calculated for this commodity record. NUMBER

CALCULATION

NVL(FPRPODT_CONVERT_TAX_AMT,0)

NO

NO
CONVERTED_UNIT_PRICE Base currency unit price calculated for this commodity record. NUMBER

CALCULATION

NVL(FPRPODT_CONVERT_UNIT_PRICE,0)

NO

NO
CORRECTION_DIGIT Correction digit associated with the address for bar code mailing. NUMBER

FTVSHIP

FTVSHIP_CORRECTION_DIGIT

NO

NO
COUNTY County for this address. VARCHAR2(1)

NA

NA

NO

NO
COUNTY_DESC County name for the address. VARCHAR2(1)

NA

NA

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DELIVERY_POINT Delivery point associated with the address for barcode mailings. NUMBER

FTVSHIP

FTVSHIP_DELIVERY_POINT

NO

NO
DISCOUNT_AMOUNT Value of the discount taken on the invoice or purchase order accounting amount. NUMBER

CALCULATION

NVL(FPRPODT_DISC_AMT,0)

NO

NO
DISCOUNT_PERCENT Extract discount percent for the purchase order from the discount code. NUMBER

FUNCTION

FOKODSF.F_PO_DISC_PCT

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
FLOOR Floor number specific to the shipping address. VARCHAR2(10)

FTVSHIP

FTVSHIP_FLOOR

NO

NO
ITEM System-generated line item number that identifies each commodity line item for procurement documents. NUMBER

FPRPODT

FPRPODT_ITEM

NO

NO
ITEM_CHANGE_ORDER Last change sequence number of the purchase order. NUMBER

FUNCTION

FOKODSF.F_PO_ITEM_LAST_CHANGE_SEQNO

NO

NO
ITEM_DELIVERY_DATE Date given to the vendors as a required deliver by date. DATE

FPRPODT

FPRPODT_REQD_DATE

NO

NO
LIQUIDATION_AMOUNT Amount that has been liquidated against the original encumbrance. NUMBER

CALCULATION

NVL(FPRPODT_LIQ_AMT,0)

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
NATION Nation/country code associated with the address. VARCHAR2(5)

FTVSHIP

FTVSHIP_NATN_CODE

NO

NO
NATION_DESC Address nation/country description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PHONE_AREA Phone area code for the ship-to address. VARCHAR2(6)

FTVSHIP

FTVSHIP_PHONE_AREA

NO

NO
PHONE_EXT Phone extension number for the ship-to address. VARCHAR2(10)

FTVSHIP

FTVSHIP_PHONE_EXT

NO

NO
PHONE_INTL_ACCESS Free format international access code for telephone number including country and city code. VARCHAR2(1)

NA

NA

NO

NO
PHONE_NUMBER Phone number for the ship-to address. VARCHAR2(12)

FTVSHIP

FTVSHIP_PHONE_NUM

NO

NO
PHONE_NUMBER_COMBINED Extracted combined phone number for the ship to address. VARCHAR2(28)

CALCULATION

FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||FTVSHIP_PHONE_EXT

NO

NO
PHONE_UNLIST_IND Specifies if the phone number is to be unlisted. VARCHAR2(1)

NA

NA

NO

NO
POSTAL_CODE Postal code associated with the ship-to address. VARCHAR2(30)

FTVSHIP

FTVSHIP_ZIP_CODE

NO

NO
PURCHASE_ORDER User-defined or system assigned one-up purchase order number issued to this vendor. VARCHAR2(8)

FPRPODT

FPRPODT_POHD_CODE

NO

NO
QUANTITY Number of units ordered. NUMBER

CALCULATION

NVL(FPRPODT_QTY,0)

NO

NO
REQUESTOR_NAME Name of the person who is submitting the purchase order. VARCHAR2(35)

FPBPOHD

FPBPOHD_NAME

NO

NO
REQUISITION User-defined or system assigned one-up requisition number. VARCHAR2(8)

FPRREQD

FPRREQD_REQH_CODE

NO

NO
REQUISITION_NUMBER System assigned one-up number of the commodity on the requisition item. NUMBER

FPRREQD

FPRREQD_ITEM

NO

NO
SHIPMENT_TO_ADDRESS Code representing the shipment address. VARCHAR2(6)

FPRPODT

FPRPODT_SHIP_CODE

NO

NO
STATE_PROVINCE State or province associated with this address. VARCHAR2(3)

FTVSHIP

FTVSHIP_STATE

NO

NO
STATE_PROVINCE_DESC State/province name. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
STREET_LINE1 First line of the address. VARCHAR2(75)

FTVSHIP

FTVSHIP_ADDR_LINE1

NO

NO
STREET_LINE2 Second line of the address. VARCHAR2(75)

FTVSHIP

FTVSHIP_ADDR_LINE2

NO

NO
STREET_LINE3 Third line of the address. VARCHAR2(75)

FTVSHIP

FTVSHIP_ADDR_LINE3

NO

NO
STREET_LINE4 Fourth line of the address. VARCHAR2(30)

NA

NA

NO

NO
SUSPENSE_IND Indicator used to inform the user that a document is being held in suspense due to missing or erroneous data content. VARCHAR2(1)

FPRPODT

FPRPODT_SUSP_IND

NO

NO
TAX_AMOUNT Amount of tax computed or entered for a document item. NUMBER

CALCULATION

NVL(FPRPODT_TAX_AMT,0)

NO

NO
TAX_GROUP Tax group code to be used for this commodity record. VARCHAR2(4)

FPRPODT

FPRPODT_TGRP_CODE

NO

NO
TAX_GROUP_DESC Tax group description. VARCHAR2(35)

FTVTGRP

FTVTGRP_TITLE

NO

NO
TEXT_USAGE Indicates if attached text is standard, user modified, or to be ignored. VARCHAR2(1)

FPRPODT

FPRPODT_TEXT_USAGE

NO

NO
TEXT_USAGE_DESC Description of the text usage. VARCHAR2(10)

CALCULATION

DECODE(FPRPODT_TEXT_USAGE)

NO

NO
UNIT_OF_MEASURE Unit of measure applicable to the selected commodity. VARCHAR2(3)

FPRPODT

FPRPODT_UOMS_CODE

NO

NO
UNIT_OF_MEASURE_DESC Description or title of the unit of measure. VARCHAR2(35)

FTVUOMS

FTVUOMS_DESC

NO

NO
UNIT_PRICE Unit price for goods and or services. NUMBER

CALCULATION

NVL(FPRPODT_UNIT_PRICE,0)

NO

NO
USER_ID Unique identification code of the user who entered or last modified the item. VARCHAR2(30)

FPRPODT

FPRPODT_USER_ID

NO

NO
VENDOR_AGREEMENT Code identifying an established agreement with a vendor for a specified unit price, minimum quantity and maximum dollar amount when ordering a specific commodity and unit of measure for that commodity. VARCHAR2(15)

FPRPODT

FPRPODT_AGRE_CODE

NO

NO
VENDOR_REFERENCE_NUMBER Vendor reference or part number for a commodity item provided. VARCHAR2(15)

FPRPODT

FPRPODT_VEND_REF_NUM

NO

NO
VENDOR_UID System generated unique internal identification number used to access the vendor. NUMBER

FPBPOHD

FPBPOHD_VEND_PIDM

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: