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 TypeLength
1RVLUEID SearchRevaluation IDSTR15_Revaluation_IDString15
2RVLSRIES SearchRevaluation SeriesDDLInteger0
3RVLUOPTN SearchRevaluation Posting OptionGBInteger0
4GAINLOSS SearchGain or Loss TypeGBInteger0
5TRXDATE SearchTRX DateDT_DateDate6
6REVSETRX SearchReverse TRXCB_Reverse_TRXBoolean0
7RVRSNGDT SearchReversing DateDT_DateDate6
8RVLUYROP SearchRevaluation Year OptionDDL_Revaluation_Year_OptionInteger0
9YEAR1 SearchYearYearInteger4
10RVLUPDOP SearchRevaluation Period OptionDDL_Revaluation_Period_OptionInteger0
11PERIODID SearchPeriod IDINT3Integer3
12RVLURTOP SearchRevaluation Rate OptionDDL_Revaluation_Rate_OptionInteger0
13SORTBY SearchSort ByDDL_Sort_ByInteger0
14INCLDPAR SearchInclude at Par TransactionsCB_Include_At_Par_TRXBoolean0
15Include_Invoice SearchInclude InvoiceCBBoolean0
16Include_Debit_Memo SearchInclude Debit MemoCB_IncludeDebitMemoBoolean0
17Include_Finance_Charge SearchInclude Finance ChargeCB_IncludeFinanceChargeBoolean0
18Include_ServiceRepair SearchInclude Service-RepairCB_IncludeServiceRepairBoolean0
19Include_Credit_Memo SearchInclude Credit MemoCB_IncludeCreditMemoBoolean0
20Include_Return SearchInclude ReturnCB_IncludeReturnBoolean0
21Include_Cash_Receipt SearchInclude Cash ReceiptCB_IncludeCashReceiptBoolean0
22Include_Misc_Charge SearchInclude Misc ChargeCB_IncludeMiscChargeBoolean0
23Include_Payment SearchInclude PaymentCB_IncludePaymentBoolean0
24STTACNUM SearchStart Account NumberAccount_NumberComposite 80
25STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
26STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
27STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
28STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
29STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
30STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
31STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
32STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
33STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
34STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
35EACCNBR SearchEnd Account NumberAccount_NumberComposite 80
36EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
37EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
38EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
39EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
40EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
41EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
42EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
43EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
44EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
45EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
46STTCLSID SearchStart Class IDSTR15_LBAUString15
47ENDCLSID SearchEnd Class IDSTR15_LBAUString15
48STTUDEF1 SearchStart User Defined 1STR20String20
49ENUSRDF1 SearchEnd User Defined 1STR20String20
50StartCustOrVendID SearchStart Customer or Vendor IDSTR15String15
51EndCustOrVendID SearchEnd Customer or Vendor IDSTR15String15
52CUTOFDAT SearchCutoff DateDTDate8
53MCRVALHDRMSGS SearchMC Revaluation HDR MessagesML_MC_Reval_HDR_MsgsLong Integer0
54Limit_Document_Gains SearchLimit Document GainsLimit Document GainsBoolean0
55DEX_ROW_ID Searchintint10

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 *