First Data Provisioning Report UML
Added On: 12/08/15
Module: UniCharge
Type: Entity
Status: Active
Java Class: FirstDataProvisioningReport
Added On: 12/08/15
SQL Column: ACCOUNT_CLOSED
Java Field: accountClosed
Status: Active
SQL Type: datetime
Java Type: Date
Date when the account was closed.
Note: Leave blank if Merchant_Account_Status field is “O”. If Merchant_Account_Status field is “C”, - use YYYY-MMDD format ('include dashes').
Added On: 12/08/15
SQL Column: ACCOUNT_OPENED
Java Field: accountOpened
Status: Active
SQL Type: datetime
Java Type: Date
Date when the account was opened.
Note: Use YYYY-MM-DD format ('include dashes').
Added On: 12/08/15
SQL Column: ADD_TO_RSRV_COLLATERAL
Java Field: addToRsrvCollateral
Status: Active
SQL Type: int(11)
Java Type: Integer
The amount added to the Reserve/Collateral.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars. '
Added On: 12/08/15
SQL Column: AMTS_OFFSET_DEBITED_CURRENT_MONTH
Java Field: amtsOffsetDebitedCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Amount Offset/Debited for the current month.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars. '
Added On: 12/08/15
SQL Column: AMTS_OFFSET_DEBITED12_MONTHS
Java Field: amtsOffsetDebited12Months
Status: Active
SQL Type: int(11)
Java Type: Integer
Amounts Offset/Debited for the past 12 months.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'.
Added On: 12/08/15
SQL Column: BUSINESS_CHANGE_CODE_CL
Java Field: businessChangeCodeCl
Status: Active
SQL Type: varchar(1)
Java Type: String
Represents current (or selected) business change code.
Added On: 12/08/15
SQL Column: CARD_TYPE
Java Field: cardType
Status: Active
SQL Type: varchar(1)
Java Type: String
Type of the credit card that was used for processed transaction.
Note: If multiple credit card types in file then -
- V = Visa;
- M = MasterCard;
- A = Amex;
- D = Discover.
Added On: 12/08/15
SQL Column: CC_CB_COUNT_CURRENT_MONTH
Java Field: ccCbCountCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Number of credit card chargebacks for the current month (1-st chargebacks only).
Note: 'No commas.'
Added On: 12/08/15
SQL Column: CC_CB_DOLLAR_CURRENT_MONTH
Java Field: ccCbDollarCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Credit card chargeback dollars for the current month (1-st chargebacks only).
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
Added On: 12/08/15
SQL Column: CC_REFUND_COUNT_CURRENT_MONTH
Java Field: ccRefundCountCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Number of credit card refunds for the current month.
Note: 'No commas.'
Added On: 12/08/15
SQL Column: CC_REFUND_DOLLARS_CURRENT_MONTH
Java Field: ccRefundDollarsCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Credit card refund dollars for the current month.
Note: 'Use decimal points to separate cents. Do not use commas.'
Added On: 12/08/15
SQL Column: CC_SALES_COUNT_CURRENT_MONTH
Java Field: ccSalesCountCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Number of credit card sales for the current month (both keyed and swiped).
Note: 'No commas'.
Added On: 12/08/15
SQL Column: CC_SALES_DOLLARS_CURRENT_MONTH
Java Field: ccSalesDollarsCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Credit card sales dollars for the current month (both keyed and swiped).
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
Added On: 12/08/15
SQL Column: CLOSE_BALANCE_RSRV_COLLATERAL
Java Field: closeBalanceRsrvCollateral
Status: Active
SQL Type: int(11)
Java Type: Integer
The closing balance of the Reserve/ Collateral.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars. '
A reserve balance may not be less than zero.
Added On: 12/08/15
SQL Column: CURRENCY_ISO_CODE
Java Field: currencyIsoCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Currency ISO code (i.e. US DOLLARS =USD).
Added On: 12/08/15
SQL Column: DATE_OF_LAST_SALES_TRANSACTION
Java Field: dateOfLastSalesTransaction
Status: Active
SQL Type: int(11)
Java Type: Integer
Date when the last sales transaction was processed.
Note: 'Leave blank if the sub-merchant has not yet processed a sale or refund. Otherwise, use YYYY-MM-DD format. Include dashes. '
Added On: 12/08/15
SQL Column: FIRST_DATA_PROVISIONING_REPORT_BATCH_FK
Java Field: firstDataProvisioningReportBatch
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents FirstData provisioning report batch file information.
Added On: 12/08/15
SQL Column: GROSS_AMT_FUNDED_CURRENT_MONTH
Java Field: grossAmtFundedCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Gross amount funded for the current month.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
Added On: 12/08/15
SQL Column: GROSS_AMT_FUNDED12_MONTHS
Java Field: grossAmtFunded12Months
Status: Active
SQL Type: int(11)
Java Type: Integer
Gross amount funded for the past 12 months.
Note: Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.
Added On: 12/08/15
SQL Column: ID
Java Field: id
Status: Active
SQL Type: bigint(20)
Java Type: Long
Attributes:
Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On: 12/08/15
SQL Column: KEYED_AMOUNT_CURRENT_MONTH
Java Field: keyedAmountCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Keyed transaction dollars for the current month.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
This amount with be equal to or less than (and 'not' in addition to) the amount noted in CCSalesDollarsCurrentMonth.
Added On: 12/08/15
SQL Column: KEYED_COUNT_CURRENT_MONTH
Java Field: keyedCountCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
Number of keyed transactions for the current month.
Note: 'No commas.'
This amount with be equal to or less than (and not in addition to) the amount noted in CCSalesCountCurrent Month.
Added On: 12/08/15
SQL Column: MERCHANT_ABA
Java Field: merchantAba
Status: Active
SQL Type: varchar(9)
Java Type: String
Sub-merchant’s bank routing number.
- If payments are made by my check instead of ACH, place nine “1” in this field;
- If Payments are made to a Paypal account instead of ACH, place nine “0”;
- If payment are made to a prepaid card, use the ABA of the prepaid card issuer.
Added On: 12/08/15
SQL Column: MERCHANT_ACCOUNT_CODE
Java Field: merchantAccountCode
Status: Active
SQL Type: int(11)
Java Type: Integer
Code of
Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On: 12/08/15
SQL Column: MERCHANT_ACCOUNT_STATUS
Java Field: merchantAccountStatus
Status: Active
SQL Type: varchar(1)
Java Type: String
Current status of the merchant account.
Added On: 12/08/15
SQL Column: MERCHANT_BILL_TO_ADDRESS1
Java Field: merchantBillToAddress1
Status: Active
SQL Type: varchar(60)
Java Type: String
Street (line 1) of the sub-merchant's billing address.
Note: This is the address used to mail notices to the sub-merchant. Often referred to as the legal address.
Added On: 12/08/15
SQL Column: MERCHANT_BILL_TO_ADDRESS2
Java Field: merchantBillToAddress2
Status: Active
SQL Type: varchar(60)
Java Type: String
Street (line 2) of the sub-merchant's billing address.
Note: This is the address used to mail notices to the sub-merchant. Optional if no info available. Blank acceptable.
Added On: 12/08/15
SQL Column: MERCHANT_BILL_TO_CITY
Java Field: merchantBillToCity
Status: Active
SQL Type: varchar(60)
Java Type: String
City of the sub-merchant's billing address.
Note: This is the address used to mail notices to the sub-merchant.
Added On: 12/08/15
SQL Column: MERCHANT_BILL_TO_COUNTRY
Java Field: merchantBillToCountry
Status: Active
SQL Type: varchar(10)
Java Type: String
Country of the sub-merchant's billing address.
Added On: 12/08/15
SQL Column: MERCHANT_BILL_TO_STATE
Java Field: merchantBillToState
Status: Active
SQL Type: varchar(3)
Java Type: String
State code of the sub-merchant's billing address.
Note: This is the address used to mail notices to the sub-merchant.
Added On: 12/08/15
SQL Column: MERCHANT_BILL_TO_ZIP
Java Field: merchantBillToZip
Status: Active
SQL Type: varchar(10)
Java Type: String
ZIP (or postal) code of the sub-merchant's billing address.
Added On: 12/08/15
SQL Column: MERCHANT_CARDHOLDER_DESCRIPTOR
Java Field: merchantCardholderDescriptor
Status: Active
SQL Type: varchar(250)
Java Type: String
Sub-merchant descriptor of the cardholder.
Added On: 12/08/15
SQL Column: MERCHANT_COUNTRY
Java Field: merchantCountry
Status: Active
SQL Type: varchar(10)
Java Type: String
Country of the sub-merchant's mailing address.
Added On: 12/08/15
SQL Column: MERCHANT_DBA_ADDRESS
Java Field: merchantDbaAddress
Status: Active
SQL Type: varchar(60)
Java Type: String
Street (line 1) of the sub-merchant's address where business is conducted.
Added On: 12/08/15
SQL Column: MERCHANT_DBA_ADDRESS2
Java Field: merchantDbaAddress2
Status: Active
SQL Type: varchar(60)
Java Type: String
Street (line 2) of the sub-merchant's address where business is conducted.
Note: Optional - if no information is available. Blank acceptable.
Added On: 12/08/15
SQL Column: MERCHANT_DBA_CITY
Java Field: merchantDbaCity
Status: Active
SQL Type: varchar(60)
Java Type: String
City of the sub-merchant's address where business is conducted.
Added On: 12/08/15
SQL Column: MERCHANT_DBA_NAME
Java Field: merchantDbaName
Status: Active
SQL Type: varchar(60)
Java Type: String
The "Doing Business As" name of the sub-merchant.
Added On: 12/08/15
SQL Column: MERCHANT_DBA_STATE
Java Field: merchantDbaState
Status: Active
SQL Type: varchar(3)
Java Type: String
State code of the sub-merchant's address where business is conducted.
Added On: 12/08/15
SQL Column: MERCHANT_DBA_ZIP
Java Field: merchantDbaZip
Status: Active
SQL Type: varchar(10)
Java Type: String
ZIP (or postal) code of the sub-merchant's address where business is conducted.
Note: 'No dashes.'
Added On: 12/08/15
SQL Column: MERCHANT_DDA
Java Field: merchantDda
Status: Active
SQL Type: varchar(50)
Java Type: String
Sub-merchant’s depository account number.
- If payments are made by my check instead of ACH, use the MID_RefNum as the Merchant_DDA;
- If payments are made to a Paypal account place the Paypal account number;
- If payments are made to a prepaid card, use the prepaid card number.
Added On: 12/08/15
SQL Column: MERCHANT_FAX
Java Field: merchantFax
Status: Active
SQL Type: varchar(15)
Java Type: String
Fax number of the sub-merchant for discussing any processing issues.
Note: Optional - if no information available. Blank acceptable. 'No parentheses or dashes'.
Added On: 12/08/15
SQL Column: MERCHANT_LEGAL_NAME
Java Field: merchantLegalName
Status: Active
SQL Type: varchar(60)
Java Type: String
Legal name of the sub-merchant.
Added On: 12/08/15
SQL Column: MERCHANT_MCC
Java Field: merchantMcc
Status: Active
SQL Type: varchar(4)
Java Type: String
Merchant category code (MCC).
Note: Each sub-merchant must be assigned the card brand MCC that best describes the product or service sold.
Added On: 12/08/15
SQL Column: MERCHANT_PHONE
Java Field: merchantPhone
Status: Active
SQL Type: varchar(15)
Java Type: String
Phone number of the sub-merchant for discussing any processing issues.
Note: 'No parentheses or dashes'.
Added On: 12/08/15
SQL Column: MERCHANT_TIN
Java Field: merchantTin
Status: Active
SQL Type: varchar(15)
Java Type: String
Sub-merchant's tax identification number.
Note: 'No dashes'.
Added On: 12/08/15
SQL Column: MERCHANT_URL
Java Field: merchantUrl
Status: Active
SQL Type: varchar(500)
Java Type: String
Sub-merchant’s URL/website.
Note: Optional if sub-merchant is not E-commerce and does not maintain a website. Blank acceptable.
Added On: 12/08/15
SQL Column: MONTH12_CB_CNT_WITH_CURRENT_MONTH
Java Field: month12CbCntWithCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month number of credit card chargeback charges with current month (1-st chargebacks only).
Note: 'No commas'.
Added On: 12/08/15
SQL Column: MONTH12_CB_DLLRS_WITH_CURRENT_MONTH
Java Field: month12CbDllrsWithCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month credit card chargeback dollars with current month (1-st chargebacks only).
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
Added On: 12/08/15
SQL Column: MONTH12_CC_CNT_WITH_CURRENT_MONTH
Java Field: month12CcCntWithCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month number of credit card sales with current month (both keyed and swiped).
Note: 'No commas.'
Added On: 12/08/15
SQL Column: MONTH12_CC_DLLRS_WITH_CURRENT_MONTH
Java Field: month12CcDllrsWithCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month credit card sales dollars with current month (both keyed and swiped).
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
Added On: 12/08/15
SQL Column: MONTH12_CC_REFUND_CNT_WITH_CURRENT_MONTH
Java Field: month12CcRefundCntWithCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month number of credit card refunds with current month.
Note: 'No commas'.
Added On: 12/08/15
SQL Column: MONTH12_KEYED_AMOUNT
Java Field: month12KeyedAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month keyed transaction dollars with the current month.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
This amount with be equal to or less than (and not in addition to) the amount noted in 12MonthCCDllrsWithCurrentMonth.
Added On: 12/08/15
SQL Column: MONTH12_KEYED_COUNT
Java Field: month12KeyedCount
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month number of keyed transactions with current month.
Note: 'No commas.'
This amount with be equal to or less than (and 'not' in addition to) the amount noted in 12MonthCCCntWith CurrentMonth.
Added On: 12/08/15
SQL Column: MONTH12_PIN_CNT_WITH_CURRENT_MONTH
Java Field: month12PinCntWithCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month PIN debit count with current month.
Note: 'No commas.'
Added On: 12/08/15
SQL Column: MONTH12_PIN_DLLRS_WITH_CURRENT_MONTH
Java Field: month12PinDllrsWithCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month PIN debit dollars with the current month.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars. '
Added On: 12/08/15
SQL Column: MONTH12_REFUND_DLLRS_WITH_CURRENT_MONTH
Java Field: month12RefundDllrsWithCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
12 month credit card refund dollars with current month.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
Added On: 12/08/15
SQL Column: OPENING_BALANCE_RSRV_COLLATERAL
Java Field: openingBalanceRsrvCollateral
Status: Active
SQL Type: int(11)
Java Type: Integer
Opening Balance of the Reserve/ Collateral.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
This must equal the prior month’s closing balance.
Added On: 12/08/15
SQL Column: PIN_COUNT_CURRENT_MONTH
Java Field: pinCountCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
PIN debit count for the current month.
Note: 'No commas.'
Added On: 12/08/15
SQL Column: PIN_DLRS_CURRENT_MONTH
Java Field: pinDlrsCurrentMonth
Status: Active
SQL Type: int(11)
Java Type: Integer
PIN debit dollars for the current month.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'
Added On: 12/08/15
SQL Column: PRINCIPAL_ADDRESS
Java Field: principalAddress
Status: Active
SQL Type: varchar(60)
Java Type: String
Street address (line 1) of the principal.
Added On: 12/08/15
SQL Column: PRINCIPAL_ADDRESS2
Java Field: principalAddress2
Status: Active
SQL Type: varchar(60)
Java Type: String
Street address (line 2) of the principal.
Added On: 12/08/15
SQL Column: PRINCIPAL_CHANGE_CODE_CL
Java Field: principalChangeCodeCl
Status: Active
SQL Type: varchar(1)
Java Type: String
Represents the change code for the principal.
Added On: 12/08/15
SQL Column: PRINCIPAL_CITY
Java Field: principalCity
Status: Active
SQL Type: varchar(40)
Java Type: String
City of the principal's mailing address.
Added On: 12/08/15
SQL Column: PRINCIPAL_CONTACT_EMAIL
Java Field: principalContactEmail
Status: Active
SQL Type: varchar(150)
Java Type: String
Contact email of the principal for discussing any processing issues.
Added On: 12/08/15
SQL Column: PRINCIPAL_COUNTRY
Java Field: principalCountry
Status: Active
SQL Type: varchar(3)
Java Type: String
Country code of the principal's mailing address.
Added On: 12/08/15
SQL Column: PRINCIPAL_DOB
Java Field: principalDob
Status: Active
SQL Type: datetime
Java Type: Date
Date of birth of the principal.
Note: Use YYYY-MM-DD format. 'Include dashes'.
Added On: 12/08/15
SQL Column: PRINCIPAL_FIRST_NAME
Java Field: principalFirstName
Status: Active
SQL Type: varchar(40)
Java Type: String
First name of the principal.
Added On: 12/08/15
SQL Column: PRINCIPAL_ID
Java Field: principalId
Status: Active
SQL Type: varchar(20)
Java Type: String
Identification number of the principal in the system.
Added On: 12/08/15
SQL Column: PRINCIPAL_LAST_NAME
Java Field: principalLastName
Status: Active
SQL Type: varchar(40)
Java Type: String
Last name of the principal.
Added On: 12/08/15
SQL Column: PRINCIPAL_MIDDLE_NAME
Java Field: principalMiddleName
Status: Active
SQL Type: varchar(40)
Java Type: String
Middle name of the principal. If none, leave blank.
Added On: 12/08/15
SQL Column: PRINCIPAL_PHONE
Java Field: principalPhone
Status: Active
SQL Type: varchar(15)
Java Type: String
Phone number of the principal for discussing any processing issues.
Added On: 12/08/15
SQL Column: PRINCIPAL_SSN
Java Field: principalSsn
Status: Active
SQL Type: varchar(12)
Java Type: String
Social security number of the principal.
Added On: 12/08/15
SQL Column: PRINCIPAL_STATE
Java Field: principalState
Status: Active
SQL Type: varchar(3)
Java Type: String
State code of the principal's mailing address.
Added On: 12/08/15
SQL Column: PRINCIPAL_TITLE
Java Field: principalTitle
Status: Active
SQL Type: varchar(20)
Java Type: String
Title of the principal (for example, owner, President, Director, Member etc).
Added On: 12/08/15
SQL Column: PRINCIPAL_ZIP
Java Field: principalZip
Status: Active
SQL Type: varchar(10)
Java Type: String
ZIP (or postal) code of the principal's mailing address.
Added On: 07/05/16
SQL Column: PROVISIONING_TRANSACTION_FK
Java Field: provisioningTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents provisioning transaction information.
Added On: 12/08/15
SQL Column: SUBTRACT_WITHDRAW_RSRV_COLLATERAL
Java Field: subtractWithdrawRsrvCollateral
Status: Active
SQL Type: int(11)
Java Type: Integer
The amount subtracted/withdrawn from Reserve/Collateral.
Note: 'Do not use commas to separate currency units (hundreds, thousands, millions etc). Use decimal points to separate cents from whole dollars.'