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