Controller for OnBase Cloud Integration
| Name | Summary |
|---|---|
| GetHREmpmstr | This service returns employee master records restricted to 8 fields required for OnBase document indexing: Id, Name, HrStatus, Stat, PhoneCd, PhoneCd2, PhoneNo, PhoneNo2. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). |
| GetHREmpPay | This service returns employee payroll records for OnBase: Id, Pcn, Position, UniqueId, CalcBeg, CalcEnd. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). |
| GetHRPcntble | This service returns position control table records for OnBase: Pcn, Position, LongDesc. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). |
| GetHREarndist | This service returns earnings distribution records for OnBase: GlKey, UniqueId. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). |
| GetGLKKeyMaster | This service returns GL key master records for OnBase: GlkKey, GlkGr, GlkGrpPart03, GlkStat, GlkTitleDl. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). |
| GetPENameMaster | This service returns person/vendor name master records for OnBase: PeId, PeName. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). Recommended for this large table (~121k rows). |
| GetPOPPVDetail | This service returns PO/PV detail records for OnBase: PopPrNo, PopPeId. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). Recommended for this large table (~28k rows). |
| GetOHDtl | This service returns AP voucher/open hold detail records for OnBase: OhPrNo, OhRef, OhStatus, OhCheckNo, OhCkDt, OhRefDt, OhGlKey, OhJlKey, OhJlObj, OhChargeAmt, OhDiscAmt, OhDistAmt, OhDutyAmt, OhTaxAmt, OhTaxAmt2, OhPrItem, OhMisc. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). Recommended for this large table (~22k rows). |
| GetAPInvoiceDataFill | This service returns AP invoice data fill records for OnBase: OhMisc, Status, OhPrItem, OhGlKey, OhGlObj, OhJlKey, OhJlObj, OhCheckNo, OhCkDt, OhAmt, OhRef, OhRefDt. |
| GetIDNameDeptPosGLKey | This service returns employee ID, name, department, position, and GL key records for OnBase: Name, Dept, LongDesc, GlKey. |
| GetIDforAcctTravelAuth | This service returns employee ID records for accounting travel authorization for OnBase: Name, Dept, LongDesc, GlKey, PhoneCd, PhoneCd2, PhoneNo, PhoneNo2. |
| GetJLKeyDesc | This service returns JL key description records for OnBase: GlkKey, GlkTitleDl. |
| GetPONumberVendor | This service returns PO number and vendor records for OnBase: VendorNum, VendorName. |
| GetPOUsedAmount | This service returns PO used amount records for OnBase: POSpent. |