Skip to content

ServiceSheets

Below are the schemas and relationships of ServiceSheets.


ColumnDescriptionType
IdInternal identifierString
TenantIdCustomer identifierString
UpdatedAtDate of the last record updateDatetime
SnapshotAtReference date of the transactionDatetime
SupplierIdSupplier identifierString
OrderIdUnique order identifierString
ServiceSheetIdPrimary key for the schema of ServiceSheetsString
DescriptionDescription of the service sheetString
PaymentConditionCodePayment condition codeString
CreatedDateCreation date of the service sheetDatetime
IssueDateIssue date of the service sheetDatetime
ApprovalDateApproval date of the service sheetDatetime
StatusStatus of the service sheetString
NoteNotes of the service sheetString
IssuedByUser who created the service sheetString
UserIdIdentifier of the user who created the service sheetString
QuantityQuantityDouble
MeasureUnit of measureString
CategoryNameCategory of the service sheetString
TotalTotal order valueDouble

ServiceSheets Schema Joins

The ServiceSheets schema has relationships with the following schemas:

SchemaRelationship ColumnDescription
OrdersOrderIdRelates the rows of ServiceSheets with the rows of Orders
OrderItemsOrderIdRelates the rows of ServiceSheets with the rows of OrderItems
OrderAddressesOrderIdRelates the rows of ServiceSheets with the rows of OrderAddresses
OrderBorgsOrderIdRelates the rows of ServiceSheets with the rows of OrderBorgs
OrderItemRequestsOrderIdRelates the rows of ServiceSheets with the rows of OrderItemRequests
OrderItemDeliveriesOrderIdRelates the rows of ServiceSheets with the rows of OrderItemDeliveries
OrderItemDatesOrderIdRelates the rows of ServiceSheets with the rows of OrderItemDates
OrderItemBorgsOrderIdRelates the rows of ServiceSheets with the rows of OrderItemBorgs
UsersUserIdRelates the rows of ServiceSheets with the rows of Users
ServiceSheetItemsServiceSheetIdRelates the rows of ServiceSheets with the rows of ServiceSheetItems
SuppliersSupplierIdRelates the rows of ServiceSheets with the rows of Suppliers
SupplierBorgsSupplierIdRelates the rows of ServiceSheets with the rows of SupplierBorgs
SupplierGroupsSupplierIdRelates the rows of ServiceSheets with the rows of SupplierGroups

ServiceSheetItems

ColumnDescriptionType
IdInternal identifierString
TenantIdCustomer identifierString
UpdatedAtDate of the last record updateDatetime
SnapshotAtReference date of the transactionDatetime
SupplierIdSupplier identifierString
DescriptionDescription of the item in the service sheetString
QuantityQuantity of the item in the service sheetDouble
MeasureUnit of measure of the item in the service sheetString
UnitPriceUnit price of the item in the service sheetDouble
ServiceSheetIdPrimary key for the schema of ServiceSheetsString
ServiceSheetItemIdIdentifier of the item in the service sheetString
NoteObservation of the item in the service sheetString
StartDateStart dateDatetime
EndDateEnd dateDatetime
TotalTotal value of the itemDouble
CodeItem code in the service sheetString

ServiceSheetItems Schema Joins

The ServiceSheetItems schema has relationships with the following schemas:

SchemaRelationship ColumnDescription
ServiceSheetsServiceSheetIdRelates the rows of ServiceSheetItems with the rows of ServiceSheets
SuppliersSupplierIdRelates the rows of ServiceSheetItems with the rows of Suppliers
SupplierBorgsSupplierIdRelates the rows of ServiceSheetItems with the rows of SupplierBorgs
SupplierGroupsSupplierIdRelates the rows of ServiceSheetItems with the rows of SupplierGroups