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

COMPANY..PAM60501 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

PAYTXAMT numeric
0.00

OPAYAMT numeric
0.00

OPYTXAMT numeric
0.00

INVCDDT datetime
'1/1/1900'

INVCNMBR char
''

RMDTYPAL smallint
0
RM Documen...(more) Join Now RVLPD013.RMDTYPAL
TOTALFEE numeric
0.00

FEETXAMT numeric
0.00

OTOTALFE numeric
0.00

OTFTXAMT numeric
0.00

DOCTYPE smallint
0
Document T...(more) Join Now PM30200.DOCTYPE
VCHRNMBR char
''
Voucher Nu...(more) Join Now PP100101.VCHRNMBR
ONCOSTAM numeric
0.00

DAYSWRDK int
0

STATE char
''

PAM_Invoice_Grouping 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

JRNENTRY int
0

CHEKNMBR char
''

PAM_GL_Audit_Trail_Code char
''

PAM_RM_TRX_Source char
''

PAM_PM_TRX_Source char
''

PAM_UPR_Audit_Control_Co char
''

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
INVOICBY char
''

CURNCYID char
''
Currency I...(more) Join Now MC40200.CURNCYID
CURRNIDX smallint
0
Currency I...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now WO010213.TIME1
XCHGRATE numeric
0.00
Exchange R...(more) Join Now MC00100.XCHGRATE
EXGTBLID char
''
Exchange T...(more) Join Now MC00100.EXGTBLID
RATETPID char
''

RTCLCMTD smallint
0
Rate calcu...(more) Join Now MC40300.RTCLCMTD
DENXRATE numeric
0.00
Exchange R...(more) Join Now
Creditor_Currency_ID char
''

Creditor_Currency_Index smallint
0

Creditor_EXCHDATE datetime
'1/1/1900'

Creditor_TIME1 datetime
'1/1/1900'

Creditor_XCHGRATE numeric
0.00

Creditor_EXGTBLID char
''

Creditor_RATETPID char
''

Creditor_RTCLCMTD smallint
0

Creditor_DENXRATE numeric
0.00

TAXSCHID char
''

PORDNMBR char
''
Purchase O...(more) Join Now JC00701.PORDNMBR
SHFTCODE char
''
Shift Code...(more) Join Now UPR30501.SHFTCODE
SHFTPREM numeric
0.00

PAM_Payroll_Tax_Costs numeric
0.00

PAM_Payroll_Benefit_Cost numeric
0.00

PAM_Vendor_Costs numeric
0.00

INVFORMT char
''

COMPTRNM int
0

HOLDCDID char
''

DCAMOUNT numeric
0.00

PAM_Original_Cost numeric
0.00

Reverse_Batch_ID char
''

REV_DATE datetime
'1/1/1900'

REVUSERID char
''

REVERSEDDATE datetime
'1/1/1900'

INVADJST tinyint
0

PAM_Discount_ID char
''

DISCAMNT numeric
0.00

ORDDLRAT numeric
0.00
Originatin...(more) Join Now
Flat_Rate_Bill_Amount numeric
0.00

ODCAAmount numeric
0.00

OFRBAMT numeric
0.00

PRCSSQNC smallint
0

Originating_OC_Amount numeric
0.00

PAMTSNUM char
''

Consolidated_Invoice char
''

Orig_Batch_ID char
''

OrigSeq 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

ADJCODE char
''

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