Module List > Module RM tables RM10301
You are currently viewing the COMPANY database.
Change

COMPANY..RM10301 Table Definition

(COMPANY..RM Sales Work File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DOCTYPE smallint
0
Document T...(more) Join Now
RMDTYPAL smallint
0
RM Documen...(more) Join Now
RMDNUMWK char(17)
''
RM Documen...(more) Join Now
DOCNUMBR char(21)
''
Document N...(more) Join Now
DOCPRFIX char(3)
''
Document P...(more) Join Now
DOCDESCR char(31)
''
Document D...(more) Join Now
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
CUSTNMBR char(15)
''
Customer I...(more) Join Now
join ... more text available
CUSTNAME char(65)
''
Customer N...(more) Join Now
ADRSCODE char(15)
''
Address Co...(more) Join Now
SLPRSNID char(15)
''
The salesp...(more) Join Now
join ... more text available
SALSTERR char(15)
''
Territory ...(more) Join Now
join ... more text available
COMAPPTO smallint
0
Commission...(more) Join Now
COMDLRAM numeric(19,5)
0.00
Commission...(more) Join Now
NCOMAMNT numeric(19,5)
0.00
The dollar...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
CSTPONBR char(21)
''
Customer P...(more) Join Now
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
SLSCHDID char(15)
''
Sales Sche...(more) Join Now
FRTSCHID char(15)
''
Freight Sc...(more) Join Now
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
COSTAMNT numeric(19,5)
0.00
Cost Amoun...(more) Join Now
SLSAMNT numeric(19,5)
0.00
Sales Amou...(more) Join Now
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
TRDDISCT smallint
0
Trade Disc...(more) Join Now
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
MISCAMNT numeric(19,5)
0.00
Misc Amoun...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
BKTSLSAM numeric(19,5)
0.00
Backout Sa...(more) Join Now
BKTFRTAM numeric(19,5)
0.00
Backout Fr...(more) Join Now
BKTMSCAM numeric(19,5)
0.00
Backout Mi...(more) Join Now
TXENGCLD tinyint
0
Tax Engine...(more) Join Now
DOCAMNT numeric(19,5)
0.00
Document A...(more) Join Now
APPLDAMT numeric(19,5)
0.00
Applied Am...(more) Join Now
CASHAMNT numeric(19,5)
0.00
Cash Amoun...(more) Join Now
CBKIDCSH char(15)
''
Checkbook ...(more) Join Now
CASHDATE datetime
'1/1/1900'
Cash Date:...(more) Join Now
DCNUMCSH char(21)
''
Document N...(more) Join Now
CHEKAMNT numeric(19,5)
0.00
Check Amou...(more) Join Now
CBKIDCHK char(15)
''
Checkbook ...(more) Join Now
CBKIDCRD char(15)
''
Checkbook ...(more) Join Now
CHEKNMBR char(21)
''
Check Numb...(more) Join Now
CHEKDATE datetime
'1/1/1900'
Check Date...(more) Join Now
DCNUMCHK char(21)
''
Document N...(more) Join Now
CRCRDAMT numeric(19,5)
0.00
Credit Car...(more) Join Now
CRCRDNAM char(15)
''
Credit Car...(more) Join Now
RCTNCCRD char(21)
''
Receipt Nu...(more) Join Now
CRCARDDT datetime
'1/1/1900'
Credit Car...(more) Join Now
DCNUMCRD char(21)
''
Document N...(more) Join Now
DISCRTND numeric(19,5)
0.00
Discount R...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
DISAVTKN numeric(19,5)
0.00
Discount A...(more) Join Now
WROFAMNT numeric(19,5)
0.00
Write Off ...(more) Join Now
PPSAMDED numeric(19,5)
0.00
PPS Amount...(more) Join Now
GSTDSAMT numeric(19,5)
0.00
GST Discou...(more) Join Now
ACCTAMNT numeric(19,5)
0.00
Account Am...(more) Join Now
PYMTRMID char(21)
''
Payment Te...(more) Join Now
SY033... more text available
DISAVAMT numeric(19,5)
0.00
Discount A...(more) Join Now
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now
DSCPCTAM smallint
0
Discount P...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
POSTED tinyint
0
Posted: S...(more) Join Now
LSTEDTDT datetime
'1/1/1900'
Last Edit ...(more) Join Now
LSTUSRED char(15)
''
Last User ...(more) Join Now
RMTREMSG binary(4)
0
RM transac...(more) Join Now
RMDPEMSG binary(4)
0
RM Dist Po...(more) Join Now
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now
PTDUSRID char(15)
''
Posted Use...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now
APLYWITH tinyint
0
Apply With...(more) Join Now
SALEDATE datetime
'1/1/1900'
Sale Date:...(more) Join Now
CORRCTN tinyint
0
Correction...(more) Join Now
SIMPLIFD tinyint
0
Simplified...(more) Join Now
CORRNXST tinyint
0
Correction...(more) Join Now
DOCNCORR char(21)
''
Document N...(more) Join Now
RMTREMSG2 binary(4)
0
RM TRX Pos...(more) Join Now
DocPrinted tinyint
0
DocPrinted...(more) Join Now
DISGRPER smallint
0
Discount G...(more) Join Now
DUEGRPER smallint
0
Due Date G...(more) Join Now
Electronic tinyint
0
Electronic...(more) Join Now
ECTRX tinyint
0
EC Transac...(more) Join Now
PSTGSTUS smallint
0
Posting St...(more) Join Now
BackoutTradeDisc numeric(19,5)
0.00
Backout Tr...(more) Join Now
DIRECTDEBIT tinyint
0
Direct Deb...(more) Join Now SOP10100.DIRECTDEBIT
EFTFLAG tinyint
0
EFT Flag T...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3