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 POP10100
You are currently viewing the COMPANY database.
Change

COMPANY..POP10100 Table Definition

(COMPANY..Purchase Order Work)
The POP_PO table contains the identifying document information for non-historical purchase orders.
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PONUMBER char(17)
''
PO Number ...(more) Join Now
POSTATUS smallint
0
PO Status ...(more) Join Now
STATGRP smallint
0
Status Gro...(more) Join Now
POTYPE smallint
0
PO Type T...(more) Join Now
USER2ENT char(15)
''
User To En...(more) Join Now
CONFIRM1 char(21)
''
Confirm Wi...(more) Join Now
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
LSTEDTDT datetime
'1/1/1900'
Last Edit ...(more) Join Now
LSTPRTDT datetime
'1/1/1900'
Last Print...(more) Join Now
PRMDATE datetime
'1/1/1900'
Promised D...(more) Join Now
PRMSHPDTE datetime
'1/1/1900'
Promised S...(more) Join Now
REQDATE datetime
'1/1/1900'
Required D...(more) Join Now
REQTNDT datetime
'1/1/1900'
Requisitio...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now
REMSUBTO numeric(19,5)
0.00
Remaining ...(more) Join Now
SUBTOTAL numeric(19,5)
0.00
Subtotal T...(more) Join Now
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
MSCCHAMT numeric(19,5)
0.00
Misc Charg...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
VENDNAME char(65)
''
Vendor Nam...(more) Join Now
MINORDER numeric(19,5)
0.00
Minimum Or...(more) Join Now
VADCDPAD char(15)
''
Vendor Add...(more) Join Now
CMPANYID smallint
0
Company ID...(more) Join Now
join ... more text available
PRBTADCD char(15)
''
Primary Bi...(more) Join Now
join ... more text available
PRSTADCD char(15)
''
Primary Sh...(more) Join Now
join ... more text available
CMPNYNAM char(65)
''
Company Na...(more) Join Now
CONTACT char(61)
''
Customer C...(more) Join Now
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
PYMTRMID char(21)
''
Payment Te...(more) Join Now
SY033... more text available
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now
DSCPCTAM smallint
0
Discount P...(more) Join Now
DISAMTAV numeric(19,5)
0.00
Discount A...(more) Join Now
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date T...(more) Join Now
TRDPCTPR numeric(23,0)
0.00
Trade Disc...(more) Join Now
CUSTNMBR char(15)
''
Customer N...(more) Join Now
join ... more text available
TIMESPRT smallint
0
Times Prin...(more) Join Now
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
PONOTIDS_1 numeric(19,5)
0.00
PO Note ID...(more) Join Now
PONOTIDS_2 numeric(19,5)
0.00
see the de...(more) Join Now
PONOTIDS_3 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_4 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_5 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_6 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_7 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_8 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_9 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_10 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_11 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_12 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_13 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_14 numeric(19,5)
0.00
span style...(more) Join Now
PONOTIDS_15 numeric(19,5)
0.00
span style...(more) Join Now
COMMNTID char(15)
''
span style...(more) Join Now
join ... more text available
CANCSUB numeric(19,5)
0.00
Canceled S...(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
RATETPID char(15)
''
Rate Type ...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
TIME1 datetime
'1/1/1900'
Time: The...(more) Join Now
RATECALC smallint
0
Rate Calc ...(more) Join Now
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now
MCTRXSTT smallint
0
MC Transac...(more) Join Now
OREMSUBT numeric(19,5)
0.00
Originatin...(more) Join Now
ORSUBTOT numeric(19,5)
0.00
Originatin...(more) Join Now
Originating_Canceled_Sub numeric(19,5)
0.00
Originatin...(more) Join Now
ORTDISAM numeric(19,5)
0.00
Originatin...(more) Join Now
ORFRTAMT numeric(19,5)
0.00
Originatin...(more) Join Now
OMISCAMT numeric(19,5)
0.00
Originatin...(more) Join Now
ORTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now
ORDDLRAT numeric(19,5)
0.00
Orig Disco...(more) Join Now
ODISAMTAV numeric(19,5)
0.00
Originatin...(more) Join Now
BUYERID char(15)
''
Buyer ID ...(more) Join Now
ONORDAMT numeric(19,5)
0.00
On Order A...(more) Join Now
ORORDAMT numeric(19,5)
0.00
Originatin...(more) Join Now
HOLD tinyint
0
Hold Desig...(more) Join Now
ONHOLDDATE datetime
'1/1/1900'
On Hold Da...(more) Join Now
ONHOLDBY char(15)
''
On Hold By...(more) Join Now
HOLDREMOVEDATE datetime
'1/1/1900'
Hold Remov...(more) Join Now
HOLDREMOVEBY char(15)
''
Hold Remov...(more) Join Now
ALLOWSOCMTS tinyint
0
Allow SO C...(more) Join Now
DISGRPER smallint
0
Discount G...(more) Join Now
DUEGRPER smallint
0
Due Date G...(more) Join Now
Revision_Number smallint
0
Revision N...(more) Join Now
Change_Order_Flag smallint
0
Change Ord...(more) Join Now
PO_Field_Changes binary(4)
0
PO Field C...(more) Join Now
PO_Status_Orig smallint
0
PO Status ...(more) Join Now
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
TXSCHSRC smallint
0
Tax Schedu...(more) Join Now
TXENGCLD tinyint
0
Tax Engine...(more) Join Now
BSIVCTTL tinyint
0
Based On I...(more) Join Now
Purchase_Freight_Taxable smallint
0
Purchase F...(more) Join Now
Purchase_Misc_Taxable smallint
0
Purchase M...(more) Join Now
FRTSCHID char(15)
''
Freight Sc...(more) Join Now
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now
ORFRTTAX numeric(19,5)
0.00
Originatin...(more) Join Now
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now
ORMSCTAX 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
BackoutFreightTaxAmt numeric(19,5)
0.00
Backout Fr...(more) Join Now
OrigBackoutFreightTaxAmt numeric(19,5)
0.00
Originatin...(more) Join Now
BackoutMiscTaxAmt numeric(19,5)
0.00
Backout Mi...(more) Join Now
OrigBackoutMiscTaxAmt numeric(19,5)
0.00
Originatin...(more) Join Now
Flags smallint
0
Flags:...(more) Join Now
BackoutTradeDiscTax numeric(19,5)
0.00
Backout Tr...(more) Join Now
OrigBackoutTradeDiscTax numeric(19,5)
0.00
Originatin...(more) Join Now
POPCONTNUM char(21)
''
POP Contra...(more) Join Now
CONTENDDTE datetime
'1/1/1900'
Contract E...(more) Join Now
CNTRLBLKTBY smallint
0
Control Bl...(more) Join Now
PURCHCMPNYNAM char(65)
''
Purchase C...(more) Join Now
PURCHCONTACT char(61)
''
Purchase C...(more) Join Now
PURCHADDRESS1 char(61)
''
Purchase A...(more) Join Now
PURCHADDRESS2 char(61)
''
Purchase A...(more) Join Now
PURCHADDRESS3 char(61)
''
Purchase A...(more) Join Now
PURCHCITY char(35)
''
Purchase C...(more) Join Now
PURCHSTATE char(29)
''
Purchase S...(more) Join Now
PURCHZIPCODE char(11)
''
Purchase Z...(more) Join Now
PURCHCCode char(7)
''
Purchase C...(more) Join Now
PURCHCOUNTRY char(61)
''
Purchase C...(more) Join Now
PURCHPHONE1 char(21)
''
Purchase P...(more) Join Now
PURCHPHONE2 char(21)
''
Purchase P...(more) Join Now
PURCHPHONE3 char(21)
''
Purchase P...(more) Join Now
PURCHFAX char(21)
''
Purchase F...(more) Join Now
BLNKTLINEEXTQTYSUM numeric(19,5)
0.00
Total Blan...(more) Join Now
CBVAT tinyint
0
Cash Based...(more) Join Now
Workflow_Approval_Status smallint
0
Workflow A...(more) Join Now
Workflow_Priority smallint
0
Workflow P...(more) Join Now
Workflow_Status smallint
0
Workflow S...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
 Time Stamp...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
Print_Phone_NumberGB smallint
0
Print_Phon...(more) Join Now
PrepaymentAmount numeric
0.00
Prepayment...(more) Join Now
OriginatingPrepaymentAmt numeric
0.00
Originatin...(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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3