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

COMPANY..RM00104 Table Definition

(COMPANY..Customer Period Summary)

This file would not normally be imported into. An exception would be to provide totals for previous periods for years before the product was used for comparative reports to current data.

This table contains sales information for customers on a calendar or fiscal basis, as defined using the Fiscal Period Setup window. Users can enter unlimited period information. No duplicate records can be stored in this table; one record should exist for each period.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CUSTNMBR char(15)
''
Customer I...(more) Join Now
join ... more text available
PERIODID smallint
0
The period...(more) Join Now
YEAR1 smallint
0
The fiscal...(more) Join Now
HISTTYPE smallint
0
History Ty...(more) Join Now
NUMOFINV int
0
Number of ...(more) Join Now
SMRYSALS numeric(19,5)
0.00
Sales Amou...(more) Join Now
SMRYCRCD numeric(19,5)
0.00
Cash Recei...(more) Join Now
SMRYCOST numeric(19,5)
0.00
Cost of go...(more) Join Now
SMRYWROF numeric(19,5)
0.00
Amount wri...(more) Join Now
SMRYDISC numeric(19,5)
0.00
Discounts ...(more) Join Now
SMRYRTNG numeric(19,5)
0.00
Summary of...(more) Join Now
SMRYFCHR numeric(19,5)
0.00
Summary of...(more) Join Now
SMRYWFCH numeric(19,5)
0.00
Summary of...(more) Join Now
SMRYRTRN numeric(19,5)
0.00
Summary of...(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