| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| SOPTYPE | SOP Type 1 = Quote |
Integer | 2 | View | |
| SOPNUMBE | SOP Number |
String | 22 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CUSTNAME | Customer Name |
String | 66 | View | |
| ADRSCODE | Address Code |
String | 16 | View | |
| CNTTYPE | Contract Type |
String | 12 | View | |
| Contract_Length | Contract Length |
Integer | 2 | View | |
| Contract_Period | Contract Period |
Integer | 2 | View | |
| STRTDATE | Start Date |
Date | 4 | View | |
| ENDDATE | End Date |
Date | 4 | View | |
| PREPAID | Pre Paid |
Boolean | 2 | View | |
| PRICSHED | Price Schedule |
String | 12 | View | |
| BILLNGTH | Bill Length |
Integer | 2 | View | |
| BILPRD | Bill Period |
Integer | 2 | View | |
| BILSTRT | Bill Start |
Date | 4 | View | |
| BILEND | Bill End |
Date | 4 | View | |
| BILONDY | Bill On Day |
Integer | 2 | View | |
| BILCYC | Billing Cycle |
Integer | 2 | View | |
| SVC_Liability_Type | SVC_Liability_Type |
Integer | 2 | View | |
| Bill_To_Customer | Bill To Customer |
String | 16 | View | |
| SVC_Bill_To_Address_Code | SVC Bill To Address Code |
String | 16 | View | |
| PORDNMBR | Purchase Order Number |
String | 22 | View | |
| SVC_Invoice_Detail | SVC Invoice Detail |
Boolean | 2 | View | |
| PARTPCT | Part Pct |
Currency | 10 | View | |
| LABPCT | Labor Pct |
Currency | 10 | View | |
| MISCPCT | Misc Pct |
Currency | 10 | View | |
| PMPRTPCT | PM Part Pct |
Currency | 10 | View | |
| PMLABPCT | PM Labor Pct |
Currency | 10 | View | |
| PMMSCPCT | PM Misc Pct |
Currency | 10 | View | |
| SVC_Paid_Contract | SVC Paid Contract |
Boolean | 2 | View | |
| DSCPCTAM | Discount Percent Amount |
Integer | 2 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| RATETPID | Rate Type ID |
String | 16 | View | |
| EXGTBLID | Exchange Table ID |
String | 16 | View | |
| XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
| EXCHDATE | Exchange Date |
Date | 4 | View | |
| TIME1 | Time |
Time | 4 | View | |
| DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
| MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
| svcBillingFrequency | svcBillingFrequency |
Integer | 2 | View | |
| svcFrequencyQty | svcFrequencyQty |
Integer | 2 | View |