RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE 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
ADDITIONAL_CHARGES_AMOUNT Amount of additional charges for the commodity record. NUMBER

FPRPODT

FPRPODT_ADDL_CHRG_AMT

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

NA

NA

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

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)

FPRPODT

FPRPODT_COMM_DESC

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

FPRPODT

FPRPODT_CONVERT_ADDL_CHRG_AMT

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

FPRPODT

FPRPODT_CONVERT_DISC_AMT

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

FPRPODT

FPRPODT_CONVERT_TAX_AMT

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

FPRPODT

FPRPODT_CONVERT_UNIT_PRICE

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

FPRPODT

FPRPODT_DISC_AMT

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

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

FPRPODT

FPRPODT_LIQ_AMT

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

FTVSHIP

FTVSHIP_PHONE_AREA

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

FTVSHIP

FTVSHIP_PHONE_EXT

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

NA

NA

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

FTVSHIP

FTVSHIP_PHONE_NUM

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

CALCULATION

FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||FTVSHIP_PHONE_EXT

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

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

FPRPODT

FPRPODT_QTY

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

FTVSHIP

FTVSHIP_ADDR_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(63)

FTVSHIP

FTVSHIP_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(63)

FTVSHIP

FTVSHIP_ADDR_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(63)

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

FPRPODT

FPRPODT_TAX_AMT

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

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

FPRPODT

FPRPODT_UNIT_PRICE

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

FPRPODT

FPRPODT_VEND_REF_NUM



Ver: 3.1