depositnumber | char(20) | Yes | - Deposit Number | IN |
RCPTNMBR | char(20) | Yes | - Receipt Number | IN |
CHEKBKID | char(15) | Yes | - Checkbook ID | IN |
RcpType | smallint | Yes | - Receipt Type - 1=Check; 2=Cash; 3=Credit Card | IN |
CMRECNUM | numeric(19,5) | Yes | - Receipt Number - use only if @I_vRCPTNMBR+@I_vCHEKBKID+@I_vRcpType are not unique | IN |
DEPDATE | datetime | No | - Deposit Date - Needs to match taCreateBankDepositHeader if MC Trx | IN |
BANKNAME | char(30) | No | - Bank Name - used to update the CM20300 if you pass a value | IN |
BNKBRNCH | char(20) | No | - Bank Branch - used to update the CM20300 if you pass a value | IN |
CURRENCYTOTAL | int | No | - Originating Currency Total | IN |
COINTOTAL | numeric(19,5) | No | - Originating Coin Total | IN |
XCHGRATE | numeric(19,5) | No | - Exchange Rate - Added for Multi-Currency - MC020103 | IN |
RATETPID | char(15) | No | - Rate Type ID - Added for Multi-Currency - MC020103 | IN |
EXPNDATE | datetime | No | - Expiration Date - Added for Multi-Currency - MC00100 | IN |
EXCHDATE | datetime | No | - Exchange Date - Added for Multi-Currency - MC00100 | IN |
EXGTBDSC | char(30) | No | - Exchange ID Desc. - Added for Multi-Currency - MC40300 | IN |
EXTBLSRC | char(50) | No | - Exchange Rate Source - Added for Multi-Currency - MC40300 | IN |
RATEEXPR | smallint | No | - Rate Expiration - Added for Multi-Currency - MC40300 | IN |
DYSTINCR | smallint | No | - Days to Increment - Added for Multi-Currency - MC40300 - only used when RATEEXPR = 8 | IN |
RATEVARC | numeric(19,5) | No | - Rate Variance - Added for Multi-Currency - MC40300 | IN |
TRXDTDEF | smallint | No | - Trx Date Default - Added for Multi-Currency - MC40300 - 0=Exact Date; 1=Next Date; 2=Previous Date | IN |
RTCLCMTD | smallint | No | - Rate Calc. Method - Added for Multi-Currency - MC40300 - 0=Multiply; 1=Divide | IN |
PRVDSLMT | smallint | No | - Previous Days Limits - Added for Multi-Currency - MC40300 | IN |
DATELMTS | smallint | No | - Date Limits - Added for Multi-Currency - MC40300 - 0=Unlimited; 1=Limited | IN |
TIME1 | datetime | No | - Time 1 - Added for Multi-Currency - MC40300 | IN |
RequesterTrx | smallint | No | - Requester Trx - 0=False; 1=True - if true then populates shadow table *NOT USED* | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
ErrorState | int | No | Error Code | INOUT |
oErrString | varchar(255) | No | Create Custom Business Logic | INOUT |