/*
auto-generated by CLI:
af resources generate atbx_Accounting_Projects \
 --id dsProjects \
 --types \
 --max-records 100 \
 --sort-order Created:DESC,ProjectID:ASC,Domain:ASC \
 --where "Category=2" \
 --fields PrimKey,Created,Domain,ProjectID,ProjectName
*/
import { generateApiDataObject, SortOrder } from "@olenbetong/appframe-data";

export type ProjectsRecord = {
	PrimKey: string;
	Created: Date;
	Domain: string;
	ProjectID: string;
	ProjectName: string;
};

export const dsProjects = generateApiDataObject<ProjectsRecord>({
	resource: "atbx_Accounting_Projects",
	id: "dsProjects",
	allowUpdate: false,
	allowInsert: false,
	allowDelete: false,
	dynamicLoading: false,
	fields: [
		{
			name: "PrimKey",
			type: "string",
			nullable: false,
		},
		{
			name: "Created",
			type: "datetime",
			nullable: false,
		},
		{
			name: "Domain",
			type: "string",
			nullable: false,
		},
		{
			name: "ProjectID",
			type: "string",
			nullable: false,
		},
		{
			name: "ProjectName",
			type: "string",
			nullable: false,
		},
	],
	parameters: {
		maxRecords: 100,
		sortOrder: [{ Created: SortOrder.Desc }, { ProjectID: SortOrder.Asc }, { Domain: SortOrder.Asc }],
		whereClause: "Category=2",
	},
});