Deferral Line Work (PP000101)

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

Display Name: Deferral Line Work
Physical Name: PP000101
Technical Name: PP_PrePayment_LINE_WORK

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PP_Module	PP Module	INT3	Integer	3
2	PP_Record_Type	PP Record Type	INT3	Integer	3
3	PP_Document_Number	PP Document Number	STR20	String	20
4	PP_Sequencer	PP Sequencer	LI_14	Long Integer	14
5	PPOFFSEQ	PP Offset Sequence	LI_14	Long Integer	14
6	VCHRNMBR	Voucher Number	STR20_LBAU	String	20
7	CNTRLTYP	Control Type	INT1	Integer	1
8	DSTSQNUM	Distribution Sequence Number	Long Int	Long Integer	8
9	DSCRIPTN	Description	STR30	String	30
10	GLPOSTDT	GL Posting Date	DT	Date	8
11	TRXAMNT	TRX Amount	DLR19_$S2	Currency	19
12	JRNENTRY	Journal Entry	LI8_U0	Long Integer	8
13	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.