POP10700 - Purchasing Landed Cost | Prospr - Dynamics GP Table Reference

POP10700 - Purchasing Landed Cost

Query Builder

Select * from POP10700

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
POPRCTNM	POP Receipt Number	String	18	View
RCPTLNNM	Receipt Line Number	Long Integer	4	View
LCLINENUMBER	LC Line Number	Long Integer	4	View
LCHDRNUMBER	LC Header Number	Long Integer	4	View
Landed_Cost_ID	Landed Cost ID	String	16	View
NOTEINDX	Note Index	Currency	10	View
Long_Description	Long Description	String	52	View
Landed_Cost_Type	Landed Cost Type	Integer	2	View
VENDORID	Vendor ID	String	16	View
Vendor_Note_Index	Vendor Note Index	Currency	10	View
CURNCYID	Currency ID	String	16	View
Currency_Note_Index	Currency Note Index	Currency	10	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RATECALC	Rate Calc Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
ODECPLCU	Originating Decimal Places Currency	Integer	2	View
ACPURIDX	Accrued Purchases Index	Long Integer	4	View
DistRef	Distribution Reference	String	32	View
PURPVIDX	Purchase Price Variance Index	Long Integer	4	View
Invoice_Match	Invoice Match	Boolean	2	View
CALCMTHD	Calculation Method	Integer	2	View
Orig_Landed_Cost_Amount	Originating Landed Cost Amount	Currency	10	View
Calculation_Percentage	Calculation Percentage	Long Integer	4	View
Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	10	View
Orig_TotalLandedCostAmt	Originating Total Landed Cost Amount	Currency	10	View
Landed_Cost_Warnings	Landed Cost Warnings	Integer	2	View
Apportion_By	Apportion By	Integer	2	View
Orig_UnapportionedAmount	Originating Unapportioned Amount	Currency	10	View
INVINDX	Inventory Index	Long Integer	4	View
Applied	Applied	Integer	2	View

POP10700 - Purchasing Landed Cost

Query Builder

Customer Service

Information

My Account

Contact Us