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