RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Operational Data Store
Composite View Target: AF_INVOICE

Description Source composite view contains information on invoices.

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

FABINVH

FABINVH_APPR_IND

CANCEL_DATE Date the invoice was cancelled. DATE

FABINVH

FABINVH_CANCEL_DATE

COMPLETE_IND Indicates if the purchase order document is complete. VARCHAR2(1)

FABINVH

FABINVH_COMPLETE_IND

CREDIT_MEMO_IND Indicator identifies invoices for which a credit memo has been processed. VARCHAR2(1)

FABINVH

FABINVH_CR_MEMO_IND

CURRENCY Type of currency represented in the amount field. VARCHAR2(4)

FABINVH

FABINVH_CURR_CODE

CURRENCY_DESC Currency code description or title. VARCHAR2(35)

GTVCURR

GTVCURR_TITLE

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

NA

NA

FEDERAL_TAX_ID Indicates 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(9)

FABINVH

FABINVH_1099_ID

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(1)

FABINVH

FABINVH_1099_IND

HOLD_IND Indicates if invoice records are on hold to prevent disbursement to a vendor. VARCHAR2(1)

FABINVH

FABINVH_HOLD_IND

INVOICE Invoice document number. VARCHAR2(8)

FABINVH

FABINVH_CODE

INVOICE_DATE Date of the invoice. DATE

FABINVH

FABINVH_INVOICE_DATE

INVOICE_METHOD Invoice method. VARCHAR2(0)

NA

NA

INVOICE_METHOD_DESC Invoice method description. VARCHAR2(0)

NA

NA

INVOICE_TYPE Indicator designates whether an invoice is direct pay or regular. VARCHAR2(1)

FABINVH

FABINVH_INVOICE_TYPE_IND

INVOICE_TYPE_DESC The description for the invoice type. VARCHAR2(30)

CALCULATION

DECODE(FABINVH_INVOICE_TYPE_IND)

INVOICE_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

FABINVH

FABINVH_USER_ID

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

MULTIPLE_INVOICE_IND Indicates whether this invoice contains multiple vendor invoices. VARCHAR2(1)

FABINVH

FABINVH_MULTIPLE_INV_IND

ONE_TIME_VENDOR_ADDRESS_IND Indicates if the remit-to address is a one-time vendor address. VARCHAR2(1)

CALCULATION

DECODE(FABINVH_ATYP_CODE,NULL,'Y','N')

OPEN_PAID_IND Indicates if a document is open or paid. VARCHAR2(1)

FABINVH

FABINVH_OPEN_PAID_IND

PAYMENT_DUE_DATE Date an invoice is due to be paid by check. DATE

FABINVH

FABINVH_PMT_DUE_DATE

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

FABINVH

FABINVH_POHD_CODE

REMIT_TO_ADDRESS_TYPE Identifies the type of address that the payment for the invoice is to be sent. VARCHAR2(2)

FABINVH

FABINVH_ATYP_CODE

REMIT_TO_ADDRESS_TYPE_DESC Description for the address type of the vendor. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_ADDRESS_TYPE_NUMBER Sequence number of the address type of the remit to vendor. NUMBER

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, TO_NUMBER(NULL), FABINVH_ATYP_SEQ_NUM)

REMIT_TO_CITY City, town or municipality associated with the address. VARCHAR2(20)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL)

REMIT_TO_NATION Nation/country code associated with the address. VARCHAR2(5)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL)

REMIT_TO_NATION_DESC Description for the nation/country associated with the address. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_POSTAL_CODE Postal code associated with the remit-to address. VARCHAR2(10)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL)

REMIT_TO_STATE_PROVINCE Identifies the state or province associated with this address. VARCHAR2(3)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL)

REMIT_TO_STATE_PROVINCE_DESC Name of the state/province. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_STREET_LINE1 First line of the address. VARCHAR2(30)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL)

REMIT_TO_STREET_LINE2 Second line of the address. VARCHAR2(30)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL)

REMIT_TO_STREET_LINE3 Third line of the address. VARCHAR2(30)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL)

REMIT_TO_STREET_LINE4 Fourth line of the address. VARCHAR2(0)

NA

NA

SUBMISSION_NUMBER Last submission number used for this invoice if it was recurring or re-established. NUMBER(3)

FABINVH

FABINVH_SUBMISSION_NUMBER

THIRD_PARTY_ADDRESS_IND Indicates if the remit-to address is a third party address. VARCHAR2(1)

CALCULATION

DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N','Y')

THIRD_PARTY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)

FABINVH

FABINVH_VEND_CHECK_PIDM

TOTAL_APPROVED_ITEM_AMOUNT Total approved amount for all invoice items calculated as approved amount plus taxes plus additional charges minus discounts minus tax rebates. NUMBER

FUNCTION

FOKODSF.F_INV_TOT_APPROV_ITEM_AMT

TOTAL_CONVERTED_AMOUNT Total conversion amount for all invoice items calculated as approved amount plus taxes plus additional charges minus discounts minus tax rebates. NUMBER

FUNCTION

FOKODSF.F_INV_TOT_CONVERT_ITEM_AMT

TRANSACTION_DATE Date used by the finance system to control posting to the ledgers. DATE

FABINVH

FABINVH_TRANS_DATE

VENDOR_INVOICE_NUMBER Vendor's invoice code. VARCHAR2(15)

FABINVH

FABINVH_VEND_INV_CODE

VENDOR_NAME Name of the Vendor VARCHAR2(60)

CALCULATION

DECODE(FABINVH_VEND_PIDM, NULL, FABINVH_ONE_TIME_VEND_NAME, NULL)

VENDOR_UID System generated unique internal identification number used to access the vendor. NUMBER(8)

FABINVH

FABINVH_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