Module List > Module PAM tables PAM93501
You are currently viewing the COMPANY database.
Change

COMPANY..PAM93501 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BTCHID char
''

SEQNUMBR int
0
Sequence N...(more) Join Now SEE30303.SEQNUMBR
TEMPID char
''

CUSTNMBR char
''
Customer c...(more) Join Now
JOBNUMBR char
''
Job Number...(more) Join Now SF010601.JOBNUMBR
DATE1 datetime
'1/1/1900'

HOURSWKD int
0

TIMEWRKD int
0

TIMEID char
''

PAYRATE numeric
0.00

PAYTYPID char
''

PAYAMT numeric
0.00

TOTALFEE numeric
0.00

ONCOSTAM numeric
0.00

DAYSWRDK int
0

STATE char
''

USERDEF1 char
''
UserDefine...(more) Join Now JC00701.USERDEF1
USERDEF2 char
''
UserDefine...(more) Join Now JC00701.USERDEF2
USRDEF03 char
''

NOTEINDX numeric
0.00
Note Index...(more) Join Now
POSITION_ID char
''

PYTIMEID char
''

PAM_Time_Billed int
0

PAM_Hours_Billed int
0

PAM_Bill_Rate numeric
0.00

CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
CRUSRID char
''

MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now WDC41400.MODIFDT
MODTIME datetime
'1/1/1900'

MDFUSRID char
''
User that ...(more) Join Now SY40500.MDFUSRID
PAM_Rule_ID char
''

New_Batch_ID char
''

Flat_Rate_Bill_Amount numeric
0.00

ODCAAmount numeric
0.00

OFRBAMT numeric
0.00

DCAMOUNT numeric
0.00

Originating_OC_Amount numeric
0.00

INVFORMT char
''

PAM_Original_Cost numeric
0.00

OPAYAMT numeric
0.00

OTOTALFE numeric
0.00

State_ID char
''

SC_JournalEntry int
0

PAM_VMSAmount numeric
0.00

PAM_VMSInvoiceDate datetime
'1/1/1900'

PAM_VMSInvoiceNumber char
''

PAM_VMS_FeeAmount numeric
0.00

PAM_VMS_FeeAmountOrig 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