Target Column	Business Definition	Database Data Type	Source Name	Source Column
BANK	Code used to identify the bank account on all cash transactions.	VARCHAR2(2)	FAB1099	FAB1099_BANK_CODE
BANK_DESC	Name of the bank where the institution has accounts.	VARCHAR2(35)	GXVBANK	GXVBANK_ACCT_NAME
BANK_UID	Internal identification number of the bank where the institution has accounts	NUMBER(8)	GXVBANK	GXVBANK_BANK_CODE_PIDM
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FAB1099	FAB1099_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts description.	VARCHAR2(1)	FTVCOAS	FTVCOAS_TITLE
CHECK_CANCEL_DATE	Date the check was canceled.	DATE	FAB1099	FAB1099_CANCEL_DATE
CHECK_CANCEL_IND	Indicates whether the check was canceled.	VARCHAR2(1)	FAB1099	FAB1099_CANCEL_IND
CHECK_DATE	Check issue date.	DATE	FAB1099	FAB1099_CHECK_DATE
CHECK_NUMBER	Check number.	VARCHAR2(8)	FAB1099	FAB1099_CHECK_NUM
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOCUMENT	Document referenced as source for the amount. Typically an invoice.	VARCHAR2(8)	FAB1099	FAB1099_INVH_CODE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
FEDERAL_PREVIOUSLY_PAID	Amount preivously paid to the federal government.	NUMBER(17,2)	FAB1099	FAB1099_FED_PAID_OVER_AMT
FEDERAL_WITHHOLDING	Amount withheld from a taxable disbursement for remittance to the government.	NUMBER(17,2)	FAB1099	FAB1099_FED_WHOLD_AMT
MIF_DESC	Institution description for the record 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
PAYER_NAME	Institution or payer name associated with the tax identification number reported.	VARCHAR2(40)	FAB1099	FOB1099_INST_NAME
PAYER_TAX_ID	Tax identification number of the institution or payer of a federal transaction.	VARCHAR2(9)	FOB1099	FAB1099_INST_TIN
REPORTED_AMOUNT	Reported amount for tax purposes.	NUMBER(17,2)	FAB1099	FAB1099_RPT_AMT
STATE_PROVINCE_PREVIOUSLY_PAID	Amount preivously paid to the state/province or taxing authority.	NUMBER(17,2)	FAB1099	FAB1099_ST_PAID_OVER_AMT
STATE_PROVINCE_WITHHOLDING	Amount withheld for state/province taxes from a taxable disbursement.	NUMBER(17,2)	FAB1099	FAB1099_ST_WHOLD_AMT
TAXABLE_INCOME_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FAB1099	FAB1099_ACTIVITY_DATE
TAXABLE_INCOME_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FAB1099	FAB1099_USER_ID
TAX_INCOME_TYPE	User value representing income type for 1099 processing and reporting purposes.	VARCHAR2(2)	FTVITYP	FTVITYP_CODE
TAX_INCOME_TYPE_DESC	Tax income type description	VARCHAR2(35)	FTVITYP	FTVITYP_DESC
TAX_INCOME_TYPE_KEY	Unique, internal, system generated value representing the user selected income type for 1099 processing and reporting purposes.	NUMBER(2)	FAB1099	FAB1099_ITYP_SEQ_CODE
TAX_YEAR	Tax year the transaction is reported for vendor taxable income.	VARCHAR2(4)	CALCULATION	TO_CHAR (TO_DATE (FAB1099_RPT_YR, 'RR'), 'YYYY')
VENDOR_TAX_ID	Reporting ID associated with the entity or person that received taxable payments.	VARCHAR2(9)	FAB1099	FAB1099_RPT_ID
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER(8)	FAB1099	FAB1099_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: