Module List > Module TM tables RepCustS
You are currently viewing the COMPANY database.
Change

COMPANY..RepCustS Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SLPRSNID char
''
Salesperso...(more) Join Now PA01101.SLPRSNID
join ... more text available
CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
LY_ShippedJan numeric
0.00

LY_ShippedFeb numeric
0.00

LY_ShippedMar numeric
0.00

LY_ShippedApr numeric
0.00

LY_ShippedMay numeric
0.00

LY_ShippedJun numeric
0.00

LY_ShippedJul numeric
0.00

LY_ShippedAug numeric
0.00

LY_ShippedSep numeric
0.00

LY_ShippedOct numeric
0.00

LY_ShippedNov numeric
0.00

LY_ShippedDec numeric
0.00

CY_ShippedJan numeric
0.00

CY_ShippedFeb numeric
0.00

CY_ShippedMar numeric
0.00

CY_ShippedApr numeric
0.00

CY_ShippedMay numeric
0.00

CY_ShippedJun numeric
0.00

CY_ShippedJul numeric
0.00

CY_ShippedAug numeric
0.00

CY_ShippedSep numeric
0.00

CY_ShippedOct numeric
0.00

CY_ShippedNov numeric
0.00

CY_ShippedDec numeric
0.00

AA_CY_OpenJan numeric
0.00

AA_CY_OpenFeb numeric
0.00

AA_CY_OpenMar numeric
0.00

AA_CY_OpenApr numeric
0.00

AA_CY_OpenMay numeric
0.00

AA_CY_OpenJun numeric
0.00

AA_CY_OpenJul numeric
0.00

AA_CY_OpenAug numeric
0.00

AA_CY_OpenSep numeric
0.00

AA_CY_OpenOct numeric
0.00

AA_CY_OpenNov numeric
0.00

AA_CY_OpenDec numeric
0.00

AA_LY_Qty_ShippedJan numeric
0.00

AA_LY_Qty_ShippedFeb numeric
0.00

AA_LY_Qty_ShippedMar numeric
0.00

AA_LY_Qty_ShippedApr numeric
0.00

AA_LY_Qty_ShippedMay numeric
0.00

AA_LY_Qty_ShippedJun numeric
0.00

AA_LY_Qty_ShippedJul numeric
0.00

AA_LY_Qty_ShippedAug numeric
0.00

AA_LY_Qty_ShippedSep numeric
0.00

AA_LY_Qty_ShippedOct numeric
0.00

AA_LY_Qty_ShippedNov numeric
0.00

AA_LY_Qty_ShippedDec numeric
0.00

AA_CY_Qty_ShippedJan numeric
0.00

AA_CY_Qty_ShippedFeb numeric
0.00

AA_CY_Qty_ShippedMar numeric
0.00

AA_CY_Qty_ShippedApr numeric
0.00

AA_CY_Qty_ShippedMay numeric
0.00

AA_CY_Qty_ShippedJun numeric
0.00

AA_CY_Qty_ShippedJul numeric
0.00

AA_CY_Qty_ShippedAug numeric
0.00

AA_CY_Qty_ShippedSep numeric
0.00

AA_CY_Qty_ShippedOct numeric
0.00

AA_CY_Qty_ShippedNov numeric
0.00

AA_CY_Qty_ShippedDec numeric
0.00

AA_CY_Qty_OpenJan numeric
0.00

AA_CY_Qty_OpenFeb numeric
0.00

AA_CY_Qty_OpenMar numeric
0.00

AA_CY_Qty_OpenApr numeric
0.00

AA_CY_Qty_OpenMay numeric
0.00

AA_CY_Qty_OpenJun numeric
0.00

AA_CY_Qty_OpenJul numeric
0.00

AA_CY_Qty_OpenAug numeric
0.00

AA_CY_Qty_OpenSep numeric
0.00

AA_CY_Qty_OpenOct numeric
0.00

AA_CY_Qty_OpenNov numeric
0.00

AA_CY_Qty_OpenDec numeric
0.00

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