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

COMPANY..IV41100 Table Definition

(COMPANY..Inventory Landed Cost)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
Landed_Cost_ID char(15)
''

Long_Description char(51)
''

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
VENDORID char(15)
''
Vendor ID:...(more) Join Now PM10000.VENDORID
join ... more text available
CURNCYID char(15)
''
Currency I...(more) Join Now CM20000
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
RATETPID char(15)
''
A valid Ra...(more) Join Now
DECPLCUR smallint
0
 Number of ...(more) Join Now
ODECPLCU smallint
0
Originatin...(more) Join Now SOP10200.ODECPLCU
ACPURIDX int
0
Accrued Pu...(more) Join Now PM00200.ACPURIDX
PURPVIDX int
0
Purchase P...(more) Join Now IV00101.PURPVIDX
Invoice_Match tinyint
0

CALCMTHD smallint
0
1 = P...(more) Join Now
Orig_Landed_Cost_Amount numeric(19,5)
0.00

Calculation_Percentage int
0

Revalue_Inventory tinyint
0
Revalue In...(more) Join Now IV00101.Revalue_Inventory
Tolerance_Percentage int
0
Tolerance ...(more) Join Now IV00101.Tolerance_Percentage
Vendor_Note_Index numeric(19,5)
0.00

Currency_Note_Index numeric(19,5)
0.00

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(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