| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADDITIONAL_CHARGES_AMOUNT
|
Amount of additional charges for the commodity record.
|
NUMBER
|
FARINVC
|
FARINVC_ADDL_CHRG_AMT
|
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
APPROVED_ITEM_AMOUNT
|
Calculation to determine the actual cost of an item.
|
NUMBER
|
CALCULATION
|
(NVL(FARINVC_APPR_QTY,0)*NVL(FARINVC_APPR_UNIT_PRICE,0))+NVL(FARINVC_ADDL_CHRG_AMT,0)+NVL(FARINVC_TAX_AMT,0)-NVL(FARINVC_DISC_AMT,0)
|
|
APPROVED_QUANTITY
|
Number of items approved for payment processing on this invoice item.
|
NUMBER
|
FARINVC
|
FARINVC_APPR_QTY
|
|
APPROVED_UNIT_PRICE
|
Unit amount approved for payment on this invoice item.
|
NUMBER
|
FARINVC
|
FARINVC_APPR_UNIT_PRICE
|
|
COMMODITY
|
User-defined code associated with this commodity.
|
VARCHAR2(63)
|
FARINVC
|
FARINVC_COMM_CODE
|
|
COMMODITY_DESC
|
Commodity description or title.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COMMODITY_HOLD_IND
|
An attribute used to place invoice records on hold to prevent disbursement to a vendor.
|
VARCHAR2(63)
|
FARINVC
|
FARINVC_HOLD_IND
|
|
COMMODITY_UNIT_OF_MEASURE
|
Code that depicts the unit of measure applicable to the selected commodity.
|
VARCHAR2(63)
|
FARINVC
|
FARINVC_UOMS_CODE
|
|
COMMODITY_UNIT_OF_MEASURE_DESC
|
Unit of measure description.
|
VARCHAR2(255)
|
FTVUOMS
|
FTVUOMS_DESC
|
|
CONVERTED_ADDITIONAL_AMOUNT
|
Base currency additional charges amount calculated for this commodity record.
|
NUMBER
|
FARINVC
|
FARINVC_CONVERT_ADDL_CHRG_AMT
|
|
CONVERTED_DISCOUNT_AMOUNT
|
Base currency discount amount calculated for this commodity record.
|
NUMBER
|
FARINVC
|
FARINVC_CONVERT_DISC_AMT
|
|
CONVERTED_TAX_AMOUNT
|
Base currency tax amount calculated for this commodity record.
|
NUMBER
|
FARINVC
|
FARINVC_CONVERT_TAX_AMT
|
|
CONVERTED_UNIT_PRICE
|
Base currency unit price calculated for this commodity record.
|
NUMBER
|
FARINVC
|
FARINVC_CONVERT_UNIT_PRICE
|
|
DISCOUNT_AMOUNT
|
Value of the discount taken on the invoice or purchase order accounting amount.
|
NUMBER
|
FARINVC
|
FARINVC_DISC_AMT
|
|
FEDERAL_TAX_IND
|
Distinguishes taxable payments resulting from the payment processing of the invoice. If Y (yes) the payment is recorded and accumulated for income tax reporting purposes.
|
VARCHAR2(63)
|
NA
|
NA
|
|
INVOICE
|
Invoice document number.
|
VARCHAR2(63)
|
FARINVC
|
FARINVC_INVH_CODE
|
|
ITEM
|
Literal commodity or goods description associated with an invoice processing record. The unique sequence number directly associated with an item on the commodity record.
|
NUMBER
|
FARINVC
|
FARINVC_ITEM
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PURCHASE_ORDER
|
User-defined or system assigned one-up purchase order number issued to this vendor.
|
VARCHAR2(63)
|
FARINVC
|
FARINVC_POHD_CODE
|
|
PURCHASE_ORDER_ITEM
|
System assigned one-up number of the commodity on the purchase order item.
|
NUMBER
|
FARINVC
|
FARINVC_PO_ITEM
|
|
TAX_AMOUNT
|
Amount of tax computed or entered for a document item.
|
NUMBER
|
FARINVC
|
FARINVC_TAX_AMT
|
|
TAX_GROUP
|
Tax group code to be used for this commodity record.
|
VARCHAR2(63)
|
FARINVC
|
FARINVC_TGRP_CODE
|
|
TAX_GROUP_DESC
|
Tax group description.
|
VARCHAR2(255)
|
FTVTGRP
|
FTVTGRP_TITLE
|