Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PURCHASE_ORDER

Description Contains current general purchase order and vendor information including type of purchase order, transaction date, vendor, buyer, organization hierarchy, shipping address, and blanket order information.
Key & Frequency One row per purchase order.
Recommended Search Columns CHART_OF_ACCOUNTS, ORGANIZATION_CODE
PURCHASE_ORDER

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

FPBPOHD

FPBPOHD_ACTIVITY_DATE

ADDITIONAL_AMOUNT Amount of additional charges e.g.freight for this purchase order. NUMBER

FPBPOHD

FPBPOHD_ADDL_CHRG_AMT

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPROVAL_IND Indicates the document has met final approval. VARCHAR2(1)

FPBPOHD

FPBPOHD_APPR_IND

BLANKET_ORDER Blanket code the purchase order was created from. VARCHAR2(63)

FPBPOHD

FPBPOHD_BLANKET_CODE

BLANKET_ORDER_IND Blanket indicator. VARCHAR2(1)

CALCULATION

NVL(FPBPOHD_BLANKET_IND,'N')

BUILDING Name of the building associated with a specific shipping address. VARCHAR2(63)

FTVSHIP

FTVSHIP_BUILDING

BUYER Code used to identify a purchasing buyer. VARCHAR2(63)

FPBPOHD

FPBPOHD_BUYR_CODE

BUYER_NAME Name of the buyer. VARCHAR2(255)

FTVBUYR

FTVBUYR_NAME

CANCEL_DATE Date the purchase order was cancelled. DATE

FPBPOHD

FPBPOHD_CANCEL_DATE

CANCEL_IND Indicates if the purchase order was canceled. VARCHAR2(1)

CALCULATION

NVL(FPBPOHD_CANCEL_IND,'N')

CANCEL_REASON Reason the purchase order was cancelled. VARCHAR2(63)

FPBPOHD

FPBPOHD_CRSN_CODE

CANCEL_REASON_DESC Retrieves the description of the cancel reason. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FTVCRSN_DESC

CARRIER_ID   VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CARRIER_NAME   VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CARRIER_ROUTE Address carrier route. VARCHAR2(63)

FTVSHIP

FTVSHIP_CARRIER_ROUTE

CARRIER_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

FPBPOHD

FPBPOHD_CARRIER_PIDM

CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FPBPOHD

FPBPOHD_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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

FTVSHIP

FTVSHIP_CITY

CLOSED_DATE Date that the purchase order is closed. DATE

FPBPOHD

FPBPOHD_CLOSED_DATE

CLOSED_IND 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(63)

FTVSHIP

FTVSHIP_CONTACT

COPIED_PURCHASE_ORDER Purchahse order code of the document copied. VARCHAR2(63)

FPBPOHD

FPBPOHD_COPIED_FROM

CORRECTION_DIGIT Correction digit associated with the address for bar code mailing. NUMBER

FTVSHIP

FTVSHIP_CORRECTION_DIGIT

COUNTY County for this address. VARCHAR2(63)

NA

NA

COUNTY_DESC County name for the address. VARCHAR2(255)

NA

NA

DELIVERY_POINT Delivery point associated with the address for barcode mailings. NUMBER

FTVSHIP

FTVSHIP_DELIVERY_POINT

DISCOUNT Default discount code representing the value of the discount to be taken on the purchase order accounting amount. VARCHAR2(63)

FPBPOHD

FPBPOHD_DISC_CODE

DISCOUNT_DESC Discount description. VARCHAR2(255)

FTVDISC

FTVDISC_DESC

DISCOUNT_PERCENT Discount percent. NUMBER

FTVDISC

FTVDISC_PCT

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

FPBPOHD

FPBPOHD_ORIGIN_CODE

EDI_IND 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(63)

FTVSHIP

FTVSHIP_FLOOR

FREIGHT_TERMS Freight terms code indicating the method of payment for freight. VARCHAR2(63)

FPBPOHD

FPBPOHD_FTRM_CODE

FREIGHT_TERMS_DESC Freight terms code description. VARCHAR2(255)

FTVFTRM

FTVFTRM_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NATION Nation/country code associated with the address. VARCHAR2(63)

FTVSHIP

FTVSHIP_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ORDER_FROM_CARRIER_ROUTE Address carrier route. VARCHAR2(4)

