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

COMPANY..POP40100 Table Definition

(COMPANY..Purchasing Setup Table)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
INDEX1 smallint
0
Index Key ...(more) Join Now
PO_Code char(3)
''
PO Code Pr...(more) Join Now
PONUMBER char(17)
''
PO Number ...(more) Join Now
POFORMAT smallint
0
PO Format ...(more) Join Now
POPRCTNM char(17)
''
POP Receip...(more) Join Now
Receipt_Code char(3)
''
Receipt Co...(more) Join Now
DECPLQTY smallint
0
 Decimal Pl...(more) Join Now
DECPLCUR smallint
0
 Number of ...(more) Join Now
POHIST tinyint
0
PO Maintai...(more) Join Now
RCPTHIST tinyint
0
Receipt Ma...(more) Join Now
DISTHIST tinyint
0
Distributi...(more) Join Now
DSPLYITM smallint
0
Display It...(more) Join Now
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
Number_Of_Lines smallint
0
Number of ...(more) Join Now
POPALWOP_1 tinyint
0
POP Allow ...(more) Join Now
POPALWOP_2 tinyint
0
POP Allow ...(more) Join Now
POPALWOP_3 tinyint
0
POP Allow ...(more) Join Now
POPALWOP_4 tinyint
0
POP Allow ...(more) Join Now
POPPSWRD_1 char(11)
''
POP Option...(more) Join Now
POPALWOP_5 tinyint
0

POPPSWRD_2 char(11)
''
POP Option...(more) Join Now
POPPSWRD_3 char(11)
''
POP Option...(more) Join Now
POPPSWRD_4 char(11)
''
POP Option...(more) Join Now
DEFAULTSITEMETHOD smallint
0
Default Si...(more) Join Now
ALLOWHOLDEDIT tinyint
0
Allow Hold...(more) Join Now
POPPSWRD_5 char
''

AUTOHOLD tinyint
0
Auto Assig...(more) Join Now
SearchPOQtysFromSO tinyint
0
SearchPOQt...(more) Join Now
TransferLineComments tinyint
0
Transfer L...(more) Join Now
Purchase_Non_IV_Taxable smallint
0
Purchase N...(more) Join Now
Purchase_Freight_Taxable smallint
0
Purchase F...(more) Join Now
Purchase_Misc_Taxable smallint
0
Purchase M...(more) Join Now
NONIVSCH char(15)
''
Non IV Ite...(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
USEADVTX smallint
0
Use Advanc...(more) Join Now
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
User_Defined_Prompt01 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt02 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt03 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt04 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt05 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt06 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt07 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt08 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt09 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt10 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt11 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt12 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt13 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt14 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt15 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt16 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt17 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt18 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt19 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt20 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt21 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt22 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt23 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt24 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt25 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt26 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt27 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt28 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt29 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt30 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt31 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt32 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt33 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt34 char(31)
''
User Defin...(more) Join Now
User_Defined_Prompt35 char(31)
''
User Defin...(more) Join Now
FreightTaxSchedNoteIdx numeric(19,5)
0.00
Freight Ta...(more) Join Now
MiscTaxSchedNoteIdx numeric(19,5)
0.00
Misc Tax S...(more) Join Now
NonIVTaxSchedNoteIdx numeric(19,5)
0.00
Non IV Tax...(more) Join Now
SingleTaxSchedNoteIdx numeric(19,5)
0.00
Single Tax...(more) Join Now
ReplenishmentLevel smallint
0
Replenishm...(more) Join Now
POPOrderMethod smallint
0
POP Order ...(more) Join Now
MasterLocationCode char(11)
''
Master Loc...(more) Join Now
POPVendorSelection smallint
0
POP Vendor...(more) Join Now
POPPricingSelection smallint
0
POP Pricin...(more) Join Now
IncludeAllocations tinyint
0
Include Al...(more) Join Now
IncludeBackorders tinyint
0
Include Ba...(more) Join Now
IncludeRequisitions tinyint
0
Include Re...(more) Join Now
RETORIGTAX tinyint
0
Return Ori...(more) Join Now
ONEPOPERADDR tinyint
0
Create One...(more) Join Now
CALCRELDT tinyint
0
Calc Relea...(more) Join Now
Default_Document_Date smallint
0
Default Do...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
UseQtyOverageTolerance tinyint
0

UseQtyShortageTolerance tinyint
0

QtyOverTolerancePercent int
0

QtyShortTolerancePercent int
0

AllowPOPrepayments tinyint
0

CreateManualPrepayment tinyint
0

PrepaymentPassword char
''

PrepaymentAccountIndex int
0

RequisitionCode char
''

POPRequisitionNumber char
''

RequisitionMaintainHist tinyint
0

RequisitionDefDocDate smallint
0

RequisitionDefSiteMethod smallint
0

RequisitionVendorSelect smallint
0

RequisitionCostSelection smallint
0

ReqCreateOnePOPerAddress tinyint
0

ReqTransferLineComments tinyint
0

SearchPOQtysFromRequisit tinyint
0

Req_Hdr_UD_Prompt1 char
''

Req_Hdr_UD_Prompt2 char
''

Req_Line_UD_Prompt1 char
''

Req_Line_UD_Prompt2 char
''

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