Module List > Module POP tables POP10200
You are currently viewing the COMPANY database.
Change

COMPANY..POP10200 Table Definition

(COMPANY..popRequisition)
Purchase Order Requisition Work
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
POPRequisitionNumber char
''

Requisition_Note_Index numeric
0.00

RequisitionDescription char
''

RequisitionStatus smallint
0

COMMNTID char
''

join ... more text available
Comment_Note_Index numeric
0.00

DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
REQDATE datetime
'1/1/1900'
Required D...(more) Join Now OSRC1100.REQDATE
REQSTDBY char
''

PRSTADCD char
''

join ... more text available
CMPNYNAM char
''
Company Na...(more) Join Now ACTIVITY.CMPNYNAM
CONTACT char
''

ADDRESS1 char
''

ADDRESS2 char
''

ADDRESS3 char
''

CITY char
''

STATE char
''

ZIPCODE char
''

CCode char
''

COUNTRY char
''

PHONE1 char
''

PHONE2 char
''

PHONE3 char
''

FAX char
''

DOCAMNT numeric
0.00
Source Doc...(more) Join Now RVLPD026.DOCAMNT
CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
USER2ENT char
''

Flags smallint
0

Workflow_Status smallint
0

DomainUserName char
''

USERDEF1 char
''
UserDefine...(more) Join Now PM00200.USERDEF1
USERDEF2 char
''
UserDefine...(more) Join Now PM00200.USERDEF2
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