Dynamics GP Table Reference - COMPANY..GenSales fields

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

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Module List > Module TM tables GenSales

You are currently viewing the COMPANY database.
Change

COMPANY..GenSales Table Definition

(COMPANY..)

Field Definitions:

What is the 'source' column?

Column Name	Data Type Default Value		Source
ITMGEDSC	char ''

ITMSHNAM	char ''

ITMCLSCD	char ''	Item Class...(more) Join Now	IV00101.ITMCLSCD

LY_ShippedJan	numeric 0.00

LY_ShippedFeb	numeric 0.00

LY_ShippedMar	numeric 0.00

LY_ShippedApr	numeric 0.00

LY_ShippedMay	numeric 0.00

LY_ShippedJun	numeric 0.00

LY_ShippedJul	numeric 0.00

LY_ShippedAug	numeric 0.00

LY_ShippedSep	numeric 0.00

LY_ShippedOct	numeric 0.00

LY_ShippedNov	numeric 0.00

LY_ShippedDec	numeric 0.00

CY_ShippedJan	numeric 0.00

CY_ShippedFeb	numeric 0.00

CY_ShippedMar	numeric 0.00

CY_ShippedApr	numeric 0.00

CY_ShippedMay	numeric 0.00

CY_ShippedJun	numeric 0.00

CY_ShippedJul	numeric 0.00

CY_ShippedAug	numeric 0.00

CY_ShippedSep	numeric 0.00

CY_ShippedOct	numeric 0.00

CY_ShippedNov	numeric 0.00

CY_ShippedDec	numeric 0.00

AA_CY_OpenJan	numeric 0.00

AA_CY_OpenFeb	numeric 0.00

AA_CY_OpenMar	numeric 0.00

AA_CY_OpenApr	numeric 0.00

AA_CY_OpenMay	numeric 0.00

AA_CY_OpenJun	numeric 0.00

AA_CY_OpenJul	numeric 0.00

AA_CY_OpenAug	numeric 0.00

AA_CY_OpenSep	numeric 0.00

AA_CY_OpenOct	numeric 0.00

AA_CY_OpenNov	numeric 0.00

AA_CY_OpenDec	numeric 0.00

AA_LY_Qty_ShippedJan	numeric 0.00

AA_LY_Qty_ShippedFeb	numeric 0.00

AA_LY_Qty_ShippedMar	numeric 0.00

AA_LY_Qty_ShippedApr	numeric 0.00

AA_LY_Qty_ShippedMay	numeric 0.00

AA_LY_Qty_ShippedJun	numeric 0.00

AA_LY_Qty_ShippedJul	numeric 0.00

AA_LY_Qty_ShippedAug	numeric 0.00

AA_LY_Qty_ShippedSep	numeric 0.00

AA_LY_Qty_ShippedOct	numeric 0.00

AA_LY_Qty_ShippedNov	numeric 0.00

AA_LY_Qty_ShippedDec	numeric 0.00

AA_CY_Qty_ShippedJan	numeric 0.00

AA_CY_Qty_ShippedFeb	numeric 0.00

AA_CY_Qty_ShippedMar	numeric 0.00

AA_CY_Qty_ShippedApr	numeric 0.00

AA_CY_Qty_ShippedMay	numeric 0.00

AA_CY_Qty_ShippedJun	numeric 0.00

AA_CY_Qty_ShippedJul	numeric 0.00

AA_CY_Qty_ShippedAug	numeric 0.00

AA_CY_Qty_ShippedSep	numeric 0.00

AA_CY_Qty_ShippedOct	numeric 0.00

AA_CY_Qty_ShippedNov	numeric 0.00

AA_CY_Qty_ShippedDec	numeric 0.00

AA_CY_Qty_OpenJan	numeric 0.00

AA_CY_Qty_OpenFeb	numeric 0.00

AA_CY_Qty_OpenMar	numeric 0.00

AA_CY_Qty_OpenApr	numeric 0.00

AA_CY_Qty_OpenMay	numeric 0.00

AA_CY_Qty_OpenJun	numeric 0.00

AA_CY_Qty_OpenJul	numeric 0.00

AA_CY_Qty_OpenAug	numeric 0.00

AA_CY_Qty_OpenSep	numeric 0.00

AA_CY_Qty_OpenOct	numeric 0.00

AA_CY_Qty_OpenNov	numeric 0.00

AA_CY_Qty_OpenDec	numeric 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

DynDeveloper.com

COMPANY..GenSales Table Definition

Field Definitions: