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

COMPANY..RepCusOr Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SOPTYPE smallint
0

SOPNUMBE char
''

AA_Document_Type char
''

SLPRSNID char
''
Salesperso...(more) Join Now PA01101.SLPRSNID
join ... more text available
AA_YearMonth char
''

AA_Year char
''

AA_Month char
''

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
DATE1 datetime
'1/1/1900'

QTYORDER numeric
0.00

QTYSHPPD numeric
0.00
QTY Shippe...(more) Join Now OSRC1300.QTYSHPPD
QTYCANCE numeric
0.00
QTY Cancel...(more) Join Now ENC10111.QTYCANCE
QTYBKORD numeric
0.00

AA_QTY_Open numeric
0.00

XTNDPRCE numeric
0.00
Field Type...(more) Join Now SC020630.XTNDPRCE
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