JobAlias (JOBA)

Keys

Name Attributes Fields JOBA:GuidKey Case +JOBA:Guid JOBA:OpenKey Dup +JOBA:OpenDate ,+JOBA:Job JOBA:FinishedKey Dup +JOBA:FinishedDate ,+JOBA:Job JOBA:CloseKey Dup +JOBA:ClosedDate ,+JOBA:Job JOBA:Key Primary +JOBA:Job JOBA:CustomerKey Dup +JOBA:Customer ,+JOBA:OpenDate JOBA:DescKey Dup +JOBA:Description

Fields

Name Type Picture Description JOBA:Guid STRING @s16 Internal System Identifier JOBA:Job STRING @s10 JOBA:Description STRING @s30 JOBA:OpenDate LONG @d6 JOBA:FinishedDate LONG @d6 JOBA:ClosedDate LONG @d6 JOBA:Status BYTE @n3 Open=0, Finished=1, Closed=2 JOBA:Quantity DECIMAL @n13.3 JOBA:Unit STRING @s10 JOBA:Comment MEMO 1024 JOBA:TotalCost DECIMAL @n12.2 JOBA:Customer LONG @n-14

RelationShips

Table Type This Key Foreign Key Allocation 1:MANY JOBA:Key ALL:ToKey