--- reportDefinition: ! description: "ActivityLedger Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "CSV" templateName: "ActivityLedger Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "date" label: "Date" ascending: false controlBreak: false pageBreak: false queryParameters: ! {} title: "ActivityLedger Report" querySpecification: specification: "type.oneOf (['PO'])" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.generalLedger.ActivityLedger" properties: ! - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: null entityName: "ActivityLedger" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: false function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "date" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 1 suppressRepeating: false permission: null - ! description: "PO #" type: "java.lang.Integer" propertyName: "poNumber" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: null columnTitle: "PO #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "poNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 2 suppressRepeating: false permission: null - ! description: "Primary Name" type: "java.lang.String" propertyName: "primaryName" propertyPath: "vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Primary Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "vendor.primaryName" dataSourcePath: path: ! [] currentPath: ! - "vendor" columnOrder: 3 suppressRepeating: false permission: null - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "account.code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Fund" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.fund" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 4 suppressRepeating: false permission: null - ! description: "SCC" type: "java.lang.String" propertyName: "scc" propertyPath: "account.code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.scc" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 5 suppressRepeating: false permission: null - ! description: "Type" type: "org.ssdt_ohio.usas.model.generalLedger.ActivityType" propertyName: "type" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 7 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false permission: null - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: null columnTitle: "Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false permission: null - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "account" entityName: "Account" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Full Account Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "account.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 8 suppressRepeating: false permission: null - ! description: "Item Description" type: "java.lang.String" propertyName: "itemDescription" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: "Item Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "itemDescription" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false permission: null - ! description: "Vendor #" type: "java.lang.Integer" propertyName: "number" propertyPath: "vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: null columnTitle: "Vendor #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "vendor.number" dataSourcePath: path: ! [] currentPath: ! - "vendor" columnOrder: 10 suppressRepeating: false permission: null - ! description: "PO Item #" type: "java.lang.Integer" propertyName: "poItemNumber" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "PO Item #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "poItemNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 11 suppressRepeating: false permission: null - ! description: "Invoiceable" type: "java.lang.Boolean" propertyName: "invoiceable" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Invoiceable" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 14 relativePropertyName: "invoiceable" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 12 suppressRepeating: false permission: null