CM10100 - CM Deposit Work - table structure


Great Plains Table Structure

Column Listing:
NameData Type
CHEKBKIDchar(15)
depositnumberchar(21)
DEPTYPEsmallint
DEPWTHRCTtinyint
DEPDATEdatetime
GLPOSTDTdatetime
DepAmtnumeric(19,5)
MDFUSRIDchar(15)
MODIFDTdatetime
CURNCYIDchar(15)
DSCRIPTNchar(31)
USERDEF1char(21)
USERDEF2char(21)
NOTEINDXnumeric(19,5)
RCRDSTTSsmallint
RATETPIDchar(15)
EXGTBLIDchar(15)
XCHGRATEnumeric(19,7)
EXCHDATEdatetime
TIME1datetime
RTCLCMTDsmallint
EXPNDATEdatetime
CURRNIDXsmallint
DECPLCURsmallint
DENXRATEnumeric(19,7)
MCTRXSTTsmallint
DEX_ROW_IDint


Last modified by Mohit @ 4/6/2025 9:42:45 PM