Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FABINVH Finance
SGHE Banner Operational Data Store Composite View Source: FABINVH - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
FABINVH_1099_ID FAAINVE COMPOSITE VIEW

AF_INVOICE

FEDERAL_TAX_ID

NA
FABINVH_1099_IND FAAINVE COMPOSITE VIEW

AF_INVOICE

FEDERAL_TAX_IND

NA
FABINVH_ACTIVITY_DATE FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_ACTIVITY_DATE

 
FABINVH_APPR_IND FAIIVNL COMPOSITE VIEW

AF_INVOICE

APPROVAL_IND

NA
FABINVH_ATYP_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

REMIT_TO_ADDRESS_TYPE

NA
FABINVH_CANCEL_ACTIVITY_DATE FAAINVD COMPOSITE VIEW

AF_INVOICE

INVOICE_CANCEL_ACTIVITY_DATE

 
FABINVH_CANCEL_DATE FAAINVE COMPOSITE VIEW

AF_INVOICE

CANCEL_DATE

NA
FABINVH_CANCEL_IND FAAINVE COMPOSITE VIEW

AF_INVOICE

CANCEL_IND

 
FABINVH_CANCEL_USER FAAINVD COMPOSITE VIEW

AF_INVOICE

INVOICE_CANCEL_USER_ID

 
FABINVH_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE

NA
FABINVH_COMPLETE_DATE FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_COMPLETE_DATE

 
FABINVH_COMPLETE_IND FAIINVL COMPOSITE VIEW

AF_INVOICE

COMPLETE_IND

NA
FABINVH_COMPLETE_USER FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_COMPLETE_USER

 
FABINVH_CREATE_DATE FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_CREATE_DATE

 
FABINVH_CREATE_USER FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_CREATE_USER

 
FABINVH_CR_MEMO_IND FAAINVE COMPOSITE VIEW

AF_INVOICE

CREDIT_MEMO_IND

NA
FABINVH_CTRY_CODE_FAX FAAINVE COMPOSITE VIEW

AF_INVOICE

FAX_COUNTRY_CODE

 
FABINVH_CTRY_CODE_PHONE FAAINVE COMPOSITE VIEW

AF_INVOICE

PHONE_COUNTRY_CODE

 
FABINVH_CURR_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

CURRENCY

NA
FABINVH_DATA_ORIGIN FAAINVE COMPOSITE VIEW

AF_INVOICE

DATA_ORIGIN

 
FABINVH_DISC_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

DISCOUNT

 
FABINVH_HOLD_IND FAAINVE COMPOSITE VIEW

AF_INVOICE

HOLD_IND

NA
FABINVH_INVOICE_DATE FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_DATE

NA
FABINVH_INVOICE_TYPE_IND NA COMPOSITE VIEW

AF_INVOICE

INVOICE_TYPE

NA
FABINVH_ITYP_SEQ_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

TAX_INCOME_TYPE_KEY

 
FABINVH_MATCH_REQUIRED FAAINVE COMPOSITE VIEW

AF_INVOICE

RECEIVING_REQUIRED

 
FABINVH_MULTIPLE_INV_IND FAAINVE COMPOSITE VIEW

AF_INVOICE

MULTIPLE_INVOICE_IND

NA
FABINVH_ONE_TIME_VEND_NAME FAAINVE       NA
FABINVH_OPEN_PAID_IND FAIINVL COMPOSITE VIEW

AF_INVOICE

OPEN_PAID_IND

NA
FABINVH_ORIGIN_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_ORIGIN

 
FABINVH_PMT_DUE_DATE FAAINVE COMPOSITE VIEW

AF_INVOICE

PAYMENT_DUE_DATE

NA
FABINVH_POHD_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

PURCHASE_ORDER

NA
FABINVH_SUBMISSION_NUMBER NA COMPOSITE VIEW

AF_INVOICE

SUBMISSION_NUMBER

NA
FABINVH_SUSP_IND FAAINVE COMPOSITE VIEW

AF_INVOICE

SUSPENSE_IND

 
FABINVH_TGRP_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

TAX_GROUP

 
FABINVH_TRANS_DATE FAAINVE COMPOSITE VIEW

AF_INVOICE

TRANSACTION_DATE

NA
FABINVH_USER_ID FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_USER_ID

NA
FABINVH_VEND_CHECK_PIDM NA COMPOSITE VIEW

AF_INVOICE

THIRD_PARTY_UID

NA
FABINVH_VEND_INV_CODE FAAINVE COMPOSITE VIEW

AF_INVOICE

VENDOR_INVOICE_NUMBER

NA
FABINVH_VEND_PIDM NA COMPOSITE VIEW

AF_INVOICE

VENDOR_UID

NA


Ver: