Deferral Header Work (PP000100)

azurecurve Products Revenue Expense Deferrals (1045)FinancialDeferral Header Work (PP000100)

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

Product: Revenue Expense Deferrals (1045)
Series:

Display Name: Deferral Header Work
Physical Name: PP000100
Technical Name: PP_PrePayment_HDR_WORK

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PP_Module	PP Module	Integer	INT3	3
2	PP_Record_Type	PP Record Type	Integer	INT3	3
3	PP_Document_Number	PP Document Number	String	STR20	20
4	PP_Sequencer	PP Sequencer	Long Integer	LI_14	14
5	PPOFFSEQ	PP Offset Sequence	Long Integer	LI_14	14
6	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
7	CNTRLTYP	Control Type	Integer	INT1	1
8	DSTSQNUM	Distribution Sequence Number	Long Integer	Long Int	8
9	STRTNGDT	Starting Date	Date	DT	8
10	ENDINGDT	Ending Date	Date	DT	8
11	OFFACCT	Offset Account	Long Integer	LI_14	14
12	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Deferral Header Work'].ACTINDX AS 'Deferral Header Work-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM PP000100 AS ['Deferral Header Work'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Deferral Header Work'].ACTINDX = ['Account Index Master'].ACTINDX
13	PP_Deferred_BC_Index	PP Deferred BC Index	Long Integer	LI_14	14
14	PP_Deferrals_Transfer_In	PP Deferrals Transfer Index	Long Integer	LI_14	14
15	PP_Recognition_Index	PP Recognition Index	Long Integer	LI_14	14
16	TRXAMNT	TRX Amount	Currency	DLR19_$S2	19
17	REFRENCE	Reference	String	STR30	30
18	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Deferral Header Work'].USERID AS 'Deferral Header Work-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PP000100 AS ['Deferral Header Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Deferral Header Work'].USERID = ['Users Master'].USERID
19	POSTING	Posting	Boolean	CB	0
20	IntegerValue	IntegerValue	Integer	INT	0
21	PP_Calculation_Method	PP Calculation Method	Integer	DDL_PP_Calculation_Method	0
22	PP_Miscellaneous_Periods	PP Miscellaneous Periods	Integer	INT5	4
23	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Deferral Header Work'].NOTEINDX AS 'Deferral Header Work-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PP000100 AS ['Deferral Header Work'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Deferral Header Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
24	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8

azurecurve Products Revenue Expense Deferrals (1045)FinancialDeferral Header Work (PP000100)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply