Not logged in - Login

CM10100 - CM Deposit Work - table structure

Great Plains Table Structure

  • CM10100 - CM Deposit Work
  • Technical Name - CM_Deposit_WORK
  • Series - Financial
  • Physical Name - CM10100

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