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 Group Display Name: Multicurrency Revaluation
Physical Name: MC10000
Technical Name: MC_Revaluation_HDR_WORK
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. |