TP-20240927-importfixes #115
No reviewers
Labels
No Label
No Milestone
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: hostsharing/hs.hsadmin.ng#115
Loading…
Reference in New Issue
Block a user
No description provided.
Delete Branch "TP-20240927-importfixes"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
c30fe63d7f
to5f6e4da28d
781529bf29
to4d7b6ca8ab
TP-20240927-importfixesto WIP: TP-20240927-importfixesWIP: TP-20240927-importfixesto TP-20240927-importfixes@ -0,0 +3,4 @@
-- ============================================================================
--changeset timotheus.pokorra:hs-global-integration-kimai endDelimiter:--//
CREATE OR REPLACE VIEW hs_integration.time_customer AS
SELECT p.partnernumber, debitor.defaultprefix
-- TODO.impl: amend to debititorNumber and do not filter anymore to '00'
@ -0,0 +34,4 @@
AND dRel.anchorUuid = pRel.holderUuid
JOIN hs_office.debitor AS debitor
ON debitor.debitorreluuid = dRel.uuid
AND debitor.debitornumbersuffix = '00'
-- TODO.impl: show all debitors to Znuny
TP-20240927-importfixesto WIP: TP-20240927-importfixesbc3636bcd3
toba3a5f8098
WIP: TP-20240927-importfixesto TP-20240927-importfixes