qr8r/contracts.md

Last active May 9, 2019 20:00

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/qr8r/0382fb8caa8d88242b9f01b8c753317e.js"></script>
Save qr8r/0382fb8caa8d88242b9f01b8c753317e to your computer and use it in GitHub Desktop.

Download ZIP

Some edge case examples for the contract id backfill

Raw

contracts.md

Example of Shop with Demo contracts

payable - 666080606 contract ids - 2352807,6900673,6900772

Example of shop with backdated contracts

payable id - 231508108 contract ids - 2046825,2046827,1886964,1883304,1824774,2042013

Example a new contract was signed after the initial term without terminating the initial deal:

payable_id - 379857097 contract ids - 2551385,2983775

Why are > 150k subs fees filtered out?

159172 subs fees appear on invoices with plus subscriptions They are not joined to a specific contract with the join query.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment