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

COMPANY..POP10600 Table Definition

(COMPANY..Purchasing Shipment Invoice Apply)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
POPIVCNO char(17)
''
POP Invoic...(more) Join Now
IVCLINNO int
0
Invoice Li...(more) Join Now
POPRCTNM char(17)
''
POP Receip...(more) Join Now
RCPTLNNM int
0
Receipt Li...(more) Join Now
LCLINENUMBER int
0
LC Line Nu...(more) Join Now
Status smallint
0
Status Ind...(more) Join Now
QTYINVCD numeric(19,5)
0.00
QTY Invoic...(more) Join Now
QTYINVRESERVE numeric(19,5)
0.00
QTY Invoic...(more) Join Now
ORUNTCST numeric(19,5)
0.00
Originatin...(more) Join Now
RCPTCOST numeric(19,5)
0.00
Receipt Co...(more) Join Now
ORCPTCOST numeric(19,5)
0.00
Originatin...(more) Join Now
ACPURTOT numeric(19,5)
0.00
Accrued Pu...(more) Join Now
UPPVTOTL numeric(19,5)
0.00
Unrealized...(more) Join Now
PURPVIDX int
0
Purchase P...(more) Join Now
PCHRPTCT numeric(19,5)
0.00
Purchase R...(more) Join Now
SPRCPTCT numeric(19,5)
0.00
Split Rece...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
RATECALC smallint
0
Rate Calc ...(more) Join Now
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now
Revalue_Inventory tinyint
0
Revalue In...(more) Join Now
PPVTotal numeric(19,5)
0.00
Purchase P...(more) Join Now
INVINDX int
0
Inventory ...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
BCKTXAMT numeric
0.00
Backout Ta...(more) Join Now
OBTAXAMT numeric
0.00
Originatin...(more) Join Now
PRCNTOFTTL numeric
0.00
Percent of...(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