| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| callID |
Call ID |
Int |
11 |
- |
|
|
|
| subject |
Subject |
nVarChar |
254 |
- |
|
|
|
| customer |
Business Partner Code |
nVarChar |
15 |
OCRD |
|
|
|
| custmrName |
Business Partner Name |
nVarChar |
200 |
- |
|
|
|
| contctCode |
Contact Person |
Int |
11 |
OCPR |
|
|
|
| manufSN |
Mfr Serial No. |
nVarChar |
36 |
- |
|
|
|
| internalSN |
Serial Number |
nVarChar |
36 |
- |
|
|
|
| contractID |
Contract No. |
Int |
11 |
OCTR |
|
|
|
| cntrctDate |
Contract End Date |
Date |
8 |
- |
|
|
|
| resolDate |
Resolution Date |
Date |
8 |
- |
|
|
|
| resolTime |
Resolution Time |
Int |
6 |
- |
|
|
|
| free_1 |
Warranty |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| free_2 |
Warranty End Date |
Date |
8 |
- |
|
|
|
| origin |
Origin |
Int |
6 |
OSCO |
|
|
|
| itemCode |
Item No. |
nVarChar |
50 |
OITM |
|
|
|
| itemName |
Item Description |
nVarChar |
200 |
- |
|
|
|
| itemGroup |
Item Group |
Int |
6 |
OITB |
|
|
|
| status |
Status |
Int |
6 |
OSCS |
-3 |
|
|
| priority |
Priority |
VarChar |
1 |
- |
L |
L |
Low |
| |
|
|
|
|
|
M |
Medium |
| |
|
|
|
|
|
H |
High |
| callType |
Call Type |
Int |
6 |
OSCT |
|
|
|
| problemTyp |
Problem Type |
Int |
6 |
OSCP |
|
|
|
| assignee |
Handled By |
Int |
6 |
OUSR |
|
|
|
| descrption |
Description |
Text |
16 |
- |
|
|
|
| objType |
Object Type |
nVarChar |
20 |
- |
191 |
|
|
| logInstanc |
Log Instance |
Int |
11 |
- |
|
|
|
| userSign |
Creating User |
Int |
6 |
OUSR |
|
|
|
| createDate |
Creation Date |
Date |
8 |
- |
|
|
|
| createTime |
Creation Time |
Int |
6 |
- |
|
|
|
| closeDate |
Closing Date |
Date |
8 |
- |
|
|
|
| closeTime |
Closing Time |
Int |
6 |
- |
|
|
|
| userSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| updateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| SCL1Count |
InternalSCL1Count |
Int |
11 |
- |
0 |
|
|
| SCL2Count |
InternalSCL2Count |
Int |
11 |
- |
0 |
|
|
| isEntitled |
Entitle for Service |
VarChar |
1 |
- |
N |
N |
Not Entitled |
| |
|
|
|
|
|
C |
Valid contract exists |
| insID |
Install Card No. |
Int |
11 |
OINS |
|
|
|
| technician |
Technician |
Int |
11 |
OHEM |
|
|
|
| resolution |
Resolution |
Text |
16 |
- |
|
|
|
| Scl1NxtLn |
SCL1 Next Line |
Int |
11 |
- |
|
|
|
| Scl2NxtLn |
SCL2 Next Line |
Int |
11 |
- |
|
|
|
| Scl3NxtLn |
SCL3 Next Line |
Int |
11 |
- |
|
|
|
| Scl4NxtLn |
SCL4 Next Line |
Int |
11 |
- |
|
|
|
| Scl5NxtLn |
SCL5 Next Line |
Int |
11 |
- |
|
|
|
| isQueue |
Belongs to a Queue |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| Queue |
Queue |
nVarChar |
20 |
OQUE |
|
|
|
| resolOnDat |
Resolution on Date |
Date |
8 |
- |
|
|
|
| resolOnTim |
Resolution on Time |
Int |
6 |
- |
|
|
|
| respByDate |
Response by Date |
Date |
8 |
- |
|
|
|
| respByTime |
Response by Time |
Int |
6 |
- |
|
|
|
| respOnDate |
Response on Date |
Date |
8 |
- |
|
|
|
| respOnTime |
Response on Time |
Int |
6 |
- |
|
|
|
| respAssign |
Assigned for Response |
Int |
6 |
OUSR |
|
|
|
| AssignDate |
Assigned Date |
Date |
8 |
- |
|
|
|
| AssignTime |
Assigned Time |
Int |
6 |
- |
|
|
|
| UpdateTime |
Updated Time |
Int |
6 |
- |
|
|
|
| responder |
Responder |
Int |
6 |
OUSR |
|
|
|
| Transfered |
Year Transfer |
VarChar |
1 |
- |
N |
|
|
| Instance |
Instance |
Int |
6 |
- |
0 |
|
|
| DocNum |
Document Number |
Int |
11 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| Handwrtten |
Manual Numbering |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PIndicator |
Period Indicator |
nVarChar |
10 |
OPID |
' ' |
|
|
| StartDate |
Start Date |
Date |
8 |
- |
|
|
|
| StartTime |
Start Time |
Int |
11 |
- |
|
|
|
| EndDate |
End Date |
Date |
8 |
- |
|
|
|
| EndTime |
End Time |
Int |
11 |
- |
|
|
|
| Duration |
Service Call Duration |
Num |
19.6 |
- |
|
|
|
| DurType |
Duration UoM |
VarChar |
1 |
- |
M |
S |
Seconds |
| |
|
|
|
|
|
M |
Minutes |
| |
|
|
|
|
|
H |
Hours |
| |
|
|
|
|
|
D |
Days |
| Reminder |
Reminder |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RemQty |
Reminder Quantity |
Num |
19.6 |
- |
|
|
|
| RemType |
Reminder UoM |
VarChar |
1 |
- |
M |
S |
Seconds |
| |
|
|
|
|
|
M |
Minutes |
| |
|
|
|
|
|
H |
Hours |
| |
|
|
|
|
|
D |
Days |
| RemDate |
Reminder Date |
Date |
8 |
- |
|
|
|
| RemSent |
Reminder Sent |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RemTime |
Reminder Time |
Int |
6 |
- |
|
|
|
| Location |
Location |
Int |
6 |
OCLO |
-1 |
|
|
| AddrName |
Address Name |
nVarChar |
50 |
- |
|
|
|
| AddrType |
Address Type |
VarChar |
1 |
- |
S |
S |
Ship To |
| |
|
|
|
|
|
B |
Bill To |
| Street |
Street |
nVarChar |
100 |
- |
|
|
|
| City |
City |
nVarChar |
100 |
- |
|
|
|
| Room |
Room |
nVarChar |
50 |
- |
|
|
|
| State |
State |
nVarChar |
3 |
OCST |
|
|
|
| Country |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| DisplInCal |
Display in Calendar |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SupplCode |
Supplementary Code |
nVarChar |
254 |
- |
|
|
|
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
- |
|
|
|
| NumAtCard |
Business Partner Ref. No. |
nVarChar |
200 |
- |
|
|
|
| ProSubType |
Problem Subtype |
Int |
6 |
OPST |
|
|
|
| BPType |
Business Partner Type |
VarChar |
1 |
- |
R |
R |
Sales |
| |
|
|
|
|
|
P |
Purchasing |
| Telephone |
Phone Number |
nVarChar |
50 |
- |
|
|
|
| BPPhone1 |
BP Phone Number1 |
nVarChar |
50 |
- |
|
|
|
| BPPhone2 |
BP Phone Number1 |
nVarChar |
50 |
- |
|
|
|
| BPCellular |
BP Mobile Phone Number |
nVarChar |
50 |
- |
|
|
|
| BPFax |
BP Fax Number |
nVarChar |
50 |
- |
|
|
|
| BPShipCode |
BP Ship-to Code |
nVarChar |
50 |
- |
|
|
|
| BPShipAddr |
BP Ship-to Address |
nVarChar |
254 |
- |
|
|
|
| BPBillCode |
BP Bill-to Code |
nVarChar |
50 |
- |
|
|
|
| BPBillAddr |
BP Bill-to Address |
nVarChar |
254 |
- |
|
|
|
| BPTerrit |
Business Partner Territory |
Int |
11 |
- |
|
|
|
| BPE_Mail |
Business Partner E-Mail |
nVarChar |
100 |
- |
|
|
|
| BPProjCode |
Business Partner Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| BPContact |
BP Contact Person |
nVarChar |
245 |
- |
|
|
|
| OwnerCode |
Service Call Owner |
Int |
11 |
OHEM |
|
|
|
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| Printed |
Printed |
VarChar |
1 |
- |
N |
|
|
| DataVers |
Data Version |
Int |
11 |
- |
1 |
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Upgrade |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Auto Summary |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year of Transfer |