Multicurrency Revaluaton Work (MC10000)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Multicurrency Revaluaton Work
Physical Name: MC10000
Technical Name: MC_Revaluation_HDR_WORK

Group Display Name: Multicurrency Revaluation
Group Technical Name: Multicurrency Revaluation

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RVLUEID	Revaluation ID	STR15_Revaluation_ID	String	15
2	RVLSRIES	Revaluation Series	DDL	Integer	0
3	RVLUOPTN	Revaluation Posting Option	GB	Integer	0
4	GAINLOSS	Gain or Loss Type	GB	Integer	0
5	TRXDATE	TRX Date	DT_Date	Date	6
6	REVSETRX	Reverse TRX	CB_Reverse_TRX	Boolean	0
7	RVRSNGDT	Reversing Date	DT_Date	Date	6
8	RVLUYROP	Revaluation Year Option	DDL_Revaluation_Year_Option	Integer	0
9	YEAR1	Year	Year	Integer	4
10	RVLUPDOP	Revaluation Period Option	DDL_Revaluation_Period_Option	Integer	0
11	PERIODID	Period ID	INT3	Integer	3
12	RVLURTOP	Revaluation Rate Option	DDL_Revaluation_Rate_Option	Integer	0
13	SORTBY	Sort By	DDL_Sort_By	Integer	0
14	INCLDPAR	Include at Par Transactions	CB_Include_At_Par_TRX	Boolean	0
15	Include_Invoice	Include Invoice	CB	Boolean	0
16	Include_Debit_Memo	Include Debit Memo	CB_IncludeDebitMemo	Boolean	0
17	Include_Finance_Charge	Include Finance Charge	CB_IncludeFinanceCharge	Boolean	0
18	Include_ServiceRepair	Include Service-Repair	CB_IncludeServiceRepair	Boolean	0
19	Include_Credit_Memo	Include Credit Memo	CB_IncludeCreditMemo	Boolean	0
20	Include_Return	Include Return	CB_IncludeReturn	Boolean	0
21	Include_Cash_Receipt	Include Cash Receipt	CB_IncludeCashReceipt	Boolean	0
22	Include_Misc_Charge	Include Misc Charge	CB_IncludeMiscCharge	Boolean	0
23	Include_Payment	Include Payment	CB_IncludePayment	Boolean	0
24	STTACNUM	Start Account Number	Account_Number	Composite	80
25	STTACNUM_1	Start Account Number:Account_Segment_Pool1	Account_Segment_Pool1	String	6
26	STTACNUM_2	Start Account Number:Account_Segment_Pool2	Account_Segment_Pool2	String	6
27	STTACNUM_3	Start Account Number:Account_Segment_Pool3	Account_Segment_Pool3	String	6
28	STTACNUM_4	Start Account Number:Account_Segment_Pool4	Account_Segment_Pool4	String	6
29	STTACNUM_5	Start Account Number:Account_Segment_Pool5	Account_Segment_Pool5	String	6
30	STTACNUM_6	Start Account Number:Account_Segment_Pool6	Account_Segment_Pool6	String	6
31	STTACNUM_7	Start Account Number:Account_Segment_Pool7	Account_Segment_Pool7	String	6
32	STTACNUM_8	Start Account Number:Account_Segment_Pool8	Account_Segment_Pool8	String	6
33	STTACNUM_9	Start Account Number:Account_Segment_Pool9	Account_Segment_Pool9	String	6
34	STTACNUM_10	Start Account Number:Account_Segment_Pool10	Account_Segment_Pool10	String	6
35	EACCNBR	End Account Number	Account_Number	Composite	80
36	EACCNBR_1	End Account Number:Account_Segment_Pool1	Account_Segment_Pool1	String	6
37	EACCNBR_2	End Account Number:Account_Segment_Pool2	Account_Segment_Pool2	String	6
38	EACCNBR_3	End Account Number:Account_Segment_Pool3	Account_Segment_Pool3	String	6
39	EACCNBR_4	End Account Number:Account_Segment_Pool4	Account_Segment_Pool4	String	6
40	EACCNBR_5	End Account Number:Account_Segment_Pool5	Account_Segment_Pool5	String	6
41	EACCNBR_6	End Account Number:Account_Segment_Pool6	Account_Segment_Pool6	String	6
42	EACCNBR_7	End Account Number:Account_Segment_Pool7	Account_Segment_Pool7	String	6
43	EACCNBR_8	End Account Number:Account_Segment_Pool8	Account_Segment_Pool8	String	6
44	EACCNBR_9	End Account Number:Account_Segment_Pool9	Account_Segment_Pool9	String	6
45	EACCNBR_10	End Account Number:Account_Segment_Pool10	Account_Segment_Pool10	String	6
46	STTCLSID	Start Class ID	STR15_LBAU	String	15
47	ENDCLSID	End Class ID	STR15_LBAU	String	15
48	STTUDEF1	Start User Defined 1	STR20	String	20
49	ENUSRDF1	End User Defined 1	STR20	String	20
50	StartCustOrVendID	Start Customer or Vendor ID	STR15	String	15
51	EndCustOrVendID	End Customer or Vendor ID	STR15	String	15
52	CUTOFDAT	Cutoff Date	DT	Date	8
53	MCRVALHDRMSGS	MC Revaluation HDR Messages	ML_MC_Reval_HDR_Msgs	Long Integer	0
54	Limit_Document_Gains	Limit Document Gains	Limit Document Gains	Boolean	0
55	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.

azurecurve Products Microsoft Dynamics GP (0)FinancialMulticurrency Revaluaton Work (MC10000)

Leave a Reply Cancel reply