BACHNUMB | char(15) | Yes | Batch Number | IN |
JRNENTRY | int | Yes | Journal Entry Number | IN |
REFRENCE | char(30) | Yes | Reference | IN |
TRXDATE | datetime | Yes | Transaction Date | IN |
RVRSNGDT | datetime | No | Reversing Date | IN |
TRXTYPE | smallint | Yes | Transaction Type 0 = Regular & 1 = Reversing | IN |
SQNCLINE | numeric(19,5) | No | Sequence Line | IN |
SERIES | smallint | No | Series | IN |
CURNCYID | char(15) | No | Currency ID - Added for Multi-Currency | 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 | IN |
RTCLCMTD | smallint | No | Rate Calc. Method - Added for Multi-Currency - MC40300 | IN |
PRVDSLMT | smallint | No | Previous Days Limits - Added for Multi-Currency - MC40300 | IN |
DATELMTS | smallint | No | Date Limits - Added for Multi-Currency - MC40300 | IN |
TIME1 | datetime | No | Time 1 - Added for Multi-Currency - MC40300 | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
SOURCDOC | char(11) | No | Source Document | IN |
Ledger_ID | smallint | No | Ledger ID - - 1=Base, 2=IFRS, 3=Local | IN |
USERID | char(15) | No | User ID | IN |
Adjustment_Transaction | smallint | No | Notes field | IN |
NOTETEXT | varchar(8000) | No | Notes field | 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 | Return value: 0=No Errors, 1=Error Occurred | INOUT |
oErrString | varchar(255) | No | Return Error Code List | INOUT |