Go To View:  RETURN TO BANNER ODS META DATA 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
CHART_OF_ACCOUNTS, PURCHASE_ORDER_DATE

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  

FPBPOHD

FPBPOHD_ADDL_CHRG_AMT

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

NA

NA

APPROVAL_IND Approval Indicator 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(63)  

FPBPOHD

FPBPOHD_BLANKET_CODE

BLANKET_ORDER_IND Blanket Order Indicator Blanket indicator. VARCHAR2(1)  

CALCULATION

NVL(FPBPOHD_BLANKET_IND,'N')

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

FTVSHIP

FTVSHIP_BUILDING

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

FPBPOHD

FPBPOHD_BUYR_CODE

BUYER_NAME Buyer Name Name of the buyer. VARCHAR2(255)  

FTVBUYR

FTVBUYR_NAME

CANCEL_DATE 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 Cancel Reason Reason the purchase order was cancelled. VARCHAR2(63)  

FPBPOHD

FPBPOHD_CRSN_CODE

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

FUNCTION

FOKODSF.F_GET_FTVCRSN_DESC

CARRIER_ID Carrier ID   VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CARRIER_NAME Carrier Name   VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CARRIER_ROUTE Carrier Route Address carrier route. VARCHAR2(63)  

FTVSHIP

FTVSHIP_CARRIER_ROUTE

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

FPBPOHD

FPBPOHD_CARRIER_PIDM

CHART_OF_ACCOUNTS 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 Description Chart of accounts code description or title. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Status of the chart of accounts. VARCHAR2(63)  

FTVCOAS

FTVCOAS_STATUS_IND

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

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 Complete Indicator Indicates if the purchase order document is complete. VARCHAR2(1)  

FPBPOHD

FPBPOHD_COMPLETE_IND

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

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

FPBPOHD

FPBPOHD_COPIED_FROM

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 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 Discount description. VARCHAR2(255)  

FTVDISC

FTVDISC_DESC

DISCOUNT_PERCENT Discount Percent Discount percent. NUMBER  

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

FPBPOHD

FPBPOHD_ORIGIN_CODE

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 Floor number specific to the shipping address. VARCHAR2(63)  

FTVSHIP

FTVSHIP_FLOOR

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

FPBPOHD

FPBPOHD_FTRM_CODE

FREIGHT_TERMS_DESC Freight Terms Description Freight terms code description. VARCHAR2(255)  

FTVFTRM

FTVFTRM_DESC

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

ORDER_FROM_CARRIER_ROUTE Order From Carrier Route Address carrier route. VARCHAR2(4)  

SPRADDR

SPRADDR_CARRIER_ROUTE

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

SPRADDR

SPRADDR_CITY

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

SPRADDR

SPRADDR_CORRECTION_DIGIT

ORDER_FROM_COUNTY Order From County County for this address record. VARCHAR2(63)  

SPRADDR

SPRADDR_CNTY_CODE

ORDER_FROM_COUNTY_DESC Order From County Description Name of the county in the address. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

SPRADDR

SPRADDR_DELIVERY_POINT

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

SPRADDR

SPRADDR_NATN_CODE

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

STVNATN

STVNATN_NATION

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

SPRADDR

SPRADDR_ZIP

ORDER_FROM_STATE_PROVINCE Order From State Province Identifies the state or province associated with this address. VARCHAR2(63)  

SPRADDR

SPRADDR_STAT_CODE

ORDER_FROM_STATE_PROVINCE_DESC Order From State Province Description Name of the state/province. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

ORDER_FROM_STREET_LINE1 Order From Street Line 1 First line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE1

ORDER_FROM_STREET_LINE2 Order From Street Line 2 Second line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE2

ORDER_FROM_STREET_LINE3 Order From Street Line 3 Third line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE3

ORDER_FROM_STREET_LINE4 Order From Street Line 4 Fourth line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE4

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

FPBPOHD

FPBPOHD_ORGN_CODE

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

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS Organization Status Status of the organization. VARCHAR2(63)  

FTVORGN

FTVORGN_STATUS_IND

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

