Module List > Module ENC tables ENC10500
You are currently viewing the COMPANY database.
Change

COMPANY..ENC10500 Table Definition

(COMPANY..Encumbrance Received Transactions)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PONUMBER char(17)
''
PO Number ...(more) Join Now POP10110.PONUMBER
POLNENUM int
0
PO Line Nu...(more) Join Now POP10500.POLNENUM
POPTYPE smallint
0
POP Type D...(more) Join Now
POPRCTNM char(17)
''
POP Receip...(more) Join Now POP40100.POPRCTNM
RCPTLNNM int
0
Receipt Li...(more) Join Now POP10500.RCPTLNNM
Status smallint
0
p>Field Ty...(more) Join Now SVC00700.STATUS
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
TRXDATE datetime
'1/1/1900'

YEAR1 smallint
0
Year: The ...(more) Join Now UPR00900.YEAR1
PERIODID smallint
0

QTYSHPPD numeric(19,5)
0.00
QTY Shippe...(more) Join Now POP10500.QTYSHPPD
QTYINVCD numeric(19,5)
0.00
QTY Invoic...(more) Join Now
QTYRESERVED numeric(19,5)
0.00
QTY Reserv...(more) Join Now
INVINDX int
0
Inventory ...(more) Join Now POP10110.INVINDX
UOFM char(9)
''
U of M The...(more) Join Now POP10110.UOFM
See I... more text available
UMDPQTYS smallint
0

UMQTYINB numeric(19,5)
0.00
U Of M QTY...(more) Join Now
OREXTCST numeric(19,5)
0.00
Field Type...(more) Join Now SVC35200.OREXTCST
LIQUDAMT numeric(19,5)
0.00

REQDATE datetime
'1/1/1900'
Required D...(more) Join Now POP10110.REQDATE
aaDimID int
0

aaTrxDimID int
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