Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

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

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

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

FPRBIDD

FPRBIDD_BIDH_CODE

BLANKET_ORDER_REMAINING_BAL Contains the remaining balance of the blanket order. NUMBER(17,2)

FPRPODT

FPRPODT_BO_REMAIN_BAL

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

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

FTVSHIP

FTVSHIP_CARRIER_ROUTE

CHANGE_ORDER_AMOUNT Gross value of the change order. NUMBER(17,2)

FPRPODT

FPRPODT_EXT_AMT

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

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

FPRPODT

FPRPODT_COMM_CODE

COMMODITY_DESC Commodity description or title. VARCHAR2(50)

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

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(FPRPODT_CONVERT_UNIT_PRICE,0))+NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)+NVL(FPRPODT_CONVERT_TAX_AMT,0)-NVL(FPRPODT_CONVERT_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(1)

FTVSHIP

FTVSHIP_CORRECTION_DIGIT

COUNTY County for this address. VARCHAR2(1)

NA

NA

COUNTY_DESC County name for the address. VARCHAR2(1)

NA

NA

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

NA

SYSDATE

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

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

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

NA

NA

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

FTVSHIP

FTVSHIP_FLOOR

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

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)

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

NA

NA

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

NA

NA

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

FTVSHIP

FTVSHIP_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

FTVSHIP

FTVSHIP_PHONE_AREA

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

FTVSHIP

FTVSHIP_PHONE_EXT

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

NA

NA

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

FTVSHIP

FTVSHIP_PHONE_NUM

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

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

FTVSHIP

FTVSHIP_ZIP_CODE

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

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

FPBPOHD

FPBPOHD_NAME

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

FPRREQD

FPRREQD_REQH_CODE

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

FPRREQD

FPRREQD_ITEM

SHIPMENT_TO_ADDRESS Code representing the shipment address. VARCHAR2(6)

FPRPODT

FPRPODT_SHIP_CODE

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

FTVSHIP

FTVSHIP_STATE

STATE_PROVINCE_DESC State/province name. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

STREET_LINE1 First line of the address. VARCHAR2(75)

FTVSHIP

FTVSHIP_ADDR_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(75)

FTVSHIP

FTVSHIP_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(75)

FTVSHIP

FTVSHIP_ADDR_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(30)

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

FPRPODT

FPRPODT_TGRP_CODE

TAX_GROUP_DESC Tax group description. VARCHAR2(35)

FTVTGRP

FTVTGRP_TITLE

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

FPRPODT

FPRPODT_TEXT_USAGE

TEXT_USAGE_DESC Description of the text usage. VARCHAR2(10)

CALCULATION

DECODE(FPRPODT_TEXT_USAGE)

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

FPRPODT

FPRPODT_UOMS_CODE

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

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

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

FPRPODT

FPRPODT_AGRE_CODE

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

FPRPODT

FPRPODT_VEND_REF_NUM

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

FPBPOHD

FPBPOHD_VEND_PIDM

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

NA

NA



Ver: 8.0