Construction Sheet

ConstructionStatus
IndexNo
Product/ Component/ ServiceName Internal
OPT
CalcFlags
ExpectedDate
StatusProject
Supplier
Text DescriptionsText
CustomerProduct/ Component/ Service Name
Description
InternalDescription
Note
IncludedAbr.
Support DocumentsDocs
Support DocumentationDG
Rev
QP
Rev
WI
Rev
FS
Rev
Room LayoutRoom
Single:Adults
ChildrenAge1
Age2
Age3
Double/ Twin:AdultDouble
Twin
ChildrenAge1
Age2
Age3
Triple:NoRoom
Adults1st/2nd
3rd
ChildrenAge1
Age2
Age3
Family:NoRoom
Adults
ChildrenAge1
Age2
Age3
Support:LeaderSingle
Double
GuideSingle
Double
DriverSingle
Double
Unit Buying RatesBuy
PAX SupplimentsPPS
Single
Triple
Child1
Child2
Child3
Support Suppliments:LeaderNo
Discount
GuideNo
Discount
DriverNo
Discount
RoomsSingle
Double
Tripple
Family
Leader
Guide
Driver
Unit AdjustmentsAdjust
Supplier Discount:%
Value
Royalty / Commision:Is Included
%
Value
Customer Discount:%
Value
Total
Pre Adjustment:Buy
%
Profit
Sell
PAXAdults
Children
Support
Post Adjustment:Buy
%
Profit
Sell
Sell
PAX Sharing:PAS
PCS
PAX SupplimentsPPS
Single
Triple
Child1
Child2
Child3
Support Suppliments:LeaderDiscount
GuideDiscount
DriverDiscount
RoomsSingle
Double
Tripple
Family
Leader
Guide
Driver
CurrencyCurr
BuyCurrency
ROE
Variance
SellCurrency
ROE
Variance
Rounding
Room AvailabilityAvail
Room AvailabilitySgl
Dbl
Trp
Fam
RestrictionsMin
Max
SupplierSupl
CalculationBase
DiscountCustomer
VoucherNumber
Acc codeSupplier
Suppl
Rates & TaxesType
Value
Vat
Incl.
VATInput
Purchase Order CommentLine 3
Line 4
Line 5
CustomerCust
InvoiceNumber
CustomerAcc Code
VatOutput
Profit
RoyaltyRoyal
RoyaltyBase
RoyaltySource
Acc Code
RoyaltyVAT
LoyaltyLoyal
Loyalty GroupName
GroupLoyalty
DatabaseDbase
SourceSheet
BuildLock
Int refBuilder
SupCode
Language
Royalty:Is Incl.
Base
Source
Code
Child Age Brackets:Age 1From
To
Age 2From
To
Age 3From
To
Serv BlockTo
From
Rate ValidTo
From
Database Rate:RateBase
BuyCur
No
DiscountsGuide
No
Leader
No
Driver
PPSharing
SingleSuppliment
Child RateAge 1
Database Rate:Age 2
Age 3
Triple3rd Adult
RoomsSingle
Double
Triple
Family
Guide
Database Rate:supl%
Value
roy%
Value
Profit%
Value
Child AgesChild
Selected Age From - Age To0-1
1-2
2-3
3-4
4-5
5-6
6-7
7-8
8-9
9-10
10-11
11-12
12-13
13-14
14-15
15-16
16-17
17-18
ReferenceRef
Codescs_id
cs_type
db_ref
b_arc
c_stat
s_stat
cr_type
i_abr
Task
Force
Markup TypesProfit
S. Discount
Royalty
C. Discount
End

Purchase Sheet

PurchaseStatus
VoucherNo
InternalProduct/ Component Name
DateIn
Out
StatusProject
Supplier
Text DescriptionsText
InternalNote
IncludedAbr.
Single:NoRoom
Adults
ChildrenAge1
Age2
Age3
Double/ Twin:NoRoom
Double
Twin
ChildrenAge1
Age2
Age3
Triple:NoRoom
Adults1st/2nd
3rd
ChildrenAge1
Age2
Age3
Family:NoRoom
Adults
ChildrenAge1
Age2
Age3
Support:LeaderSingle
Double
GuideSingle
Double
DriverSingle
Double
PAX SupplimentsPPS
Single
Triple
Child1
Child2
Child3
Support Suppliments:LeaderNo
Discount
GuideNo
Discount
DriverNo
Discount
RoomsSingle
Double
Tripple
Family
Leader
Guide
Driver
Supplier Discount:%
Value
Pre Adjustment:Buy
%
Profit
Sell
PAXAdults
Children
Support
Post Adjustment:Buy
%
Profit
Sell
BuyCurrency
ROE
Variance
Rounding
Room AvailabilitySgl
Dbl
Trp
Fam
Pax RestrictionsMin
Max
Code
Name
Contact
Tel
Tel
Cell
VATInput
Refference CodesIntern
Suppl
Builder
Purchase Order CommentLine 3
Line 4
Line 5
ServType
cs_id
OL TaskRef

