|
1
|
PR03
|
PR03001
|
ProjectNo
|
VSTRING
|
12
|
12
|
0
|
Project Number
|
|
2
|
PR03
|
PR03002
|
SubProject
|
VSTRING
|
6
|
6
|
0
|
Sub-Project
|
|
3
|
PR03
|
PR03003
|
ActivityLine
|
VSTRING
|
6
|
6
|
0
|
Activity Line Number
|
|
4
|
PR03
|
PR03004
|
ActStrucLine
|
VSTRING
|
6
|
6
|
0
|
Activity Sub-line Number
|
|
5
|
PR03
|
PR03005
|
TransactDate
|
DATE
|
8
|
0
|
0
|
Transaction Date
|
|
6
|
PR03
|
PR03006
|
ResourceCode
|
VSTRING
|
10
|
10
|
0
|
Resource Code
|
|
7
|
PR03
|
PR03007
|
TransactLine
|
VSTRING
|
6
|
6
|
0
|
Transaction Line Number
|
|
|
PR03
|
PR03008
|
HoursQty
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity/Hours Reported
|
|
|
PR03
|
PR03009
|
HoursQtyInv
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity/Hours to Invoice
|
|
|
PR03
|
PR03010
|
Price
|
MONEY
|
20
|
28
|
8
|
Unit Price (Project Currency)
|
|
|
PR03
|
PR03011
|
PriceToInvoi
|
MONEY
|
20
|
28
|
8
|
Unit Price to Invoice (Project Currency)
|
|
|
PR03
|
PR03012
|
CostLCU
|
MONEY
|
20
|
28
|
8
|
Unit Cost (Local Currency)
|
|
|
PR03
|
PR03013
|
Description
|
VSTRING
|
35
|
35
|
0
|
Text
|
|
|
PR03
|
PR03014
|
ChargeCode
|
VSTRING
|
1
|
1
|
0
|
Charge Activity 0 - Activity shall not be charged to customer but cost allocated to the project
1 - Activity will included when invoicing the project
|
|
|
PR03
|
PR03015
|
ActualInvoicedCostLCU
|
MONEY
|
20
|
28
|
8
|
Actual Invoiced Cost LCU
|
|
|
PR03
|
PR03016
|
ActInvAmount
|
MONEY
|
20
|
28
|
8
|
Actual Invoiced Amount (Project Currency)
|
|
|
PR03
|
PR03017
|
InvoiceFlag
|
VSTRING
|
1
|
1
|
0
|
Has Been Invoiced
|
|
|
PR03
|
PR03018
|
ActInvPrice
|
MONEY
|
20
|
28
|
8
|
Actual Invoiced Amount (Local Currency)
|
|
|
PR03
|
PR03019
|
WIPTransLCU
|
MONEY
|
20
|
28
|
8
|
WIP Transaction Amount (Local Currency)
|
|
|
PR03
|
PR03020
|
AccounString
|
ACCSTR
|
120
|
120
|
0
|
Accounting String
|
|
|
PR03
|
PR03021
|
ActuaInvHour
|
X_NUMERIC
|
12
|
20
|
8
|
Actual Invoiced Quantity/Hours
|
|
|
PR03
|
PR03022
|
Spare
|
VSTRING
|
20
|
20
|
0
|
Spare
|
|
|
PR03
|
PR03023
|
Spare
|
VSTRING
|
20
|
20
|
0
|
(obsolete)
|
|
|
PR03
|
PR03024
|
ActivityType
|
VSTRING
|
1
|
1
|
0
|
Activity Type 0 - Cost Activity
1 - Time Activity
2 - Material Activity (Sales Order or Purchase Order)
3 - Milestone
4 - Text Annotation
5 - Linked Sales Order
6 - Linked Purchase Order
7 - Linked Service Order
8 - Linked Contract
9 - Linked Work Order
|
|
|
PR03
|
PR03025
|
VATCode
|
VSTRING
|
6
|
6
|
0
|
VAT Code
|
|
|
PR03
|
PR03026
|
Markup
|
X_NUMERIC
|
6
|
14
|
8
|
Mark-up %
|
|
|
PR03
|
PR03027
|
SupplCode
|
VSTRING
|
10
|
10
|
0
|
Supplier Code
|
|
|
PR03
|
PR03028
|
InvLinLayout
|
VSTRING
|
1
|
1
|
0
|
Invoice Line Layout 1 - Invoice lines include quantity, unit price and total amount.
2 - Invoice lines include only the totals.
(The actual layout is defined in the ddf files for invoices and invoice proposal)
|
|
|
PR03
|
PR03029
|
LinkActiLine
|
VSTRING
|
6
|
6
|
0
|
Linked Activity Line Number
|
|
|
PR03
|
PR03030
|
LinActStrLin
|
VSTRING
|
6
|
6
|
0
|
Linked Activity Sub-line Number
|
|
|
PR03
|
PR03031
|
VoucherNo
|
VSTRING
|
9
|
9
|
0
|
General Ledger Transaction Number This information is updated for transaction updated from general ledger and manual general ledger transactions entered with project activity relation.
|
|
|
PR03
|
PR03032
|
CurrencyCode
|
VSTRING
|
2
|
2
|
0
|
Currency Code
|
|
|
PR03
|
PR03033
|
WIPBEDate
|
DATE
|
8
|
0
|
0
|
WIP Book-Entry Date
|
|
|
PR03
|
PR03034
|
EnterByUser
|
VSTRING
|
10
|
10
|
0
|
Created By
|
|
|
PR03
|
PR03035
|
ConfirByUser
|
VSTRING
|
10
|
10
|
0
|
Confirmed By
|
|
|
PR03
|
PR03036
|
DateType012
|
VSTRING
|
1
|
1
|
0
|
Date Type Time reported as per:
0 - Date
1 - Week
2 - Month
|
|
|
PR03
|
PR03037
|
WIPTransacNo
|
VSTRING
|
9
|
9
|
0
|
WIP Transaction Number
|
|
|
PR03
|
PR03038
|
WIPAmtMarkup
|
MONEY
|
20
|
28
|
8
|
WIP Amount Mark-up (Local Currency)
|
|
|
PR03
|
PR03039
|
WIPStatus
|
VSTRING
|
1
|
1
|
0
|
WIP Status 0 - No cost/wip has been booked for the transaction line
1 - Transaction cost has been booked directly to P&L as cost (wip/cost method 1)
2 - Transaction cost has been booked to WIP account
3 - Booked wip amount has been booked as cost (reversed)
|
|
|
PR03
|
PR03040
|
PercentCompl
|
X_NUMERIC
|
6
|
14
|
8
|
Estimated % to Completion Indicates how much is left to complete the activity. This estimate is entered by the user when reporting time.
|
|
|
PR03
|
PR03041
|
IntDebUpdate
|
VSTRING
|
1
|
1
|
0
|
Internal Debiting Updated
|
|
|
PR03
|
PR03042
|
WIPReturnDate
|
DATE
|
8
|
0
|
0
|
WIP Return Date
|
|
|
PR03
|
PR03043
|
WIPTreturnTranNo
|
STRING
|
9
|
9
|
0
|
WIP Return Transaction Number
|
|
|
PR03
|
PR03044
|
ReservedForCredit
|
STRING
|
8
|
8
|
0
|
Reserved For Credit
|
|
|
PR03
|
PR03045
|
CreatedForDistributeRevenue
|
STRING
|
1
|
1
|
0
|
Created For Distribute Revenue
|
|
|
PR03
|
PR03046
|
SpareFlag2
|
STRING
|
1
|
1
|
0
|
(obsolete)
|
|
|
PR03
|
PR03047
|
InvoiceNoCustomer
|
STRING
|
10
|
10
|
0
|
Customer Code Invoice
|
|
|
PR03
|
PR03048
|
GLTransactionLineID
|
STRING
|
9
|
9
|
0
|
General Ledger Transaction Line Reference
|
|
|
PR03
|
PR03049
|
GLTransactionYear
|
STRING
|
4
|
4
|
0
|
General Ledger Financial Year
|
|
|
PR03
|
PR03050
|
IncludeInRevenueRcgn
|
STRING
|
1
|
1
|
0
|
Included into Revenue Recognition
|
|
|
PR03
|
PR03051
|
CloseDate
|
DATE
|
8
|
0
|
0
|
Close Date
|
|
|
PR03
|
PR03052
|
OperationType
|
VSTRING
|
10
|
10
|
0
|
Operation Type
|
|
|
PR03
|
PR03053
|
FinancialOperationCode
|
VSTRING
|
10
|
10
|
0
|
Financial Operation Code
|
|
|
PR03
|
PR03054
|
NCMCode
|
VSTRING
|
25
|
25
|
0
|
NCM Code
|
|
|
PR03
|
PR03055
|
ProductTaxType
|
VSTRING
|
10
|
10
|
0
|
Product Tax Type
|
|
|
PR03
|
PR03056
|
TaxationReasonCode
|
STRING
|
3
|
3
|
0
|
Taxation Reason Code
|