RVLPD003 - Sales Payment Document Master
SQL Query Builder
33 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PMTDOCID | char(15) '' | |||
| PmntDocDescription | char(65) '' | |||
| CHEKBKID | char(15) '' | |||
| SettleBeforeDueDate | tinyint 0 | |||
| Discountable | tinyint 0 | |||
| Collectable | tinyint 0 | |||
| DeferredDisc | tinyint 0 | |||
| NOTEINDX | numeric(19,5) 0.00 | |||
| USRSTRG1 | char(25) '' | |||
| USRSTRG2 | char(25) '' | |||
| USRSTRG3 | char(25) '' | |||
| USRSTRG4 | char(25) '' | |||
| USRSTRG5 | char(25) '' | |||
| USRSTRG6 | char(25) '' | |||
| USRDATE1 | char(25) '' | |||
| USRDATE2 | char(25) '' | |||
| USRCURR1 | char(25) '' | |||
| USRCURR2 | char(25) '' | |||
| USRBACT1 | char(25) '' | |||
| USRBACT2 | char(25) '' | |||
| ReqUserDefnStr1 | tinyint 0 | |||
| ReqUserDefnStr2 | tinyint 0 | |||
| ReqUserDefnStr3 | tinyint 0 | |||
| ReqUserDefnStr4 | tinyint 0 | |||
| ReqUserDefnStr5 | tinyint 0 | |||
| ReqUserDefnStr6 | tinyint 0 | |||
| ReqUserDefnDate1 | tinyint 0 | |||
| ReqUserDefnDate2 | tinyint 0 | |||
| ReqUserDefnCurr1 | tinyint 0 | |||
| ReqUserDefnCurr2 | tinyint 0 | |||
| ReqUserDefnBankAcct1 | tinyint 0 | |||
| ReqUserDefnBankAcct2 | tinyint 0 | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with RVLPD003. Click "Join" to add to your query.