RMDTYPAL | smallint | Yes | RM Type 1=Sales/Invoice 2=Debit Memo 3=Finance Charge 4=Service/Repair 5=Warranty | IN |
DOCNUMBR | char(20) | Yes | Document Number | IN |
DOCDATE | datetime | Yes | Document Date | IN |
BACHNUMB | char(15) | Yes | Batch Number | IN |
CUSTNMBR | char(15) | Yes | Customer Number | IN |
DOCAMNT | numeric(19,5) | Yes | Document Amount | IN |
SLSAMNT | numeric(19,5) | Yes | Sales Amount | IN |
DOCDESCR | char(30) | No | Document Description | IN |
ADRSCODE | char(15) | No | Address Code | IN |
SLPRSNID | char(15) | No | Salesperson ID | IN |
SALSTERR | char(15) | No | Sales Territory | IN |
SHIPMTHD | char(15) | No | Shipping Method | IN |
TAXSCHID | char(15) | No | Tax Schedule ID | IN |
CSTPONBR | char(20) | No | Customer PO Number | IN |
COSTAMNT | numeric(19,5) | No | Cost Amount | IN |
TRDISAMT | numeric(19,5) | No | Trade Discount Amount | IN |
TRDDISCT | smallint | No | Trade Discount | IN |
FRTAMNT | numeric(19,5) | No | Freight Amount | IN |
MISCAMNT | numeric(19,5) | No | Miscellenous Amount | IN |
TAXAMNT | numeric(19,5) | No | Tax Amount | IN |
BKTSLSAM | numeric(19,5) | No | Backout Sales Amount | IN |
BKTFRTAM | numeric(19,5) | No | Backout Freight Amount | IN |
BKTMSCAM | numeric(19,5) | No | Backout Misc. Amount | IN |
CASHAMNT | numeric(19,5) | No | Cash Amount | IN |
CBKIDCSH | char(15) | No | Checkbook ID Cash | IN |
CASHDATE | datetime | No | Cash Date | IN |
DCNUMCSH | char(20) | No | Document Number Cash | IN |
CHEKAMNT | numeric(19,5) | No | Check Amount | IN |
CBKIDCHK | char(15) | No | Checkbook ID Check | IN |
CBKIDCRD | char(15) | No | Checkbook ID Credit Card | IN |
CHEKNMBR | char(20) | No | Check Number | IN |
CHEKDATE | datetime | No | Check Date | IN |
DCNUMCHK | char(20) | No | Document Number of the Check | IN |
CRCRDAMT | numeric(19,5) | No | Credit Card Amount | IN |
CRCRDNAM | char(15) | No | Credit Card Name | IN |
RCTNCCRD | char(20) | No | Receipt Numb. for C.Card | IN |
CRCARDDT | datetime | No | Credit Card Date | IN |
DCNUMCRD | char(20) | No | Document Number for C.Card | IN |
DISCRTND | numeric(19,5) | No | Discount Returned | IN |
DISTKNAM | numeric(19,5) | No | Discount Taken Amount | IN |
WROFAMNT | numeric(19,5) | No | Write Off Amt for Credit Docs | IN |
PPSAMDED | numeric(19,5) | No | PPS Amt Deducted for Credits | IN |
GSTDSAMT | numeric(19,5) | No | GST Discount Amount | IN |
PYMTRMID | char(20) | No | Payment Term ID | IN |
DISAVAMT | numeric(19,5) | No | Discount Avail. Amount | IN |
DSCDLRAM | numeric(19,5) | No | Discount Dollar Amount | IN |
DSCPCTAM | numeric(19,5) | No | Discount Percent Amount | IN |
LSTUSRED | char(15) | No | Last User to Edit | IN |
PTDUSRID | char(15) | No | Posted User ID | IN |
DistRef | char(30) | No | Distribution Reference | IN |
BatchCHEKBKID | char(15) | No | Checkbook ID for the batch | IN |
DUEDATE | datetime | No | Due Date | IN |
DISCDATE | datetime | No | Discount Date | IN |
CURNCYID | char(15) | No | Currency ID - 08/20/01 - Added for Multi-Currency | IN |
XCHGRATE | numeric(19,5) | No | Exchange Rate - 08/20/01 - Added for Multi-Currency - MC020103 | IN |
RATETPID | char(15) | No | Rate Type ID - 08/20/01 - Added for Multi-Currency - MC020103 | IN |
EXPNDATE | datetime | No | Expiration Date - 08/20/01 - Added for Multi-Currency - MC00100 | IN |
EXCHDATE | datetime | No | Exchange Date - 08/20/01 - Added for Multi-Currency - MC00100 | IN |
EXGTBDSC | char(30) | No | Exchange ID Desc. - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
EXTBLSRC | char(50) | No | Exchange Rate Source - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
RATEEXPR | smallint | No | Rate Expiration - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
DYSTINCR | smallint | No | Days to Increment - 08/20/01 - Added for Multi-Currency - MC40300 only used when RATEEXPR = 8 | IN |
RATEVARC | numeric(19,5) | No | Rate Variance - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
TRXDTDEF | smallint | No | Trx Date Default - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
RTCLCMTD | smallint | No | Rate Calc. Method - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
PRVDSLMT | smallint | No | Previous Days Limits - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
DATELMTS | smallint | No | Date Limits - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
TIME1 | datetime | No | Time 1 - 08/20/01 - 03/11/02 - Added for Multi-Currency - MC40300 | IN |
COMDLRAM | numeric(19,5) | No | Commission Amount | IN |
COMAPPTO | smallint | No | Commission Apply To | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
CREATEDIST | smallint | No | Flag to auto create distributions: 0=Manual; 1=Automatic | 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 |