| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ADDITIONAL_CHARGES_AMOUNT
 | 
Additional Charges Amount 
 | 
Amount of additional charges for the commodity record.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_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
 
 | 
| 
APPROVED_ITEM_AMOUNT
 | 
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
 | 
Approved Quantity 
 | 
Number of items approved for payment processing on this invoice item.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_APPR_QTY
 
 | 
| 
APPROVED_UNIT_PRICE
 | 
Approved Unit Price 
 | 
Unit amount approved for payment on this invoice item.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_APPR_UNIT_PRICE
 
 | 
| 
COMMODITY
 | 
Commodity 
 | 
User-defined code associated with this commodity.
 | 
VARCHAR2(63)
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_COMM_CODE
 
 | 
| 
COMMODITY_DESC
 | 
Commodity Description 
 | 
Commodity description or title.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
COMMODITY_HOLD_IND
 | 
Commodity Hold Indicator 
 | 
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
 | 
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
 | 
Commodity Unit of Measure Description 
 | 
Unit of measure description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVUOMS
 
 | 
 FTVUOMS_DESC
 
 | 
| 
CONVERTED_ADDITIONAL_AMOUNT
 | 
Converted Additional Amount 
 | 
Base currency additional charges amount calculated for this commodity record.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_CONVERT_ADDL_CHRG_AMT
 
 | 
| 
CONVERTED_DISCOUNT_AMOUNT
 | 
Converted Discount Amount 
 | 
Base currency discount amount calculated for this commodity record.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_CONVERT_DISC_AMT
 
 | 
| 
CONVERTED_TAX_AMOUNT
 | 
Converted Tax Amount 
 | 
Base currency tax amount calculated for this commodity record.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_CONVERT_TAX_AMT
 
 | 
| 
CONVERTED_UNIT_PRICE
 | 
Converted Unit Price 
 | 
Base currency unit price calculated for this commodity record.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_CONVERT_UNIT_PRICE
 
 | 
| 
DISCOUNT_AMOUNT
 | 
Discount Amount 
 | 
Value of the discount taken on the invoice or purchase order accounting amount.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_DISC_AMT
 
 | 
| 
FEDERAL_TAX_IND
 | 
Federal Tax Indicator 
 | 
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 
 | 
Invoice document number.
 | 
VARCHAR2(63)
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_INVH_CODE
 
 | 
| 
ITEM
 | 
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
 | 
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
 
 | 
| 
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)
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_POHD_CODE
 
 | 
| 
PURCHASE_ORDER_ITEM
 | 
Purchase Order Item 
 | 
System assigned one-up number of the commodity on the purchase order item.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_PO_ITEM
 
 | 
| 
TAX_AMOUNT
 | 
Tax Amount 
 | 
Amount of tax computed or entered for a document item.
 | 
NUMBER
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_TAX_AMT
 
 | 
| 
TAX_GROUP
 | 
Tax Group 
 | 
Tax group code to be used for this commodity record.
 | 
VARCHAR2(63)
 | 
 
 | 
 FARINVC
 
 | 
 FARINVC_TGRP_CODE
 
 | 
| 
TAX_GROUP_DESC
 | 
Tax Group Description 
 | 
Tax group description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVTGRP
 
 | 
 FTVTGRP_TITLE
 
 |