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	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	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
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	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	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	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	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	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: