Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PURCHASE_ORDER_ITEM

Description Contains current purchase order items with commodity information. This includes the requisition, bid, and each base and converted amount for unit price, taxes, discounts, and additional charges as well as quantity.
Key & Frequency One row per purchase order per item.
Recommended Search Columns PURCHASE_ORDER, ITEM

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

FPRPODT

FPRPODT_ACTIVITY_DATE

ADDITIONAL_CHARGES_AMOUNT Amount of additional charges for the commodity record. NUMBER

CALCULATION

NVL(FPRPODT_ADDL_CHRG_AMT,0)

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

FPRAGRD

FPRAGRD_MIN_QTY

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)

BID_NUMBER Bid number. VARCHAR2(63)

FPRBIDD

FPRBIDD_BIDH_CODE

BLANKET_ORDER_REMAINING_BAL Contains the remaining balance of the blanket order. NUMBER

FPRPODT

FPRPODT_BO_REMAIN_BAL

BUILDING Name of the building associated with a specific shipping address. VARCHAR2(63)

FTVSHIP

FTVSHIP_BUILDING

CANCEL_DATE Date the purchase order was cancelled. DATE

FPRPODT

FPRPODT_CANCEL_DATE

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

FPRPODT

FPRPODT_CANCEL_IND

CARRIER_ROUTE Address carrier route. VARCHAR2(63)

FTVSHIP

FTVSHIP_CARRIER_ROUTE

CHANGE_ORDER_AMOUNT Gross value of the change order. NUMBER

FPRPODT

FPRPODT_EXT_AMT

CITY Address city, town or municipality. VARCHAR2(63)

FTVSHIP

FTVSHIP_CITY

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

FPRPODT

FPRPODT_CLOSED_IND

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

FPRPODT

FPRPODT_COMM_CODE

COMMODITY_DESC Commodity description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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')

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

FTVSHIP

FTVSHIP_CONTACT

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

CALCULATION

NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)

CONVERTED_APPROVED_ITEM_AMOUNT Calculation to determine the actual converted cost of an item. NUMBER

CALCULATION

(NVL(FPRPODT_QTY,0)*NVL(CONVERTED_FPRPODT_UNIT_PRICE,0))+NVL(FPRPODT_CONVERTED_ADDL_CHRG_AMT,0)+NVL(FPRPODT_CONVERTED_TAX_AMT,0)-NVL(FPRPODT_CONVERTED_DISC_AMT,0)

CONVERTED_DISCOUNT_AMOUNT Base currency discount amount calculated for this commodity record. NUMBER

CALCULATION

NVL(FPRPODT_CONVERT_DISC_AMT,0)

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

CALCULATION

NVL(FPRPODT_CONVERT_TAX_AMT,0)

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

CALCULATION

NVL(FPRPODT_CONVERT_UNIT_PRICE,0)

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

FTVSHIP

FTVSHIP_CORRECTION_DIGIT

COUNTY County for this address. VARCHAR2(63)

NA

NA

COUNTY_DESC County name for the address. VARCHAR2(255)

NA

NA

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

FTVSHIP

FTVSHIP_DELIVERY_POINT

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

CALCULATION

NVL(FPRPODT_DISC_AMT,0)

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

FUNCTION

FOKODSF.F_PO_DISC_PCT

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

FTVSHIP

FTVSHIP_FLOOR

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

FPRPODT

FPRPODT_ITEM

ITEM_CHANGE_ORDER Last change sequence number of the purchase order. NUMBER

FUNCTION

FOKODSF.F_PO_ITEM_LAST_CHANGE_SEQNO

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

FPRPODT

FPRPODT_REQD_DATE

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

CALCULATION

NVL(FPRPODT_LIQ_AMT,0)

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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

FTVSHIP

FTVSHIP_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FTVSHIP

FTVSHIP_PHONE_AREA

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

FTVSHIP

FTVSHIP_PHONE_EXT

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

NA

NA

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

FTVSHIP

FTVSHIP_PHONE_NUM

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

CALCULATION

FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||FTVSHIP_PHONE_EXT

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

NA

NA

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

FTVSHIP

FTVSHIP_ZIP_CODE

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

FPRPODT

FPRPODT_POHD_CODE

QUANTITY Number of units ordered. NUMBER

CALCULATION

NVL(FPRPODT_QTY,0)

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

FPBPOHD

FPBPOHD_NAME

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

FPRREQD

FPRREQD_REQH_CODE

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

FPRREQD

FPRREQD_ITEM

SHIPMENT_TO_ADDRESS Code representing the shipment address. VARCHAR2(63)

FPRPODT

FPRPODT_SHIP_CODE

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

FTVSHIP

FTVSHIP_STATE

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

FTVSHIP

FTVSHIP_ADDR_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(255)

FTVSHIP

FTVSHIP_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

FTVSHIP

FTVSHIP_ADDR_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA

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

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

CALCULATION

NVL(FPRPODT_TAX_AMT,0)

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

FPRPODT

FPRPODT_TGRP_CODE

TAX_GROUP_DESC Tax group description. VARCHAR2(255)

FTVTGRP

FTVTGRP_TITLE

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

FPRPODT

FPRPODT_TEXT_USAGE

TEXT_USAGE_DESC Description of the text usage. VARCHAR2(255)

CALCULATION

DECODE(FPRPODT_TEXT_USAGE)

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

FPRPODT

FPRPODT_UOMS_CODE

UNIT_OF_MEASURE_DESC Unit of measure title or description. VARCHAR2(255)

FTVUOMS

FTVUOMS_DESC

UNIT_PRICE Unit price for goods and or services. NUMBER

CALCULATION

NVL(FPRPODT_UNIT_PRICE,0)

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

FPRPODT

FPRPODT_USER_ID

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(63)

FPRPODT

FPRPODT_AGRE_CODE

VENDOR_ID Extracted identification number for the vendor. VARCHAR2(63)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_NAME Extracted name of the vendor. VARCHAR2(255)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

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

FPRPODT

FPRPODT_VEND_REF_NUM

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

FPBPOHD

FPBPOHD_VEND_PIDM



Ver: 8.0