Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE		FPBPOHD	FPBPOHD_ACTIVITY_DATE
ADDITIONAL_AMOUNT	Additional Amount	Amount of additional charges e.g.freight for this purchase order.	NUMBER(17,2)		FPBPOHD	FPBPOHD_ADDL_CHRG_AMT
APPROVAL_IND		Indicates the document has met final approval.	VARCHAR2(1)		FPBPOHD	FPBPOHD_APPR_IND
BLANKET_ORDER	Blanket Order	Blanket code the purchase order was created from.	VARCHAR2(8)		FPBPOHD	FPBPOHD_BLANKET_CODE
BLANKET_ORDER_IND	Blanket Order Indicator	Blanket indicator.	VARCHAR2(1)		CALCULATION	NVL(FPBPOHD_BLANKET_IND,'N')
BUILDING		Name for the building associated with a specific shipping address.	VARCHAR2(15)		FTVSHIP	FTVSHIP_BUILDING
BUYER		Code used to identify a purchasing buyer.	VARCHAR2(4)		FPBPOHD	FPBPOHD_BUYR_CODE
BUYER_NAME		Name of the buyer.	VARCHAR2(35)		FTVBUYR	FTVBUYR_NAME
CANCEL_DATE		Date the purchase order was cancelled.	DATE		FPBPOHD	FPBPOHD_CANCEL_DATE
CANCEL_IND	Cancel Indicator	Indicates if the purchase order was canceled.	VARCHAR2(1)		CALCULATION	NVL(FPBPOHD_CANCEL_IND,'N')
CANCEL_REASON		Reason the purchase order was cancelled.	VARCHAR2(4)		FPBPOHD	FPBPOHD_CRSN_CODE
CANCEL_REASON_DESC		Retrieves the description of the cancel reason.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_FTVCRSN_DESC
CARRIER_ROUTE		Address carrier route.	VARCHAR2(4)		FTVSHIP	FTVSHIP_CARRIER_ROUTE
CARRIER_UID	Carrier UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		FPBPOHD	FPBPOHD_CARRIER_PIDM
CHART_OF_ACCOUNTS		Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FPBPOHD	FPBPOHD_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_FINANCE_DESC
CITY	City	Address city, town or municipality.	VARCHAR2(50)		FTVSHIP	FTVSHIP_CITY
CLOSED_DATE	Closed Date	Date that the purchase order is closed.	DATE		FPBPOHD	FPBPOHD_CLOSED_DATE
CLOSED_IND	Closed Indicator	Indicates if the document has been closed from an encumbrance perspective.	VARCHAR2(1)		CALCULATION	NVL(FPBPOHD_CLOSED_IND,'N')
COMPLETE_IND		Indicates if the purchase order document is complete.	VARCHAR2(1)		FPBPOHD	FPBPOHD_COMPLETE_IND
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
COPIED_PURCHASE_ORDER	Copied Purchase Order	Purchahse order code of the document copied.	VARCHAR2(8)		FPBPOHD	FPBPOHD_COPIED_FROM
CORRECTION_DIGIT		Correction digit associated with the address for bar code mailing.	NUMBER(1)		FTVSHIP	FTVSHIP_CORRECTION_DIGIT
COUNTY		The county code associated with the entity's address.	VARCHAR2(63)		NA	NA
COUNTY_DESC		The description of the county code associated with the entity's address.	VARCHAR2(255)		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	Discount	Default discount code representing the value of the discount to be taken on the purchase order accounting amount.	VARCHAR2(2)		FPBPOHD	FPBPOHD_DISC_CODE
DISCOUNT_DESC	Discount Description	Discount description.	VARCHAR2(35)		FTVDISC	FTVDISC_DESC
DISCOUNT_PERCENT	Discount Percent	Discount percent.	NUMBER(6, 3)		FTVDISC	FTVDISC_PCT
DOCUMENT_SOURCE	Document Source	If the purchase order has been created via an eprocuremnt system, this is set to EPROC-SYSTEM CODE. The default is BANNER. If PO is created from the self-service module then it can be set to SELF_SERVICE.	VARCHAR2(26)		FPBPOHD	FPBPOHD_ORIGIN_CODE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EDI_IND	EDI Indicator	Indicates if the purchase order is to be sent via electronic data transfer.	VARCHAR2(1)		CALCULATION	NVL(FPBPOHD_EDI_IND,'N')
FLOOR		Floor number specific to the shipping address.	VARCHAR2(10)		FTVSHIP	FTVSHIP_FLOOR
FREIGHT_TERMS		Freight terms code indicating the method of payment for freight.	VARCHAR2(2)		FPBPOHD	FPBPOHD_FTRM_CODE
FREIGHT_TERMS_DESC		Freight terms code description.	VARCHAR2(30)		FTVFTRM	FTVFTRM_DESC
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
ORDER_FROM_ADDRESS_TYPE		This field identifies the address type of the vendor address.	VARCHAR2(2)		FPBPOHD	FPBPOHD_ATYP_CODE
ORDER_FROM_ADDRESS_TYPE_DESC		Description for the address type of the vendor.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ORDER_FROM_ADDRESS_TYPE_NUMBER		Sequence number of the order from address for the vendor.	NUMBER(2)		FPBPOHD	FPBPOHD_ATYP_SEQ_NUM
ORGANIZATION_CODE		Identification accounting code used for the department.	VARCHAR2(6)		FPBPOHD	FPBPOHD_ORGN_CODE
ORGANIZATION_DESC	Organization Description	Extracted description or title associated with the organization code.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_FINANCE_DESC
PHONE_AREA	Phone Area	Phone area code for the ship-to address.	VARCHAR2(6)		FTVSHIP	FTVSHIP_PHONE_AREA
PHONE_EXT	Phone Extension	Phone extension number for the ship-to address.	VARCHAR2(10)		FTVSHIP	FTVSHIP_PHONE_EXT
PHONE_INTL_ACCESS	Phone International 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(12)		FTVSHIP	FTVSHIP_PHONE_NUM
PHONE_NUMBER_COMBINED	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	Phone Unlisted Indicator	The indicator that specifies if the phone number is to be unlisted or not.	VARCHAR2(1)		NA	NA
POSTAL_CODE	Postal Code	Postal code associated with the ship-to address.	VARCHAR2(30)		FTVSHIP	FTVSHIP_ZIP_CODE
PO_CHANGE_DATE		Last posted date for the purchase order change.	DATE		FUNCTION	FOKODSF.F_PO_LAST_CHANGE_DATE
PO_CHANGE_ORDER		Last change number for the purchase order change.	VARCHAR2(40)		FUNCTION	FOKODSF.F_PO_LAST_CHANGE_SEQNO
PO_END_DATE	Purchase Order End Date	Purchase Order end date representing either the termination date of a blanket order or the end date of a rush order.	DATE		CALCULATION	NVL(FPBPOHD_REXP_DATE,FPBPOHD_BLANKET_TERM_DATE)
PO_START_DATE		Purchase order start date.	DATE		NA	NA
PRINTED_DATE		Date on which a purchase order was printed.	DATE		FPBPOHD	FPBPOHD_PO_PRINTED_DATE
PRINT_IND	Print Indicator	Indicates if the document has been printed.	VARCHAR2(1)		CALCULATION	NVL(FPBPOHD_PRINT_IND,'N')
PURCHASE_ORDER		User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)		FPBPOHD	FPBPOHD_CODE
PURCHASE_ORDER_CLASS	Purchase Order Class	Shipping classification code for the commodity. Such as hazardous substance.	VARCHAR2(1)		FPBPOHD	FPBPOHD_PCLS_CODE
PURCHASE_ORDER_CLASS_DESC	Purchase Order Class Description	Shipping classification description.	VARCHAR2(35)		FTVPCLS	FTVPCLS_DESC
PURCHASE_ORDER_DATE		Date on which a purchase order was created.	DATE		FPBPOHD	FPBPOHD_PO_DATE
PURCHASE_ORDER_TYPE		Purchase order type.	VARCHAR2(1)		FPBPOHD	FPBPOHD_PO_TYPE_IND
PURCHASE_ORDER_TYPE_DESC		The purchase order type description.	VARCHAR2(30)		CALCULATION	DECODE(FPBPOHD_PO_TYPE_IND)
PURCHASE_ORDER_USER_ID		Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		FPBPOHD	FPBPOHD_USER_ID
RECEIVING_REQUIRED	Receiving Required	Indicates whether Invoices associated with this Purchase Orders will require Matching. Valid values are [N]o matching, [Y]es matching, [U] for no matching.	VARCHAR2(1)		FPBPOHD	FPBPOHD_MATCH_REQUIRED
RECEIVING_REQUIRED_DESC	Receiving Required Description	Description of the receiving required code.	VARCHAR2(15)		CALCULATION	DECODE(FPBPOHD_MATCH_REQUIRED)
REQUESTOR_EMAIL_ADDRESS	Requestor Email Address	Requestor email address.	VARCHAR2(128)		FPBPOHD	FPBPOHD_EMAIL_ADDR
REQUESTOR_FAX_AREA	Requestor Fax Area	Requestor fax area code.	VARCHAR2(6)		FPBPOHD	FPBPOHD_FAX_AREA
REQUESTOR_FAX_EXT	Requestor Fax Extension	Requestor fax number extension.	VARCHAR2(10)		FPBPOHD	FPBPOHD_FAX_EXT
REQUESTOR_FAX_NUMBER	Requestor Fax Number	Requestor fax telephone number.	VARCHAR2(12)		FPBPOHD	FPBPOHD_FAX_NUMBER
REQUESTOR_NAME	Requestor Name	Name of the person who is submitting the purchase order.	VARCHAR2(35)		FPBPOHD	FPBPOHD_NAME
REQUESTOR_PHONE_AREA	Requestor Phone Area	Requestor's area code.	VARCHAR2(6)		FPBPOHD	FPBPOHD_PHONE_AREA
REQUESTOR_PHONE_EXT	Requestor Phone Extension	Requestor's phone number extension.	VARCHAR2(10)		FPBPOHD	FPBPOHD_PHONE_EXT
REQUESTOR_PHONE_NUMBER	Requestor Phone Number	Requestor's telephone number.	VARCHAR2(12)		FPBPOHD	FPBPOHD_PHONE_NUM
REQUIRED_DATE		Date given to the vendors as a required deliver by date.	DATE		FPBPOHD	FPBPOHD_REQD_DATE
REQUISITION_OR_BID_SOURCE	Requisition Or Bid Source	Requisition or bid indicator. Values are (B)id, (R)equisition, or null.	VARCHAR2(1)		FPBPOHD	FPBPOHD_REQ_BID_IND
REQUISITION_OR_BID_SOURCE_DESC	Requisition or Bid Source Description	Description of the requisition or bid code.	VARCHAR2(15)		CALCULATION	DECODE(FPBPOHD_REQ_BID_IND)
REQUISITION_TEXT	Requisition Text	Indicates if the document has associated text.	VARCHAR2(1)		FPBPOHD	FPBPOHD_TEXT_IND
REQUISITION_TEXT_DESC	Requisition Text Description	Description of the requisition text.	VARCHAR2(25)		CALCULATION	DECODE(FPBPOHD_TEXT_IND)
RUSH_AMOUNT	Rush Amount	Maximum dollar amount permissible for a rush purchase order.	NUMBER(17,2)		FPBPOHD	FPBPOHD_RUSH_AMT
RUSH_ORDER_IND	Rush Order Indicator	Indicates is this is a rush purchase order.	VARCHAR2(1)		FPBPOHD	FPBPOHD_RUSH_IND
SHIPPING_ADDRESS		Code representing the shipment address.	VARCHAR2(6)		FPBPOHD	FPBPOHD_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	Street Line 1	First line of the address.	VARCHAR2(75)		FTVSHIP	FTVSHIP_ADDR_LINE1
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(75)		FTVSHIP	FTVSHIP_ADDR_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(75)		FTVSHIP	FTVSHIP_ADDR_LINE3
STREET_LINE4		The fourth street associated with the entity's address.	VARCHAR2(63)		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)		CALCULATION	NVL(FPBPOHD_SUSP_IND,'N')
THIRD_PARTY_DOCUMENT	Third Party Document	Third party eproc system purchase order number. Banner will always create a new po number for Purchase Orders from eprocurement..	VARCHAR2(20)		FPBPOHD	FPBPOHD_DOC_REF_CODE
TOTAL_APPROVED_ITEM_AMOUNT		Total approved amount for all items in the purchase order calculated as unit price time quantity plus taxes plus additional charges minus discounts.	NUMBER		FUNCTION	FOKODSF.F_CALC_TOT_APPROV_ITEM_AMT
TOTAL_BLANKET_ORDER_BAL		Calculates blanket order balance for all items in the purchase order.	NUMBER		FUNCTION	FOKODSF.F_CALC_BLANKET_ORDER_BAL
TOTAL_CONVERTED_AMOUNT		Total conversion amount approved for all purchase order items calculated as unit price time quantity plus taxes plus additional charges minus discounts.	NUMBER		FUNCTION	FOKODSF.F_CALC_TOT_CONVERT_ITEM_AMT
TRANSACTION_DATE	Transaction Date	Purchase order accounting transaction date used to post to the ledgers determining the posting fiscal year and fiscal period.	DATE		FPBPOHD	FPBPOHD_TRANS_DATE
VENDOR_CONTACT	Vendor Contact	Vendor's contact.	VARCHAR2(35)		FPBPOHD	FPBPOHD_VENDOR_CONTACT
VENDOR_EMAIL_ADDRESS	Vendor Email Address	Vendor's email address.	VARCHAR2(128)		FPBPOHD	FPBPOHD_VEND_EMAIL_ADDR
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: