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

COMPANY..PA11000 Table Definition

(COMPANY..PA Billing Commissions LINK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PABILLTRXT smallint
0

PADocnumber20 char(17)
''

SEQNUMBR int
0
Sequence N...(more) Join Now SEE30303.SEQNUMBR
PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
SLPRSNID char(15)
''
Used only ...(more) Join Now
join ... more text available
SALSTERR char(15)
''
Defaults w...(more) Join Now
join ... more text available
COMPRCNT smallint
0
The Commis...(more) Join Now
COMDLRAM numeric(19,5)
0.00
Commission...(more) Join Now RM20101.COMDLRAM
CMMSLAMT numeric(19,5)
0.00
Commission...(more) Join Now SOP30200.CMMSLAMT
PAPERBILL smallint
0

COMAPPTO smallint
0
The method...(more) Join Now
PABillingAmount numeric(19,5)
0.00

COMMFLAG smallint
0

ACTVTYPE smallint
0

NCOMAMNT numeric(19,5)
0.00
Non-Commis...(more) Join Now RM10301.NCOMAMNT
POSTED tinyint
0
Posted: S...(more) Join Now RM10301.POSTED
ORCOMAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC00600.ORCOMAMT
ORCOSAMT numeric(19,5)
0.00
Orig Commi...(more) Join Now SOP30200.ORCOSAMT
PAOrigBillAmount numeric(19,5)
0.00

ORNCMAMT numeric(19,5)
0.00
Orig Non-C...(more) Join Now SOP30200.ORNCMAMT
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