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
|
BANK
|
Code used to identify the bank account on all cash transactions.
|
VARCHAR2(63)
|
FAB1099
|
FAB1099_BANK_CODE
|
NO
|
NO
|
BANK_DESC
|
Name of the bank where the institution has accounts.
|
VARCHAR2(255)
|
GXVBANK
|
GXVBANK_ACCT_NAME
|
NO
|
NO
|
BANK_ID
|
ID of the bank where the Institution has accounts.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
NO
|
NO
|
BANK_NAME
|
Official banking institution name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
NO
|
NO
|
BANK_UID
|
Internal identification number of the bank where the institution has accounts
|
NUMBER
|
GXVBANK
|
GXVBANK_BANK_CODE_PIDM
|
NO
|
NO
|
CHART_OF_ACCOUNTS
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
FAB1099
|
FAB1099_COAS_CODE
|
NO
|
NO
|
CHART_OF_ACCOUNTS_DESC
|
Chart of accounts description.
|
VARCHAR2(255)
|
FTVCOAS
|
FTVCOAS_TITLE
|
NO
|
NO
|
CHECK_CANCEL_DATE
|
Date the check was canceled.
|
DATE
|
FAB1099
|
FAB1099_CANCEL_DATE
|
NO
|
NO
|
CHECK_CANCEL_IND
|
Indicates whether the check was canceled.
|
VARCHAR2(1)
|
FAB1099
|
FAB1099_CANCEL_IND
|
NO
|
NO
|
CHECK_DATE
|
Check issue date.
|
DATE
|
FAB1099
|
FAB1099_CHECK_DATE
|
NO
|
NO
|
CHECK_NUMBER
|
Check number.
|
VARCHAR2(63)
|
FAB1099
|
FAB1099_CHECK_NUM
|
NO
|
NO
|
CITY
|
Address city, town or municipality.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
NO
|
NO
|
COUNTY
|
County for this address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_COUNTY
|
NO
|
NO
|
COUNTY_DESC
|
County description
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
NO
|
NO
|
DOCUMENT
|
Document referenced as source for the amount. Typically an invoice.
|
VARCHAR2(63)
|
FAB1099
|
FAB1099_INVH_CODE
|
NO
|
NO
|
ENTITY_TYPE_IND
|
Indicates whether the vendor is a person or non-person record.
|
VARCHAR2(1)
|
FUNCTION
|
MFKFUNC.F_GET_VENDOR_FIELDS
|
NO
|
NO
|
FEDERAL_ADDRESS_NUMBER
|
Sequence used to identify different addresses within the same address type.
|
NUMBER
|
FTVVEND
|
FTVVEND_1099_ADDR_SEQNO
|
NO
|
NO
|
FEDERAL_ADDRESS_TYPE
|
Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.
|
VARCHAR2(63)
|
FTVVEND
|
FTVVEND_1099_ATYP_CODE
|
NO
|
NO
|
FEDERAL_PREVIOUSLY_PAID
|
Amount preivously paid to the federal government.
|
NUMBER
|
FAB1099
|
FAB1099_FED_PAID_OVER_AMT
|
NO
|
NO
|
FEDERAL_REPORT_VENDOR_ID
|
Identification number assigned to a Doing Business As vendor that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MFKFUNC.F_GET_VENDOR_FIELDS
|
NO
|
NO
|
FEDERAL_REPORT_VENDOR_NAME
|
Name of the Doing Business As vendor.
|
VARCHAR2(255)
|
FUNCTION
|
MFKFUNC.F_GET_VENDOR_FIELDS
|
NO
|
NO
|
FEDERAL_REPORT_VENDOR_UID
|
System generated, unique, internal identification number assigned to this person or organization entity providing a cross reference from Doing Business As vendor to the vendor_uid for federal reporting like the United States 1099-MISC form.
|
NUMBER
|
FTVVEND
|
FTVVEND_PIDM_OWNER
|
NO
|
NO
|
FEDERAL_WITHHOLDING
|
Amount withheld from a taxable disbursement for remittance to the government.
|
NUMBER
|
FAB1099
|
FAB1099_FED_WHOLD_AMT
|
NO
|
NO
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MFKFUNC.F_GET_VENDOR_FIELDS
|
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
|
NAME
|
Name of the vendor.
|
VARCHAR2(255)
|
FUNCTION
|
MFKFUNC.F_GET_VENDOR_FIELDS
|
NO
|
NO
|
NATION
|
Nation/country code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_NATN_CODE
|
NO
|
NO
|
NATION_DESC
|
Address nation/country description.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
PAYER_NAME
|
Institution or payer name associated with the tax identification number reported.
|
VARCHAR2(255)
|
FAB1099
|
FOB1099_INST_NAME
|
NO
|
NO
|
PAYER_TAX_ID
|
Tax identification number of the institution or payer of a federal transaction.
|
VARCHAR2(63)
|
FOB1099
|
FAB1099_INST_TIN
|
NO
|
NO
|
POSTAL_CODE
|
Address postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
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
|
REPORTED_AMOUNT
|
Reported amount for tax purposes.
|
NUMBER
|
FAB1099
|
FAB1099_RPT_AMT
|
NO
|
NO
|
STATE_PROVINCE
|
State or province associated with this address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_STAT_CODE
|
NO
|
NO
|
STATE_PROVINCE_DESC
|
State or province description.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
NO
|
NO
|
STATE_PROVINCE_PREVIOUSLY_PAID
|
Amount preivously paid to the state/province or taxing authority.
|
NUMBER
|
FAB1099
|
FAB1099_ST_PAID_OVER_AMT
|
NO
|
NO
|
STATE_PROVINCE_WITHHOLDING
|
Amount withheld for state/province taxes from a taxable disbursement.
|
NUMBER
|
FAB1099
|
FAB1099_ST_WHOLD_AMT
|
NO
|
NO
|
STREET_LINE1
|
First line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
NO
|
NO
|
STREET_LINE2
|
Second line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
NO
|
NO
|
STREET_LINE3
|
Third line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
NO
|
NO
|
STREET_LINE4
|
Fourth line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE4
|
NO
|
NO
|
TAXABLE_INCOME_ACTIVITY_DATE
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
FAB1099
|
FAB1099_ACTIVITY_DATE
|
NO
|
NO
|
TAXABLE_INCOME_USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
FAB1099
|
FAB1099_USER_ID
|
NO
|
NO
|
TAX_INCOME_TYPE
|
User value representing income type for 1099 processing and reporting purposes.
|
VARCHAR2(63)
|
FTVITYP
|
FTVITYP_CODE
|
NO
|
NO
|
TAX_INCOME_TYPE_DESC
|
Tax income type description
|
VARCHAR2(255)
|
FTVITYP
|
FTVITYP_DESC
|
NO
|
NO
|
TAX_INCOME_TYPE_KEY
|
Unique, internal, system generated value representing the user selected income type for 1099 processing and reporting purposes.
|
NUMBER
|
FAB1099
|
FAB1099_ITYP_SEQ_CODE
|
NO
|
NO
|
TAX_YEAR
|
Tax year the transaction is reported for vendor taxable income.
|
VARCHAR2(63)
|
CALCULATION
|
TO_CHAR (TO_DATE (FAB1099_RPT_YR, 'RR'), 'YYYY')
|
NO
|
NO
|
VENDOR_TAX_ID
|
Reporting ID associated with the entity or person that received taxable payments.
|
VARCHAR2(63)
|
FAB1099
|
FAB1099_RPT_ID
|
NO
|
NO
|
VENDOR_UID
|
System generated unique internal identification number used to access the vendor.
|
NUMBER
|
FAB1099
|
FAB1099_VEND_PIDM
|
NO
|
NO
|