PO_CHANGE_DATE Po Change Date Date of the purchase order change. DATE  

FUNCTION

NA

FOKODSF.F_PO_LAST_CHANGE_DATE

NA

PO_CHANGE_ORDER 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 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 Po Start Date Purchase order start date. DATE  

NA

NA

PRINTED_DATE 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')

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)  

FPBPOHD

FPBPOHD_CODE

PURCHASE_ORDER_CLASS Purchase Order Class Purchase order classification for the type of purchase order. Such as hazardous substance. VARCHAR2(63)  

FPBPOHD

FPBPOHD_PCLS_CODE

PURCHASE_ORDER_CLASS_DESC Purchase Order Class Description Purchase order classification description. VARCHAR2(255)  

FTVPCLS

FTVPCLS_DESC

PURCHASE_ORDER_DATE Purchase Order Date Date on which a purchase order was created. DATE  

FPBPOHD

FPBPOHD_PO_DATE

PURCHASE_ORDER_TYPE Purchase Order Type Purchase order type. VARCHAR2(63)  

FPBPOHD

FPBPOHD_PO_TYPE_IND

PURCHASE_ORDER_TYPE_DESC Purchase Order Type Description Deciphers purchase order type as standing or regular. VARCHAR2(255)  

CALCULATION

DECODE(FPBPOHD_PO_TYPE_IND)

PURCHASE_ORDER_USER_ID Purchase Order User ID Unique identification code of the user who entered the transaction. VARCHAR2(63)  

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

FPBPOHD

FPBPOHD_MATCH_REQUIRED

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

CALCULATION

DECODE(FPBPOHD_MATCH_REQUIRED)

REQUESTOR_EMAIL_ADDRESS Requestor Email Address Requestor email address. VARCHAR2(255)  

FPBPOHD

FPBPOHD_EMAIL_ADDR

REQUESTOR_FAX_AREA Requestor Fax Area Requestor fax area code. VARCHAR2(63)  

FPBPOHD

FPBPOHD_FAX_AREA

REQUESTOR_FAX_EXT Requestor Fax Extension Requestor fax number extension. VARCHAR2(63)  

FPBPOHD

FPBPOHD_FAX_EXT

REQUESTOR_FAX_NUMBER Requestor Fax Number Requestor fax telephone number. VARCHAR2(63)  

FPBPOHD

FPBPOHD_FAX_NUMBER

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

FPBPOHD

FPBPOHD_NAME

REQUESTOR_PHONE_AREA Requestor Phone Area Requestor's area code. VARCHAR2(63)  

FPBPOHD

FPBPOHD_PHONE_AREA

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

FPBPOHD

FPBPOHD_PHONE_EXT

REQUESTOR_PHONE_NUMBER Requestor Phone Number Requestor's telephone number. VARCHAR2(63)  

FPBPOHD

FPBPOHD_PHONE_NUM

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

FPBPOHD

FPBPOHD_REQ_BID_IND

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

CALCULATION

DECODE(FPBPOHD_REQ_BID_IND)

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

FPBPOHD

FPBPOHD_TEXT_IND

REQUISITION_TEXT_DESC Requisition Text Description Description of the requisition text. VARCHAR2(255)  

CALCULATION

DECODE(FPBPOHD_TEXT_IND)

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

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 Shipping Address Code representing the shipment address. VARCHAR2(63)  

FPBPOHD

FPBPOHD_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)  

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

FPBPOHD

FPBPOHD_DOC_REF_CODE

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

FPBPOHD

FPBPOHD_VENDOR_CONTACT

VENDOR_EMAIL_ADDRESS Vendor Email Address Vendor's email address. VARCHAR2(255)  

FPBPOHD

FPBPOHD_VEND_EMAIL_ADDR

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

SPRIDEN

SPRIDEN_ENTITY_IND

VENDOR_ID_NUMBER Vendor ID Number 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_UID Vendor UID System generated unique internal identification number used to access the vendor. NUMBER  

FPBPOHD

FPBPOHD_VEND_PIDM



Ver: 9.0