Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC30601
Product: FieldService (949)
Series: Project
Display Name: SVC_Contract_Line_HIST Group Display Name: Service History Table Group
Physical Name: SVC30601
Technical Name: SVC_Contract_Line_HIST
Group Technical Name: Service History
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | CONSTS ![]() | Contract Record Type | DDL_Contract_Status | Integer | 0 | |
2 | CONTNBR ![]() | Contract Number | STR11 | String | 11 | |
3 | LNSEQNBR ![]() | Line SEQ Number | Sequence_Number | Currency | 19 | |
4 | Contract_Transfer_Status ![]() | Contract Transfer Status | DDL_Transfer_Status | Integer | 0 | |
5 | Contract_Transfer_Date ![]() | Contract Transfer Date | DATE_L | Date | 0 | |
6 | CNTPRCOVR ![]() | Contract Price Overridden | CB | Boolean | 0 | |
7 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].NOTEINDX AS 'SVC_Contract_Line_HIST-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SVC_Contract_Line_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
8 | ADRSCODE ![]() | Address Code | STR15_Address_Code | String | 15 | |
9 | QUANTITY ![]() | QTY | DLR17_QTY_RBS0_STR | Currency | 17 | |
10 | ITEMNMBR ![]() | Item Number | STR30_Item_Number | String | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].ITEMNMBR AS 'SVC_Contract_Line_HIST-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SVC_Contract_Line_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
11 | CONFGREF ![]() | Config Reference | STR20_LBAU | String | 20 | |
12 | EQUIPID ![]() | Equipment ID | Long Int | Long Integer | 8 | |
13 | SERLNMBR ![]() | Serial Number | STR20_LBAU | String | 20 | |
14 | FRZEND ![]() | Frozen End | DATE | Date | 6 | |
15 | FRXSTRT ![]() | Frozen Start | DATE | Date | 6 | |
16 | BLKTIM ![]() | Blocked Time | CURR_TIME | Currency | 10 | |
17 | VALTIM ![]() | Value of Time | CURR_TIME | Currency | 10 | |
18 | DSCPCTAM ![]() | Discount Percent Amount | INT5_%2 | Integer | 5 | |
19 | COMDLRAM ![]() | Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 17 | |
20 | COUNTRY ![]() | Country | STR60 | String | 60 | |
21 | PRCSTAT ![]() | Status of Price | STR1 | String | 1 | |
22 | PORDNMBR ![]() | Purchase Order Number | Purchase Order Number | String | 20 | |
23 | DSCRIPTN ![]() | Description | STR30 | String | 30 | |
24 | PARTPCT ![]() | Part Pct | DLR5_%2 | Currency | 8 | |
25 | LABPCT ![]() | Labor Pct | DLR5_%2 | Currency | 8 | |
26 | MISCPCT ![]() | Misc Pct | DLR5_%2 | Currency | 8 | |
27 | PMMSCPCT ![]() | PM Misc Pct | DLR5_%2 | Currency | 8 | |
28 | PMPRTPCT ![]() | PM Part Pct | DLR5_%2 | Currency | 8 | |
29 | PMLABPCT ![]() | PM Labor Pct | DLR5_%2 | Currency | 8 | |
30 | VENDORID ![]() | Vendor ID | STR_15_Vendor_ID | String | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].VENDORID AS 'SVC_Contract_Line_HIST-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SVC_Contract_Line_HIST'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
31 | RETNAGAM ![]() | Retainage Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
32 | RTNBILLD ![]() | Retainage Billed | DLR11_RBS0_UTR$ | Currency | 11 | |
33 | SLPRSNID ![]() | Salesperson ID | STR15_Salesperson_ID | String | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].SLPRSNID AS 'SVC_Contract_Line_HIST-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['SVC_Contract_Line_HIST'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
34 | COMMCODE ![]() | Commission Code | STR15_LBAU | String | 15 | |
35 | COMPRCNT ![]() | Commission Percent | INT5_%2 | Integer | 5 | |
36 | BILSTRT ![]() | Bill Start | DATE | Date | 6 | |
37 | BILEND ![]() | Bill End | DATE | Date | 6 | |
38 | BILLNGTH ![]() | Bill Length | INT3 | Integer | 3 | |
39 | BILPRD ![]() | Bill Period | DDL_Bill_Period | Integer | 0 | |
40 | FRSTBLDTE ![]() | First Bill Date | DATE | Date | 6 | |
41 | Last_Amount_Billed ![]() | Last Amount Billed | DLR11_RBS0_UTR$ | Currency | 11 | |
42 | LSTBLDTE ![]() | Last Bill Date | DATE | Date | 6 | |
43 | NBRCAL ![]() | Max Number of Calls | INT5 | Integer | 4 | |
44 | TOTAL ![]() | Total | Dollar19 | Currency | 19 | |
45 | ACTCAL ![]() | Actual Number of Calls | INT5 | Integer | 4 | |
46 | TOTVALCAL ![]() | Total Value of Calls | DLR19_RBSO_UTR$ | Currency | 19 | |
47 | CONTACT ![]() | Contact | STR60 | String | 60 | |
48 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].CURNCYID AS 'SVC_Contract_Line_HIST-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SVC_Contract_Line_HIST'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
49 | NXTBLDTE ![]() | Next Bill Date | DATE | Date | 6 | |
50 | CNTTYPE ![]() | Contract Type | STR10_LBAU | String | 10 | |
51 | PRICSHED ![]() | Price Schedule | STR10_Schedule | String | 10 | |
52 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].CUSTNMBR AS 'SVC_Contract_Line_HIST-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SVC_Contract_Line_HIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
53 | ENTDTE ![]() | Entry Date | DT_Date | Date | 6 | |
54 | MINBIL ![]() | Min Billable Call | DLR19_RBS0_UTR$ | Currency | 19 | |
55 | MAXBIL ![]() | Max Billable Call | DLR19_RBS0_UTR$ | Currency | 19 | |
56 | MAXBILL ![]() | Max Billable | DLR19_RBS0_UTR$ | Currency | 19 | |
57 | AUTOREN ![]() | Auto Renewing | CB | Boolean | 0 | |
58 | priorityLevel ![]() | priorityLevel | INT4 | Integer | 4 | |
59 | MSTCNTRCT ![]() | Master Contract Number | STR10 | String | 10 | |
60 | SRVTYPE ![]() | Service Type | STR10_LBAU | String | 10 | |
61 | BILFRRET ![]() | Bill For Retainer | CB | Boolean | 0 | |
62 | TOTBIL ![]() | Total Billed | DLR19_RBSO_UTR$ | Currency | 19 | |
63 | PREPAID ![]() | Pre Paid | CB | Boolean | 0 | |
64 | BILONDY ![]() | Bill On Day | INT2_U0 | Integer | 2 | |
65 | BILCYC ![]() | Billing Cycle | SVC_DDL_Billing_Cycle | Integer | 0 | |
66 | UOFM ![]() | U Of M | U_Of_M | String | 8 | |
67 | BILSTAT ![]() | Billing Status | DDL_Bill_Status_SVC | Integer | 0 | |
68 | ENTTME ![]() | Entry Time | TM6 | Time | 6 | |
69 | STRTDATE ![]() | Start Date | DT | Date | 8 | |
70 | ENDDATE ![]() | End Date | DT | Date | 8 | |
71 | CNTCOVPD ![]() | Contract Coverage Periods Start | TM6 | Time | 6 | |
72 | CNTCOVPD_1 ![]() | Contract Coverage Periods Start[1] | TM6 | Time | 6 | |
73 | CNTCOVPD_2 ![]() | Contract Coverage Periods Start[2] | TM6 | Time | 6 | |
74 | CNTCOVPD_3 ![]() | Contract Coverage Periods Start[3] | TM6 | Time | 6 | |
75 | CNTCOVPD_4 ![]() | Contract Coverage Periods Start[4] | TM6 | Time | 6 | |
76 | CNTCOVPD_5 ![]() | Contract Coverage Periods Start[5] | TM6 | Time | 6 | |
77 | CNTCOVPD_6 ![]() | Contract Coverage Periods Start[6] | TM6 | Time | 6 | |
78 | CNTCOVPD_7 ![]() | Contract Coverage Periods Start[7] | TM6 | Time | 6 | |
79 | Contract_Coverage_Period ![]() | Contract Coverage Periods End | TM6 | Time | 6 | |
80 | Contract_Coverage_Period_1 ![]() | Contract Coverage Periods End[1] | TM6 | Time | 6 | |
81 | Contract_Coverage_Period_2 ![]() | Contract Coverage Periods End[2] | TM6 | Time | 6 | |
82 | Contract_Coverage_Period_3 ![]() | Contract Coverage Periods End[3] | TM6 | Time | 6 | |
83 | Contract_Coverage_Period_4 ![]() | Contract Coverage Periods End[4] | TM6 | Time | 6 | |
84 | Contract_Coverage_Period_5 ![]() | Contract Coverage Periods End[5] | TM6 | Time | 6 | |
85 | Contract_Coverage_Period_6 ![]() | Contract Coverage Periods End[6] | TM6 | Time | 6 | |
86 | Contract_Coverage_Period_7 ![]() | Contract Coverage Periods End[7] | TM6 | Time | 6 | |
87 | USECVPD ![]() | Use Coverage Period | CB_Day | Boolean | 0 | |
88 | USECVPD_1 ![]() | Use Coverage Period[1] | CB_Day | Boolean | 0 | |
89 | USECVPD_2 ![]() | Use Coverage Period[2] | CB_Day | Boolean | 0 | |
90 | USECVPD_3 ![]() | Use Coverage Period[3] | CB_Day | Boolean | 0 | |
91 | USECVPD_4 ![]() | Use Coverage Period[4] | CB_Day | Boolean | 0 | |
92 | USECVPD_5 ![]() | Use Coverage Period[5] | CB_Day | Boolean | 0 | |
93 | USECVPD_6 ![]() | Use Coverage Period[6] | CB_Day | Boolean | 0 | |
94 | USECVPD_7 ![]() | Use Coverage Period[7] | CB_Day | Boolean | 0 | |
95 | TAXSCHID ![]() | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].TAXSCHID AS 'SVC_Contract_Line_HIST-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SVC_Contract_Line_HIST'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
96 | CNFGLVL ![]() | Config Level | INT4 | Integer | 4 | |
97 | CNFGSEQ ![]() | Config Sequence | INT4 | Integer | 4 | |
98 | Contract_Length ![]() | Contract Length | INT3 | Integer | 3 | |
99 | Contract_Period ![]() | Contract Period | DDL_Bill_Period | Integer | 0 | |
100 | Invoiced_Amount ![]() | Invoiced Amount | DLR19_$U2 | Currency | 19 | |
101 | Amount_To_Invoice ![]() | Amount To Invoice | SVCDLR19_$U2 | Currency | 19 | |
102 | Liabiltiy_Reduction ![]() | Liability Reduction | CB | Boolean | 0 | |
103 | Liability_Amount ![]() | Liability Amount | DLR17_$U2 | Currency | 17 | |
104 | Total_Liability_Amount ![]() | Total Liability Amount | DLR19_$U2 | Currency | 19 | |
105 | NUMOFINV ![]() | Number of Invoices | LI6_U0 | Long Integer | 6 | |
106 | New_Invoice_Amount ![]() | New Invoice Amount | DLR19_$U2 | Currency | 19 | |
107 | Contract_Line_Status ![]() | Contract Line Status | STR1 | String | 1 | |
108 | Contract_Renewal_Contact ![]() | Contract Renewal Contact | STR30 | String | 30 | |
109 | Contract_Response_Time ![]() | Contract Response Time | STR_Bill_Time | String | 6 | |
110 | Liability_Months ![]() | Liability Months | INT3 | Integer | 3 | |
111 | Next_Liability_Date ![]() | Next Liability Date | DATE | Date | 6 | |
112 | Last_Liability_Date ![]() | Last Liability Date | DATE | Date | 6 | |
113 | Total_Liability_Billed ![]() | Total Liability Billed | DLR19_$U2 | Currency | 19 | |
114 | TAXEXMT1 ![]() | Tax Exempt 1 | STR25 | String | 25 | |
115 | TAXEXMT2 ![]() | Tax Exempt 2 | STR25 | String | 25 | |
116 | Total_Unit ![]() | Total Unit | Dollar19 | Currency | 19 | |
117 | UNITCOST ![]() | Unit Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
118 | Unit_Cost_Total ![]() | Unit Cost Total | DLR19_$U2 | Currency | 19 | |
119 | SVC_Liability_Type ![]() | SVC_Liability_Type | DDL_Liability_Type | Integer | 0 | |
120 | SVC_Contract_Signed ![]() | SVC_Contract_Signed | DATE_L | Date | 0 | |
121 | RETTYPE ![]() | SVC Return Type | STR10_LBAU | String | 10 | |
122 | SVC_Monthly_Price ![]() | SVC Monthly_Price | DLR17_RBS0_UTR$ | Currency | 17 | |
123 | Location_Segment ![]() | Location Segment | STR66_Site_SEG | String | 66 | |
124 | Bill_To_Customer ![]() | Bill To Customer | STR15_RM_Customer_Number | String | 15 | |
125 | SVC_Bill_To_Address_Code ![]() | SVC Bill To Address Code | STR15_Address_Code | String | 15 | |
126 | DSCDLRAM ![]() | Discount Dollar Amount | DLR11_RBS0_UTR$ | Currency | 11 | |
127 | SVC_Invoiced_Discount ![]() | SVC Invoiced Discount | DLR19_$U2 | Currency | 19 | |
128 | SVC_Discount_Recognized ![]() | SVC Discount Recognized | DLR19_$U2 | Currency | 19 | |
129 | SVC_Discount_Remaining ![]() | SVC Discount Remaining | DLR19_$U2 | Currency | 19 | |
130 | SVC_Discount_Next ![]() | SVC Discount Next | DLR19_$U2 | Currency | 19 | |
131 | SVC_PM_Date ![]() | SVC PM Month | SVC_DDL_Month | Integer | 0 | |
132 | SVC_PM_Day ![]() | SVC PM Day | SVC_PM_Day | Integer | 2 | |
133 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].CURRNIDX AS 'SVC_Contract_Line_HIST-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SVC_Contract_Line_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
134 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].RATETPID AS 'SVC_Contract_Line_HIST-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SVC_Contract_Line_HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
135 | EXGTBLID ![]() | Exchange Table ID | STR15_Exchange_Table_ID | String | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['SVC_Contract_Line_HIST'].EXGTBLID AS 'SVC_Contract_Line_HIST-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['SVC_Contract_Line_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
136 | XCHGRATE ![]() | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
137 | EXCHDATE ![]() | Exchange Date | DT_Date | Date | 6 | |
138 | DECPLACS ![]() | Decimal Places | DDL_Decimal_Places | Integer | 0 | |
139 | TIME1 ![]() | Time | TM6 | Time | 6 | |
140 | RATECALC ![]() | Rate Calc Method | INT | Integer | 0 | |
141 | VIEWMODE ![]() | View Mode | INT | Integer | 0 | |
142 | ISMCTRX ![]() | IS MC Trx | INT | Integer | 0 | |
143 | EXPNDATE ![]() | Expiration Date | DT_Date | Date | 6 | |
144 | DENXRATE ![]() | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
145 | MCTRXSTT ![]() | MC Transaction State | INT1 | Integer | 1 | |
146 | ORIGVALTIM ![]() | Originating Value of Time | CURR_TIME | Currency | 10 | |
147 | ORCOMAMT ![]() | Originating Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 17 | |
148 | ORIGRETNAGAM ![]() | Originating Retainage Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
149 | ORIGRTNBILLD ![]() | Originating Retainage Billed | DLR17_RBS0_UTR$ | Currency | 17 | |
150 | ORIGLASTAmountBilled ![]() | Originating Last Amount Billed | DLR11_RBS0_UTR$ | Currency | 11 | |
151 | ORIGTOTAL ![]() | Originating Service Total | Dollar19 | Currency | 19 | |
152 | ORIGTOTVALCAL ![]() | Originating Total Value of Calls | DLR19_RBSO_UTR$ | Currency | 19 | |
153 | ORIGMINBIL ![]() | Originating Min Billable Call | DLR19_RBSO_UTR$ | Currency | 19 | |
154 | ORIGMAXBIL ![]() | Originating Max Billable Call | DLR19_RBSO_UTR$ | Currency | 19 | |
155 | Originating_Max_Billable ![]() | Originating Max Billable | DLR19_RBSO_STR$ | Currency | 19 | |
156 | ORIGTOTBIL ![]() | Originating Total Billed | DLR19_RBSO_UTR$ | Currency | 19 | |
157 | Orig_Invoiced_Amount ![]() | Originating Invoiced Amount | DLR19_$U2 | Currency | 19 | |
158 | Orig_Amount_To_Invoice ![]() | Originating Amount To Invoice | SVCDLR19_$U2 | Currency | 19 | |
159 | Orig_Liability_Amount ![]() | Originating Liability Amount | DLR19_$U2 | Currency | 19 | |
160 | OrigTotLiabilityAmount ![]() | Originating Total Liability Amount | DLR19_$U2 | Currency | 19 | |
161 | OrigTotLiabBilled ![]() | Originating Total Liability Billed | DLR19_$U2 | Currency | 19 | |
162 | Originating_Total_Unit ![]() | Originating Total Unit | Dollar19 | Currency | 19 | |
163 | ORUNTCST ![]() | Originating Unit Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
164 | ORDDLRAT ![]() | Originating Discount Dollar Amount | DLR11_RBS0_UTR$ | Currency | 11 | |
165 | OrigDiscountReceived ![]() | Originating Discount Recognized | DLR19_$U2 | Currency | 19 | |
166 | OrigDiscountRemaining ![]() | Originating Discount Remaining | DLR19_$U2 | Currency | 19 | |
167 | OrigDiscountNext ![]() | Originating Discount Next | DLR19_$U2 | Currency | 19 | |
168 | ORIGUNITCOSTTOTAL ![]() | Originating Unit Cost Total | DLR19_$U2 | Currency | 19 | |
169 | ORIGMONTHPRICE ![]() | Originating Monthly Price | DLR17_RBS0_UTR$ | Currency | 17 | |
170 | ORIGINVOICEDDISC ![]() | Originating Invoiced Discount | DLR19_$U2 | Currency | 19 | |
171 | OrigNewInvoiceAmount ![]() | Originating New Invoice Amount | DLR19_$U2 | Currency | 19 | |
172 | TAXAMNT ![]() | Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
173 | ORTAXAMT ![]() | Originating Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
174 | SVC_FO_ID ![]() | SVC FO ID | STR50 | String | 50 | |
175 | SVC_Contract_Version ![]() | SVC_Contract_Version | INT3 | Integer | 3 | |
176 | MovedRevenue ![]() | Moved Revenue | DLR17_$U2 | Currency | 17 | |
177 | OriginalTotal ![]() | Original Total | Dollar19 | Currency | 19 | |
178 | OrigMovedRevenue ![]() | Originating Moved Revenue | DLR17_$U2 | Currency | 17 | |
179 | OrigOriginalTotal ![]() | Originating Original Total | Dollar19 | Currency | 19 | |
180 | Credit_Hold ![]() | Credit Hold | CB | Boolean | 0 | |
181 | ITEMDESC ![]() | Item Description | STR100 | String | 100 | |
182 | 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. |