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