DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module POP tables POP10110
You are currently viewing the COMPANY database.
Change

COMPANY..POP10110 Table Definition

(COMPANY..Purchase Order Line)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PONUMBER char(17)
''
PO Number ...(more) Join Now
ORD int
0
Sequence n...(more) Join Now
POLNESTA smallint
0
PO Line St...(more) Join Now
POTYPE smallint
0
PO Type T...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
VNDITNUM char(31)
''
Vendor Ite...(more) Join Now
VNDITDSC char(101)
''
Vendor Ite...(more) Join Now
NONINVEN smallint
0
p class="T...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
UOFM char(9)
''
U Of M The...(more) Join Now
See I... more text available
UMQTYINB numeric(19,5)
0.00
U Of M QTY...(more) Join Now ENC10111.UMQTYINB
QTYORDER numeric(19,5)
0.00
p class="T...(more) Join Now
QTYCANCE numeric(19,5)
0.00
QTY Cancel...(more) Join Now
QTYCMTBASE numeric(19,5)
0.00

QTYUNCMTBASE numeric(19,5)
0.00

UNITCOST numeric(19,5)
0.00
Unit Cost ...(more) Join Now
EXTDCOST numeric(19,5)
0.00
Extended C...(more) Join Now
INVINDX int
0
Inventory ...(more) Join Now
REQDATE datetime
'1/1/1900'
Required D...(more) Join Now OSRC1100.REQDATE
PRMDATE datetime
'1/1/1900'
Promised D...(more) Join Now
PRMSHPDTE datetime
'1/1/1900'
Promised S...(more) Join Now
REQSTDBY char(21)
''

COMMNTID char(15)
''

join ... more text available
DOCTYPE smallint
0
Document T...(more) Join Now
POLNEARY_1 numeric(19,5)
0.00
PO Line No...(more) Join Now
POLNEARY_2 numeric(19,5)
0.00
PO Line No...(more) Join Now
POLNEARY_3 numeric(19,5)
0.00
PO Line No...(more) Join Now
POLNEARY_4 numeric(19,5)
0.00
PO Line No...(more) Join Now
POLNEARY_5 numeric(19,5)
0.00
PO Line No...(more) Join Now
POLNEARY_6 numeric(19,5)
0.00
PO Line No...(more) Join Now
POLNEARY_7 numeric(19,5)
0.00
PO Line No...(more) Join Now
POLNEARY_8 numeric(19,5)
0.00
PO Line No...(more) Join Now
POLNEARY_9 numeric(19,5)
0.00
PO Line No...(more) Join Now
DECPLCUR smallint
0
 Number of ...(more) Join Now
DECPLQTY smallint
0
 Decimal Pl...(more) Join Now
ITMTRKOP smallint
0
Item Track...(more) Join Now
VCTNMTHD smallint
0
Valuation ...(more) Join Now
POP10... more text available
BRKFLD1 smallint
0
Break Fiel...(more) Join Now
PO_Line_Status_Orig smallint
0
PO Line St...(more) Join Now
QTY_Canceled_Orig numeric(19,5)
0.00
QTY Cancel...(more) Join Now
OPOSTSUB numeric(19,5)
0.00
Originatin...(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
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
ORUNTCST numeric(19,5)
0.00
Originatin...(more) Join Now
OREXTCST numeric(19,5)
0.00
Originatin...(more) Join Now
LINEORIGIN smallint
0
Line Origi...(more) Join Now
FREEONBOARD smallint
0
1 = Nonebr...(more) Join Now
ODECPLCU smallint
0

Capital_Item tinyint
0
Capital It...(more) Join Now
Product_Indicator smallint
0
Product In...(more) Join Now
Source_Document_Number char(11)
''
Source Doc...(more) Join Now
Source_Document_Line_Num smallint
0
Source Doc...(more) Join Now
RELEASEBYDATE datetime
'1/1/1900'
Release By...(more) Join Now
Released_Date datetime
'1/1/1900'
Released D...(more) Join Now
Change_Order_Flag smallint
0
Change Ord...(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
PURCHSITETXSCHSRC smallint
0
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
Landed_Cost_Group_ID char(15)
''
Landed Cos...(more) Join Now
PLNNDSPPLID smallint
0
Planned Su...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
BackoutTradeDiscTax numeric(19,5)
0.00
Backout Tr...(more) Join Now
OrigBackoutTradeDiscTax numeric(19,5)
0.00
Originatin...(more) Join Now
LineNumber smallint
0
LineNumber...(more) Join Now
ORIGPRMDATE datetime
'1/1/1900'
Original P...(more) Join Now
FSTRCPTDT datetime
'1/1/1900'
First Rece...(more) Join Now
LSTRCPTDT datetime
'1/1/1900'
Last Recei...(more) Join Now
RELEASE smallint
0
Release: ...(more) Join Now
ADRSCODE char(15)
''
Address Co...(more) Join Now
CMPNYNAM char(65)
''
Company Na...(more) Join Now
CONTACT char(61)
''

ADDRESS1 char(61)
''
Address 1:...(more) Join Now
ADDRESS2 char(61)
''
Address 2:...(more) Join Now
ADDRESS3 char(61)
''
Address 3:...(more) Join Now
CITY char(35)
''
City: Shi...(more) Join Now
STATE char(29)
''
State: Sh...(more) Join Now
ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
CCode char(7)
''
Country Co...(more) Join Now
COUNTRY char(61)
''
Country: ...(more) Join Now
PHONE1 char(21)
''
Phone 1: ...(more) Join Now
PHONE2 char(21)
''
Phone 2: ...(more) Join Now
PHONE3 char(21)
''
Phone 3: ...(more) Join Now
FAX char(21)
''
Fax: Ship...(more) Join Now
ADDRSOURCE smallint
0

Flags smallint
0
Flags:...(more) Join Now
ProjNum char(15)
''

CostCatID char(15)
''

DEX_ROW_TS datetime
(getutcdate())
 Time Stamp...(more) Join Now
Print_Phone_NumberGB smallint
0
Print_Phon...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
QTYCommittedInBaseOrig 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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3