RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

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

FPRPODT

FPRPODT_ADDL_CHRG_AMT

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(12, 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

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

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)

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

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

FTVSHIP

FTVSHIP_CORRECTION_DIGIT

COUNTY County for this address. VARCHAR2(0)

NA

NA

COUNTY_DESC County name for the address. VARCHAR2(0)

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

FPRPODT

FPRPODT_DISC_AMT

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

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

FPRPODT

FPRPODT_LIQ_AMT

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

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

NA

NA

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

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

FPRPODT

FPRPODT_QTY

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

FTVSHIP

FTVSHIP_ADDR_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(30)

FTVSHIP

FTVSHIP_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(30)

FTVSHIP

FTVSHIP_ADDR_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(0)

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

FPRPODT

FPRPODT_TGRP_CODE

TAX_GROUP_DESC Tax group description. VARCHAR2(35)

FTVTGRP

FTVTGRP_TITLE

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

FPRPODT

FPRPODT_UNIT_PRICE

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

FPRPODT

FPRPODT_VEND_REF_NUM

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

NA

NA



Ver: 3.1