Module List > Module BS tables B3950003
You are currently viewing the COMPANY database.
Change

COMPANY..B3950003 Table Definition

(COMPANY..BSSI_RM_Sales_Work_Temp)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DOCTYPE smallint
0
Document T...(more) Join Now POP10110.DOCTYPE
RMDTYPAL smallint
0
RM Documen...(more) Join Now RM20102.RMDTYPAL
RMDNUMWK char(17)
''

DOCNUMBR char(21)
''
Document N...(more) Join Now RM20102.DOCNUMBR
DOCPRFIX char(3)
''

DOCDESCR char(31)
''
Document D...(more) Join Now UPR00500.DOCDESCR
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
CUSTNMBR char(15)
''
Customer N...(more) Join Now POP10100.CUSTNMBR
join ... more text available
CUSTNAME char(65)
''

ADRSCODE char(15)
''
Address Co...(more) Join Now UPR00102.ADRSCODE
SLPRSNID char(15)
''
Salesperso...(more) Join Now PA01101.SLPRSNID
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now POP10100.TAXSCHID
join ... more text available
SLSCHDID char(15)
''

FRTSCHID char(15)
''
Freight Sc...(more) Join Now POP10100.FRTSCHID
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now POP10100.MSCSCHID
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 TX00301.SLSAMNT
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
TRDDISCT smallint
0

FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
MISCAMNT numeric(19,5)
0.00
Misc Amoun...(more) Join Now SOP30200.MISCAMNT
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now VAT10302.TAXAMNT
BKTSLSAM numeric(19,5)
0.00
Backout Sa...(more) Join Now SOP30300.BKTSLSAM
BKTFRTAM numeric(19,5)
0.00
Backout Fr...(more) Join Now SOP30200.BKTFRTAM
BKTMSCAM numeric(19,5)
0.00
Backout Mi...(more) Join Now
TXENGCLD tinyint
0
Tax Engine...(more) Join Now POP10100.TXENGCLD
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now TX30000.DOCAMNT
APPLDAMT numeric(19,5)
0.00

CASHAMNT numeric(19,5)
0.00
Cash Amoun...(more) Join Now RM50100.CASHAMNT
CBKIDCSH char(15)
''

CASHDATE datetime
'1/1/1900'

DCNUMCSH char(21)
''

CHEKAMNT numeric(19,5)
0.00
Check Amou...(more) Join Now RM10301.CHEKAMNT
CBKIDCHK char(15)
''

CBKIDCRD char(15)
''

CHEKNMBR char(21)
''

ACCTAMNT numeric(19,5)
0.00
Account Am...(more) Join Now
PYMTRMID char(21)
''
Payment Te...(more) Join Now POP10100.PYMTRMID
SY033... more text available
DISAVAMT numeric(19,5)
0.00
Discount A...(more) Join Now SOP30200.DISAVAMT
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date T...(more) Join Now POP10100.DUEDATE
CURNCYID char(15)
''
Currency I...(more) Join Now POP10100.CURNCYID
join ... more text available
POSTED tinyint
0

PSTGSTUS smallint
0
Posting St...(more) Join Now SOP10100.PSTGSTUS
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