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 |