PA Project Fee Schedule Master File (PA05200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA05200

Display Name: PA Project Fee Schedule Master File
Physical Name: PA05200
Technical Name: PA_Project_Fee_Schedule_MSTR

Group Display Name: PA Budgeting Cards
Group Technical Name: PA Budgeting Cards

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PAPROJNUMBER	PA Project Number	STR15_LBAU	String	15
2	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	10
3	PAFeeID	PA Fee ID	STR15_LBAU	String	15
4	PADT	PA Date	PA_Date	Date	8
5	PAFeeAmount	PA Fee Amount	DLR17_RBSO_STR$	Currency	17
6	PAAmount_Billed	PA Amount Billed	DLR17_RBS0_STR$	Currency	17
7	PACHGORDNO	PA Change Order Number	STR17_LBAU	String	17
8	PA_MC_Fee_Amount	PA MC Fee Amount	PA_DLR17_RBS0_UTR$	Currency	17
9	PA_MC_Amount_Billed	PA MC Amount Billed	PA_DLR17_RBS0_UTR$	Currency	17
10	DEX_ROW_ID		int	int	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.