GP Tables

RVLPD006 - Sales Payment Document Chequebook Setup

SQL Query Builder

21 Columns

Column Description Type Length
CHEKBKID char(15) ''
PMTDOCID char(15) ''
NextPmntDocNum char(21) ''
RCVDPMNTDOCGLACCT int 0
ASSESSPMNTDOCGLACCTIDX int 0
DISCPMNTDOCGLACCTIDX int 0
COLLECTPMNTDOCGLACCT int 0
NSFPMNTDOCGLACCT int 0
SETTLEPMNTDOCGLACCT int 0
RcvdPmntDocCheckbook char(15) ''
AssessPmntDocCheckbook char(15) ''
DISCPMNTDOCCHECKBOOK char(15) ''
CollectPmntDocCheckbook char(15) ''
NSFPmntDocCheckbook char(15) ''
SettlePmntDocCheckbook char(15) ''
MaxPmntDocAmt numeric(19,5) 0.00
ExceedPmntDocPassword char(11) ''
DuplicatePmntDocNum tinyint 0
OverridePmntDocNum tinyint 0
NOTEINDX numeric(19,5) 0.00
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with RVLPD006. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

NOTEINDX

AAG00201 AAG00300 AAG00400 AAG00401 AF40100 AF40103 AF40106 APR_BLM42100

RCVDPMNTDOCGLACCT

ASSESSPMNTDOCGLACCTIDX

DISCPMNTDOCGLACCTIDX

COLLECTPMNTDOCGLACCT

NSFPMNTDOCGLACCT

SETTLEPMNTDOCGLACCT