RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Operational Data Store
Composite View Target: AF_PURCHASE_ORDER

Description Source composite view contains cumulative information for purchase orders.

Target Column Business Definition Database Data Type Source Name Source Column
APPROVAL_IND Indicates the document has met final approval. VARCHAR2(1)

FPBPOHD

FPBPOHD_APPR_IND

BLANKET_ORDER_IND Blanket indicator. VARCHAR2(1)

FPBPOHD

FPBPOHD_BLANKET_IND

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 Indicates if the purchase order was canceled. VARCHAR2(1)

FPBPOHD

FPBPOHD_CANCEL_IND

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

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 code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

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

FTVSHIP

FTVSHIP_CITY

CLOSED_IND Indicates if the document has been closed from an encumbrance perspective. VARCHAR2(1)

FPBPOHD

FPBPOHD_CLOSED_IND

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

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

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

EDI_IND Indicates if the purchase order is to be sent via electronic data transfer. VARCHAR2(1)

FPBPOHD

FPBPOHD_EDI_IND

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 Extracted description or title associated with the organization code. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

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

FTVSHIP

FTVSHIP_PHONE_AREA

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

FTVSHIP

FTVSHIP_PHONE_EXT

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

NA

NA

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

FTVSHIP

FTVSHIP_PHONE_NUM

PHONE_NUMBER_COMBINED Extracted combined phone number for the ship to address. VARCHAR2(14)

CALCULATION

FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||FTVSHIP_PHONE_EXT

PHONE_UNLIST_IND The indicator that specifies if the phone number is to be unlisted or not. VARCHAR2(255)

NA

NA

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

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 Blanket purchase order end date. 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)

FPBPOHD

FPBPOHD_PRINT_IND

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

FPBPOHD

FPBPOHD_CODE

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

QUOTE_DATE Quote date. DATE

NA

NA

QUOTE_REFERENCE This field specifies the quote reference. VARCHAR2(255)

NA

NA

REQUIRED_DATE Date given to the vendors as a required deliver by date. DATE

FPBPOHD

FPBPOHD_REQD_DATE

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 First line of the address. VARCHAR2(30)

FTVSHIP

FTVSHIP_ADDR_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(30)

FTVSHIP

FTVSHIP_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(30)

FTVSHIP

FTVSHIP_ADDR_LINE3

STREET_LINE4 The fourth street associated with the entity's address. VARCHAR2(63)

NA

NA

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 Date used by the finance system to control posting to the ledgers. DATE

FPBPOHD

FPBPOHD_TRANS_DATE

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