SOP10103 - Sales Payments (Work & History)
Stores payment information applied to sales documents including deposits and payments.
SQL Query Builder
27 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| SOPTYPE | smallint 0 | ||||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| SOPNUMBE | char(21) '' | ||||
| SEQNUMBR | int 0 | ||||
| PYMTTYPE | smallint 0 | ||||
Payment Type (SOP) values (6) 1 = Cash Deposit2 = Check Deposit3 = Credit Card Deposit4 = Cash Payment5 = Check Payment6 = Credit Card Payment | |||||
| DOCNUMBR | char(21) '' | ||||
| RMDTYPAL | smallint 0 | ||||
| CHEKBKID | char(15) '' | ||||
| CHEKNMBR | char(21) '' | ||||
| CARDNAME | char(15) '' | ||||
| RCTNCCRD | char(21) '' | ||||
| AUTHCODE | char(15) '' | ||||
| AMNTPAID | numeric(19,5) 0.00 | ||||
| OAMTPAID | numeric(19,5) 0.00 | ||||
| AMNTREMA | numeric(19,5) 0.00 | ||||
| OAMNTREM | numeric(19,5) 0.00 | ||||
| DOCDATE | datetime '1/1/1900' | ||||
| EXPNDATE | datetime '1/1/1900' | ||||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char(15) '' | |||
| CURRNIDX | smallint 0 | ||||
| TRXSORCE | char(13) '' | ||||
| DEPSTATS | smallint 0 | ||||
| DELETE1 | tinyint 0 | ||||
| GLPOSTDT | datetime '1/1/1900' | ||||
| CASHINDEX | int 0 | ||||
| DEPINDEX | int 0 | ||||
| EFTFLAG | tinyint 0 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Reporting Tips
- - PYMTTYPE identifies the payment method (cash, check, credit card)
Related Tables
Tables that share columns with SOP10103. Click "Join" to add to your query.