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

COMPANY..POP30310 Table Definition

(COMPANY..Purchasing Receipt Line History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
POPRCTNM char(17)
''
POP Receip...(more) Join Now
RCPTLNNM int
0
Receipt Li...(more) Join Now
PONUMBER char(17)
''
PO Number ...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now
VNDITNUM char(31)
''
Vendor Ite...(more) Join Now
VNDITDSC char(101)
''
Vendor Ite...(more) Join Now
UMQTYINB numeric(19,5)
0.00
U Of M QTY...(more) Join Now ENC10111.UMQTYINB
ACTLSHIP datetime
'1/1/1900'
Actual Shi...(more) Join Now
COMMNTID char(15)
''

join ... more text available
INVINDX int
0
Inventory ...(more) Join Now
UOFM char(9)
''
U Of M The...(more) Join Now
See I... more text available
UNITCOST numeric(19,5)
0.00
Unit Cost ...(more) Join Now
EXTDCOST numeric(19,5)
0.00
Extended C...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
RcptLineNoteIDArray_1 numeric(19,5)
0.00
NOTEINDX f...(more) Join Now
RcptLineNoteIDArray_2 numeric(19,5)
0.00
NOTEINDX f...(more) Join Now
RcptLineNoteIDArray_3 numeric(19,5)
0.00
NOTEINDX f...(more) Join Now
RcptLineNoteIDArray_4 numeric(19,5)
0.00

RcptLineNoteIDArray_5 numeric(19,5)
0.00

RcptLineNoteIDArray_6 numeric(19,5)
0.00
NOTEINDX f...(more) Join Now
RcptLineNoteIDArray_7 numeric(19,5)
0.00
span style...(more) Join Now
RcptLineNoteIDArray_8 numeric(19,5)
0.00

NONINVEN smallint
0

DECPLCUR smallint
0
Number of ...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
ITMTRKOP smallint
0
Item Track...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
JOBNUMBR char(17)
''
Job Number...(more) Join Now
COSTCODE char(27)
''
Cost Code ...(more) Join Now
COSTTYPE smallint
0
Cost Code ...(more) Join Now
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
ORUNTCST numeric(19,5)
0.00
Originatin...(more) Join Now
OREXTCST numeric(19,5)
0.00
Originatin...(more) Join Now
ODECPLCU smallint
0

BOLPRONUMBER char(31)
''

Capital_Item tinyint
0
Capital It...(more) Join Now
Product_Indicator smallint
0
Product In...(more) Join Now
Purchase_IV_Item_Taxable smallint
0
Purchase I...(more) Join Now
Purchase_Item_Tax_Schedu char(15)
''
Purchase I...(more) Join Now
Purchase_Site_Tax_Schedu char(15)
''
Purchase S...(more) Join Now
BSIVCTTL tinyint
0
Based On I...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
ORTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now
BCKTXAMT numeric(19,5)
0.00
Backout Ta...(more) Join Now
OBTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now
PURPVIDX int
0
Purchase P...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
Landed_Cost_Group_ID char(15)
''
Landed Cos...(more) Join Now
Landed_Cost_Warnings smallint
0

Landed_Cost tinyint
0
span style...(more) Join Now IV10200.Landed_Cost
Invoice_Match tinyint
0

RCPTRETNUM char(17)
''

RCPTRETLNNUM int
0

INVRETNUM char(17)
''

INVRETLNNUM int
0

ISLINEINTRA tinyint
0
IsLineIntr...(more) Join Now
ProjNum char(15)
''

CostCatID char(15)
''

TrackedDropShipped tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
OriginatingPrepaymentAmt numeric
0.00

ORDISTKN numeric
0.00
Orig Disco...(more) Join Now RM20102.ORDISTKN
ORTDISAM numeric
0.00

ORFRTAMT numeric
0.00
Originatin...(more) Join Now
ORMISCAMT numeric
0.00

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