SVC00700 - Service Transfer Header
Dynamics GP table SVC00700 (Service Transfer Header) contains 23 columns including ORDDOCID, RFRNCDOC, TECHID....
SQL Query Builder
23 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| ORDDOCID | Order Document ID | String | 16 | |
| RFRNCDOC | Reference Document | String | 22 | |
| TECHID | Tech ID | String | 12 | |
| OFFID | Office ID | String | 12 | |
| STATUS | Transfer Status | Integer | 2 | |
| ORDRDATE | Order Date | Date | 4 | |
| ETADTE | ETA Date | Date | 4 | |
| CUSTNAME | Customer Name | String | 66 | |
| ADDRESS1 | Address 1 | String | 62 | |
| ADDRESS2 | Address 2 | String | 62 | |
| CITY | City | String | 36 | |
| STATE | State | String | 30 | |
| ZIPCODE | Zip Code | String | 12 | |
| SHIPMTHD | Shipping Method | String | 16 | |
| TRNSFLOC | Transfer From Location | String | 12 | |
| ITLOCN | Intransit Location | String | 12 | |
| LOCNCODE | Location Code | String | 12 | |
| NOTEINDX | Note Index | Currency | 10 | |
| SVC_Address_Option | SVC_Address_Option | Integer | 2 | |
| SVC_Misc_Address_Code | SVC_Misc_Address_Code | String | 16 | |
| ADDRESS3 | Address 3 | String | 62 | |
| COUNTRY | Country | String | 62 | |
| USERID | User ID | String | 16 |
Related Tables
Tables that share columns with SVC00700. Click "Join" to add to your query.