Construction Sheet

ConstructionAssy
IndexNo
Assembly LevelL1
L2
L3
L4
L5
L6
L7
L8
L9
L10
IC
Assembly ComponentDescription
QtyBOM
ORD
ConstructionStatus
InternalProduct/ Component Name
OPT
ExpectedDate
StatusProject
Supplier
Text DescriptionsText
CustomerProduct/ Component Name
Description
InternalNote
IncludedAbr.
Part
PartNo
Unit ofMeas.
Mass[kg]
Vol[m^3]
MatlSpec
Support DocumentsDoc
DG
Rev
QP
Rev
WI
Rev
FS
Rev
Unit
Pre Adjustment:Buy
%
Profit
Sell
Supplier Discount:%
Value
Royalty / Commision:%
Value
Customer Discount:%
Value
Post Adjustment:Buy
%
Profit
Sell
Stock
QuantityUnit
Lead TimeDays
Stock LevelsMin
Max
Current
Qty RestrictionsMin
Max
QuantityTotal
Total
Pre Adjustment:Buy
%
Profit
Sell
Supplier:%
Value
Royalty / Commision:%
Value
Customer Discount:%
Value
Post Adjustment:Buy
%
Profit
Sell
CurrencyCurr
BuyCurrency
ROE
Variance
SellCurrency
ROE
Variance
Rounding
SupplierSupl
CustomerDiscount
RefNumber
Product CodesSupplier
Acc
VAT
Purchase Order CommentLine 3
Line 4
Line 5
CustomerCust
InvNumber
AccCode
VAT
RoyaltyRoyal
Is Incl.
CalculationBase
Source
Acc
VAT
LoyaltyLoyal
GroupCode
%
DatabaseDbase
SourceSheet
BuildLock
Product CodesInternal
Acc
Lang
Product GeometryUnit
Mass
Vol
Matl
RoyaltyIs. Incl
Base
Source
Code
Serv BlockTo
From
Rate ValidTo
From
BuyCurrency
Value
Supplier Discount%
Value
Royalty%
Value
Profit%
Value
SellValue
ReferenceRef
Refference Codescs_id
cs_tpe
db_ref
b_arc
c_stat
s_stat
cr_tpe
i_abr
Task
Force
Markup TypesProfit
S. Discount
Royalty
C. Discount
AssyParent
End

Purchase Sheet

PurchaseStatus
PurchaseNo
InternalProduct/ Component Name
ExpectedDate
StatusProject
Supplier
Text DescriptionsText
InternalNote
IncludedAbr.
Product-Item-PartPart
PartNo
Unit ofMeas.
Mass[kg]
Vol[m^3]
MatlSpec
Unit PreUnit
Pre Adjustment:Buy
%
Profit
Sell
Supplier Discount:%
Value
Post Adjustment:Buy
%
Profit
Sell
Quantities & StockQty
QuantityUnit
Lead TimeDays
Stock LevelsMin
Max
Current
Qty RestrictionsMin
Max
QuantityTotal
Total PreTotal
Pre Adjustment:Buy
%
Profit
Sell
Supplier Discount:%
Value
Post Adjustment:Buy
%
Profit
Sell
Currency - ActiveCurr
BuyCurrency
ROE
Variance
Rounding
SupplierSupl
AccCode
PartNo
NameCompany
Contact
Tel1
Tel2
Cell
VATClass
PurchaseCmnt
Purchase Order CommentLine 3
Line 4
Line 5
RefferenceRef
ServType
cs_id
BuilderRef No
OL TaskRef
End

Rates_1 Sheet

