SOP30201 - Sales Deposit History
Query Builder
| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| SOPTYPE | SOP Type 1 = Quote |
Integer | 2 | View | |
| SOPNUMBE | SOP Number |
String | 22 | View | |
| LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CUSTNAME | Customer Name |
String | 66 | View | |
| DOCDATE | Document Date |
Date | 4 | View | |
| DOCNUMBR | Document Number |
String | 22 | View | |
| RMDTYPAL | RM Document Type-All 0 = Reserved for balance carried forward records |
Integer | 2 | View | |
| PYMTTYPE | Payment Type |
Integer | 2 | View | |
| AMNTPAID | Amount Paid |
Currency | 10 | View | |
| OAMTPAID | Originating Amount Paid |
Currency | 10 | View | |
| CHEKBKID | Checkbook ID |
String | 16 | View | |
| CHEKNMBR | Check Number |
String | 22 | View | |
| CARDNAME | Card Name |
String | 16 | View | |
| RCTNCCRD | Receipt Number Credit Card |
String | 22 | View | |
| EXPNDATE | Expiration Date |
Date | 4 | View | |
| AUTHCODE | Authorization Code |
String | 16 | View | |
| PYMNTDAT | Payment Date |
Date | 4 | View | |
| GLPOSTDT | GL Posting Date |
Date | 4 | View | |
| CASHINDEX | Cash Index |
Long Integer | 4 | View | |
| DEPINDEX | Deposits Index |
Long Integer | 4 | View | |
| DELETE1 | Delete |
Boolean | 2 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
| DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
| RATETPID | Rate Type ID |
String | 16 | View | |
| RTCLCMTD | Rate Calculation Method |
Integer | 2 | View | |
| EXGTBLID | Exchange Table ID |
String | 16 | View | |
| EXCHDATE | Exchange Date |
Date | 4 | View | |
| MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
| TIME1 | Time |
Time | 4 | View | |
| TRXSORCE | TRX Source |
String | 14 | View |