Module List > Module PA tables PA00531
You are currently viewing the COMPANY database.
Change

COMPANY..PA00531 Table Definition

(COMPANY..PA Customer MSTR WIP SUM)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CUSTNMBR char(15)
''
Customer c...(more) Join Now
join ... more text available
AGPERAMT_1 numeric(19,5)
0.00
Array fiel...(more) Join Now RM00103.AGPERAMT_1
AGPERAMT_2 numeric(19,5)
0.00
Array fiel...(more) Join Now RM00103.AGPERAMT_2
AGPERAMT_3 numeric(19,5)
0.00
Array fiel...(more) Join Now RM00103.AGPERAMT_3
AGPERAMT_4 numeric(19,5)
0.00
Array fiel...(more) Join Now RM00103.AGPERAMT_4
AGPERAMT_5 numeric(19,5)
0.00
Array fiel...(more) Join Now RM00103.AGPERAMT_5
AGPERAMT_6 numeric(19,5)
0.00
Array fiel...(more) Join Now RM00103.AGPERAMT_6
AGPERAMT_7 numeric(19,5)
0.00
Array fiel...(more) Join Now RM00103.AGPERAMT_7
PAACREV numeric(19,5)
0.00

LASTAGED datetime
'1/1/1900'
The date t...(more) Join Now RM00103.LASTAGED
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