TABLE DETAIL REFERENCE: BudgetDetailLine

(Online VERSION)

>>

<<

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
ListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EditSequence	12	VARCHAR	10	True	False	False	False	%s
Name	12	VARCHAR	1000	True	False	False	False	%s
StartDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EndDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
BudgetType	12	VARCHAR	13	True	False	False	False	ProfitAndLoss BalanceSheet
BudgetEntryType	12	VARCHAR	13	True	False	False	False	Monthly Quarterly Annually
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
BudgetDetailListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailBudgetDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
BudgetDetailAmount	3	DECIMAL	15	True	False	False	False	%11.2f
BudgetDetailAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailAccountRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
BudgetDetailCustomerRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailCustomerRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
BudgetDetailClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailClassRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
BudgetDetailDepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailDepartmentRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey