Multicurrency Revaluaton Work (MC10000)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialMulticurrency 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RVLUEID SearchRevaluation IDSTR15_Revaluation_IDString1615
2RVLSRIES SearchRevaluation SeriesDDLInteger20
3RVLUOPTN SearchRevaluation Posting OptionGBInteger20
4GAINLOSS SearchGain or Loss TypeGBInteger20
5TRXDATE SearchTRX DateDT_DateDate46
6REVSETRX SearchReverse TRXCB_Reverse_TRXBoolean20
7RVRSNGDT SearchReversing DateDT_DateDate46
8RVLUYROP SearchRevaluation Year OptionDDL_Revaluation_Year_OptionInteger20
9YEAR1 SearchYearYearInteger24
10RVLUPDOP SearchRevaluation Period OptionDDL_Revaluation_Period_OptionInteger20
11PERIODID SearchPeriod IDINT3Integer23
12RVLURTOP SearchRevaluation Rate OptionDDL_Revaluation_Rate_OptionInteger20
13SORTBY SearchSort ByDDL_Sort_ByInteger20
14INCLDPAR SearchInclude at Par TransactionsCB_Include_At_Par_TRXBoolean20
15Include_Invoice SearchInclude InvoiceCBBoolean20
16Include_Debit_Memo SearchInclude Debit MemoCB_IncludeDebitMemoBoolean20
17Include_Finance_Charge SearchInclude Finance ChargeCB_IncludeFinanceChargeBoolean20
18Include_ServiceRepair SearchInclude Service-RepairCB_IncludeServiceRepairBoolean20
19Include_Credit_Memo SearchInclude Credit MemoCB_IncludeCreditMemoBoolean20
20Include_Return SearchInclude ReturnCB_IncludeReturnBoolean20
21Include_Cash_Receipt SearchInclude Cash ReceiptCB_IncludeCashReceiptBoolean20
22Include_Misc_Charge SearchInclude Misc ChargeCB_IncludeMiscChargeBoolean20
23Include_Payment SearchInclude PaymentCB_IncludePaymentBoolean20
24STTACNUM SearchStart Account NumberAccount_NumberComposite 8080
25STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
26STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
27STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
28STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
29STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
30STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
31STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
32STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
33STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
34STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
35EACCNBR SearchEnd Account NumberAccount_NumberComposite 8080
36EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
37EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
38EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
39EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
40EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
41EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
42EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
43EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
44EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
45EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
46STTCLSID SearchStart Class IDSTR15_LBAUString1615
47ENDCLSID SearchEnd Class IDSTR15_LBAUString1615
48STTUDEF1 SearchStart User Defined 1STR20String2220
49ENUSRDF1 SearchEnd User Defined 1STR20String2220
50StartCustOrVendID SearchStart Customer or Vendor IDSTR15String1615
51EndCustOrVendID SearchEnd Customer or Vendor IDSTR15String1615
52CUTOFDAT SearchCutoff DateDTDate48
53MCRVALHDRMSGS SearchMC Revaluation HDR MessagesML_MC_Reval_HDR_MsgsLong Integer40
54Limit_Document_Gains SearchLimit Document GainsLimit Document GainsBoolean20
55DEX_ROW_ID Searchintint1010

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.

azurecurveProductsMicrosoft Dynamics GP (0)FinancialMulticurrency Revaluaton Work (MC10000)

Leave a Reply

Your email address will not be published. Required fields are marked *