TABLE DETAIL REFERENCE:
  
(US VERSION)
FIELD NAME TYPE LENGTH QRY MOD INS REQ INS VALIDATE REL
TxnID Varchar 36 True False False N/A String
TimeCreated Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
TimeModified Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
EditSequence Varchar 16 True False False N/A String
TxnNumber Integer 13 True False False N/A 11.0
TxnDate Date 10 True True True No CCCC-MM-DD
TxnDateMacro Varchar 23 True False False N/A All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
EntityRefListID Varchar 36 True False True Yes String
EntityRefFullName Varchar 209 True True True Yes String
CustomerRefListID Varchar 36 True False True No String
CustomerRefFullName Varchar 209 True True True No String
ItemServiceRefListID Varchar 36 True False True No String
ItemServiceRefFullName Varchar 159 True True True No String
Rate Decimal 14 False True False N/A 8.5
DurationMinutes Integer 8 True True True Yes PTnHnMnS
ClassRefListID Varchar 36 True False True No String
ClassRefFullName Varchar 159 True True True No String
PayrollItemWageRefListID Varchar 36 True False True No String
PayrollItemWageRefFullName Varchar 31 True True True No String
Notes Varchar 4095 True True True No String
BillableStatus Varchar 23 True True True No Billable NotBillable HasBeenBilled