ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.			FPRPODT	FPRPODT_ACTIVITY_DATE
ADDITIONAL_CHARGES_AMOUNT	Amount of additional charges for the commodity record.			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.			FUNCTION	FOKODSF.F_GET_MIN_QUANTITY
APPROVED_ITEM_AMOUNT	Calculation to determine the actual cost of an item.			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.			FPRBIDD	FPRBIDD_BIDH_CODE
BLANKET_ORDER_REMAINING_BAL	Contains the remaining balance of the blanket order.			FPRPODT	FPRPODT_BO_REMAIN_BAL
BUILDING	Name for the building associated with a specific shipping address.			FTVSHIP	FTVSHIP_BUILDING
CANCEL_DATE	Date the purchase order was cancelled.			FPRPODT	FPRPODT_CANCEL_DATE
CANCEL_IND	Indicates if the purchase order was canceled.			FPRPODT	FPRPODT_CANCEL_IND
CARRIER_ROUTE	Address carrier route.			FTVSHIP	FTVSHIP_CARRIER_ROUTE
CHANGE_ORDER_AMOUNT	Gross value of the change order.			FPRPODT	FPRPODT_EXT_AMT
CITY	Address city, town or municipality.			FTVSHIP	FTVSHIP_CITY
CLOSED_IND	Indicates if the document has been closed from an encumbrance perspective.			FPRPODT	FPRPODT_CLOSED_IND
COMMODITY	User-defined code associated with this commodity.			FPRPODT	FPRPODT_COMM_CODE
COMMODITY_DESC	Commodity description or title.			FUNCTION	GOKODSF.F_GET_DESC
COMMODITY_DESC_CHANGE_IND	Indicates when the default commodity description has been overwritten in the purchase order.			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.			FTVSHIP	FTVSHIP_CONTACT
CONVERTED_ADDITNAL_AMOUNT	Base currency additional charges amount calculated for this commodity record.			CALCULATION	NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)
CONVERTED_APPROVED_ITEM_AMOUNT	Calculation to determine the actual converted cost of an item.			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.			CALCULATION	NVL(FPRPODT_CONVERT_DISC_AMT,0)
CONVERTED_TAX_AMOUNT	Base currency tax amount calculated for this commodity record.			CALCULATION	NVL(FPRPODT_CONVERT_TAX_AMT,0)
CONVERTED_UNIT_PRICE	Base currency unit price calculated for this commodity record.			CALCULATION	NVL(FPRPODT_CONVERT_UNIT_PRICE,0)
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.			FTVSHIP	FTVSHIP_CORRECTION_DIGIT
COUNTY	County for this address.			NA	NA
COUNTY_DESC	County name for the address.			NA	NA
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.			FTVSHIP	FTVSHIP_DELIVERY_POINT
DISCOUNT_AMOUNT	Value of the discount taken on the invoice or purchase order accounting amount.			CALCULATION	NVL(FPRPODT_DISC_AMT,0)
DISCOUNT_PERCENT	Extract discount percent for the purchase order from the discount code.			FUNCTION	FOKODSF.F_PO_DISC_PCT
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
FLOOR	Floor number specific to the shipping address.			FTVSHIP	FTVSHIP_FLOOR
ITEM	System-generated line item number that identifies each commodity line item for procurement documents.			FPRPODT	FPRPODT_ITEM
ITEM_CHANGE_ORDER	Last change sequence number of the purchase order.			FUNCTION	FOKODSF.F_PO_ITEM_LAST_CHANGE_SEQNO
ITEM_DELIVERY_DATE	Date given to the vendors as a required deliver by date.			FPRPODT	FPRPODT_REQD_DATE
LIQUIDATION_AMOUNT	Amount that has been liquidated against the original encumbrance.			CALCULATION	NVL(FPRPODT_LIQ_AMT,0)
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
NATION	Nation/country code associated with the address.			FTVSHIP	FTVSHIP_NATN_CODE
NATION_DESC	Address nation/country description.			FUNCTION	GOKODSF.F_GET_DESC
PHONE_AREA	Phone area code for the ship-to address.			FTVSHIP	FTVSHIP_PHONE_AREA
PHONE_EXT	Phone extension number for the ship-to address.			FTVSHIP	FTVSHIP_PHONE_EXT
PHONE_INTL_ACCESS	Free format international access code for telephone number including country and city code.			NA	NA
PHONE_NUMBER	Phone number for the ship-to address.			FTVSHIP	FTVSHIP_PHONE_NUM
PHONE_NUMBER_COMBINED	Extracted combined phone number for the ship to address.			CALCULATION	FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||FTVSHIP_PHONE_EXT
PHONE_UNLIST_IND	Specifies if the phone number is to be unlisted.			NA	NA
POSTAL_CODE	Postal code associated with the ship-to address.			FTVSHIP	FTVSHIP_ZIP_CODE
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.			FPRPODT	FPRPODT_POHD_CODE
QUANTITY	Number of units ordered.			CALCULATION	NVL(FPRPODT_QTY,0)
REQUESTOR_NAME	Name of the person who is submitting the purchase order.			FPBPOHD	FPBPOHD_NAME
REQUISITION	User-defined or system assigned one-up requisition number.			FPRREQD	FPRREQD_REQH_CODE
REQUISITION_NUMBER	System assigned one-up number of the commodity on the requisition item.			FPRREQD	FPRREQD_ITEM
SHIPMENT_TO_ADDRESS	Code representing the shipment address.			FPRPODT	FPRPODT_SHIP_CODE
STATE_PROVINCE	State or province associated with this address.			FTVSHIP	FTVSHIP_STATE
STATE_PROVINCE_DESC	State/province name.			FUNCTION	GOKODSF.F_GET_DESC
STREET_LINE1	First line of the address.			FTVSHIP	FTVSHIP_ADDR_LINE1
STREET_LINE2	Second line of the address.			FTVSHIP	FTVSHIP_ADDR_LINE2
STREET_LINE3	Third line of the address.			FTVSHIP	FTVSHIP_ADDR_LINE3
STREET_LINE4	Fourth line of the address.			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.			FPRPODT	FPRPODT_SUSP_IND
TAX_AMOUNT	Amount of tax computed or entered for a document item.			CALCULATION	NVL(FPRPODT_TAX_AMT,0)
TAX_GROUP	Tax group code to be used for this commodity record.			FPRPODT	FPRPODT_TGRP_CODE
TAX_GROUP_DESC	Tax group description.			FTVTGRP	FTVTGRP_TITLE
TEXT_USAGE	Indicates if attached text is standard, user modified, or to be ignored.			FPRPODT	FPRPODT_TEXT_USAGE
TEXT_USAGE_DESC	Description of the text usage.			CALCULATION	DECODE(FPRPODT_TEXT_USAGE)
UNIT_OF_MEASURE	Unit of measure applicable to the selected commodity.			FPRPODT	FPRPODT_UOMS_CODE
UNIT_OF_MEASURE_DESC	Description or title of the unit of measure.			FTVUOMS	FTVUOMS_DESC
UNIT_PRICE	Unit price for goods and or services.			CALCULATION	NVL(FPRPODT_UNIT_PRICE,0)
USER_ID	Unique identification code of the user who entered or last modified the item.			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.			FPRPODT	FPRPODT_AGRE_CODE
VENDOR_REFERENCE_NUMBER	Vendor reference or part number for a commodity item provided.			FPRPODT	FPRPODT_VEND_REF_NUM
VENDOR_UID	System generated unique internal identification number used to access the vendor.			FPBPOHD	FPBPOHD_VEND_PIDM
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3