Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
BANK
|
Code used to identify the bank account on all cash transactions.
|
VARCHAR2(2)
|
FAB1099
|
FAB1099_BANK_CODE
|
NO
|
NO
|
BANK_DESC
|
Name of the bank where the institution has accounts.
|
VARCHAR2(35)
|
GXVBANK
|
GXVBANK_ACCT_NAME
|
NO
|
NO
|
BANK_UID
|
Internal identification number of the bank where the institution has accounts
|
NUMBER(8)
|
GXVBANK
|
GXVBANK_BANK_CODE_PIDM
|
NO
|
NO
|
CHART_OF_ACCOUNTS
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(1)
|
FAB1099
|
FAB1099_COAS_CODE
|
NO
|
NO
|
CHART_OF_ACCOUNTS_DESC
|
Chart of accounts description.
|
VARCHAR2(1)
|
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(8)
|
FAB1099
|
FAB1099_CHECK_NUM
|
NO
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOCUMENT
|
Document referenced as source for the amount. Typically an invoice.
|
VARCHAR2(8)
|
FAB1099
|
FAB1099_INVH_CODE
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
FEDERAL_PREVIOUSLY_PAID
|
Amount preivously paid to the federal government.
|
NUMBER(17,2)
|
FAB1099
|
FAB1099_FED_PAID_OVER_AMT
|
NO
|
NO
|
FEDERAL_WITHHOLDING
|
Amount withheld from a taxable disbursement for remittance to the government.
|
NUMBER(17,2)
|
FAB1099
|
FAB1099_FED_WHOLD_AMT
|
NO
|
NO
|
MIF_DESC
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PAYER_NAME
|
Institution or payer name associated with the tax identification number reported.
|
VARCHAR2(40)
|
FAB1099
|
FOB1099_INST_NAME
|
NO
|
NO
|
PAYER_TAX_ID
|
Tax identification number of the institution or payer of a federal transaction.
|
VARCHAR2(9)
|
FOB1099
|
FAB1099_INST_TIN
|
NO
|
NO
|
REPORTED_AMOUNT
|
Reported amount for tax purposes.
|
NUMBER(17,2)
|
FAB1099
|
FAB1099_RPT_AMT
|
NO
|
NO
|
STATE_PROVINCE_PREVIOUSLY_PAID
|
Amount preivously paid to the state/province or taxing authority.
|
NUMBER(17,2)
|
FAB1099
|
FAB1099_ST_PAID_OVER_AMT
|
NO
|
NO
|
STATE_PROVINCE_WITHHOLDING
|
Amount withheld for state/province taxes from a taxable disbursement.
|
NUMBER(17,2)
|
FAB1099
|
FAB1099_ST_WHOLD_AMT
|
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(30)
|
FAB1099
|
FAB1099_USER_ID
|
NO
|
NO
|
TAX_INCOME_TYPE
|
User value representing income type for 1099 processing and reporting purposes.
|
VARCHAR2(2)
|
FTVITYP
|
FTVITYP_CODE
|
NO
|
NO
|
TAX_INCOME_TYPE_DESC
|
Tax income type description
|
VARCHAR2(35)
|
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(2)
|
FAB1099
|
FAB1099_ITYP_SEQ_CODE
|
NO
|
NO
|
TAX_YEAR
|
Tax year the transaction is reported for vendor taxable income.
|
VARCHAR2(4)
|
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(9)
|
FAB1099
|
FAB1099_RPT_ID
|
NO
|
NO
|
VENDOR_UID
|
System generated unique internal identification number used to access the vendor.
|
NUMBER(8)
|
FAB1099
|
FAB1099_VEND_PIDM
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|