RVLPD009 - Sales Payment Document OPEN
SQL Query Builder
36 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| RMDTYPAL | smallint 0 | |||
| DOCNUMBR | char(21) '' | |||
| CUSTNMBR | char(15) '' | |||
| CUSTNAME | char(65) '' | |||
| STMTNAME | char(65) '' | |||
| PMTDOCID | char(15) '' | |||
| CHEKNMBR | char(21) '' | |||
| PDOCSTRM | smallint 0 | |||
| CHEKBKID | char(15) '' | |||
| DOCDATE | datetime '1/1/1900' | |||
| DUEDATE | datetime '1/1/1900' | |||
| DOCAMNT | numeric(19,5) 0.00 | |||
| ORDOCAMT | numeric(19,5) 0.00 | |||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char(15) '' | ||
| CURRNIDX | smallint 0 | |||
| TRXDSCRN | char(31) '' | |||
| NOTEINDX | numeric(19,5) 0.00 | |||
| VALSTRG1 | char(65) '' | |||
| VALSTRG2 | char(65) '' | |||
| VALSTRG3 | char(65) '' | |||
| VALSTRG4 | char(65) '' | |||
| VALSTRG5 | char(65) '' | |||
| VALSTRG6 | char(65) '' | |||
| VALDATE1 | datetime '1/1/1900' | |||
| VALDATE2 | datetime '1/1/1900' | |||
| VALCURR1 | numeric(19,5) 0.00 | |||
| VALCURR2 | numeric(19,5) 0.00 | |||
| VALBACT1 | char(35) '' | |||
| VALBACT2 | char(35) '' | |||
| TRXSORCE | char(13) '' | |||
| MKDBYUSR | char(15) '' | |||
| MKTOPROC | tinyint 0 | |||
| REMTYPE | smallint 0 | |||
| REMITID | char(15) '' | |||
| CMRecordNumber | numeric(19,5) 0.00 | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with RVLPD009. Click "Join" to add to your query.