SPRADDR

SPRADDR_CARRIER_ROUTE

ORDER_FROM_CITY City, town or municipality associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

ORDER_FROM_CORRECTION_DIGIT Correction digit associated with the address for bar code mailing. NUMBER

SPRADDR

SPRADDR_CORRECTION_DIGIT

ORDER_FROM_COUNTY County for this address record. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

ORDER_FROM_COUNTY_DESC Name of the county in the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ORDER_FROM_DELIVERY_POINT Delivery point associated with the address for barcode mailings. NUMBER

SPRADDR

SPRADDR_DELIVERY_POINT

ORDER_FROM_NATION Nation/country code associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_NATN_CODE

ORDER_FROM_NATION_DESC Description for the nation/country associated with the address. VARCHAR2(255)

STVNATN

STVNATN_NATION

ORDER_FROM_POSTAL_CODE Postal code associated with the order from address. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

ORDER_FROM_STATE_PROVINCE Identifies the state or province associated with this address. VARCHAR2(63)

SPRADDR

SPRADDR_STAT_CODE

ORDER_FROM_STATE_PROVINCE_DESC Name of the state/province. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

ORDER_FROM_STREET_LINE1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

ORDER_FROM_STREET_LINE2 Second line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

ORDER_FROM_STREET_LINE3 Third line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

ORDER_FROM_STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA

ORGANIZATION_CODE Identification accounting code used for the department. VARCHAR2(63)

FPBPOHD

FPBPOHD_ORGN_CODE

ORGANIZATION_DESC Extracted description or title associated with the organization code. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

ORGANIZATION_DESC_1 Retrieves description or title level 1 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_2 Retrieves description or title level 2 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_3 Retrieves description or title level 3 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_4 Retrieves description or title level 4 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_5 Retrieves description or title level 5 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_6 Retrieves description or title level 6 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_7 Retrieves description or title level 7 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_8 Retrieves description or title level 8 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_1 Retrieves level 1 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_2 Retrieves level 2 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_3 Retrieves level 3 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_4 Retrieves level 4 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_5 Retrieves level 5 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_6 Retrieves level 6 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_7 Retrieves level 7 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_8 Retrieves level 8 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_1 Retrieves status of level 1 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_2 Retrieves status of level 2 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_3 Retrieves status of level 3 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_4 Retrieves status of level 4 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_5 Retrieves status of level 5 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_6 Retrieves status of level 6 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_7 Retrieves status of level 7 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_8 Retrieves status of level 8 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

PHONE_AREA Phone area code for the ship-to address. VARCHAR2(63)

FTVSHIP

FTVSHIP_PHONE_AREA

PHONE_EXT Phone extension number for the ship-to address. VARCHAR2(63)

FTVSHIP

FTVSHIP_PHONE_EXT

PHONE_INTL_ACCESS Free format international access code for telephone number including country and city code. VARCHAR2(63)

NA

NA

PHONE_NUMBER Phone number for the ship-to address. VARCHAR2(63)

FTVSHIP

FTVSHIP_PHONE_NUM

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 Specifies if the phone number is to be unlisted. VARCHAR2(1)

NA

NA

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

FTVSHIP

FTVSHIP_ZIP_CODE

PO_CHANGE_DATE Date of the purchase order change. DATE

FUNCTION

NA

FOKODSF.F_PO_LAST_CHANGE_DATE

NA

PO_CHANGE_ORDER Change sequence number of the purchase order. VARCHAR2(63)

FPBPOHD

FUNCTION

FPBPOHD_CHANGE_SEQ_NUM

FOKODSF.F_PO_LAST_CHANGE_SEQNO

PO_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 Indicates if the document has been printed. VARCHAR2(1)

CALCULATION

NVL(FPBPOHD_PRINT_IND,'N')

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

NA

NA

PURCHASE_ORDER User-defined or system assigned one-up purchase order number issued to this vendor. VARCHAR2(63)

FPBPOHD

FPBPOHD_CODE

PURCHASE_ORDER_CLASS Shipping classification code for the commodity. Such as hazardous substance. VARCHAR2(63)

FPBPOHD

FPBPOHD_PCLS_CODE

PURCHASE_ORDER_CLASS_DESC Shipping classification description. VARCHAR2(255)

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

FPBPOHD

