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.'