SOPTYPE | smallint | Yes | 2=ORDER,3=INVOICE,4=RETURN,5=BKORDER,6=Fulfillment Order | IN |
DOCAMNT | numeric(19,5) | Yes | Payment Amount and only used for @I_vAction = 1 or 3 | IN |
CHEKNMBR | char(20) | No | Check Number, value if check | IN |
RCTNCCRD | char(20) | No | Credit Card Number, value if credit card | IN |
PYMTTYPE | int | No | 1=Cash Deposit,2=Check Deposit,3=Credit Card Deposit,4=Cash Payment,5=Check Payment,6=Credit Card Payment | IN |
DOCNUMBR | char(20) | Yes | Payment Number/Cash Receipt Number if @I_vAction=2 and @I_vSOPTYPE=2 and @I_vPYMTTYPE in (1,2,3) | IN |
Action | smallint | No | 1=New Trx/Add new Payment; 2=Delete Payment; 3=Modify existing payment | IN |
SEQNUMBR | int | Yes | Sequence Number-required if @I_vAction=1 and @I_vSOPTYPE=2 and multiple @I_vPYMTTYPE=6 exist | IN |
MDFUSRID | char(15) | No | Modified User iD - - Added for PR#505 - use this in CM20300 insert or else blank if not supplied per JAR | IN |
VOIDDATE | datetime | No | Void Date - - Added for PR#506 - use this in CM20300 update or else current date if not supplied per JAR | IN |
PROCESSELECTRONICALLY | tinyint | No | PROCESSELECTRONICALLY - - Added for Bug/Feature #58258 for use with Dynamics Online DO10103 table | 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 | Create Custom Business Logic | INOUT |
oErrString | varchar(255) | No | Create Custom Business Logic | INOUT |