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

COMPANY..PAM10502 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BTCHID char
''

BACHDATE datetime
'1/1/1900'

TRXDATE datetime
'1/1/1900'

YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
PERIODID smallint
0

TMPBCHST char
''

NUMENT smallint
0

BONCST numeric
0.00

BTCHTOTL numeric
0.00

BATCHBAL numeric
0.00

CREATUSR char
''

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

POSTEDDT datetime
'1/1/1900'
Posted Date The system date at the time the transaction iso psted B3950340.POSTEDDT
MKDTOPST tinyint
0

USERID char
''
The user t...(more) Join Now WRS10001.USERID
INVADJST tinyint
0

EXPRTDBY char
''

EXPRTDDT datetime
'1/1/1900'

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_WH_CHANGED tinyint
0

Processed tinyint
0

MC_Processed tinyint
0

APPRVLDT datetime
'1/1/1900'
Approval D...(more) Join Now
Approval_Time datetime
'1/1/1900'

APPROVL tinyint
0
Approval: ...(more) Join Now SY30500.APPROVL
APRVLUSERID char
''
Approval U...(more) Join Now SY30500.APRVLUSERID
CLASSID char
''

LocalTax_Processed tinyint
0

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