Courtesy of Dan Dawson, attached is a useful flow chart when understanding how SQL manages payment/invoice data in the database.