|
1
|
SM03
|
SM03001
|
ServOrderNo
|
STRING
|
10
|
10
|
0
|
Service Order Number
|
|
2
|
SM03
|
SM03002
|
ItemNo
|
STRING
|
4
|
4
|
0
|
Order Line Number
|
|
|
SM03
|
SM03003
|
LineType
|
STRING
|
1
|
1
|
0
|
Line Type 0 - Normal activity line
5 - Linked picture
9 - Text line
|
|
|
SM03
|
SM03004
|
ActivityCode
|
STRING
|
8
|
8
|
0
|
Activity Code
|
|
|
SM03
|
SM03005
|
Description
|
VSTRING
|
35
|
35
|
0
|
Description
|
|
|
SM03
|
SM03006
|
FldEngineer
|
STRING
|
10
|
10
|
0
|
Resource Code Engineer
|
|
|
SM03
|
SM03007
|
PlannedHours
|
X_NUMERIC
|
12
|
20
|
8
|
Hours Planned
|
|
|
SM03
|
SM03008
|
ActualHours
|
X_NUMERIC
|
12
|
20
|
8
|
Hours Actual
|
|
|
SM03
|
SM03009
|
SPARE
|
MONEY
|
20
|
28
|
8
|
SPARE
|
|
|
SM03
|
SM03010
|
SPARE
|
MONEY
|
20
|
28
|
8
|
SPARE
|
|
|
SM03
|
SM03011
|
BudgCostLCU
|
MONEY
|
20
|
28
|
8
|
Unit Cost Planned (Local Currency)
|
|
|
SM03
|
SM03012
|
ActuaCostLCU
|
MONEY
|
20
|
28
|
8
|
Unit Cost Actual (Local Currency)
|
|
|
SM03
|
SM03013
|
Spare
|
STRING
|
4
|
4
|
0
|
(obsolete)
|
|
|
SM03
|
SM03014
|
ProposInvAmoOcu
|
MONEY
|
20
|
28
|
8
|
Unit Price Proposed for Invoice (Invoice Currency)
|
|
|
SM03
|
SM03015
|
ActualInvAmoOcu
|
MONEY
|
20
|
28
|
8
|
Unit Price Actual Invoiced (Invoice Currency)
|
|
|
SM03
|
SM03016
|
VATCode1
|
STRING
|
6
|
6
|
0
|
VAT Code 1
|
|
|
SM03
|
SM03017
|
AccountCode
|
STRING
|
2
|
2
|
0
|
Accounting Code
|
|
|
SM03
|
SM03018
|
CostType
|
STRING
|
6
|
6
|
0
|
Cost Category
|
|
|
SM03
|
SM03019
|
CoveredByContract
|
STRING
|
6
|
6
|
0
|
Covered By Contract 0 - The activity line is not covered by any contract
1 - The activity line is covered be a contract and will not be charged to the customer
|
|
|
SM03
|
SM03020
|
Spare
|
STRING
|
6
|
6
|
0
|
(obsolete)
|
|
|
SM03
|
SM03021
|
IncludFixPr
|
SWITCH
|
1
|
1
|
0
|
Included in Fixed Price
|
|
|
SM03
|
SM03022
|
CustCodeInv
|
STRING
|
10
|
10
|
0
|
Customer Code Invoice
|
|
|
SM03
|
SM03023
|
InvoiceDate
|
DATE
|
8
|
0
|
0
|
Invoice Date
|
|
|
SM03
|
SM03024
|
InvoiceNo
|
STRING
|
15
|
15
|
0
|
Invoice Number
|
|
|
SM03
|
SM03025
|
PlannedPriceOCU
|
MONEY
|
20
|
28
|
8
|
Unit Price Planned (Order Currency)
|
|
|
SM03
|
SM03026
|
TransactDate
|
DATE
|
8
|
0
|
0
|
Transaction Date
|
|
|
SM03
|
SM03027
|
DiscountLabour
|
X_NUMERIC
|
7
|
15
|
8
|
Discount %
|
|
|
SM03
|
SM03028
|
HoursInvoice
|
X_NUMERIC
|
12
|
20
|
8
|
Hours to Invoiced
|
|
|
SM03
|
SM03029
|
PricelistNo
|
STRING
|
2
|
2
|
0
|
Price List
|
|
|
SM03
|
SM03030
|
ChangeCustomer
|
SWITCH
|
1
|
1
|
0
|
Calculate Price Option used internally to indicate if price needs to be recalculated on the activity line.
1 - The price on the activity line has not been recalculated after change of customer
2 - The price on the activity line has already been calculated for the customer on the order line
|
|
|
SM03
|
SM03031
|
InvUpdStat
|
INTEGER
|
1
|
0
|
0
|
Invoice Status 0/1 - The line has not been sent on a invoice
2 - The activity line has been sent/included in a invoice.
|
|
|
SM03
|
SM03032
|
Spare
|
STRING
|
2
|
2
|
0
|
(obsolete)
|
|
|
SM03
|
SM03033
|
PriceTabell
|
STRING
|
8
|
8
|
0
|
Price Table
|
|
|
SM03
|
SM03034
|
AccString
|
ACCSTR
|
120
|
120
|
0
|
Accounting String
|
|
|
SM03
|
SM03035
|
VATCode2
|
STRING
|
6
|
6
|
0
|
VAT Code 2
|
|
|
SM03
|
SM03036
|
ActivStrDate
|
DATE
|
8
|
0
|
0
|
Planned Start Date
|
|
|
SM03
|
SM03037
|
ActivStrTime
|
X_NUMERIC
|
5
|
13
|
8
|
Planned Start Time
|
|
|
SM03
|
SM03038
|
ActivEndDate
|
DATE
|
8
|
0
|
0
|
Planned End Date
|
|
|
SM03
|
SM03039
|
ActivEndTime
|
X_NUMERIC
|
5
|
13
|
8
|
Planned End Time
|
|
|
SM03
|
SM03040
|
IncludedInCurrencyClause
|
INTEGER
|
1
|
0
|
0
|
Include in Currency Clause
|
|
|
SM03
|
SM03041
|
OrderCurrencyCode
|
STRING
|
2
|
2
|
0
|
Currency Code Order
|
|
|
SM03
|
SM03042
|
CurrExchRate
|
X_NUMERIC
|
20
|
28
|
8
|
Currency Exchange Rate
|
|
|
SM03
|
SM03043
|
SPARE
|
MONEY
|
20
|
28
|
8
|
SPARE
|
|
|
SM03
|
SM03044
|
ActualPriceOCU
|
MONEY
|
20
|
28
|
8
|
Unit Price Actual (Order Currency)
|
|
|
SM03
|
SM03045
|
SPARE
|
MONEY
|
20
|
28
|
8
|
SPARE
|
|
|
SM03
|
SM03046
|
PropInvAmountIcu
|
MONEY
|
20
|
28
|
8
|
Unit Price Proposed for Invoice (Order Currency)
|
|
|
SM03
|
SM03047
|
PropInvAmountLcu
|
MONEY
|
20
|
28
|
8
|
Unit Price Proposed for Invoice (Local Currency)
|
|
|
SM03
|
SM03048
|
ActInvAmountIcu
|
MONEY
|
20
|
28
|
8
|
Unit Price Actual Invoiced (Order Currency)
|
|
|
SM03
|
SM03049
|
ActInvAmountLCU
|
MONEY
|
20
|
28
|
8
|
Unit Price Actual Invoiced (Local Currency)
|
|
|
SM03
|
SM03050
|
InvoiceCurrency
|
STRING
|
2
|
2
|
0
|
Currency Code Invoice
|
|
|
SM03
|
SM03051
|
StatusSwitch0
|
SWITCH
|
1
|
1
|
0
|
Line Status 1
|
|
|
SM03
|
SM03052
|
StatusSwitch1
|
SWITCH
|
1
|
1
|
0
|
Line Status 2
|
|
|
SM03
|
SM03053
|
StatusSwitch2
|
SWITCH
|
1
|
1
|
0
|
Line Status 3
|
|
|
SM03
|
SM03054
|
StatusSwitch3
|
SWITCH
|
1
|
1
|
0
|
Line Status 4
|
|
|
SM03
|
SM03055
|
StatusSwitch4
|
SWITCH
|
1
|
1
|
0
|
Line Status 5
|
|
|
SM03
|
SM03056
|
StatusSwitch5
|
SWITCH
|
1
|
1
|
0
|
Marked for Invoice Applies only to long term order:
0 - The activity line is not marked as ready for invoice
1 - The activity line is ready for invoice
|
|
|
SM03
|
SM03057
|
ActualStartDate
|
DATE
|
8
|
0
|
0
|
Actual Start Date
|
|
|
SM03
|
SM03058
|
ActualStrTime
|
X_NUMERIC
|
5
|
13
|
8
|
Actual Start Time
|
|
|
SM03
|
SM03059
|
ActualEndDate
|
DATE
|
8
|
0
|
0
|
Actual End Date
|
|
|
SM03
|
SM03060
|
ActualEndTime
|
X_NUMERIC
|
5
|
13
|
8
|
Actual End Time
|
|
|
SM03
|
SM03061
|
Predecessors
|
STRING
|
150
|
150
|
0
|
Predecessors MS Project Reserved for use when integrating with MS project
|
|
|
SM03
|
SM03062
|
JobNo
|
STRING
|
6
|
6
|
0
|
Job Number
|
|
|
SM03
|
SM03063
|
CheckListID
|
STRING
|
10
|
10
|
0
|
Check List ID
|
|
|
SM03
|
SM03064
|
FlagCreatedbyJobOrder
|
SWITCH
|
1
|
1
|
0
|
Was Created from Job
|
|
|
SM03
|
SM03065
|
UseCustomICURate
|
SWITCH
|
1
|
1
|
0
|
Use Custom Invoice Currency Rate
|
|
|
SM03
|
SM03066
|
CustomICURate
|
X_NUMERIC
|
15
|
23
|
8
|
Custom Invoice Currency Exchange Rate 1
|
|
|
SM03
|
SM03067
|
CustomICUExchRate2
|
X_NUMERIC
|
15
|
23
|
8
|
Custom Invoice Currency Exchange Rate 2
|
|
|
SM03
|
SM03068
|
CustomICUExchRateAlg
|
STRING
|
3
|
3
|
0
|
Custom Invoice Currency Exchange Rate Algorithm
|
|
|
SM03
|
SM03069
|
OperationTypeTime
|
VSTRING
|
10
|
10
|
0
|
Operation Type Time
|
|
|
SM03
|
SM03070
|
FinancialOperationCodeTime
|
VSTRING
|
10
|
10
|
0
|
Financial Operation CodeTime
|
|
|
SM03
|
SM03071
|
LineGUID
|
VSTRING
|
36
|
36
|
0
|
Line GUID
|
|
|
SM03
|
SM03072
|
LineGroup
|
VSTRING
|
6
|
6
|
0
|
Line Group
|
|
|
SM03
|
SM03073
|
JobID
|
INTEGER
|
9
|
0
|
0
|
JobID
|
|
|
SM03
|
SM03074
|
DelivNoteNo
|
VSTRING
|
20
|
20
|
0
|
Delivery Note Number
|
|
|
SM03
|
SM03075
|
DeliveryBlocked
|
INTEGER
|
1
|
0
|
0
|
Delivery blocked
|
|
|
SM03
|
SM03076
|
ApprovedCreditLimit
|
SWITCH
|
1
|
1
|
0
|
Approved Credit Limit
|
|
|
SM03
|
SM03077
|
ConfirmedArrivalDate
|
DATE
|
8
|
0
|
0
|
Confirmed Arrival Date Confirmed Arrival Date - 'Delivery Confirmation' functionality
|
|
|
SM03
|
SM03078
|
InvPlanLineNo
|
STRING
|
6
|
6
|
0
|
InvPlanLineNo
|
|
|
SM03
|
SM03079
|
TaxationReasonCode
|
STRING
|
3
|
3
|
0
|
Taxation Reason Code
|