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
|