SVINTER2 - ServiceCallOptions
SQL Query Builder
23 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| Start_Service_Call_ID | char(17) | |||
| End_Service_Call_ID | char(17) | |||
| Start_Customer_Number | char(15) | |||
| End_Customer_Number | char(15) | |||
| Start_Addr_Code | char(15) | |||
| End_Addr_Code | char(15) | |||
| Start_Equip_ID | char(11) | |||
| End_Equip_ID | char(11) | |||
| Start_Tech_Technician | char(11) | |||
| End_Tech_Technician | char(11) | |||
| Start_Maint_Contract_Num | char(11) | |||
| End_Maint_Contract_Num | char(11) | |||
| Start_Meter_Read_Date | datetime | |||
| End_Meter_Read_Date | datetime | |||
| Start_JCH_Ref_Trx_Num | char(17) | |||
| End_JCH_Ref_TRX_Num | char(17) | |||
| Start_JCH_Seq_Number | int | |||
| End_JCH_Seq_Number | int | |||
| Start_NTE_Note_Type | char(1) | |||
| End_NTE_Note_Type | char(1) | |||
| Start_NTE_Service_Index | char(25) | |||
| End_NTE_Service_Index | char(25) | |||
| DEX_ROW_ID | int auto number (1,1) |