FPBPOHD_PO_TYPE_IND

PURCHASE_ORDER_TYPE_DESC Deciphers purchase order type as standing or regular. VARCHAR2(255)

CALCULATION

DECODE(FPBPOHD_PO_TYPE_IND)

PURCHASE_ORDER_USER_ID Unique identification code of the user who entered the transaction. VARCHAR2(63)

FPBPOHD

FPBPOHD_USER_ID

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

FPBPOHD

FPBPOHD_MATCH_REQUIRED

RECEIVING_REQUIRED_DESC Description of the receiving required code. VARCHAR2(255)

CALCULATION

DECODE(FPBPOHD_MATCH_REQUIRED)

REQUESTOR_EMAIL_ADDRESS Requestor email address. VARCHAR2(255)

FPBPOHD

FPBPOHD_EMAIL_ADDR

REQUESTOR_FAX_AREA Requestor fax area code. VARCHAR2(63)

FPBPOHD

FPBPOHD_FAX_AREA

REQUESTOR_FAX_EXT Requestor fax number extension. VARCHAR2(63)

FPBPOHD

FPBPOHD_FAX_EXT

REQUESTOR_FAX_NUMBER Requestor fax telephone number. VARCHAR2(63)

FPBPOHD

FPBPOHD_FAX_NUMBER

REQUESTOR_NAME Name of the person who is submitting the purchase order. VARCHAR2(255)

FPBPOHD

FPBPOHD_NAME

REQUESTOR_PHONE_AREA Requestor's area code. VARCHAR2(63)

FPBPOHD

FPBPOHD_PHONE_AREA

REQUESTOR_PHONE_EXT Requestor's phone number extension. VARCHAR2(63)

FPBPOHD

FPBPOHD_PHONE_EXT

REQUESTOR_PHONE_NUMBER Requestor's telephone number. VARCHAR2(63)

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 indicator. Values are (B)id, (R)equisition, or null. VARCHAR2(63)

FPBPOHD

FPBPOHD_REQ_BID_IND

REQUISITION_OR_BID_SOURCE_DESC Description of the requisition or bid code. VARCHAR2(255)

CALCULATION

DECODE(FPBPOHD_REQ_BID_IND)

REQUISITION_TEXT Indicates if the document has associated text. VARCHAR2(63)

FPBPOHD

FPBPOHD_TEXT_IND

REQUISITION_TEXT_DESC Description of the requisition text. VARCHAR2(255)

CALCULATION

DECODE(FPBPOHD_TEXT_IND)

RUSH_AMOUNT Maximum dollar amount permissible for a rush purchase order. NUMBER

FPBPOHD

FPBPOHD_RUSH_AMT

RUSH_ORDER_IND Indicates is this is a rush purchase order. VARCHAR2(1)

FPBPOHD

FPBPOHD_RUSH_IND

SHIPPING_ADDRESS Code representing the shipment address. VARCHAR2(63)

FPBPOHD

FPBPOHD_SHIP_CODE

STATE_PROVINCE State or province associated with this address. VARCHAR2(63)

FTVSHIP

FTVSHIP_STATE

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

FTVSHIP

FTVSHIP_ADDR_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(255)

FTVSHIP

FTVSHIP_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

FTVSHIP

FTVSHIP_ADDR_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

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)

CALCULATION

NVL(FPBPOHD_SUSP_IND,'N')

THIRD_PARTY_DOCUMENT Third party eproc system purchase order number. Banner will always create a new po number for Purchase Orders from eprocurement.. VARCHAR2(63)

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 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's contact. VARCHAR2(63)

FPBPOHD

FPBPOHD_VENDOR_CONTACT

VENDOR_EMAIL_ADDRESS Vendor's email address. VARCHAR2(255)

FPBPOHD

FPBPOHD_VEND_EMAIL_ADDR

VENDOR_ENTITY_IND This field identifies if the vendor is person or non-person. VARCHAR2(1)

SPRIDEN

SPRIDEN_ENTITY_IND

VENDOR_ID_NUMBER Extracted identification number for the vendor. VARCHAR2(63)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_NAME Extracted name of the vendor. VARCHAR2(255)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_UID System generated unique internal identification number used to access the vendor. NUMBER

FPBPOHD

FPBPOHD_VEND_PIDM



Ver: 8.0