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

COMPANY..POP30100 Table Definition

(COMPANY..Purchase Order History)

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 OSRC1100.REQDATE
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
TRDPCTPR numeric(23,0)
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)
''

join ... more text available
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
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
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
Comment ID...(more) Join Now
PONOTIDS_3 numeric(19,5)
0.00

PONOTIDS_4 numeric(19,5)
0.00

PONOTIDS_5 numeric(19,5)
0.00

PONOTIDS_6 numeric(19,5)
0.00

PONOTIDS_7 numeric(19,5)
0.00

PONOTIDS_8 numeric(19,5)
0.00

PONOTIDS_9 numeric(19,5)
0.00

PONOTIDS_10 numeric(19,5)
0.00

PONOTIDS_11 numeric(19,5)
0.00

PONOTIDS_12 numeric(19,5)
0.00

PONOTIDS_13 numeric(19,5)
0.00

PONOTIDS_14 numeric(19,5)
0.00

PONOTIDS_15 numeric(19,5)
0.00

TRXSORCE char(13)
''
Transactio...(more) Join Now
COMMNTID char(15)
''

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

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
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
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
TXSCHSRC smallint
0
Tax Schedu...(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
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
Workflow_Approval_Status smallint
0
Workflow A...(more) Join Now
Workflow_Priority smallint
0
Workflow P...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
 Time Stamp...(more) Join Now
Workflow_Status smallint
0

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

OriginatingPrepaymentAmt 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