Rates_1Text
IndexNo
Item NameInternal
External (Customer)
DescriptionInternal
Customer (External)
NoteInternal
IncludedAbr.
Support DocumentationDoc
Document Type 1Name
Rev No.
Description
Document Type 2Name
Rev No.
Description
Document Type 3Name
Rev No.
Description
Document Type 4Name
Rev No.
Description
Product CodesCode
Product CodesInternal
Supplier
Accounts
Builder
LanguageCode
Royalty & CommissionRoyal
IsIncluded
CalculationBase
CodeSource
Accounts
AvailabilityAvail
Room TypeSingle
Double
Triple
Family
Pax & ChildrenPax
Children:Age Group 1From
To
Age Group 2From
To
Age Group 3From
To
Pax:Rate RangeMin
Max
Settings & ParametersSet
SourceSheet
Core
ServiceType
BuildLock
PerGroup
ActivityDuration
BuyCurrency
Taxes & ChargesType
Value
Vat
Incl.
VatInput
Output
Profit
Rate Period 1R1
Blocked:DateFrom
To
Day of WeekFrom
To
Reason
Valid:DateFrom
To
Day of WeekFrom
To
Supplier Discount%
Value
Royalty%
Value
Profit%
Value
Base
Supplements:Discounts: Support StaffNo
Leader
No
Guide
No
Driver
Per PersonSharing
SingleSupplement
Child RateAge 1
Age 2
Age 3
3rd Adult(Triple)
Room RatesSingle
Double
Triple
Family
Guide
End

Rates_1 Sheet

Rates_1Text
IndexNo
Item NameInternal
Customer
DescriptionInternal
Customer (External)
NoteInternal
IncludedAbr.
Support DocumentationDoc
Document Type 1Name
Rev No.
Description
Document Type 2Name
Rev No.
Description
Document Type 3Name
Rev No.
Description
Document Type 4Name
Rev No.
Description
Product CodesCode
Product CodesPart No
Supplier
Accounts
Builder
LanguageCode
Royalty & CommissionRoyal
IsIncluded
CalculationBase
CodeSource
Accounts
SettingsSet
SourceSheet
Core
ServiceType
BuildLock
BuyCurrency
VatInput
Output
Profit
ProductPart
Unit ofMeasure
Mass[kg]
Volume[m^3]
MaterialSpecification
Stock
Lead TimeDays
Stock LevelsMin
Max
Current
Qty RestrictionsMin
Max
Rate Period 1R1
Rates BlockedFrom
To
Reason
Rates ValidFrom
To
Buy
Supplier Discount%
Value
Royalty%
Value
Profit%
Value
Sell
End

Remote Sheet

RemoteGet
IndexNo
Local SourceName
Released
Parent
Path
Put RemotePut
Skip = SDelete=D
Cloud DestinationPath
Date
End

Contact Information Sheet

Contact InformationName
CompanyCode
Type
Name
ContactName
Tel 1
Tel 2
A/Hours
Fax
CompanyCo
ExternalAccnt Code
BlockUse
LegalReg. No
Vat. No
Vat Class
On-linewww
Web Site
E-Mail:Address
Reminders (Days)Post Requested
Pre Deadline
Bank
Description
Name
Branch Name
Account No
Branch No
Swift Code
PostalPost
Address 1
Address 2
Address 3
Code
Country
PhysicalPhys
Address 1
Address 2
Address 3
Code
Country
GPS CoordinatesLatititude
Longitude
Terms and ConditionsT&C
Documentation:Quote
Invoice
Purchase
Logo File
PaymentPay
Quote Validity(Days)
PaymentTerms
InvoiceDeadline
Discounts:Period 1%
Condition
Period 2%
Condition
Period 3%
Condition
Period 4%
Condition
Period 5%
Condition
MarkupM-up
Service Type:TBA%
TBA%
TBA%
TBA%
TBA%
TBA%
ReferenceRef
CountryPostal
Physical
Export
End

Deliverable Sheet

DeliverableTrans
BuildNo
TransactionType
Int Ref
Acc Ref
Crs Ref
Btch
Of
Date
Status
By
AccountAccnt
Product
Code
Customer / SupplierTo
Code
Name
Destination
OrderReference No
Value
%
RequestedInvoice No
EstimatedDate
Description
CommisionRoyal
Royalty:To
Value
%
Value
Exported CurrencyCurr
Roe
Var
Rnd
Value
Native CurrencyExcl. Vat
Vat - Rgnl
Vat - Natl
Incl. Vat
Z Vat
E Vat
Deliverable DatesDates
Quoted
Expected
Actual
ReferenceRef
StatusID
Export
End

Language Sheet

LanguageL1
IndexNo
Type
InternalName
Customer (External)Name
Description 1
Description 2
Description 3
Language 2L2
Customer (External)Name
Description 1
Description 2
Description 3
Language 3L3
Customer (External)Name
Description 1
Description 2
Description 3
Language 4L4
Customer (External)Name
Description 1
Description 2
Description 3
Language 5L5
Customer (External)Name
Description 1
Description 2
Description 3
End

Transaction Sheet

