Records information of prepaid time ("Support Packs") sold the debtors. You can subtract the sum of SM_LabourLineDetail.Quantity rows that reference the pack id from the TotalHours figure in this table to arrive at how much prepaid time the debtor has remaining for a given support pack.
|
Name |
Type |
Link To/Supplied |
|
PackID |
Text |
|
|
PackName |
Text |
|
|
PackDesc |
Text |
|
|
DebtorID |
Text |
DB_Main1.DebtorID |
|
SalesInvNo |
Text |
SM_Main.InvoiceNo |
|
TotalHours |
Single |
|
|
ReorderLevel |
Single |
|
|
Rate |
Single |
|
|
SpecialUse |
Yes/No |
|
|
DateCreated |
Date/Time |
|
|
NotificationType |
Byte |
|
|
NotificationID |
Text |
|
|
LastSavedDateTime |
Date/Time |
|
|
LastSavedStaffID |
Text |
HR_Staff.StaffID |
|
GLDBLedgerID |
Text |
GL_Ledger.LedgerID |
|
GLCRLedgerID |
Text |
GL_Ledger.LedgerID |
|
Ratio |
Double |
|
|
Active |
Yes/No |
|
|
Cancelled |
Byte |
|
Copyright © 2012 Jiwa Financials. All rights reserved.