--- reportDefinition: ! description: "RequisitionCharge Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Requisition Detail Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "req.number" label: "Requisition #" ascending: true controlBreak: true pageBreak: false queryParameters: ! {} title: "Requisition Detail Report" querySpecification: specification: "req.converted.eq 'f'\nreq.workflowApprovalStatus.eq 'Approved'\n\ req.createdUser.oneOf ([param(\"createdUser\",'',\"Created User(s)\")])\nreq.date.between\ \ param(\"startDate\",\"\",\"Transaction Start Date\"), param(\"endDate\",\"\ \", \"Transaction End Date\")\nreq.createdDate.between param(\"systemStartDate\"\ ,\"\",\"Created Start Date\"), param(\"systemEndDate\",\"\",\"Created End Date\"\ )\nreq.number.between param(\"startReq\",\"\", \"Starting Requisition #\"),\ \ param(\"endReq\",\"\", \"Ending Requisition #\")\nreq.type.oneOf ([param(\"\ type\",'',\"Type(s)\")])\nreq.vendor.number.oneOf ([param(\"number\",'',\"Vendor(s)\"\ )])\naccount.fullAccountCode.oneOf ([param(\"fullAccountCode\",'',\"Full Account\ \ Code(s)\")])\naccount.filter.eq param(\"Filter Name\",\"\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.requisition.RequisitionCharge" properties: ! - ! description: "Requisition #" type: "java.lang.String" propertyName: "number" propertyPath: "req" entityName: "Requisition" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 14 relativePropertyName: "req.number" dataSourcePath: path: ! [] currentPath: ! - "req" columnOrder: 1 suppressRepeating: true permission: null - ! description: "Workflow Approval Status" type: "org.ssdt_ohio.usas.model.constants.ReqApprovalStatus" propertyName: "workflowApprovalStatus" propertyPath: "req" entityName: "Requisition" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Workflow Approval Status" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "req.workflowApprovalStatus" dataSourcePath: path: ! [] currentPath: ! - "req" columnOrder: 2 suppressRepeating: false permission: null - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: "req" entityName: "Requisition" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "req.date" dataSourcePath: path: ! [] currentPath: ! - "req" columnOrder: 3 suppressRepeating: false permission: null - ! description: "Vendor #" type: "java.lang.Integer" propertyName: "number" propertyPath: "req.vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "req.vendor.number" dataSourcePath: path: ! [] currentPath: ! - "req" - "vendor" columnOrder: 4 suppressRepeating: false permission: null - ! description: "Primary Name" type: "java.lang.String" propertyName: "primaryName" propertyPath: "req.vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "req.vendor.primaryName" dataSourcePath: path: ! [] currentPath: ! - "req" - "vendor" columnOrder: 5 suppressRepeating: false permission: null - ! description: "PO #" type: "java.lang.Integer" propertyName: "number" propertyPath: "req.po" entityName: "PurchaseOrder" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "req.po.number" dataSourcePath: path: ! [] currentPath: ! - "req" - "po" columnOrder: 6 suppressRepeating: false permission: null - ! description: "Item Number" type: "java.lang.Integer" propertyName: "itemNumber" propertyPath: null entityName: "RequisitionCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "itemNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false permission: null - ! description: "Quantity" type: "java.math.BigDecimal" propertyName: "quantity" propertyPath: null entityName: "RequisitionCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "quantity" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false permission: null - ! description: "Unit Price" type: "java.math.BigDecimal" propertyName: "unitPrice" propertyPath: null entityName: "RequisitionCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "unitPrice" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false permission: null - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: "item" entityName: "RequisitionItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 25 relativePropertyName: "item.description" dataSourcePath: path: ! [] currentPath: ! - "item" columnOrder: 10 suppressRepeating: false permission: null - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "RequisitionCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 11 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: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "account.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 12 suppressRepeating: false permission: null - ! propertyName: "createdUser" reportableProperty: ! description: "Created User" type: "org.ssdt_ohio.model.entities.BaseUser" propertyName: "customFields.createdUser.value" propertyPath: "req" entityName: "Requisition" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "req.customFields.createdUser.value" dataSourcePath: path: ! [] currentPath: ! - "req" columnOrder: 0 suppressRepeating: false permission: null columnOrder: 13 columnTitle: null suppressRepeating: false controlBreak: false pageBreak: false baseClassProperty: false alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false function: null ascending: true sortOrder: 0 suppressed: false entityName: "Requisition" format: null width: 0 description: "Created User" name: "req.customFields.createdUser.value" type: "org.ssdt_ohio.model.entities.BaseUser" permission: null - ! propertyName: "type" reportableProperty: ! description: "Type" type: "java.lang.String" propertyName: "customFields.type.value" propertyPath: "req" entityName: "Requisition" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "req.customFields.type.value" dataSourcePath: path: ! [] currentPath: ! - "req" columnOrder: 0 suppressRepeating: false permission: null columnOrder: 14 columnTitle: null suppressRepeating: false controlBreak: false pageBreak: false baseClassProperty: false alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false function: null ascending: true sortOrder: 0 suppressed: false entityName: "Requisition" format: null width: 0 description: "Type" name: "req.customFields.type.value" type: "java.lang.String" permission: null - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "account.code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Fund" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.fund" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 15 suppressRepeating: false permission: null - ! description: "Func" type: "java.lang.String" propertyName: "func" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Func" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.func" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 16 suppressRepeating: false permission: null - ! description: "Function One Digit Level" type: "java.lang.String" propertyName: "functionOneDigitLevel" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Function One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.functionOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 17 suppressRepeating: false permission: null - ! description: "Function Two Digit Level" type: "java.lang.String" propertyName: "functionTwoDigitLevel" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Function Two Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.functionTwoDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 18 suppressRepeating: false permission: null - ! description: "Object" type: "java.lang.String" propertyName: "object" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Object" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.object" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 19 suppressRepeating: false permission: null - ! description: "Object One Digit Level" type: "java.lang.String" propertyName: "objectOneDigitLevel" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Object One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.objectOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 20 suppressRepeating: false permission: null - ! description: "SCC" type: "java.lang.String" propertyName: "scc" propertyPath: "account.code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "SCC" columnTitle: "SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.scc" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 21 suppressRepeating: false permission: null - ! description: "Subject" type: "java.lang.String" propertyName: "subject" propertyPath: "account.code" entityName: "GeneralLedgerCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Subject" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.subject" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 22 suppressRepeating: false permission: null - ! description: "Subject Two Digit Level" type: "java.lang.String" propertyName: "subjectTwoDigitLevel" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Subject Two Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.subjectTwoDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 23 suppressRepeating: false permission: null - ! description: "OPU" type: "java.lang.String" propertyName: "opu" propertyPath: "account.code" entityName: "GeneralLedgerCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "OPU" columnTitle: "OPU" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.opu" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 24 suppressRepeating: false permission: null - ! description: "Opu One Digit Level" type: "java.lang.String" propertyName: "opuOneDigitLevel" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Opu One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.opuOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 25 suppressRepeating: false permission: null - ! description: "Job" type: "java.lang.String" propertyName: "job" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Job" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.job" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 26 suppressRepeating: false permission: null - ! description: "IL" type: "java.lang.String" propertyName: "il" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "IL" columnTitle: "IL" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.il" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 27 suppressRepeating: false permission: null