Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE	FPRPODT	FPRPODT_ACTIVITY_DATE
ADDITIONAL_CHARGES_AMOUNT	Additional Charges Amount	Amount of additional charges for the commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_ADDL_CHRG_AMT,0)
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AGREEMENT_MINIMUM_QUANTITY	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	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	Bid number.	VARCHAR2(63)	FPRBIDD	FPRBIDD_BIDH_CODE
BLANKET_ORDER_REMAINING_BAL	Blanket Order Remaining Bal	Contains the remaining balance of the blanket order.	NUMBER	FPRPODT	FPRPODT_BO_REMAIN_BAL
BUILDING	Building	Name of the building associated with a specific shipping address.	VARCHAR2(63)	FTVSHIP	FTVSHIP_BUILDING
CANCEL_DATE	Cancel Date	Date the purchase order was cancelled.	DATE	FPRPODT	FPRPODT_CANCEL_DATE
CANCEL_IND	Cancel Indicator	Indicates if the purchase order was canceled.	VARCHAR2(1)	FPRPODT	FPRPODT_CANCEL_IND
CARRIER_ROUTE	Carrier Route	Address carrier route.	VARCHAR2(63)	FTVSHIP	FTVSHIP_CARRIER_ROUTE
CHANGE_ORDER_AMOUNT	Change Order Amount	Gross value of the change order.	NUMBER	FPRPODT	FPRPODT_EXT_AMT
CITY	City	Address city, town or municipality.	VARCHAR2(63)	FTVSHIP	FTVSHIP_CITY
CLOSED_IND	Closed Indicator	Indicates if the document has been closed from an encumbrance perspective.	VARCHAR2(1)	FPRPODT	FPRPODT_CLOSED_IND
COMMODITY	Commodity	User-defined code associated with this commodity.	VARCHAR2(63)	FPRPODT	FPRPODT_COMM_CODE
COMMODITY_DESC	Commodity Description	Commodity description or title.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMODITY_DESC_CHANGE_IND	Commodity Description Change Indicator	Indicates when the default commodity description has been overwritten in the purchase order.	VARCHAR2(1)	CALCULATION	NVL(FPRPODT_DESC_CHGE_IND,'N')
CONTACT_NAME	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	Converted Additional Amount	Base currency additional charges amount calculated for this commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)
CONVERTED_APPROVED_ITEM_AMOUNT	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	Converted Discount Amount	Base currency discount amount calculated for this commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_CONVERT_DISC_AMT,0)
CONVERTED_TAX_AMOUNT	Converted Tax Amount	Base currency tax amount calculated for this commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_CONVERT_TAX_AMT,0)
CONVERTED_UNIT_PRICE	Converted Unit Price	Base currency unit price calculated for this commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_CONVERT_UNIT_PRICE,0)
CORRECTION_DIGIT	Correction Digit	Correction digit associated with the address for bar code mailing.	NUMBER	FTVSHIP	FTVSHIP_CORRECTION_DIGIT
COUNTY	County	County for this address.	VARCHAR2(63)	NA	NA
COUNTY_DESC	County Description	County name for the address.	VARCHAR2(255)	NA	NA
DELIVERY_POINT	Delivery Point	Delivery point associated with the address for barcode mailings.	NUMBER	FTVSHIP	FTVSHIP_DELIVERY_POINT
DISCOUNT_AMOUNT	Discount Amount	Value of the discount taken on the invoice or purchase order accounting amount.	NUMBER	CALCULATION	NVL(FPRPODT_DISC_AMT,0)
DISCOUNT_PERCENT	Discount Percent	Extract discount percent for the purchase order from the discount code.	NUMBER	FUNCTION	FOKODSF.F_PO_DISC_PCT
FLOOR	Floor	Floor number specific to the shipping address.	VARCHAR2(63)	FTVSHIP	FTVSHIP_FLOOR
ITEM	Item	System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER	FPRPODT	FPRPODT_ITEM
ITEM_CHANGE_ORDER	Item Change Order	Last change sequence number of the purchase order.	NUMBER	FUNCTION	FOKODSF.F_PO_ITEM_LAST_CHANGE_SEQNO
ITEM_DELIVERY_DATE	Item Delivery Date	Date given to the vendors as a required deliver by date.	DATE	FPRPODT	FPRPODT_REQD_DATE
LIQUIDATION_AMOUNT	Liquidation Amount	Amount that has been liquidated against the original encumbrance.	NUMBER	CALCULATION	NVL(FPRPODT_LIQ_AMT,0)
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NATION	Nation	Nation/country code associated with the address.	VARCHAR2(63)	FTVSHIP	FTVSHIP_NATN_CODE
NATION_DESC	Nation Description	Address nation/country description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PHONE_AREA	Phone Area	Phone area code for the ship-to address.	VARCHAR2(63)	FTVSHIP	FTVSHIP_PHONE_AREA
PHONE_EXT	Phone Extension	Phone extension number for the ship-to address.	VARCHAR2(63)	FTVSHIP	FTVSHIP_PHONE_EXT
PHONE_INTL_ACCESS	Phone Intl Access	Free format international access code for telephone number including country and city code.	VARCHAR2(63)	NA	NA
PHONE_NUMBER	Phone Number	Phone number for the ship-to address.	VARCHAR2(63)	FTVSHIP	FTVSHIP_PHONE_NUM
PHONE_NUMBER_COMBINED	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	Phone Unlist Indicator	Specifies if the phone number is to be unlisted.	VARCHAR2(1)	NA	NA
POSTAL_CODE	Postal Code	Postal code associated with the ship-to address.	VARCHAR2(63)	FTVSHIP	FTVSHIP_ZIP_CODE
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PURCHASE_ORDER	Purchase Order	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(63)	FPRPODT	FPRPODT_POHD_CODE
QUANTITY	Quantity	Number of units ordered.	NUMBER	CALCULATION	NVL(FPRPODT_QTY,0)
REQUESTOR_NAME	Requestor Name	Name of the person who is submitting the purchase order.	VARCHAR2(255)	FPBPOHD	FPBPOHD_NAME
REQUISITION	Requisition	User-defined or system assigned one-up requisition number.	VARCHAR2(63)	FPRREQD	FPRREQD_REQH_CODE
REQUISITION_NUMBER	Requisition Number	System assigned one-up number of the commodity on the requisition item.	NUMBER	FPRREQD	FPRREQD_ITEM
SHIPMENT_TO_ADDRESS	Shipment To Address	Code representing the shipment address.	VARCHAR2(63)	FPRPODT	FPRPODT_SHIP_CODE
STATE_PROVINCE	State Province	State or province associated with this address.	VARCHAR2(63)	FTVSHIP	FTVSHIP_STATE
STATE_PROVINCE_DESC	State Province Description	State/province name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(255)	FTVSHIP	FTVSHIP_ADDR_LINE1
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(255)	FTVSHIP	FTVSHIP_ADDR_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(255)	FTVSHIP	FTVSHIP_ADDR_LINE3
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)	NA	NA
SUSPENSE_IND	Suspense Indicator	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	Tax Amount	Amount of tax computed or entered for a document item.	NUMBER	CALCULATION	NVL(FPRPODT_TAX_AMT,0)
TAX_GROUP	Tax Group	Tax group code to be used for this commodity record.	VARCHAR2(63)	FPRPODT	FPRPODT_TGRP_CODE
TAX_GROUP_DESC	Tax Group Description	Tax group description.	VARCHAR2(255)	FTVTGRP	FTVTGRP_TITLE
TEXT_USAGE	Text Usage	Indicates if attached text is standard, user modified, or to be ignored.	VARCHAR2(63)	FPRPODT	FPRPODT_TEXT_USAGE
TEXT_USAGE_DESC	Text Usage Description	Description of the text usage.	VARCHAR2(255)	CALCULATION	DECODE(FPRPODT_TEXT_USAGE)
UNIT_OF_MEASURE	Unit Of Measure	Unit of measure applicable to the selected commodity.	VARCHAR2(63)	FPRPODT	FPRPODT_UOMS_CODE
UNIT_OF_MEASURE_DESC	Unit Of Measure Description	Unit of measure title or description.	VARCHAR2(255)	FTVUOMS	FTVUOMS_DESC
UNIT_PRICE	Unit Price	Unit price for goods and or services.	NUMBER	CALCULATION	NVL(FPRPODT_UNIT_PRICE,0)
USER_ID	User ID	Unique identification code of the user who entered or last modified the item.	VARCHAR2(63)	FPRPODT	FPRPODT_USER_ID
VENDOR_AGREEMENT	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	Vendor ID	Extracted identification number for the vendor.	VARCHAR2(63)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
VENDOR_NAME	Vendor Name	Extracted name of the vendor.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
VENDOR_REFERENCE_NUMBER	Vendor Reference Number	Vendor reference or part number for a commodity item provided.	VARCHAR2(63)	FPRPODT	FPRPODT_VEND_REF_NUM
VENDOR_UID	Vendor UID	System generated unique internal identification number used to access the vendor.	NUMBER	FPBPOHD	FPBPOHD_VEND_PIDM

Ver: 9.2