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

COMPANY..PA05100 Table Definition

(COMPANY..PA Project Billing Master File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PABILLTRXT smallint
0

PADocnumber20 char(17)
''

PADOCDT datetime
'1/1/1900'

DCSTATUS smallint
0

CUSTNMBR char(15)
''
Customer c...(more) Join Now
join ... more text available
PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PABillingAmount numeric(19,5)
0.00

PARetainer_Fee_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
APPLDAMT numeric(19,5)
0.00

CURTRXAM numeric(19,5)
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