TransactionTrans
BuildNo
TransactionType
Int Ref
Acc Ref
Crs Ref
Btch
Of
Date
Status
By
AccountAccnt
Product
Code
Customer / SupplierTo
Code
Name
Destination
OrderReference No
Value
%
RequestedInvoice No
EstimatedDate
Description
CommisionRoyal
Royalty:To
Value
%
Value
Exported CurrencyCurr
Roe
Var
Rnd
Value
Native CurrencyExcl Vat
Vat - Reg.
Vat - Nat.
Incl. Vat
Z Vat
E Vat
Gross
Sell
ComparisonsVs.
Credit NoteValue
RequestedValue
Expected vs Requested:Margin:Balance
Status
Bank TransactionActual
Adjust
Expected vs Actual:Margin:Balance
Status
ReferenceRef
StatusID
Export
End

Tracking Sheet

TrackingBuild
BuildNo
Type
Phase
Department
Status
Owner
CustomerDebtr
Name
Country
Code
Reference
Destination
Country
Quote
DateLast
Expected
DeliverablesDelivr
Quantity
BatchesTotal
Next
Date
Description
Cash FlowCash
NextExpense
Date
Income
Date
ContractCntrct
ProductType
OrderDate
No
Project DatesStart
End
Days
Home (Bank)Code
ContractCurr
ROE
Expense
Profit
Income
NativeExpense
Profit
%
Income
Description
CommissionRoyal
Company Name
Acc. Code
Relation
Country
Contract Curr
ROE
%
Value
Native
Build ConstructionCnstr
Expense
Profit%
Value
Income
ExpectedInvce
Expected:ExpenseExcl. VAT
VAT
Incl. VAT
Profit%
Value
Requested:ExpenseExcl. VAT
VAT
Incl. VAT
Profit%
Value
Expected:IncomeExcluding
VAT
Including
Bank
Actual:Expense
Profit%
Value
Income
Filter
CustomFilter 1
Filter 2
Filter 3
EditorUser
LoggedBy
Date
CreatedBy
Date
Last EditorBy
Date
ReferenceRef
Comment
Codes:CompanyPhase
Deptm
Status
CountryCust.
Dest.
Royalty
FiltersF1
F2
F2
SaleCde
Markup TypesProfit
Royalty
BuildName
Language
Type
Export
End

Eisenhower Matrix Sheet

Eisenhower Matrix
UrgentTask timing is critical.Yes.
NotTask timing is not critical.No.
ImportantTask action is a priority.Yes.
NotTask action is not a priority.No.
End

Task Track Sheet

Task TrackTask
IndexTask number.Unique Identifier.
Actionable DeliverableTaskTask name.Unique Description.
DescriptionTask description.
Origin"Task Reason: Breakdown, Error, Development, Request."
Status"Awaiting Action, Work in Progress, Complete, Test, Release, Deliver, Cancel, Delete."
CustomerWho requested task.Name.
OwnerWho is responsible for executing.Name.
LeaderWho is controlling/leading.Name.
Date
Time DeliverableAssignedDate assigned to owner by leader.
RequestedClient requested completed/implementation date.
AgreedCustomer/Supplier negotiated completion date.
ExpectedRealistic expected completion date including delays.
ActualTask completed and/or signed off.
Priority MatrixMatrixEisenhower Urgent/Important Array
TaskRankToDo order per priority subset.
Domain"Management domain: Plan, Organise,Lead, Control."
UrgentTask timing is critical.Yes/No.
ImportantTask action is a priority.Yes/No.
ProjectPrjct
ParentNoParent project number.Unique Identifier.
NameParent project name.Unique Description.
AreaOrganisation department name.
Cmnt
CommentAddiitonal Information.
EditorUser
LoggedByAdministrative task creator.
DateDate created.
Last EditorByAdministrative last updated.
DateDate last edited.
ReferenceRef
CodesProjProject Code.
DeptDepartment Code.
CustCustomer code.
OwnOwner code.
LeadLeader code.
ExportTask sent to community.Builder = Exported.
End

ToDo Sheet

ToDo
TaskTask IDTask number.Unique Identifier.
RankToDo order per priority subset.Eisenhower Matrix.
ProjectParent project number.Unique Identifier.
AreaOrganisation department name.
Status"Awaiting Action, Work in Progress, Complete, Test, Release, Deliver, Cancel, Delete."
Origin"Task Reason: Breakdown, Error, Development, Request."
DeliverableTaskTask Name.Unique Identifier.
DescriptionTask Description.
CommentAdditional Information.
CustomerRequestedDate requested.
AgreedCustomer/Supplier negotiated completion date.
OwnerLoggedDate logged.
AssignedDate assigned to owner by leader.
ExpectedRealistic expected completion date including delays.
End




What is your plan?