| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
|---|
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
|
APPROVED_ITEM_AMOUNT
|
Calculation to determine the actual cost of an item.
|
NUMBER
|
CALCULATION
|
(NVL(FPRPODT_QTY,0)*NVL(FPRPODT_UNIT_PRICE,0))+NVL(FPRPODT_ADDL_CHRG_AMT,0)+NVL(FPRPODT_TAX_AMT,0)-NVL(FPRPODT_DISC_AMT,0)
|
NO
|
NO
|
|
BUYER
|
Identifies a purchasing buyer.
|
VARCHAR2(63)
|
FPBPOHD
|
FPBPOHD_BUYR_CODE
|
NO
|
NO
|
|
BUYER_NAME
|
Buyer name.
|
VARCHAR2(255)
|
FTVBUYR
|
FTVBUYR_NAME
|
NO
|
NO
|
|
COMMODITY
|
User-defined code associated with this commodity.
|
VARCHAR2(63)
|
FPRPODT
|
FPRPODT_COMM_CODE
|
NO
|
NO
|
|
COMMODITY_DESC
|
Commodity description or title.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
|
ITEM
|
System-generated item number associated with the purchase order commodity.
|
NUMBER
|
FPRPODT
|
FPRPODT_ITEM
|
NO
|
NO
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
|
PURCHASE_ORDER
|
User-defined or system assigned one-up purchase order number issued to this vendor.
|
VARCHAR2(63)
|
FPRPODT
|
FPRPODT_POHD_CODE
|
NO
|
NO
|
|
QTY_RECEIVED_REJECTED_TO_DATE
|
Total of all quantities received and rejected on an ordered commodity as of today.
|
NUMBER
|
CALCULATION FUNCTION
|
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD) MFKFUNC.F_QTY_RECEIVED_REJECTED
|
NO NO
|
NO
|
|
QUANTITY_ACCEPTED_TO_DATE
|
Total of all quantities being received, rejected and returned on a purchase order item as of today.
|
NUMBER
|
CALCULATION FUNCTION
|
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY) MFKFUNC.F_QTY_ACCEPTED
|
NO NO
|
NO
|
|
QUANTITY_ORDERED
|
Number of units ordered.
|
NUMBER
|
FPRPODT
|
FPRPODT_QTY
|
NO
|
NO
|
|
QUANTITY_RECEIVED_TO_DATE
|
Total of all quantities received on an ordered commodity as of today.
|
NUMBER
|
CALCULATION FUNCTION
|
SUM(FPRRCDT_QTY_RCVD) MFKFUNC.F_QTY_RECEIVED
|
NO NO
|
NO
|
|
QUANTITY_REJECTED_TO_DATE
|
Total of all quantities rejected on an ordered commodity as of today.
|
NUMBER
|
CALCULATION FUNCTION
|
SUM(FPRRCDT_QTY_RCVD) MFKFUNC.F_QTY_REJECTED
|
NO NO
|
NO
|
|
QUANTITY_RETURNED_TO_DATE
|
Total of all quantities being returned on an ordered commodity as of today.
|
NUMBER
|
CALCULATION FUNCTION
|
SUM(FPRRTRN_QTY) MFKFUNC.F_QTY_RETURNED
|
NO NO
|
NO
|
|
RECEIVED_AMOUNT_TO_DATE
|
Total amount received for the purchased item as of today. Used for standing orders.
|
NUMBER
|
CALCULATION FUNCTION
|
SUM(FPRRCDT_AMT_RCVD) MFKFUNC.F_RECEIVED_AMOUNT
|
NO NO
|
NO
|
|
REQUIRED_DATE
|
Date given to the vendors as a required deliver by date.
|
DATE
|
FPBPOHD
|
FPBPOHD_REQD_DATE
|
NO
|
NO
|
|
VENDOR_ENTITY_IND
|
Identifies if the vendor is a person or a non-person.
|
VARCHAR2(1)
|
FUNCTION
|
MFKFUNC.F_GET_VENDOR_FIELDS
|
NO
|
NO
|
|
VENDOR_ID
|
User-defined or system generated one-up number of the vendor.
|
VARCHAR2(63)
|
FUNCTION
|
MFKFUNC.F_GET_VENDOR_FIELDS
|
NO
|
NO
|
|
VENDOR_NAME
|
Vendor name.
|
VARCHAR2(255)
|
FUNCTION
|
MFKFUNC.F_GET_VENDOR_FIELDS
|
NO
|
NO
|
|
VENDOR_UID
|
System-generated unique internal indentification number used to access the vendor.
|
NUMBER
|
FPBPOHD
|
FPBPOHD_VEND_PIDM
|
NO
|
NO
|