|
1
|
SM05
|
SM05001
|
ServiceOrdNo
|
STRING
|
10
|
10
|
0
|
Service Order
|
|
2
|
SM05
|
SM05002
|
ItemNo
|
STRING
|
4
|
4
|
0
|
Order Line Number
|
|
|
SM05
|
SM05003
|
LineType
|
STRING
|
1
|
1
|
0
|
Line Type 0 - Normal activity line
5 - Linked picture
9 - Text line
|
|
|
SM05
|
SM05004
|
CostCode
|
STRING
|
8
|
8
|
0
|
Cost Activity Code
|
|
|
SM05
|
SM05005
|
Description
|
VSTRING
|
35
|
35
|
0
|
Description
|
|
|
SM05
|
SM05006
|
SPARE
|
MONEY
|
20
|
28
|
8
|
SPARE
|
|
|
SM05
|
SM05007
|
SPARE
|
MONEY
|
20
|
28
|
8
|
SPARE
|
|
|
SM05
|
SM05008
|
BudgCostLCU
|
MONEY
|
20
|
28
|
8
|
Unit Cost Planned (Local Currency)
|
|
|
SM05
|
SM05009
|
ActuCostLCU
|
MONEY
|
20
|
28
|
8
|
Unit Cost Actual (Local Currency)
|
|
|
SM05
|
SM05010
|
PropInvAmntOcu
|
MONEY
|
20
|
28
|
8
|
Unit Price Proposed for Invoice (Invoice Currency)
|
|
|
SM05
|
SM05011
|
ActuInvAmntOcu
|
MONEY
|
20
|
28
|
8
|
Unit Price Actual Invoiced (Invoice Currency)
|
|
|
SM05
|
SM05012
|
VATCode1
|
STRING
|
6
|
6
|
0
|
VAT Code 1
|
|
|
SM05
|
SM05013
|
AccCode
|
STRING
|
2
|
2
|
0
|
Accounting Code
|
|
|
SM05
|
SM05014
|
Spare
|
STRING
|
6
|
6
|
0
|
(obsolete)
|
|
|
SM05
|
SM05015
|
Spare
|
STRING
|
6
|
6
|
0
|
(obsolete)
|
|
|
SM05
|
SM05016
|
Spare
|
STRING
|
6
|
6
|
0
|
(obsolete)
|
|
|
SM05
|
SM05017
|
InclFixedPr
|
SWITCH
|
1
|
1
|
0
|
Included in Fixed Price
|
|
|
SM05
|
SM05018
|
CustCodeInv
|
STRING
|
10
|
10
|
0
|
Customer Code Invoice
|
|
|
SM05
|
SM05019
|
InvoiceDate
|
DATE
|
8
|
0
|
0
|
Invoice Date
|
|
|
SM05
|
SM05020
|
InvoiceNo
|
STRING
|
15
|
15
|
0
|
Invoice Number
|
|
|
SM05
|
SM05021
|
PlannedPriceOCU
|
MONEY
|
20
|
28
|
8
|
Unit Price Planned (Order Currency)
|
|
|
SM05
|
SM05022
|
TransactDate
|
DATE
|
8
|
0
|
0
|
Transaction Date
|
|
|
SM05
|
SM05023
|
PlannedQty
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Planned
|
|
|
SM05
|
SM05024
|
ActualQty
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Actual
|
|
|
SM05
|
SM05025
|
DiscountCosts
|
X_NUMERIC
|
7
|
15
|
8
|
Discount %
|
|
|
SM05
|
SM05026
|
PricelistNo
|
STRING
|
2
|
2
|
0
|
Price List
|
|
|
SM05
|
SM05027
|
ChangeInvCustomer
|
SWITCH
|
1
|
1
|
0
|
Calculate Price Option used internally to indicate if price needs to be recalculated on the cost line.
1 - The price on the cost line has not been recalculated after change of customer
2 - The price on the cost line has already been calculated for the customer on the order line
|
|
|
SM05
|
SM05028
|
FldEngineer
|
STRING
|
10
|
10
|
0
|
Resource Code Engineer
|
|
|
SM05
|
SM05029
|
InvQtyNew
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity to Invoice
|
|
|
SM05
|
SM05030
|
InvUpdStatus
|
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.
|
|
|
SM05
|
SM05031
|
InvCurrencyCode
|
STRING
|
2
|
2
|
0
|
Currency Code Invoice
|
|
|
SM05
|
SM05032
|
AccString
|
ACCSTR
|
120
|
120
|
0
|
Accounting String
|
|
|
SM05
|
SM05033
|
VATCode2
|
STRING
|
6
|
6
|
0
|
VAT Code 2
|
|
|
SM05
|
SM05034
|
CostDate
|
DATE
|
8
|
0
|
0
|
Cost Date
|
|
|
SM05
|
SM05035
|
CostTime
|
X_NUMERIC
|
5
|
13
|
8
|
Cost Time
|
|
|
SM05
|
SM05036
|
IncludedInCurrencyClause
|
INTEGER
|
1
|
0
|
0
|
Included in Currency Clause
|
|
|
SM05
|
SM05037
|
OrderCurrencyCode
|
STRING
|
2
|
2
|
0
|
Currency Code Order
|
|
|
SM05
|
SM05038
|
CurrExchRate
|
X_NUMERIC
|
20
|
28
|
8
|
Currency Exchange Rate
|
|
|
SM05
|
SM05039
|
SPARE
|
MONEY
|
20
|
28
|
8
|
SPARE
|
|
|
SM05
|
SM05040
|
ActualPriceOCU
|
MONEY
|
20
|
28
|
8
|
Unit Price Actual (Order Currency)
|
|
|
SM05
|
SM05041
|
SPARE
|
MONEY
|
20
|
28
|
8
|
SPARE
|
|
|
SM05
|
SM05042
|
PropInvAmountICU
|
MONEY
|
20
|
28
|
8
|
Unit Price Proposed for Invoice (Invoice Currency)
|
|
|
SM05
|
SM05043
|
PropInvAmountLCU
|
MONEY
|
20
|
28
|
8
|
Unit Price Proposed for Invoice (Local Currency)
|
|
|
SM05
|
SM05044
|
ActlInvAmountICU
|
MONEY
|
20
|
28
|
8
|
Unit Price Actual Invoiced (Invoice Currency)
|
|
|
SM05
|
SM05045
|
ActInvAmountLCU
|
MONEY
|
20
|
28
|
8
|
Unit Price Actual Invoiced (Local Currency)
|
|
|
SM05
|
SM05046
|
StatusSwitch0
|
SWITCH
|
1
|
1
|
0
|
Line Status 1
|
|
|
SM05
|
SM05047
|
StatusSwitch1
|
SWITCH
|
1
|
1
|
0
|
Line Status 2
|
|
|
SM05
|
SM05048
|
StatusSwitch2
|
SWITCH
|
1
|
1
|
0
|
Line Status 3
|
|
|
SM05
|
SM05049
|
StatusSwitch3
|
SWITCH
|
1
|
1
|
0
|
Line Status 4
|
|
|
SM05
|
SM05050
|
StatusSwitch4
|
SWITCH
|
1
|
1
|
0
|
Line Status 5
|
|
|
SM05
|
SM05051
|
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
|
|
|
SM05
|
SM05052
|
PlanSpendDate
|
DATE
|
8
|
0
|
0
|
Cost Date Planned
|
|
|
SM05
|
SM05053
|
ActualSpendDate
|
DATE
|
8
|
0
|
0
|
Cost Date Actual
|
|
|
SM05
|
SM05054
|
Predecessors
|
STRING
|
150
|
150
|
0
|
Predecessors MS Project Reserved for use when integrating with MS project
|
|
|
SM05
|
SM05055
|
ReportedCurrencyCode
|
STRING
|
2
|
2
|
0
|
Currency Code Reporting
|
|
|
SM05
|
SM05056
|
ReportedAmountRCU
|
MONEY
|
20
|
28
|
8
|
Reported Amount (Reporting Currency)
|
|
|
SM05
|
SM05057
|
LedgerInvoiceNumber
|
STRING
|
25
|
25
|
0
|
Cost Invoice Number
|
|
|
SM05
|
SM05058
|
SupplierCode
|
STRING
|
10
|
10
|
0
|
Cost Supplier Code
|
|
|
SM05
|
SM05059
|
GLTransNum
|
STRING
|
9
|
9
|
0
|
General Ledger Transaction Number
|
|
|
SM05
|
SM05060
|
JobNo
|
STRING
|
6
|
6
|
0
|
Job Number
|
|
|
SM05
|
SM05061
|
CheckLineID
|
STRING
|
10
|
10
|
0
|
Check List ID
|
|
|
SM05
|
SM05062
|
FlagCreatedbyJobOrder
|
SWITCH
|
1
|
1
|
0
|
Was Created from Job
|
|
|
SM05
|
SM05063
|
ExpenceAmount
|
X_NUMERIC
|
13
|
21
|
8
|
Expense Amount (Expense Currency)
|
|
|
SM05
|
SM05064
|
ExpenceCurrency
|
STRING
|
2
|
2
|
0
|
Currency Code Expense
|
|
|
SM05
|
SM05065
|
ExpenceDate
|
DATE
|
8
|
0
|
0
|
Expense Date
|
|
|
SM05
|
SM05066
|
CustomICURate
|
SWITCH
|
1
|
1
|
0
|
Use Custom Invoice Currency Rate
|
|
|
SM05
|
SM05067
|
CustomICUExchRate1
|
X_NUMERIC
|
15
|
23
|
8
|
Custom Invoice Currency Exchange Rate 1
|
|
|
SM05
|
SM05068
|
CustomICUExchRate2
|
X_NUMERIC
|
15
|
23
|
8
|
Custom Invoice Currency Exchange Rate 2
|
|
|
SM05
|
SM05069
|
CustomICUExchRateAlg
|
STRING
|
3
|
3
|
0
|
Custom Invoice Currency Exchange Rate Algorithm
|
|
|
SM05
|
SM05070
|
GLUpdFlag
|
SWITCH
|
1
|
1
|
0
|
GL Update Flag
|
|
|
SM05
|
SM05071
|
GLTransTxt
|
VSTRING
|
25
|
25
|
0
|
GL Transaction Text
|
|
|
SM05
|
SM05072
|
OperationTypeCost
|
VSTRING
|
10
|
10
|
0
|
Operation Type Cost
|
|
|
SM05
|
SM05073
|
FinancialOperationCodeCost
|
VSTRING
|
10
|
10
|
0
|
Financial Operation Code Cost
|
|
|
SM05
|
SM05074
|
LineGroup
|
VSTRING
|
6
|
6
|
0
|
Line Group
|
|
|
SM05
|
SM05075
|
JobID
|
INTEGER
|
9
|
0
|
0
|
Job ID
|
|
|
SM05
|
SM05076
|
DelivNoteNo
|
VSTRING
|
20
|
20
|
0
|
Delivery Note Number
|
|
|
SM05
|
SM05077
|
DeliveryBlocked
|
INTEGER
|
1
|
0
|
0
|
Delivery blocked
|
|
|
SM05
|
SM05078
|
LineGUID
|
VSTRING
|
36
|
36
|
0
|
Line GUID
|
|
|
SM05
|
SM05079
|
ApprovedCreditLimit
|
SWITCH
|
1
|
1
|
0
|
Approved Credit Limit
|
|
|
SM05
|
SM05080
|
ConfirmedArrivalDate
|
DATE
|
8
|
0
|
0
|
Confirmed Arrival Date Confirmed Arrival Date - 'Delivery Confirmation' functionality
|
|
|
SM05
|
SM05081
|
InvPlanLineNo
|
STRING
|
6
|
6
|
0
|
InvPlanLineNo
|
|
|
SM05
|
SM05082
|
PlanedQuantity1
|
X_NUMERIC
|
12
|
20
|
8
|
Planed Quantity 1
|
|
|
SM05
|
SM05083
|
ActualQuantity1
|
X_NUMERIC
|
12
|
20
|
8
|
Actual Quantity 1
|
|
|
SM05
|
SM05084
|
PlanedQuantity2
|
X_NUMERIC
|
12
|
20
|
8
|
Planed Quantity 2
|
|
|
SM05
|
SM05085
|
ActualQuantity2
|
X_NUMERIC
|
12
|
20
|
8
|
Actual Quantity 2
|
|
|
SM05
|
SM05086
|
PlanedQuantity3
|
X_NUMERIC
|
12
|
20
|
8
|
Planed Quantity 3
|
|
|
SM05
|
SM05087
|
ActualQuantity3
|
X_NUMERIC
|
12
|
20
|
8
|
Actual Quantity 3
|
|
|
SM05
|
SM05088
|
TaxationReasonCode
|
STRING
|
3
|
3
|
0
|
Taxation Reason Code
|