Dynamics GP Table Reference - COMPANY..PAM50900 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 PAM tables PAM50900

You are currently viewing the COMPANY database.
Change

COMPANY..PAM50900 Table Definition

(COMPANY..)

Field Definitions:

What is the 'source' column?

Column Name	Data Type Default Value
AWARDID	char ''

Award_Description	char ''

Annual_Leave_CB	tinyint 0

Sick_Leave_CB	tinyint 0

Rounding_Applies_CB	tinyint 0

SHRM	smallint 0

SHRP	smallint 0

OHRM	smallint 0

OHRP	smallint 0

Weekly_Basis_Days	smallint 0

Weekly_Normal_End_Time	datetime '1/1/1900'

Weekly_Normal_Start_Time	datetime '1/1/1900'

Weekly_Daily_Min	numeric 0.00

Weekly_Overtime_First	numeric 0.00

WOFirst_Rate	numeric 0.00

Weekly_Overtime_Hours	numeric 0.00

WO_Next_Rate	numeric 0.00

Daily_Overtime_Above	numeric 0.00

DO_First_Rate	numeric 0.00

Daily_Overtime_Hours	numeric 0.00

DO_Next_Rate	numeric 0.00

DO_Outside_Rate	numeric 0.00

Saturday_End_Time	datetime '1/1/1900'

Saturday_Start_Time	datetime '1/1/1900'

Saturday_Daily_Min	numeric 0.00

Saturday_Normal_Rate	numeric 0.00

Saturday_Outside_Rate	numeric 0.00

Saturday_Overtime_Hours1	numeric 0.00

Saturday_Overtime_Hours2	numeric 0.00

Saturday_Overtime_Rate_1	numeric 0.00

Saturday_Overtime_Rate_2	numeric 0.00

Sunday_End_Time	datetime '1/1/1900'

Sunday_Start_Time	datetime '1/1/1900'

Sunday_Daily_Min	numeric 0.00

Sunday_Normal_Rate	numeric 0.00

Sunday_Outside_Rate	numeric 0.00

Sunday_Overtime_Hours_1	numeric 0.00

Sunday_Overtime_Hours_2	numeric 0.00

Sunday_Overtime_Rate_1	numeric 0.00

Sunday_Overtime_Rate_2	numeric 0.00

Holiday_Normal_Rate	numeric 0.00

Holidays_Daily_Min	numeric 0.00

Holidays_End_Time	datetime '1/1/1900'

Holidays_OT_Hours_1	numeric 0.00

Holidays_OT_Hours_2	numeric 0.00

Holidays_OTRate_1	numeric 0.00

Holidays_OT_Rate_2	numeric 0.00

Holidays_Outside_Rate	numeric 0.00

Holidays_Start_Time	datetime '1/1/1900'

Afternoon_Start_Time	datetime '1/1/1900'

Afternoon_End_Time	datetime '1/1/1900'

Afternoon_multiple	numeric 0.00

Night_Start_Time	datetime '1/1/1900'

Night_End_Time	datetime '1/1/1900'

Night_multiple	numeric 0.00

Morning_Start_Time	datetime '1/1/1900'

Morning_End_Time	datetime '1/1/1900'

Morning_multiple	numeric 0.00

Productivity_allowance	numeric 0.00

Dirt_Allowance	numeric 0.00

Heat_Allowance	numeric 0.00

Meal_Time	datetime '1/1/1900'

Meal_Amount_1	numeric 0.00

Meal_Amount_2	numeric 0.00

Meal_Hours_1	numeric 0.00

Meal_Hours_2	numeric 0.00

Meal_time_allowance	numeric 0.00

WD_OTD_OPC	char ''

WD_OTD_PC1	char ''

WD_OTD_PC2	char ''

WD_OTW_PC1	char ''

WD_OTW_PC2	char ''

SAA_PC	char ''

SAN_PC	char ''

SAT_N_PC	char ''

SAT_OTD_OPC	char ''

SAT_OTD_PC1	char ''

SAT_OTD_PC2	char ''

SAM_PC	char ''

SUN_N_PC	char ''

SUN_OTD_OPC	char ''

SUN_OTD_PC1	char ''

SUN_OTD_PC2	char ''

PH_N_PC	char ''

PH_OTD_OPC	char ''

PH_OTD_PC1	char ''

PH_OTD_PC2	char ''

MA_PC1	char ''

MA_PC2	char ''

MA_PCS	char ''

PA_PC	char ''

DA_PC	char ''

HA_PC	char ''

SatSun_Applies	tinyint 0

Public_Hols_Apply	tinyint 0

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..PAM50900 Table Definition

Field Definitions: